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.

Christ Schlacta
  • 115
  • 4
  • 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. – JTP - Apologise to Monica Aug 20 '20 at 00: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. – Christ Schlacta 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. – Chris Degnen Aug 31 '20 at 18:36
  • @ChrisDegnen I have made several attempts to solve the question in a simpler way than you did, but with no success. Essentially, you have to weigh the benefit of reducing the interest for A2 (and later A1) to the benefit of not having to pay 22% on A3. There is a certain break-even point, and you seem to have found it. – glglgl Sep 01 '20 at 08:47

2 Answers2

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.

Chris Degnen
  • 9,797
  • 1
  • 20
  • 36
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.

glglgl
  • 5,417
  • 1
  • 17
  • 34