Financial information for four companies is provided in the following table:

Question

a) If you expect that the dividend of each company will grow at rate #2 into the foreseeable future (g is constant), at what price would you be willing to buy each of these stocks?

b) Assume that the companies will grow at rate #1 for the amount of time indicated in the table above. After that, assume that the companies will grow at rate #2 forever. Under these assumptions, what is the price at which you would be willing to buy these companies’ stocks using the two-stage dividend growth model? Calculate your solution twice, first using equation 9-5 on page 260 and then using the FAME_TwoStageValue user-defined function.

c) Assume that the transition between growth rates #1 and #2 will be gradual rather than instantaneous. Using the transition period given in the table, what is the price at which you would be willing to buy these companies’ stocks using the H Model dividend growth model? Calculate your solution twice, the first time using equation 9-8 on page 264 and then using the FAME_HModelValue user-defined function.

d) How does the calculated intrinsic value compare to the quoted price of the stock? Use an IF statement to display whether the stock is undervalued, overvalued, or fairly valued.

Answer 1