Clifford Capital Partners Fund Investor Class (CLFFX) Discounted Future Market Cap

Clifford Capital Partners Fund Investor Class

CLFFX (NASDAQ)

(%)

Models
Clifford Capital Partners Fund Investor Class Discounted Future Market Cap

# --- 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
        """,
        "#priceToEarningsRatio": """
            ratio:priceEarningsRatio
        """,
    },
    "titles": {
        "#historicalYears": "Historical Years",
        "#forecastYears": "Forecast Years",
        "#beta": "Beta",
        "%riskFreeRate": "Risk Free Rate",
        "%equityRiskPremium": "Equity Risk Premium",
        "%discountRate": "Discount Rate",
        "#priceToEarningsRatio": "Price to Earnings Ratio",
    },
    "properties": {
        "width": "responsive",
        "title": "Assumptions",
        "id": "component-1",
        "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)
        """,
        "#priceToEarningsRatio": r"""
Estimated Price to Earnings (PE) Ratio at the end of the projection period.

`Future Market Cap` = `PE Ratio` * `Projected Net Income`
        """,
    },
    "hierarchies": [
        {
            "parent": "%discountRate",
            "children": [
                "#beta",
                "%riskFreeRate",
                "%equityRiskPremium",
            ]
        },
    ]
})

# Render description block
model.render_description({
    "data": r"""
## Discounted Future Market Cap

This model estimates the intrinsic value of a common share by projecting the future market capitalization using the estimated P/E ratio, then discounting it to the present using an annual required rate of return (referred to as the discount rate).
""",
    "properties": {
        "width": "responsive"
    }
})

# --- Historical Averages
data.compute({
    "user:%revenueGrowthRate": """
        ( income:revenue / income:revenue:-1 ) - 1
    """,
    "user:%netIncomeMargin": """
        income:netIncome / income:revenue
    """,
    "user:%equityGrowthRate": """
        ( balance:totalStockholdersEquity / balance:totalStockholdersEquity:-1 ) - 1
    """,
}, forecast=0, timeseries="annual")

model.render_table({
    "timeseries": "annual",
    "data": {
        "user:%revenueGrowthRate": "Revenue Growth Rate",
        "user:%netIncomeMargin": "Net Income Margin",
        "user:%equityGrowthRate": "Equity Growth Rate",
        "ratio:returnOnInvestedCapital": "Return On Invested Capital",
    },
    "start": data.get("""
        -assumption:#historicalYears
    """),
    "end": 0,
    "properties": {
        "title": "Historical Averages",
        "order": "descending",
        "number_format": "M",
        "include_ltm": True,
        "display_averages": True,
        "width": "responsive"
    }
})

# --- Net Margin & Revenue Growth
assumptions.set({
    "timeseries": "annual",
    "data": {
        "%revenueGrowthRate": """
             function:average(start=-assumption:#historicalYears, end=0):user:%revenueGrowthRate 
            or if this > 25%:
            25%
        """,
        "%netIncomeMargin": """
             function:average(start=-assumption:#historicalYears, end=0):user:%netIncomeMargin 
            or if this > 100%:
            100%
            
        """,
    },
    "titles": {
        "%revenueGrowthRate": "Revenue Growth Rate",
        "%netIncomeMargin": "Net Income Margin",
    },
    "properties": {
        "width": "responsive",
        "title": "Net Margin & Revenue Growth",
        "id": "component-5",
        "bindTo": None
    },
    "descriptions": {
        "%revenueGrowthRate": r"""
The annual revenue growth rate is applied to projected revenue starting from the second projection year onward.
        """,
        "%netIncomeMargin": r"""
Net Income expressed as a percentage of Revenue.
        """,
    }
})

# --- Forecast
data.compute({
    "income:revenue": """
        income:revenue:-1 * (1 + assumption:%revenueGrowthRate)
    """,
    "income:netIncome": """
        income:revenue * assumption:%netIncomeMargin
    """,
}, forecast=data.get("""
    assumption:#forecastYears
"""), timeseries="annual")

