Loan Payoff Date Calculator

A $18,000 balance at 6.5% paid at $450 a month, with the next payment in December 2026, is paid off in September 2030: 46 payments and $2,342 of interest.

Enter your own loan to get the month of your last payment, then read the tables for what a bigger payment or a different rate does to it.

Loan payoff date calculator

Last payment: September 2030

That is 46 payments, 3 years 10 months, and $2,342 of interest in total.

A bigger payment moves the date

The loan is $18,000 at 6.5%, first payment in December 2026. One month of interest is $97.50.

Monthly paymentLast paymentTimeInterest paid
$350December 20315 years 1 month$3,156
$450September 20303 years 10 months$2,342
$550December 20293 years 1 month$1,867
$700March 20292 years 4 months$1,436

The same $450 payment at three rates

A higher rate leaves less of each payment for principal, so the last payment comes later.

RateLast paymentTimeInterest paid
4.5%July 20303 years 8 months$1,539
6.5%September 20303 years 10 months$2,342
8.5%November 20304 years$3,240

How the calculator works

  1. Each month, interest = balance x rate / 12.
  2. The payment minus that interest comes off the balance.
  3. It counts payments until the balance reaches zero, then adds that many months to the month of your next payment.

It assumes a fixed rate and that every payment lands on its due date. For the payoff schedule year by year see the loan payoff calculator with amortization, and for one extra payment the early loan payoff calculator for a lump sum.

Check before you pay early

The CFPB says a prepayment penalty is a fee that some lenders charge if you pay off all or part of your mortgage early.

Other loans set their own terms, so read your loan agreement for a prepayment fee and ask how an extra payment is applied.

Frequently asked questions

How do I find my loan payoff date?

Enter the balance you owe today, the rate and the payment you make each month, and set the month of your next payment. The calculator counts the payments until the balance reaches zero and names the month of the last one.

Why is the date different from the end date on my loan paperwork?

The paperwork date follows the original schedule. If you pay more than required, pay late, or the rate changed, the real date moves. This calculator uses the payment you enter and a fixed rate.

How much sooner does an extra payment end the loan?

On the example loan, $550 a month instead of $450 ends it in 3 years 1 month instead of 3 years 10 months.

What if my payment is lower than the interest?

The balance never falls. On the example loan one month of interest is $97.50, so a payment of that size or less never pays it off.

How do I work out the payoff date in a spreadsheet?

Use NPER(rate/12, -payment, balance) for the number of payments, then =EDATE(first payment date, payments - 1) for the date of the last one.

Sources

Every figure on this page comes from the pages below. Checked 2026-11-14. Rules change, so confirm with your own servicer.

More recast guides