How to Calculate Monthly Mortgage Payment
To calculate your monthly mortgage payment, use the formula M = P × [r(1 + r)n] / [(1 + r)n − 1], where P is the loan amount, r is the monthly interest rate (the annual rate divided by 12), and n is the number of monthly payments. For a $350,000 loan at 6.75% over 30 years, that works out to $2,270.09 a month for principal and interest — before taxes, insurance, and mortgage insurance, which push the real monthly cost higher.
This guide works through that example step by step, so you can repeat it with your own numbers, then adds the costs the formula leaves out. By the end you will have two numbers that matter: the principal-and-interest payment, and the full monthly amount that actually leaves your bank account.
Key takeaways
- The formula gives you principal and interest only. Taxes, homeowners insurance, mortgage insurance, and HOA dues sit on top.
- A $350,000 loan at 6.75% over 30 years costs $2,270.09 a month in principal and interest — $2,995.09 once taxes, insurance, and PMI are added in this guide’s example.
- In the first month, $1,968.75 of that payment is interest and only $301.34 reduces the balance. After five years of payments totalling $136,205, the balance has fallen by just $21,435.
- The same loan over 15 years costs $3,097.18 a month but saves $259,741 in total interest.
- Paying an extra $200 a month clears the 30-year loan in about 23.7 years and saves $114,980 in interest.
The monthly mortgage payment formula
Every fixed-rate mortgage in the US uses the same formula. It finds the single monthly payment that, paid every month, covers that month’s interest and brings the balance to exactly zero on the last payment. Written out:
M = P × [r(1 + r)n] / [(1 + r)n − 1]
| Symbol | What it is | How to get it |
|---|---|---|
| M | Monthly principal-and-interest payment | This is the answer the formula gives you |
| P | Loan amount (principal) | Home price minus your down payment |
| r | Monthly interest rate, as a decimal | Annual rate as a decimal, divided by 12 |
| n | Total number of monthly payments | Loan term in years × 12 (360 for 30 years) |
Three points about the inputs are worth getting right before you touch a calculator. First, P is the amount you borrow, not the price of the house — a $400,000 home with a $50,000 down payment is a $350,000 loan. Second, r is the monthly rate: 6.75% a year becomes 0.0675 ÷ 12 = 0.005625 a month, and using the annual rate by mistake produces a wildly wrong answer. Third, the interest rate in the formula is the note rate on the loan, not the APR. The APR folds lender fees and points into the cost of borrowing for comparing offers; using it in the payment formula overstates your monthly payment. If you are comparing two offers, an APR calculator shows what each one really costs — but keep the note rate for this calculation.
Worked example: $350,000 at 6.75% for 30 years
Here is the formula with real numbers, one step at a time. Keep at least six decimal places for r while you work; rounding it early is the usual reason a hand calculation comes out a few dollars off.
Step 1 — Set the inputs. P = $350,000. Annual rate 6.75%, so r = 0.0675 ÷ 12 = 0.005625. Term 30 years, so n = 30 × 12 = 360 payments.
Step 2 — Work out (1 + r)n. (1.005625)360 = 7.5332. Any scientific calculator or phone calculator handles this with the power key; in Excel it is =POWER(1.005625,360).
Step 3 — Multiply the top of the fraction. P × r × (1 + r)n = 350,000 × 0.005625 × 7.5332 = $14,831.08.
Step 4 — Work out the bottom of the fraction. (1 + r)n − 1 = 7.5332 − 1 = 6.5332.
Step 5 — Divide. M = 14,831.08 ÷ 6.5332 = $2,270.09 a month for principal and interest.
That is the fixed payment for all 360 months, assuming the rate never changes. You can check the result against a mortgage calculator with the same three inputs — it should return the same figure to the cent.
What the formula leaves out: your full monthly payment (PITI)
The $2,270.09 figure is principal and interest only, and for most buyers it is not the number that leaves the bank account. The Consumer Financial Protection Bureau (CFPB) puts the total like this: principal + interest + mortgage insurance (if applicable) + escrow (homeowners insurance and tax) = total monthly payment. Escrow is the account your servicer uses to hold your tax and insurance money and pay those bills on your behalf.
Using the same $350,000 loan, here is what the full payment looks like with realistic add-ons:
| Part of the payment | Monthly amount | How it is worked out |
|---|---|---|
| Principal and interest | $2,270.09 | The formula above |
| Property tax | $400.00 | $4,800 a year ÷ 12 |
| Homeowners insurance | $150.00 | $1,800 a year ÷ 12 |
| Private mortgage insurance (PMI) | $175.00 | 0.6% of the loan a year ÷ 12 |
| Total monthly payment (PITI) | $2,995.09 |
A few things in that table deserve a closer look. Property tax and insurance are yearly bills divided by 12 and collected monthly into escrow; the CFPB notes that the principal-and-interest part generally stays the same on a fixed-rate loan, while the escrow part can change — if your home rises in value, your property tax usually rises with it. PMI applies on a conventional loan when the down payment is under 20% of the purchase price, and it protects the lender, not you; it commonly runs around 0.5% to 1.5% of the loan amount per year, depending on the lender, the down payment, and your credit. And if the home has HOA dues, those are usually paid separately from the mortgage payment but still count as part of your monthly housing cost.
The practical point is the one the CFPB warns about directly: many buyers look only at the principal-and-interest figure and get an unpleasant surprise when the total turns out much higher. Check the total monthly payment on page 1 of the Loan Estimate, under “Projected Payments”, before judging whether you can afford a loan. As a rough check, the CFPB’s home loan toolkit uses the rule of thumb that total monthly housing costs stay at or below 28% of gross monthly income — on a $2,995 monthly payment, that means gross income of roughly $10,700 a month.
Where the money goes: month 1 vs later years
The payment stays fixed, but what it buys changes every month. Interest each month is the current balance times r, and the rest of the payment reduces the balance. In month 1 of the example loan, interest is $350,000 × 0.005625 = $1,968.75, so only $301.34 of the $2,270.09 goes to principal. That is why the balance barely moves at first: after five years and $136,205 in payments, the balance has fallen by just $21,435, to $328,565.
This is normal, not a mistake. The split shifts gradually — each month the balance is slightly smaller, so slightly less interest accrues and slightly more goes to principal. On a 30-year loan the crossover point, where more of the payment goes to principal than to interest, arrives roughly two-thirds of the way through. Knowing this in advance keeps the early statements from looking wrong.
30-year vs 15-year: same loan, very different totals
The term is the biggest lever after the rate. The same $350,000 at 6.75% over 15 years costs $3,097.18 a month — $827.09 more than the 30-year payment — but the totals tell a different story:
| 30 years | 15 years | |
|---|---|---|
| Monthly principal and interest | $2,270.09 | $3,097.18 |
| Total paid over the loan | $817,234 | $557,493 |
| Total interest paid | $467,234 | $207,493 |
The 15-year loan saves $259,741 in interest — more than two-thirds of the amount borrowed — in exchange for a payment about 36% higher. That trade-off is the whole decision: if the higher payment fits comfortably, the shorter term is far cheaper; if it stretches the budget, the 30-year term with occasional extra payments (below) is a workable middle ground. A mortgage affordability calculator can show how each term fits against your income before you commit.
How to calculate it in Excel, Google Sheets, or on your phone
Doing the formula by hand is worth doing once, to understand it. After that, use the PMT function — it is the same formula, and it removes the arithmetic.
In Excel or Google Sheets, type =PMT(0.0675/12, 360, -350000). The three arguments are the monthly rate, the number of payments, and the loan amount as a negative number (so the result comes out positive). It returns $2,270.09 — the same answer as the hand calculation. Replace the three values with your own and the result updates instantly, which makes it easy to test a different rate or term.
On a phone calculator, the sequence is: 1.005625, power key, 360, equals (gives 7.5332), then 350000 × 0.005625 × 7.5332 ÷ 6.5332. It takes about thirty seconds once you know the order. Whichever method you use, the check is the same: the payment must be higher than the first month’s interest ($1,968.75 here), or the balance would never fall.
Fixed rate vs adjustable rate
The formula above assumes the rate stays put for the whole loan. That is true for a fixed-rate mortgage: the payment it produces is the payment for all 360 months. An adjustable-rate mortgage (ARM) works differently. The payment usually starts lower, because the initial rate is lower, but it is only fixed for the introductory period — commonly five, seven, or ten years. When that period ends, the rate adjusts to the market, and the payment is recalculated with the same formula using the new rate and the remaining balance and term. So the formula still applies to an ARM, just not permanently: it answers “what is my payment at this rate, for this remaining term”, and the answer changes each time the rate does.
What extra payments actually save
Paying more than the required amount is the one lever most borrowers control, and the maths is generous because extra money goes straight to principal. Add $200 a month to the example loan — $2,470.09 instead of $2,270.09 — and the loan is paid off in about 284 months, or 23.7 years, instead of 360. Total interest falls by $114,980.
Two practical notes. First, the saving comes from shortening the loan, not from a discount: every extra dollar cuts the balance a month earlier, and every month shaved off removes a month of interest on the whole remaining balance. Second, check with your servicer that extra payments are applied to principal rather than treated as an early payment of next month’s bill — most servicers do this by default, but it is worth confirming, and some loans have prepayment terms worth reading before you start.
Common mistakes when calculating a mortgage payment
- Using the annual rate instead of the monthly rate. Plugging 0.0675 into the formula instead of 0.0675 ÷ 12 gives a payment in the tens of thousands. Always divide by 12 first.
- Using the APR in the formula. The APR is for comparing loan offers, not for calculating the payment. Use the note rate.
- Using the home price instead of the loan amount. Subtract the down payment first, or the payment comes out too high.
- Rounding r too early. Keep six decimal places (0.005625, not 0.006) until the final answer.
- Stopping at principal and interest. The formula’s answer is not the monthly housing cost. Add one-twelfth of annual property tax and insurance, plus PMI and HOA dues, before deciding what you can afford.
- Forgetting the rate can change. On an ARM, today’s payment is not the payment for the life of the loan.
A short note for UK readers
The maths is the same in the UK — a repayment mortgage is amortised exactly the way this guide describes, and the formula works with pounds, years, and the quoted rate just as it does with dollars. What differs is the structure around it: UK rates are commonly fixed for two or five years and then move to the lender’s standard variable rate, so the payment is recalculated at the end of each fixed period in the same way an ARM recalculates. Terms of 25 to 35 years are common. If your offer quotes a fixed period, calculate the payment for that period with the formula above, and remember it is not the payment for the full term.
Frequently asked questions
What is the formula to calculate a monthly mortgage payment?
M = P × [r(1 + r)n] / [(1 + r)n − 1]. P is the loan amount (home price minus down payment), r is the monthly interest rate (annual rate ÷ 12), and n is the total number of monthly payments (years × 12). The result is the monthly principal-and-interest payment on a fixed-rate loan.
How much is the monthly payment on a $350,000 mortgage?
At 6.75% over 30 years, $2,270.09 a month for principal and interest. With property tax, homeowners insurance, and PMI added — $400, $150, and $175 a month in this guide’s example — the full monthly payment is $2,995.09. Your own figure depends on your rate, term, taxes, and insurance.
Does the mortgage formula include taxes and insurance?
No. The formula covers principal and interest only. Add one-twelfth of your annual property tax and homeowners insurance, plus mortgage insurance if your down payment is under 20%, and any HOA dues, to get the total monthly payment.
How do I calculate my mortgage payment in Excel?
Use =PMT(rate/12, years*12, -loan). For the example in this guide, =PMT(0.0675/12, 360, -350000) returns $2,270.09. The same PMT function works in Google Sheets.
Will my monthly mortgage payment stay the same?
The principal-and-interest part stays the same for the life of a fixed-rate loan. The escrow part — taxes and insurance — can change, so the total can move. On an adjustable-rate mortgage, the payment is recalculated whenever the rate adjusts.
This article is educational and is not financial advice. Rates, taxes, insurance, and mortgage insurance vary by lender, location, and borrower — confirm the figures on your own Loan Estimate before making a decision.