How to Calculate Your Monthly Home Payment
The basic formula for a monthly mortgage payment
Your monthly payment depends on three things: the loan amount, the interest rate, and how many months you have to repay it. Lenders use a standard formula that accounts for all three at once, rather than dividing the total by the number of months.
The formula is: 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. You do not need to do this by hand — a mortgage calculator or spreadsheet will do it for you — but understanding what goes into the number helps you see how changes affect your payment.
The reason the formula is not simple division is that interest compounds. Early payments cover more interest than principal; later payments cover more principal than interest. The formula spreads the cost so each payment is the same amount.
Key Takeaways
- A mortgage payment calculator takes your loan amount, interest rate, and loan term and produces your monthly payment in seconds.
- A higher interest rate raises your monthly payment; a longer loan term lowers it but costs more in total interest.
- Your actual monthly payment will also include property taxes, homeowners insurance, and possibly mortgage insurance, which vary by location and your down payment.
- You can use a spreadsheet formula or an online calculator to see how different loan amounts, rates, and terms change your payment before you commit.
Using a mortgage calculator
The fastest way to find your payment is to enter three numbers into a mortgage calculator: the loan amount, the annual interest rate, and the loan term in years. Most calculators will show you the monthly principal and interest payment within a second.
Free calculators are available from Bankrate, NerdWallet, and the Consumer Financial Protection Bureau (CFPB). You can also use a spreadsheet: in Excel or Google Sheets, the function is =PMT(rate, nper, pv), where rate is the monthly interest rate (annual rate divided by 12), nper is the number of payments, and pv is the loan amount as a negative number. For example, a $300,000 loan at 6.5% over 30 years would be =PMT(0.065/12, 360, -300000), which returns $1,896.
A calculator shows only principal and interest. Your actual monthly payment to the lender will be higher if you have a mortgage insurance premium, property taxes, or homeowners insurance bundled into your payment — often called PITI (principal, interest, taxes, insurance).
How loan amount affects your payment
The loan amount is the purchase price minus your down payment. A larger down payment means a smaller loan and a smaller monthly payment. The relationship is direct: if you borrow twice as much, your payment doubles (assuming the same rate and term).
For example, a $300,000 loan at 6.5% over 30 years costs $1,896 per month. A $400,000 loan at the same rate and term costs $2,528 per month. The difference is $632, which is exactly 33% more payment for 33% more borrowed.
This is why down payment size matters so much. A 20% down payment on a $400,000 home means borrowing $320,000 instead of $400,000, which saves you $537 per month on a 30-year loan at 6.5%.
How interest rate affects your payment
A higher interest rate raises your monthly payment and the total amount you pay over the life of the loan. The effect is not linear — a 1% increase in rate does not raise your payment by 1%.
On a $300,000 loan over 30 years, the monthly payment is $1,610 at 5.5%, $1,896 at 6.5%, and $2,196 at 7.5%. That is a difference of $586 per month between 5.5% and 7.5%, or about 36% more payment for a 2 percentage point increase in rate. Over 30 years, that 2% difference costs you about $211,000 more in total payments.
Interest rates change daily and depend on your credit score, down payment size, loan term, and the lender. Shopping with multiple lenders can reveal rate differences of 0.25% to 0.5%, which translates to hundreds of dollars per month on a large loan.
How loan term affects your payment
A longer loan term lowers your monthly payment but raises the total interest you pay. A 15-year loan has a higher monthly payment than a 30-year loan on the same amount and rate, but you pay off the debt faster and pay less total interest.
On a $300,000 loan at 6.5%, the monthly payment is $2,717 for 15 years or $1,896 for 30 years. The 15-year payment is $821 higher per month, but over 30 years you pay $295,000 in total interest on the 30-year loan versus $189,000 on the 15-year loan — a difference of $106,000.
Some borrowers choose a 30-year loan for the lower payment and invest the difference, betting that investment returns will exceed the mortgage interest rate. Others choose 15 years to build equity faster and pay less total interest. The choice depends on your cash flow and risk tolerance.
What your payment does not include
The principal and interest payment is only part of what you owe the lender each month. Most mortgage payments also include property taxes and homeowners insurance, which the lender collects and holds in an escrow account before paying the tax assessor and insurance company on your behalf.
If you put down less than 20%, you will also pay private mortgage insurance (PMI), which protects the lender if you default. PMI typically costs 0.5% to 1% of the loan amount per year, divided into 12 monthly payments. On a $300,000 loan, PMI might add $125 to $250 per month.
Property taxes vary widely by location — from less than 0.5% of home value per year in some states to over 2% in others. Homeowners insurance also varies by location, home age, and coverage level. A calculator that includes taxes and insurance will ask for your zip code and estimated home value to estimate these costs, but your actual bill will depend on the specific property and your chosen coverage.
Adjusting your calculation for different scenarios
Once you know the basic formula or have access to a calculator, you can test different scenarios to see what you can afford. Try changing one variable at a time to understand the trade-offs.
If a $400,000 home feels out of reach at current rates, lower the purchase price to $350,000 and recalculate. If the payment is still too high, try a 40-year loan (if your lender offers it) or a larger down payment. If rates drop, recalculate with the new rate to see how much more home you could afford. If you expect a raise, calculate what payment you could handle in two years and work backward to find the home price that fits.
A spreadsheet or calculator lets you build a table of scenarios — different combinations of price, rate, and term — so you can see the full range of what is possible before you talk to a lender.
Frequently Asked Questions
What is the difference between a fixed-rate and adjustable-rate mortgage payment?
A fixed-rate mortgage has the same interest rate and payment for the entire loan term, usually 15 or 30 years. An adjustable-rate mortgage (ARM) has a lower rate for an initial period (often 3, 5, 7, or 10 years), then the rate adjusts annually based on market conditions. Your payment will rise when the rate adjusts. Calculate both to compare the initial payment and the worst-case payment after adjustment.
Does paying extra toward principal lower my monthly payment?
No. Your monthly payment is set when you sign the loan and does not change (on a fixed-rate mortgage). Paying extra goes directly toward principal and reduces the total interest you pay and the number of months until the loan is paid off. You can pay extra without changing your regular payment.
How do I know what interest rate to use in my calculation?
Interest rates change daily. Check current rates from multiple lenders — banks, credit unions, and online mortgage companies — to see the range. Your actual rate will depend on your credit score, down payment size, and loan term. Most lenders will give you a rate quote that is good for 30 to 60 days, so you can lock in a rate before you make an offer on a home.
Can I use a calculator to figure out what home price I can afford?
Yes. Work backward from the monthly payment you can afford. Decide what you can pay each month, subtract estimated taxes and insurance, and use a calculator to find what loan amount that payment supports at your expected interest rate and term. Then add your down payment to find the home price. Remember that lenders also look at your income and debt, so a payment you can technically afford may not be what they will lend you.
What happens to my payment if I refinance?
Refinancing replaces your old loan with a new one, usually at a different rate and term. Your new payment is calculated the same way as your original payment — using the new loan amount, rate, and term. If you refinance a $250,000 remaining balance at a lower rate over 20 years instead of your original 25 years, your new payment will reflect both the lower rate and the shorter term.