Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) March 31, 2014 General Fund Library Capital Projects RDA CDBG Cemetery Total Assets Cash and cash equivalents 8,403,429 $ 687,763 $ 7,075,401 $ 3,244,919 $ (19,191) $ 1,392,864 $ 20,785,185 $ Investments 3,000,353 ‐ 3,000,353 ‐ ‐ ‐ 6,000,706 Accounts receivable (net) 6,283,809 1,464,738 ‐ 2,339,342 ‐ ‐ 10,087,889 Prepaids 21,752 ‐ ‐ ‐ ‐ ‐ 21,752 Restricted cash 685,784 15,790 200,000 253,133 ‐ ‐ 1,154,707 Total assets 18,395,127 2,168,291 10,275,754 5,837,394 (19,191) 1,392,864 38,050,239 Liabilities Accrued Liabilities 1,181,191 51 ‐ 1,684 ‐ ‐ 1,182,926 Total liabilities 1,181,191 51 ‐ 1,684 ‐ ‐ 1,182,926 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 1,052,935 373,252 1,586,661 1,139,643 (19,191) 33,271 4,164,803 Total fund balance 11,053,789 $ 703,502 $ 10,275,754 $ 3,496,368 $ (19,191) $ 1,392,864 $ 26,903,086 $ ---PAGE BREAK--- March 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 7,543,549 $ 7,874,380 $ 12,682,000 $ 12,823,460 $ (4,949,080) $ Property tax 5,812,936 5,944,446 6,619,202 6,619,202 (674,756) Transfers in 3,465,072 3,487,477 4,647,611 4,649,380 (1,161,903) Franchise tax 3,504,186 3,397,747 4,825,000 4,825,000 (1,427,253) Administrative fees 2,267,704 2,225,853 2,983,289 2,988,990 (763,137) Parks and recreation 1,179,090 1,194,847 1,504,500 1,509,858 (315,011) Fines and forfeitures 1,221,970 1,374,773 1,703,000 1,703,000 (328,227) Intergovernmental 3,511,724 1,193,789 1,586,017 1,840,050 (646,261) Public safety 771,440 807,207 1,002,000 1,008,455 (201,248) Business license 512,006 501,553 645,000 645,000 (143,447) Building permits 398,634 552,646 518,000 518,000 34,646 Miscellaneous 152,856 171,256 187,000 194,500 (23,244) Sale of fixed assets 1,290,825 ‐ ‐ ‐ ‐ Investment income 116,914 41,313 75,000 75,000 (33,687) Total revenue 31,748,906 28,767,287 38,977,619 39,399,895 Expenditures Payroll General Government 2,052,419 2,067,207 3,000,243 2,985,923 918,716 Police 5,428,944 5,739,906 8,278,453 8,321,495 2,581,589 Fire 3,973,167 4,085,284 5,953,177 5,961,677 1,876,393 Public works 1,145,226 1,198,173 1,645,816 1,647,775 449,602 Parks 2,420,283 2,487,646 3,628,515 3,628,515 1,140,869 ADS 2,543,879 2,611,618 3,796,992 3,805,992 1,194,374 Operations and maintenance General Government 821,045 961,970 1,549,596 1,541,085 579,115 Police 1,563,297 1,705,857 1,963,774 2,245,358 539,501 Fire 633,445 699,770 900,819 955,275 255,505 Public works 600,412 395,581 620,844 825,536 429,955 Class C 3,067,323 980,173 428,000 958,575 (21,598) Parks 1,372,764 1,292,604 1,970,029 1,986,921 694,317 ADS 790,857 867,536 1,314,604 1,342,897 475,361 Capital Outlay Police 20,000 ‐ ‐ ‐ ‐ Class C 825,650 533,554 879,000 616,799 83,245 Parks ‐ 6,319 ‐ 10,579 4,260 Debt Service Principal 875,000 651,868 1,255,000 1,268,000 616,132 UTOPIA payments 1,185,681 1,209,395 1,619,333 1,619,333 409,938 Interest and fiscal charge 206,576 180,165 363,551 350,551 170,386 Transfer out 4,655,494 25,407 2,034,873 2,694,873 2,669,466 Total Expenditures 34,213,560 27,714,352 41,202,619 42,822,159 Net change in fund balance (2,464,654) $ 1,052,935 $ ---PAGE BREAK--- March 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,430,008 $ 1,447,937 $ 1,619,738 $ 1,619,738 $ (171,801) $ Fines and forfeitures 33,158 44,209 45,000 45,000 (791) Miscellaneous 4,992 5,514 6,500 6,500 (986) Intergovernmental 51,195 25,502 12,500 25,822 (320) Investment income 5,715 3,869 6,000 6,000 (2,131) Total revenue 1,525,068 1,527,031 1,689,738 1,703,060 Expenditures Payroll 724,289 718,670 1,011,204 1,029,633 310,963 Operations and maintenance 318,332 345,361 503,871 501,247 155,886 Capital Outlay 15,485 ‐ 55,000 52,517 52,517 Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge 11,286 ‐ ‐ ‐ ‐ Administrative Fee 74,097 89,748 119,663 119,663 29,915 Total Expenditures 1,143,489 1,153,779 1,689,738 1,703,060 Net change in fund balance 381,579 $ 373,252 $ ---PAGE BREAK--- March 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 ‐ Miscellaneous 420,177 425,000 436,500 (16,323) Investment income 35,410 ‐ ‐ 35,410 Total revenue 2,999,180 3,350,000 5,821,500 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police 140,201 59,320 164,229 24,028 Fire 79,506 36,420 79,590 84 Public works 282,442 362,313 363,865 81,423 Parks 36,224 43,000 53,500 17,276 ADS 5,406 110,500 135,500 130,094 Capital Outlay General Government ‐ ‐ ‐ ‐ Police 44,000 57,700 57,700 13,700 Fire 129,441 217,282 174,112 44,671 Public works 53,133 1,636,000 3,453,973 3,400,840 Parks 131,700 139,000 140,000 8,300 ADS 488,816 466,120 1,027,120 538,304 Debt Service Principal 21,650 28,500 28,500 6,850 Interest and fiscal charge ‐ ‐ ‐ ‐ Transfer out ‐ ‐ 200,000 200,000 Total Expenditures 1,412,519 3,156,155 5,878,089 Net change in fund balance 1,586,661 $ ---PAGE BREAK--- March 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,344,690 ‐ 1,343,000 1,690 Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Transfers in ‐ ‐ ‐ ‐ ‐ Investment income 7,245 8,150 8,000 8,000 150 Total revenue 2,244,528 3,486,421 2,347,342 3,690,342 Expenditures Operations and maintenance 45,288 278,019 1,243,091 1,243,091 965,072 Capital Outlay ‐ 1,311,799 280,000 1,841,799 530,000 Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ 26,196 ‐ 31,201 5,005 Administrative Fee 57,753 82,584 110,118 110,118 27,534 Transfer out 673,605 648,180 1,064,246 1,064,246 416,066 Total Expenditures 776,646 2,346,778 2,697,455 4,290,455 Net change in fund balance 1,467,882 $ 1,139,643 $ ---PAGE BREAK--- March 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 747 $ ‐ $ 1,000 $ 1,000 $ (1,000) $ Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Investment income 1 ‐ ‐ ‐ ‐ Total revenue 748 ‐ 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 738 $ (1,768) $ ---PAGE BREAK--- March 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 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--- March 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 25,407 $ 25,407 $ 33,873 $ 33,873 $ (8,466) $ Miscellaneous 170 2,600 ‐ ‐ 2,600 Investment income 6,928 5,264 7,000 7,000 (1,736) Total revenue 32,505 33,271 40,873 40,873 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 32,505 $ 33,271 $ ---PAGE BREAK--- March 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 4,165,495 $ 2,244,551 $ 12,427,678 $ 548,814 $ 101,777 $ 501,068 $ 1,380,040 $ 21,369,423 $ Investments 2,000,235 ‐ 4,000,470 ‐ ‐ ‐ ‐ 6,000,705 Accounts receivable (net) 482,063 295,052 2,488,864 ‐ 7,282 104,503 134,103 3,511,867 Notes receivable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Due from other funds 125,095 ‐ ‐ ‐ ‐ ‐ ‐ 125,095 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,096,843 84,507 ‐ ‐ ‐ 2,181,350 Total current assets 6,772,888 2,650,753 21,013,855 633,321 527,649 605,571 1,514,143 33,718,180 Noncurrent assets: Restricted cash 39,854 377,857 63 ‐ ‐ ‐ 2,360,246 2,778,020 Investment in joint venture ‐ 3,356,674 ‐ ‐ ‐ ‐ ‐ 3,356,674 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,031,519 1,522,593 12,650 ‐ ‐ ‐ 973,597 3,540,359 Accumulated depreciation (15,168,003) (6,542,034) (59,998,565) (4,764,259) ‐ (1,992) (23,670,864) (110,145,717) Total noncurrent assets 17,524,571 11,960,975 38,439,507 1,029,317 ‐ 52,621 15,930,595 84,937,586 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,425 88,174 4,377,926 6,553 ‐ ‐ ‐ 4,486,078 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,419 149,095 6,291,238 203,387 418,590 2,038 36,985 7,254,752 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,488 2,842,189 19,883,193 244,975 418,590 3,220 2,950,387 29,563,042 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,027,606 886,563 2,647,687 (46,947) 970 159,908 (237,394) 4,438,393 Total net position 21,076,971 $ 11,769,539 $ 39,701,682 $ 1,417,663 $ 109,059 $ 654,972 $ 14,494,351 $ 89,224,237 $ ---PAGE BREAK--- March 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,166,971 $ 3,067,795 $ 26,717,687 $ 843,224 $ 55,750 $ 1,015,493 $ 1,194,515 $ 37,061,435 $ Connection fees 10,729 925 197,908 ‐ ‐ ‐ ‐ 209,562 Miscellaneous 11,502 750 1,431,553 (12,365) ‐ ‐ 245,254 1,676,694 Total operating revenues 4,189,202 3,069,470 28,347,148 830,859 55,750 1,015,493 1,439,769 38,947,691 Operating expenses: Wages and benefits 935,418 443,970 3,605,328 521,576 ‐ 46,440 382,718 5,935,450 Administrative fees 437,859 284,868 1,176,939 567 ‐ 85,311 67,032 2,052,576 Purchase power ‐ ‐ 14,442,500 ‐ ‐ ‐ ‐ 14,442,500 Operations and maintenance 802,543 1,112,229 2,281,207 236,245 55,080 662,944 220,387 5,370,635 Depreciation and amortization 758,420 318,677 2,217,632 119,161 ‐ 1,992 898,874 4,314,756 Total operating expenses 2,934,240 2,159,744 23,723,606 877,549 55,080 796,687 1,569,011 32,115,917 Operating income (loss) 1,254,962 909,726 4,623,542 (46,690) 670 218,806 (129,242) 6,831,774 Nonoperating revenues (expenses) Investment earnings 26,537 8,507 183,183 2,238 300 1,663 14,569 236,997 Interest and fiscal charges (29,253) (35,864) (250,087) (4,119) ‐ ‐ (49,268) (368,591) Impact fees 108,324 237,771 188,659 ‐ ‐ ‐ 10,087 544,841 Total nonoperating revenues (expenses) 114,401 210,414 141,755 (257) 300 1,663 (24,128) 444,148 Income (loss) before transfers 1,369,363 1,120,140 4,765,297 (46,947) 970 220,469 (153,370) 7,275,922 Transfers out (341,757) (233,577) (2,117,610) ‐ ‐ (60,561) (84,024) (2,837,529) Change in net position 1,027,606 $ 886,563 $ 2,647,687 $ (46,947) $ 970 $ 159,908 $ (237,394) $ 4,438,393 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) March 31, 2014 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents 52,168 $ 1,628,198 $ Inventory 94,948 ‐ Total current assets 147,116 1,628,198 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (102,502) ‐ Total noncurrent assets 48,632 ‐ Total assets 195,748 1,628,198 Liabilities Current liabilities: Accrued Liabilities 1,722 253,043 Compensated absences 21,101 4,474 Total current liabilities 22,823 257,517 Noncurrent liabilities: Compensated absences 9,698 2,057 Total noncurrent liabilities 9,698 2,057 Total liabilities 32,521 259,574 Net Assets Beginning net position 69,476 1,371,921 Change in net position 93,751 (3,297) Total net position 163,227 $ 1,368,624 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) March 31, 2014 Central Garage Fund Operating revenues: Charges for services 341,752 $ Miscellaneous 714 Total operating revenues 342,466 Operating expenses: Wages and benefits 218,146 Administrative fees 567 Operations and maintenance 27,050 Depreciation and amortization 2,952 Total operating expenses 248,715 Operating income (loss) 93,751 Nonoperating revenues (expenses) Investment earnings ‐ Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) ‐ Income (loss) before transfers 93,751 Change in net position 93,751 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) March 31, 2014 Retained Risk Fund Operating revenues: Charges for services 676,269 $ Miscellaneous ‐ Total operating revenues 676,269 Operating expenses: Wages and benefits 112,580 Administrative fees 378 Operations and maintenance 15,197 Professional Fees 177,692 Insurance 273,606 Claims by department: ADS 942 Police 25,538 Parks & Recreation 1,233 Public Works 22,738 Water 28,222 Power 16,607 Storm Water 10,553 Total operating expenses 685,286 Operating income (loss) (9,017) Nonoperating revenues (expenses) Investment earnings 5,720 Total nonoperating revenues (expenses) 5,720 Income (loss) before transfers (3,297) Change in net position (3,297) $