In: Finance
A company’s common stock is expected to pay $2 in dividends annually over the next four years. At the end of the fourth year, its stock is expected to be valued at $45. If the firms cost of equity is 12%, what is its intrinsic value? What should its stock sell for in 1 year?
Please use excel and show work.
As per dividend discount model, current share price is the present value of future dividends. | ||||||||
a) | Intrinsic value | $ 34.67 | ||||||
Working: | ||||||||
Step-1:Present value of next 4 years dividend | ||||||||
Present value | = | Annual dividend | * | Present value of annuity of 1 | ||||
= | $ 2.00 | * | 3.037349 | |||||
= | $ 6.07 | |||||||
Working: | ||||||||
Present value of annuity of 1 | = | (1-(1+i)^-n)/i | Where, | |||||
= | (1-(1+0.12)^-4)/0.12 | i | = | 12% | ||||
= | 3.037349 | n | = | 4 | ||||
Step-2:Present value of dividend after 4 years | ||||||||
Present value | = | Price of stock 4 years from now | * | Discount factor | ||||
= | $ 45.00 | * | 0.635518 | |||||
= | $ 28.60 | |||||||
Working: | ||||||||
Discount factor | = | (1+i)^-n | ||||||
= | (1+0.12)^-4 | |||||||
= | 0.635518 | |||||||
Step-3:Price of stock now | ||||||||
Price of stock now | = | $ 6.07 | + | $ 28.60 | ||||
= | $ 34.67 | |||||||
b) | Intrinsic value in 1 year | $ 36.83 | ||||||
Working: | ||||||||
Step-1:Present value of next 3 years dividend | ||||||||
Present value | = | Annual dividend | * | Present value of annuity of 1 | ||||
= | $ 2.00 | * | 2.401831 | |||||
= | $ 4.80 | |||||||
Working: | ||||||||
Present value of annuity of 1 | = | (1-(1+i)^-n)/i | Where, | |||||
= | (1-(1+0.12)^-3)/0.12 | i | = | 12% | ||||
= | 2.401831 | n | = | 3 | ||||
Step-2:Present value of dividend after 4 years | ||||||||
Present value | = | Price of stock 4 years from now | * | Discount factor | ||||
= | $ 45.00 | * | 0.71178 | |||||
= | $ 32.03 | |||||||
Working: | ||||||||
Discount factor | = | (1+i)^-n | ||||||
= | (1+0.12)^-3 | |||||||
= | 0.71178 | |||||||
Step-3:Price of stock now | ||||||||
Price of stock now | = | $ 4.80 | + | $ 32.03 | ||||
= | $ 36.83 |