Debt Snowball Spreadsheet: Build One in Excel

Yes—you can create a debt snowball spreadsheet in Excel by listing debts from smallest balance to largest, calculating each month’s interest and minimum payment, then directing the remaining payment budget to the first unpaid debt. A simple worksheet can estimate balances and show how payments roll forward as debts are cleared.

What the debt snowball method does

The debt snowball is a repayment strategy that prioritizes debts by balance rather than interest rate. You make the required minimum payment on each debt and put extra money toward the debt with the smallest current balance. Once it is paid off, you apply the amount you had been paying on it to the next-smallest debt. The name describes that growing payment: it can gain momentum as individual accounts are cleared.

This approach differs from the debt avalanche, which prioritizes the highest interest rate. The snowball may give you an early, visible payoff, while the avalanche can reduce interest costs when rates and other details are comparable. Neither spreadsheet can determine which approach is right for your circumstances. A useful worksheet helps you see the trade-offs using your own balances, rates, and payment plan.

A projection is an estimate, not a lender statement. Actual interest may accrue daily, and fees, payment timing, changing minimums, or promotional rates can change the result. Check the terms and current payoff information with each lender.

Plan the worksheet before entering formulas

Start with accurate account information. For each debt, record the current balance, annual percentage rate (APR), and required minimum payment. Put the accounts in ascending balance order so the first debt in the schedule is the first snowball target. Do not include a mortgage or other account just because it exists: include debts you intend to track, and label them clearly.

Use the balance and minimum payment from a recent statement or account portal.
Enter an APR as a percentage, such as 18%, rather than the number 18.
Choose a planned total monthly debt budget: the combined minimums plus the amount you intend to pay above them.
Keep a note of assumptions, such as whether the estimate excludes fees or new charges.

For the worked setup below, the debt list has three accounts and the total planned monthly budget is $270. The budget is held constant as accounts are paid off, so money no longer needed for one minimum can move to the next target. If your budget changes, update it deliberately rather than relying on an old projection.

Set up the input table and payment schedule

In a blank Excel workbook, label cells A3:D3 Debt, Starting balance, APR, and Minimum payment. Enter Card B in row 4 with a balance of $800, an APR of 18%, and a minimum of $35; Card A in row 5 with $1,200, 24%, and $45; and Personal loan in row 6 with $2,000, 12%, and $90. These figures are illustrative only. Put Planned monthly debt budget in F3 and enter $270 in G3.

Starting in row 9, create the schedule headers below. Each debt has six columns: opening balance, interest, minimum, snowball extra, payment, and closing balance. Column A is the month, and column T is the planned budget.

Columns B:G: Card B, in the first snowball position.
Columns H:M: Card A, in the second position.
Columns N:S: Personal loan, in the third position.
Column T: planned monthly debt budget.

Use clear headers, currency formatting for balances and payments, and percentage formatting for APRs. Enter the first month in A10 and later month labels in the rows below. You can also add a separate notes column for payment dates or lender-specific details. In Excel for Microsoft 365 on Windows, the formulas below use standard comma separators. Excel for Mac uses the same functions; depending on regional settings, Excel may display a different argument separator.

Add formulas for interest, minimums, and the snowball

The example estimates monthly interest as opening balance multiplied by APR divided by 12. It applies the minimum payment first, then assigns remaining budget to debts in their listed order. For each formula below, the cell layout is the one just described, with inputs in rows 4–6 and the first schedule month on row 10.

With the debt names in A4:A6, balances in B4:B6, APRs in C4:C6, minimums in D4:D6, and the planned budget in G3, enter the opening Card B balance in B10:

=$B$4

With the same input layout and Card B opening balance in B10, calculate that month’s estimated interest in C10:

=B10*$C$4/12

With the same layout, Card B’s opening balance in B10, and interest in C10, cap the minimum payment at the amount due in D10:

=MIN($D$4,B10+C10)

With minimums in D10, J10, and P10 for all three debts, the budget in T10, and Card B’s opening balance and interest in B10 and C10, calculate the extra payment for the first debt in E10:

=MIN(MAX(0,$T10-SUM($D10,$J10,$P10)),B10+C10-D10)

With Card B’s opening balance in B10, interest in C10, minimum in D10, and extra in E10, calculate its total payment in F10 and its closing balance in G10:

=MIN(B10+C10,D10+E10)

=MAX(0,B10+C10-F10)

For Card A, use H10 for opening balance, I10 for interest, J10 for minimum, K10 for extra, L10 for payment, and M10 for closing balance. With Card A’s input values in row 5, calculate its extra in K10 after accounting for Card B’s extra:

=MIN(MAX(0,$T10-SUM($D10,$J10,$P10)-$E10),H10+I10-J10)

For the personal loan, use N10:S10 for opening balance through closing balance. With its input values in row 6 and the first two debts’ extra payments in E10 and K10, calculate the loan’s extra in Q10:

=MIN(MAX(0,$T10-SUM($D10,$J10,$P10)-$E10-$K10),N10+O10-P10)

Use the same pattern for the other debt groups: interest is opening balance times that debt’s APR divided by 12; minimum is the smaller of its stated minimum and balance plus interest; payment is the smaller of balance plus interest and minimum plus extra; closing balance is the greater of zero and balance plus interest minus payment. For example, with Card A’s opening balance in H10, APR in C5, and interest in I10, calculate interest in I10 using:

