How this calculator works
Your monthly payment has up to five parts. Principal pays back the loan, and interest is what the loan costs you. Property tax and homeowners insurance usually go into an escrow account, and the lender pays those bills for you out of it. PMI covers the lender on a conventional loan when you put down less than 20%, and FHA loans charge their own mortgage insurance whatever you put down. HOA dues go to your homeowners or condo association. Plenty of calculators still show only principal and interest, and the Consumer Financial Protection Bureau has warned buyers about exactly that. This one shows all five, and it doesn’t ask for your email.
The boxes start with a $400,000 home, 10% down and a 30-year loan at 7.18%, Freddie Mac’s average on November 5, 2026. You’d borrow $360,000. Principal and interest come to $2,438.77 a month. With property tax at the US median rate of 0.89%, $2,000 a year of insurance and $150 of PMI, the whole payment is $3,052.10.
Principal and interest come from the standard formula: the loan, times the monthly rate, divided by one minus (one plus the monthly rate) to the power of minus the number of payments. “Show the math” writes it out with your numbers. I checked the results to the cent against a widely used online mortgage calculator in four cases, including PMI and extra payments.
Property tax, insurance and escrow
Property tax depends on where you live more than on anything else. The state box fills in the median rate for each state from the Census Bureau’s American Community Survey for 2024: what homeowners paid in property tax, divided by what their homes were worth. It goes from 0.27% in Hawaii to 1.92% in Illinois, and for the whole country it’s 0.89%. Your county, your town and any exemption you get can change it a lot, so if you have the tax bill for the house, use that.
When a house sells, many places reassess it at the new price, and the seller’s exemptions don’t pass to you. A tax estimate based on what the last owner paid can come out too low.
Homeowners insurance is easy to guess too low, and premiums have gone up fast in many states. I didn’t find a recent public figure by state that I trust, so the box starts at $2,000 a year as a placeholder. Get a quote for the actual house, and ask about flood and earthquake coverage, which a standard policy leaves out.
Your rate can be fixed and your payment can still go up. Once a year, the servicer, the company that collects your payment, reviews the escrow account. If taxes or insurance went up, the payment goes up with them. If the account came up short by more than one month’s escrow payment and the servicer asks you to make it up, it has to give you at least 12 months. It can also keep a cushion of up to one sixth of a year’s tax and insurance bills (Regulation X, section 1024.17). The box “Tax, insurance and HOA increase” shows what a yearly rise does to your payment, year by year.
The rate you see and the rate you get
Freddie Mac’s weekly average on November 5, 2026 was 7.18% for a 30-year loan and 6.57% for a 15-year one (Primary Mortgage Market Survey). Over the year before that, the 30-year average moved between 5.98% and 7.40%. It’s an average for borrowers with good to excellent credit who put 20% down on a conventional loan, so your own quote can be higher or lower. The calculator shows the payment one point up and one point down, so you can see how much that matters.
Points let you pay more at closing for a lower rate. One point is 1% of the loan. Put in the points and how much each one lowers the rate, and the calculator tells you how long the lower payment takes to cover what you paid. The APR folds the points, the lender fees and the mortgage insurance into the rate, so it’s the better number to compare between lenders. With the default numbers it comes to 7.533%.
What the house really costs you
With the default numbers, if you sell after 10 years, you’d have paid $471,647 in all. That counts $52,000 at closing and $45,856 of maintenance at 1% of the home’s value a year. With the home growing 3% a year, the sale would give you back $195,092, after $32,254 in selling costs. Owning would cost you $276,554, or $2,304.62 a month.
Change the years you’ll stay and the growth, and watch that number move. With a short stay, closing and selling costs take a bigger bite. The “Rent or buy” tab puts owning and renting side by side.
Paying it off early
Extra payments go straight to the principal, so the interest that money would have cost you never gets charged. With the default loan, $300 more each month pays it off in 21 years and 7 months, 8 years and 5 months sooner, and saves $169,080 of interest.
Biweekly payments work the same way. Half the payment every two weeks is 26 halves, or 13 full payments a year. You don’t need a paid program for that. Adding one twelfth of the payment every month does the same thing, and that’s how the calculator counts biweekly. Whatever you send, check that your servicer puts it toward the principal.
Should you pay extra or invest that money? The calculator shows both. The interest you save is a sure thing. The market gives you a range: over the 69 stretches of 30 years since 1928, the S&P 500 compounded at 8% a year in the worst one, 10.8% in the middle one and 13.6% in the best. That’s the return of an index with dividends, not what any person earned. Investing the difference only works if you keep investing through the bad years, and that takes emotional muscle more than math.
How much house you can afford
The second tab works backwards from your income. The 28/36 rule is the classic one: housing at no more than 28% of your gross income, and housing plus your other debts at no more than 36%. With $100,000 a year and $500 a month of other debts, that’s a home of $300,359 with the default loan.
Lenders often go further. Fannie Mae’s Selling Guide caps all your debts at 36% of income when a person underwrites the loan, up to 45% with strong credit and savings, and at 50% when its automated system approves it. At 50%, the same income fits a home of $485,196, with a payment that leaves much less room every month.
Refinancing: the break-even people get wrong
The usual break-even divides the closing costs by what you save each month. With the default numbers, $6,000 of costs and $190.06 a month saved, that’s 2 years and 8 months. A new 30-year loan starts the clock over, though, and part of the lower payment is just the debt stretched out longer. The third tab also counts what you’d still owe on each loan. By that count, you come out ahead after 3 years and 5 months.
Renting or buying
The last tab follows two people. One buys. The other rents a similar home and invests the cash the buyer spends at closing. After that, each month, whoever spends less invests the difference. The renter’s money grows 7% a year unless you change it, and the answer also shows 4% and 10%, so you see a cautious case and a hopeful one next to the middle. With the default numbers and rent of $2,200 a month rising 3% a year, after 10 years at 7%, buying leaves $195,092 and renting $258,082.
Next to that, the S&P 500’s real stretches of the same length since 1928, the worst, the middle and the best, show what an index did. That’s history, and it doesn’t forecast what comes next. A comparison that leaves out what the renter’s money earns tilts toward buying. This one assumes the renter really invests the difference every month, for years, so keep that in mind if you know you wouldn’t.
S&P 500 is a registered trademark of Standard & Poor’s Financial Services LLC, and the index is a product of S&P Dow Jones Indices LLC. Bufetico isn’t affiliated with them or endorsed by them.
What a mortgage calculator doesn’t see
Some things about your loan a calculator can’t know:
- Your credit score. It moves your rate and your PMI. The calculator doesn’t guess from a score, so put in the rate from your Loan Estimate, the form every lender has to give you.
- Your county’s tax bill. The state rate is a median. The bill for the actual house is the number to use.
- Escrow surprises. Taxes and insurance are reviewed every year, and a shortage can raise the payment for the next 12 months.
- Special assessments. An HOA can charge owners for a big repair on top of the monthly dues.
- Prepaid items at closing. Lenders collect prepaid interest, the first year of insurance and the first escrow deposit at closing. They’re part of the cash you bring, and they vary.
- The end of your PMI. Asking at 80% takes a written request, a good payment record, and sometimes an appraisal you pay for.
- An adjustable rate. What it resets to depends on the market at the time. Put in a higher rate for the year it resets to see the payment you’d face.
- Your plans. A job move in year three changes what the house costs you more than any rate does.
To see what investing the difference could grow to, try the investment calculator. To see what today’s rent turns into with inflation, there’s the inflation calculator.
Questions people ask
How is a mortgage payment calculated?
Principal and interest use the loan, the monthly rate (the yearly rate divided by 12) and the number of payments. On top of that come property tax and insurance divided by 12, mortgage insurance on an FHA loan or on a conventional one with less than 20% down, and HOA dues. With the default numbers, $2,438.77 of principal and interest becomes $3,052.10 a month.
What does PITI mean?
Principal, interest, taxes and insurance: the four parts most lenders collect every month. PMI and HOA dues come on top when you have them.
Why is my real payment higher than the calculator said?
Usually because the calculator left out taxes, insurance or PMI, or guessed them low. The tax bill can also jump after the sale, when the house is reassessed at your price. This calculator puts all of them in the payment, and you can replace every estimate with your own number.
Why did my mortgage payment go up if my rate is fixed?
Because of escrow. Once a year your servicer checks what it paid for your taxes and insurance. If they went up, your payment goes up. If the account ran short by more than one month’s escrow payment and the servicer wants it back, it has to give you at least 12 months. It can also keep a cushion of up to one sixth of a year’s bills (Regulation X, section 1024.17).
How does the calculator estimate property tax?
With the median rate for your state from the Census Bureau’s American Community Survey for 2024: the median tax homeowners paid divided by the median value of their homes. For the whole US that’s $3,211 on a home worth $360,600, or 0.89%. Counties and towns differ a lot, and exemptions like a homestead or a senior exemption lower the bill, so use the real one if you can.
How much is homeowners insurance?
It depends on the house, the state, the coverage and the insurer, and premiums have gone up fast in many places. The box starts at $2,000 a year only as a placeholder. A quote for the actual address is the number to use.
When does PMI go away?
Under the Homeowners Protection Act, once your balance reaches 80% of the home’s original value, you can ask your lender in writing to cancel it. You need a good payment record, and sometimes proof the home hasn’t lost value. It ends on its own when your balance is scheduled to reach 78%, and in any case at the halfway point of the loan (CFPB). Extra payments can get you to 80% sooner. They don’t move the automatic date. With the default loan, PMI lasts 9 years and 8 months on its own, or 8 years and 6 months if you ask at 80%.
How much does PMI cost?
Freddie Mac puts it at about $30 to $70 a month for every $100,000 you borrow. That’s $108 to $252 a month on the default loan. Your credit score and how much you put down decide where you land. The box starts at 0.5% of the loan a year.
How is FHA mortgage insurance different from PMI?
FHA charges 1.75% of the loan upfront, usually added to what you owe, plus a yearly premium paid monthly, whatever you put down. On loans longer than 15 years and up to $726,200, that’s 0.50% or 0.55% of the balance a year. With 10% or more down it lasts 11 years; with less, the whole loan (HUD Mortgagee Letter 2023-05). On a $400,000 home with 3.5% down, that’s $6,755 upfront and $176.13 a month in year one. Refinancing into a conventional loan is the usual way out.
What is the VA funding fee?
A one-time fee on VA loans, paid at closing or added to the loan. For a purchase it’s 2.15% of the loan the first time with less than 5% down, 1.5% with 5% or more, and 1.25% with 10% or more. If you’ve used a VA loan before, the fee with less than 5% down is 3.3%. If you get VA disability compensation, you don’t pay it (VA).
How much are closing costs?
Freddie Mac says about 2% to 5% of the purchase price. They include lender fees, the appraisal, title insurance, government fees and prepaid items like interest, insurance and the first escrow deposit. The box starts at 3%. Your Loan Estimate lists them line by line.
How much cash do I need to buy a house?
The down payment plus the closing costs, plus any points. With the default numbers that’s $52,000. I’d keep some savings after closing too. The first repair never waits long.
Should I buy points?
Only if you’ll keep the loan longer than it takes the lower payment to cover what the points cost. Put in the points and the rate cut per point, and the calculator gives you that time. If you might sell or refinance before then, the points are money lost.
What’s the difference between the interest rate and the APR?
The rate sets your payment. The APR, the annual percentage rate, adds the points, the lender fees and the mortgage insurance to it, spread over the loan. Two loans with the same rate can have different APRs, so compare APRs between lenders.
Which interest rate should I put in?
The one on your Loan Estimate, if you have it. If not, Freddie Mac’s weekly average is a fair start: 7.18% for 30 years and 6.57% for 15 on November 5, 2026. It assumes good to excellent credit and 20% down, so look at the payment one point higher too.
Is a 15-year or a 30-year mortgage better?
A 15-year loan has a higher payment and much less interest. With the default home at 6.57%, principal and interest would be $3,149.86 a month, and the interest $206,974 in all, against $517,956 on the 30-year. A 30-year loan with extra payments gives you some of both, with the freedom to stop paying extra in a bad year.
Do extra payments really save that much?
Yes, because early on most of each payment is interest. With the default loan, $300 more a month saves $169,080 of interest and ends the loan 8 years and 5 months sooner. Put it under “Extra payments” to try your own numbers.
Are biweekly payments worth it?
They add one full payment a year, and that’s what saves the interest. You can do the same for free by adding one twelfth of your payment every month. Some services charge a fee for a biweekly plan, and there’s no need to pay it.
Should I pay off my mortgage early or invest?
The calculator shows both. Paying extra saves interest for certain. Investing the same money has a range of results: over 30-year stretches since 1928, the S&P 500 compounded at 8% a year in the worst one and 13.6% in the best. Those are returns of an index, with dividends put back in. It depends on your rate, your taxes and whether you’d keep investing through a crash.
How much house can I afford?
By the 28/36 rule, housing at no more than 28% of your gross income and all your debts at no more than 36%. The “How much house” tab works it out with your income, debts, down payment and rate. With $100,000 a year and $500 of other debts, that’s $300,359.
What debt-to-income ratio do lenders allow?
Your debt-to-income ratio is all your monthly debt payments divided by your gross monthly income (CFPB). Limits differ by loan and lender. Fannie Mae’s Selling Guide allows up to 36% when a person underwrites the loan, 45% with strong credit and savings, and 50% when its automated system approves it.
When does refinancing make sense?
When you come out ahead within the years you’ll keep the loan, counting what you’d still owe on each one. The “Refinance” tab shows the simple break-even and that fuller one, plus the interest left on each loan.
Is it better to rent or buy?
It depends on how long you stay, the rent, the price and what the renter’s money earns. The “Rent or buy” tab runs both with the renter’s money at 4%, 7% and 10% a year, and puts the S&P 500’s worst, middle and best stretches since 1928 next to it. That’s history, and it doesn’t forecast anything.
Does it include the mortgage interest tax deduction?
No. It only helps if you itemize deductions, and many people take the standard deduction instead. Whether it helps you depends on your whole tax return, so ask a tax professional.
What is a jumbo loan?
A conventional loan above the conforming limit, which for 2026 is $832,750 for a single home in most of the country, and more in high-cost areas (FHFA). Jumbo loans can have different rates and stricter rules.
What happens with an adjustable-rate mortgage?
The rate is fixed for the first years and then changes with the market. Put the year it changes and a new rate under “The years ahead”, and the calculator works out the new payment on what you still owe. It uses one new rate. A real adjustable-rate loan can change again every year or every six months, within its caps.
Why do calculators give slightly different payments?
Some round each month, some start on a different date, and some leave out taxes, insurance or PMI. The formula for principal and interest is the same everywhere.
How do I calculate a mortgage payment in Excel?
Use =PMT(rate/12, years*12, -loan). For the default loan, =PMT(7.18%/12, 360, -360000) gives $2,438.77.
How much should I budget for maintenance?
A common rule of thumb is 1% of the home’s value a year, more for an older house. The calculator uses 1% and lets you change it. It isn’t part of your mortgage payment, but you pay it anyway.
Does it work outside the US?
The math works in any currency, and you can pick yours at the top. The PMI, FHA, VA, tax and rate data follow US rules.