Complete the excel.

INCOME STATEMENT 1 Sales 2 COGS 3 Depreciation expense 4 Total operating costs 5 EBIT 6 Less interest 7 Earnings before taxes (EBT) 8 Taxes (40%) 11 Net Income 12 Shares of common equity 13 Dividends per share 14 Dividends to common 15 Additions to retained earnings Actual 2016 $ 7,500.00 $ 5,625.00 375.00 6,000.00 1,500.00 63.00 1,437.00 574.80 862.20 62.50 $ 2.50 $ 156.25 $ 705.95 Actual 2016 30.00 543.75 787.50 1,361.25 1,350.00 2,711.25 BALANCE SHEET ASSETS 1 Cash 2 Short-term investments 3 Accounts receivable 4 Inventories 5 Total Current Assets 6 Net plant & equipment 7 Total Assets LIABILITIES & EQUITY 8 Accounts payable 9 Accruals 10 Notes payable 11 Total current liabilities 12 Long-term bonds 13 Total liabilities 15 Common stock 16 Retained earnings 17 Total common equity 18 Total liabilities & equity 187.50 262.50 155.00 605.00 525.00 1,130.00 643.75 937.50 1,581.25 2,711.25 $ $ $ 2017 Forecast 2017 Revised % SALES 10.00% Increase 12.00% UT Debt 2 INCOME STATEMENT Sales COGS Depreciation expense Total operating costs EBIT Less interest Earnings before taxes (EBT) Taxes (35%) Net Income Shares of common equity Dividends per share Dividends to common 15 Additions to retained earnings Actual 2016 $ 9,000.00 $ 6,750.00 $ 450.00 $ 7,200.00 1,800.00 75.60 1,724.40 603.54 1,120.86 75.00 3.00 1 225.00 895.86 13 5.00% increase 2 Actual 2016 % SALES 2017 Forecast 2017 Revised $ 36.00 2 $ 652.50 945.00 1,633.50 1,620.00 3,253.50 $ BALANCE SHEET ASSETS Cash Short-term investments 3 Accounts receivable 4 Inventories 5 Total Current Assets Net plant & equipment Total Assets LIABILITIES & EQUITY Accounts payable Accruals 10 Notes payable Total current liabilities 12 Long-term bonds 13 Total liabilities 14 Common stock 15 Retained earnings 16 Total common equity Total liabilities & equity 8 11 225.00 315.00 186.00 726.00 630.00 1,356.00 772.50 1,125.00 1,897.50 3,253.50 $ $ $ $ $ From IS 4 18 19 20 Additional funds needed (AFN) Required additional notes payable Additional short-term investments RRL AFN = 12 points A*ISO = L*ISO =