In: Finance
Compute the value of a share of common stock of Lexus Hotel Berhad whose most recent dividend was RM2.50 and is expected to grow at 3.50 percent per year for the next 5 years, 5 percent per year for the next 3 years, after which the dividend growth rate will increase to 6 percent per year indefinitely. Assume 10.00 percent required rate of return.
| Required rate= | 10.00% | ||||||
| Year | Previous year dividend | Dividend growth rate | Dividend current year | Horizon value | Total Value | Discount factor | Discounted value | 
| 1 | 2.5 | 3.50% | 2.5875 | 2.5875 | 1.1 | 2.3523 | |
| 2 | 2.5875 | 3.50% | 2.6780625 | 2.6780625 | 1.21 | 2.21327 | |
| 3 | 2.6780625 | 3.50% | 2.771794688 | 2.771794688 | 1.331 | 2.08249 | |
| 4 | 2.771794688 | 3.50% | 2.868807502 | 2.868807502 | 1.4641 | 1.95943 | |
| 5 | 2.868807502 | 3.50% | 2.969215764 | 2.969215764 | 1.61051 | 1.84365 | |
| 6 | 2.969215764 | 5.00% | 3.117676552 | 3.117676552 | 1.771561 | 1.76 | |
| 7 | 3.117676552 | 5.00% | 3.27356038 | 3.27356038 | 1.9487171 | 1.67985 | |
| 8 | 3.27356038 | 5.00% | 3.437238399 | 91.087 | 94.5242384 | 2.14358881 | 44.09625 | 
| Long term growth rate (given)= | 6.00% | Value of Stock = | Sum of discounted value = | 57.99 | 
| 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 8 *(1+long term growth rate)/( Required rate-long term growth rate) | |||
| Discount factor=(1+ Required rate)^corresponding period | |||
| Discounted value=total value/discount factor | |||