calculate-loan

01 Loan payments

Estimated Loan Payoff Date Calculator

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

Months to payoff 62 months
Estimated payoff date
65:08:17
= 2025-03-01 + months to payoff × 30.44
Total interest
$4,800.00
= Monthly payment × months to payoff − current loan balance
Current loan balance
$20,000
Input
You enter
Current loan balance ($), Interest rate (APR) (%), Monthly payment ($)
You get
Months to payoff (months), Estimated payoff date, Total interest ($)
Rounding
0 dp · h:mm:ss · 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.

This calculator estimates the date your loan will be fully paid off based on your current balance, interest rate, and monthly payment. Enter your loan balance, APR, and the amount you pay each month, and you’ll get the number of months remaining and the projected payoff date. It also shows the total interest you’ll pay over that period.

Formula

The calculation uses the standard amortization formula solved for the number of payments:

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

  • n = number of monthly payments (rounded up to the next whole month)
  • P = current loan balance (in dollars)
  • r = monthly interest rate = APR / 1200 (APR in percent per year)
  • M = monthly payment amount (in dollars)

The ceiling function (⌈ ⌉) ensures you always count a full final month, even if the last payment is smaller.

Worked Example

Using the default values: balance = $20,000, APR = 8%, monthly payment = $400.

  1. Monthly rate: r = 8 / 1200 = 0.0066667
  2. Compute r × P / M = 0.0066667 × 20000 / 400 = 133.334 / 400 = 0.333335
  3. Compute 1 – 0.333335 = 0.666665
  4. Take natural log: ln(0.666665) = -0.405465
  5. Compute ln(1 + 0.0066667) = ln(1.0066667) = 0.0066445
  6. Divide: -(-0.405465) / 0.0066445 = 61.02
  7. Round up: n = 62 months
  8. Payoff date: starting from March 1, 2025, add 62 months → May 1, 2030
  9. Total paid = 62 × $400 = $24,800; total interest = $24,800 – $20,000 = $4,800

The calculator shows 62 months, a payoff date of May 2030, and $4,800 in interest—matching the manual calculation.

Assumptions

  • Fixed interest rate for the entire remaining term (no rate changes).
  • Payments are made monthly at the same time each month.
  • Interest compounds monthly at APR / 12.
  • The payment amount stays constant every month.
  • No additional fees, penalties, taxes, or insurance are included.

How to Use This Calculator

Enter your current loan balance (the principal remaining), your annual percentage rate (APR), and the monthly payment you plan to make. The result tells you how many months it will take to pay off the loan and the date you’ll make the final payment. This is useful for comparing different payment amounts—for example, if you increase your payment by $50, you can see how much sooner the loan ends and how much interest you save.

The payoff date is approximate because it assumes the same day each month and a 30.44-day average month. Actual dates may shift by a day or two depending on calendar months and when the lender posts payments.

Common Mistakes and Misconceptions

  • Using the minimum payment vs. actual payment: If you enter the minimum required payment, the result may be very long. Always use the amount you actually intend to pay.
  • Ignoring the APR: Some people use the nominal interest rate without converting to the monthly rate. The formula does this automatically, but if you manually calculate, remember to divide by 1200.
  • Rounding too early: If you round the monthly rate to 0.007 instead of 0.0066667, your result will be off by several months.
  • Assuming the payoff date is exact: Lenders may use different day-count conventions (actual/360 or actual/365), which can shift the final date by a few days.
  • Forgetting that the last payment is smaller: The calculator rounds up to a full month, so the final payment is usually less than the regular amount. The total interest shown is based on the full final month, so the actual interest may be slightly lower.

Limitations of the Formula

This formula assumes a level payment and a fixed rate. It does not handle:

  • Variable-rate loans (APR changes over time)
  • Interest-only periods or payment holidays
  • Bi-weekly payments (which effectively make 13 payments per year)
  • Loans with fees added to the balance or prepayment penalties
  • Subsidized loans where interest is paid by someone else

If your loan has any of these features, the estimate will be off. For example, a bi-weekly payment schedule (half the monthly amount every two weeks) will pay off a loan faster than this calculator predicts because you make 26 half-payments, equivalent to 13 full payments per year.

Why the Payment Must Exceed Interest

If your monthly payment is less than or equal to the monthly interest (P × r), the loan balance will never decrease—it will grow or stay flat. The formula handles this by producing a “Cannot compute” result, because the logarithm of a non-positive number is undefined. In reality, such a payment would mean you are not covering the interest, and the loan would never be paid off. Always ensure your payment is greater than the monthly interest to make progress.

Frequently Asked Questions

How do I find my current loan balance?

Your current balance is the remaining principal, not the original amount. You can find it on your latest statement, in your online account, or by calling your lender. It is the amount you still owe before interest accrues.

What is a good monthly payment to enter?

Use the amount you are actually paying or planning to pay. If you are shopping for a payment amount, try different values to see how the payoff date and total interest change. The calculator does not judge whether a payment is “good”—that depends on your budget and goals.

Does the payoff date include the day I make the payment?

No, the date is an estimate based on the number of months from a starting point. It assumes payments are made on the same day each month. The actual payoff date may be a few days earlier or later depending on your payment due date and how the lender applies payments.

Can I use this for a credit card balance?

Yes, but only if the interest rate is fixed and you make a constant payment. Credit cards often have variable APRs and minimum payments that change, so the estimate will be less accurate. For a more realistic picture, use the actual APR and a fixed payment you commit to.

What if I make extra payments occasionally?

This calculator assumes a constant monthly payment. If you make extra payments, the payoff date will be earlier than shown. To model that, you would need a more detailed amortization schedule that accounts for each extra payment.

Is the total interest accurate?

It is an estimate based on the rounded-up number of months and a constant payment. Because the final payment is usually smaller than the regular payment, the actual total interest may be slightly less than shown. The estimate is close enough for planning purposes.

Remember, this is an estimate. Your lender’s payoff statement will give the exact amount needed to pay off the loan on a specific date.

Related

Formula used
in p | Current loan balance | $ | 20000 | 0 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pmt | Monthly payment | $ | 400 | 1 | 10000000
out months | Months to payoff | months | ceil(round(-ln(1 - (apr / 1200) * p / pmt) / ln(1 + apr / 1200), 6)) | 0
out date | Estimated payoff date | - | 2025-03-01 + months * 30.44 | time
out int | Total interest | $ | pmt * 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 →