problem 9-8 excel project
Search AutoSave OM File Insert Data Sanders_Zutter_Problem_9-8_Start - Protected View - Excel Home Page Layout Formulas Review View help PROTECTED VIEW Be careful_files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protect Xf A1 AB D H Points 1 60 1 61 62 1 1 64 65 1 - 58 59 Requirements 1 In cell E19, by using cell references to the given data, calculate the dividend payment of preferred stock A. 2 In cell E20, by using cell references to the given data, calculate the proceeds from sale of preferred stock A 3 In cell E21, by using cell references to the given data, calculate the cost of preferred stock A. 4 In cell E28, by using cell references to the given data, calculate the dividend payment of preferred stock B 5 In cell E29, by using cell references to the given data, calculate the proceeds from sale of preferred stock B 6 In cell E30, by using cell references to the given data, calculate the cost of preferred stock B. 7 In cell E37, by using cell references to the given data, calculate the proceeds from sale of preferred stock C. 8 In cell E38, by using cell references to the given data, calculate the cost of preferred stock C. 9 In cell E44, by using cell references to the given data, calculate the flotation cost of preferred stock D 10 In cell E46, by using cell references to the given data, calculate the proceeds from sale of 69 preferred stock D 70 11 In cell E47, by using cell references to the given data, calculate the cost of preferred stock D. 12 In cell E54, by using cell references to the given data, calculate the dividend payment of preferred stock E 13 In cell E55, by using cell references to the given data, calculate the proceeds from sale of 72 preferred stock E. 14 In cell E56, by using cell references to the given data, calculate the cost of preferred stock E. 15 Save the workbook. Close the workbook and then exit Excel Submit the workbook as directed 75 66 67 1 1 58 1 71 1 - 73 0 Problem 9.3 Type here to search Sanders_Zutte_Problem_9-8_Start - Protected View - Excel AutoSave Formulas Data Review View Help File Home Insert Page Layout PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's a X Fax A1 H D F E A B Problem 9-8 2 3 Cost of preferred stock. Determine the cost for each of the following preferred stocks. 4 5 6 7 Preferred stock B D E Flotation Annual Par value Sale price cost dividend $ 100 $ 101 $ 9.00 11% 40 38 S 3.50 8% 35 37 $ 4.00 $ 5.00 30 26 5% of pars 3.00 20 20 $ 2.50 9% 8 9 10 11 12 Solution 13 14 15 S S 100 101 16 17 S Stock A Par value Sale price Flotation cost Annual dividend Dividend payment Proceed from sale Cost of preferred stock 9.00 11% 18 19 20 21 22 23 S 25 Stock B Par value Sale price Flotation net Problem 9-8 S 40 3S 350 26 S Sanders_Zutter_Problem_9-9_Start - Protected AutoSave Review View Fores Data Insert Page Layout File Home PROTECTED VIEW Be careful-files from the Internet can contain virus. Unless you need fo Al H F E A B 23 $ 24 25 40 38 3.50 8% S D Stock B Par value Sale price Flotation cost Annual dividend Dividend payment Proceed from sale Cost of preferred stock 26 27 28 29 30 31 32 35 33 S S S 34 Stock C Par value Sale price Flotation cost Annual dividend Proceed from sale Cost of preferred stock 37 4.00 5.00 35 36 37 S 38 39 40 S 41 42 S 30 26 5 43 Stock D Par value Sale price Flotation cost of par) Flotation cost Annual dividend Proceed from sale Cost of preferred stock 44 45 S 3.00 46 47 48 Pudblom AutoSave Sanders Zutter_Problem_9-8_Start - Protecte: Home File Insert Formulas Page Layout Vi Data Review PROTECTED VIEW Be careful_files from the Internet can contain viruses. Unless you nee A1 fx A B D F E 39 40 41 S 42 S 30 26 5% 43 Stock D Par value Sale price Flotation cost (% of par) Flotation cost Annual dividend Proceed from sale Cost of preferred stock 45 S 3.00 46 47 48 49 50 S S 51 20 20 2.50 9% 52 Stock E Par value Sale price Flotation cost Annual dividend Dividend payment Proceed from sale Cost of preferred stock S 53 54 55 56 57 58 59 Requirements 1 In cell E19. by using cell references to the given data, calculate the dividend p 60 preferred stock A 2. In cell E20. by using cell references to the given data, calculate the proceeds i 61 preferred stock A 62 3. In cell E21 by using cell references to the given data, calculate the cost of pre
