How Your Monthly Mortgage Payment Is Calculated
What the mortgage payment formula actually does
Your monthly mortgage payment is calculated using a single formula that divides what you owe into equal pieces spread across the life of the loan. The formula takes three numbers — the loan amount, the interest rate, and the number of months you have to pay — and produces one monthly payment that covers both principal (the money you borrowed) and interest (the cost of borrowing it). Every payment you make is the same amount, which is why it is called an amortizing loan.
The formula does not change based on your income, credit score, or how much house costs in your area. It is pure math. Once your lender sets the loan amount, interest rate, and term (usually 15, 20, or 30 years), the payment is locked in. You can calculate it yourself with a calculator, a spreadsheet, or by hand — you do not need the lender to tell you what it will be.
Key Takeaways
- The mortgage payment formula takes your loan amount, annual interest rate, and loan term in months and produces one fixed monthly payment.
- The formula is: M = P × [r(1+r)^n] / [(1+r)^n − 1], where M is the monthly payment, P is the principal, r is the monthly interest rate, and n is the total number of months.
- You can calculate your payment using a spreadsheet function (PMT in Excel or Google Sheets), an online calculator, or by working through the formula by hand.
- The same payment amount covers both principal and interest, but early payments are mostly interest while later payments are mostly principal.
- Changing the loan amount, interest rate, or term changes your payment; refinancing replaces your old loan with a new one using a new formula.
The formula broken down step by step
The standard mortgage payment formula is: M = P × [r(1+r)^n] / [(1+r)^n − 1]
Here is what each letter means:
- M = your monthly payment (the number you are solving for)
- P = the principal, or the amount you borrowed
- r = the monthly interest rate (your annual rate divided by 12)
- n = the total number of months you have to pay back the loan
The formula works because it spreads your debt across time and charges you interest on the balance that remains. The numerator — the top part of the fraction — grows as your interest rate rises or your loan gets longer. The denominator — the bottom part — also grows, but differently. The ratio between them produces a payment that, when made every month, will pay off the entire loan plus all the interest by the final month.
For example, if you borrow $300,000 at 6.5% annual interest over 30 years, your monthly interest rate is 0.065 ÷ 12 = 0.00542. Your total number of months is 30 × 12 = 360. Plugging those into the formula gives you a monthly payment of roughly $1,896. That same $1,896 payment, made 360 times, will pay off the $300,000 plus all the interest the lender charges.
How to calculate your payment without doing math by hand
Most people do not work through the formula manually. Instead, they use a tool that does it for them.
Spreadsheet functions: Excel and Google Sheets both have a PMT function built in. In Google Sheets, you type: =PMT(rate, nper, pv). The rate is your monthly interest rate (annual rate ÷ 12), nper is the number of months, and pv is the loan amount as a negative number. For the $300,000 example: =PMT(0.065/12, 360, -300000) returns $1,896.20.
Online calculators: Mortgage calculators on lender websites, real estate sites, and financial websites let you enter the loan amount, interest rate, and term, then instantly show you the monthly payment. These calculators use the same formula but hide the math from you.
Your lender's estimate: When you get a loan estimate from a lender, the monthly payment is already calculated using this formula. You can verify it yourself using a spreadsheet or calculator if you want to confirm the number.
Why the same payment covers different amounts of principal and interest each month
Your monthly payment stays the same every month, but what that payment covers changes. Early in the loan, most of your payment goes toward interest. Late in the loan, most of it goes toward principal. This is called amortization.
Here is why it works this way: interest is calculated on the remaining balance. In month one, your balance is the full loan amount, so the interest charge is highest. When you make your payment, the lender first takes the interest owed, and whatever is left over reduces the principal. In month two, your balance is slightly lower, so the interest charge is slightly lower, and slightly more of your payment goes to principal. This pattern repeats for the entire loan.
On a 30-year mortgage, you might pay $1,000 in interest and $896 in principal in month one. By month 360, you might pay $9 in interest and $1,887 in principal. The payment is always $1,896, but the split changes. Your lender provides an amortization schedule — a month-by-month breakdown — that shows exactly how much principal and interest you pay each month.
What changes your payment: loan amount, rate, and term
The formula shows that your payment depends on exactly three things: how much you borrow, what interest rate you get, and how long you have to pay it back.
Loan amount: Borrow more, pay more each month. A $400,000 loan at the same rate and term as a $300,000 loan will have a proportionally higher payment. The relationship is direct and linear.
Interest rate: A higher rate increases your payment, but not proportionally. A loan at 7% costs more per month than one at 6.5%, but the difference compounds over time. On a $300,000 30-year loan, 6.5% gives you $1,896; 7% gives you $1,996 — a $100 difference. On a 15-year loan, the difference is larger in absolute dollars but smaller as a percentage of the payment.
Loan term: A shorter term (15 years instead of 30) means you pay the same amount of principal in half the time, so your monthly payment is higher. But you pay far less total interest because interest accrues for fewer months. A 15-year $300,000 loan at 6.5% costs about $2,596 per month but costs roughly $167,000 in total interest. The same loan over 30 years costs $1,896 per month but roughly $382,000 in total interest.
How refinancing uses the formula to create a new payment
When you refinance a mortgage, you are replacing your old loan with a new one. The new lender pays off the old loan in full, and you start making payments on the new loan using the mortgage payment formula with new numbers.
Your new payment depends on three things: how much you still owe (the remaining balance, not the original loan amount), the new interest rate you negotiate, and the new term you choose. If you refinance a $300,000 loan after 10 years and still owe $250,000, the formula uses $250,000 as the principal, not $300,000. If you refinance into a new 20-year term instead of the remaining 20 years on your old loan, the formula uses 240 months instead of 240 months — in this case they are the same, but if you refinance into a 30-year term, it uses 360 months, which lowers your payment but increases your total interest.
Refinancing makes sense when the new interest rate is low enough that your savings on interest outweigh the closing costs of the new loan. The formula lets you calculate exactly what your new payment will be before you commit.
The difference between fixed and adjustable rates in the formula
The mortgage payment formula assumes a fixed interest rate — one that does not change for the life of the loan. If your rate is fixed at 6.5%, the formula calculates one payment that you make for 360 months (on a 30-year loan).
With an adjustable-rate mortgage (ARM), the interest rate changes after an initial fixed period. For example, a 5/1 ARM has a fixed rate for 5 years, then adjusts every year after that. During the first 5 years, the formula works the same way — you have one fixed payment. After 5 years, the lender recalculates your payment using the formula again, with the new interest rate and the remaining loan term. Your new payment might be higher or lower depending on whether rates rose or fell.
The formula itself does not change, but the inputs do. This is why ARMs are riskier: you know your payment for a set time, but after that, the formula gets recalculated with unknown future rates.
Frequently Asked Questions
Can I use the formula to calculate a payment that includes property taxes and insurance?
No. The mortgage payment formula calculates only the principal and interest portion of your payment. Property taxes, homeowners insurance, and mortgage insurance (if required) are separate costs added on top. Your lender may combine all of these into one monthly payment called PITI (principal, interest, taxes, insurance), but the formula only produces the PI part.
What happens if I make extra principal payments?
Extra principal payments reduce your remaining balance, which means you owe less interest in future months and you pay off the loan faster. The formula does not change — your regular monthly payment stays the same. But because your balance drops faster, you reach zero sooner and pay less total interest. You do not need to recalculate anything; just send the extra money to your lender and ask them to apply it to principal.
Does the formula work the same way for 15-year and 30-year mortgages?
Yes. The formula is identical; only the input changes. A 15-year loan uses 180 months in the formula; a 30-year loan uses 360 months. Everything else — the principal, the interest rate, the way the payment is split between principal and interest — follows the same math.
Why do lenders give me a loan estimate if the payment is just a formula?
The formula calculates your payment, but lenders also need to know your loan amount and interest rate first. Those depend on your credit score, down payment, income, debt, and the home price. The loan estimate shows you the payment the formula produces once the lender has set those numbers. You can verify the payment yourself using the formula, but you cannot know what it will be until the lender tells you the loan amount and rate.