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