Home › Templates › Debt payoff spreadsheet

Debt Payoff Spreadsheet: Snowball vs Avalanche

A free debt payoff spreadsheet for Excel and Google Sheets: type up to 10 debts with balance, APR and minimum payment, add an extra monthly amount, and it builds a month-by-month payoff schedule for both the snowball (smallest balance first) and the avalanche (highest APR first), with each debt's payoff month, total interest and your debt-free date side by side.

Download Excel template (.xlsx) 636 KB · no macros · Excel 2016+ and Google Sheets · v1.0, 31 Oct 2026

Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no bank connection: you type the balances yourself.

Preview: the Example Summary tab (fictional data). Six made-up debts totalling $42,150.00; minimums $930.00 a month plus $300.00 extra, so a fixed budget of $1,230.00 a month from Jan 2027.
Month 40debt-free with either method (Apr 2030)
$6,391.76total interest, snowball
$5,834.28total interest, avalanche
2 vs 1debts paid off in year 1, snowball vs avalanche
DebtBalanceAPRMinimumSnowball: order · payoffAvalanche: order · payoff
Card A (store card)$1,150.0027.49%$35.00#1 · month 4 (Apr 2027)#1 · month 4 (Apr 2027)
Card B (rewards card)$6,400.0023.99%$160.00#4 · month 23 (Nov 2028)#2 · month 19 (Jul 2028)
Car loan$9,800.006.9%$285.00#5 · month 27 (Mar 2029)#4 · month 27 (Mar 2029)
Personal loan$4,300.0013.5%$145.00#3 · month 14 (Feb 2028)#3 · month 22 (Oct 2028)
Medical payment plan$2,000.000%$100.00#2 · month 8 (Aug 2027)#6 · month 20 (Aug 2028)
Student loan$18,500.005.5%$205.00#6 · month 40 (Apr 2030)#5 · month 40 (Apr 2030)
Total$42,150.00$930.00debt-free: month 40debt-free: month 40
Example tabs: total balance by month, snowball vs avalanche. Both start at $42,150.00 and reach $0 in month 40 (Apr 2030). The lines almost overlap; after 12 months the avalanche balance is $175.29 lower.$0$5k$10k$15k$20k$25k$30k$35k$40k$45k0510152025303540MonthSnowballAvalanche

Chart: total balance from the Example Snowball and Example Avalanche tabs. The workbook draws the same comparison as a native line chart on the Summary tab.

What's inside the spreadsheet

TabWhat you typeWhat it calculates
Start hereNothingSteps, how the schedule works, colour key, limits, disclaimer
DebtsUp to 10 debts (name, balance, APR, minimum), extra payment (B4), method (B5), first payment month (B6)Monthly budget, this month's interest per debt, snowball and avalanche order, an input check and a note when a minimum does not cover the interest
Snowball, AvalancheNothingA 360-month schedule for each method: payment, interest and balance per debt, total paid and total balance each month
SummaryNothingSnowball vs avalanche side by side: debt-free month and date, total interest, total paid, debts paid off in year 1; payoff month and date per debt; this month's payment per debt for your method; a line chart of total balance
Example Debts, Example Snowball, Example Avalanche, Example SummaryAlready filledThe same tabs with six fictional debts, so you can see every formula working

This sheet plans the payoff. To find the extra money each month, start with a budget spreadsheet. Many people also keep a small cash buffer while paying debt down; the emergency fund tracker helps with that.

How to use it

  1. Open Debts. For each debt type a name, the balance today, the APR (for example 24.99%) and the minimum payment from your latest statement.
  2. Type the extra amount you can pay each month in B4, on top of all minimums. 0 is fine.
  3. Pick Snowball or Avalanche in B5. Optional: type the month of your first payment in B6 to see real dates.
  4. Check that B7 says OK. If it does not, read the note in column J of the flagged row.
  5. Open Summary. Compare both methods in rows 10 to 17, then use the column Your plan: month 1 payment to see what to pay each debt this month.
  6. Each month, or after any change, type the new balances on Debts. The plan updates from there.

Snowball vs avalanche: how the order works

Both methods use one fixed monthly budget: every minimum payment plus your extra amount. Every debt gets its minimum. All money left over goes to one target debt. When the target is paid off, the money that paid it (its minimum plus the extra) rolls to the next debt in line. That rollover is what makes the payment on each later debt grow.

MethodTarget orderOrder in the example
SnowballSmallest starting balance firstCard A → Medical → Personal → Card B → Car → Student
AvalancheHighest APR firstCard A → Card B → Personal → Car → Student → Medical

