Need help with financial data analysis

Sheet1

Facts and Assumptions
Year	2015	2016	2017
Net sales	$ 20,613
Growth rate in sales	35%	30%
Cost of goods sold/net sales	86%	86%
Gen., sell,, and admin. expenses/net sales	12%	11%
Long-term debt	$ 760	$ 660	$ 560	Decrease -10%
Current portion long-term debt	$ 100	$ 100	$ 100	Stays Constant
Interest rate	10%	10%
Tax rate	45%	45%
Dividend/earnings after tax	50%	50%
Current assets/net sales	29%	29%
Net fixed assets	$ 280	$ 270	Decrease -5%
Current liabilities/net sales	14.5%	14.4%
Owners' equity	$ 1,730
INCOME STATEMENT
Year	2015	2016	2017
Net sales	$ 27,828
Cost of good sold	23,932
Gross profit	3,896
Gen., sell,, and admin. exp.	3,339
Interest expense	231
Earnings before tax	285
Tax	128
Earnings after tax	156
Dividends paid	78
Additions to retained earnings	78
BALANCE SHEET
Current assets	$ 8,070
Net fixed assets	280
Total assets	8,350
Current liabilities	4,035
Long-term debt	660
Equity	1,808
Total liabilities and shareholders' equity	6,204
EXTERNAL FUNDING REQUIRED	$ 1,548

Locate this information for your company

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.

Complete the formulas to calculate 2017 estimates)