Filled out excel and answer question 3 short answer thank you

Effect of financing on earnings per share Three different plans for financing an $80,000,000 corporation are under consideration by its organizers. Under each of the following plans, the securities will be issued at their par or face amount, and the income tax rate is estimated at 40% of income: Plan 1 Plan 2 Plan 3 9% Bonds $40,000,000 Preferred 5% stock, $25 par $40,000,000 20,000,000 Common stock, $20 par $80,000,000 40,000,000 20,000,000 Total $80,000,000 $80,000,000 $80,000,000 Instructions 1. Determine for each plan the earnings per share of common stock, assuming that the income before bond interest and income tax is $10,000,000. 2. Determine for each plan the earnings per share of common stock, assuming that the income before bond interest and income tax is $6,000,000. 3. Discuss the advantages and disadvantages of each plan. Ivy ver. Ivy v TIJ Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded. Enter a zero in cells you would otherwise leave blank. 1. Earnings per Share of Common Stock Plan 1 Plan 2 Plan 3 Earnings before bond interest and income tax Bond interest Income before income tax Income tax Net income Dividends on preferred stock Earnings available for common stock + Shares of common stock outstanding Earnings per share on common stock $ 4,000,000 6,000,000 $ 6,000,000 $ 4,000,000 $ 1.50 $ 4,000,000 $ 2,560,000 3,840,000 4,000,000 #REF! $ 2,840,000 2,000,000 1,000,000 $ 2.00 $ 2.84 2. Earnings per Share of Common Stock Plan 1 Plan 2 Plan 3 Earnings before bond interest and income tax Bond interest Income before income tax Income tax Net income Dividends on preferred stock Earnings available for common stock Shares of common stock outstanding Earnings per share on common stock