Snowball Debt Payoff Spreadsheet: Free Excel Setup

How-to basics · Updated November 21, 2026

Yes—you can make a free snowball debt payoff spreadsheet in Excel by listing each debt, its balance, annual interest rate, minimum payment, and payoff priority. Pay every minimum, direct your extra monthly budget to the smallest balance first, then roll that amount to the next debt when the first is cleared. The formulas and worked example below create a useful month-by-month calculator without requiring a paid template.

What a debt snowball spreadsheet does

The debt snowball is a repayment method that orders debts by their current balances, from smallest to largest, rather than by interest rate. You keep paying the minimum required on every debt and put any extra repayment money toward the current smallest balance. Once that balance reaches zero, you add the money you had been paying toward it to the next debt’s payment. The growing payments are the “snowball.”

A spreadsheet helps make that sequence visible. It can show estimated interest, payments, and remaining balances over time, so you can see how a change in your monthly budget might affect the plan. It is a planning tool, not a statement from your lender: actual interest calculations, payment posting dates, fees, and minimum-payment rules can differ.

Can you get one free?

Yes. You can build the workbook yourself without buying a template. Microsoft Excel for the web is available at no cost with a Microsoft account, although it has fewer features than the desktop application. The formulas in this guide use standard Excel functions and work in Microsoft 365 for Windows; they also work in Excel for Mac and the web. Menus and some features can vary by platform, but no special add-in or macro is needed.

You may also find free downloadable templates online, but check what they calculate before entering sensitive financial information. A polished layout does not guarantee that a sheet handles interest, payment limits, or extra-payment rollovers correctly. Building a simple version lets you inspect the assumptions and adjust them yourself. Avoid entering account passwords, full account numbers, or other information the calculator does not need.

Set up the debt list and monthly budget

Start a blank workbook and set up one row per debt. Use columns for the debt name, opening balance, annual interest rate, required minimum payment, and snowball priority. Assign priority 1 to the smallest balance, 2 to the next smallest, and so on. If two debts have the same balance, choose which one goes first and give each a distinct priority number. Keep the priority order fixed; after one debt is paid off, the next unpaid debt in that order becomes the target.

Put your planned extra debt-payment budget in a separate cell, such as B3. This is the amount above the required minimums, not the total amount you can pay across all debts. Keep the inputs in the same units: enter rates as percentages, such as 24%, and balances and payments as dollar amounts. For an initial setup, a table like this is enough:

  • Column A: debt name
  • Column B: current balance
  • Column C: annual interest rate
  • Column D: minimum payment
  • Column E: snowball priority
  • Cell B3: monthly extra-payment budget

Use the minimum payment shown by the lender, and update it when the lender changes it. Some minimums vary as balances decline. For a more realistic forecast, make a new set of columns for each month, using that month’s opening balance and applicable minimum. Do not assume a lender will accept a payment below its stated minimum.

Enter the formulas for one month

For a basic one-month calculation, add columns F through J for interest, extra amount needed to clear the debt after its minimum, extra allocated, total payment, and ending balance. Assume debts are in rows 2 through 10 and B3 contains the extra budget. The simple interest estimate below uses one-twelfth of the annual rate; lender calculations may use daily balances or other terms.

With the opening balance in B2 and annual rate in C2, enter this in F2 to estimate one month of interest:

=B2*C2/12

With the estimated interest in F2 and the minimum payment in D2, enter this in G2 to calculate how much extra would be needed to clear the debt after its minimum payment:

=MAX(0,B2+F2-MIN(D2,B2+F2))

With the extra budget in B3, required extra amounts in G2:G10, and unique priority numbers in E2:E10, enter this in H2 to assign the extra budget according to snowball priority:

=MIN(G2,MAX(0,$B$3-SUMIFS($G$2:$G$10,$E$2:$E$10,"<"&E2)))

With the balance, interest, minimum, and allocated extra in B2, F2, D2, and H2, enter this in I2 to cap the total payment at the amount actually owed:

=MIN(B2+F2,D2+H2)

With the same opening balance and interest in B2 and F2, and the payment in I2, enter this in J2 for the ending balance:

=MAX(0,B2+F2-I2)

Copy the formulas in F2:J2 down through the debt rows. The SUMIFS formula subtracts the extra amounts required by debts with earlier priorities, so later debts receive only what remains in the extra budget. It does not redirect a lender’s minimum payment from a paid-off debt automatically; for the next month, update minimums as appropriate and make sure the amount you can pay is represented in your budget. Review the figures rather than assuming the sheet replaces lender instructions.

Worked example: three debts and $200 extra

Suppose the debts are a $500 balance at 24% APR with a $40 minimum, a $1,200 balance at 18% APR with a $75 minimum, and a $4,000 balance at 12% APR with a $110 minimum. Set their priorities to 1, 2, and 3, respectively, and put $200 in B3 as the extra budget. Using the monthly-interest estimate, interest for the first month is $10, $18, and $40. Those figures are each balance multiplied by the annual rate and divided by 12.