The trade-off is interest against early wins. The avalanche pays the most expensive balance first, so it usually costs less interest. The snowball clears small balances first, so you see whole debts disappear sooner. In the example, the avalanche saves $557.49, while the snowball pays off 2 debts in the first 12 months against 1 for the avalanche. Both finish in month 40, because the same $1,230.00 goes out every month either way.

Example tabs: interest paid to date. Snowball ends at $6,391.76, avalanche at $5,834.28, a gap of $557.49.$0$1,000$2,000$3,000$4,000$5,000$6,000$7,0000510152025303540MonthSnowballAvalanche

Chart: interest paid to date, from the same two example tabs.

How credit card interest really works (and what the sheet simplifies)

The sheet charges interest once a month: balance × APR ÷ 12. Real credit cards work differently:

How big is the gap? On a steady $1,000 balance at 24% APR, the sheet charges $20.00 a month. Daily compounding at 24% ÷ 365 gives about $19.92 for a 30-day cycle and $20.59 for a 31-day cycle. So the plan is close, not exact: treat the payoff month as an estimate and update balances from your statements.

For context, the Federal Reserve's G.19 consumer credit release (released October 7, 2026) reports a commercial bank interest rate of 22.36% for credit card accounts assessed interest in August 2026. The example card APRs (27.49% and 23.99%) are made up; the average is quoted only for scale. Use the APR on your own statement.

Minimum payments are fixed here. Card minimums are often a percentage of the balance, so they fall as the balance falls. Federal rules (Regulation Z, 12 CFR 1026.7) require card statements to show this warning: "Minimum Payment Warning: If you make only the minimum payment each period, you will pay more in interest and it will take you longer to pay off your balance". The sheet keeps paying the starting minimum, which is faster than paying a shrinking minimum. If you want the plan to hold, keep paying at least the amount in the plan, not the lower minimum on later statements.

The formulas, explained

Exact formulas from the Debts tab (row 11, debt 1), the Snowball tab (month 1, row 10) and the Summary tab. Row 5 of each schedule holds the order of each debt, row 6 the APR and row 7 the minimum. Columns P to Y are balances, Z to AI interest, AJ to AS the amount owed above each minimum, and AT the money left after all minimums. The Avalanche tab is identical except that row 5 reads the avalanche order.

FieldFormula
Debts: monthly budget (B8)=E21+N(B4)
Debts: snowball order (H11)=IF(G11=1,COUNTIF($K$11:$K$20,"<"&K11)+COUNTIF($K$10:K10,K11)+1,"")
Debts: avalanche order (I11)=IF(G11=1,COUNTIF($L$11:$L$20,">"&L11)+COUNTIF($L$10:L10,L11)+1,"")
Schedule: interest, debt 1, month 1 (Z10)=P9*Z$6/12
Schedule: owed above the minimum (AJ10)=MAX(0,P9+Z10-AJ$7)
Schedule: money left after all minimums (AT10)=$C$3-SUM(P9:Y9)-SUM(Z10:AI10)+SUM(AJ10:AS10)
Schedule: new balance, debt 1 (P10)=AJ10-MIN(AJ10,MAX(0,$AT10-SUMIF($AJ$5:$AS$5,"<"&AJ$5,$AJ10:$AS10)))
Schedule: payment, debt 1 (F10)=P9+Z10-P10
Schedule: debt-free month (C4)=IF(Debts!G21=0,"",IF(COUNTIF(E10:E369,">0.005")>=360,"Not within 360 months",COUNTIF(E10:E369,">0.005")+1))
Summary: payoff month per debt (F22)=IF(Debts!G11=1,IF(COUNTIF(Snowball!P10:P369,">0.005")>=360,"Not within 360",COUNTIF(Snowball!P10:P369,">0.005")+1),"")
Summary: debt-free date (B11)=IF(OR(NOT(ISNUMBER(Snowball!C4)),N(Debts!B6)=0),"",EDATE(Debts!B6,Snowball!C4-1))
Summary: total interest (B12)=IF(ISNUMBER(Snowball!C4),SUM(Snowball!D10:D369),"")

The key line is the new balance. AT10 is the money left after every minimum: the fixed budget minus what the minimums actually took. SUMIF($AJ$5:$AS$5,"<"&AJ$5,$AJ10:$AS10) adds up what every debt ahead in the order still owes. Whatever is left after them goes to this debt, capped at its balance. A paid-off debt owes nothing, so its share passes straight to the next one: that is the rollover, with no macro and no array formula.

Worked example from the sample data

Month 1 (Jan 2027)

