Debt Snowball Spreadsheet: Build and Use One in Excel

How-to basics · Updated November 21, 2026

To create a debt snowball spreadsheet in Excel, list each debt from the smallest balance to the largest, enter your monthly debt-payment budget and minimum payments, then use formulas to estimate interest, allocate payments, and calculate ending balances. The example below is a one-month worksheet for Microsoft Excel for Microsoft 365 on Windows; update it with your lender’s current figures each month.

What the debt snowball method does

The debt snowball method orders debts by current balance, not interest rate. You keep making at least the required minimum payment on every debt and direct any money left in your chosen monthly debt budget to the debt with the smallest balance. When that debt is paid off, you add the amount you had been paying toward it to the payment on the next-smallest balance. This creates a growing payment—a snowball—as debts are cleared.

A spreadsheet helps make that sequence visible and lets you check how a planned payment might affect balances. It is a planning tool, not a lender statement or a guarantee of a particular payoff date. The real amount due can depend on the lender’s interest method, payment timing, fees, and account terms.

Set up the worksheet

Start with a blank workbook. Put your total monthly debt-payment budget in cell B1. This is the total amount you intend to pay across the debts in the sheet, not the extra payment alone. Add headers in row 4, then enter each debt on rows 5 through 7, ordered from the lowest balance to the highest:

  • A: Account name or a private label such as Card A.
  • B: Current balance, using the balance you want to plan from.
  • C: Annual percentage rate (APR), entered as a percentage, such as 24%.
  • D: Contractual minimum payment for the month.
  • E: Estimated interest for the month.
  • F: Effective minimum used in the calculation.
  • G: Estimated total payment allocated to the debt.
  • H: Estimated balance after that payment.

For a compact example, use these inputs: B1 is $500; row 5 is a $200 balance at 24% APR with a $35 minimum; row 6 is $1,200 at 18% APR with a $60 minimum; and row 7 is $3,000 at 12% APR with a $90 minimum. Enter the APRs as percentages, not whole numbers. Keep the rows sorted by balance; if balances change enough to alter the order, reorder the debt rows before calculating the next month.

Enter the monthly calculation formulas

First estimate monthly interest. With the starting balance in B5 and the annual APR in C5, enter this in E5, then fill it down through E7:

With starting balances in B5:B7 and APRs in C5:C7, enter in E5: =B5*C5/12. For the example, E5 returns $4, E6 returns $18, and E7 returns $30. These are simple monthly estimates based on APR divided by 12.

Next cap each minimum at the amount needed to clear that debt for the month, so the sheet does not assign a minimum payment larger than the balance plus estimated interest. With contractual minimums in D5:D7 and estimated interest in E5:E7, enter in F5 and fill down through F7: =MIN(D5,B5+E5). In the example, the effective minimums are $35, $60, and $90.

Allocate the budget’s extra amount to the first debt in the sorted list. With the monthly budget in B1, effective minimums in F5:F7, and the first debt on row 5, enter in G5: =MIN(B5+E5,F5+MAX(0,$B$1-SUM($F$5:$F$7))). The formula reserves the sum of all effective minimums and offers the remaining budget to the smallest debt, without paying more than its estimated amount due.

For the next debt, account for any extra payment already used above earlier minimums. With rows sorted smallest to largest and the first payment in G5, enter in G6, then fill down through G7: =MIN(B6+E6,F6+MAX(0,$B$1-SUM($F$5:$F$7)-SUM($G$5:G5)+SUM($F$5:F5))). As you fill down, Excel adjusts the final row in the two running ranges. The calculation sends unused extra budget onward if an earlier debt is paid off.

Finally, calculate the estimated ending balance. With the starting balance in B5, interest in E5, and payment in G5, enter in H5 and fill down: =MAX(0,B5+E5-G5). The MAX function prevents a negative displayed balance if a payment clears a debt.

Check the worked example

In the example, the minimum payments total $185, leaving $315 of the $500 budget for extra payments. The smallest debt accrues an estimated $4, so its estimated amount due is $204. The payment formula assigns that $204 to it, clearing it. Of the $315 extra budget, $169 was used above its $35 minimum; the remaining $146 goes to the second debt, on top of its $60 minimum.

The resulting payments are $204 to the first debt, $206 to the second, and $90 to the third. They total $500. Estimated ending balances are $0, $1,012, and $2,940 respectively: for example, the second balance is $1,200 plus $18 interest minus its $206 payment. This calculation assumes the payments are applied as planned and that the simple interest estimates are close to the lenders’ actual charges.

