GlobalFree to use

Debt snowball & avalanche calculator (Excel plan)

Enter up to five debts and an extra monthly amount to see your debt-free date, total interest, payoff order and a month-by-month Excel plan.

Your inputs stay in this tab. We do not receive your files, pasted text or calculation values.

Input

Your result

Your result will appear here.

How to use this tool

  1. Enter your values or choose a local file. Replace the example data with your own.
  2. Review options, units and assumptions, then run the tool.
  3. Check the result before copying or downloading it. Keep an original copy of important files.

Method & assumptions

Enter up to five debts and an extra monthly amount to see your debt-free date, total interest, payoff order and a month-by-month Excel plan.

each month: interest on every balance, minimums on all, extra + freed minimums to the target debt

Worked example

Currency: CAD
Method: Avalanche – highest rate first (saves most)
Extra payment per month: 200
Debt 1: balance: 4,200
Debt 1: APR %: 21.99
Debt 1: minimum payment: 120
Debt 2: balance: 1,500
Debt 2: APR %: 19.99
Debt 2: minimum payment: 45
Debt 3: balance: 9,800
Debt 3: APR %: 7.5
Debt 3: minimum payment: 210
Debt 4: balance: 0
Debt 4: APR %: 0
Debt 4: minimum payment: 0
Debt 5: balance: 0
Debt 5: APR %: 0
Debt 5: minimum payment: 0
Download as: Excel workbook (.xlsx)

→ Monthly payment toward debt: CAD 575.00
→ Debt-free in: 31 months (2.6 years)
→ Total interest: CAD 2,300.11
→ Compared with Snowball (smallest balance first): 32 months, CAD 2,336.15
→ Payoff order: Debt 1 (16) → Debt 2 (19) → Debt 3 (31)

Limits & important notes

Leave unused debts at 0. Each minimum must be more than that debt’s monthly interest. Paid-off minimums roll into the next debt.

Content updated:

Privacy & Free to use

Are my inputs stored?

Your inputs stay in this tab. We do not receive your files, pasted text or calculation values.

Is this tool free?

Yes. No signup or payment is required.

Processed in your browser

Useful next steps

Monthly budget planner with Excel download

Plan income, bills, spending and savings by category, check the 50/30/20 split and download an editable Excel budget with live formulas.

Budget & debt

12-month budget spreadsheet generator (Excel)

Create a ready-to-use Excel workbook: a 12-month budget, a transaction log and a plan-versus-actual summary, all with working formulas.

Budget & debt

Debt consolidation calculator

Compare paying your current debts as they are with a consolidation loan, including fees, to see if you really save.

Budget & debt