Personal Finance
Make a Free Copy in Google Sheets →
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)
Included Columns Structure
| Debt Name | Starting Balance ($) | Interest Rate (APR %) | Minimum Payment ($) | Extra Snowball ($) | Projected Payoff Month |
|---|---|---|---|---|---|
| Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry |
Ad Slot (In-Content Responsive Ad)
How to Set Up This Template
- List all non-mortgage debts with current balances, APRs, and minimum monthly payments.
- Enter any extra monthly amount you can put toward debt in the Monthly Snowball cell.
- Watch the projected debt-free date update dynamically.
Built-In Formulas Explained
-
NPEREstimates months remaining to pay off each balance given APR and monthly payment.
-
SORTOrders 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.