Build avalanche or snowball debt payoff plans with payment schedules.
Helps you create a structured debt payoff plan using either the avalanche method (highest interest rate first) or snowball method (smallest balance first). Identifies your current debt payments, calculates extra payment capacity from your budget, and generates a month-by-month payoff schedule.
transaction_search — find recurring debt payments (loans, credit cards, lines of credit)spending_summary — calculate total income vs. expenses to find extra payment capacityRun transaction_search with query: "payment OR loan OR credit card OR interest OR minimum" and months: 3 to identify recurring debt payments.
Group the results by creditor/lender to determine your current monthly payment for each debt.
Ask the user to provide for each debt: current balance, interest rate (APR), and minimum payment. Wilson cannot determine balances from transactions alone.
Run spending_summary for the last 3 months to calculate average monthly income and average monthly expenses.
Compute extra payment capacity: (average monthly income) - (average monthly expenses) - (sum of minimum payments already in expenses). If this is negative, flag that the user is overspending.
Generate an Avalanche Plan — order debts by interest rate descending. Apply all extra payment capacity to the highest-rate debt while paying minimums on all others.
Generate a Snowball Plan — order debts by balance ascending. Apply all extra payment capacity to the smallest balance while paying minimums on all others.
For each plan, produce a month-by-month schedule in this format:
Month | Debt Name | Payment | Principal | Interest | Remaining Balance
------+---------------+---------+-----------+----------+------------------
1 | Credit Card A | $350 | $320.83 | $29.17 | $1,679.17
1 | Student Loan | $150 | $112.50 | $37.50 | $14,887.50
Calculate and display: total months to payoff, total interest paid, and total cost for each method.
Compare the two methods side by side and recommend the one that saves more in interest (avalanche) or provides faster psychological wins (snowball).
Balance * (APR / 12)=B2*(C2/12) where B2 is balance, C2 is APR as decimal=D2-E2 where D2 is payment, E2 is interest=B2-F2