Free Snowball Debt Spreadsheet: Formulas and Setup

Formulas & functions · Updated November 21, 2026

Yes. You can build a free snowball debt spreadsheet in Excel with a blank workbook and the formulas below: enter each balance, APR, and minimum payment, then use a monthly budget formula to pay minimums on every debt and send the remaining money to the smallest balance first. The example is a one-month planner you update each cycle, not a downloadable file or a substitute for your lenders’ payoff figures.

What the debt snowball method does

The debt snowball orders debts by their current balance, from smallest to largest. You make at least the required minimum payment on each account, then direct any extra amount in your debt-payment budget to the smallest balance. Once that balance is cleared, you direct the freed-up payment toward the next-smallest debt. The growing payment can feel like a snowball gaining momentum.

This method prioritizes balance size, not interest rate. A different method, often called the debt avalanche, directs extra payments to the debt with the highest interest rate. The two methods can produce different interest costs and payoff timelines. A snowball plan may offer the motivating experience of clearing smaller accounts sooner, but that is not a guarantee that it will cost less. Compare both approaches using your actual balances, rates, fees, and payment requirements.

Make a free workbook and set up the columns

In Excel for Microsoft 365 on Windows, open a blank workbook and create these headings in row 1. Enter one debt per row, using rows 2 through 4 for the example; add rows if you have more accounts.

  • A: Debt name
  • B: Current balance
  • C: APR, entered as a percentage
  • D: Required monthly minimum
  • E: Estimated monthly interest
  • F: Minimum due for the month, capped at the amount owed
  • G: Amount remaining after the minimum payment
  • H: Extra-payment capacity used by smaller debts above this row
  • I: Planned payment
  • J: Estimated ending balance

Put your total monthly debt-payment budget in K1 as a label and K2 as an amount. This budget means the total you can pay across the listed debts this month, including minimums, not extra money on top of minimums. Sort the active debts by balance from smallest to largest before using the formulas. For the example, enter a $500 balance at 24% APR with a $30 minimum, a $1,200 balance at 18% with a $50 minimum, and a $3,000 balance at 12% with a $90 minimum. Put $300 in K2.

Enter formulas for interest and minimums

With the first debt’s balance in B2 and its APR in C2, enter this in E2 and fill it down through E4. The example estimates one month of interest on the $500 debt as $10: $500 × 24% ÷ 12.

With balances in B2:B4 and APRs in C2:C4, enter =B2*C2/12 in E2 and fill down. For the example, E2:E4 returns $10, $18, and $30, respectively.

This is a simplified monthly estimate using APR divided by 12. Actual interest may be calculated daily, and the timing of payments, fees, promotional rates, or lender rules can change the amount. Treat the result as a planning estimate, not a payoff quote.

With the current balance in B2, estimated interest in E2, and required minimum in D2, enter the following in F2 and fill down. It returns $30 for the first example debt. If a balance plus estimated interest is less than the stated minimum, the formula caps the planned minimum at that amount.

With the same row layout, enter =IF(B2>0,MIN(D2,B2+E2),0) in F2 and fill down. In the example, F2:F4 returns $30, $50, and $90.

Calculate the extra payment and ending balance

With the month’s interest in E2 and minimum due in F2, enter this in G2 and fill down. It calculates how much of each debt’s estimated amount due is still available for an extra payment after the minimum. For the smallest debt, the result is $480: $500 balance + $10 estimated interest − $30 minimum.

With B2, E2, and F2 holding the first debt’s balance, interest, and minimum, enter =MAX(0,B2+E2-F2) in G2 and fill down. The example returns $480, $1,168, and $2,940 in G2:G4.

Enter 0 in H2. With extra-payment capacities in G2:G4, enter the following in H3 and fill down. H records the capacity of debts ordered before the current row, so extra money is assigned to the smallest debt first. In the example, H3 is $480 and H4 is $1,648 ($480 + $1,168).

With capacities in G2:G4, enter =SUM($G$2:G2) in H3 and fill down through H4. This returns $480 in H3 and $1,648 in H4; H2 is entered as 0.

With minimums in F2:F4, prior capacity in H2, the current debt’s capacity in G2, and the total budget in K2, enter this in I2 and fill down. It pays each minimum, then assigns available extra to the earliest debt in the sorted list, without exceeding that debt’s estimated amount due. The example produces payments of $160, $50, and $90.

With the layout above and the total monthly budget in K2, enter =F2+MIN(G2,MAX(0,$K$2-SUM($F$2:$F$4)-H2)) in I2 and fill down. The calculation sets aside $170 for minimums, leaving $130 extra. The first debt receives $30 minimum + $130 extra = $160; the remaining debts receive $50 and $90.

