How The Debt Snowball Really Works (Free Tool Included For YOUR Debt Snowball!)

  • 18
  •  
  • 11
  •  
    29
    Shares

debt snowballWant to get out of debt fast? Then commit to the debt snowball.

You might be thinking, “Oh yeah, yeah, I’ve heard of the debt snowball. It makes sense – you pay off your debts one at a time until they’re gone. I got it.

No, you missed it.

You missed it entirely…

How the Debt Snowball Works

The debt snowball is about more than just paying down your debts one at a time. There are three major elements to the debt snowball:

  1. Your initial lump-sum contribution
  2. Your contribution each month
  3. Laying out your debts – from smallest to largest

And you know what? Interest rates have pretty much nothing to do with the debt snowball. Do you know why? Because paying off debt is 80% emotional and 20% logical. Paying off debt is more about immediate progress than it is about math. All you nerds out there, just trust me and put your calculators away (and for the love of Pete…please throw away that pocket protector!).

Your Initial Lump-Sum Contribution

This is the first major step of the debt snowball. To get the snowball started, it works best to throw as much money at your debts as possible.

After all, you’re committed to getting out of debt right? And you’re going to do it as fast as possible, right? Then take that $5,000 that you have in savings and throw all but $1,000 at your debts. Then, you’ll use the savings from those debt payments (that you no longer have) and pay off your remaining debts in no-time!

If you don’t have any money, you might want to read this post to get started with a bang! – How to Save Up $1,000 in Just 4 Weeks.

Debt Snowball

Your Contributions Each Month

The second key to the debt snowball is your monthly payments. The more you can put toward your debts each month, the faster you’re going to be able to pay them all off.

This can be done via two methods:

  1. Reduce your spending
  2. Increase your income

The best way to save money each month is to lay out all your expenses. Look at them, ask yourself if they’re necessary, and eliminate them if they’re not.

Debt Snowball

If you’re thinking about increasing your income, take a look at my “Make More Money” page. Subscribe to the site if you want the full listing of 101 Ways to Make More Money.

How to Lay Out Your Debts

I suggest that people pay off their debts from smallest to largest and ignore the interest rates entirely.

Sure, that 18% credit card debt might freak you out like crazy. But if you tackle the smaller debts with intensity like I know you want to, you’ll get to it sooner than you think – and then bust it out sooner than you ever thought possible!

Set Up Your Own Debt Snowball!

I’ve never seen a free tool out there that helps you lay out your debt snowball, so I figured, “Why not make one for my readers?” Ha, as it turns out, it’s not as easy as I thought it’d be! But, it’s finally complete and it will help you figure out:

  1. How to set up your debt snowball
  2. The length of time it will take you to get out of debt at your current pace
  3. How to speed up your debt snowball by upping your initial contribution or your monthly payment

So let’s get to it! Let’s set up your plan so you can finally GET OUT OF DEBT!

1) Download the Free Debt Snowball Tool

Just click the link below and download the Excel sheet. Then, we’ll start entering your numbers!

Free Debt Snowball Tool – Click Here to Download – you’ll see the download appear as an Excel file in the lower left of your screen after clicking the link.

The Debt Snowball

2) Enter your one-time contribution

How much money could you muster up to get this debt snowball rolling? The more you can throw at your debts for the start, the quicker you’ll be able to get out of debt.

Enter your one-time contribution in cell H12.

3) Enter your monthly contributions

Now, it’s time to enter the amount you think you can throw at your debts – above and beyond your minimum payments. Can you come up with $200 a month? $400 a month? More?

Enter your monthly contribution amount in cell H11.

 

4) Enter your debts, smallest to largest

Alright peeps. I know it’s painful, but let’s enter those debts of yours into the spreadsheet – from smallest to largest.

In cell C17, enter your smallest debt amount, the minimum payment, and the interest rate. Be sure to rename the debt in the cell block so you keep them all straight.

Continue to move to the right and enter your next debt amount, the minimum payment, and interest rate. List all your debts (up to 6 of them) into the sheet. If you have less than 6 debts, just enter in zero’s for the amounts, payments, and the interest rate.

So what’s the verdict? How long will it take to pay off your debts?

Just scroll down, take a look at the far right column to see how long it will take before all your debts turn to $0.00. In what month will you be debt free? 

5) Figure out how to speed it up!!

Did you enter in all of your numbers and discover that it’s going to take you 8 years to pay off your debts??? Well that just flat out sucks! Let’s figure out how to speed up that debt snowball!

What if you…

  • Sold tons of stuff and made a couple thousand bucks? What would that do to your snowball? Would it take a year off of your debt payoff?? Maybe more??
  • Sold some of that debt? If it’s going to take more than 2 years to pay off that car loan, why not just sell the car??
  • Took on a part-time job that paid an extra $1,000 a month? How much would that speed up the snowball?

The faster your tackle your debt snowball, the more likely it is that you’ll get finally get out of debt!

So put on your working boots, make some money, and get rid of that debt!!


If you enjoyed this article, Get email updates (It’s Free!)


  • 18
  •  
  • 11
  •  
    29
    Shares
  • 18
  •  
  • 11

Battle of the Mind Get Out of Debt Money

Derek

AUTHOR Derek

My name is Derek, and I have my Bachelors Degree in Finance from Grand Valley State University. After graduation, I was not able to find a job that fully utilized my degree, but I still had a passion for Finance! So, I decided to focus my passion in the stock market. I studied Cash Flows, Balance Sheets, and Income Statements, put some money into the market and saw a good return on my investment. As satisfying as this was, I still felt that something was missing. I have a passion for Finance, but I also have a passion for people. If you have a willingness to learn, I will continue to teach.

