The formula and what each number means

Your monthly mortgage payment is calculated using a fixed formula that accounts for the loan amount, interest rate, and how many months you have to repay it. The formula is called an amortization calculation, and it produces the same result whether you use a calculator, a spreadsheet, or a mortgage payment tool.

The basic inputs are three numbers: the principal (the amount you borrowed), the monthly interest rate (your annual rate divided by 12), and the total number of monthly payments (your loan term in years multiplied by 12). A $300,000 loan at 6.5% annual interest over 30 years, for example, uses 300000 as principal, 0.00542 as the monthly rate (6.5% ÷ 12), and 360 as the number of payments (30 × 12).

The actual formula is: M = P × [r(1+r)^n] / [(1+r)^n − 1], where M is your monthly payment, P is the principal, r is the monthly interest rate, and n is the number of payments. This formula accounts for the fact that each payment covers both interest and principal, and the balance shrinks over time.

Key Takeaways

  • Your monthly payment depends on three things: how much you borrowed, your interest rate, and how long you have to repay it.
  • A higher interest rate or shorter loan term raises your monthly payment; a lower rate or longer term lowers it.
  • Your payment covers principal and interest only — property taxes, insurance, and HOA fees are separate and often added to create your total monthly housing cost.
  • Using a mortgage calculator or spreadsheet is faster and more accurate than doing the math by hand, and the result is the same either way.
  • Changing any one of the three inputs — borrowing less, locking a lower rate, or extending the term — changes your payment in a predictable way.

Why the interest rate matters more than you might think

The interest rate has an outsized effect on your monthly payment because interest compounds over the life of the loan. On a $300,000 loan, the difference between 5.5% and 6.5% is only 1 percentage point, but it changes your monthly payment from roughly $1,703 to $1,896 — a difference of $193 per month, or $69,480 over 30 years.

Early in the loan, most of your payment goes toward interest rather than principal. In month one of a $300,000 loan at 6.5%, your payment of $1,896 covers about $1,625 in interest and only $271 in principal. By month 360, that same $1,896 covers almost no interest and nearly all principal. This is why paying extra principal early in the loan saves you far more interest than paying extra near the end.

If you lock a lower rate before closing, or if rates drop and you refinance, your payment falls when ready. If rates rise, your payment rises. This is why mortgage rate shopping — getting quotes from multiple lenders — can save you thousands of dollars over the life of the loan.

How loan term changes your payment

A longer loan term spreads the same debt across more months, which lowers your monthly payment but increases the total interest you pay. A shorter term does the opposite: higher monthly payment, less total interest.

On a $300,000 loan at 6.5%, a 30-year term gives you a monthly payment of $1,896. A 15-year term on the same loan and rate raises that payment to $2,596 — $700 more per month. But over 15 years you pay roughly $166,000 in total interest, compared to roughly $382,000 over 30 years. The 15-year loan costs you $216,000 less in interest, but only if you can afford the higher monthly payment.

Some borrowers choose a 30-year loan for the lower payment, then pay extra principal when they can afford it. Others lock in a 15-year term from the start. There is no single right choice — it depends on your income, your other debts, and how much you want to pay in interest over time.

The difference between principal and interest in your payment

Every monthly payment you make is split into two parts: principal (which reduces what you owe) and interest (which goes to the lender). The split changes every month. Early payments are mostly interest; later payments are mostly principal.

An amortization schedule is a month-by-month breakdown of this split. On a $300,000 loan at 6.5% over 30 years, your first payment of $1,896 includes $1,625 in interest and $271 in principal. Your 180th payment (halfway through) includes roughly $1,000 in interest and $896 in principal. Your final payment includes almost no interest and nearly the full $1,896 in principal.

You can request an amortization schedule from your lender, or generate one using a spreadsheet. Knowing this breakdown helps you understand why paying extra principal early saves so much interest, and why refinancing late in the loan (when most of your payment is already principal) saves you less.

