Step 2. You figured that you need to make at least $20,000 Net Profit for the 4th Quarter to show the bank that your business is continuously making enough to pay for the loan on your income statement. Select a function of what-if analysis to show how you may reach your goal by determining the amount of Sales and various Expenses in the 4th Quarter in the Income Statement sheet (note that there are pre-set formulas in the table, DO NOT delete them). Step 3. Finally, once you have determined the amount of sales needed to produce a minimum of $20,000 net profit, you want to show the loan managers at which sales location you will try to increase sales to reach your newly determined sales goal for Quarter 4. In order to help you examine location sales, use the Sales Data (from the "Sales Data" tab in spreadsheet) to create a PivotTable (name the new tab "Sales Pivot Table"). Your PivotTable needs to illustrate information that could help you find out the Sum of Sales Amount sold in each Sales Location in Quarter 1, Quarter 2 and Quarter 3, as well as the Grand Total of the quarters. Make