Skip to content
LoveToCalc

Debt payoff calculator

See how long it takes to clear a balance at a fixed monthly payment, and the total interest cost. Compare two payoff plans side by side.

Your numbers

Result

Time to pay off

2 years and 9 months

Put a second set of numbers beside this one and see the difference.

Total interest
$1,522
Total paid
$6,522

Paying $200 a month on a $5,000 balance at 20% pays it off in 2 years and 9 months, costing $1,522 in interest.

Assumes a fixed monthly payment and a fixed nominal annual rate compounded monthly, with no new charges added to the balance.

Download the month-by-month payoff plan

The CSV uses commas between fields and a decimal point. In the Excel file the numbers are plain numbers, which Excel shows in your own format.

Debt payoff time in Excel: NPER

The same calculation in one cell, with your numbers. Paste it into Excel:

=ROUNDUP(NPER(20%/12,-200,5000),0)

In Swedish Excel the functions are called AVRUNDA.UPPÅT and PERIODER. There the arguments are separated by semicolons and decimals written with a comma. Google Sheets uses the English names whatever the language.

The minus sign is not a mistake. Excel tells money coming in from money going out by its sign, so one of the amounts is negative. Flip the signs and the answer flips too.

What this calculator answers

Given a balance, an interest rate and a monthly payment you plan to make, how many months until it’s paid off — and how much of that is interest? This is the reverse of a typical loan calculator: instead of fixing the term and solving for the payment, it fixes the payment and solves for the term. That fits credit cards and other revolving debt well, where you choose what to pay each month rather than following a preset schedule.

Formula

Simulated month by month rather than a single formula, so the smaller final payment falls out naturally:

Interest this month = Balance × (r / 12)

Payment = min(Monthly payment, Balance + Interest)

New balance = Balance + Interest − Payment

Worked example

A $5,000 balance at 20% APR, paid off with $200 a month, takes 33 months and costs about $1,522 in interest, for a total of about $6,522 paid.

Why the payment matters so much

The same $5,000 balance at 20% APR, paid off at different monthly amounts:

Per month Time Total interest
$100 109 months $5,840
$150 50 months $2,359
$200 33 months $1,522
$250 25 months $1,133
$300 20 months $907
$400 15 months $654

Going from $100 to $150 a month cuts payoff by five years and saves about $3,500 in interest. Further down the table each extra dollar saves less, but it saves something all the way.

Close to the limit the time grows fast. The first month’s interest is $83.33. Pay $84 a month and payoff takes 293 months, over 24 years, with about $19,578 in interest, nearly four times what you borrowed.

If you have several debts

Pay the minimum on all of them and put everything left over on the debt with the highest interest rate. That order costs the least interest overall, and is often called the avalanche method. Some prefer to clear the smallest balance first, the snowball method, to get one debt out of the way quickly. It costs a little more but can be easier to stick with. Run each debt through the calculator to see the difference.

What this does not include

Common mistakes

Frequently asked questions

Why does it show a dash instead of a number? That means the monthly payment doesn’t cover the interest that accrues each month — at a fixed payment below that level, the balance would never shrink, so there’s no payoff time to show.

How is this different from the loan calculator? The loan calculator fixes the term (say, 5 years) and calculates the payment needed. This calculator fixes the payment and calculates how long it takes — useful when you’re deciding what to pay rather than following a set schedule.

Is it cheaper to pay twice a month? Only slightly. Interest is charged on the balance, so money paid earlier saves a little interest. The big difference comes from paying more each month, not from splitting the same amount.

Last reviewed October 6, 2026 ·How pages are reviewed

The formula behind this

All loans calculators

Put this calculator on your site

Copy the code into your page where the calculator should appear. It loads from lovetocalc.com, so it stays current on its own — all we ask is that the credit line comes with it.