BMO Pyrford Intl Stock Fd - Class A (BPIAX) Simple Dividend Discount Model

BMO Pyrford Intl Stock Fd - Class A

BPIAX (NASDAQ)

(%)

Models
BMO Pyrford Intl Stock Fd - Class A Simple Dividend Discount Model

# Render description block
model.render_description({
    "data": r"""
## Simple Dividend Discount Model

This model estimates the value of companies that have reached maturity and pay stable dividends as a significant percentage of their **free cash flow to equity**, with no share buybacks or high growth expectancy.

### Fair Value Formulas

`Fair Value` = `Next Year's Expected Dividend` / (`
Discount Rate` - `Growth In Perpetuity`)

`Next year's expected dividend` = `Current Dividend per Share` * (1 + `Growth In Perpetuity`)

> This model was inspired by Prof. Aswath Damodaran's spreadsheet [⬇️ddmst.xls](https://pages.stern.nyu.edu/~adamodar/pc/ddmst.xls)

> Learn more: Prof. Aswath Damodaran's [Guide to Dividend Discount Models](https://pages.stern.nyu.edu/~adamodar/pdfiles/valn2ed/ch13.pdf)
""",
    "properties": {
        "width": "responsive"
    }
})

# --- Assumptions
assumptions.set({
    "timeseries": "annual",
    "data": {
        "#historicalYears": """
            3
        """,
        "#forecastYears": """
            5
        """,
        "#beta": """
            profile:beta
        """,
        "%riskFreeRate": """
            treasury:year10
        """,
        "%equityRiskPremium": """
            risk:totalEquityRiskPremium
        """,
        "%discountRate": """
            assumption:%riskFreeRate + assumption:#beta * assumption:%equityRiskPremium
        """,
        "%growthInPerpetuity": """
            2.5%
        """,
        "#expectedDividend": """
            dividend:adjDividend * (1 + assumption:%growthInPerpetuity)
        """,
    },
    "titles": {
        "#historicalYears": "Historical Years",
        "#forecastYears": "Forecast Years",
        "#beta": "Beta",
        "%riskFreeRate": "Risk Free Rate",
        "%equityRiskPremium": "Equity Risk Premium",
        "%discountRate": "Discount Rate",
        "%growthInPerpetuity": "Growth In Perpetuity",
        "#expectedDividend": "Expected Dividend",
    },
    "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.
        """,
        "#forecastYears": r"""
The number of years into the future for which the analysis projects financial performance and metrics.
        """,
        "#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.
        """,
        "#expectedDividend": r"""
The estimated annual dividend per share for the next year.
        """,
    },
    "hierarchies": [
        {
            "parent": "%discountRate",
            "children": [
                "#beta",
                "%riskFreeRate",
                "%equityRiskPremium",
            ]
        },
    ]
})

# --- Fair Value Calculation
data.compute_results({
    "#fairValue": """
        assumption:#expectedDividend / ( assumption:%discountRate - assumption:%growthInPerpetuity)
    """,
}, timeseries="annual")

model.render_results({
    "timeseries": "annual",
    "data": {
        "dividend:adjDividend": {
            "label": "Current dividend per share",
            "type": "$"
        },
        "assumption:%growthInPerpetuity": {
            "label": "Growth In Perpetuity",
            "type": "%"
        },
        "assumption:#expectedDividend": {
            "label": "Next year's expected dividend",
            "type": "$"
        },
        "assumption:%discountRate": {
            "label": "Cost of Equity (Discount Rate)",
            "type": "%"
        },
        "result:#fairValue": {
            "label": "Fair Value",
            "type": "$"
        },
    },
    "properties": {
        "title": "Fair Value Calculation",
        "width": "responsive",
        "hidden_keys": []
    }
})

# --- Forecast Dividends
data.compute({
    "income:eps": """
        income:eps:-1 * (1 + assumption:%growthInPerpetuity)
    """,
    "dividend:adjDividend": """
        dividend:adjDividend:-1 * (1 + assumption:%growthInPerpetuity)
    """,
}, forecast=data.get("""
    assumption:#forecastYears
"""), timeseries="annual")

model.render_chart({
    "timeseries": "annual",
    "data": {
        "income:eps": "Earnings per Share",
        "dividend:adjDividend": "Dividend per Share",
    },
    "start": -5,
    "end": data.get("""
        assumption:#forecastYears
    """),
    "properties": {
        "title": "Forecast Dividends",
        "include_ltm": True,
        "set_editable": [],
        "hidden_keys": [],
        "bar_keys": [],
        "width": "full"
    }
})

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

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

The **Free Cash Flow to Equity** represents the cash available to the common shareholders to be paid out as dividends or used for share buybacks.

`Free Cash Flow to Equity` = `Free Cash Flow to the Firm` + `Net Borrowing`

For the Dividend Discount Model to be appropriate, the FCFE payout ratio should represent a significant portion of FCFE, typically over 50%.

`FCFE Payout Ratio` = `Total Dividends Paid` / `Free Cash Flow to Equity`
""",
    "properties": {
        "width": "responsive"
    }
})

# --- FCFE vs. Dividends
data.compute({
    "user:netBorrowing": """
        balance:totalDebt - balance:totalDebt:-1
    """,
    "user:freeCashFlowToEquity": """
        flow:freeCashFlow + user:netBorrowing
    """,
    "user:totalDividendsPaid": """
        dividend:adjDividend * income:weightedAverageShsOut
    """,
    "user:%fcfePayoutRatio": """
        user:totalDividendsPaid / user:freeCashFlowToEquity
    """,
}, forecast=0, timeseries="annual")

model.render_table({
    "timeseries": "annual",
    "data": {
        "flow:freeCashFlow": "Free Cash Flow to the Firm",
        "user:netBorrowing": "Net Borrowing",
        "user:freeCashFlowToEquity": "Free Cash Flow to Equity (FCFE)",
        "user:totalDividendsPaid": "Total Dividends Paid",
        "user:%fcfePayoutRatio": "FCFE Payout Ratio",
    },
    "start": data.get("""
        -assumption:#historicalYears
    """),
    "end": 0,
    "properties": {
        "title": "FCFE vs. Dividends",
        "order": "descending",
        "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 Dividend Discount Model

This model estimates the value of companies that have reached maturity and pay stable dividends as a significant percentage of their free cash flow to equity, with no share buybacks or high growth expectancy.

Fair Value Formulas

Fair Value = Next Year's Expected Dividend / (Discount Rate - Growth In Perpetuity)

Next year's expected dividend = Current Dividend per Share * (1 + Growth In Perpetuity)

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

Learn more: Prof. Aswath Damodaran's Guide to Dividend Discount Models

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.	#
Forecast Years Forecast Years The number of years into the future for which the analysis projects financial performance and metrics.	#
Growth In Perpetuity Growth In Perpetuity The stable rate at which the company's book value is assumed to grow in perpetuity.	%
Expected Dividend Expected Dividend The estimated annual dividend per share for the next year.	#

Fair Value Calculation
Current dividend per share	0.359 USD
Growth In Perpetuity	2.5%
Next year's expected dividend	0.368 USD
Cost of Equity (Discount Rate)	4.15%
Fair Value	22.3 USD

Forecast Dividends

Monetary values in USD

Understanding the Calculations

The Free Cash Flow to Equity represents the cash available to the common shareholders to be paid out as dividends or used for share buybacks.

Free Cash Flow to Equity = Free Cash Flow to the Firm + Net Borrowing

For the Dividend Discount Model to be appropriate, the FCFE payout ratio should represent a significant portion of FCFE, typically over 50%.

FCFE Payout Ratio = Total Dividends Paid / Free Cash Flow to Equity

FCFE vs. Dividends

Monetary values in USD amounts except #	LTM Mar 08	2021	2020	2019
Free Cash Flow to the Firm
Net Borrowing
Free Cash Flow to Equity (FCFE)
Total Dividends Paid
FCFE Payout Ratio

Fair Value

USD

Market Price USD