Debt Snowball Spreadsheet: Set It Up in Excel

How-to basics · Updated November 21, 2026

Set up a debt snowball spreadsheet in Excel by listing debts from smallest balance to largest, then building a monthly schedule that pays every minimum and sends the remaining budget to the first unpaid debt. When that balance reaches zero, the formulas roll the available money to the next debt. You will need current balances, APRs, minimum payments, and a monthly amount you can consistently budget for debt payments. The example below uses three debts and estimates interest monthly; check each lender’s terms before relying on a payoff projection.

What You’ll Need

  • Excel for Microsoft 365 on Windows. The steps also work in recent desktop versions of Excel that support the functions used here; no special add-ins are needed.
  • A current balance, APR, and required minimum payment for each debt. Check recent statements or your lender’s account rather than relying on old estimates.
  • Your planned monthly debt-payment budget: the sum of all minimum payments plus any extra you can afford to pay consistently.
  • A few minutes to create two worksheets, named Inputs and Schedule. The worked example uses three debts, but you can extend the same pattern for more.

Step-by-Step

  1. Gather the numbers and choose a snowball order. Record each debt’s current balance, annual percentage rate (APR), and required minimum. Sort the debts by balance from smallest to largest, ignoring APR for the order. For example, suppose Card A is $600 at 24% APR with a $30 minimum, Card B is $1,200 at 18% with a $40 minimum, and a loan is $2,000 at 12% with a $75 minimum. The minimums total $145. If you can budget $245 a month for debt, the planned extra is $100. The figures are illustrative, not a recommendation about how much to pay.
  2. Build the Inputs worksheet. Rename the first sheet Inputs. Enter the headings Debt, Starting balance, APR, and Minimum payment in A1:D1. Put Card A on row 2, Card B on row 3, and the loan on row 4, keeping the ascending-balance order. Enter APRs as percentages, such as 24%, and amounts as numbers. Format the balance and minimum-payment columns as Currency using Home > Number. Keep the balance as a positive number; the schedule will calculate reductions.
  3. Create the Schedule worksheet and its headings. Add a second worksheet and name it Schedule. Put Month in A1, Budget in B1, and Extra pool in C1. Use five columns for each debt, in this order: Opening, Interest, Minimum, Extra, Ending. Put those headings in D1:H1 for Card A, I1:M1 for Card B, and N1:R1 for the loan. You can add debt names above each group, or use the debt name in the heading, such as “Card A Opening.” This repeated layout makes it possible to see how each balance changes each month.
  4. Set up the first month’s row. In row 2, enter a month label in A2 and the full planned debt budget, $245 in this example, in B2. With the Inputs table in A1:D4, enter =Inputs!$B$2 in D2 to bring in Card A’s opening balance. With the same layout, enter =D2*Inputs!$C$2/12 in E2 to estimate one month of interest at one-twelfth of the APR. This is a planning approximation; many lenders calculate interest daily. With the same Inputs layout and Card A’s balance and interest in D2 and E2, enter =MIN(D2+E2,Inputs!$D$2) in F2. This caps the minimum payment at the amount due, so the sheet does not pay more than the balance plus estimated interest.
  5. Calculate the extra pool after minimums. The pool is what remains from the monthly budget after the scheduled minimums for all debts. With Card A’s minimum in F2, Card B’s in K2, the loan’s in P2, and the monthly budget in B2, enter =MAX(0,B2-SUM(F2,K2,P2)) in C2. The example returns $100: $245 budget minus $30, $40, and $75 in minimums. If the budget is lower than the minimums, this formula shows zero rather than inventing money; adjust the budget and address any payment shortfall with the lenders.
  6. Allocate the pool to the smallest debt first. With Card A’s opening balance, interest, and minimum in D2:F2 and the pool in C2, enter =MIN(MAX(0,D2+E2-F2),$C2) in G2. In the example, Card A has $612 due after estimated interest and its $30 minimum, so this directs $100 of extra to it. With Card A’s values in D2:G2, enter =MAX(0,D2+E2-F2-G2) in H2 for its ending balance. The example returns $482: $600 plus $12 interest, less $30 minimum and $100 extra.
  7. Continue the allocation across the other debts. With Card B’s opening balance in I2, estimated interest in J2, and minimum in K2, enter =MIN(I2+J2,Inputs!$D$3) in K2. With its due amount, minimum, and the pool in C2, enter =MIN(MAX(0,I2+J2-K2),MAX(0,$C2-G2)) in L2. This gives Card B only the pool left after Card A’s extra. With Card B’s values in I2:L2, enter =MAX(0,I2+J2-K2-L2) in M2. In the example, Card B has $1,218 due, pays its $40 minimum and no extra, and ends at $1,178. For the loan, use N2 for opening, O2 for interest, P2 for minimum, Q2 for extra, and R2 for ending. With the loan’s opening in N2 and its APR and minimum in Inputs row 4, enter =N2*Inputs!$C$4/12 in O2 and =MIN(N2+O2,Inputs!$D$4) in P2. With the loan values in N2:P2 and the pool in C2, enter =MIN(MAX(0,N2+O2-P2),MAX(0,$C2-G2-L2)) in Q2, then enter =MAX(0,N2+O2-P2-Q2) in R2. The example loan has $2,020 due, pays its $75 minimum, and ends at $1,945. Check that the first month’s total payments are $245.
  8. Add the following month and roll payments forward. Enter the next month label in A3. With the first month’s budget in B2, enter =$B$2 in B3 to carry the same planned budget forward. With Card A’s first-month ending balance in H2, enter =H2 in D3. With Card B’s ending balance in M2, enter =M2 in I3; with the loan’s ending balance in R2, enter =R2 in N3. These openings use the previous month’s endings. In row 3, enter the same interest, minimum, pool, extra, and ending formulas as row 2, changing the row references from 2 to 3. The APR and minimum references to Inputs should remain locked with dollar signs. Copy the finished row 3 formulas down for as many months as you want to forecast.
  9. Check the payoff behavior and make the sheet readable. Once Card A’s ending balance is zero, its minimum becomes zero because the minimum formula is capped by the balance due. That leaves more of the fixed budget in the extra pool, which flows to Card B after any extra payment to Card A. Continue in the same order until each ending balance reaches zero. Format dollar columns as Currency, bold the headings, and use View > Freeze Panes > Freeze Top Row if you want the headings to stay visible while scrolling. On Mac, the same worksheet and formula setup applies; ribbon placement can differ slightly by Excel build. Excel for the web has the same basic formula behavior, though some ribbon controls may be arranged differently.

