Sunscape Estates RV Park Coop.
| | | Sep 30, 2009 |
| ASSETS | | |
| Current Assets | | |
| Checking/Savings | | |
| 1002 · BofA Operations Chking 0345 | 21,614.10 | |
| 1010 · MONEY MARKET - SAVINGS | | |
| 1016 · Money Mkt. | 28,359.40 | |
| 1020 · Great Western C D | 250,000.00 | |
| 1021 · B of A Risk Free C D | 50,458.94 | |
| Total 1010 · MONEY MARKET - SAVINGS | 328,818.34 | |
| 1040 · CHANGE FUND ACCOUNTS | | |
| 1042 · Business Office | 500.00 | |
| 1048 · Kitchen | 100.00 | |
| 1055 · | 250.00 | |
| Total 1040 · CHANGE FUND ACCOUNTS | 850.00 | |
| Total Checking/Savings | | 351,282.44 |
| Accounts Receivable | | |
| 1200 · Accounts Receivable | 4,076.93 | |
| Total Accounts Receivable | | 4,076.93 |
| Total Current Assets | | 355,359.37 |
| TOTAL ASSETS | | 355,359.37 |
| LIABILITIES & EQUITY | | |
| Liabilities | | |
| Current Liabilities | | |
| Other Current Liabilities | | |
| 2100 · Payroll Liabilities | | |
| 2101 · Federal 941 taxes payable | 2,138.72 | |
| 2103 · Federal Unemployment | 522.54 | |
| 2110 · | 317.28 | |
| 2111 · | 191.67 | |
| 2112 · | 11.98 | |
| 2100 · Payroll Liabilities - Other | 178.26 | |
| Total 2100 · Payroll Liabilities | 3,360.45 | |
| Total Other Current Liabilities | | 3,360.45 |
| Total Current Liabilities | | 3,360.45 |
| Long Term Liabilities | | |
| 2400 · RESTRICTED LIABILITIES | | |
| 1012 · 1012 Capital Improvment | 136,683.48 | |
| 1014 · 1014 Contingency Account | 84,847.91 | |
| 1017 · Park Improvements-Comm. Complex | 24,804.67 | |
| Total 2400 · RESTRICTED LIABILITIES | 246,336.06 | |
| Total Long Term Liabilities | | 246,336.06 |
| Total Liabilities | | 249,696.51 |
| Equity | | |
| 3000 · Opening Bal Equity | 8,660.55 | |
| 3900 · Retained Earnings | 185,643.70 | |
| Net Income | -88,641.39 | |
| Total Equity | | 105,662.86 |
| TOTAL LIABILITIES & EQUITY | | 355,359.37 |
| 10/05/09 | Profit & Loss Budget vs. Actual | | | |
| Accrual Basis | January through September 2009 | | | |
| | | Jan - Sep 09 | | Budget |
| Ordinary Income/Expense | | | | |
| Income | | | | |
| 3525 · Operating Cash Carry Over | 8,660.55 | 8,660.55 | ||
| 4030 · SHAREHOLDER | | | | |
| 4032 · Shareholder Asses. 480@$925 | 441,140.00 | 444,000.00 | ||
| 4034 · Less Frz. Dues, No Asses. | 0.00 | -2,860.00 | ||
| 4036 · Shareholder Assess-480@925.00 | 0.00 | | | |
| 4039 · Transfer to Capilal Reserve | -14,000.00 | -14,000.00 | ||
| Total 4030 · SHAREHOLDER | 427,140.00 | 427,140.00 | ||
| 4040 · OPERATIONAL INCOME | | | | |
| 4010 | · Activities/Entertainment Inc | 5,562.44 | 7,000.00 | |
| 4015 · Gate Cards & Mail Keys | -482.26 | | | |
| 4041 | · Rental Income Daily and Weekly | 13,360.45 | 27,000.00 | |
| 4042 | · Rental Income Monthly | 16,458.75 | | |
| 4043 | · Rental Storage | 5,691.08 | 9,000.00 | |
| 4044 | · Rental Vendor Room | 350.00 | | |
| 4045 | · Resale & Vendor Commissions Inc | 3,577.25 | 7,500.00 | |
| 4046 | · Resale - Clickers | 0.00 | 840.00 | |
| 4050 · Office Income | 2,586.92 | 3,000.00 | ||
| 4054 | · Investment Interest | 1,658.83 | | |
| 4055 | · Interest & Late Fees Inc | 727.73 | 2,500.00 | |
| 4060 | · Kitchen Receipts | 12,351.88 | 17,500.00 | |
| 4065 | · Laundry | 8,203.26 | 7,000.00 | |
| 4070 · Propane Sales | 10,285.55 | 20,000.00 | ||
| 4085 | · Transfer/Inspection Fees Inc | 1,390.10 | 2,500.00 | |
| 4115 · Bingo | 669.95 | 500.00 | ||
| 4120 | · Memberships | 66.00 | | |
| 4155 | · Reimbursements to Co-op | 2,029.37 | 4,500.00 | |
| 4180 | · Over/Short Cash | 92.56 | | |
| Total 4040 · OPERATIONAL INCOME | 84,579.86 | | 108,840.00 | |
| Total Income | 520,380.41 | | 544,640.55 | |
| Gross Profit | | 520,380.41 | 544,640.55 | |
| Expense | | | | |
| 6000 · COOP. OPERATIONAL EXPENSES | | | | |
| 6005 · Accountant / CPA Fees | 2,395.00 | 3,000.00 | ||
| 6010 · Advertising & Marketing | 794.97 | 4,000.00 | ||
| 6011 · Ambassadors | 72.09 | 284.00 | ||
| 6012 | · Architectural Committee | 630.11 | 760.00 | |
| 6015 | · Autos & Mileage Exp | 392.92 | 2,000.00 | |
| 6020 | · Bank Svc/Finance Charges | 1,101.43 | 1,000.00 | |
| 6022 | · Board/Annual Meetings | 1,072.34 | 1,500.00 | |
| 6025 | · Fire Department | 3,451.02 | 4,500.00 | |
| 6035 · Licenses & Permits | 556.87 | 1,500.00 | ||
| 6045 | · Entertainment Exp | 1,427.32 | 5,000.00 | |
| 6050 | · Kitchen Supplies/Food Purchases | 5,566.09 | 8,600.00 | |
| 6055 | · Legal / Attorney Fees | 8,847.85 | 10,000.00 | |
| 6065 | · Miscellaneous Expenses | 123.21 | 500.00 | |
| 6070 | · Payroll Taxes Federal / FICA | 7,890.59 | 10,910.00 | |
| 6080 | · Payroll-Worker Comp Insurance | 2,224.00 | 2,880.00 | |
| 6085 | · Payroll Taxes-Fed Unemplymt | 522.55 | 570.00 | |
| 6090 | · Payroll Taxes-AZ Unemployment | 1,045.09 | 1,569.00 | |
| 6095 | · Office Exp & Eqt | 5,139.13 | 7,200.00 | |
| 6100 · Propane Purchases | 8,193.32 | 16,000.00 | ||
| 6102 | · Property Committee | 68.42 | 300.00 | |
| 6105 | · Property Insurance | 12,328.58 | 23,113.00 | |
| 6111 | · Medical | 2,008.99 | 3,500.00 | |
| 6112 | · Safety & Security | 1,264.09 | 500.00 | |
| 6115 | · Salary - Activity Director | 3,150.00 | 5,550.00 | |
| 6120 | · Salary - Housekeeping | 7,142.82 | 10,800.00 | |
| 6125 | · Salary - Kitchen | 4,269.29 | 6,125.00 | |
| 6130 · Salary - Maintenance | 39,744.68 | 51,288.00 | ||
| 6135 · Salary - Manager | 32,175.00 | 46,500.00 | ||
| 6140 | · Salary - Mail Handling | 5,276.25 | 7,020.00 | |
| 6143 | · Salary - Bookkeeper | 7,762.50 | 10,350.00 | |
| 6146 | · | 3,609.31 | 4,960.00 | |
| 6150 | · Sales Tax (Food, Propane) | 2,088.77 | 3,500.00 | |
| 6152 | · Resale & Vendor Commissions Exp | 1,181.42 | 4,000.00 | |
| 6153 | · Resale - Clickers | 277.76 | 600.00 | |
| 6159 | · Supplies - Activity Office | 1,186.34 | 3,200.00 | |
| 6160 | · Supplies - Buildings | 2,986.37 | 5,000.00 | |
Page 1
Sunscape Estates RV Park Coop.
| 10/05/09 | Profit & Loss Budget vs. Actual | | | |
| Accrual Basis | January through September 2009 | | | |
| | | Jan - Sep 09 | | Budget |
| 6167 | · Supplies Post Office | 534.69 | 1,100.00 | |
| 6168 | · Supplies - | 345.69 | 500.00 | |
| 6175 | · Taxes - Real Estate | 8,939.27 | 18,000.00 | |
| 6180 | · Taxes - State Income | 76.12 | 45.00 | |
| 6192 | · Payroll Taxes-Az. Job Training | 65.33 | 80.00 | |
| 6196 | · Electric Rental | 2,749.85 | 5,000.00 | |
| 6200 | · Utilities - Electric | 21,065.04 | 27,000.00 | |
| 6205 | · Utilities - Natural Gas | 12,481.43 | 18,000.00 | |
| 6210 | · Utilities - Telephone | 3,936.02 | 5,000.00 | |
| 6215 | · Utilities - Trash | 9,726.61 | 12,000.00 | |
| 6220 | · Utilities - Water | 17,090.74 | 24,000.00 | |
| 6222 · Utilities - Sewer | 83,700.00 | 111,600.00 | ||
| 6225 | · Volunteer Appreciation Exp | 283.28 | 500.00 | |
| 6300 | · Park Maintenance | | | |
| 6320 · Coop Equipment/Tractor Etc. | 3,864.31 | 4,450.00 | ||
| 6325 · Dry Well & Septic Service | 5,846.02 | 10,000.00 | ||
| 6330 · Bldg & Grounds Maintenance | 13,460.96 | 30,921.55 | ||
| 6331 · Maintenance Tools | 1,808.71 | 2,000.00 | ||
| 6335 · Pool/Solar System | 3,617.84 | 5,000.00 | ||
| 6341 · Road Repair | 14,000.00 | | | |
| 6342 · Sunscape Survey | 9,617.96 | | | |
| 6300 · Park Maintenance - Other | 0.00 | | | |
| Total 6300 · Park Maintenance | 52,215.80 | 52,371.55 | ||
| 6500 | · Capital Improvements | | | |
| 6541 · Office Furniture | 1,283.50 | 1,365.00 | ||
| 6547 · | 0.00 | | | |
| Total 6500 · Capital Improvements | 1,283.50 | 1,365.00 | ||
| Total 6000 · COOP. OPERATIONAL EXPENSES | 392,459.86 | 544,640.55 | ||
| 7080 · Reserve Funds | 215,725.99 | | | |
| 7081 · Earned Income Alocation | 835.95 | | | |
| Total Expense | 609,021.80 | | 544,640.55 | |
| Net Ordinary Income | -88,641.39 | | 0.00 | |
| Net Income | | -88,641.39 | | 0.00 |
Fund Raisers/ Donations/Activities
| Balance Sheet | |
| As of September 30, 2009 | |
| | Sep 30, 09 |
| ASSETS | |
| Current Assets | |
| Checking/Savings | |
| 1001 · FR/D/A | 9,159.27 |
| Total Checking/Savings | 9,159.27 |
| Total Current Assets | 9,159.27 |
| TOTAL ASSETS | 9,159.27 |
| LIABILITIES & EQUITY | |
| Liabilities | |
| Current Liabilities | |
| Other Current Liabilities | |
| 2000 FR/D/A | |
| 2165 · Cancer Fund | 28.60 |
| 2004 · Block Watch | 163.50 |
| 2006 · Singles Club | 339.00 |
| 2142 · Summer Activity Fund | 190.63 |
| 2009 · Park Party Start-up Fund | 3,431.10 |
| 2070 Medical - Other | 72.33 |
| 2075 · Movie Night & Accessories Fund | 296.26 |
| 2090 Computer Club | 1,213.72 |
| 2110 Library | 57.60 |
| 2120 Quilters | 47.89 |
| 2130 Jammers | 1,217.62 |
| 2152 · Scarlet Darlins' | 1,050.75 |
| 2185 · Parade Floats | 333.15 |
| 2200 Activity Committee | 656.12 |
| Total 2000 FR/D/A | 9,098.27 |
| Total Other Current Liabilities | 9,098.27 |
| Total Current Liabilities | 9,098.27 |
| Total Liabilities | 9,098.27 |
| Equity | |
| 2091 · Genealogy Group | 61.00 |
| Total Equity | 61.00 |
| TOTAL LIABILITIES & EQUITY | 9,159.27 |