1. Computing

4 Free Debt Reduction Spreadsheets

Consolidate Debt with Free Spreadsheet Templates

By

Coming up with a plan for paying off debt sounds difficult, especially if you don’t have a financial background. But, if you can use a spreadsheet, you can plan to pay off your debt. Download one of these debt reduction spreadsheets and get started with your plan.

Technically, these are spreadsheet templates that can be used with Microsoft Excel, OpenOffice Calc or Google docs. Templates are pre-formatted spreadsheets with formulas that have been entered, and all you need to do is download the template and open it. Just plug in a few numbers and the spreadsheet does the math for you. Some of the choices listed also present schemes for dealing with your loans, credit card and other debt.

If you need even more automation, check out my list of debt reduction planning software, or see my picks for debt reduction apps for iPhone and iPad or Android mobile devices.

Vertex 42 Debt Reduction Snowball Calculator and Credit Repair Spreadsheet

Get different scenarios for paying off debt with this debt calculator spreadsheet.
Vertex 42 Debt Reduction Snowball Calculator Spreadsheet
Vertex42.com
You can learn something from the Debt Reduction Snowball Calculator spreadsheet from Vertex 42 when you choose between different debt reduction strategies after all your debts are entered. This spreadsheet includes additional information about those strategies with more resources for reducing debt. Enter your information, then select the different strategies to see how each would work for paying off your debt. This spreadsheet includes a printable payment schedule.

Need help repairing your credit? Download the Debt Reduction Calculator - Credit Repair Edition to first pay down each credit card to specific levels determined by your FICO score. Once that goal is reached, the spreadsheet shows you how to start paying off all credit card balances.

Download Debt Reduction Snowball Calculator Spreadsheet
Download the Debt Reduction and Credit Repair Spreadsheet

Squawkfox Debt Reduction Spreadsheet

The debt reduction spreadsheet at Squawkfox.com is really simple.
Squawkfox Debt Reduction Spreadsheet
Squawkfox.com
Start by entering your creditors, current balance for each bill and interest rates and the monthly payments you’re making into this simple spreadsheet to see your current total debt, average interest rate and average monthly interest paid and total of monthly payments on debt accounts.

You will need to have an idea of how much money you will dedicate each month to paying off credit cards and other debt for the next step in this spreadsheet. Enter the amount you have planned or budgeted for paying down the debt and the spreadsheet will tell you what portion of that amount should be used to as additional funds to be applied to the bill with the highest interest rate.

The author of the spreadsheet and the Squawkfox blog, Kerry Taylor, paid off $17,000 in student loans over six months using this spreadsheet.

Download Squawkfox Debt Reduction Spreadsheet

It's Your Money Excel DebtTracker Spreadsheet

The paydown worksheet in DebtTracker shows your debt reduction progress
Pay Down Worksheet in DebtTracker Spreadsheet
www.mdmproofing.com
DebtTracker is not quite as elegant as the other spreadsheets on this list, but it has a great sort/views feature and is definitely very useful.

Once all your debts are entered into The DebtTracker, you can change the view by sorting debts by type (credit card, mortgage, various types of loans), interest rate, minimum payment, and other sort options. The sort option is helpful if you're using a particular debt payoff plan, such as the debt snowball.

There are six worksheets in the DebtTracker, including Paydown worksheets with a graph for tracking the results of paying off debt over time. The worksheets come populated with some data so you can see how they work (type over or erase the data when you do your own plan), and the download page includes a tutorial. You will need to enable macros in Excel to use DebtTracker spreadsheet, which is also explained in the tutorial.

Download It's Your Money DebtTracker

How Much Debt Costs Spreadsheet from Debt Free Adventure

Use the How Much Debt Costs Spreadsheet to see how much interest you're really paying.
Debt Payoff Graph in How Much Debt Costs Spreadsheet
www.DebtFreeAdventure.com
This spreadsheet works best as a Google doc because that version includes a nifty graph depicting monthly progress over one year. Excel and Open Office versions are available for download as well.

There are three easy-to-use worksheets that require little instruction, but the How Much Debt Costs Spreadsheet doesn't do a lot math for you. For example, it can't figure out the dollar amount of interest that is allocated in each loan payment. You will need to know the principle and interest you will pay for each loan for over the course of several months. You can play with making extra payments to see the affect in the Totals sheet or on the graph.

Fill in details for each of your debts in the Data sheet for each month, then you'll see the total principle and interest paid each month and you can use the graph to see when you'll get out of debt. This spreadsheet includes a worksheet called Print which shows a breakdown of monthly and daily interest paid in huge red letters. The idea behind this is to print out that page and put it somewhere where you will see it often, like the refrigerator, to remind you of your goals and progress.

Download How Much Debt Costs Spreadsheet
  1. About.com
  2. Computing
  3. Financial Software
  4. Spreadsheet Templates
  5. Consolidate Debt and Pay It Off with Free Debt Reduction Planning Spreadsheets

©2014 About.com. All rights reserved.