How to create a debt snowball spreadsheet? The best way is by using this formula: Cost of Debt + Interest on Debt – Monthly Payment = Effective Monthly Debt Balances. You can divide your debt into three categories: Interest on debt, cost of debt and the effective payment. Your debt…