Rockwell Estates 2026 Budget Worksheet.xlsx

	A	B	C	E	G	H	I	J	K	L	M	N	O	P
1	#400 ROCKWELL ESTATES HOMES ASSOCIATION
2	2026 Budget Worksheet
3	Acct #			2024 Actual	2025 Actual	2026 Budget	% of Income

4	REVENUE:								Projected Dues Schedule
5		Base Assessment		$52,925	$57,750	$63,910			2026 Dues	Homes
6		Late Fees & Penalties		$1,216	$2,133	$1,522			$385.00	166	YoY +	Dues	Rentals	Total Income
7		Interest on Investments		$637	$367	$637			2026	$385	$39	$63,910	$4,000	$67,910
8		Clubhouse Rental		$3,300	$5,125	$4,000			2027	$424	$42	$70,301	$4,000	$74,301
9		Fundraising Activities		$2,595	$0	$0			2028	$466	$47	$77,331	$4,000	$81,331
10		Other Income		$0	$100	$0			2029	$512	$51	$85,064	$4,000	$89,064
11		Total Revenues		$60,673	$65,475	$70,069			2030	$564	$56	$93,571	$4,000	$97,571
12	EXPENSES:								2031	$620	$62	$102,928	$4,000	$106,928
13		Administrative Expenses
14	50100		Admin Fee	$3,950	$4,200	$4,200	5.99%		Debt Service
15	50300		Other HAKC Services	$0	$0	$0			$882.32	per month	Maturity Date: August 1, 2027
16	50400		Insurance	$6,144	$6,372	$6,425	9.17%
17	50450		Taxes / Annual Report	$765	$1,432	$1,013	1.45%
18	50500		Legal Services	$60	$20	$0
19	50700		Printing Postage & Supplies	$419	$673	$518	0.74%
20	50621		Meetings	$0	$0	$0
21			Website	$443	$499	$476	0.68%
22	52400		Misc. Admin	$592	$546	$597	0.85%
23		Total Administrative Expenses		$12,374	$13,742	$13,229		% of Budget
24		Operating Expenses						% of Budget
25	50600		Grounds Maint. Contract	$9,785	$17,293	$10,500	14.99%	$13,500	19.27%	*Contract signed for $10,500 for 2026 at $1,500/month April - October
26	50601		Grounds Maint. Other	$583	$362	$3,000	4.28%
27	50602		Irrigation	$207	$0	$0
28	50618		Pool Maintenance Contract	$5,793	$4,118	$4,400	6.28%	$15,552	22.19%
29	50619		Pool Repairs	$511	$3,044	$4,816	6.87%
30	50620		Pool Supplies & Chemicals	$4,891	$8,673	$6,336	9.04%
31	50621		Clubhouse R&M	$141	$382	$226	0.32%
32	51900		Social Activities	$3,041	$2,175	$2,854	4.07%
33	52200		Utilities-Electric	$5,155	$5,229	$5,450	7.78%	$10,499	14.98%
34	52201		Utilities -- Gas	$1,366	$1,225	$1,364	1.95%
35			Utilities - Trash	$0	$375	$788	1.12%
36	52202		Utilities-Water/Sewer	$3,136	$2,347	$2,898	4.14%
37	52203		Phone/Internet	$3,547	$2,998	$3,450	4.92%
38		Total Operating Expenses		$38,156	$48,221	$46,080
39		Captial Improvements
40	50622		Capital Improvements - Grounds	$0	$0	$0
41	50623		Capital Improvements -- Pool	$1,860	$0	$0
42	50624		Capital Improvements -- Clubhouse/HVAC	$0	$7,300	$0
43	50624		Capital Improvements -- Playground	$22,987	$11,470	$10,588	15.11%	$10,588	15.11%
44		Total Captial Improvement Expense		$24,847	$18,770	$10,588
45		Total Expenses		$75,376	$80,733	$69,897
46		Excess of Revenues Over Expenses		-$14,703	-$15,258	$172
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
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