Question

In: Finance

You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Div) Div Yld...

You’ve collected the following information from your favorite financial website.

52-Week Price Stock (Div) Div
Yld %
PE
Ratio
Close
Price
Net
Chg
Hi Lo
77.40 10.43 Palm Coal .36 2.6 6 13.90 –.24
55.81 33.42 Lake Lead Grp 1.54 3.8 10 40.43 –.01
130.98 69.75 SIR 2.25 2.5 10 89.02 3.07
50.24 13.95 DR Dime .80 5.2 6 15.43 –.26
35.00 20.74 Candy Galore .32 1.5 28 ?? .18

According to your research, the growth rate in dividends for SIR for the next five years is expected to be 20 percent. Suppose SIR meets this growth rate in dividends for the next five years and then the dividend growth rate falls to 5.25 percent indefinitely. Assume investors require a return of 15 percent on SIR stock.


According to the dividend growth model, what should the stock price be today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
  
Current stock price            $


Based on these assumptions, is the stock currently overvalued, undervalued, or correctly valued?

  

Solutions

Expert Solution

This is an application of dividend discount model, according to which current value of a stock is present value of all dividends expected in future. For this question, dividends for first five years is 20% and falls to 5.25% for the years after.

Based on this, the intrinsic value of stock could be calculated as:

where D1, D2, D3,... are dividends in years 1,2,3.... respectively, r is the required rate of return and V5 is the terminal value, which can be mathematically calculated as:

D0 = 2.25

D1 = 2.25 * (1 + 20%) = 2.700

D2 = 2.700 * (1 + 20%) = 3.240

D3 = 3.240 * (1 + 20%) = 3.888

D4 = 3.888 * (1 + 20%) = 4.666

D5 = 4.666 * (1 + 20%) = 5.599

D6 = 5.599 * (1 + 5.25%) = 5.893

Calculating terminal value V5,

V5 = 60.437

Now, using dividend discount model formula,

V0 = 2.348 + 2.450 + 2.556 + 2.668 + 2.783 + 30.048

V0 = $42.85. Answer

According to dividend discount model, the stocks seems to be overvalued, given the intrinsic value is greater than the trading price of stock ( $89.02).


Related Solutions

You’ve collected the following information from your favorite financial website.    52-Week Price Stock (Div) Div...
You’ve collected the following information from your favorite financial website.    52-Week Price Stock (Div) Div Yld % PE Ratio Close Price Net Chg Hi Lo 77.40 10.43 Palm Coal .36 2.6 6 13.90 –.24 55.81 33.42 Lake Lead Grp 1.54 3.8 10 40.43 –.01 130.93 69.50 SIR 2.00 2.2 10 88.97 3.07 50.31 14.02 DR Dime .87 5.6 6 15.50 –.26 35.00 20.74 Candy Galore .32 1.5 28 ?? .18    According to your research, the growth rate in...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Div) Div Yld...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Div) Div Yld % PE Ratio Close Price Net Chg Hi Lo 77.40 10.43 Palm Coal .36 2.6 6 13.90 –.24 55.81 33.42 Lake Lead Grp 1.54 3.8 10 40.43 –.01 131.07 70.20 SIR 2.70 3.0 10 89.11 3.07 50.24 13.95 DR Dime .80 5.2 6 15.43 –.26 35.00 20.74 Candy Galore .32 1.5 28 ?? .18 According to your research, the growth rate in dividends for...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Div) Div Yld...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Div) Div Yld % PE Ratio Close Price Net Chg Hi Lo 77.40 10.43 Palm Coal .36 2.6 6 13.90 –.24 55.81 33.42 Lake Lead Grp 1.54 3.8 10 40.43 –.01 131.02 69.95 SIR 2.45 2.8 10 89.06 3.07 50.24 13.95 DR Dime .80 5.2 6 15.43 –.26 35.00 20.74 Candy Galore .32 1.5 28 ?? .18 According to your research, the growth rate in dividends for...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Cur div) Div...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Cur div) Div Yld % PE Ratio Close Price Net Chg Hi Lo 77.40 10.43 Palm Coal .36 2.6 6 13.90 –.24 55.81 33.42 Lake Lead Grp 1.54 3.8 10 40.43 –.01 131.09 70.30 SIR 2.80 3.1 10 89.13 3.07 50.24 13.95 DR Dime .80 5.2 6 15.43 –.26 35.00 20.74 Candy Galore .32 1.5 28 ?? .18 According to your research, the growth rate in dividends...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Cur div) Div...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Cur div) Div Yld % PE Ratio Close Price Net Chg Hi Lo 77.40 10.43 Palm Coal .36 2.6 6 13.90 –.24 55.81 33.42 Lake Lead Grp 1.54 3.8 10 40.43 –.01 131.08 70.25 SIR 2.75 3.1 10 89.12 3.07 50.24 13.95 DR Dime .80 5.2 6 15.43 –.26 35.00 20.74 Candy Galore .32 1.5 28 ?? .18 According to your research, the growth rate in dividends...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Cur div) Div...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Cur div) Div Yld % PE Ratio Close Price Net Chg Hi Lo 77.40 10.43 Palm Coal .36 2.6 6 13.90 –.24 55.81 33.42 Lake Lead Grp 1.54 3.8 10 40.43 –.01 130.94 69.55 SIR 2.05 2.3 10 88.98 3.07 50.24 13.95 DR Dime .80 5.2 6 15.43 –.26 35.00 20.74 Candy Galore .32 1.5 28 ?? .18 According to your research, the growth rate in dividends...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Cur div) Div...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Cur div) Div Yld % PE Ratio Close Price Net Chg Hi Lo 77.40 10.43 Palm Coal .36 2.6 6 13.90 –.24 55.81 33.42 Lake Lead Grp 1.54 3.8 10 40.43 –.01 131.10 70.35 SIR 2.85 3.2 10 89.14 3.07 50.24 13.95 DR Dime .80 5.2 6 15.43 –.26 35.00 20.74 Candy Galore .32 1.5 28 ?? .18 According to your research, the growth rate in dividends...
52 Week Price Hi Lo Stock (Div) Div Yld% PE Ratio Close Price Net Chg 64.60...
52 Week Price Hi Lo Stock (Div) Div Yld% PE Ratio Close Price Net Chg 64.60 47.80 Abbot 1.12 1.9 235.6 62.91 -.05 145.94 70.28 Ralph Lauren 2.50 1.8 70.9 139.71 -.62 171.13 139.13 IBM 6.30 4.3 23.8 145.39 .19 91.80 71.96 Duke Energy 3.56 4.9 17.6 74.30 .84 113.19. 96.20. Disney 1.68 1.7 15.5 ?? .10 According to the 2018 Value Line Investment Survey, the growth rate in dividends for IBM for the next five years is expected to...
You’ve collected the following information about Erna, Inc.: Sales = $ 320,000 Net income = $...
You’ve collected the following information about Erna, Inc.: Sales = $ 320,000 Net income = $ 18,500 Dividends = $ 7,300 Total debt = $ 68,000 Total equity = $ 99,000 What is the sustainable growth rate for the company? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Sustainable growth rate % Assuming it grows at this rate, how much new borrowing will take place in the coming year,...
You’ve collected the following information about Erna, Inc.: Sales = $ 285,000 Net income = $...
You’ve collected the following information about Erna, Inc.: Sales = $ 285,000 Net income = $ 17,800 Dividends = $ 6,600 Total debt = $ 61,000 Total equity = $ 92,000 What is the sustainable growth rate for the company? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Sustainable growth rate 12.17 % Assuming it grows at this rate, how much new borrowing will take place in the coming...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT