Debt Snowball Spreadsheet: Build a Payoff Plan

How-to basics · Updated November 21, 2026

To make a debt snowball spreadsheet in Excel, list each debt’s current balance, APR, and minimum payment, then send any extra monthly payment to the debt with the smallest positive balance. A simple workbook can calculate monthly interest, payments, and ending balances so you can see how the payoff plan progresses.

What the debt snowball method does

The debt snowball is a debt repayment strategy that orders debts by balance, from smallest to largest. You continue making at least the required minimum payment on every debt, while directing money left over in your debt-payment budget toward the smallest balance. Once that debt is paid off, you add the payment you had been making on it to the amount directed to the next-smallest debt. The payment amount aimed at the next debt therefore grows over time, like a snowball.

The method focuses on balances, not interest rates. That distinction matters: a high-interest debt may cost more while you are paying off a smaller balance first. The appeal of the snowball is its visible milestones. Clearing an account can make the plan feel more manageable, but it does not guarantee the lowest total interest or the quickest payoff in every situation.

A spreadsheet helps make the trade-off visible. It can keep the debt order, payment assumptions, and month-to-month balances together. It is a planning aid, not a replacement for lender statements: actual interest and required payments can depend on payment dates, daily balance calculations, fees, and account terms.

Set up the workbook

In a blank Excel workbook for Microsoft 365 on Windows, create a table with one debt per row. Use these headings in row 1: Creditor, Current balance, APR, Minimum payment, Monthly interest, Payment, Ending balance, and Snowball target. Enter debts in rows 2 through 4 for the example below; add more rows if needed. Keep balances and payments as positive numbers, and enter APRs as percentages, such as 24% rather than 24.

  • Current balance: Use the balance you want to plan from, ideally checked against a recent statement.
  • APR: Enter the annual percentage rate as a percentage. If rates are variable, update this input when it changes.
  • Minimum payment: Enter the amount currently required by the lender. Review it each billing cycle because minimums can change.
  • Extra monthly amount: Put the amount available beyond all minimum payments in a clearly labeled input cell, such as B7. This example uses $200.

Keeping the extra amount separate is useful: the minimums are obligations on all accounts, while the extra amount is the part assigned according to the snowball order. Before relying on a budget number, account for essential expenses and irregular costs so the planned amount is one you can sustain.

Build the monthly formulas

The following example uses three debts: Card A has a $500 balance, a 24% APR, and a $35 minimum; Card B has a $1,800 balance, an 18% APR, and a $55 minimum; and a loan has a $4,000 balance, a 9% APR, and a $125 minimum. Put those values in A2:D4, with the APR in column C, and enter 200 in B7 as the extra monthly amount. The sample uses a simple monthly interest estimate, APR divided by 12; the lender’s actual calculation may differ.

With the balances in B2:B4 and annual APRs in C2:C4, enter this in E2 and copy it down through E4 to estimate one month of interest. For Card A, the result is $10.00 ($500 × 24% ÷ 12).

=B2*C2/12

With current balances in B2:B4, put this formula in H2 and copy it through H4 to mark the smallest positive balance as the target. It uses MINIFS, available in Excel 2019 and Microsoft 365. The first row wins if two debts have the same smallest balance. In the example, H2 returns Target and H3:H4 are blank.

=IF(AND(B2>0,COUNTIF($B$2:B2,B2)=1,B2=MINIFS($B$2:$B$4,$B$2:$B$4,">0")),"Target","")

With monthly interest in E2:E4, minimum payments in D2:D4, the target label in H2:H4, and the extra amount in B7, enter this in F2 and copy it down. For Card A, the result is $235: its $35 minimum plus the $200 extra. The MIN function prevents a payment from exceeding the modeled balance plus interest.

=MIN(B2+E2,D2+IF(H2="Target",$B$7,0))

With the starting balance in B2, estimated interest in E2, and payment in F2, enter this in G2 and copy it down. Card A’s modeled ending balance is $275 ($500 + $10 − $235). For Card B, interest is $27, the payment is $55, and the modeled ending balance is $1,772. For the loan, interest is $30, the payment is $125, and the ending balance is $3,905.

=MAX(0,B2+E2-F2)

The example allocates $415 in total: $215 in minimums plus $200 extra. Together, the modeled ending balances are $5,952. These are estimates for one planning month, not lender payoff quotes. Formatting the balance and payment columns as currency and the APR column as a percentage makes common entry mistakes easier to spot.

Update the plan month by month

For a practical tracker, preserve each month’s ending balances and use them as the next month’s starting balances. One straightforward layout is a separate worksheet for each month, or a repeated block of columns for each month on one sheet. At the start of a new month, copy the previous month’s ending balances into the new month’s current-balance column, update minimum payments and APRs if needed, and recalculate the target. The target should be the smallest balance that is still above zero.

