Debt Snowball Calculator Spreadsheet: Free Excel Setup

How-to basics · Updated November 21, 2026

Yes. You can make a free debt snowball calculator spreadsheet in Excel by listing debts from smallest to largest, entering each balance, interest rate and minimum payment, then directing extra money to the smallest unpaid balance. The setup below works in Microsoft Excel for Microsoft 365 on Windows; Excel for the web can also be used, while desktop Excel may require a paid license.

What a free debt snowball spreadsheet does

A debt snowball spreadsheet organizes a payoff plan and estimates how balances may change over time. Its defining feature is the order of repayment: make the required minimum payment on each debt, then put any extra amount toward the debt with the lowest balance. When that debt is paid, roll its payment amount into the next smallest balance.

You do not need a paid template to use this method. A blank workbook is enough, and a simple sheet can make the order, monthly budget and changing balances easier to follow. If you choose a prebuilt workbook from another source, check that its formulas are visible and understandable, and that it does not require you to share account passwords or other sensitive information.

A spreadsheet is an estimate and planning aid, not a lender’s payoff statement. Actual interest and required payments can depend on payment dates, daily balance calculations, fees, promotional terms and other details in the loan or card agreement. Check current terms with each lender; for financial, tax or legal questions, consult a qualified professional.

How the snowball method works

First, make a list of debts that you intend to include, such as credit-card balances, personal loans or medical bills. Sort the list by current balance, from smallest to largest. Continue paying at least the required minimum on every debt, and choose a total monthly debt-payment budget that covers those minimums. The amount left over becomes the extra payment for the snowball target.

  • Smallest balance: gets the extra payment first, regardless of its interest rate.
  • Other debts: continue receiving their minimum payments while the target is being paid down.
  • After payoff: the former target’s payment capacity is added to the amount available for the next target.

This order is different from the debt avalanche method, which directs extra money to the debt with the highest interest rate. The snowball emphasizes visible progress from clearing smaller balances. That can be motivating, but it does not necessarily minimize interest. A spreadsheet helps make the trade-off visible; it does not make one approach universally best.

Set up the free Excel calculator

Open a blank workbook and enter the monthly amount you can devote to these debts in cell B1. In A2:D2, add the headings Debt, Starting balance, APR and Minimum payment. Enter one debt per row in A3:D7, or extend the range if you have more debts. Sort the rows by starting balance, smallest first. Keep the debt rows in that order throughout the schedule so the extra payment is allocated in snowball order.

For a sample, use a monthly debt budget of $300 and these three debts: a $250 balance at 12% APR with a $25 minimum, a $1,200 balance at 18% with a $40 minimum, and a $3,000 balance at 18% with a $90 minimum. The starting balances total $4,450, and the minimum payments total $155, leaving $145 for extra payments in the first month. These figures are illustrative, not a recommendation about how much to pay.

Use E2:I2 for the first month’s schedule headings: Beginning balance, Interest, Minimum due, Extra payment and Ending balance. For the first month, the beginning balance is the starting balance. Interest is approximated as the beginning balance multiplied by the APR divided by 12. The minimum due is capped at the amount owed, so the schedule does not show a payment larger than the balance plus that month’s modeled interest.

Excel formulas for a one-month snowball schedule

With starting balances in B3:B7, APRs in C3:C7, minimum payments in D3:D7, a monthly budget in B1 and the first-month columns E:I arranged as described, enter the starting-balance formula in E3 and fill it down through E7:

=B3

With the same cell layout, calculate approximate monthly interest in F3 and fill it down through F7:

=E3*C3/12

With minimum payments in D3:D7 and the first-month balance-plus-interest in E3:F7, calculate each capped minimum due in G3 and fill it down through G7:

=MIN(E3+F3,$D3)

With monthly budget in B1, minimum dues in G3:G7, and the extra-payment column in H, enter this formula in H3 and fill it down through H7. It allocates the extra pool in row order; each row subtracts extra already assigned to earlier debts:

=MIN(MAX(0,$B$1-SUM($G$3:$G$7))-SUM($H$2:H2),MAX(0,E3+F3-G3))

With beginning balance, interest, minimum due and extra payment in E3:H7, calculate the ending balance in I3 and fill it down through I7:

=MAX(0,E3+F3-G3-H3)

The reference to the heading cell H2 in the extra-payment formula is intentional: Excel’s SUM ignores text, and filling the formula down makes each row subtract the extra payments already assigned above it. For the next month, create another five-column block, with the first month’s ending balance as the next month’s beginning balance. Keep the debt rows in the same order. The sample’s first-month interest is $2.50, $18 and $45. The $145 extra goes to the $250 debt: it receives $25 minimum plus $145 extra and ends at $82.50. The other debts end at $1,178 and $2,955. The three ending balances total $4,215.50.

Continue the schedule and update it monthly

For a second-month block in J:N, use Beginning balance, Interest, Minimum due, Extra payment and Ending balance. With the first-month ending balances in I3:I7, the APRs still in C3:C7, the updated minimums in D3:D7 and the budget in B1, the second-month beginning balance in J3 is:

