Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) May 31, 2014 General Fund Library Capital Projects RDA CDBG Cemetery Total Assets Cash and cash equivalents 8,082,272 $ 491,840 $ 6,703,154 $ 2,973,671 $ (19,367) $ 1,400,579 $ 19,632,149 $ Investments 3,003,058 ‐ 3,003,058 ‐ ‐ ‐ 6,006,116 Accounts receivable (net) 6,246,489 1,464,738 ‐ 2,339,342 ‐ ‐ 10,050,569 Due from other governments ‐ ‐ ‐ ‐ 19,787 ‐ 19,787 Prepaids 26,616 ‐ ‐ ‐ ‐ ‐ 26,616 Restricted cash 98,151 15,803 200,000 324,477 ‐ ‐ 638,431 Total assets 17,456,586 1,972,381 9,906,212 5,637,490 420 1,400,579 36,373,668 Liabilities Accrued Liabilities 900,288 44 ‐ 1,684 ‐ ‐ 902,016 Total liabilities 900,288 44 ‐ 1,684 ‐ ‐ 902,016 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 395,297 177,349 1,217,119 939,739 420 40,986 2,769,142 Total fund balance 10,396,151 $ 507,599 $ 9,906,212 $ 3,296,464 $ 420 $ 1,400,579 $ 25,507,425 $ ---PAGE BREAK--- May 31, 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 9,707,369 $ 10,123,882 $ 12,682,000 $ 12,823,460 $ (2,699,578) $ Property tax 6,283,889 6,403,085 6,619,202 6,619,202 (216,117) Transfers in 4,235,088 4,262,079 4,647,611 4,649,380 (387,301) Franchise tax 4,395,798 4,263,062 4,825,000 4,825,000 (561,938) Administrative fees 2,773,340 2,720,487 2,983,289 2,988,990 (268,503) Parks and recreation 1,436,010 1,453,031 1,504,500 1,509,858 (56,827) Fines and forfeitures 1,537,786 1,723,832 1,703,000 1,703,000 20,832 Intergovernmental 3,996,415 1,520,318 1,586,017 1,840,050 (319,732) Public safety 940,764 1,001,145 1,002,000 1,038,610 (37,465) Business license 613,780 609,206 645,000 645,000 (35,794) Building permits 523,634 685,580 518,000 518,000 167,580 Miscellaneous 195,012 221,199 187,000 201,680 19,519 Sale of fixed assets 1,273,743 ‐ ‐ ‐ ‐ Investment income 131,800 52,111 75,000 75,000 (22,889) Total revenue 38,044,428 35,039,017 38,977,619 39,437,230 Expenditures Payroll General Government 2,586,812 2,627,368 3,000,243 2,985,923 358,555 Police 6,860,898 7,239,141 8,278,453 8,321,495 1,082,354 Fire 5,013,923 5,172,372 5,953,177 5,961,677 789,305 Public works 1,398,141 1,468,517 1,645,816 1,647,775 179,258 Parks 3,059,951 3,137,900 3,628,515 3,628,515 490,615 ADS 3,224,606 3,307,553 3,796,992 3,805,992 498,439 Operations and maintenance General Government 951,187 1,204,608 1,549,596 1,541,085 336,477 Police 1,789,911 1,950,870 1,963,774 2,275,513 324,643 Fire 749,726 800,092 900,819 962,455 162,363 Public works 752,003 515,122 620,844 825,536 310,414 Class C 3,183,853 981,171 428,000 958,575 (22,596) Parks 1,675,613 1,590,268 1,970,029 1,986,921 396,653 ADS 919,850 1,045,402 1,314,604 1,342,897 297,495 Capital Outlay General Government 3,790 12,919 ‐ 26,000 13,081 Police 20,000 ‐ ‐ ‐ ‐ Fire 32,098 ‐ ‐ ‐ ‐ Public works ‐ 1,400 ‐ ‐ (1,400) Class C 838,187 554,541 879,000 616,799 62,258 Parks ‐ 6,319 ‐ 10,579 4,260 ADS ‐ ‐ ‐ 29,000 29,000 Debt Service Principal 1,505,000 1,266,868 1,255,000 1,268,000 1,132 UTOPIA payments 1,449,166 1,478,149 1,619,333 1,619,333 141,184 Interest and fiscal charge 287,698 252,087 363,551 350,551 98,464 Transfer out 4,661,306 31,053 2,034,873 2,694,873 2,663,820 Total Expenditures 40,963,719 34,643,720 41,202,619 42,859,494 Net change in fund balance (2,919,291) $ 395,297 $ ---PAGE BREAK--- May 31, 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,547,200 $ 1,559,631 $ 1,619,738 $ 1,619,738 $ (60,107) $ Fines and forfeitures 42,264 54,596 45,000 45,000 9,596 Miscellaneous 6,249 6,970 6,500 6,500 470 Intergovernmental 53,423 12,180 12,500 25,822 (13,642) Investment income 6,578 4,812 6,000 6,000 (1,188) Total revenue 1,655,714 1,638,189 1,689,738 1,703,060 Expenditures Payroll 905,385 917,755 1,011,204 1,029,633 111,878 Operations and maintenance 389,064 433,393 503,871 508,247 74,854 Capital Outlay 15,485 ‐ 55,000 45,517 45,517 Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge 11,286 ‐ ‐ ‐ ‐ Administrative Fee 90,563 109,692 119,663 119,663 9,971 Total Expenditures 1,411,783 1,460,840 1,689,738 1,703,060 Net change in fund balance 243,931 $ 177,349 $ ---PAGE BREAK--- May 31, 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 ‐ Sale of fixed assets 18,593 ‐ 8,835 9,758 Miscellaneous 430,177 425,000 436,500 (6,323) Investment income 43,823 ‐ ‐ 43,823 Total revenue 3,017,593 3,350,000 5,830,335 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police 142,176 59,320 164,229 22,053 Fire 79,506 36,420 79,590 84 Public works 304,013 362,313 363,865 59,852 Parks 36,224 43,000 53,500 17,276 ADS 23,779 110,500 135,500 111,721 Capital Outlay General Government ‐ ‐ ‐ ‐ Police 44,000 57,700 57,700 13,700 Fire 200,456 217,282 199,112 (1,344) Public works 97,884 1,636,000 3,453,973 3,356,089 Parks 131,700 139,000 140,000 8,300 ADS 517,652 466,120 1,027,120 509,468 Debt Service Principal 23,084 28,500 28,500 5,416 Interest and fiscal charge ‐ ‐ ‐ ‐ Transfer out 200,000 ‐ 200,000 ‐ Total Expenditures 1,800,474 3,156,155 5,903,089 Net change in fund balance 1,217,119 $ ---PAGE BREAK--- May 31, 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 2,237,283 $ 2,133,581 $ 2,339,342 $ 2,339,342 $ (205,761) $ Bond Proceeds ‐ 1,345,959 ‐ 1,343,000 2,959 Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Transfers in ‐ ‐ ‐ ‐ ‐ Investment income 9,570 10,714 8,000 8,000 2,714 Total revenue 2,246,853 3,490,254 2,347,342 3,690,342 Expenditures Operations and maintenance 501,593 299,350 1,243,091 1,243,091 943,741 Capital Outlay ‐ 1,311,799 280,000 1,841,799 530,000 Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge 3,000 27,946 ‐ 31,201 3,255 Administrative Fee 70,587 100,936 110,118 110,118 9,182 Transfer out 823,295 810,484 1,064,246 1,064,246 253,762 Total Expenditures 1,398,475 2,550,515 2,697,455 4,290,455 Net change in fund balance 848,378 $ 939,739 $ ---PAGE BREAK--- May 31, 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 913 $ ‐ $ 1,000 $ 1,000 $ (1,000) $ Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Investment income 1 ‐ ‐ ‐ ‐ Total revenue 914 ‐ 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 904 $ (1,768) $ ---PAGE BREAK--- May 31, 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 215,019 $ 19,787 $ 116,679 $ 147,380 $ (127,593) $ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue 215,019 19,787 116,679 147,380 Expenditures Operations and maintenance 203,936 19,367 101,178 126,178 106,811 Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee 11,262 ‐ 15,501 21,202 21,202 Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures 215,198 19,367 116,679 147,380 Net change in fund balance (179) $ 420 $ ---PAGE BREAK--- May 31, 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 31,053 $ 31,053 $ 33,873 $ 33,873 $ (2,820) $ Miscellaneous 2,270 3,510 ‐ ‐ 3,510 Investment income 8,096 6,423 7,000 7,000 (577) Total revenue 41,419 40,986 40,873 40,873 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 41,419 $ 40,986 $ ---PAGE BREAK--- May 31, 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 3,784,719 $ 2,209,715 $ 6,994,081 $ 599,885 $ 101,801 $ 521,194 $ 1,072,377 $ 15,283,772 $ Investments 2,002,038 ‐ 4,004,077 ‐ ‐ ‐ ‐ 6,006,115 Accounts receivable (net) 586,141 326,545 2,979,821 ‐ 7,542 104,709 145,851 4,150,609 Notes receivable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Due from other funds 125,095 ‐ ‐ ‐ ‐ ‐ ‐ 125,095 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,116,724 84,507 ‐ ‐ ‐ 2,201,231 Total current assets 6,497,993 2,647,410 16,094,703 684,392 527,933 625,903 1,218,228 28,296,562 Noncurrent assets: Restricted cash 24 354,345 5,189,106 ‐ ‐ ‐ 2,362,222 7,905,697 Investment in joint venture ‐ 3,362,854 ‐ ‐ ‐ ‐ ‐ 3,362,854 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,181,031 1,149,507 13,619,970 935,557 ‐ 54,613 1,134,823 20,075,501 Intangibles ‐ ‐ 3,759,027 ‐ ‐ ‐ ‐ 3,759,027 Construction in progress 1,247,901 1,523,467 12,650 21,839 ‐ ‐ 1,352,517 4,158,374 Accumulated depreciation (15,332,654) (6,612,783) (60,515,584) (4,788,959) ‐ (2,902) (23,860,849) (111,113,731) Total noncurrent assets 17,550,965 11,873,768 43,269,719 1,026,456 ‐ 51,711 16,125,078 89,897,697 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 13,300 72,164 4,392,607 11,148 ‐ ‐ ‐ 4,489,219 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 153,294 133,085 6,305,919 207,982 418,590 2,038 36,985 7,257,893 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,220,363 2,826,179 19,897,874 249,570 418,590 3,220 2,950,387 29,566,183 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 779,230 812,023 2,544,066 (3,332) 1,254 179,330 (338,826) 3,973,745 Total net position 20,828,595 $ 11,694,999 $ 39,598,061 $ 1,461,278 $ 109,343 $ 674,394 $ 14,392,919 $ 88,759,589 $ ---PAGE BREAK--- May 31, 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 4,706,788 $ 3,759,484 $ 31,735,270 $ 1,130,505 $ 67,603 $ 1,246,967 $ 1,485,367 $ 44,131,984 $ Connection fees 11,404 1,475 208,118 ‐ ‐ ‐ ‐ 220,997 Miscellaneous 12,153 750 2,166,600 (15,214) ‐ 16 246,879 2,411,184 Total operating revenues 4,730,345 3,761,709 34,109,988 1,115,291 67,603 1,246,983 1,732,246 46,764,165 Operating expenses: Wages and benefits 1,219,436 555,345 4,560,851 669,978 ‐ 58,406 512,529 7,576,545 Administrative fees 535,161 348,172 1,438,481 693 ‐ 104,269 81,928 2,508,704 Purchase power ‐ ‐ 17,663,903 ‐ ‐ ‐ ‐ 17,663,903 Operations and maintenance 964,030 1,574,994 2,989,426 304,308 66,744 830,112 263,582 6,993,196 Depreciation and amortization 923,072 389,427 2,721,892 143,861 ‐ 2,902 1,098,315 5,279,469 Total operating expenses 3,641,699 2,867,938 29,374,553 1,118,840 66,744 995,689 1,956,354 40,021,817 Operating income (loss) 1,088,646 893,771 4,735,435 (3,549) 859 251,294 (224,108) 6,742,348 Nonoperating revenues (expenses) Investment earnings 31,607 10,555 213,436 2,712 395 2,055 17,499 278,259 Interest and fiscal charges (69,884) (59,683) (250,087) (4,119) ‐ ‐ (49,268) (433,041) Impact fees 137,771 252,863 195,208 ‐ ‐ ‐ 11,334 597,176 Total nonoperating revenues (expenses) 108,287 203,735 178,557 217 395 2,055 (12,022) 481,224 Income (loss) before transfers 1,196,933 1,097,506 4,913,992 (3,332) 1,254 253,349 (236,130) 7,223,572 Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers in ‐ ‐ 218,264 ‐ ‐ ‐ ‐ 218,264 Transfers out (417,703) (285,483) (2,588,190) ‐ ‐ (74,019) (102,696) (3,468,091) Change in net position 779,230 $ 812,023 $ 2,544,066 $ (3,332) $ 1,254 $ 179,330 $ (338,826) $ 3,973,745 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) May 31, 2014 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents 55,130 $ 1,702,565 $ Inventory 86,133 ‐ Total current assets 141,263 1,702,565 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (103,158) ‐ Total noncurrent assets 47,976 ‐ Total assets 189,239 1,702,565 Liabilities Current liabilities: Accrued Liabilities ‐ 250,000 Compensated absences 21,101 4,474 Total current liabilities 21,101 254,474 Noncurrent liabilities: Compensated absences 9,698 2,057 Total noncurrent liabilities 9,698 2,057 Total liabilities 30,799 256,531 Net Assets Beginning net position 69,476 1,371,921 Change in net position 88,964 74,113 Total net position 158,440 $ 1,446,034 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) May 31, 2014 Central Garage Fund Operating revenues: Charges for services 399,837 $ Miscellaneous 713 Total operating revenues 400,550 Operating expenses: Wages and benefits 276,721 Administrative fees 693 Operations and maintenance 30,564 Depreciation and amortization 3,608 Total operating expenses 311,586 Operating income (loss) 88,964 Nonoperating revenues (expenses) Investment earnings ‐ Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) ‐ Income (loss) before transfers 88,964 Change in net position 88,964 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) May 31, 2014 Retained Risk Fund Operating revenues: Charges for services 826,551 $ Miscellaneous ‐ Total operating revenues 826,551 Operating expenses: Wages and benefits 152,254 Administrative fees 462 Operations and maintenance 15,959 Professional Fees 198,739 Insurance 273,606 Claims by department: ADS 942 Police 31,029 Parks & Recreation 1,233 Public Works 22,738 Water 29,037 Power 22,822 Storm Water 10,553 Total operating expenses 759,474 Operating income (loss) 67,077 Nonoperating revenues (expenses) Investment earnings 7,036 Total nonoperating revenues (expenses) 7,036 Income (loss) before transfers 74,113 Change in net position 74,113 $