calculate the data for 2015 and 2017. Then use the numbers calculated to find the growth rate of each year.

1 HNM # D 3 4 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. 5 Locate this information for your company 6 2017 30% 86% 7 Facts and Assumptions 8 Year 9 Net sales 10 Growth rate in sales 11 Cost of goods soldet sales 12 Gen., sell, and admin. expenseset sales 13 Long-term debt 14 Current portion long-term debt 15 Interest rate 16 Tax rate 17 Dividend/earnings after tax 18 Current assetset sales 19 Net fixed assets 20 Current liabilitieset sales 21 Owners' equity 2015 20 $ 20,613 25000 70% 30% 12% $ 760 $ 660 $ $ 100 $ 100 $ 10% 45% 50% 29% $ 280 $ 14.5% $ 1,730 11% 560 Decrease -10% 100 Stays Constant 10% 45% 50% 29% 270 Decrease -5% 14.4% 2015 2016 2012 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 $ 35,042 10,513 24,529 4,205 231 285 128 156 78 78 $ 10,162 280 34 BALANCE SHEET 35 Current assets 36 Net fixed assets 37 Total assets 38 Current liabilities 39 Long-term debt 10,442 5,081 660 2017 2015 $ 20,613 7 Facts and Assumptions 8 Year 9 Net sales 10 Growth rate in sales 11 Cost of goods soldet sales 12 Gen., sell, and admin. expenseset sales 13 Long-term debt 14 Current portion long-term debt 15 Interest rate 16 Tax rate 17 Dividend/earnings after tax 18 Current assetset sales 19 Net fixed assets 20 Current liabilitieset sales 21 Owners' equity $ $ 760 100 20 25000 70% 30% 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 2015 2012 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 2016 $ 35,042 10,513 24,529 4,205 231 285 128 156 78 78 $ 10,162 280 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 43 EXTERNAL FUNDING REQUIRED 44 45 46 10,442 5,081 660 1,808 6,204 + 1,548 1 HNM # D 3 4 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. 5 Locate this information for your company 6 2017 30% 86% 7 Facts and Assumptions 8 Year 9 Net sales 10 Growth rate in sales 11 Cost of goods soldet sales 12 Gen., sell, and admin. expenseset sales 13 Long-term debt 14 Current portion long-term debt 15 Interest rate 16 Tax rate 17 Dividend/earnings after tax 18 Current assetset sales 19 Net fixed assets 20 Current liabilitieset sales 21 Owners' equity 2015 20 $ 20,613 25000 70% 30% 12% $ 760 $ 660 $ $ 100 $ 100 $ 10% 45% 50% 29% $ 280 $ 14.5% $ 1,730 11% 560 Decrease -10% 100 Stays Constant 10% 45% 50% 29% 270 Decrease -5% 14.4% 2015 2016 2012 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 $ 35,042 10,513 24,529 4,205 231 285 128 156 78 78 $ 10,162 280 34 BALANCE SHEET 35 Current assets 36 Net fixed assets 37 Total assets 38 Current liabilities 39 Long-term debt 10,442 5,081 660 2017 2015 $ 20,613 7 Facts and Assumptions 8 Year 9 Net sales 10 Growth rate in sales 11 Cost of goods soldet sales 12 Gen., sell, and admin. expenseset sales 13 Long-term debt 14 Current portion long-term debt 15 Interest rate 16 Tax rate 17 Dividend/earnings after tax 18 Current assetset sales 19 Net fixed assets 20 Current liabilitieset sales 21 Owners' equity $ $ 760 100 20 25000 70% 30% 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 2015 2012 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 2016 $ 35,042 10,513 24,529 4,205 231 285 128 156 78 78 $ 10,162 280 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 43 EXTERNAL FUNDING REQUIRED 44 45 46 10,442 5,081 660 1,808 6,204 + 1,548