Question

In: Finance

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 be 5 percent. Suppose IBM meets this growth rate in dividends for the next five years and then the dividend growth rate falls to 3.5 percent indefinitely. Assume investors require a return of 10 percent on IBM stock. Is the stock priced correctly? What factors could affect your answer?

Solutions

Expert Solution

Given, last dividend of IBM (D0) = 6.3

The present stock price of IBM should be equal to the present values of its expected future dividends. As this is expected to follow a two-stage growth model, we can find the present value using cash flows as shown below.

Note that at the end of 5th year, it will become a constant growth stock (with g2 = 3.5%) so we can use the constant growth model to calculate the expected share price at end of 5th year and then we can discount it to present value

Formula view:

So the expected fair value of stock price should be around 106.95. But the last closing price of the stock is given to be 145.39 which is more than the calculated value. So the stock is overpriced.

Factors that could affect the answer:

1. If the expected growth rate during the first 5 years changes, the fair value of the stock would change accordingly.

2. If the high growth rate lasts more than the expected 5 years then the stock would be valued more than what we calculated above.


Related Solutions

Stock (Div) Div Yld % PE Ratio Close Price Net Chg Hi Lo 64.60        47.80          Abbott...
Stock (Div) Div Yld % PE Ratio Close Price Net Chg Hi Lo 64.60        47.80          Abbott 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     a. Using the dividend yield, calculate the closing price for Walt Disney on this day. (Do not round intermediate calculations and round your answer...
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...
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.93 69.50 SIR 2.00 2.2 10 88.97 3.07 50.24 13.95 DR Dime .80 5.2 6 15.43 –.26 35.10 20.75 Candy Galore .33 1.5 28 ?? .18 Using the dividend yield, calculate the closing price for Candy...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Cur div) Hi...
You’ve collected the following information from your favorite financial website. 52-Week Price Stock (Cur div) Hi Lo Div Yld % PE Ratio Close Price Net Chg 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.95 69.60 SIR 2.10 2.4 10 88.99 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 (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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT