The last dividend paid by Coppard Inc. was $1.25. The dividend growth rate is expected to be constant at 42.5% for 3 years, after which dividends are expected to grow at a rate of 6% forever. If the firm's required return (rs) is 11%, what is its current stock price?
As per dividend discount method, current stock price is the present value of dividends. | ||||||||||
Step-1:Present value of next 3 year's dividend | ||||||||||
Year | Dividend | Present value of 1 | Present value of dividend | |||||||
a | b | c=1.11^-a | d=b*c | |||||||
1 | $ 1.78 | 0.9009 | $ 1.60 | |||||||
2 | $ 2.54 | 0.8116 | $ 2.06 | |||||||
3 | $ 3.62 | 0.7312 | $ 2.65 | |||||||
Total | $ 6.31 | |||||||||
Working: | ||||||||||
Year 1 dividend | = | 1.25*1.425 | = | $ 1.78 | ||||||
Year 2 dividend | = | 1.78*1.425 | = | $ 2.54 | ||||||
Year 3 dividend | = | 2.54*1.425 | = | $ 3.62 | ||||||
Step-2:Terminal value of dividend at the end of year 3 | ||||||||||
Terminal Value | = | D3*(1+g)/(Ke-g) | Where, | |||||||
= | 3.62*(1+0.06)/(0.11-0.06) | D3 | Year 3 dividend | $ 3.62 | ||||||
= | $ 76.74 | g | Growth rate | 6% | ||||||
Ke | Required Return | 11% | ||||||||
Step-3:Present value of terminal value | ||||||||||
Present value | = | Terminal value at the end of Year 3*Present value of 1 | ||||||||
= | $ 76.74 | * | 0.7312 | |||||||
= | $ 56.11 | |||||||||
Working: | ||||||||||
Present value of 1 | = | (1+i)^-n | Where, | |||||||
= | (1+0.11)^-3 | i | 11% | |||||||
= | 0.7312 | n | 3 | |||||||
Step-4:Present value of all dividends | ||||||||||
Present value of all dividends | = | $ 6.31 | + | $ 56.11 | ||||||
= | $ 62.42 | |||||||||
As present value of dividends is $ 62.42. So, current stock price is $ 62.42. | ||||||||||
The last dividend paid by Coppard Inc. was $1.25. The dividend growth rate is expected to...
The last dividend paid by GM was $1.25. The dividend growth rate is expected to be constant at 15% for 3 years, after which dividends are expected to grow at a rate of 6% forever. If the firms required return (rs) is 11% in Years 1 and 2 and then increases to 13% thereafter and (rs) remains at 13% indefinitely. What is the stocks current price?
The last dividend paid by Wilden Corporation was $3.25. The dividend growth rate is expected to be constant at 1.5% for 2 years, after which dividends are expected to grow at a rate of 8.0% forever. The firm's required return (rs) is 12.0%. What is the best estimate of the current stock price? a. $80.34 b. $81.67 c. $79.01 d. $77.68 e. $76.35
ABC Company's last dividend was $2.3. The dividend growth rate is expected to be constant at 29% for 2 years, after which dividends are expected to grow at a rate of 6% forever. The firm's required return (rs) is 16%. What is its current stock price (i.e. solve for Po)?
The last dividend paid by ABC, Inc. was $1.00. ABC's growth rate is expected to be 0 for two years, after which dividends are expected to grow at a rate of 3% forever. The required rate of return is 8%. What is the current price of the stock?
5. [Ch 9] Primanti Brothers' last dividend was $1.50. The dividend growth rate is expected to be constant at 20% for 3 years, after which dividends are expected to grow at a rate of 5% forever. If the firm's required return (rs) is 10%, what is its current (expected) stock price? [Note: A timeline will be very helpful here!]
Orwell building supplies last dividend was $1.75. Its dividend growth rate is expected to be constant at 34.00% for 2 years, after which dividends are expected to grow at a rate of 6% forever. Its required return (rs) is 12%. What is the best estimate of the current stock price?
Orwell building supplies' last dividend was $1.75. Its dividend growth rate is expected to be constant at 20.00% for 2 years, after which dividends are expected to grow at a rate of 6% forever. Its required return (rs) is 12%. What is the best estimate of the current stock price?
Orwell building supplies' last dividend was $1.75. Its dividend growth rate is expected to be constant at 42.00% for 2 years, after which dividends are expected to grow at a rate of 6% forever. Its required return (rs) is 12%. What is the best estimate of the current stock price?
ABC Company's last dividend was $3.7. The dividend growth rate is expected to be constant at 6% for 4 years, after which dividends are expected to grow at a rate of 5% forever. The firm's required return (rs) is 12%. What is its current stock price (i.e. solve for Po)? Note: Enter your answer rounded off to two decimal points. Do not enter $ or comma in the answer box. For example, if your answer is $12.345 then enter as...
Orwell Building Supplies' last dividend was $1.75. Its dividend growth rate is expected to be constant at 25% for 2 years, after which dividends are expected to grow at a rate of 6% forever. Its required return (rs) is 12%. What is the best estimate of the current stock price? *****Please show work on EXCEL spreadsheet, please show EXCEL formulas****