calculate-loan

01 Loan payments

House Early Payoff Calculator: See Your New Payoff Date

Calculator No. 01-18937 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A house early payoff calculator estimates how many months it may take to repay a mortgage when you add a fixed extra amount to each monthly principal-and-interest payment. Enter the remaining loan balance, annual interest rate, remaining term, and extra monthly payment to see the estimated payoff time, total interest, and interest saved against the scheduled-payment estimate.

Formula

The calculator first finds the scheduled monthly principal-and-interest payment, then adds the extra monthly payment to calculate an estimated payoff period. It uses the standard amortizing-loan payment formula and solves for the number of level payments needed to repay the balance.

  • Scheduled payment: M = B × r / [1 − (1 + r)−n]
  • Monthly rate: r = APR / 1200
  • Payment including extra: A = M + E
  • Months to payoff: k = ceil[−ln(1 − rB/A) / ln(1 + r)]
  • Interest with extra payments: Iextra = max(0, k × A − B)
  • Interest saved estimate: Ischeduled − Iextra, where Ischeduled = M × n − B

B is the current principal balance in dollars; APR is the annual percentage rate entered as a percent; r is the monthly rate as a decimal; n is the remaining scheduled term in months; M is the scheduled monthly principal-and-interest payment in dollars; E is the additional monthly amount in dollars; A is the combined payment in dollars; and k is rounded up to a whole month. The estimate treats each payment as level. The final payment may be smaller than A in an actual amortization schedule.

Worked Example

Using the calculator defaults: balance B = $300,000, APR = 6.5%, remaining term = 25 years, and extra payment E = $300 per month.

  1. Convert the rate and term: r = 6.5 / 1200 = 0.005416667 per month; n = 25 × 12 = 300 months.
  2. Calculate the scheduled payment: M = 300,000 × 0.005416667 / [1 − (1.005416667)−300] = $2,025.89, rounded to cents.
  3. Add the extra: A = $2,025.89 + $300 = $2,325.89 per month.
  4. Solve for payoff months: −ln(1 − 0.005416667 × 300,000 / 2,325.89) / ln(1.005416667) ≈ 203.9, so the displayed whole-month estimate is 204 months.
  5. Estimate interest with extra payments: 204 × $2,325.89 − $300,000 = $174,481.56.
  6. Scheduled interest estimate: 300 × $2,025.89 − $300,000 = $307,767.00. Estimated interest saved: $307,767.00 − $174,481.56 = $133,285.44.

Because the month count is rounded up, multiplying the full assumed payment by every month slightly overstates what an actual final, smaller payment might be. The displayed figures follow the calculator’s stated whole-month method.

Assumptions

  • The interest rate stays fixed throughout the estimate.
  • Payments occur monthly, with the extra amount applied to principal as part of each payment.
  • Interest compounds monthly at APR / 12.
  • The calculation covers principal and interest only. It excludes fees, taxes, insurance, PMI, escrow, and any charges for making extra payments.

How to Use an Early Payoff Estimate

Use the current unpaid principal balance, not the home’s purchase price or the original loan amount. The remaining term should reflect the time left on the mortgage. If you do not know the principal balance or rate, check a recent mortgage statement or ask the loan servicer for the relevant figures; the calculator cannot infer them.

The extra-payment field represents a repeating monthly amount. A one-time lump-sum payment, irregular extra payments, or a changing monthly amount requires a month-by-month amortization schedule for a closer estimate. Also check how the servicer applies additional money: the model assumes it reduces principal rather than being held for a future payment.

  • Enter the current balance and remaining term, rather than the original figures.
  • Use the loan’s applicable rate as an annual percentage, not the monthly rate.
  • Enter only the extra amount beyond the scheduled principal-and-interest payment.
  • Compare the result with a statement or servicer-provided payoff projection if exact timing matters.

How to Read the Results

The first result is the estimated number of monthly payments. Divide it by 12 for an approximate number of years; the final partial year is not shown separately. The interest result is an arithmetic estimate based on the assumed balance, rate, and payment pattern. “Interest saved” compares that estimate with the same loan paid at the scheduled level payment, without extra payments.

These figures do not show a formal payoff quote. A payoff quote can include interest accrued through a specific date and other loan-specific amounts that are not included in this calculation. The total monthly mortgage bill may also include escrow items, which do not repay principal and are not part of the model.

Common Errors and Limits

  • Using the wrong balance: The starting point is the remaining principal, not the original mortgage amount or a statement’s total amount due.
  • Mixing up rates: APR is entered as a percentage per year; the formula converts it to a monthly decimal. Do not enter 0.0054 as the APR.
  • Assuming every loan is fixed-rate: A changing rate, payment recast, or loan modification can make the projected date inaccurate.
  • Overlooking payment application: The estimate assumes extra money is credited to principal promptly. Payment timing and servicing practices can affect actual interest.
  • Relying on rounded values: Payment rounding and the whole-month ceiling cause small differences from a lender’s detailed schedule, especially near the final payment.

The formula also assumes the extra amount is paid every month and does not account for skipped or late payments, missed payments, fees, or one-off principal reductions. It is a comparison tool, not a statement of the amount required to close the mortgage on a particular date.

Frequently Asked Questions

How do I calculate how early I can pay off my house?
Enter the remaining principal, annual rate, remaining term, and recurring extra monthly payment. The calculator estimates the number of payments needed using a fixed-rate amortization formula.

Does paying extra on a mortgage reduce interest?
In this model, an extra payment applied to principal lowers the balance on which later interest is calculated. The estimated savings depend on the balance, rate, timing, and amount of additional payments.

Should I enter my full mortgage payment?
No. Enter the scheduled principal-and-interest payment only indirectly through the balance, rate, and remaining term; the extra field is the additional amount. Taxes, insurance, and escrow are outside the calculation.

Can I use this calculator for a variable-rate mortgage?
It can show a hypothetical estimate using the rate entered, but it assumes that rate remains unchanged. If the rate changes, the actual payment and payoff timeline may differ.

Why does my lender show a different payoff amount?
A lender’s payoff quote may use a specific payment date and include accrued interest or other loan-specific amounts. This calculator estimates principal-and-interest payoff timing and is not a payoff quote.

This result is an estimate for education, and the lender’s disclosure gives the exact figures.

Related

Formula used
in bal | Remaining mortgage balance | $ | 300000 | 1 | 100000000
in apr | Interest rate (APR) | % | 6.5 | 0.01 | 100
in yrs | Remaining term | years | 25 | 0.0833 | 50
in extra | Extra monthly principal payment | $ | 300 | 0 | 100000000
out months | Months to payoff with extra payments | months | ceil(round(-ln(1 - (apr / 1200) * bal / (bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) + extra)) / ln(1 + apr / 1200), 6)) | 0
out int | Estimated interest with extra payments | $ | max(0, months * ((bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) + extra) - bal) | 2
out save | Estimated interest saved | $ | max(0, (bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * yrs * 12 - bal - int) | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →