What the mortgage payment formula actually calculates
The standard mortgage payment formula tells you how much principal and interest you owe each month. It does not include property taxes, insurance, or HOA fees — those are separate. The formula works backward from what the lender knows: the loan amount, the interest rate, and how many months you have to repay it. From those three numbers, it solves for the one unknown: your payment.
The formula is written as 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 (years multiplied by 12). You do not need to memorize this. You need to understand what each piece means and why the payment stays the same every month even though the split between principal and interest changes.
Key Takeaways
- The mortgage payment formula uses four inputs: loan amount, annual interest rate, monthly interest rate (annual divided by 12), and total number of months to repay.
- The formula produces a fixed monthly payment that covers both principal and interest, with the interest portion front-loaded and principal portion increasing over time.
- A $300,000 loan at 6.5% over 30 years produces a different payment than the same loan at 7% or over 20 years, and the formula shows exactly why.
- Property taxes, homeowners insurance, and PMI are not part of this formula — they are added separately to reach your total monthly housing cost.
Breaking down each part of the formula
Start with P, the principal. This is the amount you actually borrow. If you put 20% down on a $400,000 house, your principal is $320,000. The down payment does not appear in the formula because you are not borrowing it.
Next is r, the monthly interest rate. Lenders quote an annual rate — say, 6.5%. To convert that to a monthly rate, divide by 12: 6.5% ÷ 12 = 0.00542 (or 0.542% per month). This is where the formula gets its power: the lender charges interest on the remaining balance each month, and as you pay down principal, the interest owed the next month shrinks.
Then comes n, the number of payments. A 30-year mortgage is 360 payments (30 years × 12 months). A 15-year mortgage is 180 payments. The longer the term, the lower your monthly payment but the more total interest you pay over the life of the loan.
The exponent (1 + r)^n is the compounding factor. It shows how much the interest rate compounds over your entire loan term. This is why a 0.5% difference in rate produces a noticeably different payment: the compounding effect multiplies across 360 months.
How to work through the formula step by step
Take a concrete example: a $300,000 loan at 6.5% annual interest over 30 years.
Step 1: Convert the annual rate to a monthly rate. 6.5% ÷ 100 = 0.065. Then 0.065 ÷ 12 = 0.00542. So r = 0.00542.
Step 2: Calculate the number of payments. 30 years × 12 = 360 payments. So n = 360.
Step 3: Calculate (1 + r)^n. This is (1 + 0.00542)^360 = (1.00542)^360 = 6.898. This number tells you how much the compounding effect amplifies your interest over 30 years.
Step 4: Plug into the numerator: r(1 + r)^n = 0.00542 × 6.898 = 0.0374.
Step 5: Plug into the denominator: (1 + r)^n – 1 = 6.898 – 1 = 5.898.
Step 6: Divide numerator by denominator: 0.0374 ÷ 5.898 = 0.00634.
Step 7: Multiply by principal: M = $300,000 × 0.00634 = $1,902 per month (principal and interest only).
Why the payment stays the same but the split changes
Your $1,902 payment is fixed for 360 months. But in month one, most of it goes to interest. In month 360, most of it goes to principal. This happens because interest is always calculated on the remaining balance.
In month one, you owe $300,000. At 0.542% monthly interest, that is $1,626 in interest. Your $1,902 payment leaves $276 for principal. Your new balance is $299,724.
In month two, interest is calculated on $299,724, not $300,000. That is $1,625 in interest. Your $1,902 payment now puts $277 toward principal. The balance drops to $299,447.
By month 180 (year 15), you have paid down enough principal that interest and principal are roughly equal. By month 360, interest is nearly zero and almost the entire payment goes to principal. The formula ensures that this shifting split always adds up to exactly $1,902.
How changes in rate and term affect the payment
The formula shows why small changes in interest rate matter. If that same $300,000 loan were at 7% instead of 6.5%, the monthly rate becomes 0.00583. Working through the formula, the payment rises to $1,996 — an extra $94 per month, or $33,840 over 30 years.
Term length has an even bigger effect. The same $300,000 at 6.5% over 15 years instead of 30 years produces a monthly payment of $2,390 — $488 more per month. You pay off the loan twice as fast, but your monthly obligation is much higher. Over the full 15 years, you pay roughly $130,000 less in total interest, but you must be able to afford the larger payment.
This is why lenders show you multiple scenarios. The formula is deterministic: change one input, and the payment changes in a predictable way. No guessing, no approximation.
What the formula does not include
The standard mortgage payment formula covers principal and interest only. It does not account for property taxes, homeowners insurance, or private mortgage insurance (PMI). These are real costs that appear on your monthly bill, but they are not part of the amortization calculation.
Property taxes vary by location and property value. Insurance depends on the home's replacement cost and your coverage choices. PMI applies only if your down payment is less than 20%, and it disappears once you reach 20% equity. Your lender will quote these separately and add them to your principal-and-interest payment to show your total monthly housing cost.
Some lenders also include an escrow account in your monthly payment — a holding account for taxes and insurance that the lender pays on your behalf. But the formula itself is just principal and interest.
Using the formula versus using a calculator
You can work through the formula by hand with a scientific calculator, but most people use a mortgage calculator or a spreadsheet. Excel and Google Sheets both have a PMT function that does the calculation when ready: =PMT(rate, nper, pv), where rate is the monthly interest rate, nper is the number of payments, and pv is the loan amount (entered as a negative number).
Understanding the formula matters because it shows you why your payment is what it is. When a lender quotes you a rate, you can verify the payment yourself. When you are deciding between a 15-year and 30-year mortgage, the formula explains the trade-off. When interest rates drop and you consider refinancing, you can estimate what your new payment would be before you call the lender.
Frequently Asked Questions
Does the formula change if I make extra principal payments?
No. The formula calculates your required monthly payment assuming you make only that payment each month. If you pay extra toward principal, you reduce the balance faster, which shortens the loan term and reduces total interest. But the formula itself stays the same — it is the lender's calculation of what you owe each month, not a prediction of what you will actually pay.
Why do lenders use this formula instead of just dividing the total cost by the number of months?
Because you are borrowing money, not buying it outright. The lender charges interest on the outstanding balance each month. If they divided total cost by months, they would be ignoring the fact that as you pay down principal, the balance shrinks and so does the interest owed. The formula accounts for this by front-loading interest and back-loading principal.
What happens to the formula if I have an adjustable-rate mortgage?
The formula applies only to the fixed-rate portion of your loan. With an ARM, the interest rate changes at set intervals — say, every five years. When the rate adjusts, the lender recalculates your payment using the formula with the new rate, the remaining balance as the new principal, and the remaining months as the new term. Your payment can go up or down depending on whether rates have risen or fallen.
Can I use the formula to calculate what loan amount I can afford?
Yes, but you have to rearrange it. If you know your monthly budget, the interest rate, and the loan term, you can solve for P (principal). Most lenders do this for you when you ask what price range you can afford. The formula works in both directions.