The financial requirements are calculated using best estimates. However, you typically will also consider other contingencies in order to be better prepared. To illustrate this type of analysis, recalculate 2016 funds requirements using the percent of sales approach for all 9 feasible scenarios based on following variations: Sales growth = 5%, 15%, 25% Total operating costs/Sales = 90%, 95%, 100% Just change cells G90 and G91 and print the forecasted B/S, income statements and AFN. Retain all the other assumptions the firm maintains current operating ratios for assets and accounts payables and accruals, dividends will grow at 15%, deficits will be financed by new line of credit at 10%, etc. The report should include a 3 x 3 (sales growth vs. Operating Costs) table summarizing the AFN for the 9 scenarios. Include just the B/S and income statement (cells A101:H141) for each of the 9 scenarios in the Appendix