Skip to main content

How to Calculate Your Monthly Mortgage Payment

The Basic Formula for Your Monthly Payment

Your monthly mortgage payment comes from a formula that accounts for three things: the loan amount you borrowed, the interest rate your lender charges, and how many months you have to repay it. The formula is called an amortization calculation, and it produces a single number that covers both principal (the money you borrowed) and interest (what the lender charges you for lending it).

The formula itself is: M = P [ r(1 + r)^n ] / [ (1 + r)^n – 1 ], where M is your monthly payment, P is the principal loan amount, r is your monthly interest rate (annual rate divided by 12), and n is the total number of monthly payments. You do not need to memorize or calculate this by hand — a mortgage calculator or spreadsheet does it for you — but understanding what goes into it helps you see why your payment is what it is.

Key Takeaways

  • Your monthly payment depends on three numbers: how much you borrowed, your interest rate, and how many years you have to pay it back.
  • A higher interest rate or shorter loan term raises your monthly payment; a lower rate or longer term lowers it.
  • You can calculate your payment using a mortgage calculator, a spreadsheet formula, or by hand if you have a scientific calculator.
  • Your actual monthly bill may be higher than this calculation because it often includes property taxes, homeowners insurance, and mortgage insurance.
  • Changing any one of the three numbers — loan amount, rate, or term — changes your payment, so you can use this to compare different loan offers.

Gathering the Three Numbers You Need

Before you calculate, write down your loan amount, interest rate, and loan term. The loan amount is the principal — the total you are borrowing after your down payment. If you are buying a $300,000 house and putting down $60,000, your loan amount is $240,000.

Your interest rate comes from your lender's offer. It is usually stated as an annual percentage rate (APR). A 6.5% APR means you pay 6.5% per year on the outstanding balance. The loan term is how many years you have to repay it — typically 15, 20, or 30 years. A 30-year mortgage means 360 monthly payments (30 × 12).

If you are comparing offers from different lenders, you will have different combinations of these three numbers. One lender might offer 6.5% for 30 years; another might offer 6.25% for 30 years or 6.5% for 15 years. Each combination produces a different monthly payment.

Using a Mortgage Calculator

The fastest way to calculate your payment is an online mortgage calculator. You enter your loan amount, interest rate, and loan term, and it shows you the monthly payment instantly. Most calculators also show you a breakdown of how much of each payment goes to principal versus interest, and they let you adjust the numbers to see how different rates or terms change your payment.

Many lenders provide calculators on their websites. You can also find independent calculators through sites like Bankrate, NerdWallet, or your bank's website. The calculation is the same regardless of which calculator you use — the difference is usually in how much extra information they show you (like a full amortization schedule or property tax estimates).

If you want to verify a calculator's result or understand the math, you can also do the calculation in a spreadsheet or by hand, but a calculator is the practical choice for most people.

Calculating by Hand or in a Spreadsheet

If you want to do the math yourself, a spreadsheet like Excel or Google Sheets has a built-in function called PMT that does the amortization calculation for you. The syntax is =PMT(rate, nper, pv), where rate is your monthly interest rate (annual rate ÷ 12), nper is the number of payments (years × 12), and pv is the loan amount (entered as a negative number). For a $240,000 loan at 6.5% annual interest over 30 years, you would enter =PMT(0.065/12, 360, -240000), and the spreadsheet returns your monthly payment.

If you want to calculate by hand without a spreadsheet, you need a scientific calculator because the formula involves exponents. The steps are: divide your annual interest rate by 12 to get your monthly rate; add 1 to that monthly rate; raise it to the power of the number of payments; multiply the original loan amount by the monthly rate; divide that result by the exponent result minus 1. It is doable but tedious, which is why most people use a calculator or spreadsheet instead.

How Interest Rate and Loan Term Change Your Payment

Small changes in interest rate create surprisingly large changes in your monthly payment. On a $240,000 loan over 30 years, a 6.5% rate produces a payment around $1,520 per month (before taxes and insurance). At 6.0%, that same loan drops to roughly $1,440 per month — an $80 difference. At 7.0%, it rises to roughly $1,600 per month. Over 30 years, that $80 monthly difference adds up to nearly $29,000 in total payments.

Loan term works the opposite way: a shorter term raises your monthly payment but lowers your total interest. A 15-year mortgage on $240,000 at 6.5% costs roughly $1,900 per month, compared to $1,520 for 30 years. You pay $380 more each month, but you own the house free and clear 15 years sooner and pay far less interest overall. A 20-year term sits in the middle.

This is why comparing loan offers means looking at all three numbers together, not just the interest rate. A lender offering 6.25% for 30 years and another offering 6.5% for 15 years are not directly comparable — you have to calculate the payment for each to see which fits your budget and goals.

What Your Actual Monthly Bill Includes Beyond the Calculation

The number you calculate is your principal and interest payment — often called P&I. Your actual monthly mortgage bill is usually higher because it includes other costs. Property taxes, homeowners insurance, and mortgage insurance (if your down payment was less than 20%) are often bundled into your monthly payment by your lender, even though they are not technically part of the mortgage itself.

Your lender may collect these costs in an escrow account — they take a portion each month, hold it, and pay the bills on your behalf when they come due. Ask your lender for a Loan Estimate (a document they are required to provide within three days of your application) to see the full monthly payment including taxes, insurance, and any mortgage insurance. The P&I calculation is only part of the picture.

Comparing Offers Using Your Payment Calculation

Once you know how to calculate your payment, you can use it to compare different loan offers side by side. Create a simple table with each lender's loan amount, interest rate, and term, then calculate the monthly P&I for each. This shows you the real cost difference between offers in terms of what you pay each month.

Remember that the lowest interest rate does not always mean the lowest monthly payment if the loan terms are different. A 6.25% rate for 30 years might have a lower monthly payment than 6.5% for 20 years, even though the interest rate is better on the second loan. The calculation reveals which offer actually fits your budget.

You should also ask each lender for their full Loan Estimate, which includes closing costs, property taxes, insurance, and any mortgage insurance. The monthly payment calculation is one piece of the decision; the total cost of the loan is another.

Frequently Asked Questions

Does the mortgage payment calculation include property taxes and insurance?

No. The calculation covers only principal and interest. Property taxes, homeowners insurance, and mortgage insurance are separate costs that your lender may add to your monthly bill. Your Loan Estimate shows the full amount you will pay each month, including all of these.

What happens to my payment if interest rates drop after I lock in my rate?

Your payment stays the same because it is based on the rate you locked in at the time of your loan. If rates drop, you could refinance to a new loan at the lower rate, which would recalculate your payment based on the new rate and remaining balance. Refinancing has its own costs, so it only makes sense if the savings are large enough.

Can I use the payment calculation to figure out how much house I can afford?

The calculation tells you what your monthly payment will be for a given loan amount, but affordability depends on your income, other debts, and savings. Most lenders use a debt-to-income ratio — they want your total monthly debt payments (including the mortgage) to be no more than 43% of your gross monthly income. Use the payment calculation to test different loan amounts and see what fits within that limit.

Why does my actual payment differ from what the calculator showed?

The most common reason is that your actual bill includes property taxes, insurance, and mortgage insurance on top of principal and interest. The calculator usually shows only P&I unless you enter those costs separately. Also, if your interest rate is adjustable (ARM), your payment can change when the rate adjusts. Fixed-rate loans keep the same payment for the entire term.

If I pay extra toward principal each month, does the calculation change?

The calculation itself does not change — your lender still expects the regular monthly payment. But if you pay extra, that extra amount goes directly to principal, which shortens your loan term and reduces the total interest you pay. You do not need to recalculate; just make the extra payment and note it as going to principal.