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 .