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.
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.
| Debt | Balance | APR | Minimum | Snowball: order · payoff | Avalanche: order · payoff |
|---|---|---|---|---|---|
| Card A (store card) | $1,150.00 | 27.49% | $35.00 | #1 · month 4 (Apr 2027) | #1 · month 4 (Apr 2027) |
| Card B (rewards card) | $6,400.00 | 23.99% | $160.00 | #4 · month 23 (Nov 2028) | #2 · month 19 (Jul 2028) |
| Car loan | $9,800.00 | 6.9% | $285.00 | #5 · month 27 (Mar 2029) | #4 · month 27 (Mar 2029) |
| Personal loan | $4,300.00 | 13.5% | $145.00 | #3 · month 14 (Feb 2028) | #3 · month 22 (Oct 2028) |
| Medical payment plan | $2,000.00 | 0% | $100.00 | #2 · month 8 (Aug 2027) | #6 · month 20 (Aug 2028) |
| Student loan | $18,500.00 | 5.5% | $205.00 | #6 · month 40 (Apr 2030) | #5 · month 40 (Apr 2030) |
| Total | $42,150.00 | $930.00 | debt-free: month 40 | debt-free: month 40 |
What's inside the spreadsheet
| Tab | What you type | What it calculates |
|---|---|---|
| Start here | Nothing | Steps, how the schedule works, colour key, limits, disclaimer |
| Debts | Up 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, Avalanche | Nothing | A 360-month schedule for each method: payment, interest and balance per debt, total paid and total balance each month |
| Summary | Nothing | Snowball 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 Summary | Already filled | The 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
- 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.
- Type the extra amount you can pay each month in B4, on top of all minimums. 0 is fine.
- Pick Snowball or Avalanche in B5. Optional: type the month of your first payment in B6 to see real dates.
- Check that B7 says OK. If it does not, read the note in column J of the flagged row.
- 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.
- 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.
| Method | Target order | Order in the example |
|---|---|---|
| Snowball | Smallest starting balance first | Card A → Medical → Personal → Card B → Car → Student |
| Avalanche | Highest APR first | Card 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.
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:
- Daily interest. The CFPB explains: "Many credit card companies calculate the interest you owe daily, based on your average daily account balance." (CFPB)
- Daily periodic rate. "The daily periodic interest rate generally can be calculated by dividing the annual percentage rate, or APR, by either 360 or 365, depending on the card issuer." And: "This interest amount is then added to the previous day’s balance, which means that interest is compounding on a daily basis." (CFPB)
- Payment timing matters. "Since interest is accruing daily, not monthly, this means that if you don’t have a grace period, the sooner you pay off all or some of your balance, the less interest you will pay." (CFPB)
- Grace periods. "Credit card companies are not required to give a grace period." (CFPB) The sheet assumes no grace period: every balance is charged interest every month.
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.
| Field | Formula |
|---|---|
| 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)
| Debt | Balance | APR | Interest (balance × APR ÷ 12) | Payment | New balance |
|---|---|---|---|---|---|
| Card A (store card) | $1,150.00 | 27.49% | $26.34 | $335.00 | $841.34 |
| Card B (rewards card) | $6,400.00 | 23.99% | $127.95 | $160.00 | $6,367.95 |
| Car loan | $9,800.00 | 6.9% | $56.35 | $285.00 | $9,571.35 |
| Personal loan | $4,300.00 | 13.5% | $48.38 | $145.00 | $4,203.38 |
| Medical payment plan | $2,000.00 | 0% | $0.00 | $100.00 | $1,900.00 |
| Student loan | $18,500.00 | 5.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
- Month 4: Card A (store card) is paid off (last payment $207.30). From month 5, Medical payment plan gets $435.00 a month.
- Month 8: Medical payment plan is paid off (last payment $167.30). From month 9, Personal loan gets $580.00 a month.
- Month 14: Personal loan is paid off (last payment $452.94). From month 15, Card B (rewards card) gets $740.00 a month.
- Month 23: Card B (rewards card) is paid off (last payment $406.18). From month 24, Car loan gets $1,025.00 a month.
- Month 27: Car loan is paid off (last payment $839.89). From month 28, Student loan gets $1,230.00 a month.
- Month 40: Student loan is paid off with a final $571.76. Debt-free in Apr 2030.
| Month | Date | Card A | Card B | Car | Personal | Medical | Student | Interest | Total balance | Note |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Jan 2027 | $335.00 | $160.00 | $285.00 | $145.00 | $100.00 | $205.00 | $343.81 | $41,264 | |
| 4 | Apr 2027 | $207.30 | $160.00 | $285.00 | $145.00 | $227.70 | $205.00 | $311.22 | $38,540 | Paid off: Card A |
| 5 | May 2027 | – | $160.00 | $285.00 | $145.00 | $435.00 | $205.00 | $302.88 | $37,613 | |
| 8 | Aug 2027 | – | $160.00 | $285.00 | $412.70 | $167.30 | $205.00 | $291.56 | $34,809 | Paid off: Medical |
| 9 | Sep 2027 | – | $160.00 | $285.00 | $580.00 | – | $205.00 | $284.69 | $33,864 | |
| 14 | Feb 2028 | – | $287.06 | $285.00 | $452.94 | – | $205.00 | $239.66 | $29,003 | Paid off: Personal |
| 15 | Mar 2028 | – | $740.00 | $285.00 | – | – | $205.00 | $229.25 | $28,003 | |
| 23 | Nov 2028 | – | $406.18 | $618.82 | – | – | $205.00 | $105.64 | $19,452 | Paid off: Card B |
| 24 | Dec 2028 | – | – | $1,025.00 | – | – | $205.00 | $93.66 | $18,316 | |
| 27 | Mar 2029 | – | – | $839.89 | – | – | $390.11 | $74.42 | $14,868 | Paid off: Car |
| 28 | Apr 2029 | – | – | – | – | – | $1,230.00 | $68.15 | $13,706 | |
| 40 | Apr 2030 | – | – | – | – | – | $571.76 | $2.61 | $0 | Paid off: Student |
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
- Typing the APR as a whole number. Enter 24.99% (or 0.2499), not 24.99. Validation stops values above 100%.
- Using a minimum that does not cover the interest. The balance then grows each month until extra money reaches that debt. Column J on Debts flags it.
- Paying the lower minimum on later statements. The plan assumes the budget stays the same. If you cut payments when card minimums fall, the debt-free month moves out.
- Adding new charges. The schedule assumes no new purchases. New spending on a card you are paying off restarts part of the work.
- Forgetting promo rates. A 0% offer that ends, or a deferred-interest plan, changes the APR. Type the new APR when it changes.
- Judging the methods only by interest. The interest gap can be small; in the example it is $557.49 over 40 months. Pick the order you will stick to.
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
- Budget spreadsheetFind the extra money for debt
- Emergency fund trackerA cash buffer while you pay down debt
- Net worth trackerSee debt fall and net worth rise
- Compound interest spreadsheetThe same math, working for you
- FIRE calculator spreadsheetPlan what comes after debt
- All templatesFree spreadsheets
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.