ibm paid 1.50 per share in dividends this year analysts expect that the market return and the risk free rate would be 8% and 3% respectively for the next two centuries als o the dividend growth rates and the beta of ibm are expected to change as shown in the table belowPlease show how to do in excel using VLOOKUP

6-10 Years Growth Rate of Earnings Beta 1-5 11-1516-20 21-oo 9% 0.8 11% 0 12% 2% 0.7 0.6 Using the given information, answer the following questions. a. What is the expected dividend at year 10? b. By using CAPM, calculate the appropriate required rate of return of IBM(RRR) at year 21. The equation of an expected RRR isRRR R, + *(R,-Rf), where Rf, . and R represent risk free rate, beta, and the market rate of return, respectively c. Find the present value of dividend that will be paid at year 25 d. What is the cumulative present value of dividends at year 16? e. What is the expected price of IBM stOCK nOW