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 firm's Beta is 0.90. a. Calculate the estimated price (intrinsic value) for a share of this firm's 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 EXCEL's Text Box Feature explain the purpose of employing a 6% rule in this valuation process