Despegar.com, Corp. (DESP) Simple Excess Return Model

Despegar.com, Corp.

DESP (NYSE)

(%)

Models
Despegar.com, Corp. Simple Excess Return Model

# Render description block
model.render_description({
    "data": r"""
## Simple Excess Return Model

This model is used to estimate the value of companies that have **reached maturity** and earn stable excess returns with little to no chance of high growth.

**Note:** Excess return models are better suited for estimating the fair value of financial companies compared to enterprise valuation models, such as the **Discounted Free Cash Flow Model**.

> See [Valuing Financial Service Firms](https://pages.stern.nyu.edu/~adamodar/pdfiles/papers/finfirm09.pdf){target="_blank"}

### Fair Value Formulas

`Fair Value` = `Book Value of Equity` + `Present Value of Future Excess Returns`

`Present Value of Future Excess Returns` = `Next Year's Excess Return per Share` / (`Discount Rate` - `Growth In Perpetuity`)

> This model was inspired by Prof. Aswath Damodaran's spreadsheet [⬇️eqexret.xls](https://pages.stern.nyu.edu/~adamodar/pc/eqexret.xls)
""",
    "properties": {
        "width": "responsive"
    }
})

# --- Assumptions
assumptions.set({
    "timeseries": "annual",
    "data": {
        "#historicalYears": """
            3
        """,
        "#beta": """
            profile:beta
        """,
        "%riskFreeRate": """
            treasury:year10
        """,
        "%equityRiskPremium": """
            risk:totalEquityRiskPremium
        """,
        "%discountRate": """
            assumption:%riskFreeRate + assumption:#beta * assumption:%equityRiskPremium
        """,
        "%growthInPerpetuity": """
            2.5%
        """,
    },
    "titles": {
        "#historicalYears": "Historical Years",
        "#beta": "Beta",
        "%riskFreeRate": "Risk Free Rate",
        "%equityRiskPremium": "Equity Risk Premium",
        "%discountRate": "Discount Rate",
        "%growthInPerpetuity": "Growth In Perpetuity",
    },
    "properties": {
        "width": "responsive",
        "title": "Assumptions",
        "id": "component-2",
        "bindTo": None
    },
    "descriptions": {
        "#historicalYears": r"""
The number of years of historical data used to calculate averages and trends for analysis.
        """,
        "#beta": r"""
Beta measures the volatility of a stock's price in relation to the overall stock market. A higher beta indicates greater price fluctuations relative to the market.
        """,
        "%riskFreeRate": r"""
The risk-free rate represents the return an investor expects from an absolutely risk-free investment over a specified time period. By default, it is set to the current yield of the U.S. 10-Year Treasury Bond.
        """,
        "%equityRiskPremium": r"""
The market risk premium is the additional return over the risk-free rate expected by investors for equity risk.
        """,
        "%discountRate": r"""
`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)
        """,
        "%growthInPerpetuity": r"""
The stable rate at which the company's book value is assumed to grow in perpetuity.
        """,
    },
    "hierarchies": [
        {
            "parent": "%discountRate",
            "children": [
                "#beta",
                "%riskFreeRate",
                "%equityRiskPremium",
            ]
        },
    ]
})

# --- Historical Calculations
data.compute({
    "user:dividendsPaidToCommonShareholders": """
        dividend:adjDividend * income:weightedAverageShsOut
    """,
    "user:#bookValue": """
        balance:totalStockholdersEquity / income:weightedAverageShsOut
    """,
    "user:%returnOnEquity": """
        income:netIncome / balance:totalStockholdersEquity:-1
    """,
    "user:%payoutRatio": """
        dividend:adjDividend / income:eps
    """,
    "user:#retainedEarnings": """
        income:eps - dividend:adjDividend
    """,
}, forecast=0, timeseries="annual")

model.render_table({
    "timeseries": "annual",
    "data": {
        "user:dividendsPaidToCommonShareholders": "Common Dividends Paid",
        "user:#bookValue": "Book Value",
        "user:%returnOnEquity": "Return on Equity",
        "user:%payoutRatio": "Payout Ratio",
        "user:#retainedEarnings": "Retained Earnings",
    },
    "start": data.get("""
        -assumption:#historicalYears
    """),
    "end": 0,
    "properties": {
        "title": "Historical Calculations",
        "order": "descending",
        "number_format": "M",
        "include_ltm": True,
        "display_averages": True,
        "width": "responsive"
    }
})

