How to Make a Debt Snowball Spreadsheet in Excel (Step-by-Step)

You can build a working debt snowball spreadsheet in Excel or Google Sheets in about 15 minutes. Below is the structure that mirrors what our calculator does under the hood.

Step 1: Set up your debt list

In row 1, create headers:

• A1: Debt name
• B1: Starting balance
• C1: APR (%)
• D1: Minimum payment

List one debt per row, then sort by balance ascending — that's your snowball order.

Step 2: Add an "extra payment" cell

In a cell like G1, type your extra monthly payment. This is what makes the snowball roll.

Step 3: Build the monthly schedule

On a second sheet, create columns for Month, then for each debt: Starting balance, Interest, Payment, Ending balance. The formulas are:

• Interest = Starting balance × (APR / 12)
• Payment = Minimum (plus extra, if this is the target debt)
• Ending balance = Starting balance + Interest − Payment

The tricky part is logic for "when this debt is paid off, roll its minimum to the next one." That's where most homemade spreadsheets break.

Step 4: Add a running total row

Sum the ending balances across all debts each month. When that hits zero, you're debt-free.

Skip the work — use the calculator

Honestly, this is a lot of formula wrangling. The calculator above handles all of it and exports to CSV if you want a spreadsheet copy for your records.