With the balance in B2, estimated interest in E2, and planned payment in I2, enter this in J2 and fill down. It estimates the balance after this month’s interest and payment. The example returns $350 for the first debt, calculated as $500 + $10 − $160.

With B2, E2, and I2 in the same row, enter =MAX(0,B2+E2-I2) in J2 and fill down through J4. The estimated ending balances are $350, $1,168, and $2,940. Together they total $4,458, which also checks against $4,700 in starting balances + $58 estimated interest − $300 in planned payments.

Update the tracker each month

The formulas estimate one payment cycle. To plan the next cycle, use the ending balances from column J as the new balances in column B, then sort active debts by their new balances from smallest to largest. Copy the results as values when replacing the old balances so that the current-period calculations do not become circular. In Excel, copy the ending-balance cells, then use Home > Paste > Paste Values. Sort the full debt rows together, not just the balance column, so each balance stays matched to its APR and minimum.

Update minimum payments when your statements change, and update K2 if your budget changes. Check that K2 is at least as large as the total minimums in F2:F4. The example formula protects against assigning negative extra payments, but it does not reduce all minimums proportionally if your budget is too small to cover them. If you cannot make required payments, contact the lenders promptly to ask about available options rather than relying on the planner to resolve a shortfall.

Understand the limits of a spreadsheet estimate

A spreadsheet can organize a plan, but its numbers may differ from the balances shown by a lender. Credit-card interest, for example, may accrue daily; a lender may apply payments on different dates, charge fees, or calculate interest under terms that are not captured by APR divided by 12. The formulas also assume the APR remains steady during the month and do not include new purchases, late charges, or balance-transfer fees.

Use the tracker to compare a plan with your statements, not as the amount to send for a final payoff. For an exact payoff amount or the effect of a payment date, check the account terms and contact the lender. For help with a debt plan or questions about your financial circumstances, consult a qualified professional. This spreadsheet is an organizational example, not financial, tax, investment, or legal advice.

Make the sheet easier to read

Apply currency formatting to balances and payment columns, and percentage formatting to APR. In Excel for Microsoft 365 on Windows, select the relevant cells and use Home > Number to choose a currency or percentage format. You can freeze the heading row with View > Freeze Panes > Freeze Top Row, which keeps the column names visible while scrolling. These are display changes; they do not alter the calculations.

Consider adding a notes column for statement dates or promotional-rate end dates. Avoid putting full account numbers, passwords, or security answers in the workbook. If you store it in cloud storage or share it, use an account and sharing settings appropriate for sensitive financial information. Keep a separate copy before major edits if you want a simple way to recover earlier figures.

Snowball versus avalanche and other options

To compare snowball with avalanche, duplicate the sheet and sort the second copy by APR from highest to lowest. The formulas still allocate extra payments to the first row, so the changed order models an avalanche priority. Keep minimum payments current in either version. Because this example uses estimated monthly interest and a single-cycle allocation, it is not a precise forecast of the date or total interest needed to eliminate every debt.

Other tools may suit different needs: a lender’s own payoff calculator can reflect account terms more closely, while a budgeting app may track transactions in addition to balances. A paper list or a basic spreadsheet without formulas can also work if you prefer manual updates. Check whether a third-party app charges a fee, connects to financial accounts, or shares data before using it. The Excel layout above requires no paid template, though access to Excel itself depends on the version or service available to you.

Frequently Asked Questions

Is there a free snowball debt spreadsheet with formulas? You can create one without buying a template by using a blank Excel workbook and the formulas in this guide. It calculates estimated monthly interest, minimum payments, extra-payment allocation, and ending balances for the example layout.

Should the smallest debt mean the lowest balance or lowest interest rate? In the debt snowball method, it means the lowest current balance. Sorting by highest APR instead models the avalanche approach. Keep those priorities distinct when arranging the rows.

Does the spreadsheet automatically show when I will be debt-free? No. This version calculates one month at a time; you carry the ending balances forward and update the plan. A payoff date would require additional assumptions about future rates, payments, fees, and account rules.

What if I have more than three debts? Add a row for each debt and extend the formulas and ranges, including the minimum-payment total in the payment formula, to cover all debt rows. Sort the full rows by balance before allocating extra money.

Can I use this in Excel for the web or on a Mac? The formulas use standard Excel functions and can be used in current Excel versions that support them, including Microsoft 365. Menu placement can differ by platform; the Windows ribbon paths above may not match Excel for Mac or Excel for the web exactly.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.