In: Accounting
| Year | DPS | Difference | Growth rate | ||||
| 2015 | $ 1.32 | ||||||
| 2016 | $ 1.43 | $ 0.11 | 8% | ||||
| 2017 | $ 1.57 | $ 0.14 | 10% | ||||
| 2018 | $ 1.73 | $ 0.16 | 10% | ||||
| 2019 | $ 1.91 | $ 0.18 | 10% | ||||
| 2020 | $ 2.10 | $ 0.19 | 10% | ||||
| 2021 | $ 2.31 | $ 0.21 | 10% | ||||
| 2022 | $ 2.54 | $ 0.23 | 10% | ||||
| 2023 | $ 2.80 | $ 0.25 | 10% | ||||
| Scenario 1 | Do not Expand | ||||||
| Fair Price per share | |||||||
| = | DPS(1+g) | ||||||
| (Ke-g) | |||||||
| = | 2.80(1+0.10) | ||||||
| (.1415-.10) | |||||||
| = | $ 74.22 | ||||||
| Note:- Growth rate is the historical growth rate which is take as 10% | |||||||
| Scenario 2 | Expand | ||||||
| PVF @16.34% | PV | Diff | |||||
| 2021 | $ 2.15 | 1 | $ 2.15 | g=14.19% | |||
| 2022 | $ 2.46 | 0.8595 | $ 2.11 | $ 0.31 | 14% | ||
| 2023 | $ 2.80 | 0.7388 | $ 2.07 | $ 0.35 | 14% | ||
| 2024 | $ 3.08 | 0.6351 | $ 1.96 | $ 0.28 | 10% | ||
| Terminal Value of 2024= | {1/(1+ke)2}*((DPS)/(ke-g)) | ||||||
| = | 0.7388*(3.08/.1634-.10) | ||||||
| = | $ 35.89 | ||||||
| Fair Price per share | |||||||
| = | $2.11+$2.07+$1.96+$35.89 | ||||||
| = | $ 42.03 | ||||||
| Difference in Present Value of Shares under two Scenarios= | |||||||
| = | $74.22 - $42.03 | ||||||
| = | $ 32.19 | ||||||
Hope this Solves your query. Feel free to ask any further queries in the comment section