What is not included in your mortgage payment

The number you calculate using the formula above covers principal and interest only. It does not include property taxes, homeowners insurance, or HOA fees — all of which are separate costs that vary by location and property.

Your lender may require you to pay these into an escrow account each month, and then the lender pays the bills on your behalf. If so, your actual monthly housing payment (called your PITI payment: principal, interest, taxes, insurance) is higher than the principal-and-interest number you calculated. Some lenders also require mortgage insurance (PMI) if you put down less than 20%, which adds another monthly cost.

When you see a mortgage payment quoted, always ask whether it includes taxes and insurance, or whether those are separate. The principal-and-interest number alone does not tell you what you will actually pay each month.

Using a calculator versus doing the math yourself

The amortization formula is mathematically sound but tedious to calculate by hand. A mortgage calculator — available free from most lenders, banks, and financial websites — does the work in seconds and produces the same result. You enter the loan amount, interest rate, and term, and the calculator returns your monthly payment.

A spreadsheet like Excel or Google Sheets can also calculate this using the PMT function. The syntax is =PMT(rate, nper, pv), where rate is your monthly interest rate (annual rate ÷ 12), 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% over 30 years, you would enter =PMT(0.065/12, 360, -300000), and the spreadsheet returns 1895.69.

The advantage of a calculator or spreadsheet is speed and the ability to test different scenarios. You can when ready see how your payment changes if you borrow $50,000 less, or if rates drop by 0.5%, or if you choose a 20-year term instead of 30. This makes it straightforward to compare options before you commit to a loan.

How to adjust your payment by changing the inputs

Once you understand the three inputs — principal, rate, and term — you can predict how changes affect your payment. Borrowing less always lowers your payment. Locking a lower rate always lowers your payment. Extending the term always lowers your payment. The reverse is true for each: borrowing more, accepting a higher rate, or shortening the term all raise your payment.

The relationship is not linear. Doubling your loan amount doubles your payment, but cutting your interest rate in half does not cut your payment in half. A 1% drop in rate on a $300,000 loan saves you roughly $150 per month, but a 2% drop saves you roughly $290 per month — the benefit accelerates as the rate falls.

This is why small changes in rate matter so much. Shopping for a rate 0.25% lower than your initial quote saves you about $40 per month on a $300,000 loan — $14,400 over 30 years. Spending an hour getting quotes from three or four lenders often pays for itself many times over.

Frequently Asked Questions

Does the formula change if I have an adjustable-rate mortgage?

No, the formula is the same, but an adjustable-rate mortgage (ARM) changes your interest rate after a 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. When the rate adjusts, your lender recalculates your payment using the new rate and the remaining balance and term.

What if I want to pay off my mortgage early?

You can pay extra principal whenever you want without penalty (on most mortgages). Extra principal goes directly toward reducing your balance, which shortens your loan term and saves you interest. If you pay $200 extra per month on a $300,000 loan, you will pay it off years earlier and save tens of thousands in interest.

How do property taxes and insurance affect the calculation?

They do not affect the principal-and-interest calculation, but they do affect your total monthly housing cost. Your lender estimates your annual taxes and insurance, divides by 12, and adds that amount to your principal-and-interest payment. If taxes or insurance rise, your total payment rises even if your principal-and-interest payment stays the same.

Can I use this formula for other types of loans?

Yes. The amortization formula works for any loan with a fixed interest rate and fixed monthly payment — car loans, personal loans, student loans. The inputs are the same: the amount borrowed, the monthly interest rate, and the number of payments. The calculation is identical.

What happens to my payment if I refinance?

Refinancing means taking out a new loan to pay off your old one. Your new payment is calculated using the new loan amount (which may be less if you have paid down principal), the new interest rate, and the new term you choose. If you refinance a $250,000 balance at a lower rate over a new 30-year term, your payment is recalculated from scratch using those three numbers.