| OAK | Creek | 2008 | ||||||||||||
| Revenue Budget | ||||||||||||||
| 2008 | ||||||||||||||
| Budget | YTD | Jan. | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Income | ||||||||||||||
| Assessments | $ 64,800.00 | $ 64,800.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $5,400.00 | $5,400.00 | $5,400.00 | $5,400.00 | $5,400.00 | $5,400.00 |
| Club House Rental | $ 600.00 | $ 855.00 | $ 100.00 | $ 190.00 | $ 85.00 | $ 100.00 | $100.00 | $50.00 | $130.00 | $100.00 | ||||
| Interest | $ 1,500.00 | $ 1,685.95 | $ 70.18 | $ 5.64 | $ 21.52 | $ 23.63 | $ 24.53 | $17.39 | $1,116.17 | $20.54 | $386.35 | |||
| Other | $ 500.00 | $ 95.00 | $ 75.00 | $ (50.00) | $ 25.00 | $45.00 | ||||||||
| YTD | $ 67,435.95 | |||||||||||||
| Total Income | $ 67,400.00 | $ 67,435.95 | $ 5,475.00 | $ 5,520.18 | $ 5,595.64 | $ 5,421.52 | $ 5,533.63 | $ 5,524.53 | $5,517.39 | $6,566.17 | $5,400.00 | $5,465.54 | $5,530.00 | $5,886.35 |
| Accts Receivable | ||||||||||||||
| Expense | ||||||||||||||
| Admininstration | $ 13,710.00 | $ 13,625.88 | $ 972.52 | $ 671.85 | $ 1,044.06 | $ 1,011.92 | $ 745.89 | $ 810.69 | $ 3,963.95 | $ 729.65 | $ 1,028.76 | $ 1,116.61 | $ 782.23 | $ 747.75 |
| Pool | $ 18,745.00 | $ 17,548.01 | $ 2,295.49 | $ 4,232.26 | $ 5,360.80 | $ 2,475.84 | $ 2,234.34 | $ 949.28 | $ - | |||||
| Grounds | $ 17,860.00 | $ 19,024.46 | $ 647.44 | $ 1,462.50 | $ 1,357.50 | $ 1,357.50 | $ 3,085.50 | $ 1,726.50 | $ 5,021.00 | $ 1,497.11 | $ 1,511.91 | $ 1,357.50 | ||
| Clubhouse | $ 13,400.00 | $ 11,485.18 | $ 826.01 | $ 1,663.38 | $ 1,505.78 | $ 618.28 | $ 809.85 | $ 1,048.83 | $ (952.81) | $ 1,503.20 | $ 1,612.28 | $ 885.56 | $ 629.31 | $ 1,335.51 |
| Other | ||||||||||||||
| YTD | $ 61,683.53 | |||||||||||||
| Total Expense | $ 63,715.00 | $ 61,683.53 | $ 2,445.97 | $ 2,335.23 | $ 4,012.34 | $ 1,630.20 | $ 5,208.73 | $ 7,449.28 | $ 11,457.44 | $ 6,435.19 | $ 9,896.38 | $ 4,448.56 | $ 2,923.45 | $ 3,440.76 |
| Net Income | $ 3,685.00 | $ 5,752.42 | $ 3,029.03 | $ 3,184.95 | $ 1,583.30 | $ 3,791.32 | $ 324.90 | $ (1,924.75) | $ (5,940.05) | $ 130.98 | $ (4,496.38) | $ 1,016.98 | $ 2,606.55 | $ 2,445.59 |
| 2007 | ||||||||||||||
| CURRENT ASSETS | year end | |||||||||||||
| Checking | $ 5,724.74 | $ 9,253.77 | $ 15,327.07 | $ 23,945.87 | $ 28,744.17 | $ 5,004.10 | $ 5,112.90 | $ 1,597.80 | $ (60.29) | $ 187.42 | $ 1,464.92 | $ 3,696.47 | $ 5,988.38 | |
| Money Market | $ 18,300.19 | $ 18,300.19 | $ 18,364.34 | $ 18,364.34 | $ 18,385.86 | $ 18,402.33 | $ 18,418.78 | $ 18,433.83 | $ 18,461.85 | $ 5,861.85 | $ 5,881.33 | $ 5,881.33 | $ 5,890.75 | |
| CD | $ 27,250.84 | $ 27,250.84 | $ 27,250.84 | $ 27,250.84 | $ 27,250.84 | $ 27,250.84 | $ 27,250.84 | $ 27,250.84 | $ 28,336.89 | $ 28,336.89 | $ 28,336.89 | $ 28,336.89 | $ 28,711.15 | |
| A/R Assessments | $ 3,175.00 | $ 1,850.00 | $ 135.00 | $ 660.00 | $ 525.00 | $ 100.00 | $ 125.00 | $ (100.00) | $ 850.00 | $ 550.00 | $ 450.00 | $ 825.00 | $ 595.00 | |
| a/r non current | ||||||||||||||
| Special Assess. | $ 825.00 | $ 75.00 | $ 16,660.00 | $ 9,617.50 | $ 5,315.00 | $ 3,240.00 | $ 1,000.00 | $ 750.00 | $ 700.00 | $ 475.00 | $ 475.00 | $ 475.00 | ||
| Late Fee/ NSF | $ 25.00 | $ 45.00 | $ 45.00 | $ 45.00 | ||||||||||
| Total Assets | $ 58,135.77 | $ 54,450.77 | $ 57,479.80 | $61,152.25 | $ 86,881.05 | $84,523.37 | $ 56,072.27 | $ 54,147.52 | $ 48,207.47 | $ 48,338.45 | $ 35,636.16 | $ 36,653.14 | $ 39,259.69 | $ 41,705.28 |
| Admin. Budget | ||||||||||||||
| 2008 | ||||||||||||||
| Budget | YTD | Jan. | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Mgt. Fee | $7,560.00 | $7,560.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 | $630.00 |
| Off. Expense | $1,100.00 | $964.04 | $150.00 | $40.00 | $324.58 | $39.94 | $30.00 | $5.00 | $294.58 | $54.94 | $25.00 | |||
| Copies | $300.00 | $224.55 | $66.30 | $30.75 | $15.30 | $10.20 | $20.40 | $10.20 | $10.20 | $10.20 | $10.20 | $20.40 | $20.40 | |
| Legal | $400.00 | $575.00 | -$75.00 | $300.00 | $350.00 | |||||||||
| Phone | $350.00 | $421.89 | $67.75 | $2.04 | $28.86 | $28.86 | $29.06 | $29.40 | $42.65 | $40.86 | $47.32 | $47.15 | $28.97 | $28.97 |
| Bank Chrge | $0.00 | $9.00 | $4.50 | $9.00 | -$4.50 | |||||||||
| Postage | $650.00 | $589.53 | $58.47 | $39.56 | $45.32 | $42.86 | $46.89 | $39.53 | $59.59 | $53.09 | $46.66 | $66.26 | $47.92 | $43.38 |
| Insurance | $3,300.00 | $3,216.51 | $3,216.51 | |||||||||||
| RE Taxes | $50.00 | $52.36 | $52.36 | |||||||||||
| Capital | $0.00 | $0.00 | ||||||||||||
| Other | $0.00 | $13.00 | $13.00 | |||||||||||
| Total YTD | $13,625.88 | |||||||||||||
| Total | $13,710.00 | $13,625.88 | $972.52 | $671.85 | $1,044.06 | $1,011.92 | $745.89 | $810.69 | $3,963.95 | $729.65 | $1,028.76 | $1,116.61 | $782.23 | $747.75 |
| Club House Budget | ||||||||||||||
| 2008 | ||||||||||||||
| Budget | YTD | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Exterminator | $ 500.00 | $ 375.44 | $ 375.44 | |||||||||||
| Gas | $ 7,500.00 | $ 5,047.71 | $ 497.95 | $ 665.34 | $ 695.11 | $ 343.70 | $ 379.92 | $ 541.24 | $ 472.95 | $ 443.25 | $ 398.68 | $ 78.90 | $ 345.68 | $ 184.99 |
| Electric | $ 4,562.98 | $ 193.06 | $ 165.34 | $ 177.20 | $ 139.58 | $ 164.55 | $ 283.74 | $ 673.89 | $ 890.71 | $ 711.65 | $ 671.66 | $ 58.60 | $ 433.00 | |
| Janitorial | $ 1,400.00 | $ 1,170.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 180.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 |
| Maintenance | $ 3,000.00 | $ (437.73) | $ 45.00 | $ 105.00 | $ 68.47 | $ 45.00 | $ 85.38 | $ 133.85 | $ (2,189.65) | $ 79.24 | $ 411.95 | $ 45.00 | $ 135.03 | $ 598.00 |
| Painting | $ - | |||||||||||||
| Improvmnts | $ 1,000.00 | $ 591.18 | $ 116.18 | $ 475.00 | ||||||||||
| Capital | $ - | |||||||||||||
| Other | $ - | $ 175.60 | $ 146.08 | $ 29.52 | ||||||||||
| YTD Total | $ 11,485.18 | |||||||||||||
| Total | $ 13,400.00 | $ 11,485.18 | $ 826.01 | $ 1,663.38 | $ 1,505.78 | $ 618.28 | $ 809.85 | $ 1,048.83 | $ (952.81) | $ 1,503.20 | $ 1,612.28 | $ 885.56 | $ 629.31 | $ 1,335.51 |
| Grounds Budget | ||||||||||||||
| 2008 | ||||||||||||||
| Budget | YTD | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Landscape | $ 10,860.00 | $ 10,860.00 | $ - | $ 1,357.50 | $ 1,357.50 | $ 1,357.50 | $ 1,357.50 | $ 1,357.50 | $ 1,357.50 | $ 1,357.50 | $ 1,357.50 | |||
| Improvemnts | $ 5,500.00 | $ 3,405.50 | $ - | $ 3,405.50 | ||||||||||
| playground. | $ - | $ - | $ - | |||||||||||
| Snow | $ 1,500.00 | $ 2,080.00 | $ 617.50 | $ - | $ 1,462.50 | |||||||||
| Tennis Court | $ - | $ - | ||||||||||||
| Misc. | $ 2,678.96 | $ 29.94 | $ - | $ 1,728.00 | $ 369.00 | $ 258.00 | $ 139.61 | $ 154.41 | ||||||
| YTD Total | $ 19,024.46 | $ - | ||||||||||||
| Total | $ 17,860.00 | $ 19,024.46 | $ 647.44 | $ - | $ 1,462.50 | $ 1,357.50 | $ 1,357.50 | $ 3,085.50 | $ 1,726.50 | $ 5,021.00 | $ 1,497.11 | $ 1,511.91 | $ 1,357.50 | |
| Pool Budget | ||||||||||||||
| 2008 | ||||||||||||||
| Budget | YTD | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Payroll | $ 10,000.00 | $ 11,217.51 | $ 3,125.44 | $ 4,237.24 | $ 2,235.38 | $ 1,560.32 | $ 59.13 | $ - | ||||||
| Payroll Tax | $ 1,100.00 | $ 942.44 | $ (419.88) | $ 335.56 | $ 137.08 | $ 574.02 | $ 315.66 | |||||||
| Maintenance | $ 1,000.00 | $ 2,789.04 | $ 685.75 | $ 1,526.70 | $ 323.72 | $ 103.38 | $ 100.00 | $ 49.49 | ||||||
| Open/Close | $ 1,300.00 | $ 1,295.00 | $ 770.00 | $ 525.00 | ||||||||||
| Improvmnts | $ 5,345.00 | $ 839.74 | ||||||||||||
| Scavenger | $ - | |||||||||||||
| Repairs | $ - | $ 464.28 | ||||||||||||
| YTD Total | $ 16,243.99 | |||||||||||||
| Total | $ 18,745.00 | $ 17,548.01 | $ - | $ - | $ 2,295.49 | $ 4,232.26 | $ 5,360.80 | $ 2,475.84 | $ 2,234.34 | $ 949.28 | $ - | $ - | ||
| Cap. Budget | ||||||||||||||
| 2008 | ||||||||||||||
| Budget | YTD | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Income | $ 32,400.00 | $ 38,107.50 | $ 750.00 | $ 75.00 | $ 16,660.00 | $ 9,617.50 | $ 5,315.00 | $ 3,240.00 | $ 1,000.00 | $ 750.00 | $ 700.00 | |||
| Well | $ 3,049.00 | $ 3,049.00 | ||||||||||||
| Fence | $ 8,800.00 | $ 3,100.00 | $ 5,700.00 | |||||||||||
| Pool | $ - | |||||||||||||
| Tennis | $ 38,973.91 | $ 7,692.00 | $ 23,076.00 | $ 8,205.91 | ||||||||||
| Clubhouse | $ - | |||||||||||||
| Total Exp. | $ 50,822.91 | $ 7,692.00 | $ 6,149.00 | $ 28,776.00 | $ 8,205.91 | |||||||||