236 Comments

  1. Nice little spreadsheet. I like the snowball method best of all and once you get it under control you can focus on your housing. Once you have no pymts, you’ll be amazed at how much $$ you actually have at the end of each month.

    • Thanks Whiskey! I hope this will guide a ton of people out of debt in the upcoming year. It really can be tricky to pay off your debts if you don’t have the right tools. But you’re right, once you’re out, it sure become easy to save!!

  2. Great post Derek! Thank you very much for sharing this detailed information..It was very useful for me..

    • Hi Suresh! I’m glad it helped! Hopefully it will help many more!

  3. The sheet is great. It offers your reader a way to see the difference in savings by lining up the debt as they wish. Every decision is a trade-off, and there’s a cost in paying, say 0% credit card or medical debt (as shown on your sample sheet) with those extra payments vs sending that money to the highest rate debt.

    I don’t dispute that killing off a card completely can provide an emotional reward, a boost to one’s feeling of accomplishment, etc. But, I often say “knowledge is power” and one should know the cost of that decision. A few hundred dollars over 4 years? No big deal. Thousands of dollars? Look carefully at the numbers before choosing the method.

    Consider – ‘snowballers’ suggest you pay your 8 student loans, all zero interest, $10,000 each, before paying that $20,000 18% card. Of course, that’s an exaggeration, but one that easily illustrates why it’s important to look at the numbers.
    JoeTaxpayer recently posted..2016 Year End Tax Tips

    • Hi Joe. Glad you liked the free tool!

      I used to be like you – a hard-nosed financial professional that only believed in the numbers and percentages. Today, I understand much more about the emotional side of money. If you make no progress over the course of a year, there’s about a 100% chance of giving up. If, however, you pay off a $2,000 loan and get rid of that payment completely, you’ll be charged up and ready to tackle another!

      I’d still suggest that people pay off their $10,000 zero interest loan before their $20,000 18% interest loan because there’s a greater percent chance of them getting rid of the smaller debt and continuing their debt payoff journey! Pay a couple thousand extra dollars in interest but paying off the debt is better than trying to save the interest and failing at the debt payoff entirely, don’t you think??

  4. Derek, I do not agree with your December 30th reply. If the snowball method costs you “a couple thousand” annually, and you make less than $50K a year, you would have to work 13 months a year to recoup that unnecessary interest.

    The snowball requires nuance. Lets help people work smarter, not harder.

    There are a lot of ways to get a mental boost by paying down debt without just seeing the total number of debts decrease.
    – Use a big “thermometer graph” tally up your debts, fill in the thermometer with the amount, erase the amount each month.
    – Find out “how long would I need to work to pay off this loan inefficiently” See my Work 13 months a year example above. Beating your interest rate is like having a second job, but you get to spend more time with your kids.

    Getting into debt is 80% emotional, 20% false logic. Getting out must be 100% logic. You will feel good doing it as a side benefit.

    • Hi John. I’m a nerd just like you and understand the percentages perfectly. After helping hundreds of people though, there’s no denying that those who pay off a debt early are far more likely to stick with their debt snowball. To help the most people possible, I’m sticking with this method for life.

  5. Hi,

    I have a housing debt of about $600,000 (my biggest debt) and I think perhaps the spreadsheet cannot accomodate such a big loan.

    I was wondering if you have a spreadsheet that can?

    • Hi Ben. This sheet is really just for consumer debts (pretty much everything except the house). The house payoff should happen after the consumer debts are paid for, you stock up a 6 month emergency fund, you start investing 15% of your income, and you sock away some money for your kids’ college fund. Let me know if you have any other questions!

  6. Hi. Why are the formulas in D23 and D24 different than the cells around them? Excel is stating there may be a problem.

  7. Stupid question but is there a way to extend this out to more columns? My student loans, thanks to sallie mae, are broken up into 6 individual loans. Doesn’t really leave any room to include the car, boat and wedding ring. lol. Any help would be great. Thanks.

    • Hi Mike! Not yet, but I’ve had a few requests for it, so I’ll look into it. Would 10 columns be enough?

    • What I did for student loans is to calculate a weighted average as normally your monthly payment is proportioned out to each loan that makes it up. Then you have your total owed, monthly payment, and weighted average interest to place into the spreadsheet.

    • Mike, some of your loans have the same interest rate right, instead of calculating those as an average, you can put them in as individual grouped loans. Like, group the three 6.75% loans, the four 2.87% loans, etc. you can do that to see how long it’ll take to get out of debt. Then as each lower balanced account dies off, you can unroll the next lowest balance student loan out of the grouping.

      • Thanks for helping out Travis! I’m so glad everyone is using this tool!!

    • Hi Mike – Thanks to popular demand, I just extended the number of columns! Check it out!

  8. Hi Derek, great website and what a wonderful snowball tool you have created! I have linked this page to a Facebook Group, and am wondering if you would mind if I add your worksheet to our files? I would never do so without permission and certainly always give credit to the source and link back to the blog or whatever you may require.
    TIA for your consideration!

    • Hi Dani. Thanks for asking! Is there any way you could simply link to the article instead of the tool? That way you’ll catch any updates that make as well (P.S. I just updated the tool and re-uploaded it. The new version is here.).

      • Done! Btw, I did expand the original to 35 columns on request of someone that has lots of student loans. You’re right, it was very tricky!

  9. How can I edit this sheet for more than 6 debts?

    • It’s not easy! I’ll look into adding more column though. What would be better? 10?

  10. I love the spreadsheet but I have2 questions/feedback.

    1. The sheet has “room” for 6 debts, I would love for there to be a way to add more than 6.

    2. As I started playing around with the sheet I put in different amounts in the “monthly extra” figuring the higher the number, the faster you would pay off debt. However the length of time it took for payoff was longer at 175 vs 150. It seemed to work properly at 200 and 225.

    No matter what it is a great tool.

    • Hi Tony!

      1) I’ve had a few other requests to have more than 6 columns for entry. I’ll get started on this and let you know.

      2) Yup – turns out that version one had a bug. The tool has now been updated with a more sophisticated equation. You can download it directly by clicking here.

      Thanks for checking out the tool AND the site!

      • Thank you for your reply. I downloaded the file from the link in your reply, and I downloaded the file from the link you posted in a reply to someone below and i still had the bug in both files when i went from 150 to 175. Not sure if I’m doing something wrong or not.

        • Hi Tony. I haven’t heard of the issue with the 150 and 175 from anyone else. Try this most recent update of mine (it includes more columns as well!). Let me know if that’s still an issue in this new file. Thanks for reading Tony!

  11. Derek,

    I’ve got a spreadsheet of my own I use that calculates interest saved by making extra payments. I’d love to share it with you. Contact me directly.

  12. Good morning!

    Thanks for the great spreadsheet. I can tell it took quite a while to make this and is way above my head. Is there an error in the first column? I put my $3,600 car in there and will be throwing an $1,800 lump sum at it, with an additional $200 per month on top of the $283 payment, but the spreadsheet keeps wanting to have my payment be the extra amount I’m putting toward the debt, $200, not the minimum payment plus the extra, which would be $483.

    • Hi James. I plunked in your data to check out how the tool handles it, and it looks appropriate to me.

      Monthly Extra: $200
      One-Time Start-up: $1,800

      Car Balance: $3,600
      Minimum Payment: $283

      With this, you’re saying that you can make all your minimum payments, plus pay an extra $200 per month toward all of them. On top of this, you have $1,800 to get this snowball rolling in the very beginning (nice job by the way!!).

      So what the calculator is doing is:

      $3,600-$200-$1,800-$283 = $1,317 left on your car payment in Month 1.

      In Month 2 and beyond, you’ll see the $483 payment ($283 + $200) until the car is paid off.

      Hope this helps!!

  13. There are several Android applications in the Google Play Store that also calculate your debt snowball. I’ve not tested any, but a search for “debt snowball calculator” comes up with several highly rated titles. The search even auto-completes.

    • Hey Chris. What’s up? You’re trying to take business away from my site? ๐Ÿ˜‰ I did not perform any search for apps. In my opinion, I’d much rather have an Excel spreadsheet of my own to tinker with instead of some app on my phone or tablet.

  14. Nice spreadsheet, the pay off order is interesting since a lot of my balances are close. It’s currently setup as 1 – 4 – 5 – 6 – 2 – 3. So because the spreadsheet assumes the pay off time frames are in order as entered, when the normal monthly payment completes the balance of 4 without extra help, that payment goes to 5 instead of 2. Odd outcome but the spreadsheet is great regardless!

    • Yup, that can definitely happen sometimes. You’ll find that if you throw more money at your debt each month, it’s more likely that the balances will be paid off in the order of least expensive to most expensive.

      Glad you liked the tool! Share it with your friends. Let’s change the world!! ๐Ÿ™‚

  15. Thank you very much Derek for this “stupid-proof” method!
    I read all the comments above encouraging people to pay off high interest debt first but I totally agree with you, the huge emotional component of seeing a debt (any debt) coming down is what helps sticking to the plan.
    I’d suggest people to put the credit cards away, maybe at the bottom of a lake until you pay them off!!! This has always been my issue: I pay off debt, then I feel like the king of the world and bam here goes the balance up again!

    • Sure Marco! I’m glad that I can provide such a useful tool!

      I’m a big believer in the snowball method (it’s sounds like you are too). The cool thing is, once your debts are paid off and you develop a huge emergency fund and passive income streams, you start thinking to yourself, “Why do I even need credit? I shouldn’t ever have to borrow money again in my life.”

      …this is about the time that you start relating to no one… ๐Ÿ˜‰ But it’s a completely stress-free way to live and I’d recommend it to anyone.

      Pay off those debts everyone! You won’t regret it!

  16. Derek,

    Wit my wife, we’ve been practicing the snowball effect for several years now without having a spreadsheet and I have to thank you for it because I really like to have the “visual” of it … and I have 2 quick tips for those that are in the same debt “boat” out there…

    I know many will disagree, but it has been working for us pretty well so far:
    1ยบ) on my income tax, I choose on my W-4 to have deducted and “additional” $20.00 per check (I get paid twice a month), so that’s an additional $480/year bucks to the IRS… and I know that $ wont grow interest but… when income tax season comes… I know that I’ve “overpaid” on my income taxes… so that will count towards the “credit/refund”. our initial thoughts were: if it is in the bank (checking or savings), it can be spend it and not “used” properly, so out of sight = not wasted.

    and 2ยบ and most important: we have been using the income tax refund $ to pay-off several accounts for the past 6 years, and our biggest achievement was completed last year when one of my wife’s student loans of 50k was GONE because we used the income tax refund to make a lump sum payment and a very low % rate personal loan from our credit union for the remaining balance (13% APR below the sallie mae/Navient student loan)…

    I’m not saying that we are geniuses, but using the snowball effect specially using the income tax refund as lump sum HELPS a whole lot.

    • Hi Juan. I’m not in love with the method of overpaying on your taxes, but if you have trouble saving then it’s certainly an option. What you could do instead though is automate a portion of your direct deposit to go to a particular debt. That way, you save on the interest and the money is ultimately going to the same place without you noticing any different!

  17. Somewhat depressing on how long it’ll take (my newborn will be in college or post grad by then), but it’s a great spreadsheet to use.

    One thing of note: some companies penalize you for paying too much into your debt (case in point: my maximum per month I can put with Wells Fargo for my car is 900, whereas my Chase account will charge a “convenience fee” and drop your maximum if they catch you paying lots off). It’s of course to keep you in debt, so as a side I’d have to edit this to put the extra into savings, then pay it off in a lump sum (which ironically you can do).

    • Haha. Well maybe it’s time to start a side business or temporarily take on a second job!! It’d probably be easier to work your butt off for a year or two than to slowly pay off the debt for the next 20!

  18. Thanks for the help. My wife and I started our snowball exactly a year ago this month. In that time we wiped out a small personal loan, all our credit card debt, and a small student loan. I was using a rudimentary snowball tool I built myself and just transferred it all to your tool because, well, it’s awesome.

    In one year we eliminated almost two years of debt from the plan by finding more money through selling, working extra, or just skipping some life luxuries. Our plan started with 6 years to debt free. We are 1 year in and the plan says 4 years to debt free. If this keeps up, we’ll be debt free in 2 years.

    Good Luck to you all!

    • Great job Tyler!! You’re doing awesome! Keep it up!!

  19. I get that for some people there is an emotional side to debt. I’ve just never liked Dave Ramsey’s debt snowball when applying it to the masses. He appeals to the crowd with no self-control. That’s how they racked up tons of credit card debt in the first place. For those people, extreme measures like going cash only and chipping away at a mountain of debt may be best.

    But for others who can show some self-control and have some financial sense, his methods can be counterproductive. In Joe Taxpayers above example, while our guy or gal is paying off those zero interest loans, that $20,000 credit card bill at 18% is compounding like crazy. Talk about disheartening when you realize the money you’ve thrown away and your debt balance growing like crazy.

    If the dollar difference isn’t that much, then sure, throw yourself a cookie and pay off a small debt if it makes you feel better. But I don’t agree with just paying off the small debts first with complete disregard for the interest rates and the money it might be costing you.
    Go Finance Yourself! recently posted..2016 Review: Where I Invest My Money

    • Hi GFY. This sounds a lot like the debate between paying off your house vs. paying the minimum 30 year mortgage and investing the remaining money in the stock market. Sure, the math might say that it would be wiser to experience the 8% gains in the stock market, but there are two other factors at play that nearly everyone ignores:

      1) Risk – the market won’t always return 8% each year. It might never gain another dollar for as long as we live. Heck, it might even go DOWN in value.

      2) Emotions/Energy/Drive – How many people are so driven to pay off their debts that they live on less and work to earn far more than they ever imagined, which means that they pay off their debts in record time?! Many. How many people are as driven when they invest money into the stock market? Very few.

      We can’t look only at math in these scenarios. People need to be driven, they need to see progress, and they need to feel successful even before the final payoff.

  20. Derek,

    I entered 4 debts in the sheet, smallest to largest. I put 0’s in for the last 2 available slots. The 6th debt column is populating – and the plan appears to have a shorter full-debt payoff time than the 4th column (where I would expect to see the true anticipated payoff month). How should I read that?

    • Hi Brad! Ignore the 6th column – that was a minor formula glitch. I have corrected the file in the post – if you want to re-download, simply click here.

      Your question about the last debt paying off faster – that happens sometimes when the minimum payment is fairly large or if you’re really close to the end of the payment terms. That’s okay. It doesn’t change anything. Your debt snowball is done when all of the rows read zero, and the you’re debt free!!

  21. A key point: It DOES Pay to put your higher interest loans earlier. In the example spreadsheet, swap columns 2 & 3 and save over $201!

    • But how much longer will it take to pay off that higher dollar debt?? 8 months?? Twice the amount of people will probably quit before they reach it. That’s the point Robert. Emotions over math on this one. I’d rather stay energized and actually pay off all my debt than save $200 and likely stay in debt forever.

      • I have to disagree, speaking from several years of experience. Once you have the plan set, it’s very energizing to see the balances decline.
        Another key is to put the loans with the largest monthly minimums first, as they give you the biggest snowball effect.

  22. Downloaded Automated_Debt_Snowball_Calculator2.xlsx, I think you still have a bug.

    I’m not seeing the extra debts showing the strange negative balance anymore, but once the balance of the 1st debt is gone in columns, the 1st debt payment + extra doesn’t move to the second debt, and so on to the 3rd/4th, etc. Any ideas on this?

    • As a follow up, this appears to be happening with the following:

      No One-Time Start-up
      Extra Debt Payments of $200 or less

      It does work with a One-Time Start-up of $1 and extra debt payment of $199

      • Now THAT was a weird bug! Because of one hundredth of a cent!! Fixed. Try the new file here. If you find another bug, keep it to yourself. ๐Ÿ˜‰ HA! Just kidding. Let me know! We want to make this tool the absolute best we can so that thousands of people can be helped! Thanks Jared!

        • How did you end up fixing it? I just spent some time and used roundup to get things fixed up.

          Let me know if you want my version of the fix.

          • I debated on roundups, but I just changed the <=0 function to <=0.00001. Thanks again for finding the bug!

  23. This is really interesting! I was working on trying to figure out this very thing last year and I didn’t know that there was a real name and method! I admit to being pretty poor at managing finances beyond setting up autopayments to guarantee that things are being paid on time. I think it’s great to see just how much a chunk up front and little extra each month affect the overall time it takes to pay down.

    I was wondering if there was a way to add a step 2 column. While I currently direct deposit a portion of my check directly to savings, part of my plan is that as we pay off debt, I want to increase the amount deposited into savings. Is there way to add a column that would add up? I would like to see how, once the debts are paid off, if I shift that payment total to be an additional monthly deposit into a savings account. My wife and I are thinking of setting a goal of 3-5 years to have our existing debts paid off and looking to move. Would be great to get an idea of what kind of savings we would have after 5-6 years without any additional cash input.

    • Hi Thom! Thanks for the comment and the idea. I think you’re reading my mind. One of my future posts was going to be the debt snowball in reverse. In other words, once you’re out of debt, how quickly could your savings and investments grow. I haven’t started it yet, but be on the lookout for this post in the upcoming weeks!

      • Hi Derek!

        It’s been a bit over 6 months of using this and with some adjustments, we’re on track to pay off the credit cards, my car, and my student loans in 36 months! Hit a few snags that dropped our savings, and raised our credit card a bit (two computer rebuilds, and an inspection requiring all brakes/tires will do that…) but since we were already in the mindset it wasn’t as hard a hit as it could have been. (Though it’s pretty disheartening to see all that money disappear in less than a couple weeks time.)

        One question that I recently thought of was that for my student loans. There are 8-9 smaller loans in the Account, each with it’s own interest rate that average out to 6.04%. It’s the largest of my loans so it’ll have our full repayment focus. Question is, I believe that Great Lakes requires me to call and “manually” apply payments to principal balance. Once I get to that point, is there any merit to targeting individual loans in the account? They all have about the same amount in them, and the rates vary around 1-1.5% from the lowest to highest.

        I’ve checked back occasionally and haven’t seen it, have you posted the “Reverse Snowball” calculator? I know we’re not there yet, but looking at what’s ahead is a powerful motivator!

        • I’m so happy that this tool is helping you tackle your debts! YES! Great job Thom! You’re killing it!

          As for the set up, just continue to list all your debts smallest to largest (even all those small student loans). Yes, you’ll have to call some of them to apply your payment to the principle, but by listing these out individually you’ll still feel like you’re motoring through your debt as you knock them out month after month. Oh man, I can’t wait to hear from you again with your results, keep it up!

          I haven’t officially made a “Reverse Snowball” calculator, but I did make a rental property wealth calculator (https://lifeandmyfinances.com/2017/01/rental-property-wealth-calculator/) which shows how quickly your real estate empire could grow with cash purchases.

          I’ll brainstorm on the reverse snowball. It could be the next awesome new tool.

          By the way, be sure to check out all my other tools on our Free Tools page (https://lifeandmyfinances.com/freebie-tools/). Thanks for reading Thom!

  24. I think this is a great tool and visually makes paying everything off look so much more achievable, let alone actually doing it! Quick question – two of the four credit cards I’m working at paying off are 0% interest (one that ends in February 2018 and the other that ends in June 2018). Would it still make sense to pay those off first? If we’re talking about the debts in terms of smallest to largest the two 0% cards are 1 and 3 respectively. Depending on how much I get back from my taxes and what I currently have in savings I may be able to wipe out most, if not all, of that fourth card, the largest debt. Or I’d also be able to completely wipe out the first two cards and start working on cards 3 (the other 0% interest card) and 4. I just feel like it makes more sense to throw everything at cards 2 and 4 first since they are interest bearing, but I could be wrong! Appreciate any insights!

    • Hi Alex! Great question!

      I’m a fan of the debt snowball through and through, which means line them up from smallest to largest regardless of the interest percentages. By paying off 2-3 cards in a short amount of time, your mind will tell you how awesome you’re doing and you’ll then quickly pay off the 4th.

      When we pay off debt based on the level of interest, this can sometimes set us up with a huge debt as our first to pay off, and it may take a year or more to do it! This, obviously, it’s very emotionally stimulating, so many people quit before they even pay off one debt.

      In your instance, I also suspect that those 0% interest cards are actually deferred interest. Once February 2018 and June 2018 roll around and you still have a balance on those cards, you might get slammed with all the interest that was accruing since the beginning. For this reason too, I’d say just pay them off smallest to largest as fast as you possibly can.

      Best of luck to you Alex!

  25. Hi Derek,

    Well-made spreadsheet; I just share it in my (very newish) newsletter.

    As a numbers guy (as you are from what I can see), I’m not a fan of the Snowball Method, but I’ve seen first-hand how it can motivate many people to tackle a mountain of debt.

    I’d say, however, if someone has a 18% interest rate credit card with say a $10k balance, they should at the very least try to park it, so to speak, in a LOC or in a lower interest rate CC while dealing with their lower balance, lower interest debt.

    • Hey Chuck. Thanks for sharing! Sure, I wouldn’t mind if someone found themselves a better rate on the 18% credit card, but the point is not to refinance and save a few hundred bucks. It’s to get rid of your debt, and get rid of your debt now.

  26. downloaded the excel file from your website but can’t “enable editing”. how can i make it work? thanks and can’t wait to start using it.

    • Hi Sharon. There shouldn’t be any trick to it. Just click “Enable Editing” and put in your numbers! If that still doesn’t work, maybe you don’t have Excel enabled on your computer. If that’s the case, go to Google sheets and upload the sheet there. It’s a great Excel alternative. Let me know if you have any other issues!

  27. thanks again. i do have excel on my computer. will try the google sheets.

  28. Hi Derek –

    First, thanx for this great tool. I have tried to build one like this, but not tech savvy enough to make it practical. This is exactly what I’ve been looking for. Have shared it with my six adult kids who are using it as well. That said, a question for you – – I’ve tried to play around with numbers for Cell H12 to see how much a larger starting sum would pay down the total debt, and I’m thinking that cell is not working. I can put “0” or “5000” and it makes no changes in the month to month charting in the graph. Am I misunderstanding it’s intended use?

    Thanx much –
    Shane

    • Hi Shane. It definitely works for me! What are your numbers? Let me put them in the tool so I can take a look!

  29. Thanx for the reply, Derek. My numbers are 900, 1800, 2300 and 8100. As I mentioned, inputting different numbers in H12 does not alter the graph below.

    Thanx for any input…
    Shane

    • Hi Shane. Works totally fine for me! With a monthly payment of $400 a month, a $0 one-time startup takes 21 months. A $5,000 start-up will shorten your debt payoff to 13 months.

      When inputting your numbers, be sure to “Enable Editing” in Excel. Or if Excel simply doesn’t work for you, you can always upload this doc into Google Sheets! I know it works there too.

  30. HEY!! THANK YOU FOR THIS TOOL I HAVE ALWAYS FROWNED WHEN SOMEONE TELLS ME TO START WITH THE HIGHER INTEREST CARDS. THIS MAKES ME FEEL WAY BETTER. I ENTERED ALL MY INFORMATION BUT I AM NOT SEEING THE NUMBER TO TELL ME HOW LONG IT WILL TAKE FOR ME TO PAY OFF ALL MY DEBT. WHAT CELL OR AREA SHOULD I BE LOOKING AROUND OR IS MY INFORMATION NOT ENTERED CORRECTLY. THANK YOU FOR YOUR TIME.

    • Hi Jasmine! Way to take the first step toward knocking out your debt. I’m so excited for you!

      With this tool, you simply look at the last column of debt that you have, search down the page for the last payoff row, and then look to the left to see how many months it takes you to pay off the debt. If it takes 24 months, that means you’ll be debt free in two years!

  31. Oh… ok so I got 19 months.

    • So you’ll be debt free in 1 year and 7 months! Not too bad!

  32. I took a look at your spreadsheet and I think you had a few things mixed up. You were adding monthly interest after making the monthly payment in every period except the first one (which had no interest charged?). As far as a “look how quickly you can pay off debt” tool I’m not sure it matters much. But it’s less accurate as monthly interest has to be paid off first before principal is usually applied. The copy I had seemed to have a few cells where the formulas were off, I think other commentors have already pointed that out and maybe been fixed in the live version of the sheet.

    The other thing is you have a 1 time payment at the outset. To really make the sheet useful it’s nice to be able to project one time payments on some reoccurring schedule (a yearly bonus maybe). I modified a sheet I use to achieve the same “snowball” affect but with more flexibility to change whether or not you apply the extra payments to the smallest balance, or if you want to skip certain debts (for example those with 0% interest).

    I also included an interest only HELOC (the difference being the minimum payment is set to a formula that is equal to monthly interest–typically how home equity lines work).

    Hopefully I got all the settings right on google for this to be shareable:

    https://docs.google.com/spreadsheets/d/1vskYaDusXYZ0WW693CvuzSjwywPGJRZlyVSKxLcQld4/edit?usp=sharing

    • Hi Matt. Month one was basically the “current month”. I wasn’t too worried about the interest here because it’s applied at the end of the month. Like you said though, it really don’t matter much in the grand scheme of everything.

      The multiple “one-time” payment is a cool one – nice suggestion! Maybe I’ll have to add that feature to mine at some point.

      I didn’t quite follow your spreadsheet with my 2-minute glance, but I’m definitely leaving the link there if it can help someone else. Thanks for sharing!

      -Derek

    • Matt – has your spreadsheet worked like you had hoped? If so, can we get a copy? I notice that it’s not downloadable. Is that possible?

  33. First of all, thanks for this tool, you’ve done an awesome job with this and it is very well put together and very useful. Just have two small tweaks that I made to my own personal version of this tool and thought I would share. Do with this as you please…

    Don’t know if this has been addressed, as there are a lot of comments above this, but I browsed through quickly and didn’t see it.

    For your balance calculations, I was confused with how you were handling the calculation of the interest portion of your payments. For example, in cell C22, you are taking the balance in cell C17 and subtracting the payment in B22 (after checking to make sure the balance is greater than 0), however that doesn’t take into account the interest that would be charged on that outstanding balance (it’s doubtful you are making that lump sum payment on the same day you took out the loan, right?). Instead, I am making the assumption that you are making this payment after a month’s worth of interest has accrued.

    So, in my spreadsheet I changed the formula in C22 to the following:

    =IF(C17-B22<0,0,(C17-(B22-(C17*(C19/12)))))

    Next, when you get down to cell C23 (the balance after the next payment is made), you are taking the balance, subtracting the full payment amount, and then calculating interest. Instead, I think you should calculate the interest on the outstanding balance, then subtract that from the payment, leaving just the principal portion of the payment to be subtracted from the outstanding balance. This is how I set it up.

    Instead of this (your calculation):
    =IF((C22-B23)<=0.0001,0,(C22-B23)*(1+(C$19/12)))

    I did this instead:
    =IF((C22-B23)<=0.0001,0,C22-(B23-(C22*(C$19/12))))

    I know, it seems minor, but when I made these two slight changes to all of my debts it changed my overall debt repayment by nearly ten thousand dollars. I am using this tool to not only forecast my own debt repayments, but to also forecast some rental property purchases in the near future, so these changes might not make as big of a difference to some users with smaller debts.

    Anyway, thanks again for the tool. Hope my comments are helpful.
    -Mike

    • Hey Mike. Great updates. Thanks for sharing!

  34. This spreadsheet is amazing! I really am impressed and thankful for the ton of time and effort you put into it and the fact that you provide it for free! You the man!

    For all the people that are complaining in which order they should pay their debts off, if you really prefer to pay off debts with higher percentage rates first, then just place them in the spreadsheet in that order. Derek’s recommendation to put them in the order of smallest to lowest, so that people keep motivated, is just a recommendation and the spreadsheet just computes them in the order they’re added anyways.

    • It did take quite a bit of time (don’t look at they formulas…they’ll make your head spin a little), but I’m glad I did it so that people like you can benefit from it. Good luck paying off your debts Chris! Let me know when they’re gone so I can give you a shout-out! Wooot! ๐Ÿ˜‰

  35. Thanks for your tool. It is so much better than the other spreadsheets around. We pay off our house this month — and it looks like all our other will be paid off in a year!

    There’s light at the end of the tunnel!!

    • I love how many people are benefiting from this tool! Congrats on nearing complete debt freedom!! Woot woot!!

  36. I like the spreadsheet;however iam in serious debt i need to add a total of 25 bills ouch! is there a way to copy an paste the columns

    • Hi Jeff – I’m sorry, but it’s not as easy as a copy paste. You’ve got to get rid of this debt dude!! And fast! Start by saving up your $1,000 mini-emergency fund and then take on extra jobs or extra hours – whatever it takes to start getting this debt under control!

      If you need help, feel free to email me Jeff (Contact tab at the top of this page). Let’s get you out of this mess!!

  37. Thank you Derek, I had somewhat an idea of this but I did not know there was a name for it until now. I am desperately trying to get out of debt and your spreadsheet will help do just that!..Thank you!

    • I’m glad to hear that, Sue! If you ever have more questions, feel free to reach out to me via the “Contact” tab at the top of this page. Best of luck to you and getting out of debt!

  38. Derek, Hate to bother you again. Your Snowball Spreadsheet is really excellent. I am wondering if you have thought about the fact that if we put $100.00 extra for the first month and the second month maybe we can put $150.00 and the third month maybe $250.00, have you included that into your spreadsheet? Second question – since my wife and I are trying to increase our credit score and we should not close out or leave a credit card at a $0.00 balance, is there a way to leave say $5.00 on the credit card and let it sit there for months while working on the other debts? If you need clarification, please feel free to let me know how I can make these questions more clearer.

    Thank you,
    JC Willette

    • Hi JC. That’s a pretty good idea, and it is doable. The only problem is that it would become too complex a tool for the masses.

      For your second question. Stop worrying about having an impressive credit score. I have one credit card, use it occasionally (when I make big purchases), and I have no other debts. My credit score is 800. AND, there’s no reason for me to even have a credit score because I don’t ever plan to have debt again in my life!

  39. Hi Derek,

    Thank you for this great spreadsheet. It certainly makes it less overwhelming for me. Not sure if you’ve mentioned this but when I enter the data in the first column it changes the data in the second column and not the first one. Is that correct?

    • It could definitely happen, especially if your first debt is super small and paid off quickly. Then your money will flow into the second column. If you want me to take a look, feel free to email your spreadsheet to me at derek (at) lifeandmyfinances [dot] com. Thanks for reading!

      • Hi Derek,

        Ok, that makes sense. Yes it is super small – Thanks!

  40. Love the spreadsheet!! If I decide to pay more on some debts in the following months, should I just enter the actual amount paid in the payment fields? For example, Debt 4 I had actually overpaid and it’s not due for another 3 months and I will use those extra funds on debt 2 for the next 3 months.

    • Glad you like it LDub! It sounds like instead of applying your extra payments to the principle, you’re just pre-paying your debt (which is why you don’t owe on it for another 3 months). This won’t save you any money on interest though and you won’t pay off the debt any faster. Always be sure your payment goes toward the principle.

      As for that debt though, just put it 4th in line like you would normally. The calculator will have you put the minimum payment toward it until the first 3 debts are paid for, so while it won’t be perfectly accurate, it’s probably going to be within $50, so not a big deal that it’s not exactly right. Once it’s done and paid for, you can reset your debt snowball to include only debt #5 and beyond (that is, if you care about exact accuracy). ๐Ÿ˜‰

      Make sense??

      Thanks for reading!

  41. How does minimum payment work?
    Where do the balance adds up to?
    sorry, I don’t quite get it.
    I have about 6 loans amounting to almost 40k.

    For example, I have a loan, i’m repaying $200 each month, minimum is $53. How do i read the excel

    • Hi Malik – no worries, I’ll walk you through it.

      Start at the top. Enter how much you think you can put towards your debt each month, and then enter (on the second line) any money you might have stashed away that you can throw at the debt (keep $1,000 in the bank for emergencies).

      The columns below are all for your debts. The minimum payment is the absolute lowest amount you’re allowed to put toward each debt without being penalized. On a credit card, this is usually less than $100.

      The balances don’t add up to a total (you could do that math on your own if you want). The point of the snowball is to see your debts snowball themselves away! If you enter in all your debts and scroll to the bottom, you can see how many months it will take you to pay them all off. TONS of people are using this tool and LOVE it. They’re getting themselves out of debt because they can finally SEE the debt snowball plan.

      If you have $40k in debt and are paying $200 per month, you’re going to be in debt for like….20 YEARS. You’ve got to up your game, sir. You need to reduce your expenses and increase your income. Heck, an extra $1,000 a month could be HUGE for you! Instead of paying on your debts for 20 years, you could be out in less than 4. And quite honestly, I bet you could figure out a way to pay it off in two…if you got intense about it.

      Best of luck to you, Malik!

      • Hi Derek,
        Thank you for getting back, sorry I didn’t make myself clear. 6 loans $200 each. So monthly, i’m throwing in $1200 just for these loans. Yeah, with the calculator, I figured it would be at least 4 years to clear ’em. Currently, figuring out how I can cut 4 into 2.

        Much appreciated Derek. You are amazing. ๐Ÿ™‚

        • Ha, thanks for the kudos!! Let me know if you need any more help!

  42. Tried the free tool and it didn’t work correctly. I put them in order from smallest to largest, included the payments and the interest rates. I have a loan that will be paid off if 5 months, but instead of rolling off the payment into the debts prior to it, it applied the payment only to the debts after it. It’s one of my biggest debts, but we we agreed to pay it off in three years so it’s a large payment and the debt is almost gone. It would make a huge difference if the calculator worked like it should (once paid off the one large payment would have paid off three of the smaller debts allowing us to roll over the big amount with three smaller payments to the next debt). Anyway, thought I’d share our experience, the idea is nice, but the application didn’t work on an out of order payoff.

    • Hi Maria. I’m sorry the tool didn’t work for you! Send it my way and I’ll do my best to find the bug! Send it to derek [at] lifeandmyfinances DOT com. Thanks for reading!!

  43. Thank you for your spreadsheet. I am running into an issue. My payment for the last payment for my debt #3 is actually more than the amount that i can pay. It’s saying that I can pay the full remainder off, however I still have a balance remaining for debt #1 and debt #2. I totally all of my payments for month 2 and beyond. They are all a total of the minimum payments + the extra amount except this row where the payment to debt #3 = the remainder amount for debt #3. Can I email you a screenshot?

    • Hi Tawn. Based on your string of emails. It sounds like you solved your issue by listing your debts smallest to largest. Congrats on tackling your debt. Can’t wait to hear stories of you killin’ it!!

  44. I love love love love this tool! I’ve been looking for something like this for months. I used to use one that I could add my income, house expenses, etc. I’m not sure how I missed this. But, I am having a glitch Mr. Derek. One of my accounts adds more debt instead of using the snowball effect from paying previous accounts. Did I do something wrong? Can I fix this? If so, How?

    Any help would be greatly appreciate it!!! Thank you Sir Derek! You’re the man!

    Single Mom Budget

    • Hi Angela – send your file my way and I’ll have a look at it. I’m glad you’re loving the tool! Send it to: derek (at) lifeandmyfinances [dot] comm.

  45. This tool is awesome, although after entering my data, I noticed that in my second month there is an additional $360 (j23) being shown that I should pay. Can you help me with this?

    • Hey Marcus, sure! Send me the file and I’ll have a look (derek at lifeandmyfinances [dot] com. I’m thinking that, based on the amount extra you said you could pay each month, the calculator is showing where your dollars are going to, which actually pays off your first loan. Congrats! Sounds like you’ve got an awesome start!

    • Hi Marcus! Thanks for sending the spreadsheet my way to look at. Looks like you got ahold of an old spreadsheet somehow, and like some others, you were paying off your debts so fast you were breaking the calculator!! Nice work! I just sent the updated file your way with all of your numbers. Looks like you could have everything paid off in just 18 months. YES!!!

  46. Derek,
    It worked. Through tedious attention to spending, snowball application (some mild tweaks as we got better at managing our money), and some strategic downsizing my wife and I became debt free this month. A four year plan ended up taking just under two. We wanted it badly, and we got it. Thanks for your help building a tool that helped us build a strategy that worked. We will never allow the hooks of debt back into our lives.
    Thanks!
    -Tyler

    • YES!!! That’s AWESOME!! Congrats Tyler. You’ll never regret it!

      About 3 months from now you’ll look at your bank account and say, “Whoa”, that money built up fast. And your ultra-wealthy future will begin.

      Congrats again. So exciting!

  47. What if I am using this spreadsheet and a few months into it, I have an extra lump sum to apply. Where would I enter that without messing up any of the formulas?

    • Hi Denise. First of all, great job tackling your debts!! With a lump sum, the best way would be to just re-input your information after you apply your lump-sum. In other words, if you have now paid off 3 of your debts, remove them from the sheet and start it as if you just found the spreadsheet today. It’s not perfect, but it’ll still keep you on track!

  48. Thank you or the awesome free tool!
    Just had one question (Didn’t see it addressed in the comments) How do I set a limit for the total monthly amount of payments I can make. Between my husband and I we make x amount per month and the tool is saying to make total payments over that amount. I set the lump sum to 0 and the extra amount to 0 and it still goes higher than what we make per month for some of the months in the middle of our timeline. Thanks again!

    • Hi Denise. Glad you like the tool!

      If I’m reading your question right, you’re saying that at times your monthly debt payment are more than your income? Is that right?

  49. Yes. I want to set a limit for the total amount of monthly payments I make for all accounts. So if I have a total budget of $5000 per month for all my monthly payments where can I set that total amount limit?

    • Hi Denise. This model was set up for those that want to aggressively pay down their debts, not for those that don’t wish to make the minimum payments (ie. I don’t think your request is possible). It sounds to me like you need more income to tackle your debts! Time for a second job? There’s tons of opportunity out there to make more money!

  50. Derek
    I do make my minimum payments and have enough to pay all. I never said I could not make my payments. When I input the information it pays off each account with payments much bigger than the minimum payment. For example on one Acct the balance is 20,000 the minimum payment is 600. You spreadsheet shows I can pay off in x amount of months. Some of those months the payment is $2000 in order to pay off faster. I want to set a limit to where that minimum 600 mo payment will only go up to say 1000 not 2000 per month. Do that with 6 or 7 accounts and the total monthly payments go up to over 10k per month. Is there a way to either set a limit or increase the length of time to pay everything off?

    • Hi Denise. How about you send me your file so I can take a look? derek (at) lifeandmyfinances [dot] com. All numbers are confidential of course. ๐Ÿ™‚

    • Thanks for sending the file, Denise! Glad I could get you squared away. Thanks for being a reader!

  51. Hello Derek. I recently came across your spreadsheet and it is wonderful. I know you expanded it to ten debts, but I was wondering if you could go to 15? It sounds a bit extreme, but I need more columns.

    • Hi Karen,

      First of all, thanks for reading! Glad you found us!

      Currently the debt snowball allows 16 entries and it gets pretty difficult to add more. It’s possible, but to be honest, I just won’t be able to find the time now (kiddo, project house, this website, regular job..I’m barely sleeping as it is!! ๐Ÿ˜‰ ).

      Here’s what you can do though. To get an initial idea of how long it will take you to pay off all your debts, just combine some of the like-debts into one of the cells so you can get your full debt into the debt snowball.

      Then, once you get started and eliminate some of those little debts, you can re-input your numbers (without the little debts that are now gone) and start fitting into this Debt Snowball. It’s not perfect, I know, but it should work!

      Thanks again for being awesome. And good luck on your debts in 2018!!

  52. Derek, what is your latest updated Debt Snowball file version? I can only find the 1.8 version. If there is a more updated version, could you please update it on your website download? Thanks.

    JC Willette

    • 1.8 is the most updated version, so you’ve got it! Let me know if you have any questions!

  53. Hi. I was wondering if once you pay off a debt, this sheet automatically uses that debt’s payment amount and adds it to the next payment? In other words, I have $200 for extra payments each month but I’m not sure if I have to manually add the amount I used to pay on a previous card (once the debts has been paid off) to this $200 or if the formulas include them when they give me a new payment amount. I hope this makes sense. Thanks!

  54. Hi! Sorry, disregard my previous question as I’m pretty sure it does BUT In my 2nd account, I inputted the balance of $114.27 (E17) but the payment amount the shhet is telling me in cell D22 is $164.48. can you fix this and help update the spreadsheet?

    • Hey Liliana. Seems strange – nothing I’ve seen before, but I’ll check it out! Send it to my email! derek (at) lifeandmyfinances [com].

  55. Thank you so much for your spreadsheet! It is much better than the one I had originally created (no special formulas or interest taken into account!). I want to add 2 more columns but it does not seem to be working. Do you have any suggestions? It seems to lose the formula, or it gives me a warning/notice

  56. Please disregard my previous comment. I see that you have answered this question already. Thank you!

    • Sure, Kate. Glad you found the spreadsheet!

  57. Love this tool! I get two bonuses during the year, and I figured out that if you input the extra payment into the a appropriate column for the appropriate month, the sheet does pick it up and adjusts the snowball accordingly. To back it out, I simply replicate the formula from the previous cell and voila! Looks like an “undocumented feature” so I thought folks would like to know! It saved me the trouble of having to start over when a lump sum becomes available

    • Glad you love it, Michael, and great tip! I’ll have to tell that to future users that ask about it. ๐Ÿ™‚

    • Mike, where/how do you enter this information? This might help the issues I’m experiencing.

      Thanks.

  58. I LOVE this Debt Snowball spreadsheet tool!! I am such a visual person and numbers nerd! I plugged in my lowest debt(Credit Card) to mortgage(highest) and one column before the mortgage I put in the 3-6 month emergency fund with no minimum payment and 0% interest(that allows nothing to be paid on it until the debts are paid off) so I can see how long that will take to save! I love playing with the numbers to see just how long it will take if I make extra money to put on debts!

    Thank you for this great tool. This tool and your entire Website have really been a blessing, Thank you.

    • Awesome! Spread the word, Kathy. Let’s help as many people achieve their financial dreams as possible!!

  59. This is fantastic. But, I’m having some issues with the calculations.

    This month, for example, I want to pay off a debt that, on the spreadsheet, shows to have a couple more payments. I’m not finding that easy to do without messing up the subsequent columns. Even if I change the minimum payment of the debt to the amount I want to pay off, the calculations aren’t right.

    If I change the “Monthly Extra” amount, it will actually make the balance of a subsequent column go up substantially and show that I have a negative payment amount due.

    Somthing’s just not right, and I’m not Excel smart enough to figure it out. I was hoping this was the end-all-be-all for debt snowball spreadsheet.

    Can you help? I’m happy to email you my spreadsheet so that you can see what I mean. I know it’s hard to interpret based on what I’m telling you here.

    Thanks.

    • Hey Brian – sure, send it my way. I’ll take a look. derek (at) lifeandmyfinances [dot] com.

      • Hi Derek – Love the spreadsheet – Did you figure out this issue with the negative payment due? just downloaded your spreadsheet and when I plug in my numbers, I see the same thing. Thanks!

        • Should be fixed! Send the report my way. Let me take a look. derek (at) lifeandmyfinances [dot ] com.

  60. Hi,

    Absolutely love this tool. Is there a version with more columns for debt? I need 20.

    Thanks

    • Awesome! Glad you love it! Unfortunately I’m just crazy busy lately (full time job, website, project house, and wife and kiddo…) so I probably won’t get to it soon. I’ll keep the 20 column suggestion in mind though.

      If your smallest 4 debts are super tiny, you could just push to pay them off, and then load your remaining 16 debts in the tool. Just a thought!

      Thanks for being a reader! — Derek

      • Might as well go for 25 hehe… I copy pasted and got my frankensteined version of the spreadsheet to work, but there are weird issues with amounts not adding up etc.

  61. I love this spreadsheet and that it is FREE… I hate when you are at a site to help you clean up your debt and they want $99 to get started…

    Question… if I have an extra $100 some month to add to this can I just add it in and it will recalculate???

    • Glad you love it! You’re welcome!

      Yeah, you can just go to the cell that you want to add to and put “+$XXX.XX” at the end. Unless it’s an obscene amount, the calculator should still hold.

      Good luck getting out of debt!!!

  62. Great… Thank you for the quick response

  63. If I have a car loan and I split that payment into equal parts, how do I enter that into the spreadsheet?

  64. Spreadsheet is an excellent idea to show you at a glance of how you’re attacking debts make a difference. THANK YOU for doing this! When you can see it, you get that extra motivation to keep attacking. We feel fortunate. We both have just retired, and we’re down to only two debts, the new(ish) car and the house. Obviously, we don’t subscribe to everything Ramsey suggests, but we have a good, solid income and owe less than $44K on everything. With a small upfront and only $300 extra per month doing the snowball, we’ll be totally debt free in less than 2.5 years, without breaking a sweat.

    • Nice! Glad you like the spreadsheet, Jack!!

  65. Derek,
    I get paid every 2 weeks and so twice a year I get paid 3 times in a month. I would like to put my 3rd paycheck towards my debt but don’t know how to put it in the calculator. Can I just add a lump sum to one of the cells? I want to be able to add that 3rd paycheck in say June and November.

    • Hi Michael. Yeah, you should be able to just add it to the end of the formula in one of the cells. I’ve done it a couple of times and everything seems to hold. Either that or you could just average it out into your extra payment amount. The end results (# of months before payoff) should be pretty close.

      • It only works when the amount you put in the cell is less than the amount you own in the column. If I owe $1,000 in column A and put in $2,000 in as a lump sum payment, the cell directly to the right goes negative and messes up the rest of the next column.

        For now I just average it out but would love to know if this is something that can be fixed.

        • I’ll try to look into an update, Michael. Thanks for reaching out, and congrats on tackling your debt so aggressively!!

          • Please check this out as well.

            I have named this debt as: Student Loan
            Balance: $226,807.00
            Minimum Payment: $500.00
            Interest Rate: 6.50%

            With every payment the balance increases, instead of decreasing every month.

            Payment Balance
            $500.00 $226,307.00
            $500.00 $227,030.12
            $500.00 $227,757.16
            $500.00 $228,488.14
            $500.00 $229,223.07
            $500.00 $229,961.99
            $500.00 $230,704.91

            This does not happens with any of the other debts that I have entered. Only with this scenario, and it occurs regardless of the column being used.

            Here’s another debt that works OK.

            Balance: $101,265.49
            Minimum Payment: $750.00
            Interest Rate: 5.75%

            Payment Balance
            $750.00 $100,515.49
            $750.00 $100,243.53
            $750.00 $99,970.27
            $750.00 $99,695.70
            $750.00 $99,419.82

            Thanks.

          • Hi VA.

            6.5% of $226,807 is $14,742. If you’re only paying $500 a month, that’s just $6,000 a year. That’s why your balance is going up. It’s time to pay that sucker down! And holy shamoly that’s a big student loan! I sure hop your income is $200k or more!

  66. That explains a lot.

    Totally agree with you on paying it down.

    Sad to say that the sum of both scenarios is the kind of money it takes nowadays to study Veterinary Medicine, when you are not a resident of the Vet Med University’s state, and when you are not from a privilege crib. ;(

    Thanks.

    • Sheesh! I’m guessing you’d recommend that people stay within their own state to study vet med for cheaper, huh? If you hit all your debt hard, how long do you figure it will take you to pay it all off??

  67. Well, since we don’t have any Vet Med school in Puerto Rico we have no other option than to move abroad, thus we end up being “out of state” students anywere.

    This will take from 25 to 30 years, so it is like paying a $350K mortgage loan. Hope to considerably reduce this duration by using this snowball approach.

    Wish me luck! ๐Ÿ˜‰

    • Yikes! Yes, good luck! I want to hear from you once it’s paid off in 5 years. Then you’ll be making bank AND you’ll have no debt. Can’t wait for you to do it! I know you can!

  68. I found your blog on a search specifically for snowball debt calculator. Your Excel tool is by FAR my favorite of that I have seen. I send your blank template to anyone and everyone that I can. I have made a few modifications to my personal copy (totals and such; nothing with the formulas or graphics). I started using it in February 2018 and in April 2018 my credit score has increased by 21 points. I am paying $200 on top of my minimum payments, I have an exorbitant amount of student loan and other debt. My question is: do you ever start your spreadsheet over? Or do you keep the same one running?

    • Hi Kari! Glad you love the tool!

      I think it’s often appropriate to start the tool over after you cancel a few debts because after even a short period of time, you’re likely to have cut some more costs out of your budget or increased your income, which would change your outlook on your original sheet because you’re paying down your debts even FASTER! BOOM! Keep up the awesome work, and good luck on the student loan debt. It’ll feel SOOOO good once it’s gone!!

  69. Not sure what I am doing wrong but I canโ€™t download it the spreadsheet. I click the link and it takes me to the spreadsheet but then I canโ€™t seem to add my own debt in the cells. I must admit Iโ€™m not the savviest when it comes to excel ๐Ÿ™
    Thank you

    • Hi Michele – There’s probably one more click you have to do in Excel — “Enable Editing”. You’ll see it in the upper portion of the sheet. Once you click that, you should be good to go! Now go crush your debts!!

  70. Hi Derek,

    Can I just copy paste to extend more? will the formula change?

    thanks!

    • Hi Valerie! Unfortunately, no. The equations are complex and cannot simply be copy/pasted or dragged over. Load up all the cells with your current debts and then pay some of those buggers off!! Then, once you get it down to 16, reset your snowball (and fit all those debts in there) so you can see how much longer you have to go. It’s time to wage war on those debts!!!!!!

  71. Hi Derek, Thank you for the great tool. I am wondering about how to adjust for different additional payments each month. For example month 1 I have an extra $400 to put towards debt, next month an extra $300 but another month might be more or less depending on if I can get extra work that month or sell something. Do I copy/past the sheet and update it for the next month or what do you suggest? Thank you!

    • Hi Tiffany. First of all, congrats on tackling your debt! That is AWESOME!

      Unfortunately, this tool wasn’t built to morph and change as you pay down your debt. It was built to give you an idea of how long it would take and to show you how quickly that debt snowball will start rolling. If you want a new look each month (or couple of months), you can absolutely do a copy/paste into a new tab and update your debt numbers.

      Best of luck to you on paying off your debts!!!

  72. Hi! Iโ€™ve been using your spreadsheet since October 2017 and itโ€™s been really helpful to me! Iโ€™m paying off my debts smallest to largest but I notice that my car loan balance is going down a lot quicker than my other debts due to the higher minimum payment and lower interest rate. Should I switch the debts around on the spreadsheet when the time comes when my auto loan balance is lower than some currently ahead of it? I did try to switch it around now to see what it did, but it pushed me out a few months :(((. That did not make me happy!! Another reason I would like to pay the auto loan ahead of the others is because I would free up a larger minimum payment to be able to put towards the other debts. Can you let me know your thoughts? Thanks so much!

    • Hi April. This typically happens to people that are putting only a couple hundred extra dollars toward their debts each month (which is where I’m guessing you’re at). I’d recommend leaving the car where it is in the snowball and charging at your debt a bit harder – either take on a second job or start a side hustle at home! If you start paying $1,000 extra toward your debt each month, this would be a non-issue and you’d be out of debt faster than you can imagine!

      • Hey Derek…that’s exactly what I’m doing! I’m averaging $1,400 above my minimum payments. I’m not sure why moving the auto loan would push me out so far. Also, I have recently been updating the spreadsheet with my additional payments and my numbers are not moving. I wonder if I messed something up with the formulas. Would you recommend I start from scratch?

        • Yeah, I would start from scratch if I were you…with your existing numbers and debts. That way you’ll be sure that you didn’t mess up any formulas. Let me know if you need any other help! So glad you’re using the tool!!

  73. Thank you for sharing!:)

    • You’re welcome! Now kick that debt in the teeth!!

  74. Hi Derek

    I a few more debts then 10 and was wondering if there was a way to double the columns to 20 total?

    • Hey Stephen. Sorry, It’s not easy to add additional columns with all of the formulas. The maximum debts you can enter is 16. If I were you, I’d start with the smallest and add as many debts as possible, quickly pay off all those ankle-biters until you can fit your full debt picture into the tool, and then re-enter your info. Best of luck to you paying off your debts!!

      • No worries Derek I was about to add the additional columns.

  75. HI Derek! This is great thanks. I earn a monthly bonus that varies… can I just put the amount in for my lowest debt or will it throw off the spreadsheet formulas?

    • You can try to add “+200” or whatever your bonus is at the end of the formula, but it might throw it off. Try it, and if that doesn’t work, then just take the average of your bonuses and factor that into the amount you can put toward your debts. Thanks for reading, and I’m glad you’re using the tool!

  76. This is great but there is one small problem. I entered that I am able to pay $1,000/mo on top of my minimum payments. Month 1 works great, it allocates my 1k and then the rest are minimums. When it gets to month 2 it allocates 2k and then my minimums. When it gets to month 3 and beyond it resumes the 1k + minimums. Not sure what is going on here but feel free to take a look https://paste.pics/3PY4P

    Its saying in month 2 I should pay…

    $111
    $863
    $908
    $232 = $2114

    … and then minimums from there on out.

    Not sure what is going on but I thought maybe I accidentally erased a formula in a cell so I donwloaded the template and entered everything again from scratch and same result.

    • Hi Thea – sorry for the inconvenience! Here’s the quick fix:

      – in cell H23, enter this formula: =IF(AND(((I22-$H$11+F23+D23+B23-I$18-G$18-E$18-C$18)<=0),G23+E23+C23=0),I22, IF(AND((I22-I$18-$H$11)<=0, G22=0),I22,IF(I$18>=I22, I22, IF(AND(G23=0,E23=0,C23=0), $H$11-F23-D23-B23+I$18+G$18+E$18+C$18,I$18))))

      I’ll look into a more permanent solution soon. Thanks for the reaching out. And good luck kicking butt on your debts!!

      • Thanks for the response! I tried this and nothing changes. I downloaded the template again and upon entering 2000 as the monthly extra and 0 as the one time start up it already throws the calculations off before I’m even able to enter my own debts.

        Screen shot of default template with 2000 and 0 as the extra and startup amounts https://paste.pics/3RRVK

  77. Is there another version of this that allows for adding in random additional payments when extra money is put towards debts? I’m talking about tax returns, bonuses, overtime pay? I would love to be able to see what the larger payments do to my timeline. I just started my snowball to pay down $145k and I want to be able to account for the additional payments, it would be a big motivator for my overall success if I can easily plug in the higher payments wherever they fall.

    • Hi Tiffany. I’m glad to hear that you’re paying down your debts!

      You could try two things:

      1) Estimate the total of your random payments each year and divide by 12 to incorporate the dollars into your monthly payment amount
      2) You could try to add to a specific formula within specific cells – at the end of the formula, simply enter “+500” or “+1000”. As long as you don’t enter more than the payoff amount for a particular debt, it shouldn’t mess up any other formulas.

      Best of luck to you, Tiffany! That’s a big debt, but I know you can pay it off!!

  78. Hi Derek! I have been using your spreadsheet, and not only is it helpful, it’s motivating! Thank you! One question I do have: the payment column under each dept, should that exclude the min payment and the monthly extra? Or does it not care what that is and we should include the actual payment to that account? THANKS

    • Hi Kelly. Glad you like the tool!

      The payment numbers under each category are automatically placed based on your entries at the top of the sheet – the one-time adder amount, and the extra monthly amount you can put toward all the debts (above and beyond the minimum payments). You shouldn’t have to enter any extra numbers in the lower portion of the sheet. Hope that helps.

  79. Hi Derek
    Can I please have the most updated link to the spreadsheet?
    I’ve downloaded it twice and it’s showing the glitch still in the D23 area.
    thanks very much.

  80. Hi Derek!! your tool is great!! Excuse me for my ignorance, what “interest rate” stands for? I have a debt that charges me 16% interest monthly so if i pay only that 16% monthly the debt never go down but neither go up, I asumed that the interest rate is an Anual Interest Rate, so I multiplied that 16% by 12 Months and it gave me 192% so I putted that in the intetest rate in that debt but the calculations doesn’t match, so what interest rate should I use for 16% monthly? is the only debt I had issues.

    • Hi David. First off, thanks for finding us! And second, I’m so glad you’re starting to tackle your debt. That is AWESOME!!!

      The interest rate you should enter is your yearly interest rate. At 16%, it’s actually not surprising that the debt isn’t going down with the regular payment schedule they offer. Sounds like it’s time to slay your debt so they stop raping you of your money!!

  81. Hi there, I am not as good at this stuff so I have a question, what if one does not have a hefty start up, how can this work starting at the bottom of the can? I am guessing that paying off the first small bill then taking that one and adding it to the next one and keep going on from there, works, yes? I am confused about your excel page but I will work on it and get it figured out. Thank you for a great starter tool!

    • Hi Allison. You don’t need to have a big cash start to make this work, but it does help if you start generating some additional income to increase your monthly payments! Hope you figured out the tool by now. Let me know if you have any other questions!! Thanks!

  82. Hi – Thanks so much for this spreadsheet! I am getting a negative number in cell L 22, which actually increases my debt on that card, and effects all payments going forward. Have you seen this issue? I am using v1.8. Also – if I wish to make additional one time payments at some point in the future how do I account for this in the spreadsheet? Should I just re-enter the remaining debts using the last snowball payment as the minimum on the first remaining debt?

    • Hi Howard – thanks for shooting me an email. I made a simple tweak and got your snowball to work (and I sent the file back to you). Let me know if you have any other questions. Hope you kill all your debt in 2019!!

  83. Hi Derek.
    Is it possible for you to make a Debt Snowball Spreadsheet that allows extra one time payments to a balance?

    • Hi Tammy – I have gotten that response quite a bit. I’ll put that on my list of improvements to the sheet. In the meantime, you can try to manually add it into the cell at the end of the formula. If you’d like more help with this, let me know either by this comment or shoot me an email. Thanks for reading and reaching out!!

  84. Hey Derek – I stumbled across this fantastic tool about a year ago and have loved every moment since then. My husband and I began our journey with well over 100K to payoff and in the last year we’ve gotten it down to 56,163. My husband works offshore and took the opportunity with his employer to do workovers to get an extra paycheck or two every month to increase our household income. We’ve been able to tweak our budget to squeeze every extra cent out of it and throw it at our debt. Our goal is to be debt free in 15 months and I know we wouldn’t have been able to get this far with our the help of the tools you have available. THANK YOU SO MUCH!

    • Awesome!! I LOVE IT!! Thanks for telling me about your success with this tool. Give it another year and you’ll be debt free and building wealth! Keep me posted on all your future good news, Joey!

  85. Hi Derek! I love this spreadsheet- I treat it like a checklist and highlight each payment in green once I make it. Question- my current largest debt (car loan) over time will become lower than a few of my other debts as I make the minimum payments on those while snowballing my smaller debts. Once I pay off Debt A, should I double check my current balances on the rest of my debts to see if the sequence has changed due to minimum payments being made impacting those balances? I haven’t seen this scenario discussed anywhere else and just wanted to get some input. It seems that would help speed up the payoff process! Thanks!

    • Hi Casey. I actually haven’t heard that question before either, but it’s a good one!

      My vote is, “Absolutely”. If your car loan (over time) becomes your new lowest debt, shift your money there and knock it out as quickly as possible. Now, my snowball spreadsheet won’t be sophisticated enough to do this for you, so it will be a bit of a manual exercise on your part. The overall pay-off date probably won’t shift much, but paying down debts more frequently in the beginning will get you all pumped up and you’ll be more likely to get out of debt completely in the long run. That’s the power of the debt snowball vs. the debt avalanche method.

      Thanks for reading and thanks for the awesome question!

  86. Is there a way to see total interest paid? I’d love to be able to move debt order around and see how payoff order affects total interest paid.

    • Hmmm, good question John! I don’t have that functionality built in, but you could set up a formula at the bottom of the grid that multiplies 1/12th of the interest percent for each month’s remaining balance. The total of each column would equal your total interest paid.

  87. Derek, I can not thank you enough for sharing this tool. This one excel spreadsheet changed my finances completely. In 18 months, I paid off 6 credit cards, 2 personal loans AND my car. Those $1,178 car payments were scary, but man did they save on interest. I now am able to save $1000 per month on top of increased 403b and ROTH IRA contributions. THANK YOU THANK YOU THANK YOU!

    • Yeah yeah!!!!! I LOVE to hear this! The fact that I can help you in such a big way has just made my day. Thanks for dropping me the line to let me know!!

  88. Derek,
    Just found your debt spreadsheet, but I think I may have found a bug…..er, I don’t understand how it works. I’ve put in some debts, (my own way to take advantage of some interest savings) and the numbers don’t agree when I get to a debt that pays itself off (before the snowball effect). Here’s my example of how it shows in the spreadsheet:
    Loan A, $375/mo – paid off in 35 months.
    Loan B, $275/mo – paid off (with help from loan A) in 11 months after (46th month). But….
    Loan C, $123/mo – paid off with standard payments at 19th month (they are tiny payments, school loan, low interest) before getting snowballed with help from Loans A and B.
    Then….
    Loan D, $119/mo – starts getting help from Loans A and B (NOT Loan C!) at month 19! Hmmmm. That’s the strange thing. Loan C’s monthly payment doesn’t compare to the snowball of Loans A and B together($650). Loan D goes from $119/mo to $805/mo in month 19. Loan B isn’t paid off yet. And, Loan D get’s paid off before Loan B. Did something happen to the formulas in the cells if a small loan comes after a large loan? Also, I’m not including any start-up payment or extra payments at this time. Something doesn’t compute right. Can I send the example to you?
    Thanks for your help!
    BJ

    • Hi BJ. Did you line them up smallest to largest?

      • Good point. No I didn’t. Wanted to take advantage of the interest rate savings by paying off higher interest rates first (and also mature/closeout first) before tackling the smaller loans. I do see your point in doing that. Yes, I’ll stick with it even if I spend a few extra months paying off the higher interest rates first. After doing the math, it was about the same amount of time to pay all the debts, but with a tiny bit of strategy, I could also save on interest, too! Maybe the savings won’t be as much? I think there was a request in an earlier comment for total interest paid and/or saved. Is this possible in excel?
        Thanks again for all your help! Love the spreadsheet!
        BJ

      • Also, can the spreadsheet work in any combo or do the formulas only work in one direction? I was hoping to make it work in my unique way.
        Thanks!
        BJ

        • Hi BJ. It’s really set up to take the official debt snowball approach. Honestly, unless you have a crazy high interest rate, I’d stick to the snowball method. You’ll pay off those small debts and you’ll be hungry to pay off more, and you’ll actually do more to get rid of those bigger debts faster…which will actually cost you less in the long run because you’re doing more with all that motivation!!

          Best of luck to you paying off your debts, BJ! I can’t wait to hear your success story!!

  89. Hi Derek! I love your tool. I downloaded it a few years ago and weโ€™re knocking out debt! I recently messed up the spreadsheet somehow and went back to your site to download it again and start fresh, however Iโ€™m having trouble downloading it. Iโ€™ve tried the original link and the links to updated version throughout the comments and Iโ€™ve tried downloading from different devices. Nothing happens. Please help!

    • Hi GR. Glad you’re still using the tool. I love hearing that!!! When you click the link, the spreadsheet downloads on the lower left of your screen. Since you probably knew this, I just emailed the spreadsheet your way as well.

      Best of luck to you canceling your debt! Let me know when it’s paid off!!!

  90. I absolutely love this spreadsheet! What are your thoughts on the avalanche method in comparison to the snowball method? I am trying to decide which route to go. It would be awesome to have a spreadsheet to compare both options to see which is best. Thanks again for this awesome snow ball spreadsheet. I would be debt free in 5 years, LOL.

    • Glad you like the spreadsheet, Shannon! There are comparison tools out there. Technically, the avalanche method will show that it pays off faster…but it’s not factoring in the emotion of you paying off those initial debts with the snowball method that’s going to put you into high gear on the rest of your debts!!

      …You may have guessed already. I’m 100% sold on the debt snowball. Take care of those little debts, build up the momentum, and then tackle what’s left!

      You can do this Shannon!! Thanks for dropping in. Glad you found the spreadsheet!!

  91. SO OVERWHELMED BY DEBT, WILL TRY THIS, IF IT HELPS ME I’LL HELP YOU TRANSLATE into SPANISH TO HELP MY COMMUNITY

    • Sounds like a deal! Best of luck to you, Oscar. Send me an email if you need any help with the tool!

  92. Hi Derek,

    My sheet is not calculating the interest rate so my balances are off. Any ideas? Sorry if this issue was already covered…lots of posts to go through. ๐Ÿ˜‰

    • Not sure, Luis! Sorry, I don’t have the time to dig into it. BUT, the faster you pay off the debt, the less you’ll have to worry about it! ๐Ÿ˜‰

      • No worries… I think I found the error on my sheet. Thx for getting back to me.

        • Good! Glad you solved the issue. Best of luck on your debt payoff! You can do it!!!!!!!!!

  93. I have to agree with James from 2017 earlier. the 1st column has issues under certain circumstances.
    One time startup: 950
    Monthly Extra: 850
    Lowest debt: 1803
    C13 says that I should pay $1850, which is more than I owe on the 1st debt.
    Somehow it should deduct the $1803 and add the 47 to the 2nd debt, but it doesn’t.

    Other than that, it is motivating to see when debts can be paid off with the extra.

    • Sorry for the slight glitch, Bill. BUT, I’m glad you can still benefit from the accuracy of all the other calcs! Pay off that debt, sir!! You won’t regret it!!!

  94. Hi Derek!
    Trying out your spreadsheet but Iโ€™ve run into a problem. When I put in the monthly extra 1750 and the one time start up 1750 itโ€™s stating that in month one Iโ€™ll be paying more than 1750 between to debts on the spreadsheet. If I send you my spreadsheet would you be able to help me out?

    • Yeah, for sure! Send it to derek @ lifeandmyfinances.com

  95. Hi there. I have a credit card where the minimum monthly payment is calculated by interest + 1% of the balance (I think). What would be the best way to reflect that on the spreadsheet? If I do that formula in the overall minimum payment cell, it applies that number for all of the minimum payments, but my minimum payment will change based on my balance. Or will it be easier to continuously update the numbers in the spreadsheet? Thanks in advance!

    • Hi Kelsi – Maybe you can send me your fully filled-out sheet (confidential of course) and I’ll see what I can do! derek (at) lifeandmyfinances [dot] com. It’s going to be a bit tricky because the balance is calculated by the interest…and the interest is calculated by the balance… makes for a circular reference. But I bet I could come up with something. ๐Ÿ˜‰

  96. This is great but do you have it for google sheets?

    • I don’t sorry. Not sure Google sheets is robust enough to handle this calculator.

      • Sheets works beautifully. I’ll share out the template this evening when I get home from work.

      • Steps to import the xls to sheets are pretty easy.
        1. download Derek’s file from his link.
        2. head to https://docs.google.com/spreadsheets/u/0/
        3. Open up a blank spreadsheet
        4. Now go to “File” –> “Import”
        5. using the import file picker, navigate to where you saved Derek’s file and choose it.
        6. At this point you can safely click “Import spreadsheet” if you’ve followed along.
        7. Wait a moment or two and then name your untitled sheet to whatever you like. I named mine “Eff these bills.”

    • Check Ivan’s comment! He figured out how to open the debt snowball calculator in Google Sheets. Thanks Ivan!


Add a Comment

Your email address will not be published. Required fields are marked *

CommentLuv badge

Related posts