Cash Flow Statement - 2019.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1			Chimney Hill E S T A T E S					2019 CASH FLOW STATEMENT						Month #	12
2		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	2019 Total	Cost Per Unit Per Mo.	Budget Estimate
3	I. MONTHLY CONDO FEES
4	Total Condo Fees Due -	$13,200.00	$13,200.00	$13,200.00	$13,200.00	$13,200.00	$13,200.00	$13,200.00	$13,200.00	$13,200.00	$13,200.00	$13,200.00	$13,200.00	$158,400.00
5	Less Previously Paid =	$2,400.00	$3,900.00	$3,600.00	$3,300.00	$4,200.00	$3,900.00	$2,700.00	$4,200.00	$4,200.00	$3,300.00	$3,900.00	$3,900.00
6	Condo Fees Due	$10,800.00	$9,300.00	$9,600.00	$9,900.00	$9,000.00	$9,300.00	$10,500.00	$9,000.00	$9,000.00	$9,900.00	$9,300.00	$9,300.00
7
8	II. INCOME
9	Monthly Condo Fees Due & Paid +	$10,500.00	$9,600.00	$9,600.00	$9,900.00	$9,000.00	$9,300.00	$10,500.00	$9,000.00	$9,000.00	$9,900.00	$9,300.00	$9,300.00
10	Monthly Fees Paid In Adv This Month +	$12,300.00	$300.00	$1,500.00	$4,800.00		$4,800.00	$5,700.00	$300.00	$300.00	$2,700.00	$3,900.00	$1,500.00
11	Other Income +				$75.00		$314.06		$0.50
12	Transfers Fr Pre-Pay Or Other Accts =	$2,400.00	$3,900.00	$3,600.00	$3,300.00	$4,200.00	$3,900.00	$2,700.00	$4,200.00	$4,200.00	$4,100.00	$3,900.00	$3,900.00
13	Monthly Deposits (Per Bank Stmt) +	$25,200.00	$13,800.00	$14,700.00	$18,075.00	$13,200.00	$18,314.06	$18,900.00	$13,500.50	$13,500.00	$16,700.00	$17,100.00	$14,700.00	$0.00
14	C/O From Previous Month Checking -	$37,346.83	$44,358.71	$35,735.33	$37,598.32	$39,833.59	$42,123.92	$43,291.35	$41,356.47	$45,985.49	$40,575.94	$35,817.87	$33,604.11
15	Transfer To Pre-Pay Acct =	$12,300.00	$300.00	$1,500.00	$4,800.00		$4,800.00	$5,700.00	$300.00	$300.00	$2,700.00	$3,900.00	$1,500.00
16	Total Income	$50,246.83	$57,858.71	$48,935.33	$50,873.32	$53,033.59	$55,637.98	$56,491.35	$54,556.97	$59,185.49	$54,575.94	$49,017.87	$46,804.11
17
18	III. PAID EXPENSES
19	Contract Services
20	Lawncare Maintenance (Cameron)				$5,935.72	$5,935.72	$5,935.72	$6,653.59	$5,935.72	$5,935.72	$5,935.72	$6,095.25		$48,363.16	$91.60	$48,500.00
21	Snow Removal & Sand/Salt (Cameron)	$1,653.74	$20,195.87	$9,922.46									$14,176.46	$45,948.53	$87.02	$36,000.00
22	Fertilization, Etc. (TruGreen)				$719.48	$972.11	$2,854.68	$191.43	$1,396.52		$2,974.65	$966.04		$10,074.91	$19.08	$14,000.00
23	Irrigation System Maint(Anderson)					$2,047.24			$132.35			$2,046.84		$4,226.43	$8.00	$6,000.00
24	Tree Removal/Replacement (McClellan)							$3,004.39		$2,875.58	$2,446.05			$8,326.02	$15.77	$5,000.00
25	Trash Removal (Waste Material)	$3,094.00			$3,370.47			$3,397.33			$3,432.00			$13,293.80	$25.18	$13,500.00
26	Total Contract Services	$4,747.74	$20,195.87	$9,922.46	$10,025.67	$8,955.07	$8,790.40	$13,246.74	$7,464.59	$8,811.30	$14,788.42	$9,108.13	$14,176.46	$130,232.85	$246.65	$123,000.00
27	% of Total Expenses													77.85%		77.65%
28
29	Other Maintenance
30	Sidewalk/Asphalt/Lights, Etc.					$89.76					$1,063.50			$1,153.26	$2.18	$1,100.00
31	Misc Grounds Maintneance						$1,715.15	$833.76		$94.76	$1,427.25	$921.27	$29.52	$5,021.71	$9.51	$1,300.00
32	Beautification Projects					$400.75				$620.00	$423.51			$1,444.26	$2.74	$2,000.00
33	Total Other Maintenance	$0.00	$0.00	$0.00	$0.00	$490.51	$1,715.15	$833.76	$0.00	$714.76	$2,914.26	$921.27	$29.52	$7,619.23	$14.43	$4,400.00
34	% of Total Expenses													4.55%		2.78%
35
36	Utilities
37	Electricity (Eversource)	$436.16	$424.51	$407.33	$314.06	$642.09	$278.40	$354.38	$360.38	$362.78	$355.39	$382.36	$414.49	$4,732.33	$8.96	$4,500.00
38	Water (Connecticut Water)			$307.22			$862.68			$7,970.71			$1,411.77	$10,552.38	$19.99	$12,500.00
39	Total Utilities	$436.16	$424.51	$714.55	$314.06	$642.09	$1,141.08	$354.38	$360.38	$8,333.49	$355.39	$382.36	$1,826.26	$15,284.71	$28.95	$17,000.00
40	% of Total Expenses													9.14%		10.73%
41
42	Insurance
43	Liability/Property (Philadelphia Ins)											$4,169.00		$4,169.00	$7.90	$4,100.00
44	D&O (Philadelphia Ins)		$803.00											$803.00	$1.52	$840.00
45	Total Insurance	$0.00	$803.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$4,169.00	$0.00	$4,972.00	$9.42	$4,940.00
46	% of Total Expenses													2.97%		3.12%
47
48	Administrative
49	Audit /Tax return	$4.22												$4.22	$0.01	$10.00
50	State Filing									$50.00				$50.00	$0.09	$50.00
51	General Office, Meetings					$122.00			$46.51			$133.00	$412.91	$714.42	$1.35	$600.00
52	Total Administrative	$4.22	$0.00	$0.00	$0.00	$122.00	$0.00	$0.00	$46.51	$50.00	$0.00	$133.00	$412.91	$768.64	$1.46	$660.00
53	% of Total Expenses													0.46%		0.42%
54
55	Reserves
56	Cap Reserve Monthly Contribution	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$8,400.00	$15.91	$8,400.00
57	Cap Reserve Additional Contribution													$0.00	$0.00
58	Operating Reserve Contribution													$0.00	$0.00
59	Total Cap Reserve	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$8,400.00	$15.91	$8,400.00
60	% Of Total Expenses													5.02%		5.30%
61
62	TOTAL EXPENSES	$5,888.12	$22,123.38	$11,337.01	$11,039.73	$10,909.67	$12,346.63	$15,134.88	$8,571.48	$18,609.55	$18,758.07	$15,413.76	$17,145.15	$167,277.43	$316.81	$158,400.00
63	Total Inc Less Total Exp =
64	Checking Account Balance	$44,358.71	$35,735.33	$37,598.32	$39,833.59	$42,123.92	$43,291.35	$41,356.47	$45,985.49	$40,575.94	$35,817.87	$33,604.11	$29,658.96
65
66	IV. PRE-PAY ACCOUNT
67	Start Of Month Balance	$12,396.71	$22,298.54	$18,700.17	$16,601.66	$18,103.34	$13,904.77	$14,805.97	$17,807.68	$13,909.04	$10,010.23	$9,411.07	$9,411.94
68	From Checking Acct	$12,300.00	$300.00	$1,500.00	$4,800.00		$4,800.00	$5,700.00	$300.00	$300.00	$2,700.00	$3,900.00	$1,500.00
69	To Checking Acct	$2,400.00	$3,900.00	$3,600.00	$3,300.00	$4,200.00	$3,900.00	$2,700.00	$4,200.00	$4,200.00	$3,300.00	$3,900.00	$3,900.00
70	Interest	$1.83	$1.63	$1.49	$1.68	$1.43	$1.20	$1.71	$1.36	$1.19	$0.84	$0.87	$0.79
71	End Of Month Balance	$22,298.54	$18,700.17	$16,601.66	$18,103.34	$13,904.77	$14,805.97	$17,807.68	$13,909.04	$10,010.23	$9,411.07	$9,411.94	$7,012.73
72
73	V. CAPITAL RESERVE ACCOUNT/CD
74	Start Of Month Balance	$78,143.78	$78,850.47	$79,556.56	$80,262.91	$80,969.98	$81,679.70	$82,558.76	$83,395.39	$84,219.91	$85,048.90	$85,878.23	$86,699.50
75	Budgeted Contribution	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00	$700.00
76	Additional Contribution
77	To Checking Acct
78	Interest	$6.69	$6.09	$6.35	$7.07	$9.72	$179.06	$136.63	$124.52	$128.99	$129.33	$121.27	$134.15
79	End Of Month Balance	$78,850.47	$79,556.56	$80,262.91	$80,969.98	$81,679.70	$82,558.76	$83,395.39	$84,219.91	$85,048.90	$85,878.23	$86,699.50	$87,533.65
80
81	VI. OPERATING RESERVE ACCT/CD
82	Start Of Month Balance	$14,876.54	$14,877.80	$14,878.95	$14,880.13	$14,881.43	$14,883.26	$14,918.95	$14,946.12	$14,970.88	$14,996.50	$14,222.13	$14,246.14
83	Contribution
84	To Checking Acct										$800.00
85	Interest	$1.26	$1.15	$1.18	$1.30	$1.83	$35.69	$27.17	$24.76	$25.62	$25.63	$24.01	$26.55
86	End Of Month Balance	$14,877.80	$14,878.95	$14,880.13	$14,881.43	$14,883.26	$14,918.95	$14,946.12	$14,970.88	$14,996.50	$14,222.13	$14,246.14	$14,272.69
87
88
89
90
91
92
93
94
95
96
97
98
99
100