A rapidly growing firm is currently paying a dividend of $1.95. The annual dividend growth rate is expected to be 6% for the next 2 years, then 4% for the next 3 years, and 3% thereafter. The expected return on the market is 8%, the risk-free rate is 2% and the firms Beta is 0.90.

a. Calculate the estimated price (intrinsic value) for a share of this firms stock.

b. Use Goal Seek to determine what the current dividend would need to be to yield an estimated price (intrinsic value) of $95.

c. If an analyst uses a 6% rule, why is this stock overvalued, undervalued, or fairly priced if the current stock price is $60?

d. Using EXCELs Text Box Feature explain the purpose of employing a 6% rule in this valuation process?