Formula
Daily ACH debits only = Daily debit 1 + Daily debit 2 + Daily debit 3.
All financing as a daily figure = Daily ACH debits + Weekly debits ÷ 5 + Monthly loan and lease payments ÷ 21.
Average daily deposits = Average monthly deposits ÷ 21. Financing share of deposits = All financing as a daily figure ÷ Average daily deposits.
Monthly financing burden = All financing as a daily figure × 21. Cash left each month = Average monthly deposits − Monthly operating expenses excluding financing − Monthly financing burden.
Worked examples
Example 1: the default inputs, two daily advances plus a weekly and a monthly obligation
Average monthly deposits $85,000, daily debit 1 $380, daily debit 2 $215, daily debit 3 $0, weekly debits $600, monthly loan and lease payments $2,400, monthly operating expenses excluding financing $66,000. Daily ACH debits only = 380 + 215 + 0 = $595.00. All financing as a daily figure = 595 + 600 ÷ 5 + 2,400 ÷ 21 = 595 + 120 + 114.29 = $829.29. Average daily deposits = 85,000 ÷ 21 = $4,047.62. Financing share of deposits = 829.29 ÷ 4,047.62 = 20.5 percent, shown in amber because it is above 15 percent. Monthly financing burden = 829.29 × 21 = $17,415. Cash left each month = 85,000 − 66,000 − 17,415 = $1,585, shown in green because it is positive. The reading: the business is solvent on paper by $1,585 a month, which is under two days of debits. One slow week, one late customer payment or one unexpected repair and the next morning's $595 of ACH debits will be drawn against an account that cannot cover them.
Example 2: a larger business with one advance and a term loan
Average monthly deposits $140,000, daily debit 1 $650, no other daily debits, no weekly debits, monthly loan and lease payments $6,500, monthly operating expenses $105,000. Daily ACH debits only = $650.00. All financing as a daily figure = 650 + 0 + 6,500 ÷ 21 = 650 + 309.52 = $959.52. Average daily deposits = 140,000 ÷ 21 = $6,666.67. Financing share of deposits = 959.52 ÷ 6,666.67 = 14.4 percent, just under the amber line. Monthly financing burden = 959.52 × 21 = $20,150. Cash left each month = 140,000 − 105,000 − 20,150 = $14,850. Here the business keeps about $14,850 a month, roughly 15 days of total financing debits, after everything. The single advance is 68 percent of the financing burden; when it finishes the share of deposits drops to under 5 percent, which is the moment to apply for a line of credit rather than a renewal.
Example 3: three stacked advances on a small business, flagged
Average monthly deposits $52,000, daily debits $300, $180 and $140, weekly debits $250, monthly loan and lease payments $1,800, monthly operating expenses $41,000. Daily ACH debits only = 300 + 180 + 140 = $620.00. All financing as a daily figure = 620 + 250 ÷ 5 + 1,800 ÷ 21 = 620 + 50 + 85.71 = $755.71. Average daily deposits = 52,000 ÷ 21 = $2,476.19. Financing share of deposits = 755.71 ÷ 2,476.19 = 30.5 percent. Monthly financing burden = 755.71 × 21 = $15,870. Cash left each month = 52,000 − 41,000 − 15,870 = −$4,870, shown in amber with the warning that financing plus operating costs exceed deposits and each additional debit is being funded from the balance. The business is short $4,870 a month before any surprise. Its three advances take 30 percent of deposits, double the level most funders consider the ceiling; a fourth advance would not be offered, and if it were it would make the shortfall worse. The routes are reconciliation on each advance, consolidation, or a negotiated modification, in that order.