Debt snowball and avalanche planner

List your debts with their balances, rates and minimum payments. Choose a method and the extra amount you can put towards debt each month; the planner orders the debts, rolls each paid-off payment into the next one and shows when you will be debt-free.

Debt snowball and avalanche planner

Excel .xlsx · Works in Excel, Google Sheets, LibreOffice and Numbers

Download template (10 KB)

The file contains only formulas and example numbers — no macros, no links, nothing that connects to the internet.

What's inside

  • Up to 10 debts with balance, rate and minimum payment
  • Snowball (smallest balance first) or avalanche (highest rate first)
  • Payoff order with month and date for each debt
  • Debt-free date and interest compared with minimum payments only

Prefer to calculate online? Use the Credit card payoff calculator.

How to use it

  1. Download the file with the button above and open it in Excel, Google Sheets (File → Import), LibreOffice or Numbers.
  2. Fill in the yellow cells — they hold your own numbers. The example values show the expected format.
  3. Everything else is worked out by formulas. Save a copy whenever you want to keep a snapshot.

Common questions

Snowball or avalanche — which is better?

Avalanche saves the most interest. Snowball clears small debts first, which many people find more motivating. The planner lets you switch and compare.

What if a minimum payment is too small?

If a minimum doesn't cover the monthly interest, that debt never shrinks on its own; the planner flags it so you can raise the payment.

More free templates

Ads on this page help keep Abacurio and these templates free. Thank you for your support.

Choose a language