In: Finance
Dunder Mifflin will pay its first dividend of $4.35 per share in eight years. They expect to grow the dividend at 10% per year afterward. If you require a return of 18%, what is the most you would be willing to pay for the stock today?
Required rate= | 18.00% | ||||||
Year | Previous year dividend | Dividend growth rate | Dividend current year | Horizon value | Total Value | Discount factor | Discounted value |
1 | 0 | 0.00% | 0 | 0 | 1.18 | 0 | |
2 | 0 | 0.00% | 0 | 0 | 1.3924 | 0 | |
3 | 0 | 0.00% | 0 | 0 | 1.643032 | 0 | |
4 | 0 | 0.00% | 0 | 0 | 1.93877776 | 0.00 | |
5 | 0 | 0.00% | 0 | 0 | 2.287757757 | 0.00 | |
6 | 0 | 0.00% | 0 | 0 | 2.699554153 | 0 | |
7 | 0 | 0.00% | 0 | 0 | 3.185473901 | 0 | |
8 | 0 | 0.00% | 4.35 | 59.813 | 64.163 | 3.758859203 | 17.06981 |
Long term growth rate (given)= | 10.00% | Value of Stock = | Sum of discounted value = | 17.07 | |||
Where | |||
Total value = Dividend + horizon value (only for last year) | |||
Horizon value = Dividend Current year 8 *(1+long term growth rate)/( Required rate-long term growth rate) | |||
Discount factor=(1+ Required rate)^corresponding period | |||
Discounted value=total value/discount factor |