1: to optimize the monthly payments, you would designate the home cost, down payment, APR, and number of years for the loan as the variable cells. 2: Given an interest rate, the number of years, and a planned down payment, you would use monthly payment. to find the highest cost of a house you can afford while maintaining the