Miranda also wants to use defined names in other calculations to help her interpret the formulas. In the range D3:D7, create defined names based on the values in the range C3:C7. Miranda wants to calculate the monthly payment for a loan to purchase the Beecher Street house at the most favorable interest rate she found online. Calculate the payment as follows: In cell D5, start to enter a formula using the PMT function. For the rate argument, divide the Rate by 12 to use the monthly interest rate. For the nper argument, use the Term_in_Months to specify the number of periods. For the pv argument, use the Loan_Amt to include the present value. Insert a negative sign (-) after the equal sign in the formula to display the result as a positive amount.New House Nortgage Calculator

New House Nortgage Calculator