calculate-loan

04 Payoff, extra payments and refinance

Paying Off a Loan Early Calculator: Savings and Time

Calculator No. 04-0184 · 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 paying off a loan early calculator estimates how many monthly payments remain and how much interest you would pay if you make a fixed monthly payment above the scheduled amount. Enter the current loan balance, APR, remaining term, and the extra amount per month to see the estimated payoff time, interest, and comparison with the original schedule.

Formula

The calculator first finds the scheduled monthly payment, then treats that payment plus the extra amount as a fixed payment toward the current balance. It estimates the number of payments needed to reach zero, rounds that number up to a whole month, and calculates total interest from those payments.

Let P be the current balance in dollars, a the APR as a percentage per year, y the remaining term in years, x the extra monthly payment in dollars, and r = a / 1200 the monthly interest rate as a decimal. The scheduled payment is S = P × r / [1 − (1 + r)−12y]. The payment used in the estimate is M = S + x. The estimated payoff months are n = ceil[−ln(1 − rP/M) / ln(1 + r)]. Total paid is M × n, interest with extra payments is M × n − P, and estimated interest saved is S × 12y − P − (M × n − P).

All money variables are in dollars; APR is entered as a percentage, not a decimal. The formula assumes a positive APR and a monthly level-payment loan. Its payoff-month calculation requires the payment to exceed the interest accruing in that month, which it does for the scheduled payment used here.

Worked Example

Using the defaults: balance P = $20,000, APR a = 8%, remaining term y = 5 years, and extra payment x = $100 per month.

  1. Monthly rate: r = 8 / 1200 = 0.0066667.
  2. Scheduled payment: S = 20,000 × 0.0066667 / [1 − (1.0066667)−60] = $405.53 when rounded to cents.
  3. Payment with the extra amount: M = $405.53 + $100 = $505.53.
  4. Months to payoff: ceil[−ln(1 − (0.0066667 × 20,000 / 505.53)) / ln(1.0066667)] = ceil(44.86) = 45 months.
  5. Total paid with extra: $505.53 × 45 = $22,748.85.
  6. Interest with extra: $22,748.85 − $20,000 = $2,748.85.
  7. Scheduled total paid: $405.53 × 60 = $24,331.80. Estimated interest saved: $24,331.80 − $20,000 − $2,748.85 = $1,582.95.

The interest-savings comparison uses the rounded scheduled payment and the same current balance and term, keeping the calculation consistent with the displayed monthly amount.

Assumptions

  • The APR and payment amount stay fixed throughout the estimate.
  • Payments are monthly and made at the end of each monthly period.
  • Interest compounds monthly at APR / 12.
  • The entered balance is the amount on which interest is calculated; the model excludes fees, taxes, insurance, PMI, escrow, and any prepayment charge.
  • The model assumes the lender applies the extra amount to principal and accepts the stated payment each month.

When to Use the Calculator

Use it to explore a hypothetical extra monthly payment against a loan’s current balance and remaining schedule. It can help explain the mathematical trade-off: paying more each month generally reduces the balance faster, so fewer periods accrue interest under this fixed-rate model. It is an estimate, not a payoff quote.

For a useful estimate, enter the balance currently subject to interest, not the original amount borrowed. Find the APR, current balance, and remaining term on the loan statement or ask the lender for the figures it uses. The APR may not be the exact periodic rate used for every loan calculation, and payment dates or daily-interest methods can change actual results.

How to Read the Results

  • Months to payoff: the number of whole monthly payments in the model. The final actual payment may be smaller than the fixed amount because the remaining balance can be less than one full payment.
  • Total paid with extra: the calculator multiplies the modeled payment by the rounded-up number of months. This is a simplifying estimate; it does not reduce the last payment to the exact remaining amount.
  • Interest with extra: the estimated total paid minus the starting balance.
  • Estimated interest saved: the modeled interest on the scheduled payment plan minus modeled interest with the extra amount.

Because the model counts a full payment in the final month, its total paid and interest can be slightly higher than a calculation that precisely adjusts the last payment. Treat the displayed savings as an approximation rather than a guaranteed amount.

Common Limitations and Mistakes

A common mistake is using the original loan amount instead of today’s principal balance. Another is entering an APR such as 8% as 0.08; enter 8. The calculator uses years for the remaining term, so enter 2 for two years, not 24. It also assumes extra payments are made every month; a one-time lump sum or irregular payments need a different schedule.

Loan contracts and servicing methods differ. Interest may accrue daily, the payment date may affect the amount of interest, or an extra payment may be handled in a way other than immediate principal reduction. Some loans may have fees or conditions associated with early payment; check the loan documents or ask the servicer how additional payments are applied. The calculator does not include those terms.

For a variable-rate loan, the result assumes today’s APR remains unchanged. If the rate changes, the payoff schedule and interest will also change. A lender’s payoff quote may include accrued interest through a particular date and other items not represented here, so it can differ from the calculator.

Frequently Asked Questions

How much interest will I save by paying extra on my loan?
The estimate depends on your current balance, APR, remaining term, and extra payment. Enter those figures to compare modeled interest with and without the additional monthly amount. Actual savings depend on payment timing and how the lender applies extra money.

Does paying extra reduce the monthly payment?
Usually, an extra payment reduces the balance and may shorten the payoff period in a fixed-payment schedule, but it does not necessarily change the required scheduled payment. Ask the servicer how it treats additional payments and whether any recasting process applies.

Should I enter my original loan amount or current balance?
Use the current principal balance on which interest is being charged. The original amount does not account for payments already made and can substantially distort the estimate.

Is the calculator’s payoff date exact?
No. It estimates a number of monthly periods under simplified assumptions. Daily interest, payment dates, rate changes, fees, and a smaller final payment can make the actual date and amount different.

Can I use this for a variable-rate loan?
You can use it as a scenario based on the APR entered, but the result assumes that rate stays fixed. It will not model future rate changes or recalculate the schedule when the rate changes.

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

Related

Formula used
in bal | Current loan balance | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Remaining loan term | years | 5 | 0.0833 | 50
in extra | Extra monthly payment | $ | 100 | 0 | 100000000
out months | Months to payoff | 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 paid | Total paid with extra | $ | (bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) + extra) * months | 2
out interest | Interest with extra | $ | paid - bal | 2
out saved | Estimated interest saved | $ | (bal * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) + extra) * yrs * 12 - bal - interest | 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 Payoff, extra payments and refinance section →