| 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 | 2024 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 = | $1,300.00 | $3,900.00 | $3,250.00 | $3,575.00 | $3,575.00 | $3,900.00 | $2,275.00 | $4,550.00 | $4,225.00 | $2,925.00 | $3,900.00 | $3,700.00 | |||||||||||||
6 | Condo Fees Due | $13,000.00 | $10,400.00 | $11,050.00 | $10,725.00 | $10,725.00 | $10,400.00 | $12,025.00 | $9,750.00 | $10,075.00 | $11,375.00 | $10,400.00 | $10,600.00 | $171,600.00 | ||||||||||||
7 | ||||||||||||||||||||||||||
8 | II. INCOME | |||||||||||||||||||||||||
9 | Monthly Condo Fees Due & Paid + | $13,000.00 | $10,400.00 | $11,050.00 | $10,725.00 | $10,725.00 | $10,400.00 | $12,025.00 | $9,750.00 | $10,075.00 | $11,375.00 | $10,400.00 | $10,600.00 | |||||||||||||
10 | Monthly Fees Paid In Adv This Month + | $16,700.00 | $1,625.00 | $1,300.00 | $2,600.00 | $4,550.00 | $6,175.00 | $325.00 | $2,600.00 | $325.00 | $10,220.00 | |||||||||||||||
11 | Other Income + | $2,575.00 | $75.00 | $10.58 | ||||||||||||||||||||||
12 | Transfers Fr Pre-Pay Or Other Accts = | $1,300.00 | $3,900.00 | $3,250.00 | $3,575.00 | $3,575.00 | $3,900.00 | $2,275.00 | $4,550.00 | $4,225.00 | $2,925.00 | $9,900.00 | $8,700.00 | |||||||||||||
13 | Monthly Deposits (Per Bank Stmt) + | $33,575.00 | $14,300.00 | $15,925.00 | $15,600.00 | $16,900.00 | $18,850.00 | $20,475.00 | $14,300.00 | $14,625.00 | $16,900.00 | $20,700.00 | $29,530.58 | |||||||||||||
14 | C/O From Previous Month Checking - | $14,578.55 | $7,416.18 | $9,680.49 | $21,737.34 | $21,951.98 | $17,814.35 | $8,950.81 | $10,842.29 | $14,018.76 | $8,594.11 | $2,951.53 | $6,157.66 | |||||||||||||
15 | Transfer To Pre-Pay Or Other Accts = | $19,200.00 | $1,625.00 | $1,300.00 | $2,600.00 | $4,550.00 | $6,175.00 | $325.00 | $2,600.00 | $325.00 | $10,220.00 | |||||||||||||||
16 | Transfer To High Int Savings Acct | $10,000.00 | ||||||||||||||||||||||||
17 | Total Income | $28,953.55 | $21,716.18 | $23,980.49 | $36,037.34 | $26,251.98 | $32,114.35 | $23,250.81 | $25,142.29 | $28,318.76 | $22,894.11 | $23,326.53 | $25,468.24 | |||||||||||||
18 | ||||||||||||||||||||||||||
19 | III. PAID EXPENSES | |||||||||||||||||||||||||
20 | Contract Services | |||||||||||||||||||||||||
21 | Lawncare Maintenance (Cameron) | $6,447.47 | $6,447.47 | $6,447.47 | $6,713.35 | $6,447.47 | $6,447.47 | $6,447.47 | $5,450.44 | $50,848.61 | $96.30 | $53,500.00 | ||||||||||||||
22 | Snow Removal & Sand/Salt (Cameron) | $14,219.01 | $9,913.08 | rer | $11,964.38 | $36,096.47 | $68.36 | $36,000.00 | ||||||||||||||||||
23 | Fertilization, Etc. (TruGreen) | $2,205.04 | $3,617.05 | $1,763.26 | $5,137.34 | $1,836.76 | $14,559.45 | $27.57 | $10,100.00 | |||||||||||||||||
24 | Irrigation System Maint(Anderson) | $2,220.06 | $904.77 | $2,220.06 | $47.86 | $5,392.75 | $10.21 | $5,000.00 | ||||||||||||||||||
25 | Tree Removal/Replacement | $1,276.20 | $6,050.25 | $2,499.23 | $2,020.65 | $11,846.33 | $22.44 | $7,000.00 | ||||||||||||||||||
26 | Trash Removal (Waste Material) | $2,496.00 | $3,828.00 | $3,828.00 | $3,828.00 | $13,980.00 | $26.48 | $13,500.00 | ||||||||||||||||||
27 | Total Contract Services | $17,991.21 | $9,913.08 | $0.00 | $12,480.51 | $6,447.47 | $18,334.83 | $10,541.35 | $9,851.47 | $8,210.73 | $17,433.46 | $9,507.26 | $12,012.24 | $132,723.61 | $251.37 | $125,100.00 | ||||||||||
28 | % of Total Expenses | 72.42% | 72.90% | |||||||||||||||||||||||
29 | ||||||||||||||||||||||||||
30 | Other Maintenance | |||||||||||||||||||||||||
31 | Sidewalk/Asphalt/Lights, Etc. | $1,914.30 | $1,914.30 | $3.63 | $2,500.00 | |||||||||||||||||||||
32 | Misc Grounds Maintneance | $465.82 | $25.97 | $674.18 | $451.75 | $1,463.65 | $3,081.37 | $5.84 | $3,850.00 | |||||||||||||||||
33 | Landscape Services | $157.50 | $45.00 | $495.00 | $135.00 | $180.00 | $180.00 | $69.62 | $665.00 | $1,927.12 | $3.65 | $3,000.00 | ||||||||||||||
34 | Seasonal Planting Projects | $444.36 | $225.00 | $654.66 | $270.00 | $764.16 | $87.55 | $24.98 | $2,470.71 | $4.68 | $3,000.00 | |||||||||||||||
35 | Total Other Maintenance | $0.00 | $0.00 | $0.00 | $601.86 | $270.00 | $1,120.48 | $765.00 | $160.97 | $854.18 | $1,395.91 | $2,071.47 | $2,153.63 | $9,393.50 | $17.79 | $12,350.00 | ||||||||||
36 | % of Total Expenses | 5.13% | 7.20% | |||||||||||||||||||||||
37 | ||||||||||||||||||||||||||
38 | Utilities | |||||||||||||||||||||||||
39 | Electricity (Eversource) | $146.16 | $169.27 | $165.76 | $102.99 | $99.47 | $128.09 | $188.57 | $211.09 | $200.70 | $213.21 | $216.14 | $179.29 | $2,020.74 | $3.83 | $1,360.00 | ||||||||||
40 | Water (Connecticut Water) | $334.39 | $2,521.15 | $9,509.04 | $5,650.98 | $18,015.56 | $34.12 | $15,000.00 | ||||||||||||||||||
41 | Total Utilities | $146.16 | $169.27 | $500.15 | $102.99 | $99.47 | $2,649.24 | $188.57 | $211.09 | $9,709.74 | $213.21 | $216.14 | $5,830.27 | $20,036.30 | $37.95 | $16,360.00 | ||||||||||
42 | % of Total Expenses | 10.93% | 9.53% | |||||||||||||||||||||||
43 | ||||||||||||||||||||||||||
44 | Insurance | |||||||||||||||||||||||||
45 | Liability/Property (Philadelphia Ins) | $4,374.00 | $4,374.00 | $8.28 | $4,600.00 | |||||||||||||||||||||
46 | D&O (Arc Excess) | $843.00 | $843.00 | $1.60 | $840.00 | |||||||||||||||||||||
47 | Total Insurance | $0.00 | $0.00 | $843.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $4,374.00 | $0.00 | $5,217.00 | $9.88 | $5,440.00 | ||||||||||
48 | % of Total Expenses | 2.85% | 3.17% | |||||||||||||||||||||||
49 | ||||||||||||||||||||||||||
50 | Administrative | |||||||||||||||||||||||||
51 | Audit /Tax return | $1,053.34 | $1,053.34 | $1.99 | $0.00 | |||||||||||||||||||||
52 | State Filing | $50.00 | $50.00 | $0.09 | $50.00 | |||||||||||||||||||||
53 | General Office, Meetings | $2,500.00 | $720.69 | $158.99 | $13.60 | $100.00 | $498.47 | $3,991.75 | $7.56 | $1,500.00 | ||||||||||||||||
54 | Total Administrative | $2,500.00 | $1,053.34 | $0.00 | $0.00 | $720.69 | $158.99 | $13.60 | $0.00 | $50.00 | $0.00 | $100.00 | $498.47 | $5,095.09 | $9.65 | $1,550.00 | ||||||||||
55 | % of Total Expenses | 2.78% | 0.90% | |||||||||||||||||||||||
56 | ||||||||||||||||||||||||||
57 | Reserves | |||||||||||||||||||||||||
58 | 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 | ||||||||||
59 | Cap Reserve Additional Contribution | $0.00 | $0.00 | |||||||||||||||||||||||
60 | Operating Reserve Contribution | $0.00 | $0.00 | |||||||||||||||||||||||
61 | Total Cap Reserve | $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 | ||||||||||
62 | % Of Total Expenses | 5.89% | 6.29% | |||||||||||||||||||||||
63 | ||||||||||||||||||||||||||
64 | TOTAL EXPENSES | $21,537.37 | $12,035.69 | $2,243.15 | $14,085.36 | $8,437.63 | $23,163.54 | $12,408.52 | $11,123.53 | $19,724.65 | $19,942.58 | $17,168.87 | $21,394.61 | $183,265.50 | $342.36 | $171,600.00 | ||||||||||
65 | Total Inc Less Total Exp = | |||||||||||||||||||||||||
66 | Checking Account Balance | $7,416.18 | $9,680.49 | $21,737.34 | $21,951.98 | $17,814.35 | $8,950.81 | $10,842.29 | $14,018.76 | $8,594.11 | $2,951.53 | $6,157.66 | $4,073.63 | |||||||||||||
67 | ||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | IV. CAPITAL RESERVE ACCOUNT/CDs | |||||||||||||||||||||||||
70 | Account Balance + | $3,157.17 | $4,057.25 | $4,957.32 | $5,857.42 | $6,757.53 | $7,657.66 | $8,557.79 | $4,457.94 | $5,358.03 | $6,258.13 | $7,158.25 | $8,058.38 | |||||||||||||
71 | Broker-Assisted CDs = | $90,000.00 | $90,000.00 | $95,000.00 | $95,000.00 | $95,000.00 | $100,000.00 | $100,000.00 | $100,000.00 | $105,000.00 | $105,000.00 | $105,000.00 | $110,000.00 | |||||||||||||
72 | Start Of Month Balance + | $93,157.17 | $94,057.25 | $99,957.32 | $100,857.42 | $101,757.53 | $107,657.66 | $108,557.79 | $104,457.94 | $110,358.03 | $111,258.13 | $112,158.25 | $118,058.38 | |||||||||||||
73 | 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 | |||||||||||||
74 | Additional Contribution - | |||||||||||||||||||||||||
75 | To Other Accts + | $5,000.00 | ||||||||||||||||||||||||
76 | Interest = | $0.08 | $0.07 | $0.10 | $0.11 | $0.13 | $0.13 | $0.15 | $0.09 | $0.10 | $0.12 | $0.13 | $0.16 | |||||||||||||
77 | End Of Month Balance | $94,057.25 | $94,957.32 | $100,857.42 | $101,757.53 | $102,657.66 | $108,557.79 | $104,457.94 | $105,358.03 | $111,258.13 | $112,158.25 | $113,058.38 | $118,958.54 | |||||||||||||
78 | ||||||||||||||||||||||||||
79 | V. OPERATING RESERVE ACCT/CD | |||||||||||||||||||||||||
80 | Start Of Month Balance + | $2,211.54 | $2,211.58 | $2,211.61 | $2,211.65 | $2,211.68 | $2,211.72 | $2,211.76 | $2,211.80 | $2,211.83 | $2,211.87 | $2,211.91 | $2,211.94 | |||||||||||||
81 | Broker-Assisted CD = | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | |||||||||||||
82 | Start Of Month Balance + | $14,211.54 | $14,211.58 | $14,211.61 | $14,211.65 | $14,211.68 | $14,211.72 | $14,211.76 | $14,211.80 | $14,211.83 | $14,211.87 | $14,211.91 | $14,211.94 | |||||||||||||
83 | Contribution - | |||||||||||||||||||||||||
84 | To Checking Acct + | |||||||||||||||||||||||||
85 | Interest = | $0.04 | $0.03 | $0.04 | $0.03 | $0.04 | $0.04 | $0.04 | $0.03 | $0.04 | $0.04 | $0.03 | $0.04 | |||||||||||||
86 | End Of Month Balance | $14,211.58 | $14,211.61 | $14,211.65 | $14,211.68 | $14,211.72 | $14,211.76 | $14,211.80 | $14,211.83 | $14,211.87 | $14,211.91 | $14,211.94 | $14,211.98 | |||||||||||||
87 | ||||||||||||||||||||||||||
88 | VI. PRE-PAY ACCOUNT | |||||||||||||||||||||||||
89 | Start Of Month Balance + | $4,649.38 | $10,049.63 | $6,149.75 | $4,524.84 | $2,249.92 | $4,774.98 | $5,425.11 | $6,825.26 | $2,275.35 | $1,375.38 | $1,050.43 | $1,475.45 | |||||||||||||
90 | From Checking Or From Other Acct - | $16,700.00 | $0.00 | $1,625.00 | $1,300.00 | $6,100.00 | $4,550.00 | $6,175.00 | $3,325.00 | $2,600.00 | $4,325.00 | $10,220.00 | ||||||||||||||
91 | To Checking Or To Other Acct + | $11,300.00 | $3,900.00 | $3,250.00 | $3,575.00 | $3,575.00 | $3,900.00 | $4,775.00 | $4,550.00 | $4,225.00 | $2,925.00 | $3,900.00 | $3,700.00 | |||||||||||||
92 | Interest = | $0.25 | $0.12 | $0.09 | $0.08 | $0.06 | $0.13 | $0.15 | $0.09 | $0.03 | $0.05 | $0.02 | $0.08 | |||||||||||||
93 | End Of Month Balance | $10,049.63 | $6,149.75 | $4,524.84 | $2,249.92 | $4,774.98 | $5,425.11 | $6,825.26 | $2,275.35 | $1,375.38 | $1,050.43 | $1,475.45 | $7,995.53 | |||||||||||||
94 | ||||||||||||||||||||||||||
95 | VII. High Int. Savings Account | |||||||||||||||||||||||||
96 | Start Of Month Balance + | $83,799.85 | $96,612.85 | $97,425.25 | $93,809.32 | $94,156.91 | $101,032.68 | $97,451.54 | $105,148.15 | $105,498.78 | $99,167.09 | $99,489.82 | $90,019.28 | |||||||||||||
97 | From Other Accts - | $12,500.00 | $0.00 | $10,000.00 | $7,500.00 | |||||||||||||||||||||
98 | To Other Accounts + | $5,000.00 | $3,500.00 | $5,000.00 | $8,000.00 | $10,000.00 | $10,000.00 | |||||||||||||||||||
99 | Interest = | $313.00 | $812.40 | $1,384.07 | $347.59 | $375.77 | $1,418.86 | $196.61 | $350.63 | $1,668.31 | $322.73 | $529.46 | $1,317.57 | |||||||||||||
100 | End Of Month Balance | $96,612.85 | $97,425.25 | $93,809.32 | $94,156.91 | $101,032.68 | $97,451.54 | $105,148.15 | $105,498.78 | $99,167.09 | $99,489.82 | $90,019.28 | $81,336.85 | |||||||||||||