The first debt needs $470 beyond its minimum to be paid in full that month: $500 + $10 interest − $40 minimum. The $200 extra budget therefore goes entirely to that debt. Its total payment is $240 and its estimated ending balance is $270. The other two receive their minimums only, leaving estimated balances of $1,143 and $3,930. Check: $1,200 + $18 − $75 = $1,143; $4,000 + $40 − $110 = $3,930.

For the next month, use the prior month’s ending balances as the new opening balances, calculate interest again, and continue to pay minimums. Once the first balance is cleared, its former payment capacity can be added to the extra amount directed to priority 2. If the first debt is paid off partway through a month, the example formulas cap its payment at the amount owed, but do not model the exact date the lender receives or applies that payment. Real payoff timing can therefore differ.

Build a month-by-month forecast

To extend the calculation, give each month its own group of columns or create a separate worksheet for each month. Carry each debt’s previous ending balance forward as the next opening balance, then recalculate interest, payment, and ending balance. Keep a clear label for each month and preserve the original input values so you can compare your plan with the starting point.

At the start of each new month, check whether minimum payments changed, whether a promotional rate ended, or whether a fee or new transaction affected a balance. Update the inputs rather than blindly copying old minimums. The fixed priority sequence works when you have ranked debts from smallest to largest at the beginning: paid-off debts simply fall out of the sequence. If you add a new debt or correct an opening balance, review the order and adjust the priorities.

A forecast can estimate a payoff path, but a single monthly interest formula is not a precise lender payoff quote. Credit cards often accrue interest based on daily balances, and payment dates can affect the amount. A loan may have a fixed schedule, fees, or prepayment terms. For a payoff amount or the exact treatment of extra payments, check the account terms and contact the lender.

Snowball versus avalanche: which comparison matters?

The snowball method prioritizes the smallest balance. The debt avalanche method instead prioritizes the highest interest rate while paying minimums on the rest. If interest rates differ substantially, targeting the highest-rate debt first may reduce interest costs, all else being equal. The snowball’s appeal is its sequence of smaller balances being cleared sooner, which some people find easier to follow. Neither ordering changes the need to make required payments on every account.

You can compare both approaches in separate copies of the workbook by changing the priority numbers: sort by balance for the snowball and by APR, highest first, for the avalanche. Keep the extra budget and other assumptions identical so the comparison is meaningful. Treat the result as an estimate rather than a guaranteed saving or payoff date, because the sheet may not reflect lender-specific interest methods, fees, or changes in minimums.

Common spreadsheet mistakes and safety checks

Several small errors can make a payoff schedule look better than it is. Check these items before relying on a forecast:

  • Do not enter 24 instead of 24% for an APR. A value of 24 means 2,400% when Excel uses it in the interest formula.
  • Do not count the extra budget as the full monthly payment. The formula assumes minimums are paid separately and the extra amount is on top.
  • Do not allocate more than the remaining amount owed. The total-payment formula caps each payment at the balance plus estimated interest.
  • Do not overlook fees, new purchases, cash advances, or changing rates. Add them to the model if you are able to estimate them, and compare the sheet with actual statements.
  • Protect personal information. A payoff calculator needs balances and rates, not login credentials or full account numbers. Store the workbook somewhere you consider secure.

If results seem wrong, test one debt by hand: opening balance plus estimated interest minus payment should equal the ending balance, but never less than zero. Also verify that the total extra allocated across all debts is no greater than the extra budget. When you need an exact payoff amount, use the lender’s current figure rather than a spreadsheet estimate.

Frequently Asked Questions

Is there a free snowball debt payoff spreadsheet?
Yes. You can build one in Excel for the web or desktop Excel using the columns and formulas above. Free downloadable templates are another option, but inspect their assumptions and formulas before relying on their projections.

Does the debt snowball pay the least interest?
Not necessarily. It focuses on smallest balance first, while the avalanche method focuses on the highest interest rate first. When rates differ, the avalanche may cost less in interest, but the exact comparison depends on balances, rates, payments, and lender terms.

Should I include minimum payments in the extra budget?
No. In this setup, the extra budget is money beyond all required minimums. The spreadsheet calculates each debt’s minimum payment separately, then allocates the extra budget by priority.

Can Excel calculate exactly when I will be debt-free?
It can estimate a timeline if you build a month-by-month forecast, but the result may not match lender payoff dates. Interest methods, payment timing, fees, rate changes, and minimum-payment rules affect the actual schedule.

Can I use this spreadsheet in Excel for Mac or the web?
Yes. The formulas shown use standard Excel functions and are suitable for Microsoft 365 on Windows, Excel for Mac, and Excel for the web. The interface may look different, but the workbook logic is the same.

A free snowball workbook is most useful when its assumptions are visible and you update it alongside your statements. Use it to organize balances, priorities, and a planned extra amount; confirm payment requirements and payoff details with each lender. For financial, tax, investment, or legal advice specific to your circumstances, consult a qualified professional.

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.