calculate-loan

01 Loan payments

Loan End Date Calculator: Estimate Your Payoff Date

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

Estimated payments remaining 60 months
Estimated final payment month
59 months after first payment
= Estimated payments remaining − 1
Total of remaining payments
$24,331.80
= Monthly payment × estimated payments remaining
Estimated interest remaining
$4,331.80
= Monthly payment × estimated payments remaining − remaining loan balance
You enter
Remaining loan balance ($), Interest rate (APR) (%), Monthly payment ($), First payment year (years), First payment month (month)
You get
Estimated payments remaining (months), Estimated final payment month (months after first payment), Total of remaining payments ($), Estimated interest remaining ($)
Rounding
0 dp · 2 dp

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 loan end date calculator estimates when a fixed-rate loan will be paid off from its balance, APR, monthly payment, and the date payments begin. Enter those figures to see the estimated number of monthly payments and the calendar date of the final payment; the estimate assumes payments arrive on schedule and does not account for fees or payment changes.

Formula

The calculator first estimates the number of level monthly payments needed to repay the remaining balance, then places the final payment that many payment dates into the future. Its payoff calculation is:

n = ceil(round(−ln(1 − r × B ÷ M) ÷ ln(1 + r), 6))

  • B is the remaining principal balance in dollars.
  • APR is the annual percentage rate entered as a percentage.
  • r is the monthly interest rate, calculated as APR ÷ 1200.
  • M is the fixed monthly payment in dollars.
  • n is the estimated count of monthly payments, rounded up to a whole payment.

The calendar estimate uses the first payment month as payment one. Therefore, the final payment falls n − 1 months after the first payment month. The calculator advances by calendar months; a lender’s exact due date, weekend handling, and final-payment adjustment can make the actual date or amount differ. The remaining-payment total is M × n, and estimated interest is that total minus B. This interest figure is only for the remaining repayment period, not interest already paid over the life of the loan.

Worked Example

Using the calculator’s default inputs: balance B = $20,000, APR = 8%, monthly payment M = $405.53, and first payment in December 2026:

  1. Convert the APR to a monthly rate: r = 8 ÷ 1200 = 0.0066667, or about 0.66667% per month.
  2. Calculate the unrounded payment count: −ln(1 − 0.0066667 × 20,000 ÷ 405.53) ÷ ln(1.0066667) ≈ 59.99 months.
  3. Round the count up to a whole payment: n = 60 monthly payments.
  4. Payment one is due in December 2026. Payment 60 falls 59 months later, in November 2031.
  5. Total of the remaining payments: $405.53 × 60 = $24,331.80. Estimated remaining interest: $24,331.80 − $20,000 = $4,331.80.

The last payment may be smaller than the regular payment because of payment rounding or the lender’s daily interest calculation. The displayed total treats all 60 payments as $405.53, so it is a planning estimate rather than a lender payoff quote.

Assumptions

  • The APR and monthly payment remain fixed throughout the estimated payoff period.
  • Payments are made monthly, on schedule, with the first payment in the month entered.
  • Interest is modelled monthly at APR ÷ 12; actual contracts can accrue interest differently.
  • The calculation excludes fees, taxes, insurance, PMI, escrow, missed or late payments, and payment changes.

How to Use the Estimate

Use a current remaining principal balance rather than the original amount borrowed. If a recent statement shows a principal balance, that is generally the relevant starting figure for this calculation. An account’s total amount due or a payoff quote may include accrued interest and charges as well, so it may not equal principal alone.

Enter the APR as a percentage: for example, enter 8 for 8%, not 0.08. Enter the regular monthly amount actually applied to the loan. If part of a combined bill pays insurance, escrow, or another charge, do not treat the entire bill as principal-and-interest payment unless those amounts are included in the loan’s payment calculation.

The result is most useful for a straightforward, amortizing loan with a fixed rate and a steady monthly payment. It can help answer “about when would this balance be cleared if I keep paying this amount?” It is not a substitute for a lender’s payoff statement, which may specify an amount good through a particular date.

What Can Change the Payoff Date?

The estimate depends strongly on whether the payment covers monthly interest. At the entered APR, the first month’s approximate interest on a $20,000 balance is $133.33. A payment must exceed the interest accruing each month to reduce principal under this model. If the payment is too small, the logarithm in the formula has no valid real result; the calculator cannot produce a payoff date. A payment that barely exceeds interest can also imply a very long payoff period.

Real accounts may differ because interest can accrue daily, payments may post after their due date, the rate may change, or a payment may include charges that do not reduce principal. Extra principal payments, skipped payments, and late payments also change the schedule. For variable-rate loans, a single APR cannot describe the whole future unless the rate stays unchanged.

Another common misunderstanding is that an “end date” is always the date printed in the original loan agreement. That date usually follows the contract’s scheduled term and payment plan. Paying more, paying less, changing the rate, or starting with a different balance can shift the estimated payoff date. Conversely, a calculated date does not amend the loan contract or guarantee that the account will close on that day.

Frequently Asked Questions

How do I calculate when my loan will be paid off?
Use the remaining balance, APR, and monthly payment in the payoff formula above. The calculator estimates the required whole monthly payments and counts forward from the first payment month.

Does the loan end date calculator include extra payments?
No. This version assumes one fixed monthly payment. Extra principal payments can shorten repayment, but their timing and amount must be modelled separately to estimate their effect.

Why does the calculator say it cannot calculate a date?
The entered payment may not cover the interest due at the entered APR, or the values may otherwise make the formula invalid. Check that APR is entered as a percentage and that the payment is the amount applied to the loan each month.

Is the estimated date the exact date my loan closes?
No. It is a mathematical estimate based on monthly interest and on-time payments. The servicer’s account records and payoff quote determine the amount and date needed to clear the actual balance.

What balance should I enter?
Enter the current unpaid principal balance when available. A payoff quote may include interest accrued through a specific date and other amounts, so it is not always the same as the principal balance used by this calculator.

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

Related

Formula used
in bal | Remaining loan balance | $ | 20000 | 0.01 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pmt | Monthly payment | $ | 405.53 | 0.01 | 100000000
in yr | First payment year | years | 2026 | 1900 | 9999
in mon | First payment month | month | 12 | 1 | 12
out n | Estimated payments remaining | months | ceil(round(-ln(1 - (apr / 1200) * bal / pmt) / ln(1 + apr / 1200), 6)) | 0
out end | Estimated final payment month | months after first payment | n - 1 | 0
out total | Total of remaining payments | $ | pmt * n | 2
out int | Estimated interest remaining | $ | pmt * n - bal | 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 →