In: Finance
Inputs | Present | ||||
Value | |||||
Current stock Price | $ 62.00 | ||||
Risk Free | 2.5% | ||||
Beta | 1.1 | ||||
Expected Market Return | 7.0% | ||||
Dividend growth rate | 6.0% | ||||
Required Rate of Return | |||||
PV | Dividend | ||||
This Year's Dividend | This Year | $ 0.80 | Growth | ||
Next Year | $ 0.92 | 15% | |||
2 | $ 1.06 | 15% | |||
3 | $ 1.22 | 15% | |||
Future Stock Price | 3 | 6.0% | |||
Intrinsic Value | Intrinsic Value |
From the give data,
Required return of the stock can be calculated using CAPM model
Ke = Rf + Beta*(Rm-Rf) = 2.5 + 1.1*(4-2.5) = 7.45%
Next, Future stock value can be calculated using constant dividend growth model
So, future stock price at year 3 = D3*(1+g)/(Ke-g) = 1.22*(1.06)/(0.0745-0.06) = $88.94
Now, PV is calculated using PV = FV/(1+Ke)^t
So, PV of next year stock = 0.92/1.0745 = $0.86
PV of year 2 dividend = 1.06/1.0745^2 = $0.92
PV of year 3 dividend = 1.22/1.0745^3 = $0.98
PV of future stock price at year 3 = 88.94/1.0745^3 = $71.70
So total intrinsic value of stock = 0.86 + 0.92 + 0.98 + 71.70 = $74.45
All the calculation are also solved on excel, and image are attach below: