Skip to main content

How to Calculate Your Monthly Mortgage Payment

The basic formula: principal, interest rate, and loan term

Your monthly mortgage payment is calculated using three numbers: the loan amount (called the principal), the annual interest rate, and the number of months you have to repay it. The formula banks use is called an amortization calculation, and it produces a fixed payment amount that stays the same every month for a 30-year or 15-year loan.

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

For example, a $300,000 loan at 6.5% annual interest over 30 years produces a different payment than the same loan at 7% interest or over 20 years instead. Each change shifts the numbers in the formula, which shifts your monthly cost.

Key Takeaways

  • Your monthly payment depends on three things: how much you borrow, the interest rate your lender offers, and how many years you take to repay it.
  • You can calculate your payment using an online mortgage calculator, a spreadsheet formula, or by hand if you have a scientific calculator and patience.
  • Your actual monthly bill will be higher than the principal-and-interest payment alone, because it includes property taxes, homeowners insurance, and possibly mortgage insurance.
  • A one percentage point increase in interest rate raises your monthly payment by roughly 10 to 11 percent on a 30-year loan.
  • Shortening your loan term from 30 years to 15 years raises your monthly payment but cuts the total interest you pay nearly in half.

Using an online calculator

The fastest way to see your payment is an online mortgage calculator. You enter the loan amount, interest rate, and loan term (usually 15, 20, or 30 years), and the calculator returns your monthly principal-and-interest payment in seconds. Most calculators also show you a breakdown of how much of each payment goes to principal versus interest, and your total interest cost over the life of the loan.

Bankrate, NerdWallet, and the Consumer Financial Protection Bureau all offer free calculators with no login required. Your lender's website usually has one too. The results are identical across all of them because they use the same formula — the difference is only in how they display the information and what extra details they show you.

If you want to see how changes affect your payment, calculators let you adjust the numbers and recalculate instantly. This is useful for comparing a 15-year loan to a 30-year loan, or seeing what happens if your interest rate drops by half a percentage point.

Calculating it yourself in a spreadsheet

Excel, Google Sheets, and other spreadsheet programs have a built-in function called PMT that calculates your payment for you. The syntax is =PMT(rate, nper, pv), where rate is your monthly interest rate, nper is the total number of payments, and pv is the loan amount (entered as a negative number).

For a $300,000 loan at 6.5% annual interest over 30 years, you would enter: =PMT(0.065/12, 360, -300000). The 0.065/12 converts your annual rate to a monthly rate, 360 is 30 years times 12 months, and -300000 is your principal. The result is your monthly payment before taxes and insurance.

Spreadsheets are useful if you want to build a comparison table showing multiple scenarios at once — different interest rates, different loan terms, or different down payments — all in one view. You can also use them to create an amortization schedule that shows you exactly how much principal and interest you pay each month for the entire life of the loan.

What the numbers mean: principal versus interest

Early in your loan, most of your payment goes to interest and only a small amount reduces your principal. As time passes, this ratio flips. On a 30-year loan at 6.5%, your first payment might be split roughly $1,580 toward interest and $210 toward principal. By year 20, the split is closer to $400 interest and $1,390 principal.

This is why paying extra principal early in the loan saves you the most money — you are preventing years of interest charges on that amount. It is also why refinancing makes sense only if you plan to stay in the home long enough to recoup the closing costs through lower monthly payments.

An amortization schedule shows you this month-by-month breakdown. Your lender will provide one when you close, but you can also generate one in a spreadsheet using the PPMT and IPMT functions, which calculate the principal and interest portions of any payment number.

Why your actual payment is higher than the calculation

The formula above gives you principal and interest only. Your actual monthly bill, called your PITI payment, also includes property taxes, homeowners insurance, and possibly private mortgage insurance (PMI). These are often bundled into one payment by your lender.

Property taxes vary by location and home value — they are set by your county or municipality. Homeowners insurance is a quote from an insurance company. PMI is required if you put down less than 20 percent, and its cost depends on your loan amount and down payment percentage. Your lender can estimate all three before you close and show you the full monthly cost.

Some calculators let you enter these amounts and show you the total PITI payment. Others show only principal and interest, leaving you to add taxes and insurance separately. Either way, the principal-and-interest number is just one piece of your actual monthly bill.

How interest rates and loan terms change your payment

A higher interest rate raises your monthly payment and increases the total interest you pay over the life of the loan. A longer loan term (30 years instead of 15) lowers your monthly payment but increases your total interest cost because you are paying interest for twice as long.

The relationship is not linear. On a $300,000 loan, moving from 6% to 7% interest raises your monthly payment by roughly $150 to $200 on a 30-year loan. Moving from 7% to 8% raises it by another $150 to $200. But shortening the term from 30 years to 15 years raises the monthly payment by roughly $400 to $500 — a much bigger jump — even though it cuts your total interest cost nearly in half.

This is why comparing loans requires looking at both the monthly payment and the total cost. A lower monthly payment feels better now, but a longer loan term means you pay far more in interest over time. Your own situation — how long you plan to stay, what monthly payment you can afford, and how much total interest you want to pay — determines which trade-off makes sense for you.

Adjustable-rate mortgages and payment changes

An adjustable-rate mortgage (ARM) has an interest rate that changes after an initial fixed period, usually 3, 5, 7, or 10 years. During the fixed period, your payment is calculated the same way as a fixed-rate loan. After that period ends, the rate adjusts based on market conditions, and your monthly payment changes.

Your initial payment is predictable because the rate is fixed. But when the rate adjusts, your lender recalculates your payment using the new rate and the remaining loan term. If rates have risen, your payment rises. If rates have fallen, your payment falls. Some ARMs have caps that limit how much the rate can rise at each adjustment and over the life of the loan.

Calculating an ARM payment requires knowing the adjustment schedule and the index the rate is tied to — information your loan documents spell out. Because the future rate is unknown, you cannot calculate your payment after the adjustment period without guessing what rates will be. Lenders often show you a worst-case scenario (the maximum possible rate) so you can see the highest payment you might owe.

Frequently Asked Questions

Does the calculation change if I make extra principal payments?

No. The formula calculates your required monthly payment based on the original loan amount, rate, and term. Extra principal payments reduce your balance faster, which shortens your loan and saves interest, but they do not change the formula itself. Your required payment stays the same; you are simply paying it off sooner.

What if my interest rate has a decimal like 6.375 percent?

Use the exact rate in the formula. If your rate is 6.375%, divide it by 12 to get your monthly rate: 0.06375 / 12 = 0.0053125. Calculators and spreadsheets handle decimal rates without any problem. The more precise your rate, the more accurate your payment.

Can I calculate a payment for a loan that is already in progress?

Yes, but you need the remaining balance, not the original loan amount. Use the current balance, the remaining interest rate, and the remaining number of months. Your lender's loan statement shows all three. This is useful if you are considering refinancing and want to see what your new payment would be.

Why do different lenders quote different monthly payments for the same loan?

The formula is the same, but the inputs differ. One lender might quote 6.5% and another 6.625%. One might include an origination fee in the rate (called points), and another might not. One might estimate property taxes and insurance differently. Always compare the interest rate, the loan term, and the total estimated monthly payment — not just one number.

Is there a way to calculate this by hand without a calculator?

Technically yes, but it requires a scientific calculator and patience. You need to calculate (1 + r)^n, multiply and divide several times, and keep track of decimals. For a 30-year loan, you are raising a number to the 360th power. A calculator or spreadsheet saves hours and eliminates arithmetic errors. Hand calculation is not practical for real-world use.