Please solve asap, I need chapter 3 lab 1 part 3 done. And table filled out.

Instructions Part 3: Use Goal Seek to analyze three different sales scenarios. If necessary, open the workbook Lab 3-1 August Online Technology Eight-Year Financial Projection. 1. Divide the window into two panes between rows 6 and 7. Use the scroll bars to show both the top and bottom of the worksheet. Using the numbers in columns 2 and 3 of Table 310, analyze the effect of changing the annual sales growth (cell B25) and annual price increase (cell B26) on the net incomes in row 19. Record the answers for each case and submit the results in a form as requested by your instruct

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 or the results of the goal seek as requested by your instructor. 3. 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

CaseSales GrowthPrice IncreaseYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Net IncomeNet IncomeNet IncomeNet IncomeNet IncomeNet IncomeNet IncomeNet Income14.25%2.00%22.25%3.00%31.25%4.00%