OpenRow Studio

OpenRow Studio

Debt Payoff Spreadsheet for Google Sheets

$10

Debt payoff spreadsheet for Google Sheets with snowball, avalanche, and custom order. Enter up to 50 debts and compare payoff months and interest using the same total monthly budget.

Snowball prioritizes the smallest starting balance. Avalanche prioritizes the highest APR. Custom order uses your priority numbers. A payment log records actual payments without changing the forecast, and a reconcile sheet compares a statement balance with the plan.

What you get

  • Room for up to 50 debts
  • Compare, Plan, and Waterfall tabs for projected interest, payment totals, payoff months, and where extra money goes
  • A Payment Log that stays separate from the forecast
  • A Reconcile tab for statement balances
  • A blank workbook, a clearly fictional 50 debt example, a README, and a personal use license

Limits you should know

Interest is estimated each month using balance times APR divided by 12, rounded to cents before payments. The model does not include daily interest, changing rates, promotional expiration, fees, new charges, or changing minimums. The forecast covers 360 months. Unpaid scenarios are marked as not within 30 years.

This revision was recalculated and checked in LibreOffice and in Google Sheets. It has not been tested in desktop Excel, Excel for the web, or phone apps. Best used on a computer. No macros.

Educational template, not financial advice. There is no guaranteed payoff date, savings amount, or credit score improvement. Images show the included fictional example data.

Get it on Gumroad