Formula
True deposits for each month = Gross deposits − Transfers, loans and refunds for that month; months with zero gross deposits are ignored.
Average true monthly deposits = sum of true deposits ÷ number of months entered. Average gross deposits = sum of gross ÷ number of months.
Recency-weighted average = (M1 true × 1 + M2 true × 2 + M3 true × 3 [+ M4 true × 4]) ÷ (1 + 2 + 3 [+ 4]).
Exclusions as share of gross = sum of exclusions ÷ sum of gross deposits. Annualized true deposits = Average true monthly deposits × 12.
Worked examples
Example 1: three default months
Inputs: Month 1 gross deposits $74,000 with $6,000 of transfers, loans and refunds; Month 2 gross $81,000 with $2,500 excluded; Month 3 gross $69,000 with $12,000 excluded; Month 4 left at zero so it is ignored. True deposits: M1 = 74,000 − 6,000 = $68,000; M2 = 81,000 − 2,500 = $78,500; M3 = 69,000 − 12,000 = $57,000. Average gross = (74,000 + 81,000 + 69,000) ÷ 3 = 224,000 ÷ 3 = $74,667. Average true = (68,000 + 78,500 + 57,000) ÷ 3 = 203,500 ÷ 3 = $67,833. Recency-weighted = (68,000 × 1 + 78,500 × 2 + 57,000 × 3) ÷ 6 = (68,000 + 157,000 + 171,000) ÷ 6 = 396,000 ÷ 6 = $66,000. Lowest true month = $57,000. Exclusions = (6,000 + 2,500 + 12,000) ÷ 224,000 = 20,500 ÷ 224,000 = 9.2%. Annualized = 67,833 × 12 = $814,000. The gross average overstates sizing revenue by about $6,800 a month; the weighted figure is lower still because the weakest month is the most recent, which is why a funder would likely size at $66,000 rather than $74,667.
Example 2: a loan deposit hiding in month two
Inputs: M1 gross $50,000, exclusions $0; M2 gross $48,000, exclusions $25,000; M3 gross $55,000, exclusions $1,500; M4 gross $60,000, exclusions $2,000. True: M1 $50,000; M2 = 48,000 − 25,000 = $23,000; M3 = 55,000 − 1,500 = $53,500; M4 = 60,000 − 2,000 = $58,000. Average gross = 213,000 ÷ 4 = $53,250. Average true = 184,500 ÷ 4 = $46,125. Weighted = (50,000 × 1 + 23,000 × 2 + 53,500 × 3 + 58,000 × 4) ÷ 10 = (50,000 + 46,000 + 160,500 + 232,000) ÷ 10 = 488,500 ÷ 10 = $48,850. Lowest true month = $23,000. Exclusions = 28,500 ÷ 213,000 = 13.4%. Annualized = $553,500. Month two is the interesting one: $25,000 of its $48,000 was an advance landing in the account, so only $23,000 was sales. Without the exclusion the month looks ordinary; with it, the business had a weak month that it covered by borrowing. The weighted average of $48,850 is above the simple average because the last two months were the strongest, which supports a slightly larger sizing than the plain mean, provided the existing advance's debits are counted in the debt burden.
Example 3: a gently declining account
Inputs: M1 gross $30,000 with $4,000 excluded; M2 gross $28,000 with $3,000 excluded; M3 gross $26,000 with $2,000 excluded. True: $26,000, $25,000, $24,000. Average gross = 84,000 ÷ 3 = $28,000. Average true = 75,000 ÷ 3 = $25,000. Weighted = (26,000 × 1 + 25,000 × 2 + 24,000 × 3) ÷ 6 = (26,000 + 50,000 + 72,000) ÷ 6 = 148,000 ÷ 6 = $24,667. Lowest = $24,000. Exclusions = 9,000 ÷ 84,000 = 10.7%. Annualized = $300,000. All three averages are within $1,000 of each other, so the sizing base is not in dispute. What the bars show is a steady decline of about $1,000 a month in true deposits. For a business this size, a funder would want to know why before offering more than a fraction of a month's deposits, and would use the lowest month, $24,000, rather than the average as the base. The tool's note that funders size on true deposits applies with particular force when the direction is down.