| Cash Forecast (2007) | Total | January | February | March | April | May | June | July | August | September | October | November | December |
| Funds: | |||||||||||||
| A/R Collections on Past due Balances | 1,620 | 556 | 304 | 456 | 304 | ||||||||
| Transfer from Long-Term | 4,794 | 2,000 | 2,794 | ||||||||||
| Association Fees Received/Mailbox Repairs | 28,120 | 6,440 | $ 2,217 | - | 3,133 | 8,363 | 1,618 | 718 | 152 | 5,479 | |||
| Total 2004 Funds | $ 34,534 | $ 6,996 | $ 4,217 | $ 304 | $ - | $ - | $ 5,927 | $ 8,819 | $ 1,618 | $ 718 | $ 456 | $ - | $ 5,479 |
| 2005 Total Received Cash Forecast | $ 34,534 | ||||||||||||
| Expenses | |||||||||||||
| Administration | |||||||||||||
| Uncollected 2004 Assoc. Fees (Write Offs) | - | ||||||||||||
| Transfer to Long-Term Account | 11,907 | 11,907 | |||||||||||
| Legal Fees | 300 | 100 | 100 | 100 | |||||||||
| Accountant Fees | 220 | 220 | |||||||||||
| Property Management Fee | - | ||||||||||||
| Checking Fee | 119 | 9 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
| Homeowners NSF Charges | - | ||||||||||||
| Checks & Banking Supplies | 110 | 55 | 55 | ||||||||||
| Postage | 260 | 48 | 5 | 5 | 5 | 54 | 38 | 20 | 5 | 5 | 5 | 70 | |
| Post Office Box 6043 Fee | 60 | 60 | |||||||||||
| Board Newsletter | 300 | 50 | 50 | 50 | 50 | 50 | 50 | ||||||
| Internet Website | 172 | 172 | |||||||||||
| Office Supplies/Services | 340 | 60 | 40 | 40 | 40 | 40 | 20 | 20 | 20 | 20 | 20 | 20 | |
| Advertising and Signs | 60 | 60 | |||||||||||
| Miscellaneous Administration | 100 | 100 | |||||||||||
| Community Events Commity | |||||||||||||
| Christmas Party | 50 | 50 | |||||||||||
| Christmas Lighting | 150 | 150 | |||||||||||
| Community Block Party | 700 | 700 | |||||||||||
| Cleanup Day (Food) | 100 | 100 | |||||||||||
| Total Administration | $ 14,948 | $ 9 | $ 12,180 | $ 325 | $ 155 | $ 377 | $ 104 | $ 278 | $ 105 | $ 845 | $ 135 | $ 85 | $ 350 |
| Long-term Programs | |||||||||||||
| Maintenance Fund (in separate account) | 2,400 | 400 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | |
| Total Long-Term Programs | $ 2,400 | $ - | $ 400 | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 |
| Short-term Projects | |||||||||||||
| Sprinkler - South Entrance & North End of Pond | 7,000 | 2,000 | 5,000 | ||||||||||
| Total Long-Term Programs | $ 7,000 | $ - | $ 2,000 | $ - | $ - | $ - | $ 5,000 | $ - | $ - | $ - | $ - | $ - | $ - |
| Utilities | |||||||||||||
| Fountain 130-057-0007-18 | 1,180 | 14 | 15 | 15 | 41 | 150 | 140 | 160 | 160 | 160 | 160 | 150 | 15 |
| Street Lights 6890-3049-01-8 | 1,113 | 88 | 95 | 95 | 95 | 95 | 90 | 90 | 90 | 90 | 95 | 95 | 95 |
| Common 130-057-9600-10 | 541 | 51 | 60 | 45 | 45 | 45 | 45 | 40 | 40 | 40 | 40 | 40 | 50 |
| South Entrance Electrical | 361 | 31 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 |
| South Entrance Water | 305 | 30 | 35 | 50 | 50 | 50 | 45 | 30 | 15 | ||||
| Water 353832 | 501 | 26 | 35 | 45 | 50 | 70 | 70 | 70 | 55 | 55 | 25 | ||
| Water 353982 | 501 | 26 | 35 | 45 | 50 | 70 | 70 | 70 | 55 | 55 | 25 | ||
| Total Utilities | $ 4,503 | $ 237 | $ 200 | $ 185 | $ 281 | $ 440 | $ 440 | $ 510 | $ 510 | $ 510 | $ 480 | $ 455 | $ 255 |
| Taxes & Insurance | |||||||||||||
| Real Estate Taxes | 370 | 210 | 160 | ||||||||||
| Insurance Premiums | 1,200 | 1,200 | |||||||||||
| Total Taxes & Insurance | $ 1,570 | $ - | $ - | $ 1,200 | $ - | $ 210 | $ - | $ - | $ - | $ - | $ - | $ 160 | $ - |
| Maintenance & Common Grounds | |||||||||||||
| Irrigation Maintenance | 295 | 165 | 130 | ||||||||||
| Pond Maintenance (ASAP) | 2,330 | 740 | 600 | 250 | 740 | ||||||||
| Fountain removal/clean/store | 504 | 504 | |||||||||||
| Mowing, Lawn, Trees, Spraying, Mulch | 7,990 | 300 | 1,070 | 1770 | 1,070 | 820 | 1,070 | 820 | 1,070 | ||||
| Weeding Entrances | 120 | 40 | 40 | 40 | |||||||||
| Flowers | 1,300 | 400 | 400 | 300 | 200 | ||||||||
| Snow Removal | 2,556 | 1,056 | 500 | 1,000 | |||||||||
| Violation Mowing/Maint. | 100 | 40 | 20 | 20 | 20 | ||||||||
| Misc. Common Area/Mailbox Repair Cost | 137 | 137 | |||||||||||
| Total Maintenance & Common Grounds | $ 15,332 | $ 137 | $ 1,056 | $ 1,040 | $ 1,670 | $ 2,585 | $ 1,550 | $ 1,920 | $ 1,130 | $ 840 | $ 1,270 | $ 1,134 | $ 1,000 |
| Total 2006 Cash Out | $ 45,753 | $ 383 | $ 15,836 | $ 2,950 | $ 2,306 | $ 3,812 | $ 7,294 | $ 2,908 | $ 1,945 | $ 2,395 | $ 2,085 | $ 2,034 | $ 1,805 |
| Aggregate Expenses | $ 383 | $ 16,219 | $ 19,169 | $ 21,475 | $ 25,287 | $ 32,581 | $ 35,489 | $ 37,434 | $ 39,829 | $ 41,914 | $ 43,948 | $ 45,753 | |
| 2006 Aggregate Forecasted Cash Balance | 29520.17 | 17,901.28 | 15,255.28 | 12,948.97 | 9,136.97 | 7,769.54 | 13,680.43 | 13,353.43 | 11,676.43 | 10,047.43 | 8,013.43 | 11,687.39 | |
| 2006 Est Surplus/(Deficit) | $ 687 | 11,687.39 |