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 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 | 65.17 USD |
| Book value of equity invested | 60.01 USD |
| Sum of discounted excess returns in Growth Stage | 1.69 USD |
| Terminal stage EPS | 2.81 USD |
| Terminal stage Book Value | 20.86 USD |
| Terminal stage Equity Cost | 2.31 USD |
| Discounted excess return in terminal stage | 3.48 USD |
| Excess Returns in the Terminal Stage | 5.87 USD |
| Terminal Cost of Equity (the discount rate) | 11.06% |
| Terminal year's excess return | 0.503 USD |
| Average historical Return on Equity | 13.47% |
| Average historical Payout Ratio | 68.61% |
| Payout Ratio in stable stage | 81.44% |
| Yield of the U.S. 10 Year Treasury Bond | 4.26% |
Historical and Forecasted Data
Monetary values in USD
| Edit Chart Values | 2027-01-31 | 2028-01-31 | 2029-01-31 | 2030-01-31 | 2031-01-31 |
|---|---|---|---|---|---|
|
↳ Growth Rate |
Projected data
|
Monetary values in USD amounts except # |
2025
Jan 31 |
LTM
Mar 19 |
2026
Jan 31 |
2027
Jan 31 |
2028
Jan 31 |
2029
Jan 31 |
2030
Jan 31 |
|---|---|---|---|---|---|---|---|
| Beginning Book Value | 16.19 | 17.83 | 17.83 | 18.52 | 19.18 | 19.79 | 20.35 |
| Ending Book Value | 17.83 | 60.01 | 18.52 | 19.18 | 19.79 | 20.35 | 20.86 |
| EPS | 2.37 | 2.37 | 2.4 | 2.49 | 2.58 | 2.67 | 2.74 |
| Return on Equity | 14.1% | 13.47% | 13.47% | 13.47% | 13.47% | 13.47% | 13.47% |
| Dividend per Share | 0.73 | 0.739 | 1.71 | 1.84 | 1.97 | 2.1 | 2.23 |
| Payout Ratio | 30.8% | 31.17% | 71.18% | 73.74% | 76.31% | 78.87% | 81.44% |
| Retained Earnings | 1.64 | 1.63 | 0.692 | 0.655 | 0.612 | 0.563 | 0.509 |
| Equity Cost | 1.79 | 1.97 | 1.97 | 2.05 | 2.12 | 2.19 | 2.25 |
| Cost of Equity | 11.06% | 11.06% | 11.06% | 11.06% | 11.06% | 11.06% | 11.06% |
| Excess Return | 0.579 | 0.399 | 0.43 | 0.446 | 0.462 | 0.477 | 0.49 |
| Discounted Excess Return |
|
|
0.387 | 0.362 | 0.337 | 0.313 | 0.29 |
Historical data
|
Monetary values in USD amounts except # |
Average |
LTM
Mar 19 |
2025
Jan 31 |
2024
Feb 01 |
2023
Feb 03 |
2022
Jan 28 |
2021
Jan 29 |
2020
Jan 30 |
2019
Jan 31 |
2018
Jan 31 |
2017
Jan 31 |
2016
Jan 31 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Net Income | 400.7 | 642 | 642 | 582 | 45 | 1,146 | 1,430 | -3,944 | 564 | 1,108 | 1,566 | 627 |
| Total Stockholders Equity | 5,789 | 16,238 |
|
4,552 | 4,035 | 4,082 | 3,621 | 2,553 | 6,377 | 6,436 | 5,673 | 4,323 |
| Return on Equity | 13.47% | 13.47% | 14.1% | 14.42% | 1.1% | 31.65% | 56.01% | -61.85% | 8.76% | 19.53% | 36.22% | 14.75% |
| Dividends Paid to Common Shareholders | 273.7 | 200 | 197.5 | 195.4 | 181.5 | 173.1 | 92.04 | 117.6 | 467.6 | 464.6 | 461.2 | 459.7 |
| Payout Ratio | 68.62% | 31.17% | 30.8% | 33.1% | 413.8% | 14.72% | 6.44% | -2.98% | 82.97% | 41.94% | 29.43% | 73.4% |
| Shares Outstanding | 292.8 | 270.6 | 270.6 | 281.2 | 274.2 | 274.7 | 306.8 | 311.1 | 309.7 | 307.7 | 305.4 | 308.5 |
| Earnings per Share | 1.44 | 2.37 | 2.37 | 2.1 | 0.16 | 4.28 | 4.66 | -12.68 | 1.82 | 3.6 | 5.13 | 2.03 |
| Dividend per Share | 0.923 | 0.739 | 0.73 | 0.695 | 0.662 | 0.63 | 0.3 | 0.378 | 1.51 | 1.51 | 1.51 | 1.49 |
| Dividend Growth Rate | 3.57% | 1.23% | 5.04% | 4.98% | 5.08% | 110% | -20.63% | -74.97% | 0% | 0% | 1.34% | 7.19% |
| Book Value | 19.79 | 60.01 | 17.83 | 16.19 | 14.72 | 14.86 | 11.8 | 8.21 | 20.59 | 20.92 | 18.58 | 14.01 |
Deprecated Link
AI Insights
AI Insights help you understand your data more easily. With just a click, the assistant looks at the current page, generates a report with key metrics, and highlights any interesting trends, patterns, or outliers. You can also ask the assistant follow-up questions.
Delete Model
Are you sure you want to delete your model? All associated code will be permanently lost.