calculate-loan

01 Loan payments

Estimated Loan Payoff Date: How to Calculate It

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

Months to payoff 62 months
Estimated payoff date
2,025
= 2026-01
Total paid
$24,800.00
= Monthly payment × months to payoff
Total interest
$4,800.00
= Monthly payment × months to payoff − current loan balance
You enter
Current loan balance ($), Interest rate (APR) (%), Monthly payment ($)
You get
Months to payoff (months), Estimated payoff date, Total paid ($), Total interest ($)
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.

Your estimated loan payoff date is the month and year when your final payment will clear the balance, assuming you make every payment on time and never change your payment amount. You can calculate it yourself with your current balance, interest rate, and monthly payment using a standard amortization formula. This page provides a calculator that does the math for you, plus a full explanation of how the date is determined and what could change it.

Formula

The number of months to payoff is calculated with the standard loan payoff formula:

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

  • n = number of monthly payments (rounded up to the next whole month)
  • r = monthly interest rate = APR / 1200 (e.g., 8% APR → 0.08 / 12 = 0.0066667)
  • P = current loan balance (principal remaining)
  • M = monthly payment amount
  • ln = natural logarithm

The formula solves for how many months it takes for a level payment to reduce the balance to zero, given monthly compounding at the stated APR. The result is rounded up to the next whole month because you cannot make a fraction of a payment. The payoff date is then the current month plus that many months.

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 = 0.333333
  3. Compute 1 – 0.333333 = 0.666667
  4. Take natural log: ln(0.666667) = -0.405465
  5. Compute ln(1 + r) = ln(1.0066667) = 0.0066445
  6. Divide: -(-0.405465) / 0.0066445 = 61.02
  7. Round up: 62 months

If today is January 2026, the payoff date is 62 months later, which is March 2031. Total paid = 62 × $400 = $24,800. Total interest = $24,800 – $20,000 = $4,800. The calculator shows 61.02 rounded up to 62, and the date is computed from the current month. Note: the exact date within the month depends on your payment due day, but the month is what matters for planning.

Assumptions

  • Fixed interest rate for the entire remaining term (no rate changes).
  • You make exactly one payment per month, on the same day each month.
  • Interest compounds monthly at APR / 12, which is standard for most loans.
  • Your payment amount is constant; extra or missed payments change the result.
  • Fees, late charges, prepayment penalties, and escrow amounts are not included.

When to Use This Calculator

Use this calculator when you want to know how long it will take to pay off a loan with a fixed payment that is not necessarily the minimum. Common situations include:

  • You are making extra payments on a car loan or personal loan and want to see the new payoff date.
  • You are comparing a higher monthly payment to a lower one and want to see the time difference.
  • You are considering paying off a student loan early and want a target date.
  • You want to know how much total interest you will pay if you stick to a certain payment.

The calculator works for any loan with a fixed APR and monthly compounding: auto loans, personal loans, student loans, and even credit card balances if you treat the card as a fixed-rate loan (though credit cards typically compound daily, so the result will be slightly off).

How to Read the Result

The first output, Months to payoff, is the number of monthly payments you will make. The Estimated payoff date shows the month and year when the last payment is due. The Total paid is your payment amount multiplied by the number of months, and Total interest is that total minus your current balance.

For example, if you owe $10,000 at 6% APR and pay $300 per month, the formula gives about 36.5 months, so the calculator shows 37 months. Your payoff date would be 37 months from now. The total paid would be $11,100, and interest would be $1,100.

Keep in mind that the payoff date assumes you start making payments immediately. If you are between payments, the actual date shifts by a few days or weeks depending on when your next payment is due.

Common Mistakes and Misconceptions

  • Using the minimum payment on a credit card: The formula assumes a fixed payment. Credit card minimums change as the balance drops, so the result is only accurate if you keep paying the same amount.
  • Ignoring the rounding up: The formula gives a fractional month (e.g., 61.02). Rounding down would make the final payment larger than your regular payment, which is not what you planned. Always round up to the next full month.
  • Mixing up APR and monthly rate: The APR is an annual rate. You must divide by 12 to get the monthly rate. Using 8 instead of 0.0066667 will give a nonsense result.
  • Assuming the payoff date is the same as the original loan term: If you have already made payments, your remaining balance is lower, so your payoff date with the same payment will be earlier than the original maturity date.
  • Forgetting about payment timing: If you make a payment on the 1st versus the 15th, the interest accrues differently. This calculator assumes the payment is applied at the end of each month, which is standard but not exact for every lender.

What Changes Your Payoff Date

Several factors can move your payoff date earlier or later:

  • Extra payments: Any additional amount applied to principal shortens the term. Even one extra payment per year can cut months off a long loan.
  • Payment amount changes: Increasing your monthly payment shortens the term; decreasing it lengthens it. If you pay less than the interest accruing, the balance grows and you never pay off the loan.
  • Rate changes: If you have a variable-rate loan, the APR can go up or down, which changes the interest portion of each payment and therefore the payoff date.
  • Missed or late payments: Missing a payment adds interest and may incur fees, both of which extend the payoff date.
  • Loan modification or deferment: Temporarily pausing payments adds months to the end of the loan.

Frequently Asked Questions

What if my payment is less than the monthly interest?

If your payment does not cover the interest that accrues each month, the loan balance grows instead of shrinking. In the formula, the term inside the logarithm becomes negative or zero, and the calculator shows “Cannot compute” because there is no finite payoff date. This is a real situation with minimum credit card payments or some deferred loans. You would need to increase your payment to ever pay off the balance.

Does making a lump-sum payment change the payoff date?

Yes. If you make a lump-sum payment, your remaining balance drops immediately. You can re-run the calculator with the new, lower balance and the same monthly payment to see the new payoff date. The formula does not directly account for a future lump sum, but you can model it by reducing the principal.

How accurate is this compared to my lender’s payoff statement?

This calculator gives an estimate based on standard amortization. Your lender’s payoff statement will be exact because it includes the precise daily interest accrual, any fees, and the exact date your payment is applied. The difference is usually a few dollars and a few days, but for a final payoff amount, always request a payoff quote from the lender.

Can I use this for a 0% APR loan?

Yes. If the APR is 0%, the formula simplifies to n = P / M. For example, a $1,200 balance with a $100 monthly payment takes 12 months. The calculator handles this because the logarithm of 1 is 0, and the division works out correctly.

What if I make bi-weekly payments instead of monthly?

Bi-weekly payments (half the monthly amount every two weeks) effectively make 26 half-payments per year, which equals 13 full monthly payments. This shortens the payoff time compared to 12 monthly payments. This calculator assumes monthly payments, so for bi-weekly, you would need to adjust your payment amount to an equivalent monthly figure or use a different tool.

Why does the payoff date show a month, not a specific day?

The formula calculates the number of months, not the exact day. The actual due date within the final month depends on your loan’s payment schedule (e.g., the 1st or the 15th). For planning purposes, the month is usually sufficient, but your lender can provide the exact date.

This calculation is an estimate for educational purposes; your lender’s disclosure and payoff statement provide the exact figures for your specific loan.

Related

Formula used
in p | Current loan balance | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pmt | Monthly payment | $ | 400 | 1 | 100000000
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 | - | 2026-01 | 0
out total | Total paid | $ | pmt * months | 2
out interest | 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 →