City of Centerville
<br />Balance Sheet
<br />Fiscal Year 2010
<br />8/31110
<br />Fund Balance
<br />G xxx -25300 Unreserved Fund Balance at 12131/09 1,231,324.62 3,803,085.84 5,839,073.98 10,927,888.04 21,801,372.48
<br />Excess of Revenues over Expenses (1/1/10 to 8/31/10) (299,432.42) (2,392,157.67) 1,940,525.64 (253,543.80) (1,004,608.25)
<br />Total Fund Balance 931,892.20 1,410,928.17 7,779,599.62 10,674,34424 20,796,76423
<br />Unaudited - For Management Purposes Only
<br />31
<br />Other
<br />G xxx -20600 Contracts Payable (Retainage)
<br />62,518.70
<br />Governmental
<br />G xxx -20800 State Sales and Use Tax
<br />-
<br />Fund Name
<br />General Fund
<br />Debt Service
<br />Funds
<br />Enterprise Funds
<br />All Funds
<br />• xxx -10100 Cash
<br />1,409,200.68
<br />1,782,262.47
<br />452,288.11
<br />1,897,179.88
<br />5,540,931.14
<br />• xxx -10200 Petty Cash
<br />199.00
<br />(5,659.78)
<br />-
<br />199.00
<br />• xxx -10250 Cougar Cash
<br />150.00
<br />-
<br />150.00
<br />G xxx -10410 Twin Cities CCF
<br />-
<br />(126.00)
<br />50,000.00
<br />50,000.00
<br />G xxx -10450 Interest Receivable on Invest
<br />18,447.06
<br />(62.08)
<br />G xxx -21715 Dental Insurance
<br />-
<br />18,447.06
<br />G xxx -10700 Taxes Receivable - Delinquent
<br />80,707.10
<br />G xxx -21717 OPEB
<br />-
<br />14,768.00
<br />80,707.10
<br />G xxx -10800 Allow for Uncollected Taxes
<br />(80,70710)
<br />80,707.10
<br />10,809,438.83
<br />• xxx -11500 Accounts Receivable
<br />3,602.27
<br />-
<br />41,691.80
<br />-
<br />45,294.07
<br />• xxx -12200 Special Assess Rec - Delinquent
<br />5,346.47
<br />23,700.60
<br />-
<br />5,127.09
<br />34,174.16
<br />G xxx -12300 Special Assess Rec - Deferred
<br />118,120,53
<br />2,640,805.54
<br />G xxx -24504 Site Main. Escrow
<br />132,968.09
<br />2,891,894.16
<br />G xxx -13100 Due from Other Funds
<br />-
<br />G xxx -24506 Road Repair Escrow
<br />4,400.00
<br />1,197,166.50
<br />1,197,166.50
<br />G xxx -14200 Inventory for Resale
<br />G xxx -24508 Erosion Control Escrow
<br />5,100.00
<br />3,469.30
<br />3,469.30
<br />G xxx -15620 Unamortized Bond Discount
<br />47,480.00
<br />168,951.00
<br />-
<br />168,951.00
<br />G xxx -16100 Land
<br />3,253,120.00
<br />186,000.00
<br />3,439,120.00
<br />G xxx -16200 Buildings
<br />1,627,438.00
<br />414,000.00
<br />2,041,438.00
<br />G xxx -16330 Streets
<br />6,149,008.00
<br />6,149,008.00
<br />G xxx -16331 Trails
<br />1,310,166.00
<br />1,310,166.00
<br />G xxx -16335 Storm Water
<br />1,745,288.00
<br />1,745,288.00
<br />G xxx -16400 Machinery
<br />786,741.00
<br />8,408,623.81
<br />9,195,364.81
<br />G xxx -16410 Depreciation
<br />-
<br />(2,426,722.43)
<br />(2,426,722.43)
<br />G xxx -16500 Fixed Asset - In Progress
<br />4,469,754.00
<br />0.77
<br />4,469,754.77
<br />G xxx -16600 Fixed Assets
<br />986,323.43
<br />986,323.43
<br />G xxx -16999 Accumulated Depreciation
<br />(3,512,400.00)
<br />(65,333.85)
<br />(3,577,733.85)
<br />Fund Balance
<br />G xxx -25300 Unreserved Fund Balance at 12131/09 1,231,324.62 3,803,085.84 5,839,073.98 10,927,888.04 21,801,372.48
<br />Excess of Revenues over Expenses (1/1/10 to 8/31/10) (299,432.42) (2,392,157.67) 1,940,525.64 (253,543.80) (1,004,608.25)
<br />Total Fund Balance 931,892.20 1,410,928.17 7,779,599.62 10,674,34424 20,796,76423
<br />Unaudited - For Management Purposes Only
<br />31
<br />G xxx -20600 Contracts Payable (Retainage)
<br />62,518.70
<br />62,518.70
<br />G xxx -20800 State Sales and Use Tax
<br />-
<br />-
<br />(561.15)
<br />(561.15)
<br />G xxx -20900 Due to Other Funds
<br />448,827.82 371,334.30
<br />283,311.88
<br />110,000.00
<br />1,213,474.00
<br />G xxx -21500 Accrued Interest Payable
<br />- -
<br />149,776.00
<br />-
<br />149,776.00
<br />G xxx -21706 Health Insurance
<br />(5,659.78)
<br />-
<br />(5,659.78)
<br />G xxx -21707 Union Dues
<br />(95.25)
<br />(95.25)
<br />G xxx -21708 Disability Insurance
<br />(126.00)
<br />(126.00)
<br />G xxx -21715 Life Insurance
<br />(62.08)
<br />(62.08)
<br />G xxx -21715 Dental Insurance
<br />(507.90)
<br />-
<br />-
<br />(507.90)
<br />G xxx -21717 OPEB
<br />14,768.00
<br />4,664.00
<br />19,432.00
<br />G xxx -23100 Bonds Payable Non - Current
<br />10,809,438.83
<br />10,809,438.83
<br />G xxx -22100 Bonds Payable Current
<br />11,812.50
<br />11,812.50
<br />• xxx -22200 Deferred Revenues
<br />123,467.00 2,664,506.14
<br />(2,538,472.52)
<br />249,500.62
<br />• xxx -24500 Bid Penn it Surcharge
<br />150.00
<br />150.00
<br />G xxx -24504 Site Main. Escrow
<br />200.00
<br />200.00
<br />G xxx -24506 Road Repair Escrow
<br />4,400.00
<br />4,400.00
<br />G xxx -24508 Erosion Control Escrow
<br />5,100.00
<br />-
<br />5,100.00
<br />G xxx -24510 Other Escrow
<br />47,480.00
<br />355.50
<br />47,835.50
<br />Fund Balance
<br />G xxx -25300 Unreserved Fund Balance at 12131/09 1,231,324.62 3,803,085.84 5,839,073.98 10,927,888.04 21,801,372.48
<br />Excess of Revenues over Expenses (1/1/10 to 8/31/10) (299,432.42) (2,392,157.67) 1,940,525.64 (253,543.80) (1,004,608.25)
<br />Total Fund Balance 931,892.20 1,410,928.17 7,779,599.62 10,674,34424 20,796,76423
<br />Unaudited - For Management Purposes Only
<br />31
<br />
|