Blog

What monthly payment clears my card in 24 months? Work it out

A fixed-payment formula, a no-calculator lookup table and a fill-in worksheet that find the payment needed to clear your balance by a date you choose.

If a card has a $4,000 balance at a 24% APR and no new charges, it takes a payment of about $211.48 every month for 24 months to bring the balance to zero. That is the answer for one invented card. This worksheet shows you how the number is produced so that you can produce your own: with a calculator in about two minutes, with a lookup table and no calculator, or by building the schedule by hand to check it.

You will need three numbers from your latest statement (the balance, the APR and the date you want to be done) and a pencil. The figures below belong to an invented household and are illustrations, not typical balances or rates. Your statement is the source for your own.

The question the formula answers

A fixed-payment plan has a simple structure. Each month the card adds interest to what you owe (and because next month's interest is charged on a balance that includes this month's, it is compound interest), then your payment comes off. If the payment is large enough, the balance shrinks; if it is not, the balance grows or stalls. The formula finds the single payment that makes the balance land exactly on zero after the number of months you pick.

Two inputs describe the card:

  • r, the monthly rate: the APR divided by 12. For 24% that is 0.02. (Cards actually apply a daily rate to your average daily balance across the billing cycle, so a real statement will differ slightly from a monthly estimate. For planning, the monthly rate is close enough.)
  • n, the number of months you want to take.

And one input describes your debt:

  • B, the balance.

The payment is:

payment = B × r ÷ (1 − (1 + r)^−n)

The top part, B × r, is the first month's interest. The bottom part is a number between 0 and 1 that gets larger the more months you allow. Giving the debt more time makes the bottom bigger, so the payment gets smaller.

The worked example, one step at a time

Take B = $4,000, an APR of 24% (so r = 0.02) and n = 24 months.

  1. Find (1 + r): 1.02.
  2. Raise it to the power n: 1.02 to the 24th is about 1.608437. (On a calculator, press 1.02, then the power key, then 24.)
  3. Take the reciprocal: 1 ÷ 1.608437 is about 0.621721. This is (1 + r)^−24.
  4. Subtract from 1: 1 − 0.621721 = 0.378279.
  5. Compute the first month's interest: B × r = $4,000 × 0.02 = $80.00.
  6. Divide: $80.00 ÷ 0.378279 = $211.48.

So the payment is $211.48. Over 24 payments that comes to about $5,075.63 (the exact figure using unrounded numbers), meaning about $1,075.63 of interest on the $4,000 balance. Rounding the payment to cents leaves a few cents' difference.

Now check it by building the first three months of the schedule:

Month Starting balance Interest (2%) Payment Goes to principal Ending balance
1 $4,000.00 $80.00 $211.48 $131.48 $3,868.52
2 $3,868.52 $77.37 $211.48 $134.11 $3,734.41
3 $3,734.41 $74.69 $211.48 $136.79 $3,597.62

Two patterns to notice. The interest falls each month because the balance falls, so the same payment sends more and more to principal. And continuing the same arithmetic, the balance after 12 payments is $2,236.58 and, a year later, essentially zero, with a final payment of a few cents once rounding catches up. If you round the payment up to a clean $212, the 24th payment is $196.30 and total interest is $1,072.30, which many people prefer because $212 is easier to enter on an autopay screen.

A second example with different numbers

Repeating the calculation on a different card shows which steps depend on what. Say a second invented cardholder owes $7,500 at 21% and also wants 24 months. The monthly rate is 21% ÷ 12 = 1.75%, or 0.0175.

  1. (1 + r) = 1.0175.
  2. 1.0175 to the 24th is about 1.516443.
  3. The reciprocal is about 0.659438.
  4. 1 − 0.659438 = 0.340562.
  5. First month's interest is $7,500 × 0.0175 = $131.25.
  6. $131.25 ÷ 0.340562 = $385.39 a month.

Over 24 months that is about $9,249.42, or roughly $1,749.42 in interest. The first month's interest is $131.25, so $254.14 of the first payment goes to principal. A larger balance at a lower rate produces a bigger payment because the balance is bigger, even though the rate is lower. The two examples also show that the target date matters more than the rate: halve the months and the payment roughly doubles, whatever the APR.

The first check: is the payment above the monthly interest?

