Debt Snowball spreadsheets

[radi8]

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

 

Very nice collection of Excel spreadsheets for planning a debt snowball.

 

The "Auto" spreadsheets allow you to type in your balances and interest rates and will automatically calculate which order to pay the debts in.

cc_snowball_35_20.xls

[Jen23514]

thank you

[Kwak]

Thank you. Very useful!

[brazen]

Awesome radi8, great resource!

[Erica]

I'm trying the Snowball spreadsheet that is in the link above, and I can't get any of the macros to work, no matter what I do. It's frustrating.

[radi8]

I'm trying the Snowball spreadsheet that is in the link above, and I can't get any of the macros to work, no matter what I do. It's frustrating.

 

Do you have macros disabled in Excel? If you do the spreadsheets won't work.

[angeleyeskkhr]

I'm trying the Snowball spreadsheet that is in the link above, and I can't get any of the macros to work, no matter what I do. It's frustrating.

 

Do you have macros disabled in Excel? If you do the spreadsheets won't work.

 

 

How do you enable them? I don't think I disabled them but I may have as the spreadsheets don't work for me either. And I'm not longer asked if I want them disabled or not.

[landshark]

Yes I had to disable them to get it to work. Now whenever I open the program it asks to disable them. It works just fine as long as that is disabled. Now that I have figured it out it works great. IF I can help more let me know.

[angeleyeskkhr]

Yes I had to disable them to get it to work. Now whenever I open the program it asks to disable them. It works just fine as long as that is disabled. Now that I have figured it out it works great. IF I can help more let me know.

 

 

Mine does not ask that info... Oh well, I guess I don't need to use it.

[Erica]

Yes I had to disable them to get it to work. Now whenever I open the program it asks to disable them. It works just fine as long as that is disabled. Now that I have figured it out it works great. IF I can help more let me know.

 

 

Mine does not ask that info... Oh well, I guess I don't need to use it.

 

Try the one I posted, it's not an online spreadsheet, and you can save as many as you'd like.

[Uncle Leo]

The instructions for this spreadsheet suck, and it's not naturally intuitive, but once I finally figured it out it was great.

[Forget_the_Odds]

I don't think this works with Excel 07. I get some message about VBA converters.

[minnie aubre]

I don't think this works with Excel 07. I get some message about VBA converters.

 

I got that, too.

[minnie aubre]

I don't think this works with Excel 07. I get some message about VBA converters.

 

I got that, too.

 

I clicked ok for the error messages, and it actually seems to work fine for 2007.

[driggers]

I can't figure out how to add more months. I am by no means an expert at Excel, but I would definately think I know more than the average person. Any tips on how to add additional months/years that way I can tell how long the snowball will take and my current financial situation.

[sunwhipped]

I can't figure out how to add more months. I am by no means an expert at Excel, but I would definately think I know more than the average person. Any tips on how to add additional months/years that way I can tell how long the snowball will take and my current financial situation.

 

 

 

 

 

I just copied it down with formulas and formats. I just today figured out how to get my payments to amortize on each credit card. You just click create rows. After that brought all my credit cards down I felt like such a dope..lol

[sunwhipped]

I can't figure out how to add more months. I am by no means an expert at Excel, but I would definately think I know more than the average person. Any tips on how to add additional months/years that way I can tell how long the snowball will take and my current financial situation.

 

 

 

 

 

I just copied it down with formulas and formats. I just today figured out how to get my payments to amortize on each credit card. You just click create rows. After that brought all my credit cards down I felt like such a dope..lol

 

 

 

 

 

 

 

 

I've been playing with this all afternoon and I finally figured it out!

 

 

 

If you put in the years you want to snowball and click add rows. It adds everything you need. geesh..that was so hard to figure out..lol

[driggers]

Yeah I finally got it all to work myself. I guess I just assumed it would figure out how long it would take to bring the debts to zero.

 

For those of you that can't quite figure it out, if you have more than 2 cards to Snowball then you must highlight one of the cards and paste it into new cells, do this for as many cards as you have.

 

The other thing you must do is change years in plan to at least 5 (depending on how long it will take) and then click Create Rows. If you want to tidy up the spreadsheet after that, you can see where your balance equals zero and count the number of years and months and put that in for years in plan and click Create Rows again.

 

Hope that helps!

 

Great spreadsheet by the way. Just some constructive criticism if there ever happens to be another version.

 

1. Better instructions

2. An option to choose how long you want to be in the Snowball plan then give you what the minimum payment would have to be.

3. Lastly, an option to choose whether you want to pay it by lowest balance or highest interest rate as I know mentally the lowest balance can help a lot. (Although you can rearrange the snowballs in any order you so choose)

[sunwhipped]

Yeah I finally got it all to work myself. I guess I just assumed it would figure out how long it would take to bring the debts to zero.

 

For those of you that can't quite figure it out, if you have more than 2 cards to Snowball then you must highlight one of the cards and paste it into new cells, do this for as many cards as you have.

 

 

 

Actually you don't need to copy anything. You put in the number of years you want to be on the plan, change the month and year you want to start, put in how much you can contriubute, click create rows and it will do it for you.

 

To get it to figure out the number of years for you just put in a large number of years and it will add those number of years but if the debt is paid off earlier the remaining numbers will be zero.

Edited June 14, 2007 by sunwhipped

[stefer1215]

great spreadsheet thanks!

[Acrosteve]

I am just starting to work up my spreadsheet, but I don't have any teaser rates, so my snowball order is pretty straightforward. Is there a way to factor in multiple interest rates on the same card?

 

I have one card that currently has a $6,644 balance. $5,914 is at 1.99 fixed and $795 at 10.52 variable. However, the lower interest rate balance is being paid off 1st. Aren't cc companies great.

[heidiroo]

Ugh, I went through all of the trouble to get all of my thousands of cc's information in there, set it to 5 years and clikc on "create rows" and it gave me a damn error about macros. And being as I have office 2007, I have no idea how to confirm they're turned on . . . grrr!

[JohnP]

Ugh, I went through all of the trouble to get all of my thousands of cc's information in there, set it to 5 years and clikc on "create rows" and it gave me a damn error about macros. And being as I have office 2007, I have no idea how to confirm they're turned on . . . grrr!

 

 

It is crazy hidden. Follow these steps:

File (I still call it file - but the nice big marble in top left) --> Excel Options (Lower right corner)

Trust Center --> Trust Center Settings --> Macro Settings --> Disable All Macros With Notification

 

Now, when you open the document it will prompt you just between the workbook and the Ribbon that Macros are disabled and should give you an option to Enable them.

 

Hope that works for you!

[Dovie1920]

i dont think that i will be able to use this... it looks complicated and intimidating when you look at it.. i am not someone that is very familiar with Excel and such... is there a version for dummies????

[BlackWater]

Hey gang, I've had this for awhile and I figured I'd help my CB friends. I've designed a excel monthly budget spreadsheet that might be able to help you keep track of your bills. It was designed in Excel 2007 but I have saved a copy in Excel 2003, just not sure if it will work with the features I have in it.

 

Some of the features;

1. Allows you to enter all your bills a month

2. Colums for Payee, Amount, Due Date, Payoff, etc.

3. Shows money left over after all bills are paid (comes from entering your monthly gross income)

 

It has helped me, so hopefully it will help some of you all.

 

I'll attach both 2007, and 2003. If anyone is interested let me know.