As an analyst at Churnem & Burnem Securities, you are responsible for making recommendations to your firm's

Question:

As an analyst at Churnem & Burnem Securities, you are responsible for making recommendations to your firm's clients regarding common stocks. After gathering data on Denver Semiconductors, you have found that its dividend has been growing at a rate of 8% per year to the current (D0) $0.75 per share. The stock is now selling for $24 per share, and you believe that an appropriate rate of return for this stock is 12% per year.
a. If you expect that the dividend will grow at an 8% rate into the foreseeable future, what is the highest price at which you would recommend purchasing this stock to your clients?
b. Suppose now that you believe that the company's new product line will cause much higher growth in the near future. Your new estimate is for a three-year period of 20% annual growth to be followed by a return to the historical 8% growth rate. Under these new assumptions, what is the value of the stock using the two-stage dividend growth model?
c. You now realize that it is likely that the growth will transition from 20% down to 8% gradually, rather than instantaneously. If you believe that this transition will take five years, what is the value of the stock today? Use the three-stage growth model.
d. For each of the answers from above, create an IF statement that shows whether the stock is undervalued, overvalued, or fairly valued.
Dividend
A dividend is a distribution of a portion of company’s earnings, decided and managed by the company’s board of directors, and paid to the shareholders. Dividends are given on the shares. It is a token reward paid to the shareholders for their...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Financial Analysis with Microsoft Excel

ISBN: 978-1111826246

6th edition

Authors: Timothy R. Mayes, Todd M. Shank

Question Posted: