using the interest rate from column B as the Row input cell.
8 On the HomeLoan worksheet, in cell A12, enter a
4 reference to the monthly payment from column B. Create a two-variable data table in the range A12: H16, using the interest rate from column B as the Row input cell and the term in months from column B as the Column input cell.
9 On the HomeLoan worksheet, perform a goal seek
4 analysis to determine what the down payment in column B needs to be if you want the monthly payment in column B to be 2000. Accept the solution.
10 On the HomeLoan worksheet, create a scenario
4 namedMaximum using cells B2, B3, B5, and B6 as the changing cells. Enter these values for the scenario: 280000, 24000, . 075, and 360, respectively. Show the results and close the Scenario Manager. Undo the last change.