How to Calculate Your Mortgage Payment
The basic formula for your monthly payment
Your mortgage payment is calculated using four pieces of information: the loan amount you borrowed, the interest rate, the length of the loan in years, and how often you pay (usually monthly). Banks use a standard formula that divides the total interest and principal across all your payments so each one is the same amount.
The formula itself looks like this: M = P [ r(1 + r)^n ] / [ (1 + r)^n – 1 ], where M is your monthly payment, P is the principal (the amount borrowed), r is the monthly interest rate (annual rate divided by 12), and n is the total number of payments. You do not need to memorize or calculate this by hand — every mortgage lender provides a payment calculator, and most online calculators do the math instantly.
What matters is understanding what each number means and how changing one affects your payment. A higher interest rate raises your payment. A longer loan term lowers your payment but increases total interest paid. A larger loan amount raises your payment proportionally.
Key Takeaways
- Your monthly payment depends on the loan amount, interest rate, loan term in years, and payment frequency, combined using a standard mathematical formula.
- You can calculate your payment using an online mortgage calculator, a spreadsheet function like Excel's PMT formula, or by asking your lender directly.
- The interest rate has the largest effect on your payment — a 1% difference can change your monthly cost by hundreds of dollars.
- Your actual payment may be higher than the principal-and-interest calculation because it often includes property taxes, homeowners insurance, and mortgage insurance.
Using an online calculator
The fastest way to see your payment is to enter your numbers into a mortgage calculator on your lender's website or a financial site. You will need: the loan amount (the price of the home minus your down payment), the interest rate (the percentage your lender charges), and the loan term (usually 15 or 30 years).
Most calculators show you the principal-and-interest payment immediately. Some also let you add property taxes, homeowners insurance, and mortgage insurance (PMI) to see your full monthly cost. The calculator does the formula work for you and shows the result in seconds.
If you do not have an exact interest rate yet, you can use a rate from recent mortgage offers or your lender's current rate to see a rough estimate. The actual payment will shift slightly once your rate is locked in.
Calculating it yourself in a spreadsheet
If you want to see the calculation happen, you can use Excel, Google Sheets, or any spreadsheet program. Excel has a built-in function called PMT that does the formula work for you.
The syntax is: =PMT(rate, nper, pv). Here, "rate" is your monthly interest rate (annual rate divided by 12), "nper" is the total number of payments (years times 12), and "pv" is the loan amount as a negative number. For example, a $300,000 loan at 6.5% annual interest over 30 years would be: =PMT(0.065/12, 30*12, -300000). The result will be your monthly principal-and-interest payment.
Google Sheets uses the same function and syntax. This method is useful if you want to test different scenarios quickly — change the interest rate or loan term and see the payment update instantly.
What the interest rate actually does to your payment
The interest rate has the biggest impact on your monthly cost. A $300,000 loan over 30 years costs about $1,799 per month at 6% interest, but $2,075 per month at 7% interest — a difference of $276 every month, or $3,312 per year. That same rate difference on a 15-year loan creates an even larger monthly gap.
This is why shopping for the best interest rate matters so much. Even a 0.25% difference in your rate can save or cost you tens of thousands of dollars over the life of the loan. Your rate depends on your credit score, down payment size, loan term, and the lender's current pricing.
When you see a lender's advertised rate, ask whether it includes points — upfront fees you pay to lower your rate. A lower advertised rate might actually cost more money overall if you have to pay points to get it.
Why your actual payment is usually higher than the calculation
When you calculate principal and interest alone, you are seeing only part of your monthly payment. Most mortgages also include property taxes, homeowners insurance, and sometimes mortgage insurance (PMI) if your down payment was less than 20%.
These costs vary by location and your specific situation. Property taxes depend on your county and home value. Insurance depends on the home's replacement cost and your location's risk (flood, fire, etc.). Mortgage insurance depends on your down payment percentage and loan amount.
Your lender can give you an estimate of these costs before you lock in your rate. Some online calculators let you add them in to see your full monthly payment. This total is what you will actually pay each month, not just the principal-and-interest number.
How loan term changes your payment
A shorter loan term means a higher monthly payment but less total interest paid. A longer term means a lower monthly payment but more total interest paid over time.
A $300,000 loan at 6% interest costs about $1,799 per month over 30 years, but about $2,332 per month over 15 years. The 15-year loan costs $533 more each month, but you pay off the house 15 years sooner and pay roughly half the total interest.
The choice between 15 and 30 years (or other terms) depends on your budget and goals. A 30-year mortgage is more affordable month-to-month, which matters if you have other expenses. A 15-year mortgage builds equity faster and costs less in total interest, which matters if you can afford the higher payment and want to own the home outright sooner.
Frequently Asked Questions
Does my credit score affect my mortgage payment calculation?
Your credit score does not change the formula, but it affects the interest rate your lender offers you. A higher credit score usually gets you a lower rate, which lowers your payment. The calculation itself stays the same — you just plug in a different interest rate.
What if I want to pay extra toward principal each month?
Your calculated payment is the minimum required each month. You can pay more whenever you want, and the extra goes directly to principal, which shortens your loan term and reduces total interest. There is no penalty for paying extra on a standard mortgage, but check your loan documents to be sure.
How do I know if my lender's payment calculation is correct?
Run the same numbers through an independent online calculator or a spreadsheet PMT formula. If the results match, your lender's calculation is correct. If they differ by more than a few dollars, ask your lender to explain the difference — it may be due to property taxes, insurance, or other costs they included.
Can I lock in an interest rate before I am ready to buy?
Most lenders offer rate locks only after you have a purchase contract and have submitted a full application. Some lenders offer "rate quotes" or "rate locks" for a short period (usually 30 to 120 days) before you formally apply, but terms vary. Ask your lender what they offer and for how long.
What happens to my payment if interest rates drop after I close?
Your payment stays the same unless you refinance — take out a new loan to pay off the old one. Refinancing lets you lock in a lower rate, which lowers your payment, but you pay closing costs again. Refinancing makes sense only if the lower rate saves you enough money to cover those costs within your timeline.