How would you use what-if analysis tools to determine what Annual Sales Growth you would need to achieve in order to keep prices steady over the eight-year projection period?

Working with Large Worksheets, Charting, and What If Analysis Excel Module 3 EX Table 3-10 August Online Technology Alternative Projections Case Annual Price Increase Annual Sales Growth 4.25% 1 2.00% 2 2.25% 3.00% 3 1.25% 4.00% 2. Close the workbook without saving it and then reopen it. Use the 'What-If Analysis' button (Data tab / Forecast group) to goal seek. Determine a margin that would result in a Year 8 net income of $1,500,000. Save the workbook with your needed changes as Lab 3-1 August Online Technology Eight-Year Financial Projection GS. Submit the workbook with the new values o the results of the goal seek as requested by your instructor. How would you use what-if analysis tools to determine what Annual Sales Growth you would need to achieve in order to keep prices steady over the eight-year projection perioda Working with Large Worksheets, Charting, and What If Analysis Excel Module 3 EX Table 3-10 August Online Technology Alternative Projections Case Annual Price Increase Annual Sales Growth 4.25% 1 2.00% 2 2.25% 3.00% 3 1.25% 4.00% 2. Close the workbook without saving it and then reopen it. Use the 'What-If Analysis' button (Data tab / Forecast group) to goal seek. Determine a margin that would result in a Year 8 net income of $1,500,000. Save the workbook with your needed changes as Lab 3-1 August Online Technology Eight-Year Financial Projection GS. Submit the workbook with the new values o the results of the goal seek as requested by your instructor. How would you use what-if analysis tools to determine what Annual Sales Growth you would need to achieve in order to keep prices steady over the eight-year projection perioda