Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) February 28, 2014 General Fund Library Capital Projects RDA CDBG Cemetery Total Assets Cash and cash equivalents 10,730,822 $ 764,202 $ 10,119,468 $ 2,756,722 $ (19,191) $ 1,389,772 $ 25,741,795 $ Accounts receivable (net) 6,240,759 1,464,738 ‐ 2,339,342 ‐ ‐ 10,044,839 Prepaids 34,030 ‐ ‐ ‐ ‐ ‐ 34,030 Restricted cash 685,679 15,784 200,000 253,005 ‐ ‐ 1,154,468 Total assets 17,691,290 2,244,724 10,319,468 5,349,069 (19,191) 1,389,772 36,975,132 Liabilities Accrued Liabilities 857,165 560 ‐ 1,684 ‐ ‐ 859,409 Total liabilities 857,165 560 ‐ 1,684 ‐ ‐ 859,409 Deferred Inflows of Resources Deferred Inflows‐ property taxes 6,014,202 1,464,738 ‐ 2,339,342 ‐ ‐ 9,818,282 Deferred Inflows‐ ambulance billing 145,945 ‐ ‐ ‐ ‐ ‐ 145,945 Total deferred inflows of resources 6,160,147 1,464,738 ‐ 2,339,342 ‐ ‐ 9,964,227 Fund Balance Nonspendable 55,500 ‐ ‐ ‐ ‐ ‐ 55,500 Restricted 362,764 15,730 638,349 827,056 ‐ 520,000 2,363,899 Beginning fund balance 9,582,590 314,520 8,050,744 1,529,669 ‐ 839,593 20,318,884 Change in fund balance 673,124 449,176 1,630,375 651,318 (19,191) 30,179 3,413,213 Total fund balance 10,673,978 $ 779,426 $ 10,319,468 $ 3,008,043 $ (19,191) $ 1,389,772 $ 26,151,496 $ ---PAGE BREAK--- February 28, 2014 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) General Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Sales tax 6,572,261 $ 6,876,904 $ 12,682,000 $ 12,776,460 $ (5,899,556) $ Property tax 5,718,162 5,811,628 6,619,202 6,619,202 (807,574) Transfers in 3,080,064 3,100,176 4,647,611 4,649,380 (1,549,204) Franchise tax 2,850,077 2,948,316 4,825,000 4,825,000 (1,876,684) Administrative fees 2,016,606 1,978,536 2,983,289 2,988,990 (1,010,454) Parks and recreation 1,022,154 1,050,883 1,504,500 1,504,500 (453,617) Fines and forfeitures 1,047,714 1,172,551 1,703,000 1,703,000 (530,449) Intergovernmental 3,147,709 1,007,608 1,586,017 1,840,050 (832,442) Public safety 652,942 679,769 1,002,000 1,008,455 (328,686) Business license 455,079 451,217 645,000 645,000 (193,783) Building permits 346,540 506,644 518,000 518,000 (11,356) Miscellaneous 137,157 149,667 187,000 194,500 (44,833) Sale of fixed assets 1,290,825 ‐ ‐ ‐ ‐ Investment income 98,409 35,162 75,000 75,000 (39,838) Total revenue 28,435,699 25,769,061 38,977,619 39,347,537 Expenditures Payroll General Government 1,838,322 1,836,129 3,000,243 3,000,243 1,164,114 Police 4,859,374 5,041,961 8,278,453 8,321,495 3,279,534 Fire 3,552,619 3,660,552 5,953,177 5,961,677 2,301,125 Public works 1,046,012 1,091,998 1,645,816 1,645,816 553,818 Parks 2,178,311 2,237,688 3,628,515 3,628,515 1,390,827 ADS 2,271,038 2,332,952 3,796,992 3,805,992 1,473,040 Operations and maintenance General Government 758,424 892,144 1,549,596 1,552,765 660,621 Police 1,466,741 1,620,121 1,963,774 2,245,358 625,237 Fire 581,531 637,137 900,819 955,275 318,138 Public works 543,664 353,726 620,844 827,495 473,769 Class C 2,944,825 952,321 428,000 958,575 6,254 Parks 1,253,293 1,180,273 1,970,029 1,986,921 806,648 ADS 721,847 795,569 1,314,604 1,324,897 529,328 Capital Outlay Police 20,000 ‐ ‐ ‐ ‐ Class C 794,089 526,013 879,000 616,799 90,786 Parks ‐ 7,719 ‐ 5,221 (2,498) Debt Service Principal 875,000 651,868 1,255,000 1,268,000 616,132 UTOPIA payments 1,053,939 1,075,017 1,619,333 1,619,333 544,316 Interest and fiscal charge 206,576 180,165 363,551 350,551 170,386 Transfer out 4,652,588 22,584 2,034,873 2,694,873 2,672,289 Total Expenditures 31,650,291 25,095,937 41,202,619 42,769,801 Net change in fund balance (3,214,592) $ 673,124 $ ---PAGE BREAK--- February 28, 2014 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 1,390,996 $ 1,415,343 $ 1,619,738 $ 1,619,738 $ (204,395) $ Fines and forfeitures 28,713 38,466 45,000 45,000 (6,534) Miscellaneous 4,305 4,774 6,500 6,500 (1,726) Intergovernmental 39,411 13,322 12,500 25,822 (12,500) Investment income 4,687 2,780 6,000 6,000 (3,220) Total revenue 1,468,112 1,474,685 1,689,738 1,703,060 Expenditures Payroll 651,584 640,368 1,011,204 1,029,546 389,178 Operations and maintenance 291,578 305,365 503,871 501,334 195,969 Capital Outlay 15,485 ‐ 55,000 52,517 52,517 Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ ‐ ‐ ‐ ‐ Administrative Fee 65,864 79,776 119,663 119,663 39,887 Total Expenditures 1,024,511 1,025,509 1,689,738 1,703,060 Net change in fund balance 443,601 $ 449,176 $ ---PAGE BREAK--- February 28, 2014 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 ‐ Miscellaneous 417,177 425,000 426,500 (9,323) Investment income 31,951 ‐ ‐ 31,951 Total revenue 2,983,821 3,350,000 5,811,500 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police 140,201 59,320 164,229 24,028 Fire 72,195 36,420 75,210 3,015 Public works 282,515 362,313 363,865 81,350 Parks 36,129 43,000 43,500 7,371 ADS 5,406 110,500 115,500 110,094 Capital Outlay General Government ‐ ‐ ‐ ‐ Police 44,000 57,700 57,700 13,700 Fire 129,441 217,282 178,492 49,051 Public works 46,383 1,636,000 3,434,448 3,388,065 Parks 131,700 139,000 140,000 8,300 ADS 445,924 466,120 702,120 256,196 Debt Service Principal 19,552 28,500 28,500 8,948 Interest and fiscal charge ‐ ‐ ‐ ‐ Transfer out ‐ ‐ 200,000 200,000 Total Expenditures 1,353,446 3,156,155 5,503,564 Net change in fund balance 1,630,375 $ ---PAGE BREAK--- February 28, 2014 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 1,369,025 $ 1,545,771 $ 2,339,342 $ 2,339,342 $ (793,571) $ Bond Proceeds ‐ 1,343,421 ‐ ‐ 1,343,421 Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Transfers in ‐ ‐ ‐ ‐ ‐ Investment income 6,424 6,572 8,000 8,000 (1,428) Total revenue 1,375,449 2,895,764 2,347,342 2,347,342 Expenditures Operations and maintenance 40,039 256,883 1,243,091 1,243,091 986,208 Capital Outlay ‐ 1,311,799 280,000 530,000 (781,799) Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ 26,196 ‐ ‐ (26,196) Administrative Fee 51,336 73,408 110,118 110,118 36,710 Transfer out 598,760 576,160 1,064,246 1,064,246 488,086 Total Expenditures 690,135 2,244,446 2,697,455 2,947,455 Net change in fund balance 685,314 $ 651,318 $ ---PAGE BREAK--- February 28, 2014 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 664 $ ‐ $ 1,000 $ 1,000 $ (1,000) $ Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Investment income 1 ‐ ‐ ‐ ‐ Total revenue 665 ‐ 1,000 1,000 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge 10 ‐ 1,000 1,000 1,000 Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ 1,768 ‐ 1,769 1 Total Expenditures 10 1,768 1,000 2,769 Net change in fund balance 655 $ (1,768) $ ---PAGE BREAK--- February 28, 2014 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) CDBG Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Intergovernmental 185,828 $ ‐ $ 116,679 $ 147,380 $ (147,380) $ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue 185,828 ‐ 116,679 147,380 Expenditures Operations and maintenance 178,025 19,191 101,178 126,178 106,987 Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee 7,822 ‐ 15,501 21,202 21,202 Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures 185,847 19,191 116,679 147,380 Net change in fund balance (19) $ (19,191) $ ---PAGE BREAK--- February 28, 2014 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 22,584 $ 22,584 $ 33,873 $ 33,873 $ (11,289) $ Miscellaneous 70 2,950 ‐ ‐ 2,950 Investment income 6,282 4,645 7,000 7,000 (2,355) Total revenue 28,936 30,179 40,873 40,873 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 28,936 $ 30,179 $ ---PAGE BREAK--- February 28, 2014 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,214,313 $ 2,089,480 $ 15,635,368 $ 540,571 $ 101,526 $ 487,875 $ 1,350,904 $ 26,420,037 $ Accounts receivable (net) 509,261 334,342 3,019,289 ‐ 7,301 110,903 145,926 4,127,022 Notes receivable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Due from other funds 125,095 ‐ ‐ ‐ ‐ ‐ ‐ 125,095 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,097,196 84,507 ‐ ‐ ‐ 2,181,703 Total current assets 6,848,669 2,534,972 20,751,853 625,078 527,417 598,778 1,496,830 33,383,597 Noncurrent assets: Restricted cash 39,860 377,723 63 ‐ ‐ ‐ 2,359,322 2,776,968 Investment in joint venture ‐ 3,358,136 ‐ ‐ ‐ ‐ ‐ 3,358,136 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,102,589 3,734,149 ‐ ‐ 32,791,516 148,714,905 Machinery and equipment 3,166,538 1,149,507 13,461,782 935,557 ‐ 54,613 1,131,251 19,899,248 Intangibles ‐ ‐ 3,759,027 ‐ ‐ ‐ ‐ 3,759,027 Construction in progress 1,008,729 1,522,316 12,650 ‐ ‐ ‐ 969,128 3,512,823 Accumulated depreciation (15,085,798) (6,506,659) (59,741,420) (4,751,694) ‐ (1,537) (23,570,989) (109,658,097) Total noncurrent assets 17,583,992 11,997,401 38,696,652 1,041,882 ‐ 53,076 16,025,077 85,398,080 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 10,028 93,553 4,343,650 2,264 ‐ ‐ 145 4,449,640 Due to other funds ‐ ‐ ‐ 125,095 ‐ ‐ ‐ 125,095 Notes payable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Compensated absences 139,994 60,921 368,312 71,739 ‐ 2,038 36,985 679,989 Bonds & leases payable ‐ ‐ 1,545,000 ‐ ‐ ‐ ‐ 1,545,000 Total current liabilities 150,022 154,474 6,256,962 199,098 418,590 2,038 37,130 7,218,314 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 2,893,841 2,657,777 13,040,883 ‐ ‐ ‐ 2,891,960 21,484,461 Total noncurrent liabilities 3,067,069 2,693,094 13,591,955 41,588 ‐ 1,182 2,913,402 22,308,290 Total liabilities 3,217,091 2,847,568 19,848,917 240,686 418,590 3,220 2,950,532 29,526,604 Net Position Beginning net position 20,049,365 10,882,976 37,053,995 1,464,610 108,089 495,064 14,731,745 84,785,844 Change in net position 1,166,205 801,829 2,677,106 (38,336) 738 153,570 (160,370) 4,600,742 Total net position 21,215,570 $ 11,684,805 $ 39,731,101 $ 1,426,274 $ 108,827 $ 648,634 $ 14,571,375 $ 89,386,586 $ ---PAGE BREAK--- February 28, 2014 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 3,979,507 $ 2,723,434 $ 24,278,049 $ 747,213 $ 46,210 $ 903,622 $ 1,084,489 $ 33,762,524 $ Connection fees 9,637 875 193,158 ‐ ‐ ‐ ‐ 203,670 Miscellaneous 11,145 750 1,258,405 (12,763) ‐ ‐ 245,254 1,502,791 Total operating revenues 4,000,289 2,725,059 25,729,612 734,450 46,210 903,622 1,329,743 35,468,985 Operating expenses: Wages and benefits 829,738 398,737 3,217,787 471,715 ‐ 40,621 331,271 5,289,869 Administrative fees 389,208 253,216 1,046,168 504 ‐ 75,832 59,584 1,824,512 Purchase power ‐ ‐ 13,067,855 ‐ ‐ ‐ ‐ 13,067,855 Operations and maintenance 742,111 988,337 1,992,911 193,478 45,756 579,685 201,020 4,743,298 Depreciation and amortization 676,215 283,302 1,966,866 106,596 ‐ 1,537 798,999 3,833,515 Total operating expenses 2,637,272 1,923,592 21,291,587 772,293 45,756 697,675 1,390,874 28,759,049 Operating income (loss) 1,363,017 801,467 4,438,025 (37,843) 454 205,947 (61,131) 6,709,936 Nonoperating revenues (expenses) Investment earnings 24,462 7,451 164,700 2,002 284 1,455 13,079 213,433 Interest and fiscal charges (29,253) (35,864) (250,087) (4,119) ‐ ‐ (48,018) (367,341) Impact fees 102,970 236,399 186,788 ‐ ‐ ‐ 9,904 536,061 Total nonoperating revenues (expenses) 106,972 207,986 121,401 (493) 284 1,455 (24,551) 413,054 Income (loss) before transfers 1,469,989 1,009,453 4,559,426 (38,336) 738 207,402 (85,682) 7,122,990 Transfers out (303,784) (207,624) (1,882,320) ‐ ‐ (53,832) (74,688) (2,522,248) Change in net position 1,166,205 $ 801,829 $ 2,677,106 $ (38,336) $ 738 $ 153,570 $ (160,370) $ 4,600,742 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) February 28, 2014 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents 47,163 $ 1,603,742 $ Inventory 96,923 ‐ Total current assets 144,086 1,603,742 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (102,174) ‐ Total noncurrent assets 48,960 ‐ Total assets 193,046 1,603,742 Liabilities Current liabilities: Accrued Liabilities 575 250,000 Compensated absences 21,101 4,474 Total current liabilities 21,676 254,474 Noncurrent liabilities: Compensated absences 9,698 2,057 Total noncurrent liabilities 9,698 2,057 Total liabilities 31,374 256,531 Net Assets Beginning net position 69,476 1,371,921 Change in net position 92,196 (24,710) Total net position 161,672 $ 1,347,211 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) February 28, 2014 Central Garage Fund Operating revenues: Charges for services 312,619 $ Miscellaneous 457 Total operating revenues 313,076 Operating expenses: Wages and benefits 194,833 Administrative fees 504 Operations and maintenance 22,919 Depreciation and amortization 2,624 Total operating expenses 220,880 Operating income (loss) 92,196 Nonoperating revenues (expenses) Investment earnings ‐ Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) ‐ Income (loss) before transfers 92,196 Change in net position 92,196 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) February 28, 2014 Retained Risk Fund Operating revenues: Charges for services 601,128 $ Miscellaneous ‐ Total operating revenues 601,128 Operating expenses: Wages and benefits 96,720 Administrative fees 336 Operations and maintenance 14,934 Legal Fees 159,725 Insurance 270,063 Claims by department: ADS 942 Police 23,100 Parks & Recreation 1,233 Public Works 22,738 Water 28,222 Power 2,313 Storm Water 10,553 Total operating expenses 630,879 Operating income (loss) (29,751) Nonoperating revenues (expenses) Investment earnings 5,041 Total nonoperating revenues (expenses) 5,041 Income (loss) before transfers (24,710) Change in net position (24,710) $