How to Calculate Your Mortgage Payment With Interest
The basic formula for mortgage payments
Your monthly mortgage payment is calculated using a fixed formula that accounts for the loan amount, interest rate, and loan term. 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 (annual rate divided by 12), and n is the total number of payments (years multiplied by 12). You do not need to memorize this — most people use a calculator or spreadsheet — but understanding what each piece represents helps you see why your payment changes when any of these numbers change.
For example, if you borrow $300,000 at 6.5% annual interest over 30 years, your monthly interest rate is 0.065 divided by 12, or 0.00542. Your total number of payments is 30 times 12, or 360. Plugging these into the formula gives you a monthly payment of approximately $1,896 before taxes and insurance.
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 mortgage calculator (online or in a spreadsheet) does the math for you — you enter the loan amount, rate, and term, and it shows your payment instantly.
- The interest rate has the largest effect on your payment; a 1% difference in rate can change your monthly payment by $200 or more on a $300,000 loan.
- Your actual monthly bill includes property taxes, homeowners insurance, and possibly mortgage insurance, which are not part of the interest calculation.
Using a mortgage calculator instead of doing the math by hand
You can calculate your payment using the formula above, but a spreadsheet or online calculator is faster and less error-prone. Most mortgage lenders have calculators on their websites. You can also use a general-purpose spreadsheet like Excel or Google Sheets, which have a built-in PMT function designed for this exact purpose.
To use a spreadsheet PMT function, enter the monthly interest rate as the first argument, the number of payments as the second, and the loan amount (as a negative number) as the third. For the $300,000 loan at 6.5% over 30 years, you would type =PMT(0.065/12, 360, -300000) and the spreadsheet returns your monthly payment. Online calculators ask you to fill in boxes instead of typing a formula, which is simpler if you are not comfortable with spreadsheets.
How interest rate changes affect your payment
The interest rate is the single biggest lever on your monthly payment. A small change in rate creates a large change in what you owe each month. On a $300,000 loan over 30 years, the difference between 5.5% and 6.5% is about $170 per month — that is $2,040 per year, or $61,200 over the life of the loan.
This is why shopping for the best rate matters. Even a 0.25% difference (from 6.5% to 6.25%, for instance) saves you roughly $40 per month on a $300,000 loan. Over 30 years, that is $14,400. Lenders often quote rates that vary by a quarter or half percent depending on your credit score, down payment size, and loan type, so comparing offers from multiple lenders can pay off.
How loan term affects your payment and total interest
Shortening your loan term lowers the total interest you pay but raises your monthly payment. Lengthening your term does the opposite: your monthly payment falls, but you pay more interest overall. A 15-year mortgage on $300,000 at 6.5% costs roughly $2,596 per month, compared to $1,896 for a 30-year loan at the same rate. The 15-year loan costs you about $700 more per month, but you pay off the house 15 years sooner and pay roughly $200,000 less in total interest.
Some borrowers choose a 30-year term to keep the monthly payment manageable, then pay extra toward principal when they can afford it. Others choose a 15-year term from the start if their income is stable. There is no single right answer — it depends on your budget and how much interest you want to pay over time.
Breaking down principal versus interest in each payment
Early in your loan, most of your monthly payment goes toward interest rather than principal. As time passes, the split shifts — more of each payment goes toward principal and less toward interest. On a $300,000 loan at 6.5% over 30 years, your first payment of $1,896 includes roughly $1,625 in interest and only $271 in principal. By payment 180 (halfway through), interest and principal are nearly equal. By the final payment, almost all $1,896 goes toward principal because very little interest remains.
Your lender provides an amortization schedule — a month-by-month breakdown showing how much of each payment is interest and how much is principal. You can request this from your lender or generate one using a spreadsheet. Knowing this breakdown helps you understand why paying extra principal early in the loan saves so much interest over time.
The difference between interest rate and APR
Your interest rate is the percentage you pay on the borrowed amount. Your APR (annual percentage rate) includes the interest rate plus other costs, such as origination fees, discount points, and closing costs, spread across the life of the loan. The APR is always equal to or higher than the interest rate.
Lenders are required to disclose both the rate and the APR so you can compare loans fairly. A loan with a lower rate but higher fees might have a higher APR than a loan with a slightly higher rate but lower fees. When comparing offers from different lenders, use the APR to compare apples to apples, but use the interest rate to calculate your actual monthly payment.
What your monthly payment does not include
The payment you calculate using the formula or a calculator covers only principal and interest. Your actual monthly mortgage bill also includes property taxes, homeowners insurance, and possibly PMI (private mortgage insurance) if you put down less than 20%. These are often rolled into a single payment called PITI (principal, interest, taxes, and insurance).
Property taxes vary by location and home value. Homeowners insurance varies by the home's age, location, and coverage level. PMI varies by your down payment percentage and credit score. Your lender can estimate these costs and show you the full monthly PITI payment before you close on the loan. This full payment is what you actually owe each month, not just the principal and interest portion.
Frequently Asked Questions
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 closing. However, you may be able to refinance your loan at the new lower rate, which would lower your monthly payment. Refinancing involves closing costs, so you need to calculate whether the monthly savings will pay back those costs within a reasonable timeframe.
Can I use the mortgage payment formula to calculate payments on other loans?
Yes. The same formula works for car loans, personal loans, and any other fixed-rate loan where you make equal monthly payments. The only difference is the numbers you plug in — the structure of the calculation is identical.
Why does my actual monthly payment differ from what the calculator showed?
The calculator shows principal and interest only. Your actual bill includes taxes, insurance, and possibly PMI, which the calculator does not account for unless you enter those amounts separately. Ask your lender for a Loan Estimate, which breaks down all costs and shows your total monthly payment.
If I pay extra toward principal, does my interest rate change?
No. Your interest rate is locked in at closing and does not change based on how much you pay. However, paying extra principal reduces the amount of interest you owe over time because you are paying down the balance faster. This is why extra principal payments early in the loan save the most interest.
How do I know if a quoted interest rate is competitive?
Compare offers from at least three lenders. Ask each one for the same loan amount, term, and down payment percentage, and compare the APR they quote. Rates change daily, so get quotes on the same day if possible. Your credit score, down payment size, and loan type all affect the rate you are offered, so make sure you are comparing loans with the same terms.