# --- ROE & Payout
assumptions.set({
    "timeseries": "annual",
    "data": {
        "%returnOnEquity": """
            function:average(start=-assumption:#historicalYears, end=0):user:%returnOnEquity
            or if this >= 100%:
            100%
        """,
        "%stablePayoutRatio": """
            1 - assumption:%growthInPerpetuity / assumption:%returnOnEquity
        """,
    },
    "titles": {
        "%returnOnEquity": "Return on Equity",
        "%stablePayoutRatio": "Stable Payout Ratio",
    },
    "properties": {
        "width": "responsive",
        "title": "ROE & Payout",
        "id": "component-4",
        "bindTo": "component-2"
    },
    "descriptions": {
        "%returnOnEquity": r"""
Return On Equity (ROE) is used to estimate the Earnings Per Share (EPS) expressed as a percentage of Book Value.
        """,
        "%stablePayoutRatio": r"""
The stable payout ratio estimates what the company can afford to pay out in dividends.

`Stable Payout Ratio` = 1 - `Growth in Perpetuity` / `Return on Equity`
        """,
    }
})

# --- Forecast Calculations
data.compute({
    "income:eps": """
        user:#bookValue:-1 * assumption:%returnOnEquity
    """,
    "dividend:adjDividend": """
        income:eps * assumption:%stablePayoutRatio
    """,
    "user:#retainedEarnings": """
        income:eps - dividend:adjDividend
    """,
    "user:#bookValue": """
        user:#bookValue:-1 + user:#retainedEarnings
    """,
    "user:#equityCostPerShare": """
        user:#bookValue:-1 * assumption:%discountRate
    """,
    "user:#excessReturn": """
        income:eps - user:#equityCostPerShare
    """,
    "user:%returnOnEquity": """
        income:eps / user:#bookValue:-1
    """,
}, forecast=5, timeseries="annual")

# --- Fair Value Calculation
data.compute_results({
    "#terminalValue": """
        user:#excessReturn:1 / (assumption:%discountRate - assumption:%growthInPerpetuity)
    """,
    "#fairValue": """
        result:#terminalValue + user:#bookValue
    """,
}, timeseries="annual")

model.render_results({
    "timeseries": "annual",
    "data": {
        "user:#excessReturn:1": {
            "label": "Next Year's Excess Return per Share",
            "type": "$"
        },
        "assumption:%discountRate": {
            "label": "Discount Rate",
            "type": "%"
        },
        "assumption:%growthInPerpetuity": {
            "label": "Growth In Perpetuity",
            "type": "%"
        },
        "user:#bookValue": {
            "label": "Book Value of Equity",
            "type": "$"
        },
        "result:#terminalValue": {
            "label": "+ Present Value of Future Excess Returns",
            "type": "$"
        },
        "result:#fairValue": {
            "label": "= Fair Value",
            "type": "$"
        },
    },
    "properties": {
        "title": "Fair Value Calculation",
        "width": "responsive",
        "hidden_keys": []
    }
})

# --- Fair Value
model.set_final_value({
    "value": data.get("""
        result:#fairValue
    """, timeseries="annual"),
    "units": "$",
    "title": "Fair Value",
    "properties": {
        "width": "full" 
    }
})

model.render_chart({
    "timeseries": "annual",
    "data": {
        "income:eps": "Eps",
        "user:#equityCostPerShare": "Equity Cost per Share",
        "user:#excessReturn": "Excess Return",
    },
    "start": -10,
    "end": 5,
    "properties": {
        "title": "Preview Excess Returns",
        "include_ltm": False,
        "set_editable": [],
        "hidden_keys": [],
        "bar_keys": [],
        "width": "full"
    }
})

# Render description block
model.render_description({
    "data": r"""
## Understanding the Calculations

Excess Return represents the additional earnings the company generates over the cost of equity. It is calculated as:

`Excess Return` = `Earnings per Share (EPS)` - `Equity Cost per Share`

We forecast EPS figures based on our assumed return on equity and the beginning book value per share, which is the equity per share at the start of the fiscal year.

`Earnings per Share (EPS)` = `Beginning Book Value` * `Return on Equity`

Equity Cost per Share is the expected return required by equity investors.

`Equity Cost per Share` = `Beginning Book Value` * `Cost of Equity`

Ending Book Value reflects the updated value of equity after accounting for retained earnings during the period:

`Ending Book Value` = `Beginning Book Value` + `Retained Earnings`

Retained Earnings is the portion of earnings not paid out as dividends and reinvested in the company. It is calculated as:

`Retained Earnings` = `Earnings per Share (EPS)` - `Dividend per Share`

Dividends are determined using the payout ratio, which represents the portion of earnings paid out.

`Dividend per Share` = `Earnings per Share (EPS)` * `Payout Ratio`
""",
    "properties": {
        "width": "responsive"
    }
})