For the worked example, the first month’s estimated interest is $12 on Card A, $18 on Card B, and $20 on the loan. The minimums total $145, the extra pool is $100, and the ending balances total $3,605 ($482 + $1,178 + $1,945). This arithmetic is a useful check that the formulas are linked to the intended debt rows. It is not a promise of the actual statement balances: payment timing, daily interest, fees, and new charges can change them.

Common Mistakes

  • Sorting by APR instead of balance. The snowball method targets the smallest balance first. Keep the inputs ordered by balance when you begin, not by the highest interest rate.
  • Setting the budget below required minimums. The example assumes the planned monthly budget covers all minimums. A spreadsheet cannot make an inadequate budget sufficient; do not treat a zero extra pool as proof that every payment is covered.
  • Forgetting to cap payments at the amount due. Without the MIN checks, a formula can show an overpayment on a debt that is nearly paid off. The capped minimum and extra calculations prevent a negative ending balance.
  • Using relative references for input assumptions. If APR and minimum references shift when formulas are copied down, interest or minimums may pull from the wrong debt. Keep the input row references locked with dollar signs, such as Inputs!$C$2.
  • Assuming estimated interest exactly matches a statement. APR divided by 12 is a useful monthly estimate, not necessarily the lender’s calculation. Daily balances, statement dates, fees, and rate changes can all affect actual interest.
  • Continuing to add purchases to a card without recording them. New charges make the forecast inaccurate and may undermine the payoff plan. Record them in the balance assumptions or update the current balance and schedule regularly.

