Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) January 31, 2014 General Fund Library Capital Projects RDA Cemetery Total Assets Cash and cash equivalents 10,730,014 $ 872,284 $ 10,146,775 $ 1,534,501 $ 1,386,446 $ 24,670,020 $ Accounts receivable (net) 6,269,403 1,464,738 ‐ 2,339,342 ‐ 10,073,483 Prepaids 14,399 ‐ ‐ ‐ ‐ 14,399 Restricted cash 49 15,778 200,000 250,000 ‐ 465,827 Total assets 17,013,865 2,352,800 10,346,775 4,123,843 1,386,446 35,223,729 Liabilities Accrued Liabilities 723,868 41 ‐ 1,684 ‐ 725,593 Total liabilities 723,868 41 ‐ 1,684 ‐ 725,593 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 128,996 557,771 1,657,682 (573,908) 26,853 1,795,626 Total fund balance 10,129,850 $ 888,021 $ 10,346,775 $ 1,782,817 $ 1,386,446 $ 24,533,909 $ ---PAGE BREAK--- January 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 5,174,170 $ 5,449,763 $ 12,682,000 $ 12,776,460 $ (7,326,697) $ Property tax 5,656,844 5,755,327 6,619,202 6,619,202 (863,875) Transfers in 2,695,056 2,712,875 4,647,611 4,649,380 (1,936,505) Franchise tax 2,460,685 2,361,972 4,825,000 4,825,000 (2,463,028) Administrative fees 1,765,508 1,731,219 2,983,289 2,988,990 (1,257,771) Parks and recreation 920,264 949,897 1,504,500 1,504,500 (554,603) Fines and forfeitures 890,530 1,003,944 1,703,000 1,703,000 (699,056) Intergovernmental 3,112,877 925,682 1,586,017 1,840,050 (914,368) Public safety 558,727 609,753 1,002,000 1,008,455 (398,702) Business license 392,484 385,165 645,000 645,000 (259,835) Building permits 283,588 453,324 518,000 518,000 (64,676) Miscellaneous 116,218 136,399 187,000 194,500 (58,101) Sale of fixed assets 1,282,307 ‐ ‐ ‐ ‐ Investment income 92,018 30,798 75,000 75,000 (44,202) Total revenue 25,401,276 22,506,118 38,977,619 39,347,537 Expenditures Payroll General Government 1,622,745 1,611,283 3,000,243 3,000,243 1,388,960 Police 4,266,625 4,419,725 8,278,453 8,321,495 3,901,770 Fire 3,133,721 3,236,024 5,953,177 5,961,677 2,725,653 Public works 925,743 979,840 1,645,816 1,645,816 665,976 Parks 1,925,794 1,987,154 3,628,515 3,628,515 1,641,361 ADS 1,995,889 2,054,096 3,796,992 3,805,992 1,751,896 Operations and maintenance General Government 690,987 838,310 1,549,596 1,552,765 714,455 Police 1,389,550 1,484,685 1,963,774 2,245,358 760,673 Fire 519,024 586,227 900,819 955,275 369,048 Public works 470,013 287,514 620,844 827,495 539,981 Class C 2,925,602 930,497 428,000 528,000 (402,497) Parks 1,090,779 1,033,225 1,970,029 1,986,921 953,696 ADS 659,238 710,301 1,314,604 1,324,897 614,596 Capital Outlay Police 20,000 ‐ ‐ ‐ ‐ Class C 794,089 423,446 879,000 1,047,374 623,928 Parks ‐ 2,361 ‐ 5,221 2,860 Debt Service Principle 875,000 651,868 1,255,000 1,268,000 616,132 UTOPIA payments 922,196 940,640 1,619,333 1,619,333 678,693 Interest and fiscal charge 206,576 180,165 363,551 350,551 170,386 Transfer out 2,801,250 19,761 2,034,873 2,694,873 2,675,112 Total Expenditures 27,234,821 22,377,122 41,202,619 42,769,801 Net change in fund balance (1,833,545) $ 128,996 $ ---PAGE BREAK--- January 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,376,080 $ 1,401,632 $ 1,619,738 $ 1,619,738 $ (218,106) $ Fines and forfeitures 24,926 33,219 45,000 45,000 (11,781) Miscellaneous 3,738 4,066 6,500 6,500 (2,434) Intergovernmental 39,411 13,322 12,500 25,822 (12,500) Investment income 3,999 2,308 6,000 6,000 (3,692) Total revenue 1,448,154 1,454,547 1,689,738 1,703,060 Expenditures Payroll 578,677 562,632 1,011,204 1,029,546 466,914 Operations and maintenance 252,817 264,340 503,871 498,851 234,511 Capital Outlay 1,481 ‐ 55,000 55,000 55,000 Administrative Fee 57,631 69,804 119,663 119,663 49,859 Total Expenditures 890,606 896,776 1,689,738 1,703,060 Net change in fund balance 557,548 $ 557,771 $ ---PAGE BREAK--- January 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 417,177 425,000 426,500 (9,323) Investment income 27,959 ‐ ‐ 27,959 Total revenue 2,979,829 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 72,210 15 Public works 280,759 362,313 363,865 83,106 Parks 35,773 43,000 43,500 7,727 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 181,492 52,051 Public works 41,190 1,636,000 3,434,448 3,393,258 Parks 131,700 139,000 140,000 8,300 ADS 424,029 466,120 702,120 278,091 Debt Service Principle 17,453 28,500 28,500 11,047 Interest and fiscal charge ‐ ‐ ‐ ‐ Transfer out ‐ ‐ 200,000 200,000 Total Expenditures 1,322,147 3,156,155 5,503,564 Net change in fund balance 1,657,682 $ ---PAGE BREAK--- January 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 1,369,025 $ 1,545,771 $ 2,339,342 $ 2,339,342 $ (793,571) $ Investment income 5,616 5,994 8,000 8,000 (2,006) Total revenue 1,374,641 1,552,186 2,347,342 2,347,342 Expenditures Operations and maintenance 38,864 245,923 1,243,091 1,243,091 997,168 Capital Outlay ‐ 1,311,799 280,000 530,000 (781,799) Debt Service Principle ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ ‐ ‐ ‐ ‐ Administrative Fee 44,919 64,232 110,118 110,118 45,886 Transfer out 523,915 504,140 1,064,246 1,064,246 560,106 Total Expenditures 607,698 2,126,094 2,697,455 2,947,455 Net change in fund balance 766,943 $ (573,908) $ ---PAGE BREAK--- January 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 581 $ ‐ $ 1,000 $ 1,000 $ (1,000) $ Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Investment income 1 ‐ ‐ ‐ ‐ Total revenue 582 ‐ 1,000 1,000 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Debt Service Principle ‐ ‐ ‐ ‐ ‐ 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 572 $ (1,768) $ ---PAGE BREAK--- January 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,013 ‐ 101,178 126,178 126,178 Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee 7,822 ‐ 15,501 21,202 21,202 Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures 185,835 ‐ 116,679 147,380 Net change in fund balance $ ‐ $ ---PAGE BREAK--- January 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 19,761 $ 19,761 $ 33,873 $ 33,873 $ (14,112) $ Miscellaneous 320 3,000 ‐ ‐ 3,000 Investment income 5,656 4,092 7,000 7,000 (2,908) Total revenue 25,737 26,853 40,873 40,873 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 25,737 $ 26,853 $ ---PAGE BREAK--- January 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 6,320,303 $ 2,034,594 $ 15,524,396 $ 574,163 $ 102,006 $ 484,957 $ 1,321,369 $ 26,361,788 $ Accounts receivable (net) 498,116 306,803 2,886,822 ‐ 6,910 110,636 145,934 3,955,221 Notes receivable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Due from other funds 125,095 ‐ ‐ ‐ ‐ ‐ ‐ 125,095 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,071,415 84,507 ‐ ‐ ‐ 2,155,922 Total current assets 6,943,514 2,452,547 20,482,633 658,670 527,506 595,593 1,467,303 33,127,766 Noncurrent assets: Restricted cash 59 353,780 63 ‐ ‐ ‐ 2,607,894 2,961,796 Investment in joint venture ‐ 3,354,225 ‐ ‐ ‐ ‐ ‐ 3,354,225 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,370,966 935,557 ‐ 54,613 1,131,251 19,808,432 Intangibles ‐ ‐ 3,759,027 ‐ ‐ ‐ ‐ 3,759,027 Construction in progress 1,001,404 1,522,316 3,650 ‐ ‐ ‐ 962,942 3,490,312 Accumulated depreciation (15,001,829) (6,471,284) (59,484,276) (4,738,499) ‐ (1,082) (23,471,115) (109,168,085) Total noncurrent assets 17,620,835 12,004,922 38,853,980 1,055,077 ‐ 53,531 16,367,337 85,955,682 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 8,052 116,650 4,311,935 (985) ‐ ‐ ‐ 4,435,652 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 ‐ ‐ ‐ 210,000 1,755,000 Total current liabilities 148,046 177,571 6,225,247 195,849 418,590 2,038 246,985 7,414,326 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,215,115 2,870,665 19,817,202 237,437 418,590 3,220 3,160,387 29,722,616 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,299,869 703,828 2,596,929 11,700 827 150,840 (57,492) 4,706,501 Total net position 21,349,234 $ 11,586,804 $ 39,650,924 $ 1,476,310 $ 108,916 $ 645,904 $ 14,674,253 $ 89,492,345 $ ---PAGE BREAK--- January 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 3,778,973 $ 2,377,323 $ 21,691,927 $ 707,071 $ 41,730 $ 794,034 $ 973,325 $ 30,364,383 $ Connection fees 9,357 875 187,758 ‐ ‐ ‐ ‐ 197,990 Miscellaneous 3,353 750 1,100,970 (12,714) ‐ ‐ 245,254 1,337,613 Total operating revenues 3,791,683 2,378,948 22,980,655 694,357 41,730 794,034 1,218,579 31,899,986 Operating expenses: Wages and benefits 724,247 354,375 2,836,654 425,334 ‐ 34,557 285,244 4,660,411 Administrative fees 340,557 221,564 915,397 441 ‐ 66,353 52,136 1,596,448 Purchase power ‐ ‐ 11,619,416 ‐ ‐ ‐ ‐ 11,619,416 Operations and maintenance 673,265 876,624 1,727,059 162,775 41,152 495,370 187,740 4,163,985 Depreciation and amortization 592,246 247,928 1,716,101 93,401 ‐ 1,082 699,124 3,349,882 Total operating expenses 2,330,315 1,700,491 18,814,627 681,951 41,152 597,362 1,224,244 25,390,142 Operating income (loss) 1,461,368 678,457 4,166,028 12,406 578 196,672 (5,665) 6,509,844 Nonoperating revenues (expenses) Investment earnings 21,985 6,507 148,106 1,789 249 1,271 11,459 191,366 Interest and fiscal charges (29,253) (35,864) (250,087) (4,119) ‐ ‐ (8,322) (327,645) Impact fees 102,787 236,399 161,061 ‐ ‐ ‐ 9,904 510,151 Total nonoperating revenues (expenses) 104,312 207,042 79,080 (706) 249 1,271 13,525 404,773 Income (loss) before transfers 1,565,680 885,499 4,245,108 11,700 827 197,943 7,860 6,914,617 Transfers out (265,811) (181,671) (1,647,030) ‐ ‐ (47,103) (65,352) (2,206,967) Change in net position 1,299,869 $ 703,828 $ 2,596,929 $ 11,700 $ 827 $ 150,840 $ (57,492) $ 4,706,501 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) January 31, 2014 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents (38,842) $ 1,691,215 $ Inventory 96,447 ‐ Total current assets 57,605 1,691,215 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (101,846) ‐ Total noncurrent assets 49,288 ‐ Total assets 106,893 1,691,215 Liabilities Current liabilities: Accrued Liabilities (26) 250,000 Compensated absences 21,101 4,474 Total current liabilities 21,075 254,474 Noncurrent liabilities: Compensated absences 9,698 2,057 Total noncurrent liabilities 9,698 2,057 Total liabilities 30,773 256,531 Net Assets Beginning net position 69,476 1,371,921 Change in net position 6,644 62,763 Total net position 76,120 $ 1,434,684 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) January 31, 2014 Central Garage Fund Operating revenues: Charges for services 201,667 $ Miscellaneous 457 Total operating revenues 202,124 Operating expenses: Wages and benefits 171,521 Administrative fees 441 Operations and maintenance 21,222 Depreciation and amortization 2,296 Total operating expenses 195,480 Operating income (loss) 6,644 Nonoperating revenues (expenses) Investment earnings ‐ Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) ‐ Income (loss) before transfers 6,644 Change in net position 6,644 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) January 31, 2014 Retained Risk Fund Operating revenues: Charges for services 525,987 $ Miscellaneous ‐ Total operating revenues 525,987 Operating expenses: Wages and benefits 80,860 Administrative fees 294 Operations and maintenance 14,640 Legal Fees 121,715 Insurance 175,539 Claims by department: Fire ‐ Police 20,018 Parks & Recreation 1,233 Public Works 22,648 Water 17,857 Storm Water 10,553 Total operating expenses 467,670 Operating income (loss) 58,317 Nonoperating revenues (expenses) Investment earnings 4,446 Total nonoperating revenues (expenses) 4,446 Income (loss) before transfers 62,763 Change in net position 62,763 $