How to Calculate What Your Monthly Mortgage Payment Will Be
The basic formula: principal, interest rate, and loan term
Your monthly mortgage payment comes down to three numbers: how much you borrowed, what interest rate the lender charges, and how many months you have to pay it back. The lender uses a standard formula to divide the total cost across all those months so you pay the same amount each time.
If you borrowed $300,000 at 6.5% interest over 30 years, that is not simply $300,000 divided by 360 months. The interest compounds — you pay interest on the remaining balance each month, and as that balance shrinks, so does the interest portion of your payment. The formula accounts for this automatically, which is why a calculator or spreadsheet is far easier than doing it by hand.
Key Takeaways
- Your payment depends on three things: the loan amount, the interest rate, and the number of years to repay, and small changes in any of these shift your payment by hundreds of dollars per month.
- You can calculate your payment using an online mortgage calculator, a spreadsheet formula, or by asking your lender — all three will give you the same answer.
- Your actual monthly bill includes property taxes and homeowners insurance on top of the principal and interest payment, so the total is usually higher than the calculation alone.
- The interest rate you see advertised is not always the rate you will receive — it depends on your credit score, down payment size, and the specific loan program you choose.
- Changing your loan term from 30 years to 15 years cuts the total interest you pay but raises your monthly payment significantly.
Using an online calculator to find your payment
The fastest way to see what your payment will be is to enter your numbers into a mortgage calculator on a lender's website or a financial site. You type in the loan amount, the interest rate, and the loan term in years, and the calculator shows your monthly principal and interest payment instantly.
Most calculators also let you add property taxes and homeowners insurance, which gives you the full monthly cost you would actually owe. Some lenders' calculators will also show you how much of each payment goes toward principal versus interest — in the early months, most of your payment covers interest, but as time goes on, more goes toward principal.
The calculator does not lock you into anything. It is just a way to see the numbers before you talk to a lender or commit to a loan.
How to use the mortgage payment formula in a spreadsheet
If you want to calculate the payment yourself using Excel, Google Sheets, or another spreadsheet program, the formula is straightforward. In most spreadsheet programs, you use the PMT function, which stands for payment.
The formula looks like this: =PMT(rate, nper, pv). Here, "rate" is your monthly interest rate (the annual rate divided by 12), "nper" is the total number of payments (years times 12), and "pv" is the loan amount as a negative number. For a $300,000 loan at 6.5% annual interest over 30 years, you would type: =PMT(0.065/12, 30*12, -300000). The spreadsheet returns your monthly principal and interest payment.
This method works the same way across all spreadsheet programs, though the exact syntax may vary slightly. If you are not sure, searching for "PMT function" plus your program name will show you the exact format.
What happens when you change the loan term
The number of years you choose to repay the loan has a huge effect on your monthly payment and the total interest you pay over time. A 15-year mortgage has a higher monthly payment than a 30-year mortgage on the same loan amount and interest rate, because you are paying off the balance in half the time.
On a $300,000 loan at 6.5% interest, a 30-year term gives you a monthly payment of roughly $1,896. The same loan over 15 years raises the monthly payment to roughly $2,596 — about $700 more per month. But over the life of the loan, you pay far less interest: the 30-year loan costs you about $382,000 in total interest, while the 15-year loan costs about $167,000. That is a difference of over $215,000.
Some people choose a 15-year term if they can afford the higher payment and want to build equity faster. Others stick with 30 years to keep the monthly payment lower, even though they pay more interest overall. There is no right answer — it depends on your budget and your goals.
How interest rates change your payment
Even a small difference in interest rate shifts your monthly payment noticeably. On a $300,000 loan over 30 years, the difference between 6% and 7% interest is about $200 per month — $1,799 versus $1,996. Over 30 years, that small rate difference costs you an extra $72,000 in total interest.
Your interest rate depends on several factors: your credit score, the size of your down payment, the type of loan program (conventional, FHA, VA, USDA), current market rates, and the lender you choose. Two people with different credit scores applying on the same day may receive different rates. Shopping with multiple lenders can show you the range of rates available to you.
Some lenders offer a rate lock, which freezes your interest rate for a set number of days while your loan is being processed. This protects you if rates rise before your loan closes, but if rates fall, you are stuck with the higher locked rate unless you pay a fee to renegotiate.
The difference between principal-and-interest and your total monthly payment
When you calculate your payment using a formula or calculator, you are finding just the principal and interest portion. Your actual monthly mortgage bill usually includes three other costs: property taxes, homeowners insurance, and sometimes mortgage insurance.
Property taxes vary by location and are set by your county or municipality — they are not part of the loan itself, but your lender requires you to pay them as part of your monthly mortgage payment. Homeowners insurance protects the lender's investment in case of fire, theft, or other damage. If you put down less than 20%, your lender also requires private mortgage insurance (PMI), which protects the lender if you default.
A common way to express the full payment is PITI: Principal, Interest, Taxes, and Insurance. If your principal and interest is $1,896, your property taxes are $300 per month, your insurance is $150, and you have PMI of $200, your total PITI payment is $2,546. That is what you actually send to your lender each month.
What to do if the payment is higher than you expected
If your calculated payment is too high for your budget, you have a few options. The first is to borrow less money — a smaller loan amount lowers your payment proportionally. The second is to extend the loan term — a 40-year mortgage exists in some cases and lowers the payment further, though you pay significantly more interest over time.
The third option is to wait and save for a larger down payment. A bigger down payment reduces the amount you need to borrow, which lowers your payment. It also may lower your interest rate and eliminate the need for PMI, both of which reduce your total monthly cost.
You can also shop for a better interest rate by applying with multiple lenders. Even a 0.25% rate reduction saves you money each month and over the life of the loan. Some lenders specialize in borrowers with lower credit scores or smaller down payments, so the rate you receive may vary by lender even if your financial situation is the same.
Frequently Asked Questions
Does the payment stay the same every month?
Your principal and interest payment stays the same for the life of a fixed-rate loan. However, your property taxes and insurance may increase over time, so your total monthly payment can go up even though the principal and interest portion does not change.
What is an adjustable-rate mortgage and how does it affect my payment?
An adjustable-rate mortgage (ARM) has an interest rate that starts low but changes after a set period — often 3, 5, 7, or 10 years. When the rate adjusts, your monthly payment changes too. ARMs are riskier because your payment could rise significantly, but they offer a lower starting rate than fixed-rate loans.
Can I pay extra toward principal to lower my total interest?
Yes. Any extra payment you make goes toward principal and reduces the total interest you pay over the life of the loan. Some people pay an extra $100 or $200 per month, or make one extra payment per year. Check your loan documents to make sure there is no prepayment penalty.
How do I know what interest rate I will actually receive?
You will not know your exact rate until you apply and the lender reviews your credit, income, and assets. You can get a rough estimate by checking current rates on lender websites, but your actual rate depends on your individual situation. Getting quotes from multiple lenders shows you the range of rates you may receive.
What if I want to refinance later and get a lower payment?
Refinancing means taking out a new loan to pay off your existing loan. If interest rates drop, you can refinance at a lower rate and lower your monthly payment. However, refinancing involves closing costs and a new application process, so you need to calculate whether the savings are worth the upfront expense.