Can anyone answer this question using 4 tables ??

TABLE 1 Idexo's 2016 Income Statement and Balance Sheet 2016 2016 100,000 15,000 20,000 8.219 43,219 60,000 1 Year 2 Income Statement (5000s) 3 Sales 4 Cost of Goods Sold 5 Raw Materials 6 Direct Labor Costs 7 Gross Profit 8 Sales and Marketing 9 Administration 10 EBITDA 11 Depreciation 12 EBIT 13 Interest Expense (net) 14 Pretax Income 15 Income Tax 16 Net Income 1 Year 2 Balance Sheet (5000s) 3 Assets 4 Cash and Cash Equivalents 5 Accounts Receivable 6 Inventories 7 Total Current Assets 8 Property. Plant, and Equipment 9 Goodwill 10 Total Assets 11 Liabilities and Stockholders' Equity 12 Accounts Payable 13 Debt 14 Total Liabilities 15 Stockholders' Equity 16 Total Liabilities and Equity -21,333 - 24,000 54,667 -15,000 -18.000 21,667 -6,667 15,000 -1,021 13,979 -4,893 9,086 103,219 6,205 20,000 26,205 77,014 103,219 TABLE 2 Idexo's Sales and Operating Cost Projections 2016 2017 2018 2019 2020 2021 20.000 21.200 22.472 23,820 25.250 26,765 10.0% 11.0% 12.0% 13.0% 14.0% 14.0% 50.00 51.00 52.02 53.06 54.12 55.20 1 Year 2 Sales Data Growth/Yr 3 Market Size (000s units) 6.0% 4 Market Share *1.0% 5 Average Sales Price (S/unit) 2.00% 6 7 Operating Expense and Tax Data 8 Gross Margin 9 Sales and Marketing (% sales) 10 Administration (% sales) 11 Tax Rate 54.7% 53.0% 53.0% 53.0% 53.0% 53.0% 15.0% 16.5% 18.0% 19.5% 20.0% 20.0% 18.0% 15.0% 15.0% 14.0% 13.0% 13.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% *Market Share growth is expected through 2020 only. TABLE 3 Idexo's Capital Expenditure Forecast 2016 2017 2018 2019 2020 2021 1 Year 2 Fixed Assets and Capital Investment (5000s) 3 Opening Book Value 4 Capital Investment 5 Depreciation 6 Closing Book Value 60,167 60,000 58.500 57,150 73,935 77,341 6,500 5.000 5,000 25.000 12.000 8,000 -6,667 -6,500 -6,350 -8,215 -8,594 -8,534 60.000 58,500 57,150 73,935 77,341 76,807 TABLE 4 Idexo's Debt and Interest Forecast 2016 2017 2018 2019 2020 2021 1 Year 2 Debt and Interest Table (5000s) 3 Outstanding Debt 4 Interest on Term Loan 6.80% 20.000 20.000 20.000 35,000 40.000 40.000 -1,360 -1,360 -1,360 -2,380 -2.720 Use the following spreadsheet to project Idexo's working capital needs over the next five years. Why is the increase in net working capital negative in 2017? Why does the increase in net working capital decline from 2017 to 2018? 2016 2017 2018 2019 2020 2021 1 Year 2 Working Capital (5000s) 3 Assets 4 Accounts Receivable 5 Inventories 6 Minimum Cash Balance 7 Total Current Assets 8 Liabilities 9 Accounts Payable 10 Net Working Capital 11 Increase in Net Working Capital 20.000 8,219 8.219 36,438 6,205 30.233 TABLE 1 Idexo's 2016 Income Statement and Balance Sheet 2016 2016 100,000 15,000 20,000 8.219 43,219 60,000 1 Year 2 Income Statement (5000s) 3 Sales 4 Cost of Goods Sold 5 Raw Materials 6 Direct Labor Costs 7 Gross Profit 8 Sales and Marketing 9 Administration 10 EBITDA 11 Depreciation 12 EBIT 13 Interest Expense (net) 14 Pretax Income 15 Income Tax 16 Net Income 1 Year 2 Balance Sheet (5000s) 3 Assets 4 Cash and Cash Equivalents 5 Accounts Receivable 6 Inventories 7 Total Current Assets 8 Property. Plant, and Equipment 9 Goodwill 10 Total Assets 11 Liabilities and Stockholders' Equity 12 Accounts Payable 13 Debt 14 Total Liabilities 15 Stockholders' Equity 16 Total Liabilities and Equity -21,333 - 24,000 54,667 -15,000 -18.000 21,667 -6,667 15,000 -1,021 13,979 -4,893 9,086 103,219 6,205 20,000 26,205 77,014 103,219 TABLE 2 Idexo's Sales and Operating Cost Projections 2016 2017 2018 2019 2020 2021 20.000 21.200 22.472 23,820 25.250 26,765 10.0% 11.0% 12.0% 13.0% 14.0% 14.0% 50.00 51.00 52.02 53.06 54.12 55.20 1 Year 2 Sales Data Growth/Yr 3 Market Size (000s units) 6.0% 4 Market Share *1.0% 5 Average Sales Price (S/unit) 2.00% 6 7 Operating Expense and Tax Data 8 Gross Margin 9 Sales and Marketing (% sales) 10 Administration (% sales) 11 Tax Rate 54.7% 53.0% 53.0% 53.0% 53.0% 53.0% 15.0% 16.5% 18.0% 19.5% 20.0% 20.0% 18.0% 15.0% 15.0% 14.0% 13.0% 13.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% *Market Share growth is expected through 2020 only. TABLE 3 Idexo's Capital Expenditure Forecast 2016 2017 2018 2019 2020 2021 1 Year 2 Fixed Assets and Capital Investment (5000s) 3 Opening Book Value 4 Capital Investment 5 Depreciation 6 Closing Book Value 60,167 60,000 58.500 57,150 73,935 77,341 6,500 5.000 5,000 25.000 12.000 8,000 -6,667 -6,500 -6,350 -8,215 -8,594 -8,534 60.000 58,500 57,150 73,935 77,341 76,807 TABLE 4 Idexo's Debt and Interest Forecast 2016 2017 2018 2019 2020 2021 1 Year 2 Debt and Interest Table (5000s) 3 Outstanding Debt 4 Interest on Term Loan 6.80% 20.000 20.000 20.000 35,000 40.000 40.000 -1,360 -1,360 -1,360 -2,380 -2.720 Use the following spreadsheet to project Idexo's working capital needs over the next five years. Why is the increase in net working capital negative in 2017? Why does the increase in net working capital decline from 2017 to 2018? 2016 2017 2018 2019 2020 2021 1 Year 2 Working Capital (5000s) 3 Assets 4 Accounts Receivable 5 Inventories 6 Minimum Cash Balance 7 Total Current Assets 8 Liabilities 9 Accounts Payable 10 Net Working Capital 11 Increase in Net Working Capital 20.000 8,219 8.219 36,438 6,205 30.233