The basic formula for your monthly payment

Your monthly mortgage payment comes from a single formula that accounts for three things: how much you borrowed, the interest rate, and how many months you have to pay it back. 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 or do it by hand — a calculator or spreadsheet does the work — but understanding what each piece means helps you see why your payment changes when any of these three numbers change.

For example, a $300,000 loan at 6.5% annual interest over 30 years produces a monthly payment of roughly $1,896 before taxes and insurance. If that same loan were at 7.5% instead, your payment jumps to about $2,098. The interest rate alone changed your monthly cost by $202.

Key Takeaways

  • Your monthly payment depends on three numbers: how much you borrowed, your interest rate, and your loan term in years.
  • Online calculators and spreadsheet formulas do the math instantly; you enter the three numbers and get your payment.
  • Your actual monthly bill includes property taxes, homeowners insurance, and possibly mortgage insurance, which are not part of the base payment calculation.
  • Changing your 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.
  • The interest rate has the biggest effect on your payment; a 1% difference can change your monthly cost by $200 or more on a typical loan.

Using an online calculator

The fastest way to find your payment is to use a mortgage calculator on a lender's website, a real estate site, or a financial calculator site. You enter three numbers: the loan amount, the annual interest rate, and the loan term in years. The calculator returns your monthly principal and interest payment in seconds.

Most calculators also let you add property taxes, homeowners insurance, and mortgage insurance (PMI) to see your full monthly housing cost. This total is what your lender calls your PITI payment — principal, interest, taxes, and insurance. Your actual mortgage bill will include these items if they apply to your loan.

The calculator result assumes you are making a standard payment every month for the full term. If you plan to make extra payments or pay off the loan early, the calculator will not reflect that change — you would need to run a separate amortization schedule to see how early payments shorten your loan.

Building the calculation in a spreadsheet

If you want to build the calculation yourself in Excel, Google Sheets, or another spreadsheet, use the PMT function. 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 as a negative number.

For a $300,000 loan at 6.5% annual interest over 30 years, the formula would be =PMT(0.065/12, 360, -300000). The result is your monthly principal and interest payment. The spreadsheet does the exponents and division for you.

Once you have the base payment, you can add rows for property taxes (divide your annual tax by 12), homeowners insurance (divide your annual premium by 12), and PMI if your down payment was less than 20%. This gives you a complete picture of your monthly housing cost before you sign anything.

How loan term affects your payment

A shorter loan term means a higher monthly payment but much less interest paid overall. A 15-year mortgage at the same interest rate costs roughly 40% more per month than a 30-year mortgage, but you pay off the loan in half the time and pay far less total interest.

On a $300,000 loan at 6.5%, the 30-year payment is about $1,896 per month. The 15-year payment on the same loan and rate is about $2,596 per month — $700 more each month. Over the life of the loan, you pay roughly $283,000 in interest on the 30-year loan and roughly $167,000 on the 15-year loan. The shorter term saves you about $116,000 in interest, but only if you can afford the higher monthly payment.

Some borrowers choose a 30-year term for the lower payment and then make extra principal payments when they can afford it. This gives you flexibility: you pay the minimum in tight months and accelerate payoff in good months. Your lender should allow this without penalty, but confirm it before you sign the note.

Why interest rate matters most

Of the three inputs to your payment formula, the interest rate has the largest effect on your monthly cost. A 1% change in rate can shift your payment by $200 or more on a typical loan, depending on the size and term.

This is why shopping for rates across multiple lenders matters. If one lender offers 6.5% and another offers 7.0%, the difference looks small — but over 30 years, that 0.5% costs you tens of thousands of dollars. Always get rate quotes from at least three lenders before you commit.

Your rate depends on your credit score, your down payment size, the loan term, current market rates, and the type of loan (fixed-rate, adjustable-rate, FHA, VA, or conventional). You cannot control market rates, but you can improve your credit score before you apply, save for a larger down payment, and compare offers across lenders.

Understanding amortization schedules

An amortization schedule is a month-by-month breakdown of your payment. Each row shows how much of that month's payment goes to principal (the amount you borrowed) and how much goes to interest (the lender's fee). Early in the loan, most of your payment is interest. Late in the loan, most is principal.

On a $300,000 loan at 6.5% over 30 years, your first payment of $1,896 includes about $1,625 in interest and only $271 in principal. By payment 300 (near the end), you pay about $8 in interest and $1,888 in principal. This is why paying extra principal early in the loan saves so much interest — you are redirecting money that would have gone to the lender's fee.

Most lenders provide an amortization schedule when you close the loan. You can also generate one using a spreadsheet or an online amortization calculator. Use it to see the effect of extra payments: if you add $200 to your principal each month, the schedule shows you how many years earlier you will pay off the loan and how much interest you will save.

What the calculation does not include

The basic payment formula covers only principal and interest. It does not include property taxes, homeowners insurance, HOA fees, or mortgage insurance (PMI). These costs vary by location, the home's value, your insurance choices, and your down payment size, so they cannot be part of a single formula.

Property taxes are set by your county or municipality and are usually paid through an escrow account held by your lender. Homeowners insurance is required by your lender and is also often paid through escrow. If your down payment was less than 20%, your lender requires PMI, which protects them if you default. All three are added to your monthly bill but are separate from the principal and interest calculation.

Your actual monthly payment will be higher than the number your calculator shows. Use the calculator to find the base payment, then add estimates for taxes, insurance, and PMI to see your true monthly cost.

Frequently Asked Questions

What is the difference between principal and interest?

Principal is the amount you borrowed. Interest is the fee the lender charges you for lending it. Each month, part of your payment reduces the principal (you owe less), and part goes to the lender as interest. Early in the loan, most of your payment is interest; late in the loan, most is principal.

Can I use the payment formula to compare loans from different lenders?

Yes. Enter the loan amount, rate, and term from each lender into the formula or a calculator. The lender with the lowest monthly payment is not always the best deal — compare the total interest paid over the life of the loan and any fees the lender charges at closing.

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

Your payment stays the same if you have a fixed-rate mortgage. The rate you locked in at closing does not change for the life of the loan. If you want a lower rate, you would need to refinance, which means taking out a new loan to pay off the old one. Refinancing has closing costs, so it only makes sense if the new rate is low enough to offset those costs.

How much of my payment goes to principal versus interest each month?

An amortization schedule shows the exact breakdown for each payment. Early payments are mostly interest; later payments are mostly principal. If you want to pay off your loan faster, ask your lender if you can make extra principal payments without penalty, then use an amortization calculator to see how much interest you will save.

Does my credit score affect the payment calculation?

Your credit score does not change the formula, but it affects the interest rate the lender offers you. A higher credit score usually means a lower rate, which lowers your monthly payment. A lower credit score means a higher rate and a higher payment. This is why improving your credit before you apply can save you thousands of dollars over the life of the loan.