Blog

How long will minimum payments take? Work out your own payoff date

Step a balance forward month by month with interest and a percent-of-balance minimum, see how long and costly it runs, then compare it with your warning box.

Every credit card statement carries a small box that says how long it would take to pay off your balance if you made only the minimum payments and added no new charges. Most people glance at it, find the number alarming and move on. You can reproduce that number yourself with a pencil, a calculator or a spreadsheet, and doing it once shows why it is so long. It also gives you a way to test what a small change in your payment would do before you make it.

This worksheet walks through the whole calculation for one example balance, shows the results at several points along the way and ends with a blank version for your own numbers. The example is a labeled hypothetical. The rate and the minimum-payment formula are illustrations, and yours may differ.

What you are calculating

A minimum payment on revolving credit is the smallest amount you must pay by the due date to keep the account current. On most cards it is the greater of a fixed floor and a percentage of the balance plus the month's interest. Because the interest part falls as the balance falls, and the percentage part falls too, the payment shrinks as you pay down. That is the heart of the problem, and the worksheet makes it visible.

The calculation has one loop, repeated once per month:

  1. Interest for the month = starting balance x APR / 12.
  2. Minimum payment = the greater of the floor and (interest + a percentage of the starting balance).
  3. Ending balance = starting balance + interest - payment.
  4. Ending balance becomes the next month's starting balance.

Repeat until the balance reaches zero. Count the months. Add up the interest. That is all.

It is a simplified model. Real issuers apply a daily rate to daily balances, which gives slightly different figures, and work out one month of card interest by hand with average daily balance shows how. For judging a payoff time, dividing the APR by 12 is accurate enough.

Step 1: gather four numbers

From your latest statement and agreement, write down:

  • Your balance. The statement balance or current balance, whichever you are paying down.
  • Your APR for that balance. If you have more than one balance at different rates, do the worksheet for each, or start with the one at the highest rate.
  • The minimum payment formula. It is in the agreement, in a paragraph on the minimum payment. Look for a percentage of the balance, a dollar floor and whether interest and fees are added.
  • Whether you plan to add new charges. The warning box assumes you will not. This worksheet does too.

For the example:

  • Balance: $2,000
  • APR: an illustrative 20 percent, which is 1.6667 percent a month
  • Minimum payment: the greater of $25 or the month's interest plus 1 percent of the balance
  • New charges: none

Step 2: do the first month by hand

  • Interest = $2,000 x 0.20 / 12 = $33.33
  • Minimum = $33.33 + 1 percent of $2,000 ($20.00) = $53.33, which is more than the $25 floor, so $53.33 applies
  • Ending balance = $2,000 + $33.33 - $53.33 = $1,980.00

In the first month, $33.33 of the $53.33 payment, about 62 percent, is interest (the finance charge on the statement). Only $20 reduces the balance.

Second month, starting from $1,980.00:

  • Interest = $1,980.00 x 0.20 / 12 = $33.00
  • Minimum = $33.00 + $19.80 = $52.80
  • Ending balance = $1,980.00 + $33.00 - $52.80 = $1,960.20

Notice the payment fell from $53.33 to $52.80. It will keep falling.

Step 3: fill in the table

Here is the table for the first six months, then selected later months. Each starting balance is the previous month's ending balance.

Month Starting balance Interest Minimum payment Ending balance
1 $2,000.00 $33.33 $53.33 $1,980.00
2 $1,980.00 $33.00 $52.80 $1,960.20
3 $1,960.20 $32.67 $52.27 $1,940.60
4 $1,940.60 $32.34 $51.75 $1,921.19
5 $1,921.19 $32.02 $51.23 $1,901.98
6 $1,901.98 $31.70 $50.72 $1,882.96
12 $29.84 $47.75 $1,772.77
24 $26.45 $42.33 $1,571.36
36 $23.45 $37.52 $1,392.83
60 $18.42 $29.48 $1,094.31

