In: Finance
Lawrence Industries' most recent annual dividend was $1.14 per share (D0=1.14) and the firms required return is 12%. Find the market value of Lawrence shares when dividends are expected to grow at 10% annually for 3 years followed by a 7% constant annual growth rate in years 4 to infinity.
The market value of Lawrence share is ____ ?( Round to nearest cent.)
| E | F | G | H | |
| 5 | Year | Dividend=D0(1+g)^n | Discount factor = 1/(1+r)^n | Present value | 
| 6 | 1 | 1.2540 | 0.892857 | 1.11964 | 
| 7 | 2 | 1.3794 | 0.797194 | 1.09965 | 
| 8 | 3 | 1.5173 | 0.711780 | 1.08001 | 
| 9 | ||||
| Present value = 3.30(rounded) | 3.29930 | |||
| Present value of dividend 3 years onwards | ||||
| =(D3*(1+g)/(ke-g))*(1+ke)^-3 | ||||
| = (1.5173*(1+.07)/(.12-.07))*(1.11)^-3 | ||||
| =(1.623511/(.050*)).731191 | ||||
| =32.47022*.731191 | ||||
| =23.74195 | ||||
| Market value = Present value + Present value od dividend 3 years onwards | ||||
| = 3.29930+23.74195 = 27.04 | ||||
formula:
| E | F | G | H | |
| 5 | Year | Dividend=D0(1+g)^n | Discount factor = 1/(1+r)^n | Present value | 
| 6 | 1 | =(1.14)*(1+0.1)^E6 | =1/(1+0.12)^E6 | =F6*G6 | 
| 7 | 2 | =(1.14)*(1+0.1)^E7 | =1/(1+0.12)^E7 | =F7*G7 | 
| 8 | 3 | =(1.14)*(1+0.1)^E8 | =1/(1+0.12)^E8 | =F8*G8 | 
| 9 | ||||
| Present value = 3.30(rounded) | =SUM(H6:H9) |