Formula
Total monthly debt burden = Daily debits × 21 + Weekly debits × (52 ÷ 12) + Monthly loan, lease and card payments.
Share of deposits = Total monthly debt burden ÷ Monthly deposits. Gross profit = Monthly deposits × Gross margin; Share of gross profit = Total monthly debt burden ÷ Gross profit.
Room under policy cap (monthly) = Monthly deposits × Policy cap − Total monthly debt burden; Room as a daily debit = that figure ÷ 21.
Daily-equivalent total burden = Total monthly debt burden ÷ 21.
Worked examples
Example 1: the default file is already over the cap
Inputs: Monthly deposits $120,000, Gross margin 35%, Daily debits (all positions) $950, Weekly debits $1,200, Monthly loan, lease and card payments $4,800, Policy cap 15%. Daily debits to monthly: 950 × 21 = $19,950. Weekly to monthly: 1,200 × 52 ÷ 12 = 1,200 × 4.333 = $5,200. Monthly payments: $4,800. Total monthly debt burden = 19,950 + 5,200 + 4,800 = $29,950. Share of deposits = 29,950 ÷ 120,000 = 24.96%, shown as 25.0%, well above the 15 percent cap. Gross profit = 120,000 × 0.35 = $42,000; share of gross profit = 29,950 ÷ 42,000 = 71%, flagged because it exceeds half. Room under cap = 120,000 × 0.15 − 29,950 = 18,000 − 29,950 = −$11,950 a month, which is −11,950 ÷ 21 = −$569.05 as a daily debit. Daily-equivalent total burden = 29,950 ÷ 21 = $1,426.19. This business sends out more than $1,400 every business day against deposits of about $5,700 a day, and seven dollars of every ten it earns in gross profit go to financing. A new position here is a stack onto an already overloaded account.
Example 2: a thin-margin retailer
Inputs: deposits $60,000, gross margin 15%, daily debits $500, weekly $0, monthly payments $2,200, cap 12%. Daily to monthly: 500 × 21 = $10,500. Weekly: 0. Total = 10,500 + 0 + 2,200 = $12,700. Share of deposits = 12,700 ÷ 60,000 = 21.2%. Gross profit = 60,000 × 0.15 = $9,000; share of gross profit = 12,700 ÷ 9,000 = 141%. Room = 60,000 × 0.12 − 12,700 = 7,200 − 12,700 = −$5,500 a month, or −$261.90 a day. Daily-equivalent burden = $604.76. The deposit share, 21 percent, is lower than the default example's 25 percent, but the gross profit share is the figure that matters: the business pays out $1.41 in financing for every dollar of gross profit it generates. That is only possible for a short time, funded by the balance, by supplier credit or by the next advance. For a fuel station, grocer or distributor with margins in this range, a 12 percent deposit cap is itself too generous; many funders use 8 to 10 percent for such trades.
Example 3: a consultancy with room to spare
Inputs: deposits $250,000, gross margin 60%, daily $0, weekly $3,500, monthly payments $9,000, cap 20%. Weekly to monthly: 3,500 × 4.333 = $15,166.67. Total = 0 + 15,166.67 + 9,000 = $24,167. Share of deposits = 24,167 ÷ 250,000 = 9.7%. Gross profit = 250,000 × 0.60 = $150,000; share of gross profit = 24,167 ÷ 150,000 = 16%. Room = 250,000 × 0.20 − 24,167 = 50,000 − 24,167 = $25,833 a month, or 25,833 ÷ 21 = $1,230.16 a day. Daily-equivalent burden = $1,150.79. Here the policy cap of 20 percent is comfortably above the current burden, and gross profit covers financing six times over. The account could carry another $1,230 a day, which at 160 business days and a 1.3 factor supports roughly $150,000 of new funding before the deposit multiple or coverage limits are checked. Whether it should is a question of use of proceeds; the burden analysis says only that the cash is there.