A debt reduction snowball spreadsheet lists debts from smallest balance to largest, pays each required minimum, and directs your extra monthly payment to the smallest unpaid debt. In Excel for Microsoft 365 on Windows, you can build a useful one-month calculator with columns for balance, APR, minimum payment, interest, extra payment, and ending balance, then carry each month’s ending balances into the next month.
What the debt snowball method does
The snowball method is a way to order debt repayments. You keep paying the minimum due on every account and put money above those minimums toward the debt with the lowest balance. When that account is paid off, its former payment joins the amount available for the next-smallest balance. The payment amount can therefore grow as debts are cleared, like a snowball rolling downhill.
The method focuses on balance size, not interest rate. That distinction matters: paying the smallest debt first can produce an early account payoff, but it may cost more interest than prioritizing the highest-rate debt. A spreadsheet makes the order, estimated interest, and changing balances visible; it does not change the terms of a loan or guarantee a particular payoff date.
Set up the debt list in Excel
Create a worksheet named Snowball and enter one debt per row. Use these headings in row 1: A: Debt, B: Starting balance, C: APR, D: Minimum payment, E: Balance this month, F: Interest, G: Minimum paid, H: Extra paid, and I: Ending balance. Put the monthly extra amount available above minimums in K1, and enter its value in K2. Enter APR as a percentage, such as 24%, not as 24.
For a simple example, enter three debts: Card A has a $600 balance, 24% APR, and $30 minimum; Loan B has a $1,800 balance, 12% APR, and $60 minimum; Card C has a $3,200 balance, 18% APR, and $80 minimum. Put these in rows 2 to 4, ordered by balance from smallest to largest. Enter $130 in K2 as the extra amount for this month. The total amount planned for debt payments is $300: $170 in minimums plus $130 extra.
In row 2, set E2 equal to B2, then copy the formula down through E4. With starting balances in B2:B4, enter =B2 in E2; the displayed balance for Card A is $600. This separates the original input from the balance used in the monthly calculation.
Calculate interest and minimum payments
This example estimates monthly interest as APR divided by 12. With the current month’s balance in E2 and the annual percentage rate in C2, enter =E2*C2/12 in F2 and copy it down. For the example, Card A’s estimated interest is $12, Loan B’s is $18, and Card C’s is $48. The arithmetic is balance × annual rate ÷ 12; $600 × 24% ÷ 12 = $12.
Actual interest can differ because lenders may accrue it daily, use a different balance method, or apply fees or other adjustments. Treat the result as a planning estimate, not a statement balance. Check your account agreement and current lender information for the real rate, minimum, due date, and payment rules.
With the balance in E2, interest in F2, and contractual minimum in D2, enter =MIN(E2+F2,D2) in G2 and copy down. This prevents the planned minimum from exceeding the balance plus estimated interest if a debt is nearly paid off. In the example, minimum payments are $30, $60, and $80, for $170 total.
Direct extra money to the snowball target
Keep the debt rows sorted from the smallest current balance to the largest. In H2, use =MIN(MAX(0,$K$2),MAX(0,E2+F2-G2)). This assigns the available extra amount to the first debt, but caps the payment at what remains after interest and the minimum. For this example, Card A receives the full $130 extra because its post-minimum amount owed is $582.
For the second debt, enter =MIN(MAX(0,$K$2-SUM($H$2:H2)),MAX(0,E3+F3-G3)) in H3. Copy that pattern down, extending the SUM range to include the extra payments in all rows above the current one. In H4, for example, the range should end at H3. This lets any extra left after clearing an earlier debt continue to the next debt in the sorted list. If the extra budget exceeds the total debt, the formulas cap payments at the amounts owed.
With the illustrative balances, the $130 extra goes to Card A. The formula does not automatically reorder debts if their balances change. At the start of each new month, update the current balances and sort the debt rows from smallest to largest before calculating the next month.
Calculate ending balances and carry the plan forward
With the month’s balance in E2, interest in F2, minimum paid in G2, and extra paid in H2, enter =MAX(0,E2+F2-G2-H2) in I2 and copy down. The example returns $452 for Card A: $600 + $12 interest − $30 minimum − $130 extra. Loan B ends at $1,758 ($1,800 + $18 − $60), and Card C ends at $3,168 ($3,200 + $48 − $80). Together, those ending balances total $5,378, down from $5,600 after the planned $300 of payments and $78 of estimated interest.
For the next month, use each ending balance as the next starting balance. A straightforward approach is to duplicate the worksheet for each month, copy the values in I2:I4, and paste them as values into B2:B4 on the new sheet. Then set E2:E4 from the updated starting balances, refresh lender minimums and the extra budget, and sort the debt rows again. Keeping a separate tab for each month gives you a record of assumptions and estimates. Avoid copying formulas as values into the original formula cells if you want to retain the calculator.
Make the sheet easier to read and maintain
Format balances and payment columns as currency and the APR column as Percentage using Home > Number. Freeze the heading row with View > Freeze Panes > Freeze Top Row. You can make a simple payoff warning with Home > Conditional Formatting > Highlight Cells Rules > Less Than, applied to the ending-balance range with a value of 0.01. Check the selected range before applying the rule so it highlights the intended balances.
Add a few control totals below the debt list: minimums, extra payments, and ending balances. Compare the sum of G and H with the payment amount you intend to send, and make sure the extra payments do not exceed K2. A spreadsheet is only as reliable as its inputs, so date each monthly update and record any known fees, promotional-rate expiry dates, or payment changes in a notes column.
These menu paths describe Excel for Microsoft 365 on Windows. Excel for Mac has similar Home and View tabs, though the location or wording of some commands can vary by release. Excel for the web also has formatting and freeze-pane controls, but the menus can differ. The formulas above use basic arithmetic and MIN, MAX, and SUM, which are available in current desktop Excel versions.
Snowball versus avalanche: what changes?
The avalanche method also pays minimums on every debt, but directs extra money to the debt with the highest interest rate first. All else being equal, and if rates and balances are modeled accurately, prioritizing the highest rate generally reduces interest compared with prioritizing a smaller balance. The snowball’s counterpoint is its focus on visible account payoffs. Which order is more workable can depend on a person’s circumstances and ability to stick with a plan; the spreadsheet can show the trade-off rather than decide it.
To model an avalanche, sort the rows by APR from highest to lowest before applying the extra-payment formulas. The formulas themselves do not change; only the order of the rows changes. Do not sort by APR and then describe the result as a snowball, or sort by balance and assume the result minimizes interest. If the rates are close, or an account has a temporary promotional rate, check the actual terms and likely rate changes before relying on a long-range estimate.
Common spreadsheet problems and limitations
- Using the wrong extra amount: K2 is the amount above all minimum payments, not the total monthly debt budget. If $300 is the total budget and minimums are $170, enter $130 as extra.
- Leaving the rows in the old order: After balances change, resort by current balance each month. Otherwise the extra payment may go to a debt that is no longer the smallest.
- Using a stale minimum: Minimums can change with balances, account rules, or lender updates. Replace estimates with the amounts actually due.
- Assuming monthly interest is exact: APR divided by 12 is an approximation. Daily interest, transaction timing, fees, and payment posting can shift real balances.
- Forgetting the payment budget: A formula can allocate money, but it cannot confirm that the planned payment fits a household budget or that a lender received it on time.
A payoff estimate also depends on continuing to make the planned payments and on assumptions remaining stable. New charges, late fees, rate changes, missed payments, and changes in income can make the projection inaccurate. Keep an emergency cash buffer in mind rather than entering a payment figure that is not realistic to sustain.
Alternatives to a manually updated workbook
A manual Excel workbook is transparent and easy to adapt, but it requires monthly balance updates and sorting. A lender’s payoff calculator may use that lender’s own rules for interest and payment timing, though it may not compare several accounts in one view. A budgeting app may synchronize balances, but synchronization and features depend on the provider and account. Compare data access, fees, update frequency, and privacy terms before connecting financial accounts.
You can also keep the spreadsheet as a planning tool while using lender statements or online accounts to verify required payments. Do not treat a projected payoff date as permission to stop checking statements. If you are unsure how a contract, rate, or repayment option works, ask the lender or a qualified professional. This spreadsheet is for organization and illustration, not financial, tax, investment, or legal advice.
Frequently Asked Questions
What should a debt snowball spreadsheet include? Include each debt’s current balance, APR, required minimum, estimated interest, planned minimum payment, extra payment, and ending balance. Also show the extra monthly amount available above minimums, and keep a dated record of monthly updates.
Should I include interest in the snowball balance? Yes, estimate the month’s interest before calculating the ending balance, as the example formulas do. But sort debts using current balances at the start of the month, then verify the following month’s actual balances and resort. Lender calculations may differ from a simple APR-divided-by-12 estimate.
What if my extra payment pays off the smallest debt? The formulas cap its extra payment at the remaining amount owed and can pass unused extra to the next row. At the next monthly update, remove or mark the paid-off account, confirm its actual payoff with the lender, and reorder the remaining debts by balance.
Does the debt snowball save the most interest? Not necessarily. Snowball prioritizes the smallest balance; avalanche prioritizes the highest interest rate and can reduce interest under otherwise comparable assumptions. Actual outcomes depend on rates, fees, payment timing, and changing account terms.
Can I build this in Google Sheets instead? Yes. The formulas shown use basic operators and common spreadsheet functions that are also available in Google Sheets. Menu locations differ, so follow Sheets’ own formatting and freeze-row menus rather than Excel ribbon paths.
Related
- PowerPoint Slide Template: How to Create and Save One
- Bi-Weekly Budget Spreadsheet: Build One That Works
- How to Animate Typing Text in PowerPoint, Step by Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Merge Cells but Keep All Data?No—Excel cannot merge cells while retaining each cell’s value as separate data. When you merge a range, it…
- How to Change View Size in Outlook Email on Any ScreenTo change the size of an email in Outlook, adjust message zoom in classic Outlook for Windows, or…
- Excel Concatenation: Other Ways to Join Text ValuesBesides the ampersand (&), you can join text in Excel with CONCAT, TEXTJOIN, or the older CONCATENATE function;…
- Excel Tab Rename Shortcut: Windows and Mac StepsIn Excel for Microsoft 365 on Windows, select the worksheet you want to rename and press Alt, then…
- Hide in Excel: Keyboard Shortcuts for Rows, Columns & SheetsTo hide rows in Excel for Microsoft 365 on Windows, select them and press Ctrl+9; to hide columns,…
- Microsoft Excel Compare Two Sheets: Methods That WorkTo compare two Excel sheets, use a formula when matching cells occupy the same positions, or compare records…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.