Formula
List mode: Average daily balance = (Balance on day 1 + Balance on day 2 + … + Balance on day N) ÷ N, where N is the number of balances pasted
Segment mode: each line is a balance and the number of days it was held; the balance is repeated that many times before averaging, so Average daily balance = Σ (balance × days) ÷ Σ days
Lowest balance and Highest balance = the minimum and maximum of the expanded daily list; Ending balance = the last balance in the list
Days below half the average = count of days whose balance is less than 0.5 × Average daily balance
Worked examples
Example 1: the default 21-day list
The default balances are 5,200; 5,200; 6,100; 3,900; 3,900; 3,900; 7,400; 8,100; 2,200; 2,200; 5,600; 6,900; 7,100; 7,100; 4,800; 4,800; 9,200; 9,600; 6,300; 6,300; 5,100. Adding them in groups: 5,200 + 5,200 + 6,100 = 16,500; 3,900 × 3 = 11,700; 7,400 + 8,100 = 15,500; 2,200 × 2 = 4,400; 5,600 + 6,900 = 12,500; 7,100 × 2 = 14,200; 4,800 × 2 = 9,600; 9,200 + 9,600 = 18,800; 6,300 × 2 = 12,600; and 5,100. The total is 16,500 + 11,700 + 15,500 + 4,400 + 12,500 + 14,200 + 9,600 + 18,800 + 12,600 + 5,100 = $120,900 over 21 days. Average daily balance = $120,900 ÷ 21 = $5,757.14. Lowest balance $2,200, highest $9,600, ending balance $5,100. Half the average is $2,878.57, and only the two $2,200 days fall below it, so days below half the average = 2. Repeated balances on consecutive days are normal: they are days with no posted activity on which the statement carries the balance forward.
Example 2: segment mode from a statement that lists only activity days
Many statements print a balance only on days with transactions. If the statement shows $12,000 held for 5 days, then $3,500 for 9 days, then $800 for 4 days, then $6,200 for 12 days, enter four lines in segment mode: 12000, 5 and 3500, 9 and 800, 4 and 6200, 12. The calculator expands them to 30 daily balances. Sum = 12,000 × 5 + 3,500 × 9 + 800 × 4 + 6,200 × 12 = 60,000 + 31,500 + 3,200 + 74,400 = $169,100. Average daily balance = $169,100 ÷ 30 = $5,636.67. Lowest $800, highest $12,000, ending $6,200. Half the average is $2,818.33, and the four days at $800 fall below it, so days below half the average = 4. Notice that the average is pulled up by the 12 days at $6,200 and the 5 days at $12,000; the 4 days at $800 would have returned a daily debit of $900, which the average alone would never reveal.
Example 3: a ten-day list with a low floor
Balances 3,000; 3,000; 1,500; 400; 400; 6,500; 6,500; 2,800; 2,800; 2,100. Sum = 3,000 + 3,000 + 1,500 + 400 + 400 + 6,500 + 6,500 + 2,800 + 2,800 + 2,100 = $29,000. Average daily balance = $29,000 ÷ 10 = $2,900.00. Lowest $400, highest $6,500, ending $2,100. Half the average is $1,450, and the two $400 days fall below it, so days below half the average = 2. An underwriter reading this file sees an average that clears most funders' minimum for a small advance, but a floor of $400 on two consecutive days, which means a daily debit of $450 would have overdrawn the account twice in ten days. The advance this merchant can carry is set by the floor, not by the $2,900 average.