Computerized Investing > December 22, 2012

# Vertex 42 Debt Reduction Calculator

## by CI Staff

The Debt Reduction Calculator is a Microsoft Excel spreadsheet that helps you plan how to reduce credit card debt, auto loans, student loans and other debts. Its easy-to-use format and built-in formulas can help alleviate your financial stresses.

The application contains two different tabs. The first one is the Calculator tab. There are a couple different debt-reduction strategies in the Calculator tab that the user can choose from. The “snowball” strategy encourages the user to pay off the lowest balance first and the “avalanche” advises the user to first pay the debt with the highest interest. The program explains each theory and the positives and negatives of each approach, so you can choose which strategy fits best with your financial situation.

CI Staff .
CI Staff Profile
All Articles by CI Staff

The spreadsheet has a creditor information table where you input each creditor, the balance on the account, the rate you are being charged and your minimum payment. The program will show a red background in the cell if you are trying to make a payment smaller than the interest-only payment.

The Debt Reduction Calculator spreadsheet is very self-explanatory and clearly lays out the payments for the user. You will know how much you are paying on each debt as well as a total of how much you need to pay per month. Each creditor gets broken down into another table that shows the user the original balance, total interest paid, how many months it will take to pay it off and when the debt will be paid off. There is a grand total for total interest paid. You can move your payments around, change amounts or try different approaches in order to find a way that works best for you as well as minimizes your total interest paid.

The monthly payment is the amount you have to set aside each month to pay your debts. If your total payment comes out to \$270.00 and you input \$500.00 for the amount that you can set aside, your “snowball” for that month would be \$230.00. That is money that you have left over after you’ve made all your minimum payments. From there, you can choose to use that money to pay off more debt and lower your total interest paid, or keep that as discretionary income.

Welcome to the American Association of Individual Investors.

AAII is a nonprofit association dedicated to investment education. For full access to our award-winning content, classrooms, model portfolios and stock screens, please take a moment to join AAII today for only \$29 -- a 40% savings off our regular rate.

Debt Reduction Calculator

The next tab is the Payment Schedule. This tab shows again each creditor, balance, rate, base payment, months to pay off, month paid off and total interest paid on each debt. This is similar to a checkbook in that it keeps record of each payment. Everything is carried over from the other tab, so there is nothing to edit except where you input any additional amount you would like to pay on your debt. The chart will automatically add the additional amount into the column of the creditor that should be paid first to avoid a higher total interest amount.

Overall, the Debt Reduction Calculator is a great tool for managing debt and reducing total interest paid. The user can view all their debts on one spreadsheet and manage their payments efficiently. The application is easy to navigate through and a description of each part of the spreadsheet is given by clicking on any cell with a red flag.

Vertex 42 Debt Reduction Calculator

System Requirements: Windows NT/Me/2000/XP/Vista/7

Size: 915.97K

Price: Free

## Discussion

Why are they exe files for an Excel spreadsheet? This one caused a Runtime Error in Visual C++. "This applicationhas requested the Runtime to terminate it in an unusual way."

Really annoying when you make it sound like something that can benefit me and then it doesn't work. Are you guys a branch of the government?

posted 5 months ago by James Ranum from Florida

I agree with James. First of all, I have a MacBook and pretty well knew it would not work when I read system requirements. Tried it anyway to no surprises there. Why not simply load the .xls file? I can get into it on my Mac. Also, it appears that you don't like Macs anyway as I can't purchase the stock software as it only runs on a Windows system. Would be nice if it were easier.

posted 5 months ago by Daniel Ekstrand from Illinois

I had the same problem. How can I open this spreadsheet and save on my pc?? Thanks, Bob

posted 5 months ago by Bob Pajak from Massachusetts

I couldn't open the exe file. I got a run time error

posted 5 months ago by Athan Skroumbelds from New Jersey

I also receive the Runtime Error in Visual C++. When I click on the icon that appears on my desktop I get another box that tells me......This is not a valid Win32 application.

How do I solve this issue???

posted 4 months ago by Allan Lozier from Nebraska

The issue has been fixed! Thank you for letting us know about your concerns.

posted 4 months ago by CI Staff from Illinois

You need to log in as a registered AAII user before commenting.
Create an account