In: Finance
Orange Company dividends will grow at 8% during the next 4 years, 7% during year 5, after that they will grow at a 6%. Last year dividend was $1.50. The risk-free rate of return is 4% and the risk premium is 5% What is the value of the stock? Please show calculations
Risk-free rate | 4% | ||||
Risk premium | 5% | ||||
Cost of capital | Risk-free rate + Risk premium | ||||
Cost of capital | 4%+5% | ||||
Cost of capital | 9.00% | ||||
Year | Growth rate | Dividend computation | Dividend | PV factor @9%, 1/(1+r)^time | Dividend * PV factor |
1 | 8.00% | 1.5*(1+8%) | $ 1.62 | 0.9174 | $ 1.49 |
2 | 8.00% | 1.62*(1+8%) | $ 1.75 | 0.8417 | $ 1.47 |
3 | 8.00% | 1.75*(1+8%) | $ 1.89 | 0.7722 | $ 1.46 |
4 | 8.00% | 1.89*(1+8%) | $ 2.04 | 0.7084 | $ 1.45 |
5 | 7.00% | 2.04*(1+7%) | $ 2.18 | 0.6499 | $ 1.42 |
5 | $ 77.15 | 0.6499 | $ 50.14 | ||
Current share price | $ 57.43 | ||||
Current Dividend | $ 2.18 | ||||
Rate of return | 9.00% | ||||
Growth Rate | 6.00% | ||||
Share Price at the horizon i.e. T5 | =Current Dividend*(1+Growth rate)/(Rate of return-Growth Rate) | ||||
Share Price at the horizon i.e. T5 | =2.1835847808*(1+0.06)/(0.09-0.06) | ||||
Share Price at the horizon i.e. T5 | $ 77.15 |