calculate-loan

01 Loan payments

Debt Payoff Calculator: Plan Your Payoff

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

Months to payoff 32 months
Total paid
$6,400.00
= Monthly payment × months to payoff
Total interest
$1,400.00
= Monthly payment × months to payoff − current balance
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 debt payoff calculator works out how much you need to pay each month to clear your debt by a target date, or how long your current payment will take. You enter your current balance, the annual interest rate, and either a monthly payment or a target payoff time, and it returns the missing figure along with the total interest you will pay. Use it to compare different payment amounts and see the real cost of carrying a balance.

Formula

The calculator uses the standard amortization formula solved for the number of payments. With a fixed monthly payment and a fixed monthly interest rate, the number of months n needed to pay off a balance P is:

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

where:

  • P = current balance (in dollars)
  • r = monthly interest rate = APR / 1200 (APR is the annual percentage rate in percent, divided by 100 to get a decimal, then by 12 for monthly)
  • M = monthly payment (in dollars)
  • ⌈ ⌉ means round up to the next whole month, because you make whole monthly payments

Total paid = M × n, and total interest = total paid − P.

Worked Example

Using the defaults: balance = $5,000, APR = 18%, payment = $200 per month.

  1. Monthly rate: r = 18 / 1200 = 0.015
  2. Compute 1 − r·P / M = 1 − (0.015 × 5000) / 200 = 1 − 75/200 = 1 − 0.375 = 0.625
  3. Take natural log: ln(0.625) ≈ −0.4700
  4. Compute ln(1 + r) = ln(1.015) ≈ 0.014889
  5. Divide: −(−0.4700) / 0.014889 ≈ 31.57
  6. Round up to the next whole month: 32 months

So with $200 per month at 18% APR, the debt is cleared in 32 months. Total paid = $200 × 32 = $6,400. Total interest = $6,400 − $5,000 = $1,400. The calculator shows exactly that.

Assumptions

  • Interest is compounded monthly at APR / 12.
  • You make the same payment every month on the same day.
  • The interest rate never changes over the payoff period.
  • No fees, penalties, or charges are added. Late fees, annual fees, or balance-transfer fees are not included.
  • The result is rounded up to the next month, so the final month may be smaller than the regular payment.

When to Use This Calculator

Use it when you want to see how a different monthly payment changes your payoff time and total interest. For example, if you have a $5,000 credit card balance at 18% APR and you can pay $250 instead of $200, the calculator shows you save months of payments and hundreds in interest. You can also work backward: set a target payoff date (say 24 months) and adjust the payment until the calculator shows 24 months. That tells you the monthly amount needed to hit that goal.

This is also useful for comparing debt repayment strategies. The calculator itself does not tell you which debt to pay first, but you can run the numbers for each debt and see which one costs the most in interest per month. That information helps you decide where to focus extra payments.

How to Choose Your Payment Amount

There is no single “correct” payment, but a few practical approaches can guide you:

  • Minimum payment only: This is the slowest and most expensive path. The calculator will show a very long payoff time and high total interest.
  • Fixed comfortable amount: Choose a payment that fits your budget and stick to it. Even $50 extra per month can cut months off the payoff.
  • Target date: If you want the debt gone by a specific date (e.g., before retirement or a big purchase), adjust the payment until the calculator matches that timeline.
  • Avalanche vs. snowball: The avalanche method pays the highest-APR debt first, which minimizes total interest. The snowball method pays the smallest balance first, which can feel motivating. The calculator helps you quantify the interest cost of each approach.

Whatever amount you choose, make sure it is more than the monthly interest. If your payment is less than the interest charged, the balance will never decrease—the calculator will show “Cannot compute” because the formula breaks down. That is a clear warning that your payment is too low.

Common Mistakes and Misconceptions

One frequent mistake is using the annual rate directly in the formula without dividing by 12. For an 18% APR, the monthly rate is 1.5%, not 18%. Using 18% would give a wildly wrong answer.

