| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Chimney Hill E S T A T E S | 2022 CASH FLOW STATEMENT | Month # | 12 | ||||||||||||||||||||||
2 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 2022 Total | Cost Per Unit Per Mo. | Budget Estimate | |||||||||||
3 | I. MONTHLY CONDO FEES | |||||||||||||||||||||||||
4 | Total Condo Fees Due - | $14,300.00 | $14,300.00 | $14,300.00 | $14,300.00 | $14,300.00 | $14,300.00 | $14,300.00 | $14,300.00 | $14,300.00 | $14,300.00 | $14,300.00 | $14,300.00 | $171,600.00 | ||||||||||||
5 | Less Previously Paid = | $975.00 | $4,550.00 | $4,225.00 | $3,575.00 | $4,550.00 | $4,550.00 | $3,250.00 | $4,550.00 | $4,550.00 | $3,900.00 | $3,900.00 | $4,225.00 | |||||||||||||
6 | Condo Fees Due | $13,325.00 | $9,750.00 | $10,075.00 | $10,725.00 | $9,750.00 | $9,750.00 | $11,050.00 | $9,750.00 | $9,750.00 | $10,400.00 | $10,400.00 | $10,075.00 | |||||||||||||
7 | ||||||||||||||||||||||||||
8 | II. INCOME | |||||||||||||||||||||||||
9 | Monthly Condo Fees Due & Paid + | $13,350.00 | $9,750.00 | $10,075.00 | $10,725.00 | $9,750.00 | $9,750.00 | $11,050.00 | $9,750.00 | $9,750.00 | $10,400.00 | $10,400.00 | $10,075.00 | |||||||||||||
10 | Monthly Fees Paid In Adv This Month + | $20,275.00 | $325.00 | $2,600.00 | $1,950.00 | $6,175.00 | $7,150.00 | $975.00 | $650.00 | $1,950.00 | $975.00 | $4,225.00 | ||||||||||||||
11 | Other Income + | $75.00 | $75.00 | |||||||||||||||||||||||
12 | Transfers Fr Pre-Pay Or Other Accts = | $975.00 | $4,550.00 | $4,225.00 | $3,575.00 | $4,550.00 | $4,550.00 | $3,250.00 | $4,550.00 | $4,550.00 | $3,900.00 | $3,900.00 | $4,225.00 | |||||||||||||
13 | Monthly Deposits (Per Bank Stmt) + | $34,600.00 | $14,300.00 | $14,625.00 | $16,975.00 | $16,250.00 | $20,550.00 | $21,450.00 | $15,275.00 | $14,950.00 | $16,250.00 | $15,275.00 | $18,525.00 | |||||||||||||
14 | C/O From Previous Month Checking - | $52,402.70 | $51,603.67 | $53,015.67 | $60,117.17 | $58,168.43 | $57,351.49 | $56,964.43 | $51,736.71 | $56,562.42 | $42,612.33 | $42,338.98 | $42,586.40 | |||||||||||||
15 | Transfer To Pre-Pay Acct = | $20,275.00 | $325.00 | $2,600.00 | $1,950.00 | $6,175.00 | $7,150.00 | $975.00 | $650.00 | $1,950.00 | $975.00 | $4,225.00 | ||||||||||||||
16 | Total Income | $66,727.70 | $65,578.67 | $67,640.67 | $74,492.17 | $72,468.43 | $71,726.49 | $71,264.43 | $66,036.71 | $70,862.42 | $56,912.33 | $56,638.98 | $56,886.40 | |||||||||||||
17 | ||||||||||||||||||||||||||
18 | III. PAID EXPENSES | |||||||||||||||||||||||||
19 | Contract Services | |||||||||||||||||||||||||
20 | Lawncare Maintenance (Cameron) | $6,281.30 | $6,458.49 | $6,517.55 | $6,966.59 | $6,458.49 | $6,281.30 | $6,919.40 | $6,281.30 | $52,164.42 | $98.80 | $52,000.00 | ||||||||||||||
21 | Snow Removal & Sand/Salt (Cameron) | $11,735.73 | $11,501.75 | $5,253.69 | $3,094.79 | $31,585.96 | $59.82 | $37,000.00 | ||||||||||||||||||
22 | Fertilization, Etc. (TruGreen) | $1,914.31 | $1,650.15 | $1,580.40 | $1,580.40 | $1,100.11 | $1,643.29 | $9,468.66 | $17.93 | $11,000.00 | ||||||||||||||||
23 | Irrigation System Maint(Anderson) | $2,257.28 | $175.42 | $71.79 | $138.26 | $2,220.06 | $4,862.81 | $9.21 | $5,000.00 | |||||||||||||||||
24 | Tree Removal/Replacement | $5,636.55 | $5,636.55 | $10.68 | $8,000.00 | |||||||||||||||||||||
25 | Trash Removal (Waste Material) | $2,340.00 | $3,507.00 | $500.00 | $3,432.00 | $3,432.00 | $13,211.00 | $25.02 | $13,500.00 | |||||||||||||||||
26 | Total Contract Services | $14,075.73 | $11,501.75 | $5,253.69 | $13,959.89 | $6,633.91 | $8,739.49 | $17,615.54 | $8,038.89 | $7,519.67 | $12,571.46 | $7,924.59 | $3,094.79 | $116,929.40 | $221.46 | $126,500.00 | ||||||||||
27 | % of Total Expenses | 65.55% | 73.72% | |||||||||||||||||||||||
28 | ||||||||||||||||||||||||||
29 | Other Maintenance | |||||||||||||||||||||||||
30 | Sidewalk/Asphalt/Lights, Etc. | $400.29 | $2,500.00 | $2,900.29 | $5.49 | $2,010.00 | ||||||||||||||||||||
31 | Misc Grounds Maintneance | $6,647.03 | $65.31 | $436.04 | $203.13 | $3,146.25 | $300.00 | $52.15 | $10,849.91 | $20.55 | $3,150.00 | |||||||||||||||
32 | Landscape Services | $202.01 | $315.00 | $262.01 | $175.00 | $66.98 | $420.00 | $488.97 | $559.23 | $690.00 | $3,179.20 | $6.02 | $3,000.00 | |||||||||||||
33 | Seasonal Planting Projects | $194.00 | $105.00 | $658.40 | $175.00 | $733.27 | $210.00 | $168.69 | $2,244.36 | $4.25 | $3,000.00 | |||||||||||||||
34 | Total Other Maintenance | $0.00 | $0.00 | $202.01 | $509.00 | $7,014.04 | $1,124.00 | $786.04 | $270.11 | $4,299.52 | $998.97 | $611.38 | $3,358.69 | $19,173.76 | $36.31 | $11,160.00 | ||||||||||
35 | % of Total Expenses | 10.75% | 6.50% | |||||||||||||||||||||||
36 | ||||||||||||||||||||||||||
37 | Utilities | |||||||||||||||||||||||||
38 | Electricity (Eversource) | $107.83 | $161.25 | $169.02 | $111.85 | $96.29 | $170.86 | $83.92 | $196.81 | $202.14 | $102.92 | $100.61 | $115.45 | $1,618.95 | $3.07 | $4,500.00 | ||||||||||
39 | Water (Connecticut Water) | $321.36 | $3,194.58 | $14,795.89 | $2,057.39 | $20,369.22 | $38.58 | $12,500.00 | ||||||||||||||||||
40 | Total Utilities | $107.83 | $161.25 | $490.38 | $111.85 | $96.29 | $3,365.44 | $83.92 | $196.81 | $14,998.03 | $102.92 | $100.61 | $2,172.84 | $21,988.17 | $41.64 | $17,000.00 | ||||||||||
41 | % of Total Expenses | 12.33% | 9.91% | |||||||||||||||||||||||
42 | ||||||||||||||||||||||||||
43 | Insurance | |||||||||||||||||||||||||
44 | Liability/Property (Philadelphia Ins) | $4,360.00 | $4,360.00 | $8.26 | $4,600.00 | |||||||||||||||||||||
45 | D&O (Philadelphia Ins) | $843.00 | $843.00 | $1.60 | $840.00 | |||||||||||||||||||||
46 | Total Insurance | $0.00 | $0.00 | $0.00 | $843.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $4,360.00 | $0.00 | $5,203.00 | $9.85 | $5,440.00 | ||||||||||
47 | % of Total Expenses | 2.92% | 3.17% | |||||||||||||||||||||||
48 | ||||||||||||||||||||||||||
49 | Administrative | |||||||||||||||||||||||||
50 | Audit /Tax return | $40.47 | $40.47 | $0.08 | $0.00 | |||||||||||||||||||||
51 | State Filing | $50.00 | $50.00 | $0.09 | $50.00 | |||||||||||||||||||||
52 | General Office, Meetings | $472.70 | $20.00 | $142.22 | $68.48 | $156.00 | $586.72 | $1,446.12 | $2.74 | $650.00 | ||||||||||||||||
53 | Total Administrative | $40.47 | $0.00 | $0.00 | $0.00 | $472.70 | $20.00 | $142.22 | $68.48 | $50.00 | $0.00 | $156.00 | $586.72 | $1,536.59 | $2.91 | $700.00 | ||||||||||
54 | % of Total Expenses | 0.86% | 0.41% | |||||||||||||||||||||||
55 | ||||||||||||||||||||||||||
56 | Reserves | |||||||||||||||||||||||||
57 | Cap Reserve Monthly Contribution | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $10,800.00 | $20.45 | $10,800.00 | ||||||||||
58 | Cap Reserve Additional Contribution | $677.42 | $613.13 | $482.87 | $968.43 | $2,741.85 | $5.19 | |||||||||||||||||||
59 | Operating Reserve Contribution | $0.00 | $0.00 | |||||||||||||||||||||||
60 | Total Cap Reserve | $900.00 | $900.00 | $1,577.42 | $900.00 | $900.00 | $1,513.13 | $900.00 | $900.00 | $1,382.87 | $900.00 | $900.00 | $1,868.43 | $13,541.85 | $25.65 | $10,800.00 | ||||||||||
61 | % Of Total Expenses | 7.59% | 6.29% | |||||||||||||||||||||||
62 | ||||||||||||||||||||||||||
63 | TOTAL EXPENSES | $15,124.03 | $12,563.00 | $7,523.50 | $16,323.74 | $15,116.94 | $14,762.06 | $19,527.72 | $9,474.29 | $28,250.09 | $14,573.35 | $14,052.58 | $11,081.47 | $178,372.77 | $337.83 | $171,600.00 | ||||||||||
64 | Total Inc Less Total Exp = | |||||||||||||||||||||||||
65 | Checking Account Balance | $51,603.67 | $53,015.67 | $60,117.17 | $58,168.43 | $57,351.49 | $56,964.43 | $51,736.71 | $56,562.42 | $42,612.33 | $42,338.98 | $42,586.40 | $45,804.93 | |||||||||||||
66 | ||||||||||||||||||||||||||
67 | IV. PRE-PAY ACCOUNT | |||||||||||||||||||||||||
68 | Start Of Month Balance | $4,194.99 | $23,495.18 | $18,945.35 | $15,045.50 | $14,070.62 | $11,470.74 | $13,095.85 | $16,995.99 | $13,421.14 | $9,521.32 | $7,571.46 | $4,646.58 | |||||||||||||
69 | From Checking Acct | $20,275.00 | $325.00 | $2,600.00 | $1,950.00 | $6,175.00 | $7,150.00 | $975.00 | $650.00 | $1,950.00 | $975.00 | $4,225.00 | ||||||||||||||
70 | To Checking Acct | $975.00 | $4,550.00 | $4,225.00 | $3,575.00 | $4,550.00 | $4,550.00 | $3,250.00 | $4,550.00 | $4,550.00 | $3,900.00 | $3,900.00 | $4,225.00 | |||||||||||||
71 | Interest | $0.19 | $0.17 | $0.15 | $0.12 | $0.12 | $0.11 | $0.14 | $0.15 | $0.18 | $0.14 | $0.12 | $0.09 | |||||||||||||
72 | End Of Month Balance | $23,495.18 | $18,945.35 | $15,045.50 | $14,070.62 | $11,470.74 | $13,095.85 | $16,995.99 | $13,421.14 | $9,521.32 | $7,571.46 | $4,646.58 | $4,646.67 | |||||||||||||
73 | ||||||||||||||||||||||||||
74 | V. CAPITAL RESERVE ACCOUNT/CD | |||||||||||||||||||||||||
75 | Start Of Month Balance | $90,504.96 | $91,407.84 | $92,310.45 | $93,890.77 | $94,793.49 | $95,696.02 | $97,209.95 | $98,110.73 | $99,011.62 | $100,396.08 | $101,297.80 | $102,199.13 | |||||||||||||
76 | Budgeted Contribution | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | $900.00 | |||||||||||||
77 | Additional Contribution | $677.42 | $613.13 | $482.87 | $968.43 | |||||||||||||||||||||
78 | To Checking Acct | |||||||||||||||||||||||||
79 | Interest | $2.88 | $2.61 | $2.90 | $2.72 | $2.53 | $0.80 | $0.78 | $0.89 | $1.59 | $1.72 | $1.33 | $0.39 | |||||||||||||
80 | End Of Month Balance | $91,407.84 | $92,310.45 | $93,890.77 | $94,793.49 | $95,696.02 | $97,209.95 | $98,110.73 | $99,011.62 | $100,396.08 | $101,297.80 | $102,199.13 | $104,067.95 | |||||||||||||
81 | ||||||||||||||||||||||||||
82 | VI. OPERATING RESERVE ACCT/CD | |||||||||||||||||||||||||
83 | Start Of Month Balance | $14,202.03 | $14,202.61 | $14,203.14 | $14,203.72 | $14,204.28 | $14,204.86 | $14,205.33 | $14,205.78 | $14,206.29 | $14,206.75 | $14,207.23 | $14,207.70 | |||||||||||||
84 | Contribution | |||||||||||||||||||||||||
85 | To Checking Acct | |||||||||||||||||||||||||
86 | Interest | $0.58 | $0.53 | $0.58 | $0.56 | $0.58 | $0.47 | $0.45 | $0.51 | $0.46 | $0.48 | $0.47 | $0.47 | |||||||||||||
87 | End Of Month Balance | $14,202.61 | $14,203.14 | $14,203.72 | $14,204.28 | $14,204.86 | $14,205.33 | $14,205.78 | $14,206.29 | $14,206.75 | $14,207.23 | $14,207.70 | $14,208.17 | |||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||