=H10*$C$5/12

With the same input layout, opening balance in H10, interest in I10, and minimum input in D5, calculate Card A’s capped minimum in J10:

=MIN($D$5,H10+I10)

For each remaining debt, use its corresponding opening, interest, minimum, extra, payment, and closing cells. Set T10 to the planned budget:

=$G$3

In month two, the opening balance for each account should equal its previous month’s closing balance. With the first month’s closing balances in G10, M10, and S10, enter these formulas in the next schedule row:

=G10

=M10

=S10

Those formulas go in B11, H11, and N11 respectively. Copy the remaining row 10 formulas down for future months, ensuring each row refers to its own opening balance and budget. Check the references after copying: the input APRs, minimums, and planned budget should remain fixed, while monthly schedule references should advance to the new row.

Check the first month with a worked example

With the sample inputs, opening balances total $4,000. Estimated first-month interest is $12 on Card B, $24 on Card A, and $20 on the personal loan: $56 altogether. The minimums total $170, leaving $100 of the $270 budget for the snowball target, Card B.

Card B receives its $35 minimum plus $100 extra, for a $135 payment and a projected closing balance of $677 ($800 + $12 − $135). Card A receives $45 and ends at $1,179 ($1,200 + $24 − $45). The loan receives $90 and ends at $1,930 ($2,000 + $20 − $90). The ending balances total $3,786, which also matches $4,000 opening debt plus $56 estimated interest minus $270 paid. This check is useful for spotting a missing payment or a formula that allocated more than the budget.

Make the projection more useful and easier to maintain

Keep the worksheet understandable for the person who will update it. Add a date or month label to each row, freeze the input section visually with borders or fill colors, and distinguish typed inputs from calculated cells. You can use Excel’s Home > Conditional Formatting menu to highlight a closing balance of zero, but treat that formatting as a visual aid rather than proof that a lender has recorded a payoff.

Update actual balances and required minimums from statements or account portals. If you record actual payments, add an actual-payment column or a separate transaction log; do not overwrite a formula cell without noting the change. Compare the projection with statements each month. For an account with a changing minimum, update its input and review the planned budget so it still reflects the amount you intend to pay overall.

This schedule assumes one monthly interest calculation, no new purchases, no fees, and payments applied in the modeled month. Those assumptions make it suitable for planning, not an exact payoff quote. A card may calculate interest using a daily balance, and a lender may apply a payment on a different date. Promotional APRs, penalty rates, late fees, or a final payment smaller than the usual amount can also change timing.

Snowball versus avalanche and other options

A snowball spreadsheet orders accounts by balance. An avalanche version uses the same basic structure but orders debts by APR, highest first, while still paying minimums on the rest. Comparing two copies of the workbook can show how the projected payoff order and interest estimate differ under the same budget. The result depends on the inputs and simplifying assumptions, so it should not be presented as a guaranteed savings figure.

Another option is a lender’s repayment calculator or a nonprofit credit counselor’s budgeting tools. A spreadsheet is flexible and makes assumptions visible, but it requires maintenance. A calculator can be quicker for a one-time estimate, but may not provide the same account-by-account monthly record. For questions about your specific loan terms or options, check with the lender or a qualified professional. This article is educational and is not financial, tax, or legal advice.

Common spreadsheet problems to avoid

Wrong debt order: Sort by current balance for the snowball method, and recheck the order when balances change substantially.
Budget counted twice: The planned budget is the total monthly amount for all debts, not an extra amount on top of the minimums.
Negative balances: Cap payments at the balance plus modeled interest, as the formulas do, so a final payment does not create a negative closing balance.
Interest mistaken for a quote: Monthly APR divided by 12 is an estimate; verify exact amounts and payoff dates with the lender.
Missing new activity: New charges, cash advances, fees, or late payments can invalidate the projection. Record them or revise the assumptions.
Copied formulas with broken references: Check that input references stay fixed and row references move down as expected.

Frequently Asked Questions

What is the best spreadsheet layout for a debt snowball?

Use an input table for each debt’s balance, APR, and minimum payment, followed by a monthly schedule with opening balance, interest, minimum, extra payment, total payment, and closing balance. Put the smallest balance first and keep the planned total monthly budget visible.

Should I use the snowball or avalanche method in my spreadsheet?

A snowball sorts debts by balance, smallest first. An avalanche sorts them by interest rate, highest first. You can duplicate the workbook and compare projections, but actual costs depend on lender terms, payment timing, and account activity.

Does Excel have a debt snowball template?

Excel may offer templates through its template gallery, but availability can vary. You can also build the basic tracker with ordinary cells and formulas as shown here, which makes the assumptions and payment order easier to inspect.

How accurate is monthly interest calculated as APR divided by 12?

It is a simplified estimate. Some lenders calculate interest daily or use other terms, and fees or payment dates can affect the balance. Use lender statements or payoff information for exact amounts.

What should I do when a debt is paid off?

Confirm the payoff with the lender, then stop including that account’s minimum in future calculations and direct the available budget to the next debt in the chosen order. Keep the planned total budget consistent if that is still the amount you intend to pay.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.