A mortgage lender requires a 20% down payment and is offering a 30-year loan with a 3. 5% interest rate. Which excel function can you use to calculate the maximum purchase price you can afford?.