Before trusting any plan, compare your minimum payment and your planned payment to one month's interest on your current balance (B × r). In the example that is $80.00. A payment of $80.00 or less does nothing to the debt: all of it goes to interest, and anything under that makes the balance grow. This is the most common reason a payoff does not move, and it is easy to see on a statement: the interest charged line shows what the card added that month. How long will minimum payments take? Work out your own payoff date shows how a minimum payment set just above the interest produces a very long payoff.

The shortcut: a lookup table for each $1,000

You can skip the exponent. The table below gives the payment needed per $1,000 of balance, computed with the same formula, for three common targets. To use it, divide your balance by 1,000 and multiply by the figure in the row for your APR and the column for your months.

APR 12 months 24 months 36 months
12% $88.85 $47.07 $33.21
15% $90.26 $48.49 $34.67
18% $91.68 $49.92 $36.15
20% $92.63 $50.90 $37.16
22% $93.59 $51.88 $38.19
24% $94.56 $52.87 $39.23
26% $95.53 $53.87 $40.29
28% $96.51 $54.89 $41.36

Examples:

  • $4,000 at 24%, 24 months: 4 × $52.87 = $211.48, which matches the formula.
  • $2,350 at 20%, 12 months: 2.35 × $92.63 = $217.68. (The formula gives $217.69; the table rounds each figure to cents.) Total interest is about $262.29.
  • $9,000 at 22%, 24 months: 9 × $51.88 = $466.92. (The formula gives $466.90.)

If your APR is between two rows, use the row for the higher APR, which gives a slightly higher and safer payment. Notice also how little the APR changes the 24-month payment on small balances: moving from 20% to 24% adds about $1.97 per $1,000 each month.

What the target date does to cost

The date you choose trades a bigger payment for less interest. For the same $4,000 balance at 24%:

Months Monthly payment Total interest
12 $378.24 $538.86
18 $266.81 $802.55
24 $211.48 $1,075.63
36 $156.93 $1,649.53
48 $130.41 $2,259.55

Going from 24 months to 12 takes the payment up by $166.76 a month and cuts interest by $536.77. Going from 24 months to 36 takes the payment down by $54.55 and raises interest by $573.90. Neither is better in the abstract. The right row is the shortest one whose payment you can keep paying, month after month, including the months when something goes wrong. A payment you abandon at month 8 costs more than a longer plan you finish.

Working backward: how long will my payment take?

Sometimes the payment is fixed by your budget and the unknown is the date. The same formula rearranged gives the number of months:

months = −ln(1 − B × r ÷ payment) ÷ ln(1 + r)

The "ln" key is the natural logarithm on a calculator or spreadsheet (in a spreadsheet, LN). For the $4,000 balance at 24% and a payment of $150: B × r is $80, and 80 ÷ 150 is 0.533333, so the expression in brackets is 1 − 0.533333 = 0.466667. The natural log of 0.466667 is about −0.76214, and ln(1.02) is about 0.019803, so months = 0.76214 ÷ 0.019803, which is about 38.5. That means 39 payments, the last one smaller, and total interest of $1,773.36.

The same balance at other fixed payments shows how sensitive the answer is when the payment sits close to the monthly interest of $80:

Fixed payment Months Total interest
$85 144 $8,161.44
$100 82 $4,127.64
$150 39 $1,773.36
$180 30 $1,343.20
$212 24 $1,072.30

Moving from $85 to $100, an extra $15 a month, cuts the payoff from twelve years to under seven. Moving from $150 to $212 takes it from 39 months to 24. Near the interest line a few dollars matter enormously; far from it, the same few dollars matter much less. If your current payment is only a little above your monthly interest, a small increase is the highest-value change available.

The worksheet

Fill this in with your own numbers. A completed example for the invented household is in the right-hand column.

Line What to write Example
A Current balance (from the statement) $4,000.00
B APR (from the statement) 24%
C Monthly rate r (B ÷ 12, as a decimal) 0.02
D First month's interest (A × C) $80.00
E Months you want to take (n) 24
F Payment from the table or formula $211.48
G Principal in month 1 (F − D) $131.48
H Balance after month 1 (A + D − F) $3,868.52
I Total you will pay (F × E, approximately) about $5,076
J Total interest (I − A) about $1,076
K Does the payment fit my budget every month? yes / no

If line K is "no," try a longer date and fill the sheet in again. If it is "yes," put the payment on autopay as a fixed amount, not as "minimum due." The credit card payoff calculator checks your arithmetic and shows the whole schedule, and the minimum payment calculator shows what your card's own minimums would do by comparison.

