Please note that inconsistencies may arise during the recovery process. We kindly ask you to verify the integrity of the model.
To save the restored assumptions, consider adding the valuation to your watchlist or shared valuations.
Estimated Value
USD
Market Price 22.05 USD
research before making investment decisions.
#Two-Stage Excess Return Model
Used to estimate the value of companies based on two stages of growth. An initial period of high growth, represented by [Sum of discounted excess returns in Growth Stage], followed by a period of stable growth, represented by [Discounted excess return in terminal stage]. 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).
Read more: GitHub Documentation
Interactive Assumptions
Results |
|
---|---|
Estimated Value | 31.02 USD |
Book value of equity invested | 38.5 USD |
Sum of discounted excess returns in Growth Stage | -1.7 USD |
Terminal stage EPS | 4.26 USD |
Terminal stage Book Value | 47.66 USD |
Terminal stage Equity Cost | 4.78 USD |
Discounted excess return in terminal stage | -5.78 USD |
Excess Returns in the Terminal Stage | -9.31 USD |
Terminal Cost of Equity (the discount rate) | 10.02% |
Terminal year's excess return | -0.516 USD |
Average historical Return on Equity | 8.94% |
Average historical Payout Ratio | 48.48% |
Payout Ratio in stable stage | 49.88% |
Yield of the U.S. 10 Year Treasury Bond | 4.48% |
Historical and Forecasted Data
In USD
Edit Chart Values | 2025 | 2026 | 2027 | 2028 | 2029 |
---|---|---|---|---|---|
↳ Growth Rate |
Projected data
amounts of USD except for # |
2024 | LTM | 2025 | 2026 | 2027 | 2028 | 2029 |
---|---|---|---|---|---|---|---|
Beginning Book Value | 36.33 | 38.19 | 38.19 | 39.94 | 41.76 | 43.65 | 45.62 |
Ending Book Value | 38.19 | 38.5 | 39.94 | 41.76 | 43.65 | 45.62 | 47.66 |
EPS | 3.25 | 3.39 | 3.41 | 3.57 | 3.73 | 3.9 | 4.08 |
Return on Equity | 9.3% | 9.42% | 8.94% | 8.94% | 8.94% | 8.94% | 8.94% |
Dividend per Share | 1.5 | 1.38 | 1.66 | 1.75 | 1.84 | 1.94 | 2.03 |
Payout Ratio | 46.15% | 40.71% | 48.76% | 49.04% | 49.32% | 49.6% | 49.88% |
Retained Earnings | 1.75 | 2.01 | 1.75 | 1.82 | 1.89 | 1.97 | 2.04 |
Equity Cost | 3.64 | 3.83 | 3.83 | 4.0 | 4.18 | 4.37 | 4.57 |
Cost of Equity | 10.02% | 10.02% | 10.02% | 10.02% | 10.02% | 10.02% | 10.02% |
Excess Return | -0.39 | -0.437 | -0.413 | -0.432 | -0.452 | -0.472 | -0.494 |
Discounted Excess Return |
|
|
-0.376 | -0.357 | -0.339 | -0.322 | -0.306 |
Historical data
amounts of USD except for # |
Average | LTM | 2024 | 2023 | 2022 | 2021 | 2020 | 2019 | 2018 | 2017 | 2016 | 2015 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Net Income | 24,222 | 27,854 | 27,132 | 26,515 | 27,528 | 31,978 | 17,894 | 27,430 | 28,147 | 18,232 | 17,822 | 15,910 |
Total Stockholders Equity | 274,420 | 295,581 | 295,559 | 291,646 | 273,197 | 270,066 | 272,924 | 264,810 | 265,325 | 267,146 | 266,195 | 256,176 |
Return on Equity | 8.94% | 9.42% | 9.3% | 9.71% | 10.19% | 11.72% | 6.76% | 10.34% | 10.54% | 6.85% | 6.96% | 6.54% |
Dividends Paid to Common Shareholders | 10,326 | 10,596 | 11,608 | 11,079 | 8,195 | 8,578 | 8,928 | 13,053 | 10,197 | 10,298 | 10,490 | 10,567 |
Payout Ratio | 48.48% | 40.71% | 46.15% | 44.52% | 31.46% | 28.06% | 54.26% | 50.18% | 38.26% | 61.96% | 64.56% | 73.19% |
Shares Outstanding | 9,021 | 7,678 | 7,738 | 8,029 | 8,114 | 8,493 | 8,753 | 9,390 | 10,096 | 10,196 | 10,284 | 10,462 |
Earnings per Share | 2.58 | 3.39 | 3.25 | 3.1 | 3.21 | 3.6 | 1.88 | 2.77 | 2.64 | 1.63 | 1.58 | 1.38 |
Dividend per Share | 1.16 | 1.38 | 1.5 | 1.38 | 1.01 | 1.01 | 1.02 | 1.39 | 1.01 | 1.01 | 1.02 | 1.01 |
Dividend Growth Rate | 5.92% | -8% | 8.7% | 36.63% | 0% | -0.98% | -26.62% | 37.62% | 0% | -0.98% | 0.99% | 0% |
Book Value | 30.97 | 38.5 | 38.19 | 36.33 | 33.67 | 31.8 | 31.18 | 28.2 | 26.28 | 26.2 | 25.88 | 24.49 |
Recommended for
Used to value financial service companies such as Banks, Investment Banks and Insurance Companies that have reached maturity and earn stable excess returns with little to no high growth chance.
Financial Service
companies.
The intrinsic value is calculated assuming that the Excess Return will grow steadily at a Growth In Perpetuity rate. Excess Return is defined as the difference between Return on Equity and Cost of Equity. Read more on GitHub |
Recommended for
Used to value high growing financial service companies such as Banks, Investment Banks and Insurance Companies.
Financial Service
companies.
The model assumes an initial period of high growth adding up all Discounted Excess Return projections, followed by a period of stable growth, where it adds the Discounted Terminal Value calculated assuming that the Excess Return will grow steadily at a Growth In Perpetuity rate. Excess Return is defined as the difference between Return on Equity and Cost of Equity. Read more on GitHub |
Recommended for
Used to estimate the value of companies that have reached maturity and pay stable dividends as a significant percentage of their Free Cashflow to Equity with little to no high growth chance.
All
companies.
The model assumes a Growth in Perpetuity for the company's dividend and uses the Gordon Growth Formula to calculate the intrinsic value. Read more on GitHub |
Recommended for
Used to value a company based on two stages of dividend growth.
All
companies.
The model assumes an initial period of high growth adding up all Discounted Dividend projections, followed by a period of stable growth, where it adds the Discounted Terminal Value calculated assuming that the Dividend will grow steadily at a Growth In Perpetuity rate. Read more on GitHub |
This model is only available with a paid subscription plan.
Recommended for
Earnings power value is a method of valuing the stocks of a company, assuming that the current earnings are sustainable, and there is no future growth.
The model was developed by Columbia University Professor Bruce Greenwald, a renowned financial economist and value investor who, through this valuation technique, tries to overcome the main challenge in discounted cash flow (DCF) analysis related to making assumptions about future growth, cost of capital, profit margins, and required investments.
All
companies.
|
Recommended for
Graham number is a method developed for the defensive investors as described in CHAPTER 14 in The Intelligent Investor. It evaluates a stock’s intrinsic value by calculating the square root of 22.5 times the multiplied value of the company’s EPS and BVPS.
This fundamental value formula does not apply to asset-light companies with high growth rate and companies with negative earnings.
All
companies.
|
Recommended for
Used to value a company based on its projections of Free Cash Flow to the Firm, also called Unlevered Free Cash Flow.
Non-Financial Service
companies.
The model calculates Enterprise Value assuming an initial period of high growth and summing up all Discounted Free Cash Flow projections, followed by a period of stable growth, where it adds the Discounted Terminal Value calculated assuming that the Free Cash Flow will grow steadily at a Growth In Perpetuity rate. This model is not recommended for Financial Service Companies. Read more on GitHub |
This model is only available with a paid subscription plan.
Recommended for
Peter Lynch Fair Value applies to growing companies. The ideal range for the growth rate is between 10% and 20% a year. It is computed by multiplying PEG Ratio, which according to Peter Lynch should always equal to 1 (so it can be ignored), EPS LTM, and Earnings Growth Rate. The resulting model value shows whether the company is currently trading at its fair value or not.
All
companies.
|
Recommended for
Used to value a company by projecting the Future Market Capitalization using an estimated Forward PE Ratio and an Earnings projection. Then, it discounts the Future Market Capitaliztion to the Present Value using a Discount Rate.
All
companies.
|
Recommended for
Used to value a company based on its projections of Free Cash Flow to the Firm, also called Unlevered Free Cash Flow.
Non-Financial Service
companies.
The model calculates Enterprise Value assuming an initial period of high growth and summing up all Discounted Free Cash Flow projections, followed by an Exit EV/EBITDA multiple terminal value. This model is not recommended for Financial Service Companies. Read more on GitHub |
Recommended for
All
companies.
|
Recommended for
All
companies.
|
Recommended for
Return on Invested Capital (ROIC) determines how efficiently a company puts the capital under its control toward profitable investments or projects. The ROIC ratio gives a sense of how well a company is using the money it has raised externally to generate returns. Comparing a company's return on invested capital with its weighted average cost of capital (WACC) reveals whether invested capital is being used effectively.
All
companies.
|
This model is only available with a paid subscription plan.
Recommended for
The CAPE Ratio (also known as the Shiller P/E or PE 10 Ratio) is an acronym for the Cyclically-Adjusted Price-to-Earnings Ratio. The ratio is calculated by dividing a company’s stock price by the average of the company’s earnings for the last [Historical Years] (10 years by default), adjusted for inflation.
Financial Analysts use the Cyclically-Adjusted Price to Earnings Ratio to assess long-term financial performance, while isolating the impact of economic cycles.
All
companies.
|
This model is only available with a paid subscription plan.
Recommended for
Beneish’s M-Score is a mathematical model that uses eight financial ratios weighted by coefficients to identify whether a company has manipulated its profits.
All
companies.
|
This model is only available with a paid subscription plan.
Recommended for
Altman’s Z-Score model is a numerical measurement that is used to predict the chances of a business going bankrupt in the next two years. The model was developed by American finance professor Edward Altman in 1968 as a measure of the financial stability of companies.
All
companies.
|
This model is only available with a paid subscription plan.
Recommended for
The Piotroski score, also known as the Piotroski F-score, is a discrete score that ranges from 0 to 9 and reflects nine criteria that are used to gauge the strength of a firm’s financial position.
All
companies.
|
Recommended for
Non-Financial Service
companies.
|
Delete Model
Are you sure you want to delete your model? All associated code will be permanently lost.