[Math] Finding a fix amount payment to payoff multiple credit cards in 24 months

algebra-precalculuscalculusfinance

Mr.Debt has 3 credit cards. First card have \$5,000 balance with the rate of 10% compounded monthly. Second card have \$2,000 balance with the rate of 14% compounded monthly. Third card have \$4,000 balance with the rate of 8% compounded monthly. All card have minimal payment of 1% + each month interest . Mr.Debt want to set a fix amount of payment per month. How much will Mr.Debt will have to pay as little as possible and still payoff his debt in 24 months.

Please Help.

I found the formula to do a single credit card which is http://www.algebra.com/algebra/homework/word/finance/Money_Word_Problems.faq.question.321982.html
but does not seem to work with multiple credit card.

Best Answer

To actually solve your problem, you would start out with an unknown amount of $X$ payment per month. This is the variable you care about. In fact, you would program a function where this is your input. You would then program an iterative process that pays the minimum on the two cards with the lower rates and the rest of $X$ on the one with the highest balance, until that one is paid off. Once that one is paid off, you start paying the minimum on the one with 8\% interest and pay all the rest to the one with 10\%. And, you would make payments for 24 months. And, once the the second is paid off, all remaining payments go to the one remaining card.

Now that you have this function programmed, you run it with different values of $X$ until your remaining value is \$0. Use some basic knowledge, such as, if one value of $X$, say $X_1$, gives you a positive balance at the end, and another, say $X_2$, gives you a negative balance at the end, then your answer is somewhere in between.

By the way, in reality, the formula you found is wrong. A 12% annual interest rate does NOT translate into 1% per month. But, maybe that is how they teach things when you first see this stuff.

$$A(t) = A_0 \left( 1 + \frac{r}{n} \right)^{nt}$$

is the formula you can use to find the amount, $A(t)$, at time $t$ if your initial balance is $A_0$, your interest rate is $r$ (given as a decimal, so 12% would be 0.12), and $n$ is the number of payments per month. An annual rate of 12% per year means that if you start with \$100, after 1 year, you will have 12%. A monthly rate of 1% means after 1 month, you would have $100 (1 + .01) = 101$. And, in general, after $k$ months, you'd have $100 (1.01)^k$. So, after 12 months, you'd actually have \$112.68. It's somewhat close, but it's not the same.

To take an annual rate, $r$, and translate it into the appropriate monthly rate, you would want to solve $$1 + r = \left( 1 + \frac{i}{12} \right)^{12}$$ for $i/12$, which would give you $$\frac{i}{12} = (1+r)^{1/12} - 1.$$

So, for instance, if your annual rate is 14%, your monthly rate would be $$\frac{i}{12} = (1.14)^{1/12} - 1 = 0.010978852.$$ This is not the same as 0.14/12 = 0.011666666666.

On the other hand, if you said that your interest rate is 14% compounded monthly, then your monthly rate is in fact 0.14 / 12. It's a matter of knowing the terminology and it is important in reality. Just to be clear, if you say your rate is an annual rate of 14%, then the above calculations are necessary. If you say the rate is 14% compounded monthly, then the monthly rate is 0.14/12.

Related Question