calculate-loan

01 Loan payments

Extra Mortgage Payments Payoff Calculator

Calculator No. 01-10580 · 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.

This extra mortgage payments payoff calculator estimates how additional monthly principal payments change your payoff time and total interest. Enter your current mortgage balance, annual interest rate, remaining term, and planned extra payment to see the estimated months saved and interest reduction.

Formula

The calculator first finds the scheduled monthly principal-and-interest payment, then estimates the number of monthly payments needed when the extra amount is added. It subtracts the accelerated payoff time from the original remaining term. Interest saved is estimated as scheduled-payment interest over the original term minus interest under the accelerated payment.

  • r = monthly interest rate, calculated as APR ÷ 1,200.
  • P = current mortgage principal balance in dollars.
  • n = remaining scheduled months, calculated as years × 12.
  • M = scheduled monthly principal-and-interest payment in dollars: P × r ÷ [1 − (1 + r)−n], rounded to cents.
  • E = extra monthly principal payment in dollars.
  • k = estimated payoff months with extra payments: round up [−ln(1 − rP/(M + E)) ÷ ln(1 + r)].
  • Months saved = n − k. Estimated interest saved = (M × n − P) − [(M + E) × k − P].

This simplified interest comparison uses the rounded scheduled payment and treats the accelerated payment as a steady monthly amount. Real final payments are usually smaller than a full payment if the remaining balance is less than the regular amount due.

Worked Example

Using the calculator’s default inputs: balance P = $300,000, APR = 6.5%, remaining term = 25 years, and extra payment E = $200 per month.

  1. Convert the APR to a monthly rate: r = 6.5 ÷ 1,200 = 0.005416667.
  2. Convert the term to months: n = 25 × 12 = 300.
  3. Scheduled payment: M = 300,000 × 0.005416667 ÷ [1 − (1.005416667)−300] = $2,026.14, rounded to cents.
  4. Payment used for the payoff estimate: M + E = $2,226.14. The payoff equation gives k ≈ 234 months after rounding up.
  5. Months saved: 300 − 234 = 66 months.
  6. Original estimated interest: $2,026.14 × 300 − $300,000 = $307,842. Accelerated estimate: $2,226.14 × 234 − $300,000 = $220,916.76. Estimated interest saved: $86,925.24.

These values are estimates from the stated formula, not a lender payoff quote. The calculator models each accelerated payment as the same amount through the estimated payoff month; an actual final payment can differ. Because the displayed savings formula uses a rounded month count and monthly payment, small differences from a detailed amortization schedule are possible.

Assumptions

  • The interest rate remains fixed for the full calculation.
  • Payments occur monthly, with the first regular payment one month from the calculation start; extra principal is paid with each monthly payment.
  • Interest compounds monthly at APR ÷ 12.
  • The calculation excludes fees, taxes, insurance, PMI, escrow, late charges, and any prepayment charge. It assumes extra amounts are applied to principal.

How Extra Payments Change a Mortgage

A scheduled mortgage payment covers interest accrued for the period and reduces principal with the remainder. When an extra amount is applied directly to principal, the balance used to calculate future interest is lower. The effect builds over time: less principal can mean less interest in later periods, allowing more of subsequent payments to reduce the balance.

“Extra payment” can mean different things. This calculator assumes the extra amount is paid every month, in addition to the regular principal-and-interest installment. A one-time lump sum, an extra annual payment, or a biweekly schedule follows a different timeline and is not represented exactly here. Entering the monthly equivalent of an irregular plan can offer a rough comparison, but it does not model the dates or changing payment amounts.

How to Use and Read the Results

  • Use the current unpaid principal balance, not the home’s purchase price or estimated market value.
  • Enter the mortgage’s annual interest rate as a percentage, such as 6.5, not 0.065.
  • Enter the time left on the loan, rather than the original term if payments have already been made.
  • Enter only the extra monthly principal amount. Do not include property tax, homeowners insurance, or escrow in that field.
  • Compare the estimated months saved and interest saved with the scheduled payment shown as a reference.

The outputs are sensitive to the inputs. A small balance or term error can materially affect the estimate, and rounding to whole months means the result is not an exact calendar payoff date. The scheduled payment is principal and interest only; a monthly mortgage bill can be higher when it includes escrow or other items.

Common Issues and Limits

Check the loan statement or servicer records for the unpaid principal, rate, and remaining term. The original loan amount is not necessarily the current balance. Also check how additional payments are allocated: if they are held for a future installment or applied to another amount rather than principal, this estimate will not match the account’s actual progress.

The formula assumes a fixed-rate loan with level monthly payments. It does not model adjustable-rate changes, skipped or missed payments, payment-date effects, refinancing, or a changing extra-payment amount. It also estimates interest through a simplified whole-month calculation, while a servicer’s accounting may use daily accrual, payment posting dates, or other contract details. For the exact balance and payoff date, use the lender’s amortization information or request a payoff figure.

A common misconception is that every extra dollar lowers the required scheduled payment. Typically, an extra principal payment shortens the time needed to repay the balance under the existing payment schedule; this calculator does not recast the loan or calculate a newly reduced required installment. A recast, if available under the loan terms, is a separate calculation.

Frequently Asked Questions

How much time can extra mortgage payments save?
The amount depends on the balance, interest rate, remaining term, and extra payment. Enter those figures to estimate months saved; the result assumes a fixed rate and the same additional amount every month.

Does an extra payment go directly to principal?
This calculator assumes it does. Payment allocation depends on the loan’s servicing and instructions, so confirm with the servicer how to designate an additional amount as principal.

Can I use this for a one-time extra payment?
Not exactly. The extra-payment field represents a repeated monthly amount. A one-time lump sum changes the balance at a particular date, so a lump-sum payoff calculator or a detailed amortization schedule is more suitable.

Why is the calculator’s result different from my mortgage statement?
The estimate assumes monthly compounding, level payments, fixed interest, and immediate application of extra principal. Posting dates, daily interest methods, payment rounding, escrow, or a different remaining balance can create differences.

Does paying extra reduce my required monthly payment?
Not in this model. It estimates an earlier payoff while keeping the scheduled payment amount unchanged. It does not model a loan recast or a change to the required installment.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

Formula used
in bal | Current mortgage balance | $ | 300000 | 0.01 | 100000000
in apr | Interest rate (APR) | % | 6.5 | 0.01 | 100
in yrs | Remaining term | years | 25 | 0.0833 | 50
in extra | Extra monthly payment | $ | 200 | 0 | 100000000
out saved | Months saved | months | ceil(round(-ln(1 - (apr / 1200) * bal / (bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) + extra)) / ln(1 + apr / 1200), 6)) + 0 * sqrt(yrs * 12 - ceil(round(-ln(1 - (apr / 1200) * bal / (bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) + extra)) / ln(1 + apr / 1200), 6))) - (yrs * 12 - 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 saved | $ | (bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * yrs * 12 - bal - ((bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) + extra) * ceil(round(-ln(1 - (apr / 1200) * bal / (bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) + extra)) / ln(1 + apr / 1200), 6)) - bal) | 2
out pmt | Scheduled monthly principal-and-interest payment | $ | round(bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 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 →