Your debts
Example data: replace with your own. Rows 1 to 3 hold three illustrative debts and an extra of 100 a month; clear them and type your own figures. Leave unused rows empty. Take balances, rates and minimums from your latest statements.
| # | Name | Balance | Annual rate % | Minimum monthly amount |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 |
Result
Press Calculate to see the result.
How it is calculated
Each month, every open debt first gets interest: balance times annual rate divided by 1200. Then the minimum is paid on every open debt. The extra amount plus the minimums freed by debts already cleared go to the target debt: the smallest balance first for the snowball method, the highest rate first for the avalanche method. With minimums only, nothing extra is added and freed minimums are not moved. Payments are made at month end, rates are fixed, and the calculation stops at 600 months. For the example data above, the figures match the worked table on the debt payoff planner page; example figures for the example debts shown, your results depend on your own numbers. Real loans may differ: fees, variable rates, grace periods and rounding by your servicer are not modelled. This page does not advise either method.
Want it in a spreadsheet?
Snowball and avalanche ordering, with freed payments moved on to the next debt, is done only by this free in-browser calculator. The USD 12 Excel workbook is different: a monthly budget (planned, actual, difference), a debts list, a per-debt payoff plan with an extra payment applied to one chosen debt (nothing carries over to the other debts), and a term plan that spreads a lump sum over up to 26 weeks. USD 12, one-time payment, sold on Gumroad: 3 workbooks (US, UK, CA) and a PDF guide. Licence: personal use. Refund on request within 14 days. These are the same terms as on the Gumroad listing.
Get the spreadsheet version with the monthly budget and term plan
Other pages
See the debt snowball spreadsheet page, the debt payoff planner and the United States edition. Background: Debt snowball method on Wikipedia.