=I3

With second-month beginning balances in J3:J7 and APRs in C3:C7, calculate interest in K3 and fill down:

=J3*C3/12

With second-month balance and interest in J3:K7 and minimums in D3:D7, calculate minimum due in L3 and fill down:

=MIN(J3+K3,$D3)

With the budget in B1, second-month minimum dues in L3:L7 and extra payments in M, enter this in M3 and fill down:

=MIN(MAX(0,$B$1-SUM($L$3:$L$7))-SUM($M$2:M2),MAX(0,J3+K3-L3))

With the second-month values in J:M, calculate the ending balance in N3 and fill down:

=MAX(0,J3+K3-L3-M3)

Repeat the same pattern for later months, referring each month’s beginning balances to the previous month’s ending balances. In practice, update the minimum-payment inputs from current statements: minimums can change as balances fall, and a fixed amount may not match the lender’s current requirement. If the monthly budget is below the sum of minimums, the sheet cannot represent a complete on-time plan; revisit the budget and contact lenders or a qualified credit counselor about options.

What the estimate leaves out

The formula APR divided by 12 is a convenient monthly approximation. Many credit-card issuers calculate interest using daily balances and a daily periodic rate, so the spreadsheet’s interest and payoff month can differ from the statement. The model also assumes the stated monthly budget is paid on schedule and does not automatically account for new purchases, late fees, annual fees, variable rates or promotional-rate expiration.

To make the plan more useful, enter balances and minimums from recent statements, record the payment due dates, and update the sheet after payments post. Do not treat a zero in a projected ending-balance cell as proof that an account is closed or fully settled. A final payoff amount can include interest accruing after the statement date. Ask the lender for its payoff figure when needed, and follow its instructions for closing or keeping an account open.

Snowball versus avalanche and other approaches

The snowball sorts debts by balance; the avalanche sorts by interest rate. For example, if the $250 debt in the sample had a lower rate than the $3,000 debt, snowball still pays the $250 balance first, while avalanche would generally prioritize the $3,000 debt if it carried the higher APR. With equal budgets and assumptions, prioritizing high-rate debt can reduce interest costs, while quick small-balance wins may help some people stay engaged. Results vary with rates, fees and payment timing.

Other approaches may fit a particular situation better. A borrower might focus on an account with a temporary promotional rate ending soon, or seek a structured repayment plan from a reputable nonprofit credit counselor. Consolidation or balance transfers can have fees, eligibility rules and new terms; moving balances does not erase what is owed. Compare written terms and costs, and do not assume that a lower advertised rate guarantees a lower total cost.

Common spreadsheet problems and safe use

  • Rows are not sorted: the formula sends extra money in row order, not by reading balances and choosing the smallest automatically. Re-sort carefully when setting up the plan, or keep the order fixed as balances change.
  • Budget is too low: check that the monthly budget covers all current minimum dues before counting any amount as extra.
  • Minimums are outdated: replace them with current statement amounts rather than assuming they stay constant.
  • Interest seems different: compare the model’s monthly approximation with the lender’s statement method and payment dates.
  • Workbook privacy: account names or labels can be generic. Do not store passwords, full account numbers or security answers in the file, and protect any copy shared or saved in a cloud location.

For readability, format balances and payments as currency and APR cells as percentages using Home > Number. Excel for Mac has a similar Home tab and number-format controls, though ribbon layout can vary by version. The formulas above use standard Excel references and work in Microsoft 365 for Windows and Excel for the web; Mac users can use the same formulas. Excel for the web’s menus may look different, but no special add-in or macro is required.

Frequently Asked Questions

Is there a free debt snowball calculator spreadsheet?
Yes. You can build one in a blank Excel workbook with the formulas above. Excel for the web is another option for working in a browser. If you download a template, inspect its payment order, interest assumptions and any fees before relying on its projections.

Does the debt snowball method save the most interest?
Not necessarily. It prioritizes the smallest balance, not the highest rate. The avalanche method often directs extra payments to the highest-rate debt and may reduce interest under comparable assumptions, but the result depends on actual terms and payment timing.

Should I include every debt in the spreadsheet?
Include the debts you intend to manage in this payoff plan, and make sure required payments on all accounts remain accounted for. Some obligations have special terms or consequences, so check those terms before changing how you pay them. A qualified professional can help with questions specific to your situation.

Why does my spreadsheet payoff date differ from my lender’s?
The sheet may approximate interest monthly, use an outdated minimum, or omit daily interest, fees, new charges and payment-posting dates. Use lender statements for current balances and required payments, and request a payoff amount directly from the lender when precision matters.

Can I use this calculator in Google Sheets?
The formulas shown use basic functions and references that are also available in Google Sheets, but menu paths and formatting controls differ. Check the workbook’s results after importing it, especially if a downloaded Excel template contains features beyond the formulas described here.

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.