calculate-loan

01 Loan payments

Calculate My Payoff Date: Loan Payoff Calculator

Calculator No. 01-24074 · 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 calculator works out the exact date your loan will be paid off based on your current balance, interest rate, monthly payment, and any extra amount you add each month. Enter those four numbers and you get the payoff date, the number of months remaining, and the total interest you will pay. The result is an estimate that assumes your rate and payment stay the same for the rest of the loan.

Formula

The payoff date is found by solving the standard amortization formula for the number of payments remaining. The monthly rate is r = APR / 1200 (APR in percent per year divided by 12 months). Your total monthly payment is M = scheduled payment + extra. The number of months to payoff is:

n = ceil( -ln(1 – r × P / M) / ln(1 + r) )

where:

  • P = current loan balance (dollars)
  • r = monthly interest rate (APR ÷ 1200)
  • M = total monthly payment (dollars)
  • n = number of months until the balance reaches zero
  • ceil = round up to the next whole month

The payoff date is simply today plus n months. The total interest is the total of all payments minus the original balance.

Worked Example

Using the default values: balance P = $20,000, APR = 8%, remaining term = 5 years, extra payment = $100 per month.

  1. Monthly rate: r = 8 / 1200 = 0.0066667
  2. Scheduled monthly payment (from the standard formula): pmt = 20000 × 0.0066667 / (1 – (1.0066667)^-60) = $405.53
  3. Total monthly payment: M = 405.53 + 100 = $505.53
  4. Months to payoff: n = ceil( -ln(1 – 0.0066667 × 20000 / 505.53) / ln(1.0066667) ) = ceil( -ln(1 – 0.2637) / 0.0066445 ) = ceil( 0.3062 / 0.0066445 ) = ceil(46.08) = 47 months
  5. Total interest: (505.53 × 47) – 20000 = 23759.91 – 20000 = $3,759.91

So with the extra $100, you pay off the loan in 47 months (about 3 years 11 months) instead of 60 months, and the total interest is $3,759.91 instead of the original $4,331.71.

Assumptions

  • Fixed interest rate for the entire remaining term.
  • Payments are made monthly at the same time each month.
  • Interest compounds monthly at APR ÷ 12.
  • The extra payment is added to every monthly payment until the loan ends.
  • No fees, penalties, taxes, or insurance are included. If your loan has prepayment penalties or daily interest, the actual date may differ.

How to Read the Result

The payoff date is the month when your final payment brings the balance to zero. The months figure is rounded up, so your last payment may be slightly smaller than the regular total. The total interest is the sum of all interest charges from today until payoff, assuming you make every payment on time. If you miss a payment or make a partial payment, the date moves later.

Common Mistakes

  • Using the original loan term instead of the remaining term. If you are 2 years into a 5-year loan, the remaining term is 3 years, not 5.
  • Forgetting to convert APR to a monthly rate. Dividing by 12 is essential; using the annual rate directly gives a wildly wrong date.
  • Rounding the monthly payment too early. Use the exact payment (or at least 2 decimals) in the formula, then round the final months.
  • Assuming the extra payment is a one-time lump sum. This calculator expects a recurring monthly extra. For a lump sum, recalculate with the reduced balance.

When to Use This Calculator

Use it when you are considering increasing your monthly payment, making biweekly payments, or adding a fixed extra amount. It shows the trade-off between a higher payment and a shorter term. It also helps you compare two scenarios: for example, $50 extra vs. $150 extra. The difference in payoff date and total interest is clear. However, this is only an estimate; your lender’s amortization schedule is the authoritative source.

Limits of the Formula

The formula assumes a constant interest rate and a constant payment. Real loans may have variable rates, payment holidays, or fees that change the math. Also, the formula fails if your monthly payment is less than the interest charged that month – in that case, the balance grows and you never pay off the loan. The calculator shows “Cannot compute” for that situation, which is correct. Additionally, the payoff date is based on calendar months of equal length; actual dates may shift by a day or two due to weekends and month lengths.

Frequently Asked Questions

What if I make a lump sum payment instead of monthly extra?

Enter the lump sum as a reduction in the current balance. For example, if you owe $20,000 and pay $5,000 extra once, enter $15,000 as the balance, keep the same rate and remaining term, and set extra to $0. The result shows the new payoff date after that lump sum.

Does making biweekly payments change the payoff date?

Biweekly payments are equivalent to making 13 full monthly payments per year (26 half-payments). To model that, set your extra payment to one extra monthly payment per year divided by 12. For example, if your monthly payment is $400, add $33.33 extra each month. The calculator will show a slightly earlier payoff date.

Why does the calculator say “Cannot compute”?

That happens when your total monthly payment (scheduled + extra) is less than the interest that accrues in the first month. In that case, the balance never decreases, so there is no payoff date. You need to increase your payment or reduce the interest rate.

Is the payoff date affected by the day of the month I make the payment?

Yes, slightly. Most lenders calculate interest daily, so paying earlier in the month reduces interest a little. This calculator assumes payments on the same day each month and monthly compounding, which is a standard simplification. The actual date may differ by a few days.

Can I use this for a student loan or car loan?

Yes, the math is identical for any amortizing loan with a fixed rate and monthly payments. Just enter the current balance, APR, remaining term, and any extra payment. The result is a valid estimate for auto, student, personal, or mortgage loans.

What if my interest rate changes later?

The calculator assumes a fixed rate for the entire remaining term. If your rate is variable, the payoff date will change when the rate changes. You would need to recalculate with the new rate at that time.

This result is an estimate for educational purposes; your lender’s disclosure gives the exact payoff figures.

Related

Formula used
in p | Current balance | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Remaining term | years | 5 | 0.0833 | 50
in extra | Extra monthly payment | $ | 100 | 0 | 100000
out months | Months to payoff | months | ceil(round(-ln(1 - (apr / 1200) * p / (pmt + extra)) / ln(1 + (apr / 1200)), 6)) | 0
out date | Payoff date | - | (now + months * 30.4375) | time
out tot | Total interest | $ | (pmt + extra) * months - p | 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 →