QuantaSing Group Ltd (QSG) Simple Excess Return Model

QuantaSing Group Ltd

QSG (NASDAQ)

(%)

Valuation
QuantaSing Group Ltd Simple Excess Return Model

"""
    Model: Simple Excess Return Model

# Render model description
model.render_description(r"""
## Simple Excess Return Model

Used to estimate the value of companies that have reached maturity and earn stable excess returns with little to no high growth chance. Excess Return models are better suited to calculate the intrinsic value of a financial company than an enterprise valuation model (such as the Discounted Free Cash Flow Model).

See our [GitHub Documentation](https://github.com/DiscountingCashFlows/Documentation/blob/main/models-documentation/excess-return-models.md#simple-excess-return-model-source-code)
""")

# Initialize assumptions
assumptions.init({
    "data": {
        "%discount_rate": None,
        "%return_on_equity": None,
        "%growth_in_perpetuity": "2.5%",
        "%risk_free_rate": data.get("treasury:year10"),
        "%market_premium":data.get("risk:totalEquityRiskPremium"),
        "beta": data.get("profile:beta", default=1),
        "historical_years": 10,
    },
    "hierarchies": [{
        "parent": "%discount_rate",
        "children": ["beta", "%risk_free_rate", "%market_premium"]
    }]
})

# Set the discount rate to the cost of equity
risk_free_rate = assumptions.get("%risk_free_rate")
beta = assumptions.get("beta")
market_premium = assumptions.get("%market_premium")
cost_of_equity = risk_free_rate + beta * market_premium

assumptions.set("%discount_rate", cost_of_equity)

# Compute historical data
data.compute({
    "dividendsPaidToCommon": "dividend:adjDividend * income:weightedAverageShsOut",
    "#bookValue": "balance:totalStockholdersEquity / income:weightedAverageShsOut",
    "%returnOnEquity": "income:netIncome / balance:totalStockholdersEquity:-1",
    "%payoutRatio": "dividend:adjDividend / income:eps",
    "#retainedEarnings": "income:eps - dividend:adjDividend",
})

# Calculate the average return on equity over the historical years
average_return_on_equity = data.average(f"%returnOnEquity:{-assumptions.get('historical_years')}->0")

assumptions.set("%return_on_equity", average_return_on_equity)
assumptions.set_bounds(
    "%return_on_equity", low="0%", high="100%"
)

# Calculate stable payout ratio
stable_payout_ratio = 1 - (assumptions.get("%growth_in_perpetuity") / assumptions.get("%return_on_equity"))

# Compute 5 years of forecasted values and ratios
data.compute({
    "income:eps": f"#bookValue:-1 * {assumptions.get('%return_on_equity')}",
    "dividend:adjDividend": f"income:eps * {stable_payout_ratio}",
    "#retainedEarnings": "income:eps - dividend:adjDividend",
    "#bookValue": "#bookValue:-1 + #retainedEarnings",
    "%returnOnEquity": "income:eps / #bookValue:-1",
    "#equityCostPerShare": f"#bookValue:-1 * {assumptions.get('%discount_rate')}",
    "#excessReturn": "income:eps - #equityCostPerShare",
    "%costOfEquity": assumptions.get("%discount_rate"),
    "#beginningBookValue": "#bookValue:-1",
}, forecast=5)

book_value = data.get("#bookValue")
excess_returns = data.get("#excessReturn:1")
if excess_returns and excess_returns <= 0:
    model.warn("Warning: Excess return is negative. Either EPS is negative or the Cost of Equity (Discount Rate) is higher than the Return on Equity.")

# Calculate the terminal value
terminal_value = excess_returns / (assumptions.get("%discount_rate") - assumptions.get("%growth_in_perpetuity"))

# Calculate value per share
stock_value = terminal_value + book_value

model.set_final_value({
    "value": stock_value,
    "units": '$'
})

model.render_results([
    [stock_value, 'Estimated Value', '$'],
    [book_value, "Book value of equity invested", '$'],
    [data.get('#bookValue:1'), "Next year's estimated book value", '$'],
    [terminal_value, "Present value of future excess returns", '$'],
    [excess_returns, "Excess Return per share", '$'],
    [assumptions.get("%discount_rate"), "Cost of Equity (the discount rate)", '%'],
    [average_return_on_equity, "Average historical Return on Equity", '%'],
    [data.average(f"%payoutRatio:{-assumptions.get('historical_years')}->0"), "Average historical Payout Ratio", '%'],
    [stable_payout_ratio, "Payout Ratio used", '%'],
    [data.get("treasury:year10"), 'Risk Free Rate of the 10 Year U.S. Treasury Note', '%']
])

# Render a chart for historical and forecasted data
model.render_chart({
    "data": {
        "income:eps": "Earnings Per Share",
        "#bookValue": "Book Value Per Share",
        "dividend:adjDividend": "Dividend",
        "#retainedEarnings": "Retained Earnings"
    },
    "start": -assumptions.get("historical_years"),
    "end": "*",
    "properties": {
        "title": "Historical and Forecasted Data",
        "hidden_keys": ["#retainedEarnings"]
    }
})

# Projections Table
model.render_table({
    "data": {
        "#beginningBookValue": "Beginning Book Value",
        "#bookValue": "Ending Book Value",
        "income:eps": "EPS",
        "%returnOnEquity": "Return on Equity",
        "dividend:adjDividend": "Dividend per Share",
        "#retainedEarnings": "Retained Earnings",
        "#equityCostPerShare": "Equity Cost per Share",
        "%costOfEquity": "Cost of Equity",
        "#excessReturn": "Excess Return"
    },
    "start": -1,
    "end": "*",
    "properties": {
        "title": "Projected Data",
        "order": "ascending",
    }
})

# Historical Table
model.render_table({
    "data": {
        "income:netIncome": "Net Income",
        "balance:totalStockholdersEquity": "Total Equity",
        "%returnOnEquity": "Return on Equity",
        "dividendsPaidToCommon": "Dividends Paid to Common Shareholders",
        "%payoutRatio": "Payout Ratio",
        "income:weightedAverageShsOut": "Shares Outstanding",
        "income:eps": "EPS",
        "dividend:adjDividend": "Dividend per Share",
        "#bookValue": "Book Value"
    },
    "start": -assumptions.get('historical_years'),
    "end": 0,
    "properties": {
        "title": "Historical data",
        "number_format": "M",
        "display_averages": True
    }
})

assumptions.set_description({
    "%discount_rate": r"""
        ## Discount Rate

`Discount Rate` = `Cost of Equity` = `Risk Free Rate` + `Beta` * `Market Premium`

The cost of equity is the theoretical rate of return that an equity investment should generate. It is calculated using the CAPM formula.

[Read More](https://www.investopedia.com/terms/c/costofequity.asp#mntl-sc-block_1-0-20)
    """,

"historical_years": r"""
        ## Historical Years

The number of historical years used to calculate averages for historical data.
    """,

"%risk_free_rate": r"""
        ## Risk-Free Rate

The risk-free rate represents the interest an investor would expect from an absolutely risk-free investment over a specified period of time.
        By default, it is equal to the current yield of the U.S. 10 Year Treasury Bond.
    """,

"%market_premium": r"""
        ## Market Premium

Market risk premium represents the excess returns over the risk-free rate that investors expect for taking on the incremental risks connected to the equities market.
    """,

"beta": r"""
        ## Beta

Beta is a value that measures the price fluctuations (volatility) of a stock with respect to fluctuations in the overall stock market.
    """,

"%growth_in_perpetuity": r"""
        ## Growth in Perpetuity

The rate at which the company's free cash flow is assumed to grow in perpetuity. By default, this is equal to the yield of the U.S. 10 Year Treasury Bond.
    """,

"%return_on_equity": r"""
        ## Return on Equity

Return On Equity (ROE) is used to estimate the Earnings Per Share (EPS) expressed as a percentage of Book Value.
    """
})

print(f"End of model.")

Estimated Value

USD

Market Price USD

* Values are not guaranteed, please do your own
research before making investment decisions.

Simple Excess Return Model

See our GitHub Documentation

Interactive Assumptions

Discount Rate Discount Rate Discount Rate `Discount Rate` = `Cost of Equity` = `Risk Free Rate` + `Beta` * `Market Premium` The cost of equity is the theoretical rate of return that an equity investment should generate. It is calculated using the CAPM formula. Read More	%
↳ Beta Beta Beta Beta is a value that measures the price fluctuations (volatility) of a stock with respect to fluctuations in the overall stock market.	#
↳ Risk Free Rate Risk Free Rate Risk-Free Rate The risk-free rate represents the interest an investor would expect from an absolutely risk-free investment over a specified period of time. By default, it is equal to the current yield of the U.S. 10 Year Treasury Bond.	%
↳ Market Premium Market Premium Market Premium Market risk premium represents the excess returns over the risk-free rate that investors expect for taking on the incremental risks connected to the equities market.	%
Return On Equity Return On Equity Return on Equity Return On Equity (ROE) is used to estimate the Earnings Per Share (EPS) expressed as a percentage of Book Value.	%
Growth In Perpetuity Growth In Perpetuity Growth in Perpetuity The rate at which the company's free cash flow is assumed to grow in perpetuity. By default, this is equal to the yield of the U.S. 10 Year Treasury Bond.	%
Historical Years Historical Years Historical Years The number of historical years used to calculate averages for historical data.	#

Results
Estimated Value	-46.28 USD
Book value of equity invested	1.8 USD
Next year's estimated book value	1.32 USD
Present value of future excess returns	-48.08 USD
Excess Return per share	1.15 USD
Cost of Equity (the discount rate)	0.109%
Average historical Return on Equity	89.07%
Average historical Payout Ratio	18.78%
Payout Ratio used	97.19%
Risk Free Rate of the 10 Year U.S. Treasury Note	4.15%

Historical and Forecasted Data

Monetary values in USD

{"sectionId": "section-chart-1", "sectionType": "chart", "title": "Historical and Forecasted Data", "timeseries": "annual", "series": [{"label": "Earnings Per Share", "mappingKey": "income:eps", "data": [{"l": "2021", "x": "2021-06-30", "y": -1.49}, {"l": "2022", "x": "2022-06-30", "y": -0.703}, {"l": "2023", "x": "2023-06-30", "y": -0.521}, {"l": "2024", "x": "2024-06-30", "y": 0.966}, {"l": "2025", "x": "2025-06-30", "y": 1.15}, {"l": "2026", "x": "2026-06-30", "y": 1.18}, {"l": "2027", "x": "2027-06-30", "y": 1.21}, {"l": "2028", "x": "2028-06-30", "y": 1.24}, {"l": "2029", "x": "2029-06-30", "y": 1.27}], "dataType": "#", "displayAs": "line", "dataTimeseries": "annual", "hidden": false}, {"label": "Book Value Per Share", "mappingKey": "#bookValue", "data": [{"l": "2021", "x": "2021-06-30", "y": -0.786}, {"l": "2022", "x": "2022-06-30", "y": -2.14}, {"l": "2023", "x": "2023-06-30", "y": 0.89}, {"l": "2024", "x": "2024-06-30", "y": 1.29}, {"l": "2025", "x": "2025-06-30", "y": 1.32}, {"l": "2026", "x": "2026-06-30", "y": 1.36}, {"l": "2027", "x": "2027-06-30", "y": 1.39}, {"l": "2028", "x": "2028-06-30", "y": 1.43}, {"l": "2029", "x": "2029-06-30", "y": 1.46}], "dataType": "#", "displayAs": "line", "dataTimeseries": "annual", "hidden": false}, {"label": "Dividend", "mappingKey": "dividend:adjDividend", "data": [{"l": "2024", "x": "2024-06-30", "y": 0.201}, {"l": "2025", "x": "2025-06-30", "y": 1.12}, {"l": "2026", "x": "2026-06-30", "y": 1.15}, {"l": "2027", "x": "2027-06-30", "y": 1.18}, {"l": "2028", "x": "2028-06-30", "y": 1.2}, {"l": "2029", "x": "2029-06-30", "y": 1.23}], "dataType": "#", "displayAs": "line", "dataTimeseries": "annual", "hidden": false}, {"label": "Retained Earnings", "mappingKey": "#retainedEarnings", "data": [{"l": "2024", "x": "2024-06-30", "y": 0.765}, {"l": "2025", "x": "2025-06-30", "y": 0.032}, {"l": "2026", "x": "2026-06-30", "y": 0.033}, {"l": "2027", "x": "2027-06-30", "y": 0.034}, {"l": "2028", "x": "2028-06-30", "y": 0.035}, {"l": "2029", "x": "2029-06-30", "y": 0.036}], "dataType": "#", "displayAs": "line", "dataTimeseries": "annual", "hidden": true}], "editableDates": {}, "properties": {"display_table": false}, "width": "full"}

Projected Data

Monetary values in USD amounts except #	2024 Jun 30	LTM Mar 11	2025 Jun 30	2026 Jun 30	2027 Jun 30	2028 Jun 30	2029 Jun 30
Beginning Book Value	0.89	1.29	1.29	1.32	1.36	1.39	1.43
Ending Book Value	1.29	1.8	1.32	1.36	1.39	1.43	1.46
EPS	0.966	1.2	1.15	1.18	1.21	1.24	1.27
Return on Equity	172%	91.06%	89.07%	89.07%	89.07%	89.07%	89.07%
Dividend per Share	0.201	0.201	1.12	1.15	1.18	1.2	1.23
Retained Earnings	0.765	0.999	0.032	0.033	0.034	0.035	0.036
Equity Cost per Share	0.001	0.001	0.001	0.001	0.001	0.002	0.002
Cost of Equity	0.109%	0.109%	0.109%	0.109%	0.109%	0.109%	0.109%
Excess Return	0.965	1.2	1.15	1.18	1.21	1.24	1.27

Historical data

Monetary values in USD amounts except #	Average	LTM Mar 11	2024 Jun 30	2023 Jun 30	2022 Jun 30	2021 Jun 30
Net Income	3.81	64.72	53.05	-14.96	-34.83	-48.93
Total Equity	7.75	97.91	71.07	30.84	-117.8	-43.28
Return on Equity	89.06%	91.06%	172%	12.7%	80.49%
Dividends Paid to Common Shareholders	10.98	10.91	11.05
Payout Ratio	18.78%	16.75%	20.81%
Shares Outstanding	50.81	54.26	55	34.65	55.08	55.08
EPS	-0.11	1.2	0.966	-0.521	-0.703	-1.49
Dividend per Share	0.201	0.201	0.201
Book Value	0.211	1.8	1.29	0.89	-2.14	-0.786

Estimated Value

USD

Market Price USD

Simple Excess Return Model

Interactive Assumptions

Discount Rate

Discount Rate

Beta

Beta

Risk Free Rate

Risk-Free Rate

Market Premium

Market Premium

Return On Equity

Return on Equity

Growth In Perpetuity

Growth in Perpetuity

Historical Years

Historical Years

Results

Historical and Forecasted Data

Projected Data

Historical data

Discounted Cash Flow to Firm - Perpetual Growth

Earnings Power Value

Simple Dividend Discount Model

Simple Excess Return Model

Two-Stage Dividend Discount Model

Two-Stage Excess Return Model

Discounted Cash Flow to Firm - Exit Multiple

Discounted Future Market Cap

Peter Lynch Fair Value

Altman Z-Score

Beneish M-Score

Capital Asset Pricing Model (CAPM)

Margin Analysis

Piotroski F-Score

Return on Invested Capital (ROIC)

Shiller PE (CAPE) Ratio

Weighted Average Cost of Capital (WACC)

Market is Open

After-Hours Quote

Market is Open

After-Hours Quote

QuantaSing Group Ltd Simple Excess Return Model

Estimated Value

USD

Market Price USD

Simple Excess Return Model

Interactive Assumptions

Discount Rate

Discount Rate

Beta

Beta

Risk Free Rate

Risk-Free Rate

Market Premium

Market Premium

Return On Equity

Return on Equity

Growth In Perpetuity

Growth in Perpetuity

Historical Years

Historical Years

Results

Historical and Forecasted Data

Projected Data

Historical data

Discounted Cash Flow to Firm - Perpetual Growth

Earnings Power Value

Simple Dividend Discount Model

Simple Excess Return Model

Two-Stage Dividend Discount Model

Two-Stage Excess Return Model

Discounted Cash Flow to Firm - Exit Multiple

Discounted Future Market Cap

Peter Lynch Fair Value

Altman Z-Score

Beneish M-Score

Capital Asset Pricing Model (CAPM)

Margin Analysis

Piotroski F-Score

Return on Invested Capital (ROIC)

Shiller PE (CAPE) Ratio

Weighted Average Cost of Capital (WACC)