Tips

Keep the monthly budget realistic and consistent. If income varies, choose a baseline amount you can meet in an ordinary month and treat extra one-off payments separately. Update the balances and minimums from statements each month, then compare the projected ending amounts with actual balances. A small difference is expected when the lender’s interest method differs from the estimate.

Use clear labels and distinguish inputs from formulas. For example, apply a light fill color to cells you type into and another to calculated cells. Add a note near the APR column that rates are entered as percentages. If you add a debt, insert a complete five-column group and update the extra-pool formula so it includes that debt’s minimum. Also extend the extra-allocation logic in smallest-to-largest order; otherwise the new debt may not receive money in the intended sequence.

Keep a backup before changing the structure. Excel’s Undo can reverse many ordinary edits, but a separate copy is useful if you are experimenting with columns or overwriting formulas. You can use File > Save As to save a working copy with a different filename. Review the workbook after adding rows or debts to ensure formulas still point to the right inputs and prior-month endings.

Troubleshooting

The extra pool is zero when you expected money to remain. Check that B contains the full monthly budget and that the minimum cells F, K, and P contain the correct amounts. In this layout, the pool is budget minus all three minimums. If the budget is $245 and the minimums sum to $145, it should be $100. If minimums exceed the budget, increase the budget only if that is affordable; otherwise contact lenders about available payment arrangements rather than assuming the sheet resolves the shortfall.

A balance becomes negative or a payment exceeds what is due. Confirm that the minimum and extra formulas use MIN and that the ending balance uses MAX with zero. Check that each debt group references its own opening, interest, minimum, and extra cells. Do not manually type over an ending-balance formula to force a zero; correct the reference or update the opening balance instead.

The schedule does not move forward. Look at the opening balance in the new row. It should link to the previous row’s ending balance for that same debt: H to the next Card A opening, M to Card B, and R to the loan. If you copied formulas down, inspect a few rows for references that still point to row 2 rather than the prior row.

The projected payoff date differs from the lender’s information. Compare your current balance, APR, minimum, payment date, and any fees with the account statement. The monthly-interest approximation may be the main cause. Update the actual opening balances and minimums, and avoid treating a spreadsheet estimate as a lender quote. Confirm real payment amounts, due dates, and terms with each lender; seek a qualified financial professional if you need advice about your circumstances.

Frequently Asked Questions

Should I enter APR as 24 or 24%?
Enter 24% and format the cell as Percentage. Excel stores that as 0.24, so the formula that multiplies the balance by APR and divides by 12 estimates one month’s interest correctly. Entering 24 as a plain number would produce an incorrect result.

Can I use this setup for more than three debts?
Yes. Add another five-column group for each debt, keep the groups ordered from smallest starting balance to largest, and include its minimum-payment cell in the extra-pool calculation. Extend the extra formulas so each debt receives only what remains after allocations to the smaller debts.

What if a debt’s minimum payment changes?
Update its minimum on the Inputs sheet to the amount currently required, then review the monthly budget. The formulas cap the minimum at the estimated amount due, but they do not know when a lender changes a required payment unless you update the input.

Should I include a debt with a zero balance?
You can leave it out of the active schedule or keep it with a zero starting balance. If you keep it, its capped minimum and extra should remain zero. Update the debt list if a new balance appears, and ensure its position follows your chosen snowball order.

Does this spreadsheet account for fees, daily interest, or missed payments?
No. The sample estimates interest as APR divided by 12 and assumes scheduled payments happen as planned, with no new charges or fees. Those factors can change actual balances. Check account terms and statements, and revise the figures when circumstances change.

Is the debt snowball always the best repayment approach?
This sheet models the smallest-balance-first method; it does not compare every repayment strategy or account for personal priorities. It is a tracking tool, not financial advice. Check your lender terms and speak with a qualified professional if you need guidance tailored to your situation.

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.