Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) April 30, 2014 General Fund Library Capital Projects RDA CDBG Cemetery Total Assets Cash and cash equivalents 8,091,267 $ 648,961 $ 6,988,012 $ 3,108,301 $ (19,367) $ 1,396,914 $ 20,214,088 $ Investments 3,001,519 ‐ 3,001,519 ‐ ‐ ‐ 6,003,038 Accounts receivable (net) 6,250,770 1,464,738 ‐ 2,339,342 ‐ ‐ 10,054,850 Prepaids 8,265 ‐ ‐ ‐ ‐ ‐ 8,265 Restricted cash 98,150 15,797 200,000 300,691 ‐ ‐ 614,638 Total assets 17,449,971 2,129,496 10,189,531 5,748,334 (19,367) 1,396,914 36,894,879 Liabilities Accrued Liabilities 832,460 14,664 65,308 1,684 ‐ ‐ 914,116 Total liabilities 832,460 14,664 65,308 1,684 ‐ ‐ 914,116 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 456,510 319,844 1,435,130 1,050,583 (19,367) 37,321 3,278,253 Total fund balance 10,457,364 $ 650,094 $ 10,124,223 $ 3,407,308 $ (19,367) $ 1,396,914 $ 26,016,536 $ ---PAGE BREAK--- April 30, 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 8,471,661 $ 8,848,314 $ 12,682,000 $ 12,823,460 $ (3,975,146) $ Property tax 6,118,756 6,228,398 6,619,202 6,619,202 (390,804) Transfers in 3,850,080 3,874,778 4,647,611 4,649,380 (774,602) Franchise tax 3,927,042 3,793,500 4,825,000 4,825,000 (1,031,500) Administrative fees 2,522,242 2,473,170 2,983,289 2,988,990 (515,820) Parks and recreation 1,294,703 1,299,942 1,504,500 1,509,858 (209,916) Fines and forfeitures 1,377,843 1,557,989 1,703,000 1,703,000 (145,011) Intergovernmental 3,565,753 1,224,066 1,586,017 1,840,050 (615,984) Public safety 827,395 860,764 1,002,000 1,038,610 (177,846) Business license 557,485 553,217 645,000 645,000 (91,783) Building permits 455,906 595,521 518,000 518,000 77,521 Miscellaneous 166,587 195,492 187,000 201,680 (6,188) Sale of fixed assets 1,298,553 ‐ ‐ ‐ ‐ Investment income 126,947 46,969 75,000 75,000 (28,031) Total revenue 34,560,953 31,552,120 38,977,619 39,437,230 Expenditures Payroll General Government 2,253,082 2,290,721 3,000,243 2,985,923 695,202 Police 5,983,199 6,339,179 8,278,453 8,321,495 1,982,316 Fire 4,386,663 4,514,473 5,953,177 5,961,677 1,447,204 Public works 1,244,181 1,304,536 1,645,816 1,647,775 343,239 Parks 2,665,608 2,739,147 3,628,515 3,628,515 889,368 ADS 2,818,490 2,892,983 3,796,992 3,805,992 913,009 Operations and maintenance General Government 900,842 1,145,501 1,549,596 1,541,085 395,584 Police 1,691,246 1,830,085 1,963,774 2,275,513 445,428 Fire 682,633 748,452 900,819 962,455 214,003 Public works 698,619 449,530 620,844 825,536 376,006 Class C 3,068,122 981,171 428,000 958,575 (22,596) Parks 1,520,983 1,443,868 1,970,029 1,986,921 543,053 ADS 850,687 970,815 1,314,604 1,342,897 372,082 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 825,650 533,554 879,000 616,799 83,245 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,317,423 1,343,772 1,619,333 1,619,333 275,561 Interest and fiscal charge 287,698 252,087 363,551 350,551 98,464 Transfer out 4,658,400 28,230 2,034,873 2,694,873 2,666,643 Total Expenditures 37,414,414 31,095,610 41,202,619 42,859,494 Net change in fund balance (2,853,461) $ 456,510 $ ---PAGE BREAK--- April 30, 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,507,030 $ 1,517,088 $ 1,619,738 $ 1,619,738 $ (102,650) $ Fines and forfeitures 37,445 50,020 45,000 45,000 5,020 Miscellaneous 5,611 6,333 6,500 6,500 (167) Intergovernmental 51,195 25,502 12,500 25,822 (320) Investment income 6,327 4,465 6,000 6,000 (1,535) Total revenue 1,607,608 1,603,408 1,689,738 1,703,060 Expenditures Payroll 795,954 798,247 1,011,204 1,029,633 231,386 Operations and maintenance 359,196 385,597 503,871 508,247 122,650 Capital Outlay 15,485 ‐ 55,000 45,517 45,517 Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge 11,286 ‐ ‐ ‐ ‐ Administrative Fee 82,330 99,720 119,663 119,663 19,943 Total Expenditures 1,264,251 1,283,564 1,689,738 1,703,060 Net change in fund balance 343,357 $ 319,844 $ ---PAGE BREAK--- April 30, 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 430,177 425,000 436,500 (6,323) Investment income 39,381 ‐ ‐ 39,381 Total revenue 3,013,151 3,350,000 5,830,335 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police 140,201 59,320 164,229 24,028 Fire 79,506 36,420 79,590 84 Public works 283,555 362,313 363,865 80,310 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,199 1,636,000 3,453,973 3,356,774 Parks 131,700 139,000 140,000 8,300 ADS 517,652 466,120 1,027,120 509,468 Debt Service Principal 23,749 28,500 28,500 4,751 Interest and fiscal charge ‐ ‐ ‐ ‐ Transfer out ‐ ‐ 200,000 200,000 Total Expenditures 1,578,021 3,156,155 5,903,089 Net change in fund balance 1,435,130 $ ---PAGE BREAK--- April 30, 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 8,434 9,426 8,000 8,000 1,426 Total revenue 2,245,717 3,488,966 2,347,342 3,690,342 Expenditures Operations and maintenance 96,312 286,678 1,243,091 1,243,091 956,413 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 64,170 91,760 110,118 110,118 18,358 Transfer out 748,450 720,200 1,064,246 1,064,246 344,046 Total Expenditures 911,932 2,438,383 2,697,455 4,290,455 Net change in fund balance 1,333,785 $ 1,050,583 $ ---PAGE BREAK--- April 30, 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 830 $ ‐ $ 1,000 $ 1,000 $ (1,000) $ Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Investment income 1 ‐ ‐ ‐ ‐ Total revenue 831 ‐ 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 821 $ (1,768) $ ---PAGE BREAK--- April 30, 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 189,287 $ ‐ $ 116,679 $ 147,380 $ (147,380) $ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue 189,287 ‐ 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 (25,911) $ (19,367) $ ---PAGE BREAK--- April 30, 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 28,230 $ 28,230 $ 33,873 $ 33,873 $ (5,643) $ Miscellaneous (80) 3,260 ‐ ‐ 3,260 Investment income 7,520 5,831 7,000 7,000 (1,169) Total revenue 35,670 37,321 40,873 40,873 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 35,670 $ 37,321 $ ---PAGE BREAK--- April 30, 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,961,165 $ 2,111,328 $ 12,636,319 $ 598,155 $ 101,880 $ 512,800 $ 1,406,172 $ 21,327,819 $ Investments 2,001,013 ‐ 4,002,026 ‐ ‐ ‐ ‐ 6,003,039 Accounts receivable (net) 502,135 316,455 2,727,357 ‐ 7,276 107,361 146,393 3,806,977 Notes receivable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Due from other funds 125,095 ‐ ‐ ‐ ‐ ‐ ‐ 125,095 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,092,810 84,507 ‐ ‐ ‐ 2,177,317 Total current assets 6,589,408 2,538,933 21,458,512 682,662 527,746 620,161 1,552,565 33,969,987 Noncurrent assets: Restricted cash 23 354,199 ‐ ‐ ‐ ‐ 2,361,253 2,715,475 Investment in joint venture ‐ 3,359,935 ‐ ‐ ‐ ‐ ‐ 3,359,935 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,131,251 20,071,929 Intangibles ‐ ‐ 3,759,027 ‐ ‐ ‐ ‐ 3,759,027 Construction in progress 1,168,301 1,522,909 12,650 10,000 ‐ ‐ 1,334,820 4,048,680 Accumulated depreciation (15,250,329) (6,577,408) (60,257,074) (4,776,609) ‐ (2,447) (23,770,739) (110,634,606) Total noncurrent assets 17,553,689 11,905,520 38,339,123 1,026,967 ‐ 52,166 16,192,950 85,070,415 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 55,479 87,330 4,506,629 23,412 ‐ 40 308,336 4,981,226 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 195,473 148,251 6,419,941 220,246 418,590 2,078 345,321 7,749,900 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,262,542 2,841,345 20,011,896 261,834 418,590 3,260 3,258,723 30,058,190 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 831,190 720,132 2,863,257 (16,815) 1,067 174,003 (244,953) 4,327,881 Total net position 20,880,555 $ 11,603,108 $ 39,917,252 $ 1,447,795 $ 109,156 $ 669,067 $ 14,486,792 $ 89,113,725 $ ---PAGE BREAK--- April 30, 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,377,778 $ 3,409,202 $ 29,108,056 $ 966,307 $ 60,285 $ 1,135,313 $ 1,374,292 $ 40,431,233 $ Connection fees 10,944 975 202,613 ‐ ‐ ‐ ‐ 214,532 Miscellaneous 12,023 750 2,010,915 (13,394) ‐ ‐ 245,389 2,255,683 Total operating revenues 4,400,745 3,410,927 31,321,584 952,913 60,285 1,135,313 1,619,681 42,901,448 Operating expenses: Wages and benefits 1,056,214 488,964 3,978,804 575,424 ‐ 51,588 435,385 6,586,379 Administrative fees 486,510 316,520 1,307,710 630 ‐ 94,790 74,480 2,280,640 Purchase power ‐ ‐ 15,811,598 ‐ ‐ ‐ ‐ 15,811,598 Operations and maintenance 885,215 1,460,717 2,695,763 262,128 59,570 747,040 240,065 6,350,498 Depreciation and amortization 840,746 354,052 2,469,762 131,511 ‐ 2,447 998,749 4,797,267 Total operating expenses 3,268,685 2,620,253 26,263,637 969,693 59,570 895,865 1,748,679 35,826,382 Operating income (loss) 1,132,060 790,674 5,057,947 (16,780) 715 239,448 (128,998) 7,075,066 Nonoperating revenues (expenses) Investment earnings 28,950 9,528 199,638 2,460 352 1,845 16,102 258,875 Interest and fiscal charges (69,884) (59,683) (250,087) (4,119) ‐ ‐ (49,268) (433,041) Impact fees 111,001 239,143 188,659 ‐ ‐ ‐ 10,087 548,890 Total nonoperating revenues (expenses) 78,860 188,988 158,210 (35) 352 1,845 (22,595) 405,625 Income (loss) before transfers 1,210,920 979,662 5,216,157 (16,815) 1,067 241,293 (151,593) 7,480,691 Transfers out (379,730) (259,530) (2,352,900) ‐ ‐ (67,290) (93,360) (3,152,810) Change in net position 831,190 $ 720,132 $ 2,863,257 $ (16,815) $ 1,067 $ 174,003 $ (244,953) $ 4,327,881 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) April 30, 2014 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents 115,545 $ 1,676,433 $ Inventory 92,308 ‐ Total current assets 207,853 1,676,433 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (102,830) ‐ Total noncurrent assets 48,304 ‐ Total assets 256,157 1,676,433 Liabilities Current liabilities: Accrued Liabilities 59,677 254,746 Compensated absences 21,101 4,474 Total current liabilities 80,778 259,220 Noncurrent liabilities: Compensated absences 9,698 2,057 Total noncurrent liabilities 9,698 2,057 Total liabilities 90,476 261,277 Net Assets Beginning net position 69,476 1,371,921 Change in net position 96,205 43,235 Total net position 165,681 $ 1,415,156 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) April 30, 2014 Central Garage Fund Operating revenues: Charges for services 370,876 $ Miscellaneous 714 Total operating revenues 371,590 Operating expenses: Wages and benefits 241,477 Administrative fees 630 Operations and maintenance 29,998 Depreciation and amortization 3,280 Total operating expenses 275,385 Operating income (loss) 96,205 Nonoperating revenues (expenses) Investment earnings ‐ Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) ‐ Income (loss) before transfers 96,205 Change in net position 96,205 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) April 30, 2014 Retained Risk Fund Operating revenues: Charges for services 751,410 $ Miscellaneous ‐ Total operating revenues 751,410 Operating expenses: Wages and benefits 128,446 Administrative fees 420 Operations and maintenance 15,541 Professional Fees 184,953 Insurance 273,606 Claims by department: ADS 942 Police 30,067 Parks & Recreation 1,233 Public Works 22,738 Water 28,222 Power 17,804 Storm Water 10,553 Total operating expenses 714,525 Operating income (loss) 36,885 Nonoperating revenues (expenses) Investment earnings 6,350 Total nonoperating revenues (expenses) 6,350 Income (loss) before transfers 43,235 Change in net position 43,235 $