# --- Preview Calculations
data.compute({
    "user:%payoutRatio": """
        assumption:%stablePayoutRatio
    """,
}, forecast=5, timeseries="annual")

model.render_table({
    "timeseries": "annual",
    "data": {
        "user:#bookValue:-1": "Beginning Book Value",
        "user:#bookValue": "Ending Book Value",
        "user:%returnOnEquity": "Return on Equity",
        "income:eps": "Earnings per Share (EPS)",
        "user:%payoutRatio": "Payout Ratio",
        "dividend:adjDividend": "Dividend per Share",
        "user:#retainedEarnings": "Retained Earnings",
        "assumption:%discountRate": "Cost of Equity (Discount Rate)",
        "user:#equityCostPerShare": "Equity Cost per Share",
        "user:#excessReturn": "Excess Return",
    },
    "start": 1,
    "end": 5,
    "properties": {
        "title": "Preview Calculations",
        "order": "ascending",
        "number_format": "M",
        "include_ltm": True,
        "display_averages": False,
        "width": "responsive"
    }
})

Fair Value

USD

Market Price USD

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

Simple Excess Return Model

This model is used to estimate the value of companies that have reached maturity and earn stable excess returns with little to no chance of high growth.

Note: Excess return models are better suited for estimating the fair value of financial companies compared to enterprise valuation models, such as the Discounted Free Cash Flow Model.

See Valuing Financial Service Firms

Fair Value Formulas

Fair Value = Book Value of Equity + Present Value of Future Excess Returns

Present Value of Future Excess Returns = Next Year's Excess Return per Share / (Discount Rate - Growth In Perpetuity)

This model was inspired by Prof. Aswath Damodaran's spreadsheet ⬇️eqexret.xls

Assumptions

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 measures the volatility of a stock's price in relation to the overall stock market. A higher beta indicates greater price fluctuations relative to the market.	#
↳ Risk Free Rate Risk Free Rate The risk-free rate represents the return an investor expects from an absolutely risk-free investment over a specified time period. By default, it is set to the current yield of the U.S. 10-Year Treasury Bond.	%
↳ Equity Risk Premium Equity Risk Premium The market risk premium is the additional return over the risk-free rate expected by investors for equity risk.	%
Historical Years Historical Years The number of years of historical data used to calculate averages and trends for analysis.	#
Growth In Perpetuity Growth In Perpetuity The stable rate at which the company's book value is assumed to grow in perpetuity.	%
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.	%
Stable Payout Ratio Stable Payout Ratio The stable payout ratio estimates what the company can afford to pay out in dividends. `Stable Payout Ratio` = 1 - `Growth in Perpetuity` / `Return on Equity`	%

Historical Calculations

Monetary values in USD amounts except #	Average	LTM Mar 08	2024 Dec 31	2023 Dec 31	2022 Dec 31
Common Dividends Paid
Book Value	-0.956	-1.14	-1.14	0.116	-1.66
Return on Equity	123.8%	-29.56%	311.6%	-19.26%	232.5%
Payout Ratio
Retained Earnings

Fair Value Calculation
Next Year's Excess Return per Share	-1.01 USD
Discount Rate	11.36%
Growth In Perpetuity	2.5%
Book Value of Equity	-1.14 USD
+ Present Value of Future Excess Returns	-11.37 USD
= Fair Value	-12.5 USD

Preview Excess Returns

Monetary values in USD

