Which of the following is NOT a best practice for financial model inputs? Add comments to cells to give more information Use colour to separate inputs from outputs Data should only be entered once Protect inputs by locking input cells 2 Complex financial models are all of the following EXCEPT: They typically model most outputs from first principles They are more prone to error due to size and complexity They are easy to follow and audit They offer users a high degree of precision 3 Forecast the 2019 Cost of goods sold on the previous year's number and the assumptions 2018 Actual 2019 Estimate Sales Growth 6% 8% Gross Margin 40% 40% 50,000 Revenues Cost of Goods Sold 27,000 26,630 29,160 32,400 35,200 O00 4 Forecast the accounts receivable for Company XYZ using the following annual information. Receivable days assumption = 55 days Payable days assumption = 69 days %3D Forecasted revenue = $263,500 Forecasted cost of goods sold = $114,780 17,296 49,812 39,705 21,698 5 What formula below can be used to forecast inventory? (Inventory days / Cost of sales) x 365 (Inventory days / 365) x Cost of sales (Inventory / Cost of sales) x 365 (Inventory days / 365) / Cost of sales