Yes. You can make a free snowball debt spreadsheet in a blank Excel workbook, using the layout and formulas below; no paid template is required. It tracks balances, minimums, interest estimates, and the extra payment aimed at your smallest debt.
What the debt snowball method does
The debt snowball is a repayment strategy: pay at least the required minimum on every debt, then direct any extra amount to the debt with the smallest current balance. When that debt is paid off, roll the amount you had been paying on it into the next-smallest balance. Continue until the listed debts are cleared.
The method prioritizes visible progress rather than the interest rate. That is the key difference from the debt avalanche, which sends extra money to the debt with the highest rate. A snowball can help a person stay engaged by eliminating smaller accounts sooner, but it may cost more interest than an avalanche if a larger debt has a much higher APR. A spreadsheet can show the balances and payments; it cannot decide which trade-off is right for you.
Free spreadsheet layout to create in Excel
Open a blank workbook in Excel for Microsoft 365 on Windows. Enter the following headings in row 6, then list each debt on its own row from 7 through 16. You can use fewer rows, or extend the formulas if you have more debts.
- Column A: Debt or account name
- Column B: Current balance
- Column C: APR, entered as a percentage such as 24%
- Column D: Required monthly minimum
- Column E: Snowball order, with 1 assigned to the smallest balance
- Column F: Estimated interest for this month
- Column G: Planned payment
- Column H: Estimated balance after payment
Put Monthly payment budget in J3 and enter your total monthly debt budget in K3. Put Total minimums in J4 and Extra for target debt in J5. The budget means the amount you intend to spend across these debts in the month, including minimum payments. Format B, D, F, G, H, and K3:K5 as currency, and C as a percentage. In Excel for Windows, select the relevant cells and use Home > Number to choose a format. On Mac, the Home tab also contains the number-format controls, though their placement can vary with window size.
Formulas for the monthly plan
With minimum payments in D7:D16 and the monthly budget in K3, enter this in K4 to total the minimums: =SUM(D7:D16). With that total in K4 and the budget in K3, enter this in K5 to calculate the available extra: =MAX(0,K3-K4). If the budget is less than the minimums, this formula returns zero; it does not make the budget sufficient to cover what creditors require. Treat that as a warning to review the plan, rather than as a workable repayment schedule.
With the current balance in B7 and APR in C7, enter this in F7 to estimate one month of interest: =B7*C7/12. This uses a simple monthly estimate, not the lender’s exact interest calculation. With the minimum in D7, target rank in E7, extra amount in K5, and estimated interest in F7, enter this in G7: =MIN(B7+F7,D7+IF(E7=1,$K$5,0)). It adds the extra only to the row ranked 1 and caps the payment at the estimated amount owed. With balance, interest, and planned payment in B7, F7, and G7, enter this in H7: =MAX(0,B7+F7-G7).
Copy F7:H7 down through row 16. In Excel, use the fill handle at the lower-right corner of the selected cells, or copy and paste them into the rows below. These formulas assume each debt has a minimum payment entered and that the monthly budget covers all minimums. They model one target debt at a time; they do not automatically pass an unused amount to a second target if the first is paid off mid-month. You can adjust the plan for the next cycle after confirming the actual payoff amount.
Worked example: how the numbers change
Suppose the sheet has three debts: a $500 balance at 24% APR with a $30 minimum, a $1,200 balance at 18% with a $45 minimum, and a $3,000 balance at 12% with a $75 minimum. Assign ranks 1, 2, and 3 in that order, and set the monthly budget to $300. The minimums total $150, leaving $150 extra for the smallest balance.
Using the spreadsheet’s simple monthly-interest estimate, the first debt accrues $10 in interest ($500 × 24% ÷ 12). Its planned payment is $180: the $30 minimum plus $150 extra. Its estimated ending balance is $330. The second debt accrues $18 and receives its $45 minimum, leaving $1,173. The third accrues $30 and receives its $75 minimum, leaving $2,955. The balances total $4,458 after the estimated $58 interest and $300 in payments: $4,700 + $58 − $300. Actual statement balances may differ because lenders can calculate interest daily, add fees, or post payments on different dates.
Choosing and ordering debts
Use the current balance shown by each lender, not the original amount borrowed. Sort the debts from lowest to highest balance and enter the corresponding order in column E. If two balances are equal, choose either one first or use another practical tie-breaker, such as the account with the smaller minimum. Consistency matters more than a finely tuned tie-break.
Before relying on the plan, check that the minimums are current, the APR is entered correctly, and the monthly budget reflects what you can actually pay. Some accounts have promotional rates, variable APRs, deferred interest, or fees that make a single rate less representative. Check the terms and current amounts with each lender. This spreadsheet is an organizational aid, not financial, tax, investment, or legal advice; consult a qualified professional if you need advice for your circumstances.
Updating the sheet each month
Use the ending-balance column as a projection, not as a substitute for statements. At the start of the next cycle, compare each lender’s posted balance and minimum due with the estimate. Replace column B with the confirmed current balance, update column D if a minimum changed, and revise APRs if the lender changed them. Re-sort or reassign the snowball order if the smallest balance has changed.
- Check account statements or lender portals for balances, minimums, rates, and due dates.
- Confirm that the monthly budget is at least the combined minimums before assigning extra.
- Pay each minimum by its due date, then send the planned extra to the smallest balance.
- Record actual payments and use confirmed balances for the next month’s plan.
Payments can take time to post, so avoid treating a projected zero as confirmation that an account is paid off. Ask the lender for the payoff amount when appropriate, and verify that the account reaches a zero balance. Also check how the lender handles recurring payments after payoff so that an old automatic payment does not create an unintended overpayment.
Common spreadsheet mistakes and safeguards
A frequent error is putting 24 in the APR cell instead of 24%. Excel interprets 24 as 2,400% when used as a percentage value; enter 24% or 0.24. Another is setting the snowball order based on APR. That changes the plan into something closer to an avalanche strategy. The snowball rank should follow current balance, not interest rate.
It is also easy to confuse the monthly budget with the extra payment. In this layout, K3 includes the minimums; K5 is only the amount left after them. Entering the extra itself in K3 would understate the planned payment. Check that all debts appear in the ranges used by the formulas, and make sure blank rows or omitted accounts do not leave a minimum out of the total.
To reduce accidental edits, label input cells clearly and keep formulas in separate columns. In Excel for Windows, you can turn the debt list into a table with Insert > Table after selecting the data and confirming that the range has headers. On Mac, use Insert > Table. Tables make lists easier to filter and extend, but if you add rows beyond row 16, expand the formula ranges too. You can also save a separate copy before making structural changes.
Snowball versus avalanche and other options
The snowball focuses on the smallest balance first; the avalanche focuses on the highest interest rate first. If the debt amounts and rates differ substantially, compare both approaches before choosing. A snowball tracker is straightforward to maintain, while a detailed comparison needs to account for balances, rates, minimums, payment timing, and rate changes. Estimates are not guarantees of a payoff date or total interest cost.
Other options include a lender’s own repayment tools, a basic paper list, or a spreadsheet in another program. If using Excel for the web, the basic formulas shown here work in a browser, although menus and layout differ from the Windows desktop app. A Microsoft account may provide access to Excel for the web at no charge, subject to Microsoft’s current account and service terms; the desktop Microsoft 365 app may require a paid subscription or an eligible license. Avoid entering account passwords, full account numbers, or other sensitive login details in a shared or publicly accessible workbook.
Frequently Asked Questions
Is there a free snowball debt spreadsheet template?
Yes. You can build one in a blank Excel workbook with the columns and formulas above. This page provides a setup rather than a downloadable workbook file; you do not need a paid template to use the method.
Does the snowball method pay the least interest?
Not necessarily. The avalanche method often reduces interest faster when it prioritizes the highest APR, assuming the same total payment and no other changes. The snowball instead prioritizes clearing the smallest balance first.
Should I include a credit card’s APR or its monthly interest?
Enter the APR as an annual percentage in column C, such as 24%. The formula estimates monthly interest by dividing that rate by 12. It is a planning approximation; check the issuer’s statement and terms for the actual amount.
What if my monthly budget is below the total minimums?
The extra-payment formula will show zero, but that does not resolve a shortfall. Review the amounts and due dates with the lenders, and consider speaking with a qualified nonprofit credit counselor or other qualified professional about available options.
What should I do when the smallest debt is paid off?
Confirm the account balance with the lender, then remove it from the active list or mark it paid. Apply the amount previously directed to that debt, along with the other minimums, to the next-smallest balance in the next plan cycle.
Related
- Budget Planner Spreadsheet: Build a Monthly Spending Plan
- Debt Snowball Spreadsheet Template: Build and Use One
- PowerPoint: How to Animate Part of Text
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create a Work Signature in Outlook on Any DeviceTo create a work signature in Outlook, open the signature settings for your version of Outlook, add your…
- Monthly Employee Work Schedule Template Excel GuideA monthly employee work schedule template in Excel is a calendar-style grid: employees go down the rows, dates…
- How to Create Mailing Labels in WordTo create mailing labels in Word, open the Mailings tab, choose Start Mail Merge > Labels, select the…
- How to Write Subscript in Excel: Shortcut and StepsIn Excel for Microsoft 365 on Windows, there is no dedicated one-key shortcut that toggles subscript. To apply…
- Excel Day Counter: Count Days Between DatesWith a start date in A2 and an end date in B2, enter =B2-A2 to count the days…
- Conditional Formatting in Spreadsheets: How It WorksConditional formatting in a spreadsheet automatically changes a cell’s appearance when its value meets a condition; in Excel…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.