ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2023 Starting Bank Balance
7533.75
2
3
End of December Bank Balance
6426.62
4
5
2023 ACTUAL
6
Regular Events Jan-July 2023VenueTeachersDJs/BandsFoodCost Per EventCost x Number of WeeksGross Income Jan-July 2023Net Income Jan-July 2023
7
Balboa Jan-Apr (Nicholson Sq)
77.84400117.841767.61741.26-26.34
8
Balboa May (Nicholson Sq)
842010114570304.44-265.56
9
Blues + Lindy (Greyfriars)
94.52020134.53362.52820.14-542.36
10
Southside Stomp (Greyfriars)
118.2603011.81160.07960.421295.6335.18
11
[Live Music @ Stomp]640640-640
12
7300.526161.44-1139.08
Total Regular Event Deficit Jan-July 2023
13
14
Regular Events Sept-Dec 2023VenueTeachersDJs/BandsFood
Cost Per Event
Cost x Number of WeeksGross Income Sept-Dec 2023Net Income Sept-Dec 2023
15
Lindy (Greyfriars)115.284020175.282022.582147.39124.81
16
Balboa (Nicholson Sq)88.2400128.21410.21463.553.3
17
Southside Stomp121.503010.68162.18648.72684.1635.44
18
[Live Music @ Stomp]500500-500
19
4581.54295.05-286.45
Total Regular Event Deficit Sept-Dec 2023
20
21
WorkshopsGross CostGross IncomeNet Income
22
Lindy Hop457.48740.88283.4
23
Edinburgh Balboa Weekend 1
3284.753521.93237.18
24
Collegiate Shag460.8731.6270.8
25
Edinburgh Balboa Weekend 2
3686.133721.1535.02
26
Slow Balboa154.98384229.02
27
Blues Dancing293.88509.7215.82
28
8338.029609.261271.24
Total Workshops Profit 2023
29
30
Overall event totals
20,220.0420,065.75-154.29
31
32
Anticipated Payments 2023
Cost
33
Insurance151.2
34
Website86.26
35
36
Other Payments 2023
37
Misc. (markers, name badges, cable, etc.)
20
38
Lindy venue deposit
200
39
Web domain name
9.54
40
Soundcore speaker
119.99
41
586.99
42
43
Total 2023 ExpenditureTotal 2023 Gross IncomeTotal 2023 Net Income
44
20,807.0320,065.75-741.28
Total Deficit 2023
45
46
2023 OVERALL
47
Upcoming Payments
20,807.03Expenses
48
Lindy venue359.120,065.75Gross Income
49
Sweet Swing venue in April
170-741.28
Net Income (Deficit)
50
529.1
51
6,426.62
Edinbop Current Finances
52
5,897.52
Minus Pending Payments
53
54
PREDICTED 2024
55
VenueTeachersDJWeekly CostYearly Cost (36 Weeks)2024 Gross Income Extrapolated2024 Predicted Net Income
56
Balboa Expenses (Nicholson Sq)
7540011541404437.36297.36
57
Lindy Expenses (Greyfriars)
119.74015174.76289.27027.92738.72
58
Southside Stomp
102.6030132.613261799.8473.8
59
60
Insurance151.2-151.2
61
Website50-50
62
Balboa venue deposit
240-240
63
Workshops830095001200
64
Live music2000-2000
65
22,496.4022,765.08268.68
Total Predicted Profit 2024
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100