calculate-loan

01 Loan payments

Debt Payoff Timeline: How Long It Takes

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

Months to payoff 32 months
Total paid
$6,400.00
From the formula below, to the cent
Total interest
$1,400.00
From the formula below, to the cent
Current balance
$5,000
Input
You enter
Current balance ($), Interest rate (APR) (%), Monthly payment ($)
You get
Months to payoff (months), 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.

This calculator works out how long it takes to pay off a loan or credit card balance given your monthly payment, interest rate, and current balance. You enter the amount you owe, the annual interest rate, and your planned monthly payment, and it returns the number of months until the balance reaches zero, plus the total interest you’ll pay along the way.

Formula

The number of months to pay off a loan with a fixed monthly payment is calculated using the standard amortization formula solved for time:

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

  • n = number of monthly payments (rounded up to the next whole month)
  • P = current balance (in dollars)
  • r = monthly interest rate = APR / 1200 (APR is the annual percentage rate, e.g., 18% becomes 0.015 per month)
  • M = monthly payment amount (in dollars)

The ceiling function (⌈ ⌉) ensures you count the final partial month as a full month, which is how real lenders handle it.

Worked Example

Using the default values: balance = $5,000, APR = 18%, monthly payment = $200.

  1. Convert APR to monthly rate: r = 18 / 1200 = 0.015
  2. Compute r × P / M = 0.015 × 5000 / 200 = 75 / 200 = 0.375
  3. Compute 1 – 0.375 = 0.625
  4. Take natural log: ln(0.625) ≈ -0.4700036
  5. Compute ln(1 + r) = ln(1.015) ≈ 0.0148886
  6. Divide: -(-0.4700036) / 0.0148886 ≈ 31.57
  7. Round up to the next whole month: 32 months

So the calculator shows 32 months. Total paid = 32 × $200 = $6,400. Total interest = $6,400 – $5,000 = $1,400.

Assumptions

  • Fixed interest rate for the entire payoff period.
  • Payments are made monthly at the same time each month.
  • Interest compounds monthly at APR / 12.
  • Your payment stays constant; if you pay extra or change the amount, the timeline changes.
  • No fees, penalties, or charges are included. Credit card minimum payments often change as the balance drops—this calculator assumes a fixed payment.

How to Read the Result

The number of months is the time until your balance reaches zero if you make exactly the payment you entered every month. The total interest figure shows what that payment plan costs over the whole period. A shorter timeline means less interest paid overall, but it requires a higher monthly payment. The calculator helps you see the trade-off between monthly cash flow and total cost.

For credit cards, note that the minimum payment is usually a percentage of the balance (often 1-3% plus interest), so it decreases over time. If you pay only the minimum, your timeline will be much longer than what this fixed-payment calculator shows. To use this tool for a card, enter the payment you intend to make as a fixed amount, not the minimum.

Common Mistakes

  • Using the APR as a monthly rate. Always divide by 12. An 18% APR is 1.5% per month, not 18%.
  • Forgetting to round up. If the math says 31.57 months, you actually make 32 payments. The final payment is smaller, but the number of months is a whole number.
  • Ignoring payment timing. If you pay biweekly instead of monthly, the effective interest period is shorter, so the payoff comes sooner. This calculator assumes monthly payments.
  • Using a payment that doesn’t cover interest. If your payment is less than the monthly interest, the balance grows forever. The formula returns a negative log, which the calculator shows as “Cannot compute.”

How to Choose a Payment Amount

There is no single “right” payment—it depends on your budget and goals. A common approach is to pay at least the minimum to avoid late fees, then add any extra cash you can spare. The more you pay each month, the fewer months you’ll be in debt and the less interest you’ll pay. For example, on a $5,000 balance at 18% APR:

  • Paying $150/month takes about 46 months and costs about $1,900 in interest.
  • Paying $200/month takes 32 months and costs $1,400.
  • Paying $300/month takes about 20 months and costs about $1,000.

Use the calculator to try different payment amounts and see how the timeline and total interest change.

Alternatives to Fixed Payments

If you have multiple debts, you might consider the debt snowball (pay off smallest balances first) or debt avalanche (pay off highest interest first). These strategies don’t change the math for each individual loan, but they change how you allocate extra payments across accounts. The calculator works for any single debt; to compare multiple debts, run it for each one.

Another alternative is a balance transfer to a 0% APR card, but the calculator doesn’t model promotional periods or transfer fees. If you’re considering that, enter the promotional rate and the fee-adjusted balance to get an estimate, and check the card’s terms for the exact end date.

Frequently Asked Questions

What if my payment changes over time?

This calculator assumes a fixed payment. If you increase your payment later, your actual payoff will be sooner than the estimate. If you decrease it, it will take longer. For a more accurate plan, recalculate whenever your payment changes.

Why does the calculator say “Cannot compute”?

That happens when your payment is less than or equal to the monthly interest. For example, on a $5,000 balance at 18% APR, the monthly interest is $75. If you pay $75 or less, the balance never decreases, so there is no finite payoff time.

Does this work for student loans or mortgages?

Yes, the formula works for any fixed-rate loan with level payments. For mortgages, property taxes and insurance are not included—enter only the principal and interest portion of your payment. For student loans, if you’re on an income-driven plan, your payment changes annually, so the estimate is only accurate for a single year.

How does making extra payments affect the timeline?

Extra payments reduce the principal faster, which cuts both the number of months and the total interest. The calculator shows the effect of a higher fixed payment. If you make a one-time lump sum, the timeline shortens by more than you might expect because you avoid interest on that amount for the remaining term.

Is the total interest exact?

It’s an estimate based on the rounded-up number of months. In reality, your final payment may be smaller than your regular payment, so the exact interest could be a few cents less. The calculator rounds to the nearest cent, which is close enough for planning.

This result is an estimate based on the inputs you provide; your lender’s statement will show the exact figures.

Related

Formula used
in p | Current balance | $ | 5000 | 1 | 1000000
in apr | Interest rate (APR) | % | 18 | 0.01 | 100
in pmt | Monthly payment | $ | 200 | 1 | 100000
out months | Months to payoff | months | ceil(-ln(1 - apr / 1200 * p / pmt) / ln(1 + apr / 1200)) | 0
out total | Total paid | $ | pmt * ceil(-ln(1 - apr / 1200 * p / pmt) / ln(1 + apr / 1200)) | 2
out interest | Total interest | $ | pmt * ceil(-ln(1 - apr / 1200 * p / pmt) / ln(1 + apr / 1200)) - 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 →