Several cards at once

The formula works for one balance at one rate. With several cards, there are two sound ways to use it.

Card by card. Run the worksheet for each card to find the payment each would need on its own, then add them. This gives a total monthly budget and a feel for the target.

Blended estimate. Weight each APR by its balance. Suppose one card has $3,000 at 26% and another has $2,000 at 16%. The weighted rate is (3,000 × 26% + 2,000 × 16%) ÷ 5,000 = 22%. Treat the pair as $5,000 at 22%: 5 × $51.88 = $259.40 for 24 months. That is an approximation, since it ignores how you order the payments, but it gives a ballpark. Aiming extra money at the higher-rate card first usually does slightly better, and how to build a credit card payoff plan you can actually stick to covers how to sequence it. Keep paying the minimum on every card while you do.

Slips to avoid when you run the numbers

Most wrong answers come from a handful of small errors, and each is easy to catch once you know it.

  • Using the APR as the monthly rate. If you put 0.24 in place of 0.02 you get a payment of about $965.53 for the $4,000 example, more than four times the right answer. Divide the APR by 12 first.
  • Mixing years and months. The exponent n is the number of monthly payments. Two years is 24, not 2.
  • Using the wrong balance. Use the current balance you owe, including interest charged since the statement if you have it, not the amount of your last payment or your credit limit. If you owe different amounts on different dates, today's figure from the card's website is more useful than last month's statement.
  • Forgetting that the card may have more than one rate. A statement can list a purchase balance, a balance transfer balance and a cash advance balance, each with its own APR. Run the formula for each part separately.
  • Trusting a payment that sits just above the interest. The $85 row in the table above shows what happens: the arithmetic works, and it also says twelve years.

If your answer looks surprising in either direction, rebuild the first month by hand (interest, then payment, then new balance). If the first month does not match what you expect from the formula, the inputs are wrong, not the method.

What can throw the answer off

A payment calculated today is correct for today's inputs. Four things change them.

  • A rate change. Most card APRs are variable and track the prime rate. If the APR rises by a quarter point, to 24.25%, the payment needed for the remaining 12 months on a $2,236.58 balance goes from about $211.49 to about $211.76, a difference of 27 cents a month. A bigger move changes it more. Recompute when your APR changes.
  • New charges. The formula assumes none. Every new purchase you do not pay off by the due date adds to B. eight mistakes that stall a credit card payoff plan and how to fix each shows how much damage new charges can do.
  • Fees. A late fee, an annual fee or a cash advance fee adds to the balance. Late fees are limited by federal rule to no more than the minimum payment due, but they still move the plan.
  • A promotional rate ending. If part of the balance is at a low promotional rate, the formula needs the promotional rate for the promotional months and the standard rate afterward. Treat each balance separately.

Put a reminder to redo the worksheet every three months, or whenever the APR on a statement changes.

If the payment does not fit

Sometimes line K is "no" for every date you can bear. Options, in rough order of how little they disrupt your life:

  1. Choose a longer date, such as 36 or 48 months, and see what you pay in interest. A smaller payment you can sustain beats a bigger one you cannot.
  2. Look for money in the budget, using a worksheet such as what an extra $50, $100 or $200 a month does to a card payoff for what small additions achieve.
  3. Call the issuer, using the number on the back of the card, and ask what hardship programs exist and what they cost.
  4. Talk to a nonprofit credit counselor, who can review all your debts and explain options such as a debt management plan. The CFPB's consumer pages describe what to expect.

Be cautious about advertisements promising to erase card debt for cents on the dollar, and never pay a stranger who calls you about your debt. If a company asks for fees up front to settle or reduce debt, that is a red flag under the FTC's rules for debt relief sellers.

Key takeaways

  • The fixed payment that clears a balance in n months is B × r ÷ (1 − (1 + r)^−n), where r is the APR divided by 12. For $4,000 at an illustrative 24% over 24 months it is $211.48.
  • Check that your payment exceeds one month's interest (B × r). A payment at or below it never reduces the debt.
  • The lookup table gives the payment per $1,000 at common APRs and terms, so you can skip the exponent.
  • The date is a trade-off: in the example 12 months cost $538.86 in interest and 36 months cost $1,649.53. Pick the shortest date whose payment you can sustain.
  • Redo the worksheet whenever the APR changes, a promotion ends or you add charges.

Terms used in this article

Related tools

Latest on this topic