Use this data to calculate 2016 based on 2015 actuals. Note: you will need to modify: Long-term Debt, Current long-term debt and Net Fixed Assets based on your company's data. Locate this information for your company 20 2017 2015 $ 20,613 Facts and Assumptions Year Net sales Growth rate in sales Cost of goods soldet sales Gen., sell, and admin. expenseset sales Long-term debt Current portion long-term debt Interest rate Tax rate Dividend/earnings after tax Current assetset sales Net fixed assets Current liabilitieset sales lOwners' equity $ $ 760 $ 100 $ 35% 86% 12% 660 $ 100 $ 10% 45% 50% 29% 280 $ 14.5% 30% 86% 11% 560 Decrease - 10% 100 Stays Constant 10% 45% 50% 29% 270 Decrease -5% 14.4% $ 1.730 B B D E IL F G H 2015 2017 Complete the formulas to calculate 2017 estimates) 22 INCOME STATEMENT 23 Year 24 Net sales 25 Cost of good sold 26 Gross profit 27 Gen., sell, and admin. exp. 28 Interest expense 29 Earnings before tax 30 Tax 31 Earnings after tax 32 Dividends paid 33 Additions to retained earnings 34 BALANCE SHEET 35 Current assets 36 Net fixed assets 37 Total assets 38 Current liabilities 39 Long-term debt 40 Equity 41 Total liabilities and shareholders' equity 42 2016 $ 27,828 23,932 3,896 3,339 76 481 216 264 132 132 $ 8,070 280 8,350 4,035 660 1,862 6,557 12 LEYTEDNAL CUINNINC DEOLIDEN 1 702