{"sectionId": "section-chart-1", "sectionType": "chart", "title": "Preview Excess Returns", "timeseries": "annual", "series": [{"label": "Eps", "mappingKey": "income:eps", "data": [{"l": "2015", "x": "2015-12-31", "y": -1.27}, {"l": "2016", "x": "2016-12-31", "y": 0.26}, {"l": "2017", "x": "2017-12-31", "y": 0.69}, {"l": "2018", "x": "2018-12-31", "y": 0.28}, {"l": "2019", "x": "2019-12-31", "y": -0.3}, {"l": "2020", "x": "2020-12-31", "y": -1.93}, {"l": "2021", "x": "2021-12-31", "y": -1.27}, {"l": "2022", "x": "2022-12-31", "y": -0.89}, {"l": "2023", "x": "2023-12-31", "y": 0.32}, {"l": "2024", "x": "2024-12-31", "y": 0.34}, {"l": "2025", "x": "2025-12-31", "y": -1.14}, {"l": "2026", "x": "2026-12-31", "y": -1.16}, {"l": "2027", "x": "2027-12-31", "y": -1.19}, {"l": "2028", "x": "2028-12-31", "y": -1.22}, {"l": "2029", "x": "2029-12-31", "y": -1.25}], "dataType": "#", "displayAs": "line", "dataTimeseries": "annual", "hidden": false}, {"label": "Equity Cost per Share", "mappingKey": "user:#equityCostPerShare", "data": [{"l": "2016", "x": "2016-12-31", "y": -0.141}, {"l": "2017", "x": "2017-12-31", "y": -0.139}, {"l": "2018", "x": "2018-12-31", "y": 0.403}, {"l": "2019", "x": "2019-12-31", "y": 0.407}, {"l": "2020", "x": "2020-12-31", "y": 0.318}, {"l": "2021", "x": "2021-12-31", "y": 0.145}, {"l": "2022", "x": "2022-12-31", "y": -0.041}, {"l": "2023", "x": "2023-12-31", "y": -0.188}, {"l": "2024", "x": "2024-12-31", "y": 0.013}, {"l": "2025", "x": "2025-12-31", "y": -0.129}, {"l": "2026", "x": "2026-12-31", "y": -0.132}, {"l": "2027", "x": "2027-12-31", "y": -0.136}, {"l": "2028", "x": "2028-12-31", "y": -0.139}, {"l": "2029", "x": "2029-12-31", "y": -0.143}], "dataType": "#", "displayAs": "line", "dataTimeseries": "annual", "hidden": false}, {"label": "Excess Return", "mappingKey": "user:#excessReturn", "data": [{"l": "2016", "x": "2016-12-31", "y": 0.401}, {"l": "2017", "x": "2017-12-31", "y": 0.829}, {"l": "2018", "x": "2018-12-31", "y": -0.123}, {"l": "2019", "x": "2019-12-31", "y": -0.707}, {"l": "2020", "x": "2020-12-31", "y": -2.25}, {"l": "2021", "x": "2021-12-31", "y": -1.41}, {"l": "2022", "x": "2022-12-31", "y": -0.849}, {"l": "2023", "x": "2023-12-31", "y": 0.508}, {"l": "2024", "x": "2024-12-31", "y": 0.327}, {"l": "2025", "x": "2025-12-31", "y": -1.01}, {"l": "2026", "x": "2026-12-31", "y": -1.03}, {"l": "2027", "x": "2027-12-31", "y": -1.06}, {"l": "2028", "x": "2028-12-31", "y": -1.08}, {"l": "2029", "x": "2029-12-31", "y": -1.11}], "dataType": "#", "displayAs": "line", "dataTimeseries": "annual", "hidden": false}], "editableDates": {}, "properties": {"display_table": false}, "width": "full"}

Understanding the Calculations

Excess Return represents the additional earnings the company generates over the cost of equity. It is calculated as:

Excess Return = Earnings per Share (EPS) - Equity Cost per Share

We forecast EPS figures based on our assumed return on equity and the beginning book value per share, which is the equity per share at the start of the fiscal year.

Earnings per Share (EPS) = Beginning Book Value * Return on Equity

Equity Cost per Share is the expected return required by equity investors.

Equity Cost per Share = Beginning Book Value * Cost of Equity

Ending Book Value reflects the updated value of equity after accounting for retained earnings during the period:

Ending Book Value = Beginning Book Value + Retained Earnings

Retained Earnings is the portion of earnings not paid out as dividends and reinvested in the company. It is calculated as:

Retained Earnings = Earnings per Share (EPS) - Dividend per Share

Dividends are determined using the payout ratio, which represents the portion of earnings paid out.

Dividend per Share = Earnings per Share (EPS) * Payout Ratio

Preview Calculations

Monetary values in USD amounts except #	2025 Dec 31	2026 Dec 31	2027 Dec 31	2028 Dec 31	2029 Dec 31
Beginning Book Value	-1.14	-1.16	-1.19	-1.22	-1.25
Ending Book Value	-1.16	-1.19	-1.22	-1.25	-1.29
Return on Equity	100%	100%	100%	100%	100%
Earnings per Share (EPS)	-1.14	-1.16	-1.19	-1.22	-1.25
Payout Ratio	97.5%	97.5%	97.5%	97.5%	97.5%
Dividend per Share	-1.11	-1.14	-1.16	-1.19	-1.22
Retained Earnings	-0.028	-0.029	-0.03	-0.031	-0.031
Cost of Equity (Discount Rate)	11.36%	11.36%	11.36%	11.36%	11.36%
Equity Cost per Share	-0.129	-0.132	-0.136	-0.139	-0.143
Excess Return	-1.01	-1.03	-1.06	-1.08	-1.11

Fair Value

USD

Market Price USD