DP DeskPrintly
Personal Finance

Free Debt Snowball Spreadsheet for Google Sheets

Orders debts from smallest balance to largest, calculates payoff dates, and visualizes total interest saved.

Ready-to-Use Google Sheets Workbook
Private copy in your Google Drive • Compatible with Excel (.xlsx)
Make a Free Copy in Google Sheets →
Included Columns Structure
Debt NameStarting Balance ($)Interest Rate (APR %)Minimum Payment ($)Extra Snowball ($)Projected Payoff Month
Auto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / Entry
Ad Slot (In-Content Responsive Ad)

How to Set Up This Template

  1. List all non-mortgage debts with current balances, APRs, and minimum monthly payments.
  2. Enter any extra monthly amount you can put toward debt in the Monthly Snowball cell.
  3. Watch the projected debt-free date update dynamically.

Built-In Formulas Explained

  • NPER

    Estimates months remaining to pay off each balance given APR and monthly payment.

  • SORT

    Orders active debts automatically from lowest balance to highest.

Frequently Asked Questions

What is the difference between Debt Snowball and Debt Avalanche?

Debt Snowball targets the smallest balance first for quick psychological wins; Debt Avalanche targets the highest APR first to minimize interest.