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.