Please answer only in Excel and show the steps that lead to the answer

2 You buy a share of Microdrive for $81.21 per share. You expect it to pay dividends of $4.50, $4.725 and $4.96125 in years1, 2 and 3 respectively. You expect to sell the investment in 3 years for $94.01. 3 4 5 a. Calculate the growth rate in dividends 6 7 b. Calculate the expected dividend yield 8 9 c. What is the stock's total expected rate of return? (Assume the market is in equilibrium with the required return equal to the expected return.) 10 11 12 13 14