How to Calculate Your Monthly Mortgage Payment
The Basic Formula for Monthly Mortgage Payment
Your monthly mortgage payment comes from a formula that takes three pieces of information: the loan amount you borrowed, the interest rate your lender charges, and how many months you have to pay it back. The formula is called an amortization calculation, and it produces a single number that covers principal (the money you borrowed) and interest (the cost of borrowing it) in one payment.
The formula itself is: M = P [ r(1 + r)^n ] / [ (1 + r)^n – 1 ], where M is your monthly payment, P is the principal loan amount, r is your 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 or do it by hand — a mortgage calculator or spreadsheet will do the math for you — but understanding what goes into it helps you see why small changes in interest rate or loan term shift your payment so much.
Key Takeaways
- Your monthly payment depends on three factors: how much you borrowed, your interest rate, and how many years you have to repay it.
- A mortgage calculator or spreadsheet formula will compute your payment in seconds; doing it by hand with the amortization formula is slow and error-prone.
- Changing your loan term from 30 years to 15 years raises your monthly payment but cuts the total interest you pay over the life of the loan.
- Your actual monthly payment may be higher than the principal-and-interest number because it often includes property taxes, homeowners insurance, and mortgage insurance.
- Lenders provide a loan estimate within three days of your application that shows your exact monthly payment and all the costs rolled into it.
Using a Mortgage Calculator
The fastest way to find your monthly payment is to enter your loan amount, interest rate, and loan term into a mortgage calculator. Most banks and mortgage lenders have one on their website, and many are free and do not require you to enter personal information. You can also use a spreadsheet like Excel or Google Sheets with a built-in PMT function, which takes the same three inputs and returns your payment in seconds.
When you use a calculator, start with the numbers from your loan estimate or pre-approval letter. The loan amount is the principal — the total you are borrowing after your down payment. The interest rate is the annual percentage rate (APR) your lender quoted you. The loan term is almost always 30 years for a conventional mortgage, though 15-year and 20-year terms are also common. Enter those three numbers and the calculator shows you the monthly principal-and-interest payment.
Understanding Principal, Interest, and the Amortization Schedule
In your first payment, most of the money goes toward interest and only a small portion toward principal. As you pay down the loan over time, that ratio flips — later payments put more money toward principal and less toward interest. This is called amortization, and it is why your loan balance drops slowly at first and then faster as you approach the end of the loan.
An amortization schedule is a month-by-month table showing how much of each payment goes to principal, how much goes to interest, and what your remaining balance is after that payment. Your lender will provide this schedule, or you can generate one using a spreadsheet. Looking at your schedule helps you see why paying extra toward principal early in the loan saves you so much interest over 30 years — each extra dollar you pay now reduces the balance that future interest is calculated on.
For example, on a $300,000 loan at 6.5% interest over 30 years, your first payment might be $1,896, with $1,625 going to interest and $271 going to principal. By payment 300 (near the end), that same $1,896 might be split as $50 to interest and $1,846 to principal. The total you pay over 30 years is roughly $682,000 — more than double what you borrowed — almost all of that extra cost is interest.
How Loan Term Changes Your Monthly Payment
Shortening your loan term raises your monthly payment but cuts the total interest you pay. A 15-year mortgage costs more per month than a 30-year mortgage on the same loan amount and interest rate, because you are paying back the money in half the time. On that $300,000 loan at 6.5%, a 30-year term gives you a $1,896 monthly payment, while a 15-year term raises it to about $2,896 — roughly $1,000 more per month. But over 15 years, you pay only about $421,000 total instead of $682,000, saving you more than $260,000 in interest.
The trade-off is cash flow: the higher monthly payment on a shorter loan means less money available for other expenses, savings, or emergencies. Some people choose a 30-year loan for the lower payment and then pay extra toward principal when they can afford it, which gives them flexibility. Others choose a 15-year loan from the start if their income is stable and they want to own the home free and clear faster. Your choice depends on your budget and your priorities.
What Happens When Interest Rates Change
A higher interest rate raises your monthly payment on a new loan, even if the loan amount and term stay the same. On that $300,000 loan over 30 years, a 5.5% interest rate gives you a payment of about $1,703, while a 7.5% rate raises it to about $2,098 — a difference of $395 per month, or $142,200 over the life of the loan. This is why shopping around with multiple lenders matters: a difference of even 0.5% in interest rate can save or cost you tens of thousands of dollars.
Your interest rate depends on several factors: the current market rate (which moves with the Federal Reserve and economic conditions), your credit score, your down payment size, your debt-to-income ratio, and the type of loan (conventional, FHA, VA, or USDA). Lenders offer you a rate based on these factors, and you can often lock that rate for 30 to 60 days while you shop for a home. If rates drop during that time, you may be able to refinance later — taking out a new loan at the lower rate to pay off the old one — though refinancing has its own costs.
The Difference Between Principal-and-Interest and Your Full Monthly Payment
The number your calculator shows you — the principal-and-interest payment — is not always the number that comes out of your bank account each month. Your actual payment often includes four things, sometimes called PITI: principal, interest, taxes, and insurance. Property taxes and homeowners insurance are added to your mortgage payment and held in an escrow account by your lender, who pays those bills on your behalf when they come due.
If you put down less than 20% on a conventional loan, your lender also requires private mortgage insurance (PMI), which protects the lender if you default. PMI is added to your monthly payment and typically costs between 0.5% and 1.5% of your loan amount per year, divided into 12 monthly payments. On a $300,000 loan, that might be $125 to $375 per month. PMI drops off automatically once your loan balance falls to 80% of the home's original purchase price, though you can request removal earlier if your home has gained value and you have paid down the loan.
Your loan estimate from the lender shows all four components separately, so you can see exactly what your full monthly payment will be. This is the number you should use when deciding whether the mortgage fits your budget.
Using a Spreadsheet to Build Your Own Calculator
If you want to experiment with different loan amounts, rates, or terms without visiting multiple calculator websites, you can build a simple spreadsheet in Excel or Google Sheets. In Google Sheets, the PMT function works like this: =PMT(rate, nper, pv), where rate is your monthly interest rate (annual rate divided by 12), nper is the number of payments (years times 12), and pv is the loan amount as a negative number.
For example, to calculate the payment on a $300,000 loan at 6.5% annual interest over 30 years, you would enter: =PMT(0.065/12, 30*12, -300000). The result is your monthly principal-and-interest payment. You can then change any of those numbers and see how the payment shifts. This approach is useful if you are comparing different scenarios — what if I put down 15% instead of 10%, or what if rates are 6% instead of 6.5% — because you can see all the results side by side.
Frequently Asked Questions
Does my monthly payment include property taxes and insurance?
Not always. The principal-and-interest number from a calculator does not include them. Your lender will add property taxes and homeowners insurance to your payment if you have an escrow account, which most borrowers do. Your loan estimate shows the full payment with all four components (PITI), so that is the number to use for budgeting.
What if I want to pay off my mortgage early?
You can pay extra toward principal any time without penalty on most conventional mortgages. Even an extra $100 or $200 per month cuts years off your loan and saves significant interest. Some lenders charge a prepayment penalty if you pay off the entire loan within a certain period (often three to five years), so check your loan documents before you sign.
How do I know if my interest rate is competitive?
Shop with at least three lenders and compare the interest rates they offer you. Rates change daily and depend on your credit score, down payment, and loan type, so the rate one lender quotes you may differ from another's. Ask each lender for a loan estimate, which shows your rate, your monthly payment, and all closing costs — this lets you compare apples to apples.
Can I change my loan term after I sign?
You cannot change the term of your existing loan without refinancing, which means taking out a new loan to pay off the old one. Refinancing has closing costs (typically 2% to 5% of the loan amount), so it only makes sense if you will stay in the home long enough to recoup those costs through lower payments or a lower interest rate.
What is the difference between APR and interest rate?
The interest rate is the percentage you pay on the loan itself. The APR (annual percentage rate) includes the interest rate plus other costs like origination fees and points, expressed as a yearly rate. For comparing loans, the APR is more useful because it shows the true cost of borrowing. Your loan estimate shows both numbers.