In: Finance
| Required rate= | 10.00% | ||||||
| Year | Previous year dividend | Dividend growth rate | Dividend current year | Horizon value | Total Value | Discount factor | Discounted value | 
| 1 | 5.05 | 12.00% | 5.656 | 5.656 | 1.1 | 5.1418 | |
| 2 | 5.656 | 12.00% | 6.33472 | 6.33472 | 1.21 | 5.23531 | |
| 3 | 6.33472 | 12.00% | 7.0948864 | 7.0948864 | 1.331 | 5.33049 | |
| 4 | 7.0948864 | 12.00% | 7.946272768 | 137.735 | 145.6812728 | 1.4641 | 99.50227 | 
| Long term growth rate (given)= | 4.00% | Value of Stock = | Sum of discounted value = | 115.21 | |||
| Where | |||||||
| Current dividend =Previous year dividend*(1+growth rate)^corresponding year | |||||||
| Total value = Dividend + horizon value (only for last year) | |||||||
| Horizon value = Dividend Current year 4 *(1+long term growth rate)/( Required rate-long term growth rate) | |||||||
| Discount factor=(1+ Required rate)^corresponding period | |||||||
| Discounted value=total value/discount factor |