ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Actual Numbers from 2022-01 to 2022-12
2
Required Expenses
Cost Per Month
Cost Per Year
3
Mortgage (Lenox)$2,850.00$34,200.00
4
Electric and Gas (Lenox)$15,484.73
5
Insurance (Both)$7,977.00
6
Water (Lenox)$2,353.70
7
Garbage (Lenox)$3,063.62
8
Garbage (Norwich)$2,136.00
9
Internat (Lenox)$1,379.88
10
Internet (Norwich)$1,439.88
11
Fire (Lenox)$600.98
12
Cleaning (Lenox)$4,082.07
13
Rent (Norwich)$47,392.02
14
Total$120,109.88
15
16
Additional Expenses
17
Excess Mortgage Principal$150.00$1,800.00
18
Total$1,800.00
19
20
Combined Total$121,909.88
21
Lenox Total$66,953.48
22
Norwich Total$50,967.90
23
24
Operating Costs
25
Lenox Building Square Footage16,000.00
26
Actual Cost Per Square Foot$4.18
27
28
Norwich Building Square Footage10,785.00
29
Actual Cost Per Square Foot$4.73
30
31
32
Projected Numbers for 2023
33
Required Expenses
Cost Per Month
Cost Per Year
34
Mortgage (Lenox)$2,850.00$34,200.00
35
Electric and Gas (Lenox)$16,258.97
36
Insurance (Both)$8,375.85
37
Water (Lenox)$2,471.39
38
Garbage (Lenox)$3,664.20
39
Garbage (Norwich)$2,196.00
40
Internat (Lenox)$1,379.88
41
Internet (Norwich)$1,439.88
42
Fire (Lenox)$631.03
43
Cleaning (Lenox)$4,286.17
44
Rent (Norwich)$49,406.76
45
Total$124,310.12
46
47
Additional Expenses
48
Excess Mortgage Principal$150.00$1,800.00
49
Total$1,800.00
50
51
Combined Total$126,110.12
52
Lenox Total$68,879.56
53
Norwich Total$53,042.64
54
55
Operating Costs
56
Lenox Building Square Footage16,000.00
57
Actual Cost Per Square Foot$4.30
58
59
Norwich Building Square Footage10,785.00
60
Actual Cost Per Square Foot$4.92
61
62
63
Actual 2022 Spending Total$315,631.76
64
Actual 2022 Income Total$297,305.42
65
Actual 2022 Change in total funds-$18,326.34
66
Actual 2022 Change in area funds$9,895
67
Actual 2022 Change in general funds-$28,221
68
69
Actual 2022 Sublet Rent Paid out to MV$106,025.52
70
71
Actual 2022 Excess Spending after removing Required Expenses and Sublet Rent
$87,696.36
72
73
Projected 2023 Income at 545 members$215,247.75
74
75
Projections Assuming We Continue Current Discressionary Spending and Area Funding
76
Projected 2023 Surplus (Flat Growth)$3,241.27
77
Projected 2023 Surplus (Shrink -50 Members)-$6,632.48
78
Projected 2023 Surplus (Grow +50 Members)$13,115.02
79
80
Breakeven Membership Size to afford Lenox based on 2019 actual with no storage rental
81
164 Members
82
83
Projections are simplified per the following assumptions:
84
Historical Average Split in membership
78% General, 22% Family, ~25% on yearly billing
85
Average Yearly Dues Income Per Member$394.95
86
Membership growth/shrinkage occurs linearly over the course of the next 12 months
87
88
89
90
91
92
93
94
95
96
97
98
99
100