Got this far, and now im lost. Please help!!

Assumptions (use these to drive projected IS and BS 2 Sales Growth % of Current Sales 3 Cost of Goods Sold % of Sales 4 Operating Expense % of Forecast Sales 5 Tax Rate % of EBT 6 Dividend Rate % of NI 7 A/R days 8 Inventory Days 9 Net Fixed Assets % of Forecast Sales 10 Days Payable 11 Accured Liability % of Forecast Sales 12 13 14 15 Net Sales 16 Cost of Goods Sold 17 Gross Profit 18 Operating exp 19 Iterest 20 EBT 21 Taxes (40% 22 Net Income 23 24 Cash Dividends (0% of NI) 25 Added Retained Earnings 26 27 Balance Sheet 28 Required Cash 29 Surplus Cash 30 A/R 31 Inventories 32 Total Current Assets 33 Net Fixed Assets 34 Total Assets 35 36 Accounts Payable 37 Bank Loan 38 Accured Liabili 39 Total Current Liability 40 Long Term Debt 41 Common Stock 42 Retained Earnings 43 Additional Funds Needed (AFN 44 Total Liability &Equit 45 0.25 0.7 166666667 -0.1666667+0.16666667 0.4 0 43 0.15 0.7 0.2 0.4 0 48 0.4 0 45 Actual 2017 15000 -10500 4500 -2500 2019 20700 12075 -14490 6210 -69 2018 17250 2020 25875 18113 7763 12 5175 417 1600 -640 960 1000 0 2000 2200 5200 12000 1600 1800 1200 2200 2400 2800 12000 Project 2018- 2020 Income Statement and Balance Sheet for Minoso. Assumptions: Sales growth rates in each of next 3 years: 15%, 20%, 25% Gross margin and operating expenses/sales percentage stay at 2017 level 40% tax rate No dividends Interest expense fixed at $400 year Bank loan and LT debt stay constant Accounts receivable: for 2018 use year 2017 DSO, then decrease by 3 days in 2019 and by another 2 days in 2020 Inventory: for 2018 use year 2017 DII, then decrease by 2 days in 2019 and another 2 days in 2020 A/P days stays at year 2017 days Net fixed assets and accruals keep relationship with sales . .Required cash fixed at 1000 Calculate Additional Funds Needed as plug (to get Balance Sheet to balance!) Calculate 2017 breakeven revenues and units. Assumptions: All operating expenses are fixed Average price per unit is $50 . . GRADING: You will be assessed both on the accuracy of your projections as well as your proper use of spreadsheet projection etiquette (such as not hard coding numbers into cells). This assignment is worth 10 points. Assumptions (use these to drive projected IS and BS 2 Sales Growth % of Current Sales 3 Cost of Goods Sold % of Sales 4 Operating Expense % of Forecast Sales 5 Tax Rate % of EBT 6 Dividend Rate % of NI 7 A/R days 8 Inventory Days 9 Net Fixed Assets % of Forecast Sales 10 Days Payable 11 Accured Liability % of Forecast Sales 12 13 14 15 Net Sales 16 Cost of Goods Sold 17 Gross Profit 18 Operating exp 19 Iterest 20 EBT 21 Taxes (40% 22 Net Income 23 24 Cash Dividends (0% of NI) 25 Added Retained Earnings 26 27 Balance Sheet 28 Required Cash 29 Surplus Cash 30 A/R 31 Inventories 32 Total Current Assets 33 Net Fixed Assets 34 Total Assets 35 36 Accounts Payable 37 Bank Loan 38 Accured Liabili 39 Total Current Liability 40 Long Term Debt 41 Common Stock 42 Retained Earnings 43 Additional Funds Needed (AFN 44 Total Liability &Equit 45 0.25 0.7 166666667 -0.1666667+0.16666667 0.4 0 43 0.15 0.7 0.2 0.4 0 48 0.4 0 45 Actual 2017 15000 -10500 4500 -2500 2019 20700 12075 -14490 6210 -69 2018 17250 2020 25875 18113 7763 12 5175 417 1600 -640 960 1000 0 2000 2200 5200 12000 1600 1800 1200 2200 2400 2800 12000 Project 2018- 2020 Income Statement and Balance Sheet for Minoso. Assumptions: Sales growth rates in each of next 3 years: 15%, 20%, 25% Gross margin and operating expenses/sales percentage stay at 2017 level 40% tax rate No dividends Interest expense fixed at $400 year Bank loan and LT debt stay constant Accounts receivable: for 2018 use year 2017 DSO, then decrease by 3 days in 2019 and by another 2 days in 2020 Inventory: for 2018 use year 2017 DII, then decrease by 2 days in 2019 and another 2 days in 2020 A/P days stays at year 2017 days Net fixed assets and accruals keep relationship with sales . .Required cash fixed at 1000 Calculate Additional Funds Needed as plug (to get Balance Sheet to balance!) Calculate 2017 breakeven revenues and units. Assumptions: All operating expenses are fixed Average price per unit is $50 . . GRADING: You will be assessed both on the accuracy of your projections as well as your proper use of spreadsheet projection etiquette (such as not hard coding numbers into cells). This assignment is worth 10 points