2021-22_Financial_Report.xlsx

	A	B	C	D	E	F	G
1	FPHRA	Expenses	2021-2022	21-22 Budget	21-22 Var	22-23 Budget	Notes
2	Board
3		Accounting	$540.00	$450.00	$90.00	$550.00	Quickbooks rate change
4		Legal	$910.50	$1,000.00	$89.50	$2,500.00	Necessary Document Update in 22-23
5		Bank Fees	$476.85	$500.00	$23.15	$500.00	Banks charge 1% fee
6		Insurance	$9,906.21	$8,000.00	$1,906.21	$10,500.00	Significant increases
7		Annual Meeting	$327.86	$500.00	$172.14	$500.00
8		Supplies/Mailing	$270.73	$500.00	$229.27	$400.00	Continue reductions with E-bills and payments
9		Tax Return	$250.00	$250.00	$0.00	$250.00
10		Outreach	$48.04	$200.00	$151.96	$200.00
11		Website	$0.00	$0.00	$0.00	$350.00	Paid for 2 years
12		Total	$12,730.19	$11,400.00	$1,330.19	$15,750.00	One time legal increase and insurance costs
13	Capital
14		Playground	$0.00	$3,000.00	$3,000.00
15		General	$1,050.99	$0.00	$1,050.99	$3,000.00	General upgrades
16		AED	$1,386.00	$1,500.00	$114.00		Blue Fins donation to cover
17		Total	$2,436.99	$4,500.00	$2,063.01	$3,000.00
18	Pool
19		Management	$48,999.18	$50,000.00	$1,000.82	$52,000.00
20		Supplies and Incidentals	$4,237.34	$3,000.00	$1,237.34	$3,000.00	Large chemical purchase for next year
21		Total	$53,236.52	$53,000.00	$236.52	$55,000.00
22	Utilities
23		Xcel	$9,927.65	$9,000.00	$927.65	$10,000.00	Rate increases
24		Denver Water	$8,703.59	$4,000.00	$4,703.59	$9,000.00	Tier rate changes. Usage stayed similar
25		CenturyLink	$799.77	$200.00	$599.77	$0.00	Transaction error, unlikely to continue next year
26		Trash Service	$215.77	$250.00	$34.23	$250.00
27		Security	$629.90	$800.00	$170.10	$800.00
28		Sewer/Storm Water	$1,388.77	$1,300.00	$88.77	$1,400.00
29		Total	$21,665.45	$15,550.00	$6,115.45	$21,450.00
30	Social
31		4th of July	$1,641.34	$1,500.00	$141.34	$1,750.00
32		Oktoberfest	$1,689.30	$1,500.00	$189.30	$1,750.00
33		Misc	$486.53	$0.00	$486.53	$500.00
34		Total	$3,817.17	$3,000.00	$817.17	$4,000.00	Increasing costs and some new events
35	Maintenance
36		Spring Cleanup	$958.00	$1,000.00	$42.00	$1,000.00
37		Fall Cleanup	$439.00	$0.00	$439.00	$1,000.00	Fall Cleanup 2022 included Dry Creek support
38		Grounds Maintenance	$4,710.20	$6,000.00	$1,289.80	$6,000.00	Two year contract in work for 23/24
39		Misc Repairs	$609.00	$1,500.00	$891.00	$1,500.00
40		Total	$6,716.20	$8,500.00	$1,783.80	$9,500.00
41	Tennis
42		Total	$0.00	$0.00	$0.00	$0.00
43
44	Totals		$100,602.52	$95,950.00	$4,652.52	$108,700.00	Significant inflation to costs
45
46
47	Income
48		Dues	$100,525.00	$101,060.00	$535.00	$117,360.00	Dues increase to $800 on 6/1/2023
49		Fees/Closings	$1,760.00	$1,000.00	$760.00	$1,000.00	Several Home sales
50		Other	$90.00	$0.00	$90.00	$0.00
51		Total	$102,375.00	$102,060.00	$315.00	$118,360.00	(2023-24 income ~ $130,000)
52
53	Balances		1-Oct-21	1-Oct-22		Change
54		Checking	$29,113.58	$23,421.12		-$5,692.46
55		Reserve	$39,278.26	$39,291.47		$13.21
56		Total Assets	$68,391.84	$62,712.59		-$5,679.25
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