calculate-loan

01 Loan payments

How Long to Pay Off Loan? Use This Calculator

Calculator No. 01-21182 · 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 how many months it will take to pay off a loan given the amount you owe, the annual interest rate (APR), and the monthly payment you plan to make. You enter those three numbers and get back the payoff time in years and months, plus the total interest you will pay over that period. The result assumes a fixed interest rate and that you make the same payment every month until the balance reaches zero.

Formula

The payoff time formula comes from the standard amortization equation. If you know the monthly payment and the interest rate, you can solve for the number of payments n:

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

  • P = loan principal (the amount you borrowed, in $)
  • r = monthly interest rate = APR / 1200 (APR is an annual percentage, so divide by 12 months and by 100 to get a decimal)
  • M = monthly payment amount (in $)
  • n = number of monthly payments needed to reach a zero balance

The ceiling function (⌈ ⌉) rounds up to the next whole month, because you cannot make a fraction of a payment. The expression inside the logarithm is the fraction of the loan that each payment covers after interest. If that fraction is negative or zero, the payment is too small to cover the monthly interest, and the balance would grow forever—the calculator shows “Cannot compute” in that case.

Worked Example

Use the default values from the calculator: a $20,000 loan at 8% APR with a $500 monthly payment.

  1. Monthly rate: r = 8 / 1200 = 0.0066667
  2. Interest portion of the first payment: 0.0066667 × 20,000 = $133.33
  3. Principal portion of the first payment: 500 − 133.33 = $366.67
  4. Apply the formula: n = -ln(1 − 0.0066667 × 20,000 / 500) / ln(1 + 0.0066667)
  5. Inside: 0.0066667 × 20,000 / 500 = 0.26667, so 1 − 0.26667 = 0.73333
  6. -ln(0.73333) = 0.31015; ln(1.0066667) = 0.0066445
  7. n = 0.31015 / 0.0066445 = 46.68 → rounded to 47 months

So the payoff time is 47 months (3 years and 11 months). Total paid: 47 × 500 = $23,500. Total interest: 23,500 − 20,000 = $3,500. The calculator shows the same numbers: months = 47, years/months = “3 yr 11 mo”, and total interest = $3,500.00.

Assumptions

  • The interest rate is fixed for the entire payoff period.
  • Payments are made at the same time each month (end of the month, standard for loans).
  • Interest compounds monthly at a rate of APR / 12.
  • You make exactly the same payment every month, with no extra payments, skipped payments, or changes in rate.
  • Fees, taxes, insurance, and other charges are not included. They would increase the total cost and lengthen the payoff time if added to the balance.

Why Payoff Time Matters

Knowing how long a loan will take to pay off helps you plan your budget and see the true cost of borrowing. A longer payoff time usually means more total interest, but a lower monthly payment. A shorter payoff time means higher monthly payments but less interest overall. The calculator lets you compare scenarios: increase the monthly payment by $50 and see how many months you save, or lower the payment and see how much extra interest you pay.

This is especially useful when you receive a windfall (like a tax refund or bonus) and wonder whether to put it toward the loan. You can enter your current payment and then a higher payment to see the difference in months and interest.

How to Use the Calculator Correctly

Enter your actual loan balance (not the original amount if you have already made payments), your current APR (check your latest statement), and the monthly payment you plan to make. The result tells you how many months from today it will take to reach zero, assuming no changes.

Common mistakes:

  • Using the original loan amount instead of the remaining balance—this overstates the payoff time.
  • Entering the annual rate as a decimal (0.08 instead of 8). The calculator expects the percentage number, so type 8, not 0.08.
  • Forgetting that the payment must cover the monthly interest. If the payment is too low, the balance grows and the loan never gets paid off—the calculator will show “Cannot compute”.
  • Rounding the monthly rate too early. Keep full precision until the final step.

Common Problems and Edge Cases

Payment too low: If your payment is less than the monthly interest (P × r), the formula’s logarithm becomes undefined. For example, a $20,000 loan at 8% has monthly interest of about $133. A $100 payment would not cover that, so the balance increases. The calculator rejects this with “Cannot compute”. The minimum payment that works is slightly above the interest amount.

Very high payments: If you pay off the loan in one month, the formula still works: the logarithm approaches zero and n rounds to 1. The calculator handles this fine.

Zero interest: The formula divides by ln(1 + r), which is zero when r = 0. The calculator requires an APR of at least 0.01%, so a true 0% loan is not supported. For a 0% loan, the payoff time is simply P / M rounded up.

Extra payments: This calculator assumes a level payment every month. If you plan to make irregular extra payments, you need a more detailed amortization schedule that tracks the balance month by month.

Comparing Different Payment Amounts

To see the effect of paying more each month, run the calculator twice: once with your current payment and once with the higher amount. The difference in months is the time you save. The difference in total interest is the money you save. For example, on a $20,000 loan at 8%:

  • $400/month → about 67 months, total interest ≈ $6,800
  • $500/month → 47 months, total interest ≈ $3,500
  • $600/month → 37 months, total interest ≈ $2,200

Notice that increasing the payment from $400 to $500 saves 20 months and about $3,300 in interest, while going from $500 to $600 saves only 10 months and $1,300. The benefit of each extra dollar shrinks as the payoff gets shorter.

Limits of This Calculation

This formula assumes a fixed rate and constant payment. Real loans can have variable rates, fees added to the balance, or payment holidays. It also does not account for the time value of money—a dollar today is worth more than a dollar in the future, but the total interest figure is simply the sum of payments minus principal. For a more precise plan, use a full amortization schedule that tracks the balance each month and allows for changes.

Frequently Asked Questions

How do I find my current loan balance? Check your latest monthly statement or log into your lender’s online portal. The balance is the amount you still owe, not the original loan amount.

What if I make extra payments? This calculator assumes a fixed payment. If you make extra payments, the payoff time will be shorter than the result. To estimate, increase the monthly payment input to reflect the average total you pay each month.

Why does the calculator show “Cannot compute”? That happens when your payment is less than the monthly interest. The loan balance would grow, not shrink. Increase the payment amount or lower the interest rate to get a valid result.

Does the payment due date matter? The formula assumes payments are made at the end of each month. If you pay early or late, the interest accrual changes slightly, but the difference is usually small unless you pay weeks early every month.

Can I use this for a credit card? Yes, if you have a fixed APR and make a fixed payment. Credit cards often have variable rates and minimum payments that change, so the result is an estimate. For a card, the “loan amount” is your current balance.

What about 0% APR offers? The calculator requires a positive rate. For a 0% APR loan, divide the balance by the monthly payment and round up to get the number of months. For example, $2,000 at $200/month = 10 months.

The result from this calculator is an estimate based on the assumptions listed above. Your lender’s disclosure statement provides the exact payoff amount and schedule for your specific loan.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pmt | Monthly payment | $ | 500 | 1 | 10000000
out months | Payoff time | months | ceil(round(-ln(1 - (apr / 1200) * p / pmt) / ln(1 + (apr / 1200)), 6)) + 0 * sqrt(pmt - (apr / 1200) * p) | 0
out yrs | Years and months | - | floor(months / 12) + " yr " + round(months - 12 * floor(months / 12)) + " mo" | 0
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 →