Use the sheet for the next month

This worksheet calculates one monthly allocation. At the start of the next month, replace each starting balance with a current figure from the account, update APRs and minimums if they changed, and sort the debts again by their new balances. Set the minimum for a paid-off account to zero and remove it from the active list when appropriate. Then recalculate the allocation.

Keep a dated copy of each month’s figures if you want to compare estimates with actual statements. A separate column for actual payment or statement balance can help explain differences, but avoid overwriting historical inputs if you want a useful record. If you build a longer monthly schedule, model each month’s starting balances from the prior month’s ending balances, while remembering that actual interest and payment posting dates may not match a simplified monthly estimate.

Common spreadsheet problems and limitations

  • The budget is below the minimums: The allocation formulas assume the budget covers all effective minimums. If it does not, they still show the minimums and can therefore imply payments exceeding the budget. Check that B1 is at least the total in F5:F7 before relying on the allocation.
  • The debts are not sorted: Extra payments go down the rows in order. If a smaller balance appears below a larger one, the result no longer follows the snowball method.
  • APR is mistaken for a monthly rate: Enter an annual APR such as 24%, not 2% or 24 as a whole number. The example divides the annual rate by 12, but lenders may calculate interest daily or use other terms.
  • Fees or promotional rates are ignored: A late fee, annual fee, cash advance, or expiring promotional APR may change the balance or the best payment plan. Add relevant charges only if you can represent their timing accurately, and verify account details with the lender.
  • Payments exceed the amount due: The formulas cap a payment at the estimated balance plus interest. They do not account for every lender rule about payment allocation, overpayments, or pending transactions.

Excel’s values are only as reliable as the inputs. Compare the worksheet with current statements and lender account information, and check the actual terms with the lender or a qualified professional. This spreadsheet is general educational information, not financial, tax, investment, or legal advice.

Snowball versus debt avalanche

The debt avalanche method directs extra money to the debt with the highest interest rate, while paying minimums on the others. It can reduce interest costs compared with paying the smallest balance first when rates and other terms are comparable, but the snowball method may provide quicker visible progress by clearing a small account early. Neither ordering rule removes the need to pay each minimum on time.

To compare the methods in this workbook, duplicate the sheet and sort the debts by APR from highest to lowest in the copy. The payment allocation formulas then direct extra money to the first row, so the duplicate estimates an avalanche order. Compare projected balances and interest cautiously: one-month calculations do not fully model lender-specific accrual, fees, changing minimums, or future changes in your budget.

Make the workbook easier to review

Use clear labels for the budget, dates, and units, and format balances and payments as currency and APR cells as percentages. Keep the original statement figures separate from calculated fields so you can see which values are inputs. For privacy, account labels such as Card A are usually sufficient; a payoff tracker does not need full account numbers or passwords.

You can also add a notes column for due dates or a reminder to check a promotional rate. Avoid treating a colored cell, chart, or projected payoff estimate as confirmation that a lender received or processed a payment. Confirm payments and balances in the lender’s own account records.

Frequently Asked Questions

Should I include every debt in a snowball spreadsheet?
Include the debts you intend to track, with current balances, APRs, and minimums. If an obligation has unusual terms, a required payment arrangement, or a promotional period, record those details and verify how it should be handled rather than assuming the simple formula covers it.

Does the debt snowball save the most interest?
Not necessarily. Snowball order is based on balance size, whereas avalanche order prioritizes the highest APR. The avalanche may cost less in interest under comparable conditions, while the snowball emphasizes clearing smaller balances first.

Why does my estimated balance differ from my statement?
The sheet uses a simplified APR-divided-by-12 estimate. A lender may accrue interest daily, post payments on different dates, include fees, or apply payments under account-specific terms. Use the statement or lender account as the authoritative balance.

What should I do when one debt is paid off?
Update the balance and minimum for the next calculation, set the cleared account’s active minimum to zero when it no longer requires a payment, and direct the freed-up payment capacity to the next-smallest balance. Continue making required payments on all active debts.

Can I use this in Google Sheets?
The basic functions shown, including MIN, MAX, and SUM, are also available in Google Sheets, but menus and some formatting details differ. This setup is written for Excel for Microsoft 365; check your spreadsheet app’s formula settings if it uses different argument separators.

Related

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.