Formula
Average daily balance = sum of Daily ending balances ÷ number of balances pasted; Lowest balance = the minimum of the list
Negative balance days = count of balances below $0; Days under $1,000 = count of balances below $1,000
Total deposits = sum of Deposit amounts; Deposit count = number of amounts; Average deposit = Total deposits ÷ Deposit count
Balance volatility = sample standard deviation of the balances ÷ absolute value of the average daily balance; Existing debits as share of deposits = Existing financing debits per day × 21 ÷ Total deposits
Illustrative grade: A when no negative days, no NSFs, average balance above $5,000 and volatility below 0.5; B when at most one negative day, at most one NSF and average balance above $2,500; C when at most three negative days and three NSFs; otherwise D. Funding estimate = Total deposits × 1.0 (A), 0.8 (B), 0.5 (C) or 0 (D).
Worked examples
Example 1: the default statement, 21 balances and 12 deposits with one NSF
The default balances are 8,200; 7,650; 9,100; 4,200; −150; 3,900; 6,100; 7,800; 8,900; 5,200; 2,100; 6,400; 7,700; 9,900; 8,100; 6,600; 4,300; 5,900; 7,200; 8,800; 9,400. They sum to $137,300 over 21 days, so the average daily balance = $137,300 ÷ 21 = $6,538.10, shown as $6,538. One balance is negative (−$150, day 5) and it is also the only day under $1,000, so negative days = 1 and days under $1,000 = 1; the lowest balance is −$150. The deposits are 3,200; 2,900; 4,100; 1,800; 2,600; 3,900; 4,400; 2,200; 3,100; 2,700; 3,800; 4,100, totalling $38,800 across 12 credits, an average deposit of $3,233. The sample standard deviation of the balances is about $2,558, so volatility = $2,558 ÷ $6,538 = 0.39. Existing debits of $350 a day × 21 = $7,350, which is 18.9 percent of $38,800. Grade: the single negative day rules out A; with one negative day, one NSF and an average above $2,500 the statement grades B, and the estimate is $38,800 × 0.8 = $31,040.
Example 2: a clean but small account
Balances 4,000; 3,500; 5,200; 6,100; 2,900; 3,300; 4,800; 5,500; 4,100; 3,600 sum to $43,000 over 10 days, so the average daily balance = $4,300. No day is negative or under $1,000; the lowest balance is $2,900. Deposits 2,500; 3,000; 1,800; 2,200; 4,000; 2,500 total $16,000 across 6 credits, averaging $2,667. Deviations from the $4,300 mean are −300, −800, 900, 1,800, −1,400, −1,000, 500, 1,200, −200, −700; their squares sum to 9,960,000; dividing by 9 gives 1,106,667 and the square root is $1,052, so volatility = $1,052 ÷ $4,300 = 0.24. NSFs are 0. Existing debits of $200 a day × 21 = $4,200, which is 26.3 percent of deposits. Grade: no negatives and no NSFs, but the average balance of $4,300 is below the $5,000 required for A, so the statement grades B and the estimate is $16,000 × 0.8 = $12,800. The account is clean; it is simply small, and the existing debits already take more than a quarter of deposits.
Example 3: a statement that fails on negative days
Balances 900; −200; −450; 300; −120; 1,500; 800; −60; 200; 2,100 sum to $4,970 over 10 days, so the average daily balance = $497. Four days are negative and eight of the ten are under $1,000; the lowest balance is −$450. Deposits 1,200; 900; 1,500; 2,000; 1,100 total $6,700 across 5 credits, averaging $1,340. The standard deviation of the balances is about $819, so volatility = $819 ÷ $497 = 1.65, meaning the typical swing is larger than the average balance. Four NSFs are entered. Existing debits of $100 a day × 21 = $2,100, which is 31.3 percent of deposits. Grade: four negative days exceeds the three allowed for C, so the statement grades D and the funding estimate is $0. A broker who submits this file is spending a funder's underwriting time on a decline; the merchant needs to clear the overdrafts and show a month without NSFs before any funder will look.