DebtBalanceAPRInterest (balance × APR ÷ 12)PaymentNew balance
Card A (store card)$1,150.0027.49%$26.34$335.00$841.34
Card B (rewards card)$6,400.0023.99%$127.95$160.00$6,367.95
Car loan$9,800.006.9%$56.35$285.00$9,571.35
Personal loan$4,300.0013.5%$48.38$145.00$4,203.38
Medical payment plan$2,000.000%$0.00$100.00$1,900.00
Student loan$18,500.005.5%$84.79$205.00$18,379.79
Total$42,150.00$343.81$1,230.00$41,263.81

Card A: $1,150.00 × 27.49% ÷ 12 = $26.34 of interest. Every debt gets its minimum ($930.00 in total), which leaves $300.00 of the $1,230.00 budget. Card A is first in both orders (smallest balance and highest APR), so it gets $35.00 + $300.00 = $335.00, and its balance falls to $841.34.

The snowball rolls

MonthDateCard ACard BCarPersonalMedicalStudentInterestTotal balanceNote
1Jan 2027$335.00$160.00$285.00$145.00$100.00$205.00$343.81$41,264
4Apr 2027$207.30$160.00$285.00$145.00$227.70$205.00$311.22$38,540Paid off: Card A
5May 2027–$160.00$285.00$145.00$435.00$205.00$302.88$37,613
8Aug 2027–$160.00$285.00$412.70$167.30$205.00$291.56$34,809Paid off: Medical
9Sep 2027–$160.00$285.00$580.00–$205.00$284.69$33,864
14Feb 2028–$287.06$285.00$452.94–$205.00$239.66$29,003Paid off: Personal
15Mar 2028–$740.00$285.00––$205.00$229.25$28,003
23Nov 2028–$406.18$618.82––$205.00$105.64$19,452Paid off: Card B
24Dec 2028––$1,025.00––$205.00$93.66$18,316
27Mar 2029––$839.89––$390.11$74.42$14,868Paid off: Car
28Apr 2029–––––$1,230.00$68.15$13,706
40Apr 2030–––––$571.76$2.61$0Paid off: Student

Example Snowball tab, selected months: payment to each debt. Green rows: a debt is paid off. The total paid is $1,230.00 every month until the last one.

The avalanche instead

The avalanche sends Card A's money to Card B (23.99%) instead: what is left over in month 4 goes to Card B, and from month 5 Card B gets $495.00 a month. Card B is paid off in month 19 instead of month 23. The 0% medical plan comes last, so its $100.00 minimum alone pays it off in month 20, against month 8 with the snowball. Total interest: $5,834.28 vs $6,391.76. Same budget, same finish month (40), $557.49 less interest.

Common mistakes

FAQ

What is the difference between the debt snowball and the debt avalanche?

Both pay every minimum and send all extra money to one debt at a time. The snowball picks the smallest balance first; the avalanche picks the highest APR first. When a debt is paid off, its minimum is added to the payment on the next debt. Only the order differs.

Which saves more money, snowball or avalanche?

The avalanche usually costs less interest, because the extra money goes to the most expensive debt first. In the fictional example it saves $557.49 ($5,834.28 vs $6,391.76), and both finish in month 40. The snowball pays off 2 debts in the first 12 months against 1 for the avalanche. Your own numbers decide the gap, so the sheet shows both.

How do I make a debt payoff spreadsheet in Excel?

List each debt with balance, APR and minimum payment. Each month, add interest (balance × APR ÷ 12), take off every minimum, then send what is left of a fixed monthly budget to the first unpaid debt in your chosen order. Repeat until every balance is zero. This template does that for up to 10 debts and 360 months with plain formulas, so you only type the debts.

Why does the interest in the spreadsheet differ from my credit card statement?

The sheet uses balance × APR ÷ 12 once a month. The CFPB says: "Many credit card companies calculate the interest you owe daily, based on your average daily account balance." Daily rates, the number of days in the billing cycle, payment timing and new purchases all move the real figure a little.

How long will it take to pay off my debt with minimum payments only?

Type 0 as the extra payment and read the debt-free month on the Summary tab. The CFPB warns: "If you make only the minimum payment, it could take years to pay off your credit card." Note that this sheet keeps each minimum fixed and rolls it over, which is faster than paying a card minimum that shrinks as the balance falls.

Can I use this debt payoff spreadsheet in Google Sheets?

Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. It uses IF, SUM, SUMIF, COUNTIF, MIN, MAX, INDEX, EDATE and SUMPRODUCT, which work in Excel 2016 or later and Google Sheets. There are no macros and no dynamic arrays.

Related tools and templates

Educational template only, not financial, legal or credit advice. The schedule is arithmetic on the numbers you type, with simplified monthly interest; check payoff amounts with your lenders. Example data is fictional: the debts, balances, APRs and minimums are made up. CFPB and Federal Reserve material was retrieved on 31 October 2026.