City of Centerville
<br />Balance Sheet
<br />Fiscal Year 2010
<br />3/31/10
<br />Fund Balance
<br />G xxx -25300 Unreserved Fund Balance at 12/31/09 1,243,298.56 3,800,133.84 4,444,347.98 10,911,821.04 20,399,601.42
<br />Excess of Revenues over Expenses (1/1/10 to 3/31/10) (347,784.31) (2,775,650.13) 2,278,560.68 864.87 (844,008.89)
<br />Total Fund Balance 895,514.25 1,024,483.71 6,722,908.66 10,912,685.91 19.555,592.53
<br />Other
<br />G xxx -20600 Contracts Payable (Retainage)
<br />13,939.35
<br />-
<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 />G xxx -10100 Cash
<br />1,373,296.24
<br />1,390,330.31
<br />768,002.42
<br />2,207,066.26
<br />5,738,695.23
<br />G xxx -10200 Petty Cash
<br />199.00
<br />(4,973.68)
<br />-
<br />199.00
<br />G xxx -10250 Cougar Cash
<br />150.00
<br />-
<br />150.00
<br />G xxx -10410 Twin Cities CCF
<br />(60.08)
<br />50,000.00
<br />50,000.00
<br />G xxx -10425 Cash with fiscal agent
<br />-
<br />(481.50)
<br />G xxx -21717 OPEB
<br />-
<br />-
<br />G xxx -10450 Interest Receivable on Invest
<br />18,447.06
<br />G xxx -23100 Bonds Payable Non - Current
<br />10,809,438.83
<br />18,447.06
<br />G xxx -10700 Taxes Receivable - Delinquent
<br />80,707.10
<br />-
<br />-
<br />-
<br />80,707.10
<br />G xxx -10800 Allow for Uncollected Taxes
<br />(80,707.10)
<br />2,285,506.14 (1,640,686.52)
<br />80,707.10
<br />-
<br />-
<br />G xxx -11500 Accounts Receivable
<br />3,180.09
<br />-
<br />41,691.80
<br />180,756.46
<br />225,628.35
<br />G 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,261,805.54
<br />53,500.00
<br />132,968.09
<br />2,512,894.16
<br />G xxx -13100 Due from Other Funds
<br />-
<br />1,087,166.50
<br />1,087,166.50
<br />G xxx -14200 Inventory for Resale
<br />-
<br />3,469.30
<br />3,469.30
<br />G xxx -15620 Unamortized Bond Discount
<br />168,951.00
<br />-
<br />168,951.00
<br />G xxx -16100 Land
<br />3,258,620.00
<br />186,000.00
<br />3,444,620.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 />-
<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,096,556.00
<br />0.77
<br />4,096,556.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 12/31/09 1,243,298.56 3,800,133.84 4,444,347.98 10,911,821.04 20,399,601.42
<br />Excess of Revenues over Expenses (1/1/10 to 3/31/10) (347,784.31) (2,775,650.13) 2,278,560.68 864.87 (844,008.89)
<br />Total Fund Balance 895,514.25 1,024,483.71 6,722,908.66 10,912,685.91 19.555,592.53
<br />G xxx -20600 Contracts Payable (Retainage)
<br />13,939.35
<br />-
<br />13,939.35
<br />G xxx -20800 State Sales and Use Tax
<br />-
<br />- -
<br />2,240.02
<br />2,240.02
<br />G xxx -20900 Due to Other Funds
<br />442,194.90
<br />365,846.60 279,125.00
<br />-
<br />1,087,166.50
<br />G xxx -21500 Accrued Interest Payable
<br />-
<br />- 149,776.00
<br />149,776.00
<br />G xxx -21706 Health Insurance
<br />(4,973.68)
<br />-
<br />(4,973.68)
<br />G xxx -21708 Disability Insurance
<br />(121.50)
<br />(121.50)
<br />G xxx -21715 Life Insurance
<br />(60.08)
<br />(60.08)
<br />G xxx -21715 Dental Insurance
<br />(481.50)
<br />-
<br />-
<br />(481.50)
<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 />-
<br />10,809,438.83
<br />G xxx -22100 Bonds Payable Current
<br />-
<br />171,500.00
<br />-
<br />171,500.00
<br />G xxx -22200 Deferred Revenues
<br />123,467.00
<br />2,285,506.14 (1,640,686.52)
<br />249,500.00
<br />1,017,786.62
<br />G xxx -24504 Site Main. Escrow
<br />200.00
<br />-
<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 />51100.00
<br />G xxx -24510 Other Escrow
<br />53,500.00
<br />355.50
<br />53,855.50
<br />Fund Balance
<br />G xxx -25300 Unreserved Fund Balance at 12/31/09 1,243,298.56 3,800,133.84 4,444,347.98 10,911,821.04 20,399,601.42
<br />Excess of Revenues over Expenses (1/1/10 to 3/31/10) (347,784.31) (2,775,650.13) 2,278,560.68 864.87 (844,008.89)
<br />Total Fund Balance 895,514.25 1,024,483.71 6,722,908.66 10,912,685.91 19.555,592.53
<br />
|