The Basic Formula and What Each Part Means

Your monthly mortgage payment is calculated using a formula that accounts for the loan amount, interest rate, and how many months you have to repay it. The formula is:

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

In this formula: M is your monthly payment, P is the principal (the amount you borrowed), r is your monthly interest rate (your annual rate divided by 12), and n is the total number of monthly payments (your loan term in years multiplied by 12).

This formula assumes a fixed-rate mortgage, where your interest rate stays the same for the entire loan. If you have an adjustable-rate mortgage, your payment will change when the rate adjusts, so this calculation only works for the current rate period.

Key Takeaways

  • Your monthly payment depends on three things: how much you borrowed, your interest rate, and how many years you have to repay it.
  • A higher interest rate or shorter loan term increases your monthly payment; a lower rate or longer term decreases it.
  • Your actual monthly bill includes property taxes, homeowners insurance, and possibly mortgage insurance — the formula above calculates only the principal and interest portion.
  • Online calculators and spreadsheet formulas can do this math for you, but understanding the pieces helps you see how changes affect your payment.
  • Small changes in interest rate create surprisingly large differences in what you pay each month and over the life of the loan.

Working Through a Real Example

Say you borrow $300,000 at 6.5% annual interest over 30 years. Your monthly interest rate is 6.5% divided by 12, which equals 0.00542 (or 0.542%). Your total number of payments is 30 years times 12 months, which equals 360 payments.

Plugging those numbers into the formula: M = 300,000 [ 0.00542(1.00542)^360 ] / [ (1.00542)^360 – 1 ]. The result is approximately $1,896 per month for principal and interest alone.

If that same loan were at 5.5% instead, your monthly payment would drop to roughly $1,703. That 1% difference saves you about $193 per month, or $69,480 over the life of the loan. This is why shopping for the best interest rate matters.

How Loan Term Changes Your Payment

The length of your loan — typically 15, 20, or 30 years — has a major effect on your monthly payment. A shorter loan means you pay off the balance faster, so each monthly payment is larger. A longer loan spreads payments over more months, making each one smaller.

Using the same $300,000 loan at 6.5%: a 15-year mortgage costs about $2,596 per month, while a 30-year mortgage costs about $1,896. The 15-year loan costs $700 more each month, but you pay off the house 15 years sooner and pay roughly $167,000 less in total interest.

There is no universally "right" choice. A 15-year term builds equity faster and costs less in interest, but a 30-year term gives you lower monthly payments and more cash flow for other needs. Your choice depends on your budget and financial goals.

What the Formula Does Not Include

The mortgage payment formula calculates only principal and interest — the amount that goes toward paying back the loan itself and the lender's cost for lending it to you. Your actual monthly mortgage bill usually includes other costs.

Property taxes vary by location and are set by your county or municipality. Homeowners insurance is required by your lender and protects the house against damage. If you put down less than 20%, you will also pay private mortgage insurance (PMI), which protects the lender if you default.

These costs are often bundled into a single monthly payment called PITI (principal, interest, taxes, and insurance). Your lender can give you an estimate of taxes and insurance for your specific property, but the formula above covers only the P and I portion.

Using a Spreadsheet or Calculator Instead

Most people do not calculate this by hand. Spreadsheet programs like Excel or Google Sheets have a built-in function called PMT that does the math when ready. 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 in a spreadsheet: =PMT(0.00542, 360, -300000) returns $1,896.20. Online mortgage calculators work the same way but add fields for taxes, insurance, and HOA fees so you see your full monthly cost.

Calculators are faster and less error-prone than doing the formula by hand, especially when you want to test different scenarios — what if the rate were 5%? What if you borrowed $350,000 instead? What if you chose a 20-year term?

How Interest Rate Affects Total Cost Over Time

The interest rate does not just change your monthly payment — it changes how much you pay in total. On a $300,000 loan over 30 years, the difference between 5.5% and 6.5% is about $193 per month. Over 360 payments, that adds up to $69,480 in extra interest.

This is why even a 0.5% difference in rate is worth negotiating. Locking in a lower rate before closing saves you money every single month for the next 15 or 30 years. If you have the option to pay points (an upfront fee to lower your rate), the math depends on how long you plan to stay in the house — a longer timeline makes paying points more worthwhile.

Adjustable-Rate Mortgages and Payment Changes

An adjustable-rate mortgage (ARM) starts with a lower initial rate, often called a teaser rate, that is fixed for a set period (commonly 3, 5, 7, or 10 years). After that period ends, the rate adjusts periodically — usually once or twice a year — based on market conditions.

When the rate adjusts, your monthly payment recalculates using the new rate. If rates have risen, your payment goes up. If rates have fallen, your payment goes down. The formula stays the same, but the input (your interest rate) changes.

ARMs can be risky because you cannot predict what your payment will be after the initial period. If you have an ARM, use the formula above to estimate what your payment might be if rates rise by 1% or 2%, so you know whether you can afford it if that happens.

Frequently Asked Questions

What is the difference between APR and interest rate?

The interest rate is the cost of borrowing the money itself. The APR (annual percentage rate) includes the interest rate plus other costs like origination fees and points, expressed as an annual rate. For calculating your monthly payment, use the interest rate, not the APR.

Can I pay off my mortgage early without penalty?

Most mortgages allow you to pay extra toward principal without penalty, which shortens your loan term and reduces total interest. Some older mortgages or certain loan types have prepayment penalties, so check your loan documents or ask your lender before making large extra payments.

How much should I put down to avoid PMI?

A 20% down payment is the standard threshold to avoid private mortgage insurance. If you put down less, PMI gets added to your monthly payment. You can sometimes remove PMI later once your equity reaches 20%, but the rules vary by lender and loan type.

Does my credit score affect my monthly payment?

Your credit score does not directly change the payment formula, but it affects the interest rate you are offered. A higher credit score usually qualifies you for a lower rate, which lowers your monthly payment. A lower score may result in a higher rate and a higher payment.

What happens to my payment if I refinance?

Refinancing means taking out a new loan to pay off the old one. Your new monthly payment is calculated using the new loan amount, new interest rate, and new term. You might refinance to lower your rate, change your term, or switch from an ARM to a fixed rate.