Download the Free Debt Snowball Excel Worksheet
Click the below links to download the free Debt Snowball Excel Worksheet with Chart.
- Free Debt Snowball Excel Worksheet (XLSX file).
- Free Debt Snowball Excel Worksheet (XLS file for older versions of Excel).
If you are not familiar with the Debt Snowball method, then please read the steps involved in a Debt Snowball Repayment Plan.
Instructions for using the Debt Snowball Excel Worksheet
- On the Debt-Snowball worksheet – review and edit row #2 by entering the names of all accounts where you have outstanding debt, with the account with the lowest balance first, followed by the next account with the next lowest balance.
- Clear the excess cells if there are more cells than what you need.
- On row 3, enter the outstanding amount for each of those accounts.
- On row 4, enter the minimum payment required for each of those accounts.
- On cell A6, enter the date when you are starting your Debt Snowball process.
- Starting from cell B6, enter the repayment amount for each account until the accounts are paid off.
- Note: The cells in gray color are computed cells, you cannot edit them.
Dave Ramsey’s Baby Steps FREE progress tracking charts:
- If you are just starting with Baby Step 1 of the Total Make Money Makeover book by Dave Ramsey you can download our emergency fund progress tracking charts here. This chart will help you visually track the progress of building your initial emergency fund.
- You can also download the debt snowball progress tracking charts here. These charts will help you visually track the progress you are making in repaying each individual debt.
You can read more about the Debt Snowball Strategy blow:
What is the Debt Snowball method for repaying debt?
The debt-snowball method is a debt repayment strategy, in which one pays off the accounts starting with the smallest balances first, while paying the minimum payment on larger debts. This is different from the traditional wisdom of paying the debt with the largest interest rate first.
Why the Debt Snowball plan is a very effective debt repayment strategy?
The reason for the effectiveness of the Debt Snowball method is due to the emotional aspect involved in debt repayment. Most often, people are driven by emotions rather than logic.
Paying off the smaller loans first, will provide a quick victory over debt and will provide an emotional high for the person repaying the debt. This will help them to continue with the debt snowball program. This quick victory will provide the needed reassurance regarding the effectiveness of the Debt Snowball method.
Once you start your debt snowball process, you will notice the amazing part of the debt snowball method. It can efficiently knockout your debt in the shortest possible time.
Generally people who are in debt with a number of charge or credit accounts, use the following strategy. Whenever they come across a little bit of extra money (annual bonus, tax refund etc) they will try to spread that little bit of money to a number of accounts. Then, the next time they get a little bit of extra money, they will send that money to another set of accounts. By doing so they believe, they are effectively dodging all their creditors. This is the most in-effective way to pay off debt.
On the contrary, in the debt snowball method, you will put your most concentrated effort to attack one and only debt with all your might until it is killed.
Once that debt is eliminated, you are freeing up that much money to attack the next debt. This one minded focus on a single debt at a time, will give you enormous power and focus in your debt free journey. This is also exactly why the debt snowball program is so effective.
The steps involved in a Debt Snowball Repayment Plan:
- List all debts in ascending order from smallest balance to largest. This is the method’s most distinctive feature, in that the order is determined by amount owed, not the rate of interest charged. However, if two debts are very close in amount owed, then the debt with the higher interest rate would be moved above in the list.
- Commit to pay the minimum payment on every debt.
- Determine how much extra can be applied towards the smallest debt.
- Pay the minimum payment plus the extra amount towards that smallest debt until it is paid off. Note that some lenders (mortgage lenders, car companies) will apply extra amounts towards the next payment; in order for the method to work the lenders need to be contacted and told that extra payments are to go directly toward principal reduction. Credit cards usually apply the whole payment during the current cycle.
- Once a debt is paid in full, add the old minimum payment (plus any extra amount available) from the first debt to the minimum payment on the second smallest debt, and apply the new sum to repaying the second smallest debt.
- Repeat until all debts are paid in full.
Did you find this worksheet useful?
Is this worksheet useful for you? If so please comment using the comment box below.
Also, please comment if you like to see any improvements on this worksheet or chart.