Please show via excel

2. A stock is currently selling for $45, pays a dividend of $2.75. Dividends are expected to grow at a constant rate of 2.5% a year. Investors require an 10% rate of return. a. Calculate the intrinsic value (estimated price) for this stock. b. If an analyst uses a 16% rule i. At what price range would this stock be considered to be overvalued? ii. At what price range would this stock be considered to be undervalued? ili. At what price range would this stock be considered to be fairly priced? iv. Is this stock overvalued, undervalued, or fairly priced? V. What is the purpose of employing a 16% rule in this valuation process