BROWN DEER SENIORS FINANCIAL STATUS
Item Formula Date 10/25/17 1/9/18 10/31/18 1/2/19 6/13/19 9/19/19 11/2/19 12/28/19 3/15/20 5/17/20 7/14/20
1 Bank Balance  $16,930 $15,024 $22,562 $19,201 $28,367 $31,278 $24,169 $23,670 $24,564 $31,225 $28,093
1a Checks written, not yet cleared $2,058 $300 $3,447 $0 $0 $0 $562 $0 $131 $4,608 $180
2 Checks received, not yet deposited $157 $130 $0 $0 $585 $0 $263 $660 $910 $910 $1,465
3 = 1+2 Total Funds on Hand $15,029 $14,854 $19,115 $19,201 $28,952 $31,278 $23,870 $24,330 $25,343 $27,527 $29,379
4 Total Player Accounts $13,897 $14,179 $17,919 $18,000 $18,941 $26,401 $22,825 $23,285 $24,634 $18,025 $20,068
5 = 3-4 Total Club Funds $1,132 $675 $1,196 $1,201 $10,011 $4,877 $1,045 $1,045 $709 $9,503 $9,310
Planned allocation of Funds Through January
6 Cup Payouts, October ($100/$60 for winners/runners up) $0 $0 $0 $0 $1,600 $1,600 $0 $0 $0 $1,420 $1,420
7 Run Club Payment to JB, $75/wk x 26 wks, pd in Nov. $0 $0 $0 $0 $1,560 $1,560 $0 $0 $0 $1,950 $1,950
9 Club Championship prize money August $0 $0 $0 $0 $2,000 $0 $0 $0 $0 $2,000 $2,000
10 Skins Game prize money, September $0 $0 $0 $0 $3,000 $0 $0 $0 $0 $3,000 $3,000
11 Scramble prize money, October $0 $0 $0 $0 $250 $250 $0 $0 $0 $250 $250
12 Annual website fee, January $300 $0 $300 $300 $300 $300 $300 $300 $0 $300 $300
13 Annual domain fee, January $13 $13 $0 $0 $0 $0 $13 $0 $0 $13 $13
14 Office expense payment to JB, November $0 $0 $0 $0 $100 $100 $0 $0 $0 $100 $100
15
16 Sum 6 - 15 Total planned allocations $313 $13 $300 $300 $8,810 $3,810 $313 $300 $0 $9,033 $9,033
17 = 5-16 Estimated club funds January $819 $662 $896 $901 $1,201 $1,067 $732 $745 $709 $470 $277