After the first debt is paid, the old target’s minimum payment is no longer needed for that account. To keep the planned debt-payment budget steady, add that freed-up amount to the extra amount aimed at the new target. For instance, if the former target had a $35 minimum, the next month’s extra allocation could rise from $200 to $235, provided the overall amount you can afford has not changed. Keep making required minimum payments on the other debts.

If a payment clears a debt partway through a billing period, the simple row-by-row formulas do not automatically redirect leftover money to a second debt in that same month. They cap the target payment at the modeled amount due, but leave the unused portion unassigned. Record what actually happened, then include any available leftover in the next payment plan—or calculate a same-month rollover separately after checking due amounts and lender rules.

Excel recalculates formulas as inputs change. If you want a fixed historical record, save a monthly copy or copy the calculated results and use Paste Special > Values in a history area. In Excel for Microsoft 365 on Windows, Paste Special is available from Home > Paste > Paste Special. On Mac, use Home > Paste > Paste Special or the Edit menu; exact menu presentation can vary by Excel release. Keep a separate editable copy of the formulas before replacing them with values.

Snowball versus avalanche

The debt avalanche method sends extra money to the debt with the highest interest rate, while still paying minimums on all other debts. Paying high-rate balances first can reduce interest under comparable assumptions, but the exact result depends on balances, rates, fees, and payment timing. The snowball instead prioritizes the smallest balance, which can produce an early account payoff even if that account does not have the highest APR.

A spreadsheet makes it easier to compare the approaches without assuming one is right for everyone. Duplicate the plan, change the target rule to highest APR for the comparison version, and use the same starting balances, minimums, and total monthly budget in both. Compare projected payoff timing and estimated interest, while remembering that a simple APR/12 model is not a lender’s exact accounting. If motivation from early progress is important to you, that may also influence which approach feels workable.

Common spreadsheet problems

  • Forgetting a debt: Include every account in the ordering and minimum-payment total, including debts with promotional rates or a zero current balance if a payment is still due.
  • Entering APR incorrectly: A cell containing 24 instead of 24% makes the interest estimate one hundred times larger. Format APR cells as percentages and check representative entries.
  • Leaving out fees or changing minimums: The example estimates interest only. Late fees, annual fees, new charges, and lender-specific minimum calculations can change the actual balance and payment due.
  • Using old balances: Update from current statements or account information. An estimate that starts from an outdated balance can drift quickly.
  • Counting the same money twice: The extra amount in B7 should be additional to the minimum payments, not the entire monthly debt budget. If $415 is the total budget in the example, the extra is $200 only because minimums total $215.
  • Assuming a projected zero is a payoff quote: Ask the lender for the amount needed to pay an account in full on a particular date. Interest can accrue between statement date and payment posting.

For a basic visual check, select the balance cells and use Home > Conditional Formatting > Highlight Cells Rules > Less Than to identify balances below a chosen threshold. This is optional; the formulas work without formatting. Avoid treating color as proof that an account is paid: confirm the balance and status with the lender.

Make the workbook safer and more useful

Enter only information needed for the plan. A creditor nickname is usually enough; the spreadsheet does not need full account numbers, passwords, or security answers. If the workbook contains sensitive financial details, store it in a location protected by your device and account security, and be thoughtful about shared folders or email attachments. Excel workbook protection can help prevent accidental edits, but it should not be treated as a substitute for secure storage.

Useful additions include a notes column for due dates or promotional-rate end dates, a field for the statement date, and a separate record of actual payments. Do not assume that a promotional APR will remain in place or that a balance transfer is cost-free: check the agreement for fees, expiry dates, and what happens after an offer ends. A plan should be revised when terms, income, expenses, or minimum payments change.

Debt repayment decisions can have consequences beyond a spreadsheet’s calculations. This article offers general educational information, not financial, tax, investment, or legal advice. Check actual balances, rates, payment requirements, and payoff terms with each lender; consult a qualified professional for guidance about your circumstances.

Frequently Asked Questions

What should a debt snowball spreadsheet include?
At minimum, list each debt’s current balance, APR, required minimum payment, snowball order, and planned payment. Adding estimated interest and ending balance helps you track progress, while actual lender statements should remain the source for amounts due.

Should I include interest in the snowball order?
The standard snowball order is based on current balance, from smallest to largest, rather than interest rate. Interest still matters to the projected balances and total cost, so include APR in the tracker even though it does not decide which balance is targeted.

Do I pay minimums on all debts with the snowball method?
Yes. The method directs extra money to one target, but you generally continue making at least the required minimum on every other debt. Follow each lender’s due dates and requirements.

Why does my spreadsheet balance differ from my statement?
A simple estimate using APR divided by 12 may not match a lender’s daily interest calculation, payment posting date, fees, new charges, or minimum-payment rules. Compare the spreadsheet with current account information and update the assumptions rather than treating the estimate as authoritative.

Can I use the same spreadsheet for the debt avalanche?
Yes. Keep the same debts and monthly budget, but change the target rule to the highest APR among balances above zero. Comparing otherwise identical plans can show how the target order changes projected balances and interest estimates.

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.