| 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 | 2021 CASH FLOW STATEMENT | Month # | 12 | ||||||||||||||||||||||
2 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 2021 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,570.00 | ||||||||||||
5 | Less Previously Paid = | $900.00 | $4,800.00 | $4,800.00 | $3,600.00 | $3,900.00 | $4,800.00 | $2,400.00 | $4,200.00 | $3,900.00 | $3,900.00 | $3,600.00 | $3,900.00 | |||||||||||||
6 | Condo Fees Due | $12,300.00 | $8,400.00 | $8,400.00 | $9,600.00 | $9,300.00 | $8,400.00 | $10,800.00 | $9,000.00 | $9,300.00 | $9,300.00 | $9,600.00 | $9,300.00 | |||||||||||||
7 | ||||||||||||||||||||||||||
8 | II. INCOME | |||||||||||||||||||||||||
9 | Monthly Condo Fees Due & Paid + | $12,300.00 | $8,400.00 | $8,100.00 | $9,900.00 | $9,300.00 | $8,400.00 | $10,800.00 | $9,000.00 | $9,300.00 | $9,300.00 | $9,600.00 | $9,300.00 | |||||||||||||
10 | Monthly Fees Paid In Adv This Month + | $19,500.00 | $300.00 | $300.00 | $1,500.00 | $2,700.00 | $5,100.00 | $6,300.00 | $600.00 | $900.00 | $1,500.00 | $2,700.00 | $2,275.00 | |||||||||||||
11 | Other Income + | $75.00 | $75.00 | $75.00 | $62.74 | |||||||||||||||||||||
12 | Transfers Fr Pre-Pay Or Other Accts = | $1,180.96 | $4,800.00 | $4,800.00 | $3,600.00 | $3,900.00 | $4,800.00 | $11,580.00 | $4,200.00 | $3,900.00 | $9,900.00 | $3,600.00 | $3,900.00 | |||||||||||||
13 | Monthly Deposits (Per Bank Stmt) + | $32,980.96 | $13,500.00 | $13,200.00 | $15,075.00 | $15,975.00 | $18,300.00 | $28,755.00 | $13,800.00 | $14,100.00 | $20,700.00 | $15,962.74 | $15,475.00 | |||||||||||||
14 | C/O From Previous Month Checking - | $46,201.71 | $52,228.35 | $41,249.45 | $51,912.75 | $53,282.42 | $56,314.76 | $56,277.72 | $51,897.28 | $52,439.04 | $52,636.52 | $50,560.39 | $46,926.10 | |||||||||||||
15 | Transfer To Pre-Pay Or Cap Acct = | $19,500.00 | $300.00 | $300.00 | $1,500.00 | $2,700.00 | $5,100.00 | $6,300.00 | $600.00 | $900.00 | $1,500.00 | $2,700.00 | $2,275.00 | |||||||||||||
16 | Total Income | $59,682.67 | $65,428.35 | $54,149.45 | $65,487.75 | $66,557.42 | $69,514.76 | $78,732.72 | $65,097.28 | $65,639.04 | $71,836.52 | $63,823.13 | $60,126.10 | |||||||||||||
17 | ||||||||||||||||||||||||||
18 | III. PAID EXPENSES | |||||||||||||||||||||||||
19 | Contract Services | |||||||||||||||||||||||||
20 | Lawncare Maintenance (Cameron) | $6,054.44 | $6,054.44 | $6,426.67 | $6,692.54 | $6,054.44 | $6,054.44 | $6,054.44 | $6,054.44 | $49,445.85 | $93.65 | $49,000.00 | ||||||||||||||
21 | Snow Removal & Sand/Salt (Cameron) | $2,717.24 | $23,125.82 | $3,344.71 | $29,187.77 | $55.28 | $36,000.00 | |||||||||||||||||||
22 | Fertilization, Etc. (TruGreen) | $1,823.16 | $3,076.72 | $1,505.14 | $1,047.72 | $517.33 | $7,970.07 | $15.09 | $10,000.00 | |||||||||||||||||
23 | Irrigation System Maint(Anderson) | $2,242.01 | $201.16 | $157.54 | $2,100.41 | $4,701.12 | $8.90 | $5,400.00 | ||||||||||||||||||
24 | Tree Removal/Replacement | $212.70 | $3,296.85 | $3,077.80 | $6,587.35 | $12.48 | $7,500.00 | |||||||||||||||||||
25 | Trash Removal (Waste Material) | $3,142.54 | $2,970.93 | $3,354.00 | $500.00 | $3,432.00 | $13,399.47 | $25.38 | $13,500.00 | |||||||||||||||||
26 | Total Contract Services | $6,072.48 | $23,125.82 | $0.00 | $10,848.53 | $8,296.45 | $9,704.55 | $13,343.39 | $11,137.38 | $6,211.98 | $12,634.57 | $6,571.77 | $3,344.71 | $111,291.63 | $210.78 | $121,400.00 | ||||||||||
27 | % of Total Expenses | 66.27% | ||||||||||||||||||||||||
28 | ||||||||||||||||||||||||||
29 | Other Maintenance | $0.00 | $0.00 | |||||||||||||||||||||||
30 | Sidewalk/Asphalt/Lights, Etc. | $12,180.00 | $6,788.00 | $2,215.00 | $21,183.00 | $40.12 | $2,010.00 | |||||||||||||||||||
31 | Misc Grounds Maintneance | $50.00 | $211.10 | $179.86 | $623.53 | $193.16 | $1,490.29 | $2,747.94 | $5.20 | $2,200.00 | ||||||||||||||||
32 | Landscape Services | $525.00 | $366.53 | $1,000.00 | $425.00 | $2,316.53 | $4.39 | |||||||||||||||||||
33 | Seasonal Planting Projects | $323.01 | $585.91 | $42.54 | $244.00 | $139.14 | $1,334.60 | $2.53 | $2,000.00 | |||||||||||||||||
34 | Total Other Maintenance | $0.00 | $0.00 | $50.00 | $323.01 | $797.01 | $0.00 | $12,402.40 | $525.00 | $623.53 | $7,591.69 | $4,844.43 | $425.00 | $27,582.07 | $52.24 | $6,210.00 | ||||||||||
35 | % of Total Expenses | 16.42% | ||||||||||||||||||||||||
36 | ||||||||||||||||||||||||||
37 | Utilities | |||||||||||||||||||||||||
38 | Electricity (Eversource) | $400.88 | $353.08 | $361.56 | $333.79 | $291.55 | $366.79 | $325.84 | $295.86 | $351.00 | $349.87 | $99.03 | $111.19 | $3,640.44 | $6.89 | $5,000.00 | ||||||||||
39 | Water (Connecticut Water) | $322.14 | $2,443.92 | $63.81 | $5,066.01 | $2,115.67 | $10,011.55 | $18.96 | $11,500.00 | |||||||||||||||||
40 | Total Utilities | $400.88 | $353.08 | $683.70 | $333.79 | $291.55 | $2,810.71 | $389.65 | $295.86 | $5,417.01 | $349.87 | $99.03 | $2,226.86 | $13,651.99 | $25.86 | $16,500.00 | ||||||||||
41 | % of Total Expenses | 8.13% | ||||||||||||||||||||||||
42 | ||||||||||||||||||||||||||
43 | Insurance | |||||||||||||||||||||||||
44 | Liability/Property (Philadelphia Ins) | $4,547.00 | $25.00 | $4,572.00 | $8.66 | $4,400.00 | ||||||||||||||||||||
45 | D&O (Philadelphia Ins) | $803.00 | $803.00 | $1.52 | $840.00 | |||||||||||||||||||||
46 | Total Insurance | $0.00 | $0.00 | $803.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $4,547.00 | $25.00 | $5,375.00 | $10.18 | $5,240.00 | ||||||||||
47 | % of Total Expenses | 3.20% | ||||||||||||||||||||||||
48 | ||||||||||||||||||||||||||
49 | Administrative | |||||||||||||||||||||||||
50 | Audit /Tax return | $280.96 | $280.96 | $0.53 | $170.00 | |||||||||||||||||||||
51 | State Filing | $50.00 | $50.00 | $0.09 | $50.00 | |||||||||||||||||||||
52 | General Office, Meetings | $157.65 | $21.78 | $134.80 | $373.78 | $688.01 | $1.30 | $600.00 | ||||||||||||||||||
53 | Total Administrative | $280.96 | $0.00 | $0.00 | $0.00 | $157.65 | $21.78 | $0.00 | $0.00 | $50.00 | $0.00 | $134.80 | $373.78 | $1,018.97 | $1.93 | $820.00 | ||||||||||
54 | % of Total Expenses | 0.61% | ||||||||||||||||||||||||
55 | ||||||||||||||||||||||||||
56 | Reserves | |||||||||||||||||||||||||
57 | 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 | ||||||||||
58 | Cap Reserve Additional Contribution | $628.05 | $628.05 | $1.19 | ||||||||||||||||||||||
59 | Operating Reserve Contribution | $0.00 | $0.00 | |||||||||||||||||||||||
60 | 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 | $1,328.05 | $9,028.05 | $17.10 | $8,400.00 | ||||||||||
61 | % Of Total Expenses | 5.38% | ||||||||||||||||||||||||
62 | ||||||||||||||||||||||||||
63 | TOTAL EXPENSES | $7,454.32 | $24,178.90 | $2,236.70 | $12,205.33 | $10,242.66 | $13,237.04 | $26,835.44 | $12,658.24 | $13,002.52 | $21,276.13 | $16,897.03 | $7,723.40 | $167,947.71 | $318.08 | $158,570.00 | ||||||||||
64 | Total Inc Less Total Exp = | Less Capital Reserve Funding | $289.33 | |||||||||||||||||||||||
65 | Checking Account Balance | $52,228.35 | $41,249.45 | $51,912.75 | $53,282.42 | $56,314.76 | $56,277.72 | $51,897.28 | $52,439.04 | $52,636.52 | $50,560.39 | $46,926.10 | $52,402.70 | |||||||||||||
66 | ||||||||||||||||||||||||||
67 | IV. PRE-PAY ACCOUNT | |||||||||||||||||||||||||
68 | Start Of Month Balance | $5,218.61 | $23,818.75 | $19,318.92 | $14,819.08 | $12,719.20 | $11,519.30 | $11,819.43 | $15,719.57 | $12,119.70 | $9,119.80 | $6,719.87 | $5,819.93 | |||||||||||||
69 | From Checking Acct | $19,500.00 | $300.00 | $300.00 | $1,500.00 | $2,700.00 | $5,100.00 | $6,300.00 | $600.00 | $900.00 | $1,500.00 | $2,700.00 | $2,275.00 | |||||||||||||
70 | To Checking Acct | $900.00 | $4,800.00 | $4,800.00 | $3,600.00 | $3,900.00 | $4,800.00 | $2,400.00 | $4,200.00 | $3,900.00 | $3,900.00 | $3,600.00 | $3,900.00 | |||||||||||||
71 | Interest | $0.14 | $0.17 | $0.16 | $0.12 | $0.10 | $0.13 | $0.14 | $0.13 | $0.10 | $0.07 | $0.06 | $0.06 | |||||||||||||
72 | End Of Month Balance | $23,818.75 | $19,318.92 | $14,819.08 | $12,719.20 | $11,519.30 | $11,819.43 | $15,719.57 | $12,119.70 | $9,119.80 | $6,719.87 | $5,819.93 | $4,194.99 | |||||||||||||
73 | ||||||||||||||||||||||||||
74 | V. CAPITAL RESERVE ACCOUNT/CD | |||||||||||||||||||||||||
75 | Start Of Month Balance | $96,462.36 | $97,199.47 | $97,935.33 | $98,677.62 | $99,416.11 | $100,136.59 | $100,839.75 | $92,362.59 | $93,065.58 | $93,768.39 | $88,471.08 | $89,174.04 | |||||||||||||
76 | 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 | |||||||||||||
77 | Additional Contribution | $628.05 | ||||||||||||||||||||||||
78 | To Checking Acct | $9,180.00 | $6,000.00 | |||||||||||||||||||||||
79 | Interest | $37.11 | $35.86 | $42.29 | $38.49 | $20.48 | $3.16 | $2.84 | $2.99 | $2.81 | $2.69 | $2.96 | $2.87 | |||||||||||||
80 | End Of Month Balance | $97,199.47 | $97,935.33 | $98,677.62 | $99,416.11 | $100,136.59 | $100,839.75 | $92,362.59 | $93,065.58 | $93,768.39 | $88,471.08 | $89,174.04 | $90,504.96 | |||||||||||||
81 | ||||||||||||||||||||||||||
82 | VI. OPERATING RESERVE ACCT/CD | |||||||||||||||||||||||||
83 | Start Of Month Balance | $14,444.02 | $14,170.49 | $14,177.67 | $14,186.12 | $14,193.82 | $14,197.91 | $14,198.53 | $14,199.10 | $14,199.70 | $14,200.27 | $14,200.83 | $14,201.43 | |||||||||||||
84 | Contribution | |||||||||||||||||||||||||
85 | To Checking Acct | $280.96 | ||||||||||||||||||||||||
86 | Interest | $7.43 | $7.18 | $8.45 | $7.70 | $4.09 | $0.62 | $0.57 | $0.60 | $0.57 | $0.56 | $0.60 | $0.60 | |||||||||||||
87 | End Of Month Balance | $14,170.49 | $14,177.67 | $14,186.12 | $14,193.82 | $14,197.91 | $14,198.53 | $14,199.10 | $14,199.70 | $14,200.27 | $14,200.83 | $14,201.43 | $14,202.03 | |||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||