Debt Payoff Planner

What this workbook does

The Debt Payoff Planner places multiple debts in one table and calculates current monthly interest, total planned payment, approximate payoff months, avalanche rank by APR, and snowball rank by balance. Those ranks help compare strategies; they do not create a complete month-by-month cascade after one debt is paid. Use the estimates to choose the next account, then verify terms and balances with each creditor.

What is inside the download

The download is an .xlsx workbook with formulas but no macros, scripts, live bank connection, or automatic data feed. It opens in current desktop Excel and can be imported into Google Sheets. Importing can change formatting or formula behavior, so test the converted copy before depending on it.

The sample rows demonstrate the intended structure; they are not recommendations, current prices, tax conclusions, or a picture of a typical household. Save an untouched master, create a dated working copy, and replace every sample input that affects a result.

• Balance: the current principal or statement balance.
• APR: the annual percentage rate for the balance being modeled.
• Minimum payment: the current required payment from the statement.
• Extra payment: the additional amount assigned to that debt.
• Strategy ranks: APR order for avalanche and balance order for snowball.
• Estimated months: an NPER-based estimate assuming a stable rate and payment.

Input cells and formula cells are visually distinct where practical, but spreadsheet software still permits a formula to be overwritten. If a total stops changing after an input changes, compare the cell with the clean master.

How the calculations work

• Monthly payment: Minimum + Extra.
• Current monthly interest: Balance × APR ÷ 12; actual daily interest can differ.
• Avalanche rank: highest APR receives the first priority number.
• Snowball rank: smallest balance receives the first priority number.
• Estimated months: the spreadsheet NPER function with a monthly rate and fixed payment.

Spreadsheet outputs are estimates produced by the values entered. A mathematically correct formula can still give a misleading answer when a rate uses the wrong period, an account is omitted, a date is stale, or a category is counted twice.

Recalculate one sample independently with a calculator. Then change one input at a time and confirm the expected cells respond. This known-answer test is more useful than assuming that a polished workbook is correct.

Set up the template

1. Download the workbook from this page and scan the file with current security tools if your device or organization requires it.
2. Save a clean master copy in a private folder. Rename the working copy with the starting date or planning scenario.
3. Read every header, note, and formula before deleting the fictional sample values.
4. Enter values from current statements, contracts, bills, receipts, or official account records—not from memory when a document exists.
5. Use one currency, date convention, and time period throughout the working copy.
6. Reconcile the first completed period with the external records that the workbook is meant to summarize.
7. Record material assumption changes in a note so the next review explains why the result moved.

Controls to review

• Flag any payment that does not exceed estimated monthly interest.
• Confirm promotional rates and their expiration dates separately.
• Keep every minimum payment current regardless of strategy rank.
• Update balances after statements post, not from an unposted bank transfer.
• Verify that added debts are included in rank and total ranges.

Do not hide a failed control by typing over a result. Correct the underlying input, extend the referenced range, or restore the formula from the clean master. If the workbook is shared, agree on who can change structure and who only enters data.

Limits of this template

The estimate assumes no new charges, fees, rate changes, skipped payments, or timing differences. It does not model a full cascading payment schedule, variable-rate loans, deferred interest, forgiveness, settlement, or tax consequences. Contact creditors early when required payments cannot be made; a spreadsheet cannot change a contract.

The workbook does not provide financial, investment, tax, accounting, or legal advice. It cannot see information outside the file and cannot verify that an input is complete. Use official statements and current agency guidance for decisions, and use a qualified professional when the consequences or uncertainty justify it.

Privacy and file safety

The file needs no DollarScout account and sends no workbook data back to DollarScout. That does not make every storage location safe. Financial spreadsheets can reveal income, account balances, debts, addresses, vendors, or tax facts even when they contain no passwords.

Use a device and storage account you control, enable appropriate authentication, review link-sharing permissions, and remove unnecessary personal identifiers. Never place passwords, full payment-card numbers, authentication codes, or private keys in the workbook. If collaborating, share the minimum data and access needed.

Keep recoverable versions before importing transactions, sorting large ranges, or changing formulas. A synced deletion or mistaken paste can affect every device; synchronization is not the same as a versioned backup.

Update and review routine

Update after each statement cycle and after any rate, minimum, or extra-payment change. When a balance reaches zero, preserve the final statement, redirect the released payment intentionally, and rerun the ranks before sending the next extra amount.

Archive a period only after reconciliation. If a projection differs from reality, preserve both numbers and document the cause rather than rewriting the old estimate. The variance is useful evidence for improving the next assumption.

Who this template fits

It fits a borrower comparing an APR-first avalanche with a balance-first snowball while keeping the arithmetic inspectable. It is not a substitute for nonprofit credit counseling, legal advice, or direct creditor communication when delinquency, collection, bankruptcy, or hardship is involved.

It is a poor fit when the task requires automatic account aggregation, multi-user approval controls, audited books, specialized tax-lot accounting, or guarantees about future rates and returns. In those situations, use purpose-built software or professional support and treat this workbook only as a secondary check.

Final checklist

Before relying on a displayed result, confirm that:

• all sample values have been replaced or intentionally retained;
• every amount uses the same period and currency;
• formulas cover newly added rows;
• totals reconcile with the relevant external records;
• assumptions have a date and source;
• sensitive data and sharing permissions are appropriate; and
• the workbook result is being used as an estimate, not as evidence the underlying transaction occurred.

A useful spreadsheet makes its reasoning inspectable. The goal is not to create a perfect dashboard; it is to maintain a small, traceable model that makes the next financial decision clearer.