need help woth excel formulas

Maloney, Inc., has an odd dividend policy. The company has just paid a dividend of $3.50 per share and has announced that it will increase the dividend by $4.50 per share for each of the next five years, and then never pay another dividend. If you require a return of 11 percent on the company's stock, how much will you pay for a share today? Current dividend Dividend growth Required return S $ 3.50 4 50 11% Complete the following analysis. Do not hard code values in your calculations. Dividend Year 1 2 3 4 5 Saved Help Save & Ex 8 In yuwun Required return 11% 9 Complete the following analysis. Do not hard code values in your calculations. 10 11 12 13 14 15 Dividend Year 1 2. 3 4 5 16 17 18 19 Share price 20 21 22 23 Sheet1 100 DEADY