Question

In: Finance

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 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 13 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

Requirement (1) – Current Share Price

Step-1, Dividend per share for the next 5 years

D0 = $2.85

D1 = $3.42 per share [$2.85 x 120%]

D2 = $4.10 per share [$3.42 x 120%]

D3 = $4.92 per share [$4.10 x 120%]

D4 = $5.91 per share [$4.92 x 120%]

D5 = $7.09 per share [$5.91 x 120%]

Step-2, Calculation of Stock Price for the Year 5 (P5)

Stock Price for the Year 5 = D5(1 + g) / (Ke – g)

= $7.09(1 + 0.0525) / (0.13 – 0.0525)

= $7.46 / 0.0775

= $96.31 per share

Step-3, The Current Stock Price

The Current Stock Price is the aggregate of the Present Value of the future dividend payments and the present value the stock price for the year 5

The Current Stock Price = D1/(1 + r)1 + D2/(1 + r)2 + D3/(1 + r)3 + D4/(1 + r)4 + D5/(1 + r)5 + P5/(1 + r)5

= $3.42/(1 + 0.13)1 + $4.10/(1 + 0.13)2 + $4.92/(1 + 0.13)3+ $5.91/(1 + 0.13)4+ $7.09/(1 + 0.13)5 + $96.31/(1 + 0.13)5

= [$3.42 / 1.13] + [$4.10 / 1.27690] + [$4.92 / 1.44290] + [$5.91 / 1.63047] + [$7.09 / 1.84244] + [$96.31 / 1.84244]

= $3.03 + $3.21 + $3.41 + $3.62 + $3.85 + $52.27

= $69.40 per share

“Hence, the current stock price would be $69.40”

Requirement (2)

Based on these assumptions, the stock is currently overvalued.


Related Solutions

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 (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 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...
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...
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