c D F K fx A B E G H 4 5 Requirements 46 1 In cell E18, by using cell references to the given data, calculate the value of stock A. 47 2 In cell E24, by using cell references to the given data, calculate the value of stock B. 48 3 In cell E30, by using cell references to the given data, calculate the value of stock C. 49 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. Points 1 1 50 1 1 51 0 52 53 54 55 B G H 1 L M N Problem 7-8 1 2 Common stock value: Constant growth. Use the constant-growth dividend model (Gordon growth model) to find the value of each firm shown in the following table. 3 2. s Firm A Dividend expected next year S 1.20 4.00 0.65 Dividend growth rate 8% 5 6 7 B Required return 13% 15 14 9 20 8 10. 6.00 D E 8 8 2.25 11 ber Tables N23 Can AB D E F G H I 12 Solution K L 13 14 15 16 Stock A Dividend expected next yea S Dividend growth rate Required return Stock value 1.20 8% 13% 18 19 20 21 22 Stock B Dividend expected next yea $ Dividend growth rate Required return Stock value 4.00 5% 15% 23 124 25 AB D E E F G H 25 26 27 28 Stock Dividend expected next yea $ Dividend growth rate Required return Stock value 0.65 10% 14% 29 30 31 32 33 34 Stock D Dividend expected next yea S Dividend growth rate Required return Stock value 6.00 8% 9% 35 36 37 38 Stock E Dividend expected next yea $ 39 2.25 A FULLLLL LLLLL Undo Clipboard Font Alignment Number Tables 123 A B C D E F G Stock value 30 31 33 34 Stock D Dividend expected next yea $ Dividend growth rate Required return Stock value 6.00 8% 9% 35 36 37 38 39 40 Stock E Dividend expected next yea $ Dividend growth rate Required return Stock value 2.25 8% 20% 41 43 44 Problem 7-8 +