Abby Organizes a Debt Snowball Spreadsheet?

How-to basics · Updated November 21, 2026

There isn’t enough context to verify whether a particular Abby organizes or publishes a debt snowball spreadsheet; a first name alone does not identify a person or source. If you mean how to organize one in Excel, list debts from smallest balance to largest, track each minimum payment, and direct any planned extra payment to the smallest unpaid balance.

What can be confirmed about Abby?

“Abby” could refer to many people, and the question does not include a surname, website, video, workbook, or other identifying detail. Without that information, it would be misleading to claim that a specific Abby created a template, uses a particular method, or recommends particular spreadsheet columns. If you have a link or a fuller name, that could make it possible to assess the specific resource.

The debt snowball itself is a well-known way to prioritize debt repayment. It is not a special Excel feature or a spreadsheet product tied to one named organizer. A workbook can help someone apply the method, but its usefulness depends on the balances, interest rates, required payments, and payment dates entered—and on keeping those details current.

How the debt snowball works

First, list debts by balance, from the smallest to the largest. Continue making at least the required minimum payment on every debt. If the budget allows an additional amount, apply it to the smallest balance. After that balance is paid off, add the amount that had gone toward it to the payment on the next-smallest debt. Repeat until the listed debts are paid.

For example, suppose a person has a $600 card, a $1,800 personal loan, and a $4,000 car loan. The snowball order is card, personal loan, then car loan, regardless of which has the highest APR. If the card is paid off, the money previously used for its minimum and extra payment can be redirected to the personal loan, while minimum payments continue on the other debts.

The method is designed to create visible progress from clearing smaller balances early. That can make a repayment plan feel more manageable for some people. It does not automatically produce the lowest total interest cost: if a larger debt has a much higher rate, paying it later may cost more interest than prioritizing the highest APR.

Set up a clear Excel worksheet

In Excel for Microsoft 365 on Windows, start with a blank worksheet and use one row per debt. Put the headers in row 1 and enter the account details beginning in row 2. A practical layout is:

  • A: Debt: a recognizable account label, not a full account number.
  • B: Current balance: the latest amount owed.
  • C: APR: the annual percentage rate, entered as a percentage.
  • D: Minimum payment: the required payment for the current billing period.
  • E: Extra payment: the planned additional amount assigned to this debt.
  • F: Estimated monthly interest: a simplified estimate based on the current balance and APR.
  • G: Planned total payment: minimum plus planned extra payment.
  • H: Estimated ending balance: the projected balance after estimated interest and payment.

Sort the debt rows by current balance, smallest to largest, using Data > Sort. Keep the labels and all related values together when sorting; sorting only the balance column would attach the wrong APR or payment to an account. For readability, format balances and payments as currency and APR values as percentages using the Home tab’s number-format controls.

Use formulas for a one-month estimate

With headers in row 1 and the first debt in row 2, enter the balance in B2, APR in C2, minimum in D2, and extra payment in E2. Enter the following formulas in the corresponding calculation cells. These formulas estimate one month; they do not forecast a complete payoff schedule.

  • With the current balance in B2 and annual APR in C2, put this in F2: =B2*C2/12.
  • With the minimum payment in D2 and extra payment in E2, put this in G2: =D2+E2.
  • With the balance in B2, estimated interest in F2, and planned payment in G2, put this in H2: =MAX(0,B2+F2-G2).

For an illustrative example, enter $1,200 in B2, 18% in C2, $50 in D2, and $100 in E2. F2 returns $18 because $1,200 × 0.18 ÷ 12 = $18. G2 returns $150. H2 returns $1,068 because $1,200 + $18 − $150 = $1,068. The zero floor prevents a negative displayed balance if the payment exceeds the estimated amount due. The example assumes no new charges, fees, or other adjustments.

This monthly interest calculation is a convenient approximation, not necessarily the amount on a lender’s statement. Many accounts accrue interest using daily balances, and actual payments may be applied under account-specific rules. A lender may also change the minimum due as the balance changes. Check actual rates, minimums, fees, and payment treatment with the lender; consult a qualified professional for advice about your circumstances.

Assign the extra payment without losing track

The extra-payment column should show where the planned extra money is going, rather than suggesting that every debt receives the full extra amount. If there is $150 available above minimums, assigning $150 to each of three debts would overstate the budget. Enter the extra amount only on the current snowball target, or divide it deliberately if following a different plan.

After a debt is cleared, update its balance and redirect its former payment toward the next target. In a month-by-month tracker, record the actual payment and updated statement balance in separate columns or on a separate tab. Keeping a record of actuals alongside estimates helps reveal whether the plan is matching reality without silently overwriting the starting figures.

It is also useful to include a date for each balance update and a notes column for promotional rates, deferred interest, or due-date changes. Avoid storing full card numbers, passwords, or security codes in the workbook. A debt tracker needs balances and terms to organize payments; it does not need credentials that could expose accounts if the file is shared or lost.

What a spreadsheet can—and cannot—predict

A basic worksheet can make the order of debts, the planned extra payment, and a rough monthly balance estimate easy to see. It can help answer practical questions such as whether the planned payments exceed the amount set aside for debt repayment, or which balance is currently the smallest. It can also make it easier to notice missing information, such as an APR or a minimum payment that has not been updated.

A few rows of formulas do not constitute a precise payoff calculator. A reliable month-by-month forecast needs to account for changing balances, payment timing, interest calculation methods, payment allocation, fees, new borrowing, and minimum-payment rules. A single monthly-interest formula assumes a simplified period and cannot capture all those details. Treat the result as a planning estimate, then compare it with lender statements and adjust the inputs.

Do not assume that a projected zero balance means an account can safely be ignored. Confirm the payoff amount and timing with the lender, and keep making required payments until the lender confirms the debt is satisfied. Exact payoff figures can differ from a spreadsheet estimate because interest can accrue between statement dates and payment posting.

Snowball versus avalanche

The debt avalanche orders debts by APR, highest to lowest, while maintaining minimum payments on all accounts and applying the extra amount to the highest-rate debt. All else equal, focusing on the highest rate first can reduce interest compared with focusing on the smallest balance first. The snowball instead ranks by balance and may produce earlier account payoffs, which some people find motivating.

For a fair comparison, use the same balances, rates, minimum-payment assumptions, and total monthly budget in each plan. Compare estimated payoff timing and interest, but remember that results are only as sound as the assumptions. A debt with a promotional rate about to expire, a penalty rate, or special payment terms may need closer attention than a simple ranking suggests. Verify those terms with the lender rather than relying on the spreadsheet to interpret them.

Common spreadsheet mistakes

  • Using old balances: refresh balances and minimums from current statements, and note the date of each update.
  • Confusing APR and monthly interest: enter an annual rate such as 18% as 18%, not 18, and remember that dividing APR by 12 is only a simplified estimate.
  • Paying less than a required minimum: a snowball target does not replace required payments on other accounts.
  • Sorting only one column: sort the complete debt table so each balance stays attached to its creditor, rate, and minimum.
  • Counting the same money twice: total the extra-payment budget and assign it once, rather than repeating it on every row.
  • Assuming the worksheet changes lender accounts: it only records a plan. Payments must still be scheduled or made through the lender’s approved process.

Frequently Asked Questions

Does Abby have a debt snowball spreadsheet? The name alone is not enough to identify which Abby you mean or verify that she offers a spreadsheet. A specific surname, link, or source would be needed to confirm that claim.

What columns should a debt snowball spreadsheet include? At minimum, track the debt label, current balance, APR, minimum payment, extra payment, and payment status or updated balance. Interest and estimated ending-balance columns can add planning context, but their assumptions should be clear.

Should I list debts by balance or interest rate? For the snowball method, list them by balance from smallest to largest. For the avalanche method, list them by APR from highest to lowest. Compare the trade-offs and verify any unusual account terms before choosing an order.

Does Excel calculate the exact payoff date with these formulas? No. The formulas above estimate one month using APR divided by 12 and do not model daily interest, changing minimums, fees, or payment posting dates. Use lender figures for exact payoff amounts.

Can I use the same setup in Excel for Mac? The basic formulas and worksheet layout work in current Excel for Mac as well. Ribbon placement can vary slightly by Mac version, but sorting and entering formulas work the same way; the instructions here use the Windows ribbon paths.

Bottom line

There is no reliable way to attribute a debt snowball spreadsheet to an unspecified Abby. The method itself is straightforward to organize in Excel: list balances from smallest to largest, keep minimums current, assign the extra payment to one target, and update the workbook with actual account information. Use estimates for planning—not as a substitute for lender terms, confirmed payoff amounts, or qualified financial guidance.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.