In: Finance
Sia Dance Studios has an annual cash dividend policy that raises the dividend each year by 3%. Last year's dividend, Div 0Div0, was $8 per share. The company will be in business for 40 years with no liquidating dividend. What is the price of this stock if
a. an investor wants a return of 9%?
b. an investor wants a return of 10%?
c. an investor wants a return of 13%?
d. an investor wants a return of 15%?
e. an investor wants a return of 18%?
round to the nearest cent
Growth rate = 3% |
Last dividend = 8 |
Next year dividend = 8*(1+3%)= 8.24 |
No of years (n)=` 40 |
Present value of growing annuity formula will be applicable to calculate value of growing dividends |
a. required return (i)= 9% |
(Next Dividend*(1-((1+g)^n/(1+i)^n))/(i-g) |
(8.24*(1-((1+3%)^40/(1+9%)^40)))/(9%-3%) |
123.0705255 |
Stock price is $123.07 |
b. required return (i)= 10% |
(Next Dividend*(1-((1+g)^n/(1+i)^n))/(i-g) |
(8.24*(1-((1+3%)^40/(1+10%)^40)))/(10%-3%) |
109.2300885 |
Stock price is $109.23 |
c. required return (i)= 13% |
(Next Dividend*(1-((1+g)^n/(1+i)^n))/(i-g) |
(8.24*(1-((1+3%)^40/(1+13%)^40)))/(13%-3%) |
80.37568329 |
Stock price is $80.38 |
d. required return (i)= 15% |
(Next Dividend*(1-((1+g)^n/(1+i)^n))/(i-g) |
(8.24*(1-((1+3%)^40/(1+15%)^40)))/(15%-3%) |
67.83044515 |
Stock price is $67.83 |
e. required return (i)= 18% |
(Next Dividend*(1-((1+g)^n/(1+i)^n))/(i-g) |
(8.24*(1-((1+3%)^40/(1+18%)^40)))/(18%-3%) |
54.69452766 |
Stock price is $54.69 |