| 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 | 2023 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 | $4,225.00 | $4,225.00 | $3,575.00 | $4,225.00 | $4,225.00 | $2,600.00 | $4,875.00 | $4,225.00 | $3,900.00 | $4,225.00 | $4,225.00 | |||||||||||||
6 | Condo Fees Due | $13,000.00 | $10,075.00 | $10,075.00 | $10,725.00 | $10,075.00 | $10,075.00 | $11,700.00 | $9,425.00 | $10,075.00 | $10,400.00 | $10,075.00 | $10,075.00 | |||||||||||||
7 | ||||||||||||||||||||||||||
8 | II. INCOME | |||||||||||||||||||||||||
9 | Monthly Condo Fees Due & Paid + | $13,000.00 | $10,075.00 | $10,075.00 | $10,725.00 | $10,400.00 | $10,075.00 | $11,700.00 | $9,425.00 | $10,075.00 | $10,400.00 | $10,075.00 | $10,075.00 | |||||||||||||
10 | Monthly Fees Paid In Adv This Month + | $19,175.00 | $650.00 | $325.00 | $2,275.00 | $1,625.00 | $5,200.00 | $8,125.00 | $1,300.00 | $1,950.00 | $975.00 | $4,225.00 | ||||||||||||||
11 | Other Income + | $197.26 | $448.77 | $2,500.00 | $774.77 | $1,221.00 | ||||||||||||||||||||
12 | Transfers Fr Pre-Pay Or Other Accts = | $1,300.00 | $4,225.00 | $4,225.00 | $3,575.00 | $4,225.00 | $4,225.00 | $2,600.00 | $4,875.00 | $9,225.00 | $8,900.00 | $4,225.00 | $4,225.00 | |||||||||||||
13 | Monthly Deposits (Per Bank Stmt) + | $33,475.00 | $14,950.00 | $14,822.26 | $16,575.00 | $16,250.00 | $19,948.77 | $24,925.00 | $14,300.00 | $21,374.77 | $21,250.00 | $15,275.00 | $19,746.00 | |||||||||||||
14 | C/O From Previous Month Checking - | $45,804.93 | $52,603.66 | $64,685.12 | $62,595.63 | $64,278.53 | $64,890.17 | $66,037.08 | $10,785.27 | $13,711.43 | $8,483.01 | $11,053.58 | $12,492.42 | |||||||||||||
15 | Transfer To Pre-Pay Or Other Accts = | $19,175.00 | $650.00 | $325.00 | $2,275.00 | $1,625.00 | $5,200.00 | $8,125.00 | $6,300.00 | $1,950.00 | $975.00 | $4,225.00 | ||||||||||||||
16 | Transfer To High Int Savings Acct | $52,500.00 | $8,000.00 | |||||||||||||||||||||||
17 | Total Income | $60,104.93 | $66,903.66 | $79,182.38 | $76,895.63 | $78,903.53 | $79,638.94 | $30,337.08 | $25,085.27 | $28,786.20 | $27,783.01 | $25,353.58 | $20,013.42 | |||||||||||||
18 | ||||||||||||||||||||||||||
19 | III. PAID EXPENSES | |||||||||||||||||||||||||
20 | Contract Services | |||||||||||||||||||||||||
21 | Lawncare Maintenance (Cameron) | $6,281.30 | $6,281.30 | $6,281.30 | $6,945.98 | $6,573.76 | $7,557.50 | $6,281.30 | $6,281.30 | $52,483.74 | $99.40 | $52,000.00 | ||||||||||||||
22 | Snow Removal & Sand/Salt (Cameron) | $3,833.92 | $1,223.03 | $13,394.79 | $18,451.74 | $34.95 | $37,000.00 | |||||||||||||||||||
23 | Fertilization, Etc. (TruGreen) | $2,100.04 | $1,687.40 | $3,444.80 | $69.13 | $2,343.22 | $577.69 | $10,222.28 | $19.36 | $11,000.00 | ||||||||||||||||
24 | Irrigation System Maint(Anderson) | $2,296.53 | $2,220.06 | $4,516.59 | $8.55 | $5,000.00 | ||||||||||||||||||||
25 | Tree Removal/Replacement | $1,010.00 | $1,847.95 | $3,084.15 | $1,276.20 | $7,218.30 | $13.67 | $8,000.00 | ||||||||||||||||||
26 | Trash Removal (Waste Material) | $2,660.00 | $2,904.00 | $3,432.00 | $3,932.00 | $12,928.00 | $24.48 | $13,500.00 | ||||||||||||||||||
27 | Total Contract Services | $6,493.92 | $1,223.03 | $13,394.79 | $11,285.34 | $11,275.23 | $6,281.30 | $15,670.73 | $9,657.91 | $7,626.63 | $14,776.58 | $6,858.99 | $1,276.20 | $105,820.65 | $200.42 | $126,500.00 | ||||||||||
28 | % of Total Expenses | 69.26% | 73.72% | |||||||||||||||||||||||
29 | ||||||||||||||||||||||||||
30 | Other Maintenance | |||||||||||||||||||||||||
31 | Sidewalk/Asphalt/Lights, Etc. | $0.00 | $0.00 | $2,010.00 | ||||||||||||||||||||||
32 | Misc Grounds Maintneance | $52.12 | $670.23 | $383.87 | $30.61 | $135.54 | $26.06 | $1,298.43 | $2.46 | $3,850.00 | ||||||||||||||||
33 | Landscape Services | $260.00 | $203.02 | $300.00 | $540.00 | $180.00 | $155.00 | $360.00 | $1,998.02 | $3.78 | $3,000.00 | |||||||||||||||
34 | Seasonal Planting Projects | $297.99 | $140.00 | $849.37 | $787.43 | $312.85 | $25.52 | $2,413.16 | $4.57 | $3,000.00 | ||||||||||||||||
35 | Total Other Maintenance | $0.00 | $0.00 | $0.00 | $350.11 | $1,070.23 | $1,436.26 | $330.61 | $675.54 | $26.06 | $967.43 | $467.85 | $385.52 | $5,709.61 | $10.81 | $11,860.00 | ||||||||||
36 | % of Total Expenses | 3.74% | 6.91% | |||||||||||||||||||||||
37 | ||||||||||||||||||||||||||
38 | Utilities | |||||||||||||||||||||||||
39 | Electricity (Eversource) | $107.35 | $95.51 | $94.02 | $81.65 | $77.59 | $143.65 | $150.47 | $140.39 | $171.17 | $85.42 | $108.28 | $128.32 | $1,383.82 | $2.62 | $3,000.00 | ||||||||||
40 | Water (Connecticut Water) | $339.03 | $3,693.08 | $10,313.02 | $554.89 | $14,900.02 | $28.22 | $13,000.00 | ||||||||||||||||||
41 | Total Utilities | $107.35 | $95.51 | $433.05 | $81.65 | $77.59 | $3,836.73 | $150.47 | $140.39 | $10,484.19 | $85.42 | $108.28 | $683.21 | $16,283.84 | $30.84 | $16,000.00 | ||||||||||
42 | % of Total Expenses | 10.66% | 9.32% | |||||||||||||||||||||||
43 | ||||||||||||||||||||||||||
44 | Insurance | |||||||||||||||||||||||||
45 | Liability/Property (Philadelphia Ins) | $4,383.00 | $4,383.00 | $8.30 | $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,383.00 | $0.00 | $5,226.00 | $9.90 | $5,440.00 | ||||||||||
48 | % of Total Expenses | 3.42% | 3.17% | |||||||||||||||||||||||
49 | ||||||||||||||||||||||||||
50 | Administrative | |||||||||||||||||||||||||
51 | Audit /Tax return | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||
52 | State Filing | $50.00 | $50.00 | $0.09 | $50.00 | |||||||||||||||||||||
53 | General Office, Meetings | $690.31 | $9.56 | $2,500.00 | $143.04 | $274.55 | $3,617.46 | $6.85 | $950.00 | |||||||||||||||||
54 | Total Administrative | $0.00 | $0.00 | $0.00 | $0.00 | $690.31 | $9.56 | $2,500.00 | $0.00 | $50.00 | $0.00 | $143.04 | $274.55 | $3,667.46 | $6.95 | $1,000.00 | ||||||||||
55 | % of Total Expenses | 2.40% | 0.58% | |||||||||||||||||||||||
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 | $1,015.91 | $1,138.01 | $1,216.31 | $1,915.39 | $5,285.62 | $10.01 | |||||||||||||||||||
60 | Operating Reserve Contribution | $0.00 | $0.00 | |||||||||||||||||||||||
61 | Total Cap Reserve | $900.00 | $900.00 | $1,915.91 | $900.00 | $900.00 | $2,038.01 | $900.00 | $900.00 | $2,116.31 | $900.00 | $900.00 | $2,815.39 | $16,085.62 | $30.47 | $10,800.00 | ||||||||||
62 | % Of Total Expenses | 10.53% | 6.29% | |||||||||||||||||||||||
63 | ||||||||||||||||||||||||||
64 | TOTAL EXPENSES | $7,501.27 | $2,218.54 | $16,586.75 | $12,617.10 | $14,013.36 | $13,601.86 | $19,551.81 | $11,373.84 | $20,303.19 | $16,729.43 | $12,861.16 | $5,434.87 | $152,793.18 | $289.38 | $171,600.00 | ||||||||||
65 | Total Inc Less Total Exp = | |||||||||||||||||||||||||
66 | Checking Account Balance | $52,603.66 | $64,685.12 | $62,595.63 | $64,278.53 | $64,890.17 | $66,037.08 | $10,785.27 | $13,711.43 | $8,483.01 | $11,053.58 | $12,492.42 | $14,578.55 | |||||||||||||
67 | ||||||||||||||||||||||||||
68 | IV. PRE-PAY ACCOUNT | |||||||||||||||||||||||||
69 | Start Of Month Balance | $4,646.67 | $22,521.95 | $18,947.26 | $15,047.55 | $13,747.79 | $11,148.02 | $12,123.24 | $17,648.53 | $12,773.79 | $9,849.00 | $7,899.17 | $4,649.28 | |||||||||||||
70 | From Checking Acct | $19,175.00 | $650.00 | $325.00 | $2,275.00 | $1,625.00 | $5,200.00 | $8,125.00 | $1,300.00 | $1,950.00 | $975.00 | $4,225.00 | ||||||||||||||
71 | To Checking Acct | $1,300.00 | $4,225.00 | $4,225.00 | $3,575.00 | $4,225.00 | $4,225.00 | $2,600.00 | $4,875.00 | $4,225.00 | $3,900.00 | $4,225.00 | $4,225.00 | |||||||||||||
72 | Interest | $0.28 | $0.31 | $0.29 | $0.24 | $0.23 | $0.22 | $0.29 | $0.3 | $0.21 | $0.17 | $0.11 | $0.10 | |||||||||||||
73 | End Of Month Balance | $22,521.95 | $18,947.26 | $15,047.55 | $13,747.79 | $11,148.02 | $12,123.24 | $17,648.53 | $12,773.79 | $9,849.00 | $7,899.17 | $4,649.28 | $4,649.38 | |||||||||||||
74 | ||||||||||||||||||||||||||
75 | V. CAPITAL RESERVE ACCOUNT/CD | |||||||||||||||||||||||||
76 | Start Of Month Balance | $104,067.95 | $104,968.38 | $105,868.78 | $107,785.16 | $108,685.60 | $109,586.13 | $111,624.65 | $112,525.20 | $83,425.38 | $90,541.76 | $91,441.87 | $92,341.99 | |||||||||||||
77 | 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 | |||||||||||||
78 | Additional Contribution | $818.65 | $689.24 | $5,510.67 | $965.39 | |||||||||||||||||||||
79 | To Other Accts | $30,000.00 | $2,000.29 | |||||||||||||||||||||||
80 | Interest | $0.43 | $0.40 | $197.73 | $0.44 | $0.53 | $449.28 | $0.55 | $0.18 | $705.71 | $0.11 | $0.12 | $950.08 | |||||||||||||
81 | End Of Month Balance | $104,968.38 | $105,868.78 | $107,785.16 | $108,685.60 | $109,586.13 | $111,624.65 | $112,525.20 | $83,425.38 | $90,541.76 | $91,441.87 | $92,341.99 | $93,157.17 | |||||||||||||
82 | ||||||||||||||||||||||||||
83 | VI. OPERATING RESERVE ACCT/CD | |||||||||||||||||||||||||
84 | Start Of Month Balance | $14,208.17 | $14,208.67 | $14,209.10 | $14,209.58 | $14,210.02 | $14,210.53 | $14,211.00 | $14,211.31 | $14,211.39 | $14,211.43 | $14,211.46 | $14,211.50 | |||||||||||||
85 | Contribution | |||||||||||||||||||||||||
86 | To Checking Acct | |||||||||||||||||||||||||
87 | Interest | $0.50 | $0.43 | $0.48 | $0.44 | $0.51 | $0.47 | $0.31 | $0.08 | $0.04 | $0.03 | $0.04 | $0.04 | |||||||||||||
88 | End Of Month Balance | $14,208.67 | $14,209.10 | $14,209.58 | $14,210.02 | $14,210.53 | $14,211.00 | $14,211.31 | $14,211.39 | $14,211.43 | $14,211.46 | $14,211.50 | $14,211.54 | |||||||||||||
89 | ||||||||||||||||||||||||||
90 | VII. High Int. Savingx Account | |||||||||||||||||||||||||
91 | Start Of Month Balance | $0.00 | $52,547.00 | $82,799.65 | $78,053.40 | $73,306.16 | $73,542.71 | |||||||||||||||||||
92 | From Other Accts | $52,500.00 | $30,000.00 | $10,000.29 | ||||||||||||||||||||||
93 | To Checking Acct Or Cap Reserve | $5,000.00 | $5,000.00 | |||||||||||||||||||||||
94 | Interest | $47.00 | $252.65 | $253.75 | $252.76 | $236.55 | $256.85 | |||||||||||||||||||
95 | End Of Month Balance | $52,547.00 | $82,799.65 | $78,053.40 | $73,306.16 | $73,542.71 | $83,799.85 | |||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||