Free debt snowball spreadsheet

Free debt snowball spreadsheet

Vertex42, a site devoted to Microsoft Excel templates, spreadsheets, and calendars, has posted a free debt snowball calculatorthat will help you create a debt snowball spreadsheet. From the description:

This spreadsheet allows you to choose different debt reduction strategies, including the debt snowball effect (paying the lowest balance first) and highest interest first. Just choose the strategy from a dropdown box after you enter your creditor information into the worksheet.

What Do You Get?

This file contains two worksheets:

  1. A debt reduction calculator, which allows you to list your debts, their balances, interest rates, and monthly payments.
  2. A payment schedule telling you which bills to pay when.

The brilliant thing about this spreadsheet — other than the fact it does all the math for you — is that it allows you to choose from a variety of snowball methods. You can use the Dave Ramsey-esque “low balance first” debt snowball, the mathematically superior “high interest first” method, opt for no snowball at all, or — and this is the best part — enter your own payoff order. Got a loan from your brother-in-law that drives you nuts? Prioritize it and this spreadsheet will make sure it's finished first.

I wish I had access to a tool like this when I was first starting to dig out of debt…

More about...Debt, Planning

Become A Money Boss And Join 15,000 Others

Subscribe to the GRS Insider (FREE) and we’ll give you a copy of the Money Boss Manifesto (also FREE)

Yes! Sign up and get your free gift
Become A Money Boss And Join 15,000 Others
guest
28 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
A. Dawn
A. Dawn
12 years ago

Before we did not have these smart tools because Internet was not massively popular and it was not accessible to everyone. By performing a simple search, we can now discover so many smart tools like these.

Solomon
Solomon
12 years ago

I used to have a spreadsheet to track my spending, but it was just so much hassle to track everything in it.

Moneymonk
Moneymonk
12 years ago

There are several tools now that can help. However, you will always have that group of people that say “I don’t have time”

With all these tools, blogs, magazines about personal finance, why are so many people still not taking advantage?

Angie
Angie
12 years ago

I’ve created one similar to this but much more complicated. Took way too much time to make. But it allows me to add in extra payments on just a one month basis. So if I know I’ll get a raise next year, I can change how much I can add on a month by month basis.

The simplicity of this is probably worth it in itself though.

MultifolDream$
MultifolDream$
12 years ago

Although I have no CC debt I like the template a lot. Keep coming with tools like this.

Paying It Down
Paying It Down
12 years ago

The calculator is easy enough to use. However, after plugging in my numbers, the year under the “Month Paid Off” column is off. For example, my credit card that should be paid off in 13 months is shown to be paid off in Oct-08. Perhaps the formula needs to be corrected.

Flexo
Flexo
12 years ago

Great tool, thanks for sharing!

The biggest limitation I see is that it assumes a steady required minimum payment in each account over time. In real life, your minimum payment on a credit card is often a percentage of the balance or some other calculation. But that’s just a minor complaint.

elena
elena
12 years ago

Thanks for the new program tip.

Quicken.com also has a a free online debt reduction planner under the “tools” section. It helped me in the past. I also like Bankrate’s mortgage payment calculator. Printing out amortization tables as variables change has weirdly become a guilty pleasure.

Computer Consulting Kit Home Study Course
Computer Consulting Kit Home Study Course
12 years ago

Thanks for pointing out this simple tool! Invoicing and billing can be some of the most time-consuming tasks for all kinds of business owners and entrepreneurs. And many small business owners in particular and independent contractors, etc. have a hard time finding programs and applications that are affordable and easy to use. Invoicing and related tasks don’t have to be complicated in most cases, and this is a nice little tool for streamlining the process so it’s not so frustrating.

JG
JG
12 years ago

I like the ones this guy built much better:

http://www.geocities.com/schizeckinosy/Snowball.html

Matthew
Matthew
12 years ago

You should sticky this to the new section in the forums for ‘Tips, Tricks, Links, Pointers’ so that it doesn’t get lost in time.

Double
Double
12 years ago

Technology is just great when it makes your life easier and better.

