In: Finance
Four years ago, XYZ company paid a dividend of $0.80 per share. Today XYZ paid a dividend of $1.66 per share. It is expected that the company will pay dividends growing at this same rate for the next 5 years. Thereafter, the growth rate will level off at 8% per year. The current stock price is $30. If the required return on this stock remains at 18%, should you buy the stock?
Please show all steps. Don't round off until you get to the end.
Annual average growth rate=((last value/First value)^(1/Time between 1st and last value)-1)*100 |
Annual Growth rate=((1.66/0.8)^(1/4)-1)*100 |
Annual Growth rate% = 20.02 |
Required rate= | 18.00% | ||||||
Year | Previous year dividend | Dividend growth rate | Dividend current year | Horizon value | Total Value | Discount factor | Discounted value |
1 | 1.66 | 20.02% | 1.992332 | 1.992332 | 1.18 | 1.6884 | |
2 | 1.992332 | 20.02% | 2.391196866 | 2.391196866 | 1.3924 | 1.71732 | |
3 | 2.391196866 | 20.02% | 2.869914479 | 2.869914479 | 1.643032 | 1.74672 | |
4 | 2.869914479 | 20.02% | 3.444471358 | 3.444471358 | 1.93877776 | 1.77662 | |
5 | 3.444471358 | 20.02% | 4.134054524 | 44.648 | 48.78205452 | 2.287757757 | 21.32309 |
Long term growth rate (given)= | 8.00% | Value of Stock = | Sum of discounted value = | 28.25 | |||
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 5 *(1+long term growth rate)/( Required rate-long term growth rate) | |||||||
Discount factor=(1+ Required rate)^corresponding period | |||||||
Discounted value=total value/discount factor |
Donot buy as CMP of 30 is more than 28.25 (intrinsic value)