Another common error is rounding the number of months to the nearest whole number instead of rounding up. If the formula gives 31.2 months, you still need 32 payments because you cannot make a partial payment in the middle of a month. Rounding down would understate the payoff time and total interest.

People also forget that the final payment is often smaller than the regular payment. The calculator rounds up to the next month, so your last payment might be less than the others. That is normal and does not mean the formula is wrong.

A widespread misconception is that paying twice a month or biweekly saves a lot of interest. In reality, the savings come from making an extra full payment per year (26 half-payments = 13 full payments). This calculator assumes one payment per month, so if you pay biweekly, you would need to enter your effective monthly payment (e.g., $100 every two weeks ≈ $216.67 per month) to get an accurate estimate.

Limitations of the Formula

This is a fixed-rate, fixed-payment model. Real credit cards often have variable rates that change with the prime rate, and they may have promotional rates that expire. If your rate changes, the payoff time will differ from the estimate. The calculator also ignores fees such as late fees, cash advance fees, or balance transfer fees, which add to your balance and increase interest.

The formula assumes you never miss a payment and that the payment is applied on the same day each month. In practice, the exact day of the month can slightly affect interest accrual. For most budgeting purposes, the difference is small, but the lender’s statement will show the exact figures.

Finally, the calculator does not account for minimum payment requirements. Credit card issuers require a minimum payment (often 1% of the balance plus interest). If your chosen payment is below that minimum, the issuer will not accept it. Check your statement for the minimum and make sure your payment is at least that amount.

Frequently Asked Questions

Should I use the avalanche or snowball method?

Both work; the best choice depends on your personality and finances. The avalanche method (highest APR first) saves the most money in interest, which you can see by running each debt through this calculator. The snowball method (smallest balance first) gives quick wins that can keep you motivated. There is no universally “right” answer—pick the one you will stick with.

What if my payment is less than the monthly interest?

Then your balance will grow, not shrink. The calculator will show “Cannot compute” because the formula requires the payment to exceed the interest. If that happens, you need to increase your payment or find a way to lower the interest rate (such as a balance transfer offer, but be aware of transfer fees).

Does making extra payments reduce total interest?

Yes, but only if the extra amount is applied to the principal, not as an early payment of next month’s bill. Most lenders apply extra payments to principal automatically, but it is worth confirming. This calculator assumes every dollar you pay reduces the principal, so extra payments shorten the payoff time and reduce interest.

How do I calculate the payoff if I make biweekly payments?

Convert your biweekly payment to an equivalent monthly amount: multiply the biweekly amount by 26 and divide by 12. For example, $100 biweekly = $100 × 26 / 12 ≈ $216.67 per month. Enter that in the payment field to get an accurate estimate. The result will be slightly different from making 12 monthly payments because you are effectively making 13 full payments per year.

Can I use this calculator for student loans or auto loans?

Yes, as long as the loan has a fixed interest rate and you plan to make a fixed monthly payment. For federal student loans with income-driven repayment, the payment changes yearly, so this simple model will not match exactly. For auto loans, the rate is usually fixed, so the estimate is quite accurate. Just enter the current balance, APR, and your planned payment.

Why does the calculator show a different payoff time than my lender?

Lenders may use a slightly different compounding method (daily vs. monthly) or round the payment date differently. They also include fees and may adjust the final payment. The calculator gives a close estimate, but the lender’s amortization schedule is the authoritative source. If the difference is large, check whether your rate is variable or if fees are being added.

The result from this calculator is an estimate for planning purposes. Your lender’s disclosure and monthly statements provide the exact payoff figures, including any fees or rate changes.

Related

Formula used
in p | Current balance | $ | 5000 | 1 | 10000000
in apr | Interest rate (APR) | % | 18 | 0.01 | 100
in pmt | Monthly payment | $ | 200 | 1 | 10000000
out months | Months to payoff | months | ceil(round(-ln(1 - (apr / 1200) * p / pmt) / ln(1 + apr / 1200), 6)) | 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 →