show work in excel please

2. A rapidly growing firm is currently paying a dividend of $2.50. The annual dividend growth rate is expected to be 8% for the next year, then 6% for the next 2 years, then 4% for the next 3 years, and 3% thereafter. The expected return on the market is 7%, the risk-free rate is 2% and the firm's Beta is 1.25 . a. Calculate the estimated price (intrinsic value) for a share of this firm's stock. b. If an analyst uses an 8% rule, is this stock overvalued, undervalued, or fairly priced if the current stock price is $57 ? c. Using EXCEL's Text Box Feature explain the purpose of employing a 8% rule in this valuation process