Mortgage Payoff Calculator

What a mortgage payoff calculator computes

A payoff calculator starts where a mortgage starts the other way around: from the balance you still owe, not the price of the house. The inputs are the remaining balance, the interest rate, and how many payments are left. Everything else, including the payoff date, comes out of the same monthly payment formula that set the loan up in the first place: M = P x [r(1+r)^n] / [(1+r)^n - 1].

On the default example, $320,000 still owed at 6.5 percent with 27 years to run, the payment is $2,097.78 a month. Interest on the first month is 320,000 x 0.0054167 = 1,733.33 dollars, so only $364.44 of that payment is principal. At this pace the remaining interest alone comes to $359,679.40, which is 52.9 percent of everything you will send in.

Read the last column and the shape of the loan is visible. Five years in you have sent $125,866.55 to the bank and the balance has moved from $320,000 to $294,243.40. Half the payments bring the balance to $225,859.98. Most of what a long mortgage costs is paid in the years you cannot see yet, which is exactly the part a payoff plan can change.

What an extra $200 a month does

Every extra dollar of principal removes interest on that dollar for the rest of the loan, which is why small amounts matter so much at the start of a long term. On the default loan, $200.00 of extra principal each month cuts the payoff from 324 payments to 260, removes 64 payments from the schedule, and saves $82,543.89 of interest.

The $200.00 version is worth pausing on. It is about 9.5 percent on top of the regular payment, and it buys back more than five years of payments and $82,543.89 of interest. The same $200.00 a month invested at a conservative 4 percent after tax would grow to about $14,241.49 over those 64 months, far short of the interest it removes by staying in the loan.

The pattern across the table is close to linear: every extra $100 a month removes roughly 15 to 20 payments from a loan of this size, and the interest saved compounds as the extra amount grows. Moving from $200 to $400 a month adds 40 more payments saved and about $50,000 more interest saved.

Biweekly payments and the extra half payment

A biweekly plan sends half of the regular payment every two weeks. Because there are 52 weeks in a year, that is 26 half payments, or 13 full payments, instead of 12: 26 x 1,048.89 = 27,271.14 dollars a year, the same as 13 x 2,097.78. On the default loan the half payment is $1,048.89, and 26 of them add up to the same thing as paying $174.81 extra each month.

The two biweekly rows are the same plan written two ways, and they show what the marketing does not always say: the saving comes from the extra payment, not from the frequency. Paying $2,272.59 once a month does exactly the same job as paying half every two weeks, without signing up for a service. Some servicers charge a fee to set up a biweekly plan, and a free version of the same plan is to divide the payment by 12 and add that amount to each monthly check.

One caution. A biweekly plan only works the way advertised if the servicer applies the extra half payment to principal when it arrives, rather than holding it until the full payment accumulates. Ask before enrolling, and check the first statement to confirm where the extra went.

One lump sum against a monthly habit

A lump sum works the same way as extra principal: it removes interest on the amount for every remaining month. The difference is timing. A lump sum applies today, so it saves interest for the whole life of the loan, while a monthly habit builds up gradually.

A $25,000.00 lump sum removes $97,694.27 of interest and 58 payments, which beats the $200.00 monthly habit on interest saved. But it is $25,000 gone from your savings on day one, and that money is hard to get back if the furnace dies the following winter. Extra monthly principal keeps the cash in your hands until the day you send it.

A reasonable way to split the difference is to put windfalls, such as a bonus or a tax refund, into the loan, and keep the regular extra small and steady. The calculator accepts both at once: enter the lump sum and the monthly extra, and it will run the combined schedule.

When PMI ends, and how extra principal changes that

If you put less than 20 percent down, you are probably paying private mortgage insurance on top of principal and interest, and paying down the balance ends it. Under the rules the Consumer Financial Protection Bureau describes, you can request PMI cancellation once the balance falls to 80 percent of the home's original value, and the servicer must end it automatically when the scheduled balance first reaches 78 percent of that value or at the midpoint of the amortization period, whichever comes first.

