# monthly mortgage payment formula

### Contents

Example: Calculating a Monthly Car Payment in Excel. Calculating a monthly car payment is similar to figuring a monthly mortgage payment. To start, you will need the interest rate, length of loan, and the amount borrowed. For this example, let’s say the car loan is for \$32,000 over five years at a 3.9% interest rate:

To figure out how much you must pay on the mortgage each month, use the following formula: "= -PMT(Interest Rate/Payments per Year,Total Number of Payments,Loan Amount,0)". For the provided screenshot, the formula is "-PMT(B6/B8,B9,B5,0)". If your values are slightly different, input them with the appropriate cell numbers.

A 15-year mortgage will have a higher monthly payment but a lower interest rate than a 30-year mortgage. Because you pay more toward the principal amount each month, you‘ll build equity in your home faster, be out of debt sooner, and save thousands of dollars in interest payments.

Since we were able to put down a nice sum for the down payment and we lucked out and got a good deal on an interest rate for our mortgage loan, we’re lucky that our monthly payments. Finance.