Excel snowball spreadsheet to download

mizmir

Have noticed occasionally people asking for a snowball calculator in spreadsheet form - and have been looking out for one myself as I like to be able to add in extra payments etc when they happen and play with the numbers etc.

Anyway - I found this spreadsheet today and it seems to be just the thing.
It is US by default but you can change the currency and you can do everything the online version can do - include intro rates, add extra payments etc. It is shareware - free to download with an "honesty" donation of US$5 (via paypal) if you like it and use it. So I am going to trial it for a week or two and see how I get on. If it works well $5 seems very fair.

Thought it might be helpful to others too.

Note: I don't know the author and don't benefit from anyone downloading this!

thriftykatie

I think most MSEers use this one http://www.whatsthecost.co.uk/snowball.aspx

I certainly use it and it is great seeing the debts going down. No charge either.

mizmir

thriftykatie wrote:

I think most MSEers use this one http://www.whatsthecost.co.uk/snowball.aspx

I certainly use it and it is great seeing the debts going down. No charge either.

Yes I use the online calculator too - but it is online so not available when (as mine did last week) your connection goes down for days! I have also found it frustrating that it wouldn't let me reconcile figures until a month had passed from the last time - and that I couldn't play with the monthly available figure to see what happens (without starting another snowball). Might well be possible to do those things on the online calculator and I've just missed it - but I found this useful and thought it might be useful to someone else.
It is also free in that there is no price tag and it is free download - the $5 is a suggested donation if it helps you. I believe that whatsthecost also asks for a donation if you find it useful....

moneyLost_2

mizmir wrote:

I have also found it frustrating that it wouldn't let me reconcile figures until a month had passed from the last time - and that I couldn't play with the monthly available figure to see what happens (without starting another snowball).

Hello,

I'm the guy who wrote the on-line snowball calculator. I just wanted to quickly pop in and say that I've made a few changes to the saved snowballs. It now works in a slightly different manner which means that you can add debits or (ideally!) credits to your saved snowball at any time. I was always aware that the way it used to work, with the ‘reconcile’ option was a little messy and difficult to understand, I’m sure when I first wrote it there was a very good reason for doing it that way, but I can’t for the life of me remember what it was! Anyway, I’ve been meaning to change it for ages, but finally found some time this weekend to do so.

I’ve also changed it to allow the monthly snowball amount to be changed – As well as names and APRs for accounts within a saved snowball. Again, something I’ve been meaning to do for a long time. Each saved snowball will now also give a brief “you will be debt free in X months” description beneath it, so it’s quick and easy to see how much difference changing the monthly payment will make.

The above only effects saved snowballs – The standard snowball calculator works in the same way it always had.

Hope you find it useful.

Regards,
A.

The_Boss

You can easily copy and paste your Snowball (from whatsthecost) into Excel - I have several worksheets set up showing different payment plans and what would happen if I got a new card at a promo rate etc. Its really worth doing if you want to plan things out

mizmir

moneyLost wrote:

Hello,

I'm the guy who wrote the on-line snowball calculator. I just wanted to quickly pop in and say that I've made a few changes to the saved snowballs. It now works in a slightly different manner which means that you can add debits or (ideally!) credits to your saved snowball at any time. I was always aware that the way it used to work, with the ‘reconcile’ option was a little messy and difficult to understand, I’m sure when I first wrote it there was a very good reason for doing it that way, but I can’t for the life of me remember what it was! Anyway, I’ve been meaning to change it for ages, but finally found some time this weekend to do so.

I’ve also changed it to allow the monthly snowball amount to be changed – As well as names and APRs for accounts within a saved snowball. Again, something I’ve been meaning to do for a long time. Each saved snowball will now also give a brief “you will be debt free in X months” description beneath it, so it’s quick and easy to see how much difference changing the monthly payment will make.

The above only effects saved snowballs – The standard snowball calculator works in the same way it always had.

Hope you find it useful.

Regards,
A.

Brilliant - thank you! :T

mizmir

The_Boss wrote:

You can easily copy and paste your Snowball (from whatsthecost) into Excel - I have several worksheets set up showing different payment plans and what would happen if I got a new card at a promo rate etc. Its really worth doing if you want to plan things out

But you have to add your own formulas don't you? I'd be concerned I got them wrong!