model.render_chart({
    "timeseries": "annual",
    "data": {
        "income:revenue": "Revenue",
        "income:netIncome": "Net Income",
    },
    "start": -5,
    "end": data.get("""
        assumption:#forecastYears
    """),
    "properties": {
        "title": "Forecast",
        "include_ltm": False,
        "set_editable": ["income:revenue", "income:netIncome"],
        "hidden_keys": [],
        "bar_keys": [],
        "width": "full"
    }
})

# --- Estimated Future Values
data.compute({
    "user:%revenueGrowthRate": """
        ( income:revenue / income:revenue:-1 ) - 1
    """,
}, forecast=data.get("""
    assumption:#forecastYears
"""), timeseries="annual")

model.render_table({
    "timeseries": "annual",
    "data": {
        "income:revenue": "Revenue",
        "user:%revenueGrowthRate": "Revenue Growth Rate",
        "income:netIncome": "Net Income",
    },
    "start": 1,
    "end": data.get("""
        assumption:#forecastYears
    """),
    "properties": {
        "title": "Estimated Future Values",
        "order": "ascending",
        "number_format": "M",
        "include_ltm": False,
        "display_averages": False,
        "width": "responsive"
    }
})

# --- Fair Value Calculation
data.compute_results({
    "estimatedMarketCapitalization": """
        assumption:#priceToEarningsRatio * income:netIncome:assumption:#forecastYears
    """,
    "discountedMarketCapitalization": """
        result:estimatedMarketCapitalization / (1 + assumption:%discountRate) ** assumption:#forecastYears
    """,
    "#equityValuePerShare": """
        result:discountedMarketCapitalization / income:weightedAverageShsOut
    """,
}, timeseries="annual")

model.render_results({
    "timeseries": "annual",
    "data": {
        "income:netIncome:assumption:#forecastYears": {
            "label": "End Net Income",
            "type": "$"
        },
        "assumption:#priceToEarningsRatio": {
            "label": "* End Price to Earnings Ratio",
            "type": ""
        },
        "result:estimatedMarketCapitalization": {
            "label": "= End Market Capitalization",
            "type": "$"
        },
        "result:discountedMarketCapitalization": {
            "label": "Discounted Market Capitalization",
            "type": "$"
        },
        "income:weightedAverageShsOut": {
            "label": "/ Shares Outstanding",
            "type": ""
        },
        "result:#equityValuePerShare": {
            "label": "= Fair Value per Share",
            "type": "$"
        },
    },
    "properties": {
        "title": "Fair Value Calculation",
        "width": "responsive",
        "hidden_keys": []
    }
})

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

Error at line 167: max() arg is an empty sequence

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.	#
Price to Earnings Ratio Price to Earnings Ratio Estimated Price to Earnings (PE) Ratio at the end of the projection period. `Future Market Cap` = `PE Ratio` * `Projected Net Income`	#

Discounted Future Market Cap

Historical Averages

Monetary values in USD amounts except #	Average	LTM Mar 08
Revenue Growth Rate
Net Income Margin
Equity Growth Rate
Return On Invested Capital		0%

Net Margin & Revenue Growth

Revenue Growth Rate Revenue Growth Rate The annual revenue growth rate is applied to projected revenue starting from the second projection year onward.	%
Net Income Margin Net Income Margin Net Income expressed as a percentage of Revenue.	%

Assumptions

Discount Rate

Beta

Risk Free Rate

Equity Risk Premium

Historical Years

Forecast Years

Price to Earnings Ratio

Discounted Future Market Cap

Historical Averages

Net Margin & Revenue Growth

Revenue Growth Rate

Net Income Margin

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

Clifford Capital Partners Fund Investor Class Discounted Future Market Cap

Assumptions

Discount Rate

Beta

Risk Free Rate

Equity Risk Premium

Historical Years

Forecast Years

Price to Earnings Ratio

Discounted Future Market Cap

Historical Averages

Net Margin & Revenue Growth

Revenue Growth Rate

Net Income Margin

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)