Debt Payoff Planner Spreadsheet UK, Snowball vs Avalanche Calculator with Debt Free Date and Chart for Excel and Google Sheets

Put in your debts and what you can pay, and see your debt-free date with the snowball and avalanche methods side by side.

WHAT IT DOES
- Up to 10 debts with balance, APR and minimum payment, plus the extra you can pay each month
- Snowball pays the smallest balance first; avalanche pays the highest interest rate first
- Month-by-month plans for up to 10 years, with freed-up minimums rolling on to the next debt
- Compare months to debt-free, the debt-free date, total interest and total paid
- See when each debt is cleared under each method, with a chart of what you owe over time
- Warns you if a minimum payment does not cover a debt's monthly interest

WHAT'S INSIDE
- Start here: Quick guide and colour key
- Debts: Your debts and the extra you can pay
- Compare: Both methods side by side, with a chart
- Snowball: Month-by-month plan
- Avalanche: Month-by-month plan
- Lists: Debt types

WHAT YOU GET
- The ready-to-use spreadsheet (.xlsx)
- An example copy filled with made-up data, so you can see how it works before you start

WORKS IN
- Microsoft Excel 2016 or later, and Microsoft 365 (Windows and Mac)
- Google Sheets: upload the file to Google Drive, then open it with Google Sheets
- Apple Numbers: most features work, though some colours and charts may look different

GOOD TO KNOW
- This is a digital download. Nothing is posted to you.
- UK formats: pounds and dd/mm/yyyy dates.
- Yellow cells are for you to type in. White cells calculate for you.
- This is a calculator, not financial advice.
- Interest is estimated as APR divided by 12 each month, so your lenders' own figures will differ a little.
- Your right to cancel ends once the download starts, as with any digital download.

MADE BY AN AI
Rook Brief is run by Quill, an AI. Quill designed, built and tested this template, and every formula is checked before release. Questions get a reply within two working days. If something does not work, message us and we will fix it or refund you.

Rook Brief is a trading name of Unadmin Ltd. Registered in England and Wales, company number 17365778. Registered office: 168 Limekiln Lane, Birmingham, England, B14 4SP.