| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Tokyo HackerSpace Budget overview | ||||||||||||||
2 | Starting Balance | 0 | [42] | Total | Average | ||||||||||
3 | Total Income | 111,559 | 100,260 | 116,450 | 109,000 | 113,139 | 97,301 | 99,940 | 83,606 | 120,500 | 142,815 | 162,370 | 117,770 | 1,374,710 | 114,559 |
4 | Total Expenses | 120,500 | 100,000 | 105,000 | 120,168 | 100,000 | 100,000 | 100,000 | 110,962 | 136,000 | 110,000 | 111,500 | 123,900 | 1,338,030 | 111,503 |
5 | NET (Income - Expenses) | -8,941 | 260 | 11,450 | -11,168 | 13,139 | -2,699 | -60 | -27,356 | -15,500 | 32,815 | 50,870 | -6,130 | 36,680 | 3,057 |
6 | Projected End Balance | -8,941 | -8,681 | 2,769 | -8,399 | 4,740 | 2,041 | 1,981 | -25,375 | -40,875 | -8,060 | 42,810 | 36,680 | ||
7 | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Total | Average | |
8 | INCOME | ||||||||||||||
9 | Member Dues | 54,500 | 74,500 | 92,500 | 88,000 | 78,500 | 82,500 | 62,500 | 77,500 | 92,500 | 101,000 | 145,000 | 92,500 | 1,041,500 | 86,792 |
10 | Snack Bar | 9,909 | 0 | 2,350 | 3,000 | 7,690 | 1,900 | 2,000 | 0 | 0 | 0 | 0 | 0 | 26,849 | 2,237 |
11 | Kit Sales | 7,150 | 10,260 | 9,000 | 1,500 | 7,699 | -650 | 8,040 | 0 | 0 | 1,000 | -4,000 | 9,370 | 49,369 | 4,114 |
12 | Events | 23,000 | 10,500 | 10,600 | 15,500 | 17,250 | 12,551 | 0 | 0 | 28,000 | 7,500 | 8,600 | 5,000 | 138,501 | 11,542 |
13 | Donations | 17,000 | 5,000 | 2,000 | 1,000 | 2,000 | 1,000 | 27,400 | 6,106 | 0 | 33,315 | 12,770 | 10,900 | 118,491 | 9,874 |
14 | Total INCOME | 111,559 | 100,260 | 116,450 | 109,000 | 113,139 | 97,301 | 99,940 | 83,606 | 120,500 | 142,815 | 162,370 | 117,770 | 1,374,710 | 114,559 |
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 Bar | 0 | 0 | 0 | 20,168 | 0 | 0 | 0 | 0 | 25,000 | 0 | 0 | 0 | 45,168 | 3,764 |
19 | Utilities Share | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10,962 | 10,000 | 10,000 | 10,000 | 12,000 | 52,962 | 4,414 |
20 | Shannon Debt | 0 | 0 | ||||||||||||
21 | Promotions | 1,500 | 11,900 | 13,400 | 1,117 | ||||||||||
22 | Projects | 20,500 | 20,500 | 1,708 | |||||||||||
23 | Other | 5,000 | 1,000 | 6,000 | 500 | ||||||||||
24 | Total EXPENSES | 120,500 | 100,000 | 105,000 | 120,168 | 100,000 | 100,000 | 100,000 | 110,962 | 136,000 | 110,000 | 111,500 | 123,900 | 1,338,030 | 111,503 |