Here the timing detail matters. Take a house bought for $400,000 with 10 percent down, so the loan starts at $360,000. The 80 percent line sits at $320,000 and the automatic line at $312,000. On the regular schedule the balance does not cross the 80 percent line until payment 95. With $200.00 of extra principal the same line is crossed at payment 64, so PMI can be cancelled 31 payments earlier, and the money freed up can itself go to principal.

The automatic 78 percent date is a different animal. It is keyed to the balance as scheduled, so extra principal does not move it earlier; what moves PMI out early is your written cancellation request at 80 percent, supported by a good payment record and evidence the value has not declined. Ask the servicer for the exact figures, because the original value and the schedule come from your loan documents.

FHA loans work differently, and HUD's guidance sets annual mortgage insurance premiums that run for the life of the loan when the borrower puts down less than 10 percent, or 11 years when the loan to value ratio is 90 percent or less. There is no servicer request that ends it early, so on an FHA loan the fastest route out of mortgage insurance is usually a refinance once the balance and value allow it.

Paying off the mortgage or keeping the money invested

Extra principal is a guaranteed return equal to the loan rate, after tax. At 6.5 percent, a dollar of extra principal saves 6.5 cents a year for the rest of the loan, with no market risk. Whether that beats investing depends on what you would do with the money instead and on the tax side: mortgage interest is deductible only if you itemize, and the IRS explains the rules in Publication 936, so the effective cost of the loan is lower for households that itemize.

Two comparisons are worth running. First, the guaranteed one: no safe investment pays 6.5 percent after tax right now, so if your alternative is a savings account or bonds, the extra principal wins. Second, the risky one: stock returns have historically been higher than 6.5 percent over long periods, but not in every stretch of years, and not with the certainty of the loan saving.

The refinance row shows the other lever. Moving $320,000 from 6.5 percent to 5.75 percent cuts the payment to $1,867.43 and the remaining interest to $352,275.93, but the new 30 year term means 3 more years of payments, and closing costs come out of pocket. Refinance to lower the rate and keep paying the old amount, and you get both the lower rate and a faster payoff.

Before you send extra money, check these five things

Extra principal is simple in principle, and the details decide whether it works. Five checks take ten minutes and prevent most of the mistakes people make.

First, check the note for a prepayment penalty. The CFPB explains that a penalty usually applies to paying the loan off entirely, often within the first three to five years, and that small extra principal payments normally do not trigger one. Read your note rather than assume.

Second, mark the extra money as principal. A payment marked nothing special can be posted against next month's bill instead, which reschedules the loan and saves nothing. Most servicers have a principal only option online; if not, include a note and confirm the next statement.

Third, confirm there is no fee for paying extra. Some lenders charge for biweekly enrollment, and none of that fee buys anything the free version does not do.

Fourth, keep the escrow intact. Taxes and insurance continue after the loan ends, so a paid off house still has costs, and a payment skip caused by confusion over what is owed can undo a year of extra principal.

Fifth, decide once and automate it. The plans that fail are the ones that depend on remembering. A standing payment that includes the extra amount works whether or not the month is busy.

What this calculator leaves out

The calculator handles principal and interest on a fixed rate loan, extra principal, a one time lump sum, and the payoff date. It does not model several things that affect the real money.

Escrow is the first. Property taxes and homeowner's insurance continue for as long as you own the home, and the payoff date does not change them. A paid off mortgage still costs the escrow amount every month.

Second, an adjustable rate mortgage resets after the fixed period, and this tool assumes the rate you enter holds for every remaining payment. Run the numbers again at the maximum rate in the note before relying on the schedule.

Third, the calculator does not price the costs of refinancing, which can run to thousands of dollars and change the comparison in the refinance table above, and it does not model selling the house, since a sale pays the loan off on its own schedule.

Fourth, the payoff date assumes the next payment lands next month and every payment after that arrives on time. Late payments, a forbearance, or a modification all move the date. Treat the output as the plan, and confirm the final figures with the servicer before wiring a large payoff, since per diem interest on the closing day is theirs to calculate.