A simple Excel model that calculates monthly interest, payoff order, and new balances for multiple debts using the avalanche method.
- Shows payoff order (highest APR first).
- Calculates monthly interest and new balances.
- Lets you change your monthly budget to see different payoff speeds.
- Uses conditional formatting for easy visual priority.
Debt_Repayment_Model.xlsx— the full Excel model.screenshot_dashboard.png— sample view of the dashboard.
- Excel financial modeling
- Interest and payoff math
- Data visualization with conditional formatting