| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||
2 | Starting Balance | 36,680 | [42] | Total | Average | ||||||||||
3 | Total Income | 96,600 | 130,180 | 124,000 | 204,870 | 142,000 | 129,000 | 116,000 | 106,500 | 146,100 | 206,000 | 136,150 | 104,300 | 1,641,700 | 136,808 |
4 | Total Expenses | 122,000 | 122,000 | 120,000 | 220,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 128,020 | 122,000 | 1,554,020 | 129,502 |
5 | NET (Income - Expenses) | -25,400 | 8,180 | 4,000 | -15,130 | 22,000 | 9,000 | -4,000 | -13,500 | 26,100 | 86,000 | 8,130 | -17,700 | 87,680 | 7,307 |
6 | Projected End Balance | 11,280 | 19,460 | 23,460 | 8,330 | 30,330 | 39,330 | 35,330 | 21,830 | 47,930 | 133,930 | 142,060 | 124,360 | ||
7 | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Total | Average | |
8 | INCOME | ||||||||||||||
9 | Member Dues | 87,500 | 92,500 | 102,500 | 147,500 | 92,500 | 105,000 | 100,000 | 80,000 | 130,000 | 110,000 | 95,000 | 80,000 | 1,222,500 | 101,875 |
10 | Snack/Vending | 0 | 3,680 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3,680 | 307 |
11 | Kit Sales | 0 | 3,000 | 7,500 | 2,500 | 0 | 0 | 0 | 0 | 0 | 1,000 | 3,500 | 4,500 | 22,000 | 1,833 |
12 | Events | 3,000 | 21,000 | 9,000 | 44,000 | 13,000 | 11,000 | 0 | 16,000 | 0 | 37,500 | 19,650 | 7,000 | 181,150 | 15,096 |
13 | Donations | 6,100 | 10,000 | 5,000 | 10,870 | 36,500 | 13,000 | 16,000 | 10,500 | 16,100 | 57,500 | 18,000 | 12,800 | 212,370 | 17,698 |
14 | Total INCOME | 96,600 | 130,180 | 124,000 | 204,870 | 142,000 | 129,000 | 116,000 | 106,500 | 146,100 | 206,000 | 136,150 | 104,300 | 1,641,700 | 136,808 |
15 | |||||||||||||||
16 | EXPENSES | ||||||||||||||
17 | Mortgage/Rent | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 100,000 | 1,200,000 | 100,000 |
18 | Snack/Vending | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
19 | Utilities Share | 12,000 | 12,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 12,000 | 12,000 | 128,000 | 10,667 |
20 | Shannon Debt | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 120,000 | 10,000 |
21 | Promotions | 6,020 | 6,020 | 502 | |||||||||||
22 | Projects | 0 | 0 | ||||||||||||
23 | Other | 100,000 | 100,000 | 8,333 | |||||||||||
24 | Total EXPENSES | 122,000 | 122,000 | 120,000 | 220,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 128,020 | 122,000 | 1,554,020 | 129,502 |