Adam
Adam
12 years ago

Thanks for the tool. I really enjoy GetRichSlowly.org and thought I’d offer a budgeting spreadsheet that I’ve used for years to support the Dave Ramsey approach as outlined in Total Money Makeover. It’s worked well for me and I feel that I should extend a hand by offering the tool to others. I hope someone will find it helpful. I tried to keep it simple and intuitive. You just need Excel and a few minutes to play with it. It’s available in the top posting at my blog below.

Enjoy.

Adam @ http://www.avoidregret.com

Alison Wiley
Alison Wiley
12 years ago

I’m a big fan of spreadsheets in general because they help us to ‘live in reality’, with real-time updates as our money situation keep changing. I do think that our financial profiles improve as we consume less, and I also think our quality of life can be as high as ever (sometimes higher) as we consume less. Here is an example of that principle, centered on using less gasoline: http://www.diamondcutlife.org/how-to-save-money-on-gas/.

bdentzy
bdentzy
12 years ago

Thank you for posting this. I didn’t know there was a spreadsheet template out there to help with the debt snowball.

Tabs at Levnow
Tabs at Levnow
12 years ago

Thanks for the spreadsheet, I downloaded a copy and will be sharing this post with a few people, thanks.

-Tabs

William Bay
William Bay
12 years ago

Funny Timing,
I grabbed this about a week and a half ago after getting acquainted with your site and some of the books you suggest.
I googled around for awhile and found this spreadsheet to be the best as far as cleanliness and ease of use.

My wife and I were able to sit down and see where we would stand in just a matter of minutes.

Glad that you shared this with everybody.

Effortless Abundance
Effortless Abundance
12 years ago

A great example of technology being put to a sensible and ‘useful’ use. Good stuff.

jtimberman
jtimberman
12 years ago

Awesome spreadsheet. Wish I had that when I was helping a friend arrange her debt snowball. I did it mostly manually in excel, and I’m not a spreadsheet ninja.

DGMarsh
DGMarsh
12 years ago

This is my favorite place for a debt snowball:

http://www.whatsthecost.com

You plug in your info and decide if you want to pay the lowest balance or highest interest first. It tells you what to pay to what card and when, and updates how long it will be until you’re debt free. You update it when you make payments or when you spend – and you can personalize that information as well.

Did I mention it’s FREE?

Vertex42
Vertex42
11 years ago

Thanks or the review, J.D.

Thought I should mention that due to multiple requests, the Debt Reduction Calculator now works in OpenOffice. The download contains two .ods files (one for up to 10 creditors and the other for up to 20).

Enjoy,
Jon W.

al
al
11 years ago

amazing! this answered the exact questions i had about paying down 3 different student loans (me, my SO, and my SO’s parent loan). woo!!

Lelo
Lelo
10 years ago

The download link does not work anymore.
Any other link I should try?

Thanks!

renorateupdates
renorateupdates
6 years ago
Reply to  Lelo

Just tried it now and it works

Jason Cabler (@DrCabler)
Jason Cabler (@DrCabler)
7 years ago

Great resource, I haven’t seen that one before. I like to do a written plan for my debt instead of using the computer. Just works better for me.

I made some similar forms that are available on my site and may be of interest for those that like to use pencil and paper.

You can find them in my post about how to make a get out of debt plan.

http://www.cfinancialfreedom.com/CFFwordpress/how-do-you-get-out-of-debt-part-4-the-debt-rocket/

Todd
Todd
7 years ago

Thanks for sharing! this looks like an awesome debt snowball tool.

Tony
Tony
5 years ago

Any idea where I can get a good snowball tool for a MAC?

Heather
Heather
5 years ago

Thanks for the calculator. This doesn’t address the issue of balance transfers which have a 0% (or low) interest for a period of time, which can affect the strategy and total amount of interest paid over time. Is this something that could be addressed in a future revision? I have only found one app that does this –> Debt Manager (Apple only). But I have had some issues with crashing, etc. and have had to redo it several times, so I’m frustrated and looking for an Excel based version that would be more stable.

shares