A few readings from this table.

  • After six months the balance has fallen by $117.04, from $2,000 to $1,882.96.
  • After a full year, the cardholder has paid about $605.93 in total, of which about $378.71 was interest. The balance is $1,772.77, down $227.23.
  • After three years, at month 36, the balance is still $1,392.83, about 70 percent of where it started.
  • The $25 floor begins to apply around month 77, when the balance is about $922. From then on the payment stops shrinking and stays at $25.

Step 4: read the result

Continuing the same steps to the end:

  • Months to pay off: 135, which is 11 years and 3 months
  • Total interest: about $2,317
  • Total paid: about $4,317, more than double the original $2,000

The last payment is about $18, and the balance reaches zero in month 135. At no point did the cardholder do anything but pay on time. The formula produced the result.

The reason is the shrinking payment. Early on, a bit more than half of each payment is interest. The 1 percent part of the minimum reduces the balance by only 1 percent a month, which is a slow slope. A balance that falls 1 percent a month takes years to fall by half.

Step 5: test a small change

The most useful thing the worksheet does is let you change an input and rerun it. Here are three changes to the same example.

Add $25 to every payment. The cardholder pays the minimum plus $25. The first month's payment becomes $78.33, and the balance after month 1 is $1,955.00.

  • Months to pay off: 50, which is 4 years and 2 months
  • Total interest: about $850
  • Total paid: about $2,850

That is 85 months faster and about $1,467 less in interest, for $25 more a month.

Pay a fixed amount equal to the first minimum. If the cardholder pays $53.33 every month and does not let it fall, the payoff takes about 60 months, which is 5 years, and costs about $1,165 in interest. A fixed payment ends the slow tail, and it costs nothing extra in month 1.

Pay the 36-month figure. Federal rules require the statement's warning box to show the payment that would pay the balance off in 36 months. For this example, the payment is $2,000 x (0.20 / 12) / (1 - (1 + 0.20 / 12)^-36), which is about $74.33. Over 36 months the total paid is about $2,676, and the interest is about $676. Compared with the minimum path, the cardholder is $21 a month higher in the first month and finishes more than eight years earlier.

Path First payment Months Interest Total paid
Minimum only $53.33 135 about $2,317 about $4,317
Minimum plus $25 $78.33 50 about $850 about $2,850
Fixed at the first minimum $53.33 60 about $1,165 about $3,165
36-month payment $74.33 36 about $676 about $2,676

You can add your own row. Set the payment in the loop to any amount you choose and rerun it.

Step 6: compare with the statement's warning box

Find the box on your statement. It says something like: if you make only the minimum payment each month, you will pay off the balance shown on this statement in about a stated number of years and you will end up paying a stated total. It also gives a payment amount and total for paying off in 36 months.

Compare it with your own result. The two should be close if you used the issuer's actual minimum formula and rate. If they differ, there are ordinary reasons.

  • The formula. Your issuer's formula may use 2 percent of the balance, or 1 percent plus interest and fees, or a different floor. Change the loop to match your agreement.
  • The rate. The box may use your current APR as if it stays fixed. A variable rate that rises or falls changes the real outcome. A promotional rate that ends changes it too.
  • Rounding and daily interest. Small differences accumulate over many months.
  • Fees. A late fee or annual fee added to the balance would lengthen the schedule.

A quick illustration of a good match: say the box on this example statement reads "about 11 years and 4 months" with a total near $4,330, while your loop gives 11 years and 3 months and about $4,317. A one-month and $13 gap is rounding and the daily-versus-monthly interest difference, and it tells you the model is sound. A gap of several years or thousands of dollars is not rounding. It points to a different formula, a different rate or a balance you did not include, and it is worth a call to the issuer.

If your numbers are far from the box and you cannot explain it, ask the issuer how the box was computed. If the answer does not make sense, you can file a complaint with the CFPB.

Variations and pitfalls

How the answer moves with the balance and the rate

Once you can run the loop, you can see what matters most. Here is the same minimum formula, interest plus 1 percent with a $25 floor, applied to different balances and rates. These are illustrations.

Balance APR Months to pay off Total interest
$2,000 15% 124 about $1,632
$2,000 20% 135 about $2,317
$2,000 25% 145 about $3,032
$1,000 20% 66 about $650
$4,000 20% 204 about $5,650

Two things stand out. First, a rate that is five points higher adds only about ten months but adds roughly $700 in interest, because the interest is charged on a balance that lasts almost as long and is bigger each month. Second, doubling the balance does more than double the time and the interest: going from $2,000 to $4,000 raises the interest from about $2,317 to about $5,650, which is 2.4 times as much, because the larger balance stays above the $25 floor for longer. Balances compound their own costs, and that is why paying down the largest and most expensive balance first, as described in Debt avalanche or snowball? Same four cards, both methods compared, matters.

Mistakes people make with the worksheet

  • Using the wrong rate. A cash advance, a promotional balance and purchases may all have different rates. Use the rate for the balance you are modeling.
  • Forgetting the floor. Many minimum formulas have a dollar floor, and the tail of the payoff runs at the floor. Leaving it out makes the schedule look shorter than it will be.
  • Adding new charges to the model. The warning box assumes none. If you keep using the card, the schedule lengthens, and without a grace period each new charge accrues interest from the day it posts.
  • Assuming the rate stays put. A variable rate can move with the prime rate. If you want to see the effect, rerun the loop with a higher rate from a given month on.
  • Mixing the statement balance and the current balance. Start from the balance you intend to pay down, and say which one it is.
  • Treating the result as a promise. It is a projection from stated inputs. The real result depends on your payments, your rate and your charges.

A different formula, a different story

The example uses a formula of interest plus 1 percent. Suppose the issuer's minimum were instead a flat 2 percent of the balance, with the same $25 floor. Run the loop again on the $2,000 at 20 percent.

  • Months to pay off: about 250, which is more than 20 years
  • Total interest: about $5,210

A 2 percent-of-balance minimum can be even slower than interest plus 1 percent, because in early months it may be only a little more than the interest, and it falls with the balance. The reason is the same: a payment tied to the balance shrinks as the balance shrinks. This is why you should run the loop with your own formula, not rely on the example.

The blank worksheet

Fill in the first row from your statement and then continue down the table.

Month Starting balance Interest (balance x APR / 12) Minimum payment Ending balance
1
2
3
4
5
6

To keep going, use a spreadsheet. Put the starting balance in cell A2 and the APR as a decimal in a cell off to the side, say F1. Then in row 2:

  • Column B (interest): A2 multiplied by F1, divided by 12
  • Column C (payment): the larger of your floor and (B2 plus your percentage times A2)
  • Column D (ending balance): A2 plus B2 minus C2
  • Next row's A: the previous row's D

Copy the row down until column D reaches zero. The number of rows is the number of months, and the sum of column B is the total interest. To test a change, replace column C with your chosen payment, and compare.

If you prefer not to build it, the minimum payment calculator and the credit card payoff calculator perform the same loop. The value of doing it by hand once is that you see how the interest and the payment interact.

What to do with the answer

Key takeaways

  • The minimum payment is usually a floor or a share of the balance plus interest, so it shrinks as the balance falls and stretches the payoff.
  • In the example, $2,000 at an illustrative 20 percent with a minimum of interest plus 1 percent took 135 months and about $2,317 in interest, more than doubling the cost.
  • The loop is simple: interest, then payment, then new balance, repeated each month, and you can run it in a spreadsheet in minutes.
  • Adding $25 to each payment cut the example from 135 months to 50 and saved about $1,467, and the 36-month payment shown in the warning box was about $74.33 in the example.
  • Compare your result with the statement's warning box, adjust the formula to your agreement and use the answer to choose a payment you can sustain.

Terms used in this article

Related tools

Latest on this topic