Accounts are grouped by age: 0โ30 days, 31โ60, 61โ90 and over 90. The older an account, the less likely it is to be paid. We apply commonly used collection-risk estimates of 2%, 10%, 25% and 50% to each group.
Sales needed to replace a bad debt = amount lost รท your profit margin. At a 10% margin, losing Rs. 10,000 means selling Rs. 1,00,000 just to earn it back.
Daily target = total outstanding รท the days you choose. Start with the oldest and largest accounts.
Results are estimates for planning, not tax, legal or investment advice.