# Formula for Calculating Amortization for Credit Card Debt

••• Hoxton/Sam Edwards/Hoxton/GettyImages
Share It

With interest rates typically much higher than interest rates for secured debt such as mortgages and car loans, you may want to make paying off your credit cards a priority. Your ability to calculate the monthly payment required to pay off your debts may help you get your credit card debt under control.

#### Tips

• If you are ready to begin calculating the amortization on your credit card debt, you can do so using a mathematical formula which utilizes your current credit card balance, your credit card interest rate, and the number of years in which you are planing to pay off your card.

## Evaluating the Amortization Formula

Calculate the monthly payment required to pay off your credit debt with the formula: CCB / [1 - (1/(1+i/12)^(n_12)] / (i/12)], where _CCB is your credit card balance, i is your annual credit card interest rate and n is the number of years in which you want to pay off your credit card. If you owe \$10,000 on a credit card with a 19.5 percent interest rate and you wish to pay it off in 3 years, the required monthly payment would be \$10,000 _/ [1-(1/(1+0.195/12)^(3_12)] / (0.195/12)] = \$10,000 / [1-1/(1.01625)^36] / 0.01625 = \$369.09.

## Exploring Total Interest

Calculate the total interest you will pay over the period it will take you to pay off the debt by using: (Payment * n * 12) - CCB, where Payment is the monthly payment required to pay off the debt, n is the number of years in which you want to repay the debt and CCB is your current credit card balance. Paying off a \$10,000 credit card debt at 19.5 percent interest with a monthly payment of \$369.09 over 3 years would result in total interest of (\$369.09 * 3 * 12) - \$10,000 = \$3,287.24.

## Working With the Amortization Table

You can create an amortization table to track your credit card debt as you make regular payments every month. Start at month(0) with your current credit card balance. For month(1) your interest charge will be Interest(1) = i / 12 * CCB(0), where i equals your credit card annual interest rate and CCB(0) is your current credit card balance. Your credit card principal repaid will be Principal(1) = Payment - Interest(1), and your new credit card balance in month(1) will be CCB(1) = CCB(0) – Principal(1). A \$10,000 credit card balance at 19.5 percent interest will generate an interest charge of 0.195 / 12 * \$10,000 = \$162.50. Principal repaid will equal \$369.09 - \$162.50 = \$206.59. Your new credit card balance will be \$10,000 - \$206.59 = \$9,793.41. Repeat these steps for each month thereafter.