Skip to main content

The Mortgage Payment Formula and How to Use It

The basic mortgage payment formula

The standard formula for calculating a monthly mortgage payment is:

M = P [ r(1 + r)^n ] / [ (1 + r)^n – 1 ]

Where M is your monthly payment, P is the loan principal (the amount you borrowed), r is your monthly interest rate (annual rate divided by 12), and n is the total number of monthly payments over the life of the loan.

This formula accounts for the fact that each payment covers both principal and interest, with the balance shifting over time. Early payments go mostly toward interest; later payments go mostly toward principal. The formula calculates the single payment amount that will pay off the entire loan by the final payment date.

Key Takeaways

  • The mortgage payment formula requires four pieces of information: loan amount, annual interest rate, loan term in years, and the number of payments per year (usually 12).
  • You must convert the annual interest rate to a monthly rate by dividing by 12 before plugging it into the formula.
  • A spreadsheet or online calculator will do this math for you, but understanding the formula helps you spot errors and see why small rate changes affect your payment.
  • The formula produces only the principal and interest payment; property taxes, insurance, and HOA fees are separate and added on top.

Breaking down each variable in the formula

P (principal) is the amount you are borrowing. If you are putting 20 percent down on a $300,000 house, your principal is $240,000. This is the number that changes most when you shop for a lower purchase price or a larger down payment.

r (monthly interest rate) is your annual rate divided by 12. If your lender quotes you 6.5 percent annually, your monthly rate is 0.065 ÷ 12 = 0.00542 (rounded). This decimal form is what goes into the formula, not the percentage. A difference of 0.5 percent in the annual rate changes your monthly payment by roughly $150 to $300 on a $300,000 loan, depending on the term.

n (number of payments) is your loan term in years multiplied by 12. A 30-year mortgage has 360 payments; a 15-year mortgage has 180 payments. Shorter terms mean higher monthly payments but less total interest paid over the life of the loan.

Working through a concrete example

Suppose you borrow $250,000 at 6 percent annual interest over 30 years.

First, convert the annual rate to a monthly rate: 0.06 ÷ 12 = 0.005. Calculate the number of payments: 30 × 12 = 360. Now plug into the formula:

M = 250,000 [ 0.005(1.005)^360 ] / [ (1.005)^360 – 1 ]

The term (1.005)^360 equals approximately 6.023. So:

M = 250,000 [ 0.005 × 6.023 ] / [ 6.023 – 1 ] = 250,000 [ 0.03012 ] / [ 5.023 ] = 250,000 × 0.005996 = $1,499

Your monthly principal and interest payment would be roughly $1,499. If you change the term to 15 years (180 payments), the same loan at the same rate produces a payment of approximately $1,899 per month — higher each month, but you pay off the loan in half the time and pay far less total interest.

Why you should use a spreadsheet or calculator instead

The formula is mathematically correct, but the exponents and rounding make it error-prone by hand. A spreadsheet like Excel or Google Sheets has a built-in PMT function that does this calculation instantly. In Excel, the syntax is =PMT(rate, nper, pv), where rate is your monthly interest rate, nper is the number of payments, and pv is the loan amount (entered as a negative number).

For the example above, you would enter =PMT(0.005, 360, -250000) and get $1,498.88 in seconds. Online mortgage calculators do the same thing and often show you a breakdown of principal versus interest over time, which helps you understand how your payment is split.

Understanding the formula is useful because it shows you which lever moves the payment most. Lowering the interest rate by 0.5 percent saves you more money than shortening the term by 5 years, for instance. Seeing the formula also helps you catch calculator errors or spot when a lender's quote does not match the math.

What the formula does and does not include

The mortgage payment formula calculates principal and interest only. It does not include property taxes, homeowners insurance, HOA fees, or mortgage insurance (PMI). These are added on top of the principal-and-interest payment to get your total monthly housing cost.

If your lender quotes you a "total monthly payment" of $2,100, that number likely includes taxes and insurance. The formula gives you only the $1,499 portion. Lenders often use the acronym PITI (principal, interest, taxes, insurance) to describe the full payment, so ask which parts are included when you see a quoted number.

How interest rate and term length affect the payment

The formula shows why lenders emphasize rate shopping. A $300,000 loan at 5.5 percent over 30 years costs about $1,703 per month. The same loan at 6.5 percent costs about $1,896 per month — a difference of $193 every month, or $69,480 over the life of the loan. A 0.25 percent rate reduction saves you roughly $40 to $50 per month on a $300,000 loan.

Term length has a different effect. Shortening a 30-year loan to 20 years raises your monthly payment but cuts your total interest paid roughly in half. A 15-year term raises the payment even more but saves you the most interest overall. The formula lets you model these trade-offs before you commit to a rate and term with a lender.

Frequently Asked Questions

Do I need to know this formula to get a mortgage?

No. Lenders and online calculators do the math for you. But understanding the formula helps you verify quotes, compare offers from different lenders, and see why a lower rate or shorter term saves you money. It also helps you spot if a lender's number does not match the math.

Why does the formula use monthly interest rate instead of annual?

Because you make monthly payments, not annual ones. The formula calculates how much each monthly payment covers. If you used the annual rate, the math would be wrong. Always divide the annual rate by 12 before plugging it in.

What if I want to calculate a 20-year mortgage instead of 30?

Change n to 240 (20 years × 12 months). Everything else stays the same. Your monthly payment will be higher, but you will pay off the loan faster and pay less total interest. Use a spreadsheet to compare different terms side by side.

Does this formula work for adjustable-rate mortgages?

The formula calculates a fixed payment for a fixed rate. With an adjustable-rate mortgage (ARM), the rate changes after an initial period, so your payment changes too. The formula works for the fixed-rate period, but you cannot use it to predict payments after the rate adjusts.

How do property taxes and insurance fit into the formula?

They do not. The formula gives you principal and interest only. Taxes and insurance are separate costs that vary by location and your home value. Add them to the principal-and-interest payment to get your total monthly housing cost.