| Cash Forecast (2005) | Total | January | February | March | April | May | June | July | August | September | October | November | December |
| Funds: | |||||||||||||
| 2004 Cash Balance Forward | 11,572 | 15,584 | |||||||||||
| A/R Collections on Past due Balances | 1,246 | 298 | 464 | 252 | 232 | ||||||||
| Credit Balance/Not collected | (2,585) | (1,825) | (760) | ||||||||||
| Association Fees Received/Mailbox Repairs | 31,096 | 6,571 | $ 1,348 | 651 | 729 | 8,000 | 7,696 | 6,100 | |||||
| Total 2004 Funds | $ 41,328 | $ 22,453 | $ 1,348 | $ 651 | $ 1,193 | $ 252 | $ 6,407 | $ 7,696 | $ - | $ - | $ - | $ - | $ 5,340 |
| 2005 Total Received Cash Forecast | $ 29,757 | ||||||||||||
| Expenses | |||||||||||||
| Administration | |||||||||||||
| Uncollected 2004 Assoc. Fees (Write Offs) | - | ||||||||||||
| Legal Fees | 400 | 200 | 200 | ||||||||||
| Accountant Fees | - | ||||||||||||
| Property Management Fee | - | ||||||||||||
| Checking Fee | 105 | 10 | 14 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
| Homeowners NSF Charges | - | ||||||||||||
| Checks & Banking Supplies | 96 | 46.22 | 50 | ||||||||||
| Postage | 292 | 56.88 | 13 | 20 | 5 | 54 | 38 | 20 | 5 | 5 | 5 | 70 | |
| Post Office Box 6043 Fee | 50 | 50 | |||||||||||
| Board Newsletter | 212 | 12.11 | 50 | 50 | 50 | 50 | |||||||
| Internet Website | 322 | 100 | 50 | 172 | |||||||||
| Office Supplies/Services | 411 | 38.10 | 212 | 1 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | |
| Advertising and Signs | 60 | 30 | 30 | ||||||||||
| Miscellaneous Administration | 100 | 100 | |||||||||||
| Community Events Commity | |||||||||||||
| Christmas Party | 309 | 59 | 250 | ||||||||||
| Christmas Lighting | 214 | 39 | 175 | ||||||||||
| Community Block Party | - | ||||||||||||
| Cleanup Day (Food) | 50 | 50 | |||||||||||
| Total Administration | $ 2,621 | $ 252 | $ 110 | $ 239 | $ 79 | $ 336 | $ 83 | $ 317 | $ 99 | $ 164 | $ 234 | $ 84 | $ 624 |
| Long-term Programs | |||||||||||||
| Maintenance Fund (in separate account) | 1,200 | 200 | 400 | 400 | (1,000) | 200 | 200 | 200 | 200 | 200 | 200 | ||
| Total Long-Term Programs | $ 1,200 | $ 200 | $ - | $ 400 | $ - | $ 400 | $ (1,000) | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 |
| Short-term Projects | |||||||||||||
| Enhanced entrance lighting | 4,684 | 2,227 | 2,457 | ||||||||||
| Total Long-Term Programs | $ 4,684 | $ - | $ - | $ - | $ 2,227 | $ - | $ 2,457 | $ - | $ - | $ - | $ - | $ - | $ - |
| Utilities | |||||||||||||
| Fountain 130-057-0007-18 | 905 | 12.45 | 10 | 20 | 120 | 123 | 121 | 129 | 130 | 130 | 101 | 9 | |
| Street Lights 6890-3049-01-8 | 949 | 84 | 84 | 84 | 87 | 87 | 87 | 87 | 87 | 87 | 87 | 87 | |
| Common 130-057-9600-10 | 570 | 135.64 | 60 | 41 | 40 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 50 |
| South Entrance Electrical | 185 | - | - | 25 | 25 | 25 | 25 | 25 | 30 | 30 | |||
| South Entrance Water | 125 | - | - | 25 | 25 | 25 | 25 | 25 | |||||
| Water 353832 | 527 | 17.05 | 30 | 30 | - | 25 | 25 | 15 | 37 | 103 | 80 | 140 | 25 |
| Water 353982 | 568 | 21.18 | 31 | 31 | - | 25 | 25 | 12 | 40 | 114 | 90 | 153 | 25 |
| Total Utilities | $ 3,829 | $ 186 | $ 215 | $ 207 | $ 124 | $ 292 | $ 345 | $ 320 | $ 377 | $ 519 | $ 472 | $ 546 | $ 226 |
| Taxes & Insurance | |||||||||||||
| Real Estate Taxes | 454 | 294 | 160 | ||||||||||
| Insurance Premiums | 1,059 | 1,059 | |||||||||||
| Total Taxes & Insurance | $ 1,513 | $ - | $ - | $ - | $ 1,059 | $ 294 | $ - | $ - | $ - | $ - | $ - | $ 160 | $ - |
| Maintenance & Common Grounds | |||||||||||||
| Irrigation Maintenance | 393 | 293 | 100 | ||||||||||
| Pond Maintenance (ASAP) | 1,915 | 665 | 600 | 650 | |||||||||
| Fountain removal/clean/store | 275 | 275 | |||||||||||
| Mowing, Lawn, Trees, Spraying, Mulch | 9,676 | 350 | 1,627 | 1,545 | 1,298 | 1,048 | 1,048 | 1,448 | 1,312 | ||||
| Weeding Entrances | 120 | 40 | 40 | 40 | |||||||||
| Flowers | 2,699 | 337 | 337 | 337 | 337 | 337 | 337 | 337 | 337 | ||||
| Snow Removal | 1,900 | 400 | 500 | 1,000 | |||||||||
| Violation Mowing/Maint. | 100 | 40 | 20 | 20 | 20 | ||||||||
| Misc. Common Area/Mailbox Repair Cost | 814 | 314 | 500 | ||||||||||
| Total Maintenance & Common Grounds | $ 17,892 | $ 400 | $ - | $ 1,352 | $ 2,571 | $ 2,983 | $ 1,715 | $ 2,095 | $ 1,445 | $ 1,805 | $ 1,649 | $ 875 | $ 1,000 |
| Total 2004 Cash Out | $ 31,739 | $ 1,038 | $ 325 | $ 2,199 | $ 6,060 | $ 4,305 | $ 3,600 | $ 2,933 | $ 2,122 | $ 2,688 | $ 2,555 | $ 1,865 | $ 2,050 |
| Aggregate Expenses | $ 1,038 | $ 1,363 | $ 3,562 | $ 9,622 | $ 13,926 | $ 17,526 | $ 20,459 | $ 22,581 | $ 25,269 | $ 27,825 | $ 29,690 | $ 31,739 | |
| 2004 Aggregate Forecasted Cash Balance | $ 9,589 | 21415.20 | 22,438.25 | 20,890.43 | 16,024.03 | 11,971.22 | 14,778.36 | 19,541.38 | 17,419.55 | 14,731.37 | 12,175.98 | 10,310.98 | 13,601.30 |
| 2,029.57 |