Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) September 30, 2013 General Fund Library Capital Projects RDA MBA CDBG Cemetery Total Assets Cash and cash equivalents 7,610,681 $ 31,688 $ 10,615,479 $ 1,837,645 $ 2,018 $ ‐ $ 1,371,385 $ 21,468,896 $ Accounts receivable (net) 6,421,974 1,464,738 ‐ 2,339,342 ‐ ‐ ‐ 10,226,054 Due from other governments 1,444 ‐ ‐ ‐ ‐ ‐ ‐ 1,444 Prepaids 29,636 ‐ ‐ ‐ ‐ ‐ ‐ 29,636 Restricted cash 70,686 15,750 200,000 250,000 ‐ ‐ ‐ 536,436 Total assets 14,134,421 1,512,176 10,815,479 4,426,987 2,018 ‐ 1,371,385 32,262,466 Liabilities Accrued Liabilities 811,540 17,135 34,284 14,288 ‐ ‐ ‐ 877,247 Total liabilities 811,540 17,135 34,284 14,288 ‐ ‐ ‐ 877,247 Deferred Inflows of Resources Deferred Inflows‐ property taxes 6,014,202 1,464,738 ‐ 2,339,342 ‐ ‐ ‐ 9,818,282 Total deferred inflows of resources 6,014,202 1,464,738 ‐ 2,339,342 ‐ ‐ ‐ 9,818,282 Fund Balance Restricted 362,764 15,730 638,349 827,056 ‐ ‐ 520,000 2,363,899 Beginning fund balance 9,962,698 314,520 8,050,744 1,529,669 1,769 ‐ 839,593 20,698,993 Change in fund balance (3,016,783) (299,947) 2,092,102 (283,368) 249 ‐ 11,792 (1,495,955) Total fund balance 7,308,679 $ 30,303 $ 10,781,195 $ 2,073,357 $ 2,018 $ ‐ $ 1,371,385 $ 21,566,937 $ ---PAGE BREAK--- September 30, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) General Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Property tax 144,073 $ 155,319 $ 6,619,202 $ 6,619,202 $ (6,463,883) $ Sales tax 915,466 1,056,812 12,682,000 12,682,000 (11,625,188) Franchise tax 963,281 892,315 4,825,000 4,825,000 (3,932,685) Business license 162,443 159,708 645,000 645,000 (485,292) Building permits 144,165 278,612 518,000 518,000 (239,388) Fines and forfeitures 384,711 396,466 1,703,000 1,703,000 (1,306,534) Miscellaneous 40,915 52,611 187,000 194,500 (141,889) Sale of fixed assets 60,427 ‐ ‐ ‐ ‐ Intergovernmental 252,724 250,908 1,586,017 1,701,459 (1,450,551) Public safety 262,520 192,748 1,002,000 1,002,000 (809,252) Parks and recreation 548,093 552,207 1,504,500 1,504,500 (952,293) Transfers in 1,155,024 1,161,903 4,647,611 4,647,611 (3,485,708) Administrative fees 753,294 741,951 2,983,289 2,988,990 (2,247,039) Investment income 49,628 11,740 75,000 75,000 (63,260) Total revenue 5,836,764 5,903,300 38,977,619 39,106,262 Expenditures Payroll General Government 628,142 601,583 3,000,243 3,000,243 2,398,660 Police 1,574,407 1,661,177 8,278,453 8,311,495 6,650,318 Fire 1,217,246 1,218,161 5,953,177 5,961,677 4,743,516 Public works 350,978 366,102 1,645,816 1,645,816 1,279,714 Parks 830,114 846,302 3,628,515 3,628,515 2,782,213 ADS 735,891 766,692 3,796,992 3,796,992 3,030,300 Operations and maintenance General Government 329,485 542,463 1,549,596 1,550,996 1,008,533 Police 632,558 666,414 1,963,774 2,077,164 1,410,750 Fire 215,329 244,160 900,819 932,819 688,659 Public works 196,945 93,354 620,844 810,844 717,490 Class C 177,390 150,708 428,000 528,000 377,292 Parks 649,610 625,347 1,970,029 1,983,529 1,358,182 ADS 389,975 364,698 1,314,604 1,320,305 955,607 Capital Outlay Class C 39,557 272,470 879,000 1,047,374 774,904 Parks ‐ 2,361 ‐ ‐ (2,361) ADS ‐ ‐ ‐ ‐ ‐ Debt Service Principle ‐ 86,066 1,255,000 1,255,000 1,168,934 UTOPIA payments 395,227 403,132 1,619,333 1,619,333 1,216,201 Interest and fiscal charge ‐ 175 363,551 363,551 363,376 Transfer out 8,718 8,718 2,034,873 2,694,873 2,686,155 Total Expenditures 8,391,572 8,920,083 41,202,619 42,528,526 Net change in fund balance (2,554,808) $ (3,016,783) $ ---PAGE BREAK--- September 30, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) Library Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Property tax 35,041 $ 37,782 $ 1,619,738 $ 1,619,738 $ (1,581,956) $ Fines and forfeitures 11,106 13,003 45,000 45,000 (31,997) Miscellaneous 1,435 1,708 6,500 6,500 (4,792) Intergovernmental ‐ 13,322 12,500 25,822 (12,500) Investment income 1,080 486 6,000 6,000 (5,514) Total revenue 48,662 66,301 1,689,738 1,703,060 Expenditures Payroll 241,808 208,325 1,011,204 1,029,546 821,221 Operations and maintenance 112,548 128,007 503,871 498,851 370,844 Capital Outlay 1,481 ‐ 55,000 55,000 55,000 Administrative Fee 24,699 29,916 119,663 119,663 89,747 Total Expenditures 380,536 366,248 1,689,738 1,703,060 Net change in fund balance (331,874) $ (299,947) $ ---PAGE BREAK--- September 30, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) Capital Projects Fund Current YTD Original Budget Final Budget Variance Revenue Transfers in ‐ 2,200,000 2,860,000 (2,860,000) Intergovernmental 2,525,000 725,000 2,525,000 ‐ Sale of fixed assets ‐ ‐ ‐ ‐ Miscellaneous 414,080 425,000 425,000 (10,920) Investment income 10,873 ‐ ‐ 10,873 Total revenue 2,949,953 3,350,000 5,810,000 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police 53,410 59,320 59,320 5,910 Fire 32,429 36,420 70,510 38,081 Public works 123,513 362,313 363,865 240,352 Parks 11,455 43,000 43,000 31,545 ADS 5,000 110,500 110,500 105,500 Capital Outlay General Government ‐ ‐ ‐ ‐ Police ‐ 57,700 57,700 57,700 Fire 99,865 217,282 183,192 83,327 Public works 10,193 1,636,000 3,434,448 3,424,255 Parks 98,847 139,000 139,000 40,153 ADS 414,080 466,120 666,120 252,040 Transfer out ‐ ‐ 200,000 200,000 Total Expenditures 857,851 3,156,155 5,356,155 Net change in fund balance 2,092,102 $ ---PAGE BREAK--- September 30, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) RDA Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Property tax ‐ $ ‐ $ 2,339,342 $ 2,339,342 $ (2,339,342) $ Miscellaneous ‐ ‐ ‐ ‐ ‐ Investment income 2,711 2,445 8,000 8,000 (5,555) Total revenue 2,711 2,445 2,347,342 2,347,342 Expenditures Operations and maintenance 12,113 42,225 1,243,091 1,243,091 1,200,866 Capital Outlay ‐ ‐ 280,000 280,000 280,000 Debt Service Principle ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ ‐ ‐ ‐ ‐ Administrative Fee 19,251 27,528 110,118 110,118 82,590 Transfer out 224,535 216,060 1,064,246 1,064,246 848,186 Total Expenditures 255,899 285,813 2,697,455 2,697,455 Net change in fund balance (253,188) $ (283,368) $ ---PAGE BREAK--- September 30, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) MBA Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Transfers in 249 $ 249 $ 1,000 $ 1,000 $ (751) $ Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue 249 249 1,000 1,000 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Debt Service Principle ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ ‐ 1,000 1,000 1,000 Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ 1,000 1,000 Net change in fund balance 249 $ 249 $ ---PAGE BREAK--- September 30, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) CDBG Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Intergovernmental (190) $ ‐ $ 116,679 $ 147,380 $ (147,380) $ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue (190) ‐ 116,679 147,380 Expenditures Operations and maintenance 89,061 ‐ 101,178 126,178 126,178 Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ 15,501 21,202 21,202 Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures 89,061 ‐ 116,679 147,380 Net change in fund balance (89,251) $ ‐ $ ---PAGE BREAK--- September 30, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) Cemetery Perpetual Care Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Transfers in 8,469 $ 8,469 $ 33,873 $ 33,873 $ (25,404) $ Miscellaneous (350) 1,600 ‐ ‐ 1,600 Investment income 2,583 1,723 7,000 7,000 (5,277) Total revenue 10,702 11,792 40,873 40,873 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 10,702 $ 11,792 $ ---PAGE BREAK--- September 30, 2013 Statement of Net Position ‐ Proprietary Funds (Unaudited) Water Waste Water Power Murray Parkway Telecom Solid Waste Storm Water Fund Fund Fund Fund Fund Fund Fund Total Assets Current assets: Cash and cash equivalents 6,250,704 $ 2,014,612 $ 13,991,840 $ 767,991 $ 101,348 $ 489,406 $ 820,985 $ 24,436,886 $ Accounts receivable (net) 551,091 246,721 3,050,452 ‐ 3,817 75,046 77,940 4,005,067 Notes receivable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Due from other funds 164,776 ‐ ‐ ‐ ‐ ‐ ‐ 164,776 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,096,727 84,507 ‐ ‐ ‐ 2,181,234 Total current assets 6,966,571 2,372,483 19,139,019 852,498 523,755 564,452 898,925 31,317,703 Noncurrent assets: Restricted cash 335,309 459,262 295 ‐ ‐ ‐ 3,053,028 3,847,894 Investment in joint venture ‐ 3,302,897 ‐ ‐ ‐ ‐ ‐ 3,302,897 Capital Assets: Land 2,155,313 455,921 1,691,650 326,336 ‐ ‐ 2,344,849 6,974,069 Buildings 904,024 949,132 3,410,311 797,534 ‐ ‐ ‐ 6,061,001 Improvements 25,395,326 10,691,325 76,243,203 3,734,149 ‐ ‐ 32,867,440 148,931,443 Machinery and equipment 3,116,240 1,231,707 12,442,960 961,556 ‐ ‐ 1,141,285 18,893,748 Intangibles ‐ ‐ 4,309,027 ‐ ‐ ‐ ‐ 4,309,027 Construction in progress 820,861 1,392,669 ‐ ‐ ‐ ‐ 501,421 2,714,951 Accumulated depreciation (14,676,510) (6,411,873) (58,792,195) (4,710,982) ‐ ‐ (23,082,071) (107,673,631) Total noncurrent assets 18,050,563 12,071,040 39,305,251 1,108,593 ‐ ‐ 16,825,952 87,361,399 Deferred Outflows of Resources Bond defeasance costs ‐ ‐ 131,513 ‐ ‐ ‐ ‐ 131,513 Total deferred outflows of resources ‐ ‐ 131,513 ‐ ‐ ‐ ‐ 131,513 Liabilities Current liabilities: Accrued Liabilities 19,377 126,006 4,366,451 10,262 ‐ 39 ‐ 4,522,135 Due to other funds ‐ ‐ ‐ 164,776 ‐ ‐ ‐ 164,776 Notes payable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Interest payable 25,237 21,523 49,017 ‐ ‐ ‐ 25,420 121,197 Compensated absences 139,994 60,921 368,312 71,739 ‐ 2,038 36,985 679,989 Bonds & leases payable 284,777 272,223 1,545,000 ‐ ‐ ‐ 210,000 2,312,000 Total current liabilities 469,385 480,673 6,328,780 246,777 418,590 2,077 272,405 8,218,687 Noncurrent liabilities: Compensated absences 81,157 35,317 213,516 41,588 ‐ 1,182 21,442 394,202 Net OPEB payable 92,071 ‐ 337,556 ‐ ‐ ‐ ‐ 429,627 Bonds payable 3,150,446 2,811,172 13,040,883 ‐ ‐ ‐ 2,897,326 21,899,827 Total noncurrent liabilities 3,323,674 2,846,489 13,591,955 41,588 ‐ 1,182 2,918,768 22,723,656 Total liabilities 3,793,059 3,327,162 19,920,735 288,365 418,590 3,259 3,191,173 30,942,343 Net Position Beginning net position 19,688,332 10,803,893 36,387,176 1,464,610 105,065 454,154 14,662,743 83,565,973 Change in net position 1,535,743 312,468 2,267,872 208,116 100 107,039 (129,039) 4,302,299 Total net position 21,224,075 $ 11,116,361 $ 38,655,048 $ 1,672,726 $ 105,165 $ 561,193 $ 14,533,704 $ 87,868,272 $ ---PAGE BREAK--- September 30, 2013 YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ Proprietary Funds (Unaudited) Water Waste Water Power Murray Parkway Telecom Solid Waste Storm Water Fund Fund Fund Fund Fund Fund Fund Total Operating revenues: Charges for services 2,598,649 $ 1,007,213 $ 11,075,350 $ 537,298 $ 14,988 $ 338,852 $ 387,838 $ 15,960,188 $ Connection fees 7,108 525 92,980 ‐ ‐ ‐ ‐ 100,613 Miscellaneous 650 375 425,931 (10,923) ‐ ‐ ‐ 416,033 Total operating revenues 2,606,407 1,008,113 11,594,261 526,375 14,988 338,852 387,838 16,476,834 Operating expenses: Wages and benefits 267,492 142,449 1,068,772 186,101 ‐ 11,833 103,867 1,780,514 Administrative fees 145,953 94,956 392,313 189 ‐ 28,437 22,344 684,192 Purchase power ‐ ‐ 5,750,959 ‐ ‐ ‐ ‐ 5,750,959 Operations and maintenance 330,937 353,418 805,433 92,835 14,985 171,903 37,458 1,806,969 Depreciation and amortization 254,135 106,317 724,050 39,885 ‐ ‐ 300,046 1,424,433 Total operating expenses 998,517 697,140 8,741,527 319,010 14,985 212,173 463,715 11,447,067 Operating income (loss) 1,607,890 310,973 2,852,734 207,365 3 126,679 (75,877) 5,029,767 Nonoperating revenues (expenses) Investment earnings 6,971 2,673 57,828 751 97 547 5,191 74,058 Interest and fiscal charges ‐ ‐ ‐ ‐ ‐ ‐ (33,742) (33,742) Impact fees 34,801 76,681 63,180 ‐ ‐ ‐ 3,397 178,059 Total nonoperating revenues (expenses) 41,772 79,354 121,008 751 97 547 (25,154) 218,375 Income (loss) before transfers 1,649,662 390,327 2,973,742 208,116 100 127,226 (101,031) 5,248,142 Transfers out (113,919) (77,859) (705,870) ‐ ‐ (20,187) (28,008) (945,843) Change in net position 1,535,743 $ 312,468 $ 2,267,872 $ 208,116 $ 100 $ 107,039 $ (129,039) $ 4,302,299 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) September 30, 2013 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents (4,155) $ 1,568,362 $ Inventory 72,734 ‐ Total current assets 68,579 1,568,362 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (100,535) ‐ Total noncurrent assets 50,599 ‐ Total assets 119,178 1,568,362 Liabilities Current liabilities: Accrued Liabilities 7,612 258,858 Compensated absences 21,101 4,474 Total current liabilities 28,713 263,332 Noncurrent liabilities: Compensated absences 9,698 2,057 Total noncurrent liabilities 9,698 2,057 Total liabilities 38,411 265,389 Net Assets Beginning net position 69,476 1,371,921 Change in net position 11,291 (68,948) Total net position 80,767 $ 1,302,973 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) September 30, 2013 Central Garage Fund Operating revenues: Charges for services 88,783 $ Miscellaneous ‐ Total operating revenues 88,783 Operating expenses: Wages and benefits 63,285 Administrative fees 189 Operations and maintenance 13,034 Depreciation and amortization 984 Total operating expenses 77,492 Operating income (loss) 11,291 Nonoperating revenues (expenses) Investment earnings ‐ Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) ‐ Income (loss) before transfers 11,291 Change in net position 11,291 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) September 30, 2013 Retained Risk Fund Operating revenues: Charges for services 225,423 $ Miscellaneous ‐ Total operating revenues 225,423 Operating expenses: Wages and benefits 26,240 Administrative fees 126 Operations and maintenance 13,454 Legal Fees 46,044 Insurance 173,791 Claims by department: Fire ‐ Police 342 Parks & Recreation 100 Public Works 20,568 Water 5,000 Storm Water 10,553 Total operating expenses 296,218 Operating income (loss) (70,795) Nonoperating revenues (expenses) Investment earnings 1,847 Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) 1,847 Income (loss) before transfers (68,948) Change in net position (68,948) $