Wicked Cool Debt Reduction Calculator (and it’s free!)

by Rob Berger

in debt

free debt reduction calculator

This week I stumbled upon a really useful (and free) debt reduction calculator. It’s built using Excel, and it can be used with either Excel or Open Office (a free suite of office software). I’ve been using it all week, trying to figure out when we’ll be debt free. I can personally vouch for the fact that it can calculate debt repayments well into the future. Here are a couple of screen shots from the calculator:

debt-reduction-calculator1

In the first section of the calculator shown above, you can enter all of your current debts, including the balance, interest rate, and minimum payment. The “custom” column to the far right allows you to determine in what order you’ll pay down the debt, which comes into play with the next screen shot:

debt-reduction-calculator2

You’ll see a drop-down box with a label of “Strategy.” Here you can select from several debt snowball strategies (e.g., highest interest first, lowest balance first, etc.) or, using the Custom column from the first screen shot, pay off your debt in any order you want.

Plug in how much extra you’ll pay, if any, and the spreadsheet calculates when each debt will be paid and how much total interest you’ll pay. It’s a great tool to war game your debt snowball plan.

This past week has been a great one for personal finance articles around the net. Here are a list of some of the top personal finance carnivals and articles for your reading pleasure:

Carnivals

Articles

Published or updated November 11, 2011.

{ 4 comments… read them below or add one }

Harrison May 19, 2009 at 3:01 am

Thanks for the free tool.

Reply

J. Money May 21, 2009 at 1:37 pm

yeah, good stuff my man. thanks for the shout out :)

Reply

Lisa smith May 12, 2010 at 12:53 am

hey this is a good stuff, very good tool also free. i will love to use this tool and see how it will benefit me.

Reply

Micheline Erbst February 2, 2011 at 4:02 pm

Pretty nice post. I just stumbled upon your blog and wished to say that I’ve truly enjoyed browsing your blog posts. In any case I’ll be subscribing to your feed and I hope you write again very soon!

Reply

Leave a Comment

Previous post:

Next post: