Debt Snowball Payment Schedule Excel: Build a Payoff Plan

A debt snowball payment schedule in Excel lists your debts from the smallest balance to the largest, applies minimum payments to every debt, and directs extra money to the smallest balance first. Enter each balance, APR, minimum payment, and your monthly debt budget to estimate the month-by-month payoff order, payment allocation, interest, and debt-free date; this simple calculator illustrates the method, while Excel is needed for a full personalized schedule.

Formula

This calculator estimates one debt’s payoff when its payment is held level. The monthly payment is pay = min + extra. The monthly interest rate is r = APR / 1200, converting an annual percentage rate into a monthly decimal rate. The estimated number of payments is n = ceil[−ln(1 − r × balance / pay) / ln(1 + r)], rounded to six decimal places before rounding up to a whole month. Estimated interest is pay × n − balance.

• balance is the starting balance in dollars.
• APR is the annual percentage rate, entered as a percentage.
• min is the monthly minimum payment in dollars.
• extra is the additional monthly amount applied to this debt in dollars.
• pay is the assumed total monthly payment in dollars.
• n is the estimated number of monthly payments.

The formula assumes the same payment each month. It can estimate a debt’s standalone payoff time, but it cannot by itself model a complete snowball: in an actual snowball, the payment amount directed to a debt generally changes when another debt is paid off. For that schedule, the freed payment must be added to the next target.

Worked Example

Using the calculator’s default inputs: balance = $1,200, APR = 18%, minimum = $50, and extra = $100.

1. Monthly payment: $50 + $100 = $150.
2. Monthly rate: 18 / 1200 = 0.015, or 1.5%.
3. Unrounded payoff estimate: −ln(1 − 0.015 × 1,200 / 150) / ln(1.015) = −ln(0.88) / ln(1.015), approximately 8.59 months.
4. Round up to a whole payment month: 9 months.
5. Level-payment interest estimate: $150 × 9 − $1,200 = $150.00.

This is a simplified estimate because a real final payment would usually be smaller than the assumed $150, and interest accrues between payment dates. The calculator’s total uses nine full level payments so its result follows the stated formula; it is not a lender payoff quote.

Assumptions

• The APR is fixed for the estimate.
• Payments are made monthly at the end of each monthly period.
• Interest compounds monthly at APR / 12.
• Fees, taxes, insurance, promotional-rate changes, late charges, and lender-specific payment allocation are not included.

How to Build a Full Snowball Schedule in Excel

A full spreadsheet needs one row per month and a separate set of columns for each debt. List debts by current balance, lowest first. For each debt, track beginning balance, interest, minimum due, snowball extra, total payment, and ending balance. Use actual statement minimums and APRs as inputs; they can change, so update the sheet when your statements do.

1. Enter debt names, balances, APRs, and minimum payments in a table. Sort by balance ascending to set the initial payoff order.
2. Choose the total amount you plan to put toward all debts each month. The budget must cover all required minimum payments; otherwise, the schedule does not represent the stated plan.
3. For each month and debt, calculate interest using beginning balance × APR / 12. Calculate the payment after interest, and cap it at the amount actually owed so the final payment does not create a negative balance.
4. Pay minimums on debts that are not the current target. Send the remaining budget to the smallest unpaid balance. When it reaches zero, add its former payment amount to the next target’s allocation.
5. Carry each ending balance into the next month as the new beginning balance. Stop when all balances reach zero, then review total interest and the final payoff month.

Spreadsheet formulas should prevent payments from exceeding a balance plus that period’s interest. A basic ending-balance calculation is beginning balance + interest − payment, with the payment limited to the amount due. Excel’s exact formula layout depends on where you place inputs, so keep assumptions in clearly labelled cells and use cell references rather than typing rates into every row.

Snowball Order, Interest, and Comparisons

