8

So I'm in not-the-best™ position with about 15K in undesirable credit card debt (And another 5K in permanent no-interest deferred payment plans). I'm trying to calculate what the optimal payoff strategy is, but I'm coming up confused. Here's a brief overview of the amounts and approximate interest rates:

  • Acct 1: 5K, 0% for 5 months, then 14%
  • Acct 2: 6K, 14%
  • Acct 3: 4K, 0% for 10 months, then 22%

Obviously, if I didn't have the 0%, it would make the most sense to pay off the 22% first. That said, I'm currently able to make between $300-$500 payments every month to any one of these cards, above the minimums. The question is, what's the optimal strategy? 14% on Acct 2 is currently the highest, but then again, the 22% on Acct 3 will be highest after the intro period. I'm not sure how to do the math on these, or what to plug in to excel. I'm hoping someone will be able to post a good enough answer that I can solve this problem myself using excel or a pocket calculator.

6
  • 1
    Are you comfortable with spreadsheets? I'd load one up, showing the rate for each acct by month, and then tinker with the choices. Aug 20 '20 at 0:48
  • 1
    How big are your minimum payments on each account? That may affect the result.
    – glglgl
    Aug 20 '20 at 11:29
  • 2
    Do accounts 1 and 3 accrue the interest or are they truly no-interest?
    – D Stanley
    Aug 20 '20 at 12:29
  • They don't accrue any interest. They charge interest on the current balance monthly starting in the respective months. Aug 20 '20 at 21:31
  • @glglgl - just to add, it is still on my mind to figure out the simplest method for solving this problem. Thanks for your input. Aug 31 '20 at 18:36
3

This seems to be the minimal cost scenario: Pay into Account 2 for 4 months, then either 1 or 2 for 3 months. Then pay down Account 3. (Shown colour shaded). Then finish paying down 1 & 2.

Minimal payment schemes are not included. You can add them in to complicate things yourself.

For final account payments, overpayments from the $500 per month are passed to other accounts if possible, or deducted from the total cost.

Thanks to various members for their comments in my other answer (now abandoned).

enter image description here

with formulas

enter image description here

This Excel spreadsheet is available here for 7 days.

1

There is one strategy which is not obvious at the first glance:

Pay off A2 first as hard as you can, and continue on A1 after 5 months (maybe split the payments). This reduces your interest for now, but OTOH makes your A3 more expensive as you have to pay higer interest on the remaining balance.

But it also makes you eligible for a loan with low interest rate. And a loan with a rate of 5 or 8 or 10% is easier (cheaper) to pay off than cards with a rate of 14% or even 22%.

After 8 or 9 months, depending on how long it takes to clear the process, try to apply for a loan for less than 22%, maybe even less than 14%. Pay off your remaining balances with that loan and then only pay off that loan.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.