Having a little trouble figuring out this problem. Could anyone explain how you got the numbers and not hard code it into a worksheet (not hard coding numbers into cells.) Please and thank you

+0 X B Bac X wk3 X Bb Wec X wk5 X wk5 X wk5 X My X Aut X 362466-dt-content-rid-15060237 1/courses/ENTR4640.061 FA19/wk5-HW1-instructions.pdf ENTR 4640 Homework 1: Forecasting In this assignment you will create a forecast for the Minoso Corporation using the attached spreadsheet template. Input the following as assumptions in the assumption part of the spreadsheet (grey highlighted cells at the top of the spreadsheet) and then reference those cells when projecting the appropriate income statement, balance sheet, or break-even account. Do NOT hard code numbers into your projections Project 2018-2020 Income Statement and Balance Sheet for Minoso. sur 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, LT debt, and common stock 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 DI, 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 Ignore surplus cash 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. 3 OFFICIAL 30SEPT19.xlsx shipment items (9) csv part 1 jpg wk5-HW1-termplate Help Tell me what you want to do Insert Formulas Data Review Viow File Home Draw Page Layout Cut 12 A A ab General Calibri Wrap Text Copy A Paste BIU Merge & Center $% .0 Format Painter Alignment Number Font . Clipboard fox X E5 C Assumptions (use these to drive projected IS and BS) E D E F G A 1 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 0.15 0.2 0.25 12 ->>>>>>>>>>>> Actual