The snowball method prioritizes the smallest balance, not the highest APR. Its defining feature is the payment order: minimums go to all debts, and extra money goes to the smallest remaining balance. Once that debt is cleared, its payment rolls into the next target. This can produce an early account payoff, but it does not necessarily minimize interest.

The avalanche method instead directs extra payments to the debt with the highest APR, while maintaining minimums on the others. The two methods can produce different payoff orders and interest totals. The results depend on balances, rates, payment amounts, and timing; there is no universal outcome. A spreadsheet can calculate both scenarios using the same inputs, changing only the target-selection rule.

A common misconception is that snowball means paying only one debt at a time. It does not: minimums remain due on all debts, while the extra portion is concentrated on one target. Another is that the smallest balance will always be the first debt cleared. If required minimums or promotional terms change, the actual order can differ from a static sorted list, so use the current balance and payment information when updating your schedule.

Common Excel Problems and Limits

• Negative balances: Cap the payment at the amount due. Otherwise, the last row can show a credit instead of a zero balance.
• Minimum payments that change: A fixed minimum entered for every month can make the forecast inaccurate. Replace estimates with current statement amounts.
• Rounding differences: Interest may be rounded to cents by an issuer, while a spreadsheet may carry fractions of a cent. Round consistently and expect small differences.
• Irregular timing: The monthly APR / 12 calculation is an estimate. Actual interest may depend on daily balances, transaction dates, or account terms.
• Payment budget too small: If the total budget does not cover all minimums, the snowball allocation described here cannot be followed as modeled.

The single-debt calculator is not a full Excel template and does not accept several debts at once. Its payoff formula also requires a payment greater than the monthly interest on the starting balance; if the payment does not cover that interest, the logarithm has no valid payoff result. Even when it does, a changing minimum or a payment that varies after each payoff calls for a month-by-month schedule rather than a fixed-payment estimate.

Frequently Asked Questions

How do I make a debt snowball spreadsheet in Excel?
Enter each debt’s balance, APR, and minimum payment, sort by balance from smallest to largest, then create monthly rows that calculate interest, payments, and ending balances. Keep minimums on all debts and direct the available extra amount to the smallest unpaid balance.

What formula calculates debt payoff time?
For a fixed monthly payment and monthly rate, use n = −ln(1 − r × balance / payment) / ln(1 + r), then round up to a whole month. This assumes the payment exceeds monthly interest and does not model changing payments or lender-specific rounding.

Should I sort debts by balance or interest rate?
Sorting by balance follows the snowball method. Sorting by APR follows the avalanche method. They use different priorities, so compare schedules using your actual balances, rates, minimums, and planned monthly budget rather than assuming the payoff order or interest total.

Does the debt snowball include minimum payments?
Yes. The usual schedule includes minimum payments for every debt, then applies the remaining debt-payment budget to the current target. When that balance is cleared, its payment amount can be redirected to the next target.

Why is my Excel payoff date different from my statement?
Statements may use daily interest, changing minimums, payment dates, fees, or rounding rules that a basic monthly spreadsheet does not model. Compare the schedule with current account information and treat it as an estimate, not a payoff quote.

This result is an estimate for educational arithmetic; the lender’s disclosure gives the exact figures.

Related

• Second Home Loan Down Payment: What to Expect
• Car Loan Repayment Schedule Calculator
• Car Loan Repayment Schedule Calculator and Formula

in bal | Smallest debt balance | $ | 1200 | 0 | 100000000
in apr | Interest rate (APR) | % | 18 | 0.01 | 100
in min | Monthly minimum payment | $ | 50 | 0.01 | 1000000
in extra | Extra monthly amount for this debt | $ | 100 | 0 | 1000000
out pay | Monthly payment to this debt | $ | min + extra | 2
out months | Estimated payoff months | months | ceil(round(-ln(1 - (apr / 1200) * bal / pay) / ln(1 + apr / 1200), 6)) | 0
out interest | Estimated interest if payment stays level | $ | pay * months - bal | 2