The Basic Formula for Monthly Mortgage Payments

Your monthly mortgage payment is calculated using a standard 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:

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 payments (years multiplied by 12). You do not need to memorize this—a calculator or spreadsheet does the work—but understanding what each piece represents helps you see why changing any one of them 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 over 15 years, because n changes. A higher interest rate raises your payment even if the loan amount stays the same. This is why shopping for a lower rate or choosing a longer loan term are real levers you can pull before you sign.

Key Takeaways

  • Your monthly payment depends on three numbers: how much you borrowed, your interest rate, and how many months you have to repay it.
  • An online mortgage calculator or a spreadsheet with the standard payment formula will give you an exact figure in seconds.
  • Changing the loan term from 30 years to 15 years raises your monthly payment but cuts the total interest you pay over the life of the loan.
  • Your actual monthly bill may be higher than the principal-and-interest payment because it often includes property taxes, homeowners insurance, and mortgage insurance.
  • Lenders are required to show you the full payment breakdown before you close, so you will know the exact total before you commit.

Using an Online Mortgage Calculator

The fastest way to see your payment is to use a free online mortgage calculator. You enter three numbers—the loan amount, the annual interest rate, and the loan term in years—and the calculator returns your monthly principal-and-interest payment when ready. Most calculators also let you add property taxes, homeowners insurance, and mortgage insurance to see your full monthly housing cost.

Mortgage calculators are offered by most lenders' websites, by real estate sites like Zillow and Realtor.com, and by financial sites like Bankrate. They all use the same formula, so the result should be identical across them. The advantage of using your lender's calculator is that you can see their current rates; the advantage of a neutral site is that you can compare rates across multiple lenders without being contacted by each one.

A calculator also lets you run scenarios quickly. You can see what happens if you put down 10% instead of 20%, or if you lock in a 6% rate instead of 7%, or if you choose a 20-year loan instead of 30. This takes seconds and helps you understand which decisions move the needle on your payment.

Calculating Payment by Hand Using a Spreadsheet

If you want to see the math yourself or build a custom spreadsheet, most spreadsheet programs (Excel, Google Sheets, LibreOffice) include a built-in function called PMT that does the calculation for you. 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 a $300,000 loan at 6.5% annual interest over 30 years, you would enter: =PMT(0.065/12, 30*12, -300000). The result is approximately $1,896 per month in principal and interest. You can change any of the three numbers and see the payment recalculate when ready.

Building your own spreadsheet is useful if you want to track additional details—like how much of each payment goes to principal versus interest, or how your payment changes if you make extra payments toward principal. Many people find this transparency helpful when deciding whether to refinance or pay off the loan early.

Understanding the Parts of Your Monthly Payment

The formula above calculates only principal and interest—the amount that goes toward paying back the loan itself. But your actual monthly bill from your lender is usually larger, because it includes other costs bundled into a single payment. These are often called PITI: Principal, Interest, Taxes, and Insurance.

Property taxes are set by your county or municipality and vary widely by location. Homeowners insurance protects your house against fire, theft, and weather damage and is required by your lender. Mortgage insurance (PMI) is required if you put down less than 20% and protects the lender if you default. Some lenders also collect money for homeowners association fees or other costs.

Your lender is required to give you a Loan Estimate within three business days of your process. This document breaks down every cost—principal and interest, taxes, insurance, and fees—so you see the full monthly payment before you commit. The final Closing Disclosure, provided three days before closing, shows the exact numbers based on your final loan terms.

How Interest Rate Changes Affect Your Payment

Interest rate is the single biggest lever on your monthly payment. A 1% difference in rate can change your payment by $200 to $300 per month on a typical loan. This is why shopping for a lower rate before you lock in is worth the effort.

When you explore for a mortgage, your lender quotes you a rate and offers to lock it for a set number of days—usually 30, 45, or 60. During that lock period, your rate cannot change even if market rates move. If you do not lock and rates rise before you close, your payment rises. If rates fall, you can sometimes renegotiate, though some lenders charge a fee.

The rate you receive depends on your credit score, down payment, loan term, and the type of loan (fixed-rate or adjustable-rate). A higher credit score and a larger down payment typically earn you a lower rate. Comparing offers from at least three lenders before you lock helps you understand what rate you can actually get, not just what the advertised rate is.

How Loan Term Changes Affect Your Payment

Loan term—how many years you have to repay—is the second major factor. A 15-year mortgage has a higher monthly payment than a 30-year mortgage on the same loan amount and rate, because you are paying it back in half the time. But you pay far less total interest over the life of the loan.

On a $300,000 loan at 6.5%, a 30-year term costs about $1,896 per month and totals roughly $682,000 over 30 years (meaning you pay about $382,000 in interest). A 15-year term costs about $2,596 per month but totals only about $467,000 (meaning you pay about $167,000 in interest). The monthly difference is $700, but you save $215,000 in interest and own your home free and clear 15 years sooner.

Some people choose a 30-year loan for the lower monthly payment and then pay extra toward principal when they can. Others choose a 15-year loan from the start if they can afford it. Your choice depends on your budget and your priorities—there is no single right answer, only what works for your situation.

What Happens After You Lock Your Rate

Once you lock your rate with a lender, your payment is set (assuming you do not change the loan amount or term). Your lender will order an appraisal to confirm the house is worth what you are paying, and will verify your income and assets. If everything checks out, you move toward closing.

Three days before closing, your lender sends you a Closing Disclosure that shows your final payment amount, broken down by principal, interest, taxes, insurance, and any other costs. This is your final note to review the numbers and ask questions. If something does not match what you were quoted, raise it when ready—lenders are required to explain any changes.

After closing, your payment is locked in for the life of the loan if you have a fixed-rate mortgage. If you have an adjustable-rate mortgage (ARM), your rate may change after an initial fixed period, which would change your payment. Most people choose fixed-rate mortgages to avoid this uncertainty.

Frequently Asked Questions

Does the mortgage payment formula work the same for all loans?

Yes, the formula works for any loan where you make equal monthly payments—mortgages, car loans, personal loans. The only difference is the numbers you plug in. A mortgage uses a much larger principal and longer term than a car loan, but the math is identical.

What if I want to pay off my mortgage early?

You can pay extra toward principal at any time without penalty on most mortgages. Some people pay an extra $100 or $200 per month; others make a lump-sum payment when they receive a bonus or inheritance. Each extra dollar goes straight to principal and reduces the total interest you pay and the number of years until the loan is paid off.

Why is my actual monthly bill higher than the calculator showed?

The calculator probably showed only principal and interest. Your actual bill includes property taxes, homeowners insurance, and possibly mortgage insurance, which are added on top. Your Loan Estimate breaks down all of these, so you can see which costs are which.

Can I change my payment after I close?

Your principal-and-interest payment is fixed for the life of a fixed-rate mortgage and cannot be changed. However, property taxes and insurance can change year to year, so your total monthly bill may go up or down. If you refinance, you can choose a new term and rate, which changes your payment.

What is the difference between a fixed-rate and adjustable-rate mortgage?

A fixed-rate mortgage locks your interest rate for the entire loan term, so your principal-and-interest payment never changes. An adjustable-rate mortgage (ARM) has a lower rate for an initial period (often 3, 5, 7, or 10 years), then adjusts periodically based on market rates. After adjustment, your payment can rise significantly, which is why most borrowers prefer fixed-rate mortgages.