use the constant growth dividend model to find the value of each firm shown in the following table

Sanders_Zutter_Problem_7-8_Start - Read-Only - Excel AutoSave Data Review View Formulas File Home Insert Page Layout X 14 AA E Times New Roman 2 Wrap Text Paste Merge & Center A. BIU > Clipboard Alignment 5 Font A1 fr D AB E F G 4 5 Firm A 6 Dividend expected next year $ 1.20 4.00 0.65 6.00 7 8 B D Dividend growth rate 8% 5 10 8 8 Required return 13% 15 14 9 20 9 10 E 2.25 11 12 Solution 13 14 15 16 Stock A Dividend expected next year S Dividend growth rate Required return Stock value 1.20 8% 17 13% 18 19 20 Stock B Dividend expected next year $ 21 4.00 Problem 7-8 Type here to search les AutoSave Formulas Data Review File Home Insert Page Layout X A A 2w Times New Roman 14 5 EM Paste BIU Font Alignment Z Clipboard A1 E A B D C 20 21 Stock B Dividend expected next year $ Dividend growth rate Required return Stock value 4.00 5% 15% 22 23 24 25 26 27 28 Stock C Dividend expected next year S Dividend growth rate Required return Stock value 0.65 10% 14% 29 30 31 32 33 34 Stock D Dividend expected next year S Dividend growth rate Required return Stock value 6.00 8% 900 35 36 37 38 199 Stock E Dividend expected next vearls Probleme 2.25 AutoSave Sanders Zutter Problem_7-8_Start - Read-Only - Excel p Search File Home Insert Page Layout Formulas Data Review View Help X Times New Roman 14 AA Wrap Text SEE Merge & Center General $ - % -58-88 BIU- a.A- Clipboard Font Alignment Number A1 > AB D 37 38 39 40 Stock E Dividend expected next year S Dividend growth rate Required return Stock value 2.25 896 20% 42 43 44 46 4 45 Requirements 1 In cell E18, by using cell references to the given data, calculate the value of stock A. 2 In cell E24, by using cell references to the given data, calculate the value of stock B. 3 In cell E30, by using cell references to the given data, calculate the value of stock C. 4 In cell E36, by using cell references to the given data, calculate the value of stock D. 5 In cell E42, by using cell references to the given data, calculate the value of stock E. 6 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed 49 50 51 52 53 54 55 Problem 7.3 Type here to search O e **