| Grantchester Maintenance Corporation | |||||||||||||||||
| FY 2003 | |||||||||||||||||
| Cash Flow | |||||||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Actual | Budget | Difference | % Budget | ||
| Source: | |||||||||||||||||
| Cash on hand 12/31/02 | $5,383.00 | $5,383.00 | $0.00 | 100% | |||||||||||||
| $0.00 | |||||||||||||||||
| Annual Fees | $0.00 | $4,800.00 | $5,900.00 | $1,100.00 | $0.00 | $100.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $11,900.00 | $12,400.00 | $500.00 | 96% | |
| Interest income (CD) | $53.46 | $53.56 | $46.75 | $42.62 | $40.03 | $41.42 | $40.15 | $41.54 | $40.27 | $33.52 | $34.00 | $34.00 | $501.32 | $700.00 | $198.68 | 72% | |
| Interest Income (MM) | $0.90 | $0.54 | $2.15 | $1.90 | $1.96 | $1.90 | $1.96 | $1.96 | $1.12 | $0.89 | $1.00 | $1.00 | $17.28 | $25.00 | $7.72 | 69% | |
| NCCo Reimbursement | $0.00 | $0.00 | $0.00 | $1,090.31 | $0.00 | $1,447.50 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,537.81 | $0.00 | ($2,537.81) | 0% | |
| Total Sources | $54.36 | $4,854.10 | $5,948.90 | $2,234.83 | $41.99 | $1,590.82 | $42.11 | $43.50 | $41.39 | $34.41 | $35.00 | $35.00 | $20,339.41 | $18,508.00 | ($1,831.41) | 110% | |
| Use: | |||||||||||||||||
| Accounting | $500.00 | 500.00 | 500.00 | $0.00 | 100% | ||||||||||||
| Bank Fees | $12.00 | $34.00 | $2.00 | $2.00 | $115.00 | 165.00 | 30.00 | ($135.00) | 550% | ||||||||
| Insurance | $1,094.00 | 1,094.00 | 1,100.00 | $6.00 | 99% | ||||||||||||
| Legal | 0.00 | 500.00 | $500.00 | 0% | |||||||||||||
| Management | 0.00 | 0.00 | $0.00 | 0% | |||||||||||||
| Office Expenses | $105.09 | $24.00 | $50.40 | $42.61 | $189.30 | 411.40 | 500.00 | $88.60 | 82% | ||||||||
| Newsletters | 0.00 | 100.00 | $100.00 | 0% | |||||||||||||
| Repairs/Maintenance | $375.00 | $1,175.00 | $1,175.00 | 2,725.00 | 3,628.00 | $903.00 | 75% | ||||||||||
| Snow Removal | $2,500.00 | $1,300.00 | 3,800.00 | 3,900.00 | $100.00 | 97% | |||||||||||
| Landscaping | $1,535.80 | 1,535.80 | 2,000.00 | $464.20 | 77% | ||||||||||||
| Grass Cutting | $925.00 | $475.00 | $750.00 | $600.00 | $600.00 | $750.00 | $750.00 | $250.00 | 5,100.00 | 5,100.00 | $0.00 | 100% | |||||
| Taxes | 250.00 | $250.00 | 0% | ||||||||||||||
| Utilities | $39.00 | $9.51 | $0.00 | $20.00 | $20.00 | $20.00 | $20.00 | $20.30 | $40.60 | $20.00 | 209.41 | 400.00 | $190.59 | 52% | |||
| Miscellaneous | $59.00 | $20.00 | $10.00 | 89.00 | 500.00 | $411.00 | 18% | ||||||||||
| Total Uses | $1,035.00 | $2,639.09 | $1,326.00 | $384.51 | $0.00 | $1,720.40 | $790.00 | $2,208.41 | $3,580.30 | $885.30 | $790.60 | $270.00 | 15,629.61 | 18,508.00 | $2,878.39 | 84% | |
| Source/(Use) | -$980.64 | $2,215.01 | $4,622.90 | $1,850.32 | $41.99 | -$129.58 | -$747.89 | -$2,164.91 | -$3,538.91 | -$850.89 | -$755.60 | -$235.00 | $4,709.80 | $0.00 | -$4,709.80 | ||
| Cash Balances | 12/31/2002 | 12/31/2003 | |||||||||||||||
| Checking | $161.51 | $126.51 | $1,487.42 | $1,861.42 | $3,667.22 | $3,667.22 | $3,494.32 | $2,704.32 | $495.91 | $1,915.61 | $1,085.31 | $294.71 | $24.71 | ||||
| Money Market | $5,221.97 | $4,222.87 | $5,023.41 | $9,225.56 | $9,227.46 | $9,229.42 | $9,231.32 | $9,233.28 | $9,235.24 | $4,236.36 | $4,182.25 | $4,183.25 | $4,184.25 | ||||
| CD | $26,989.78 | $27,043.24 | $27,096.80 | $27,143.55 | $27,186.17 | $27,226.20 | $27,267.62 | $27,307.77 | $27,349.31 | $27,389.58 | $27,423.10 | $27,457.10 | $27,491.10 | ||||
| $32,373.26 | $31,392.62 | $33,607.63 | $38,230.53 | $40,080.85 | $40,122.84 | $39,993.26 | $39,245.37 | $37,080.46 | $33,541.55 | $32,690.66 | $31,935.06 | $31,700.06 | |||||