How to Calculate Your Monthly Mortgage Payment
The Basic Mortgage Payment Formula
Your monthly mortgage payment comes from a formula that takes three numbers: the loan amount you borrowed, the interest rate your lender charges, and how many months you have to pay it back. The formula is not something you need to memorize—a calculator or spreadsheet does the work—but understanding what goes into it helps you see why your payment is what it is.
The standard formula is called the amortization calculation. It divides your total loan into equal monthly payments that cover both principal (the money you borrowed) and interest (what the lender charges you for lending it). Early payments are mostly interest; later payments are mostly principal. By the end of the loan term, you will have paid back everything.
Key Takeaways
- Your monthly payment depends on three things: how much you borrowed, your interest rate, and your loan term in years.
- You can calculate your payment using a mortgage calculator, a spreadsheet formula, or by hand if you understand the math behind it.
- The same loan amount at a lower interest rate produces a lower monthly payment, and a longer loan term spreads payments over more months.
- Your actual monthly payment may be higher than the principal-and-interest number because it often includes property taxes, insurance, and mortgage insurance.
- Changing any one of the three inputs—loan amount, rate, or term—changes your payment, so you can use this to compare different loan offers.
The Three Numbers You Need
Loan amount is the principal—the money you actually borrowed after your down payment. If you buy a house for $300,000 and put down $60,000, your loan amount is $240,000. This is the number that goes into the formula.
Interest rate is the percentage the lender charges you per year. A 6.5% rate means the lender charges 6.5% of the remaining balance each year. This rate is fixed (stays the same for the life of the loan) or adjustable (changes after an initial period), depending on your loan type. The formula uses the monthly rate, which is the annual rate divided by 12.
Loan term is how many years you have to pay back the loan. The most common terms are 15 years and 30 years. A 30-year loan spreads payments over 360 months; a 15-year loan spreads them over 180 months. The longer the term, the lower your monthly payment—but you pay more interest overall because you are borrowing the money for longer.
Using a Mortgage Calculator
The fastest way to calculate your payment is to use an online mortgage calculator. You enter your loan amount, interest rate, and loan term, and the calculator shows your monthly principal-and-interest payment instantly. Most calculators also let you add property taxes, homeowners insurance, and mortgage insurance to see your full monthly housing cost.
Mortgage calculators are free and widely available. Your lender usually provides one on their website. You can also find them on real estate sites, financial websites, and banking platforms. The math inside them is always the same, so the result should be identical no matter which calculator you use—as long as you enter the same three numbers.
A calculator is useful for comparing scenarios. You can enter a $300,000 loan at 6.5% for 30 years, see the payment, then change the rate to 6.0% and see how much lower the payment becomes. This helps you understand the real cost of different interest rates or loan terms before you commit.
The Spreadsheet Formula
If you use Excel, Google Sheets, or another spreadsheet program, you can calculate your payment using the PMT function. The formula is: =PMT(rate, nper, pv), where rate is your monthly interest rate, nper is the number of months, and pv is the loan amount as a negative number.
For example, a $240,000 loan at 6.5% annual interest for 30 years would be: =PMT(0.065/12, 360, -240000). The spreadsheet returns 1,520.06, meaning your monthly principal-and-interest payment is $1,520.06. The formula handles all the amortization math automatically.
Spreadsheets are useful if you are comparing many scenarios or building a larger financial plan. You can set up a table with different loan amounts, rates, and terms, and the spreadsheet calculates all the payments at once. You can also build an amortization schedule—a month-by-month breakdown showing how much of each payment goes to principal and how much goes to interest.
Calculating by Hand (The Math Behind It)
The full amortization formula is: M = P [ r(1 + r)^n ] / [ (1 + r)^n – 1 ], where M is your monthly payment, P is the principal, r is the monthly interest rate, and n is the number of months. This formula looks intimidating, but it is just a way of spreading the loan evenly across all your payments while accounting for interest.
You do not need to memorize or use this formula yourself—calculators and spreadsheets do it for you. But understanding that it exists helps explain why your payment is what it is. The formula ensures that every month you pay the same amount, even though the split between principal and interest changes over time.
If you want to work through an example by hand, you can, but it requires a calculator that handles exponents. Most people find it faster and less error-prone to use a mortgage calculator or spreadsheet instead. The point is to understand what the numbers mean, not to do the arithmetic yourself.
What Happens When You Change One Number
Your payment is sensitive to all three inputs. If you lower your interest rate by 0.5%, your monthly payment drops noticeably. If you extend your loan term from 30 years to 40 years, your monthly payment falls—but you pay much more interest over the life of the loan. If you increase your down payment (lowering your loan amount), your payment shrinks.
This is why comparing loan offers matters. Two lenders might offer different rates or terms. A lower rate saves you money every month and over the life of the loan. A longer term lowers your monthly payment but costs you more in total interest. A spreadsheet or calculator lets you see these trade-offs side by side before you decide.
Beyond Principal and Interest: Your Full Monthly Payment
The number you calculate—principal and interest—is only part of what you actually pay each month. Your full mortgage payment often includes four things, sometimes called PITI: principal, interest, taxes, and insurance.
Property taxes vary by location and are usually collected by your lender and paid to your local government. Homeowners insurance protects your house and is required by your lender. Mortgage insurance (PMI) is required if your down payment is less than 20% and protects the lender if you default. Some loans also include HOA fees if you live in a community with a homeowners association.
Your lender can tell you the estimated taxes and insurance for your property and show you the full monthly payment including everything. This full number is what you actually budget for each month, even though only the principal-and-interest portion goes toward paying off the loan itself.
Frequently Asked Questions
Does the interest rate change my monthly payment?
Yes, significantly. A lower interest rate means a lower monthly payment on the same loan amount and term. For example, a $240,000 loan at 6.0% for 30 years costs about $1,439 per month, while the same loan at 7.0% costs about $1,596 per month. The 1% difference adds up to roughly $157 more per month.
What is the difference between a 15-year and 30-year mortgage?
A 15-year mortgage has a higher monthly payment but you pay off the loan faster and pay much less total interest. A 30-year mortgage has a lower monthly payment but takes twice as long to pay off and costs significantly more in interest. The choice depends on whether you prioritize lower monthly payments or paying less interest overall.
Can I calculate what my payment will be if I put down more money?
Yes. Your down payment reduces your loan amount, which reduces your monthly payment. If you put down $80,000 instead of $60,000 on a $300,000 house, your loan amount drops from $240,000 to $220,000, and your monthly payment drops accordingly. Use a calculator and enter the lower loan amount to see the new payment.
Why does my actual monthly payment not match the calculator result?
The calculator usually shows only principal and interest. Your actual payment includes property taxes, homeowners insurance, and possibly mortgage insurance, which vary by location and your loan details. Ask your lender for a loan estimate, which shows all four components and your true monthly payment.
What happens to my payment if interest rates drop after I lock in my rate?
Your payment stays the same because you locked in your rate with your lender. However, you could refinance your loan with a new lender at the lower rate, which would lower your payment. Refinancing involves closing costs, so you need to calculate whether the monthly savings justify the upfront expense.