How to Build a Debt Payoff Plan: 5 Spreadsheet Steps

A debt payoff plan is a written order for your extra payments: which debt gets the extra dollars first, and how much goes there each month. A simple spreadsheet makes that order visible, so you can see the finish date instead of guessing. This guide shows how to build one in five steps, using the two payoff methods the Consumer Financial Protection Bureau (CFPB) describes.

Step 1: List every debt on one sheet

Open a spreadsheet and make one row per debt. The columns that matter are creditor name, current balance, APR, minimum payment, and due date. Pull the numbers from your most recent statements rather than from memory, since the APR on a statement is the rate you actually pay.

Next, find your monthly extra. Work out what you spend on needs, compare it with what comes in, and see what is left over. That leftover amount is your extra payment, and it is the most powerful cell in the sheet.

The table below shows how a finished list looks for two cards with a $200 monthly extra payment. The numbers are illustrative inputs, so replace them with your own statement figures.

What the table shows: every debt gets at least its minimum payment each month, and the entire extra amount flows to one target debt. When the target is paid off, its whole payment rolls into the next debt.

Step 2: Choose the payoff order

The CFPB describes two common approaches. With the snowball method, you keep making the minimum payments on all of your debts and put any extra funds toward your smallest debt first. The CFPB notes that you may end up paying more in the long run with this approach.

With the highest interest rate method, you focus on the debt with the highest rate of interest. The CFPB explains that the goal is to pay off that debt as quickly as possible, because it is costing you the most.

Add a column for the order under each method. Then run both orders in the sheet and compare the total interest and the payoff date. A plan you can follow for two years is worth more than a perfect plan you drop after three months, so pick the order that keeps you paying.

Step 3: Build the monthly simulation

Add two calculated columns: monthly interest and new balance. A simple approach that works in any spreadsheet is to estimate one month of interest as balance times APR divided by 12. Add that interest to the balance, subtract the payment, and the result is the new balance.

Copy the row down month by month until the balance reaches zero. The sheet then shows the two numbers that matter: the month the debt clears and the total interest paid along the way.

Here is the example from the table. The assumptions are fixed APRs, monthly interest, no new charges, on-time payments, and fixed minimums. With $200 extra aimed at Card A, it clears in about 12 months. Card B then receives $430 a month and clears about 11 months later.

That puts the whole payoff at about 23 months, with about $1,680 in total interest. Credit card interest rules vary, so check your card agreement for how your issuer calculates it.

Step 4: Compare it with minimums only

Now enter the same debts with minimum payments only and no rollover. Under the same assumptions, the last balance clears after about 58 months, with about $4,600 in interest.

The gap between the two columns is the point of the exercise. In this example, the extra $200 a month shortens the payoff by roughly 35 months and cuts interest by about $2,900. Your real numbers will differ, but seeing the gap in your own sheet can help the plan stay alive month after month.

What the table shows: a steady extra payment changes both the date and the cost. These are illustrations with stated assumptions, not predictions for your accounts.

Step 5: Review the sheet every month

Update balances after each statement and watch the payoff date move closer. Re-run the sheet whenever a rate, a balance, or your income changes. If you receive a raise or a bonus, test what happens when part of it joins the monthly extra.

A few habits keep the sheet useful:

• Keep every minimum payment on time, so the plan never stalls.
• Note each due date, and consider paying a little before it.
• Record any new charge, so balances stay accurate.
• Save a copy each quarter to see your progress.

Follow these steps

1. Build the sheet: one row per debt with balance, APR, minimum payment, and due date from your latest statements.
2. Find your monthly extra from a budget that still covers your needs.
3. Pick the order: enter the snowball and highest-rate orders, then compare total interest and payoff dates.
4. Simulate each month until every balance reaches zero, and compare the result with minimums only.
5. Review monthly, updating balances and re-running the sheet after any change.

Before you decide

If the minimum payments themselves are hard to afford, contact your card issuer. Some issuers offer hardship programs that may lower a payment or pause it for a period, and the terms vary by company. Ask for any agreement in writing before you rely on it.

A late or missed payment can lead to fees and may affect your credit, so the sheet should always protect the minimums first. See the CFPB site for current guidance on dealing with debt collectors and credit reports. A spreadsheet will not pay your debts for you, but it turns a vague worry into a dated finish line.

This article is for general information, not financial advice.

Sources

• CFPB, How to reduce your debt
• CFPB, Resolve to take control of your debt in the new year