Create a tool to calculate the operating breakeven point in units, using the data table below: All your formulas should reference the data cells in the table. If you change the data in the table, the answer should recalculate correctly. Fixed cost per period Selling price per unit Variable cost per unit Breakeven point in units (Test your tool by entering $23,597.00 for fixed cost, $109.99 for selling price, and $23.24 for variable cost. The breakeven point should be 272.01 units.) Create a tool to calculate the degree of operating leverage, using the data table below: All your formulas should reference the data cells in the table. If you change the data in the table, the answer should recalculate correctly. Sales revenue Total variable operating costs Fixed operating costs 2 Degree of operating leverage (Test your tool by entering $12,355 for fixed cost, $125,840 for sales revenue, and $93,000 for total variable cost. The degree of operating leverage should be 1.60) Create a tool to calculate the degree of financial leverage, using the data table below: All your formulas should reference the data cells in the table. If you change the data in the table, the answer should recalculate correctly. EBIT Interest expense Preferred dividends Tax rate 3 (Test your tool by entering $23,800 for EBIT, $7,100 for preferred dividends, interest expense of $3,500, and tax rate of 21% The degree of financial leverage should be 2.10) 3 M (Test your tool by entering $23,800 for EBIT, S7,100 for preferred dividends, interest expense of $3,500, and tax rate of 21% The degree of financial leverage should be 2.10) Create a tool to: 4) complete the income statement 5) calculate DOL 6) Calculate DFL 7) Calculate DTL All your formulas should reference the data cells in the table. I have entered test data in the table for you already. (The DTL should be 2.74) If you change the data in the table the answer should recalculate correctly. Tax rate Sales revenue Total variable operating costs Total fixed operating costs Interest expense Preferred dividends 2196 10000 4000 2500 800 400 Paste General St Format Painter BIU Menge a Center - 5 $ - % 90 Conditional Formats Cell Formatting Table Styles IntDelete Cipboard F Font Alignment be KSS - A B H M 55 56 57 58 59 FO D Total fixed operating costs Interest expense Preferred dividends G 2500 800 400 2 3 25 4 Income statement Sales revenue Total variable operating costs Total fixed operating costs Operating income Interest expense Income before taxes Tax expense Net income Preferred dividends Earnings available to common 7 18 79 0 1 2 94 2 5 DOL 36 2 6 DFL 38 2 7 DTL 39 30 Sheet1 (0) 0 II 0 20 Type here to search