Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) December 31, 2014 General Fund Library Capital Projects RDA Cemetery Total Assets Cash and cash equivalents 6,889,566 $ 378,228 $ 8,145,259 $ 3,298,622 $ 1,425,913 $ 20,137,588 $ Investments 2,869,918 600,000 2,869,917 ‐ ‐ 6,339,835 Accounts receivable (net) 6,365,891 1,460,991 ‐ 3,074,312 ‐ 10,901,194 Prepaids 12,764 ‐ ‐ ‐ ‐ 12,764 Restricted cash 346 15,848 ‐ 63,002 ‐ 79,196 Total assets 16,138,485 2,455,067 11,015,176 6,435,936 1,425,913 37,470,577 Liabilities Accrued Liabilities 720,568 38 ‐ 1,000 ‐ 721,606 Due to other funds ‐ ‐ ‐ ‐ ‐ ‐ Total liabilities 720,568 38 ‐ 1,000 ‐ 721,606 Deferred Inflows of Resources Deferred Inflows‐ property taxes 6,003,221 1,460,991 ‐ 3,074,312 ‐ 10,538,524 Deferred Inflows‐ ambulance billing 126,642 ‐ ‐ ‐ ‐ 126,642 Total deferred inflows of resources 6,129,863 1,460,991 ‐ 3,074,312 ‐ 10,665,166 Fund Balance Nonspendable 122,454 ‐ ‐ ‐ ‐ 122,454 Restricted 163,010 15,810 3,007,276 525,828 520,000 4,231,924 Beginning fund balance 8,440,290 321,747 10,368,134 1,860,064 883,958 21,874,193 Change in fund balance 562,300 656,481 (2,360,234) 974,732 21,955 (144,766) Total fund balance 9,288,054 $ 994,038 $ 11,015,176 $ 3,360,624 $ 1,425,913 $ 26,083,805 $ ---PAGE BREAK--- December 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 4,398,472 $ 4,625,031 $ 12,943,703 $ 12,973,703 $ (8,348,672) $ Property tax 5,627,038 5,657,813 6,618,221 6,618,221 (960,408) Transfers in 2,325,574 2,332,902 4,665,816 4,665,816 (2,332,914) Franchise tax 1,853,003 1,913,960 4,842,000 4,842,000 (2,928,040) Administrative fees 1,483,902 1,552,752 3,105,489 3,105,489 (1,552,737) Parks and recreation 848,612 826,284 1,564,500 1,564,500 (738,216) Fines and forfeitures 852,437 807,193 1,818,000 1,818,000 (1,010,807) Intergovernmental 637,782 647,263 1,609,284 1,688,456 (1,041,193) Public safety 523,931 677,438 1,039,500 1,058,683 (381,245) Business license 326,369 325,009 655,000 655,000 (329,991) Building permits 422,673 448,502 525,250 525,250 (76,748) Miscellaneous 121,110 118,706 226,500 226,500 (107,794) Emergency 911 Fees ‐ ‐ ‐ 423,000 (423,000) Investment income 24,864 38,482 60,000 60,000 (21,518) Total revenue 19,445,767 19,971,335 39,673,263 40,224,618 Expenditures Payroll General Government 1,390,717 1,492,976 3,174,759 3,222,259 1,729,283 Police 3,821,909 3,799,222 8,369,388 8,402,431 4,603,209 Fire 2,806,967 2,847,765 6,122,724 6,131,224 3,283,459 Public works 865,122 881,957 1,718,878 1,718,878 836,921 Parks 1,748,050 1,755,637 3,717,183 3,717,183 1,961,546 ADS 1,775,341 1,836,425 3,959,412 3,945,412 2,108,987 Operations and maintenance General Government 724,717 778,484 1,024,356 1,402,022 623,538 Police 884,546 913,964 1,713,702 1,840,531 926,567 Fire 367,252 383,928 821,482 824,848 440,920 Emergency 911 Services 235,293 251,070 503,620 926,620 675,550 Public works 219,574 241,220 834,732 834,732 593,512 Class C 841,491 372,836 325,000 533,565 160,729 Parks 927,736 884,043 2,056,046 2,050,719 1,166,676 ADS 645,398 623,285 1,293,334 1,283,834 660,549 Capital Outlay Class C 421,186 667,516 1,000,000 859,733 192,217 Parks 2,361 5,327 ‐ 48,327 43,000 Debt Service Principal 651,868 673,565 1,278,566 1,278,566 605,001 UTOPIA payments 806,263 822,388 1,647,520 1,647,520 825,132 Interest and fiscal charge 180,165 160,429 308,061 308,061 147,632 Transfer out 16,938 16,998 34,000 34,000 17,002 Total Expenditures 19,332,894 19,409,035 39,902,763 41,010,465 Net change in fund balance 112,873 $ 562,300 $ ---PAGE BREAK--- December 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,370,395 $ 1,376,957 $ 1,619,738 $ 1,619,738 $ (242,781) $ Fines and forfeitures 26,455 25,308 45,000 45,000 (19,692) Miscellaneous 3,473 3,719 6,500 6,500 (2,781) Intergovernmental 13,322 38,300 12,000 50,300 (12,000) Investment income 1,430 1,457 6,131 6,131 (4,674) Total revenue 1,415,075 1,445,741 1,689,369 1,727,669 Expenditures Payroll 486,240 511,726 1,036,140 1,036,140 524,414 Operations and maintenance 218,493 206,072 473,404 511,704 305,632 Capital Outlay ‐ ‐ 55,000 55,000 55,000 Transfer out ‐ 9,050 ‐ 9,050 ‐ Administrative Fee 59,832 62,412 124,825 124,825 62,413 Total Expenditures 764,565 789,260 1,689,369 1,736,719 Net change in fund balance 650,510 $ 656,481 $ ---PAGE BREAK--- December 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 406,716 200,000 606,716 (200,000) Intergovernmental 959,847 ‐ 959,847 ‐ Investment income 43,267 ‐ ‐ 43,267 Total revenue 1,409,830 200,000 1,566,563 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police 61,388 85,500 85,500 24,112 Fire 9,833 42,800 42,800 32,967 Public works 48,841 192,392 252,392 203,551 Parks 18,949 170,000 170,000 151,051 ADS 41,380 50,000 150,000 108,620 Capital Outlay General Government ‐ ‐ ‐ ‐ Police 275,820 295,000 295,000 19,180 Fire 187,062 452,863 452,863 265,801 Public works 2,816,274 732,000 3,884,603 1,068,329 Parks 47,926 475,000 475,000 427,074 ADS 247,498 219,602 1,032,318 784,820 Debt Service Principal 12,591 24,139 24,139 11,548 Interest and fiscal charge ‐ 1,050 1,050 1,050 Transfer out 2,502 5,000 5,000 2,498 Total Expenditures 3,770,064 2,745,346 6,870,665 Net change in fund balance (2,360,234) $ ---PAGE BREAK--- December 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,545,771 $ 1,752,119 $ 3,074,312 $ 3,074,312 $ (1,322,193) $ Rents ‐ 2,538 ‐ ‐ 2,538 Investment income 4,774 5,502 9,500 9,500 (3,998) Total revenue 1,550,545 1,760,159 3,083,812 3,083,812 Expenditures Operations and maintenance 245,500 19,562 1,670,778 1,670,778 1,651,216 Capital Outlay 24,945 250,000 100,000 350,000 100,000 Debt Service Principal ‐ ‐ 262,000 262,000 262,000 Interest and fiscal charge ‐ 11,671 22,040 22,040 10,369 Administrative Fee 55,056 58,290 116,567 116,567 58,277 Transfer out 432,120 445,904 1,064,937 1,078,379 632,475 Total Expenditures 757,621 785,427 3,236,322 3,499,764 Net change in fund balance 792,924 $ 974,732 $ ---PAGE BREAK--- December 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 ‐ $ ‐ $ 50,000 $ 61,119 $ (61,119) $ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue ‐ ‐ 50,000 61,119 Expenditures Operations and maintenance ‐ ‐ 50,000 61,119 61,119 Total Expenditures ‐ ‐ 50,000 61,119 Net change in fund balance ‐ $ ‐ $ ---PAGE BREAK--- December 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 16,938 $ 16,998 $ 34,000 $ 34,000 $ (17,002) $ Miscellaneous 2,750 1,550 ‐ ‐ 1,550 Investment income 3,495 3,407 8,000 8,000 (4,593) Total revenue 23,183 21,955 42,000 42,000 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 23,183 $ 21,955 $ ---PAGE BREAK--- December 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,307,954 $ 3,278,355 $ 9,805,052 $ 647,892 $ 104,160 $ 497,281 $ 914,225 $ 18,554,919 $ Investments 1,913,279 ‐ 3,826,557 ‐ ‐ ‐ ‐ 5,739,836 Accounts receivable (net) 493,277 365,562 2,870,863 ‐ 7,359 122,324 147,705 4,007,090 Notes receivable ‐ ‐ ‐ ‐ 461,219 ‐ ‐ 461,219 Due from other funds 81,295 ‐ ‐ ‐ ‐ ‐ ‐ 81,295 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,268,240 84,255 ‐ ‐ ‐ 2,352,495 Total current assets 5,795,805 3,755,067 18,770,712 732,147 572,738 619,605 1,061,930 31,308,004 Noncurrent assets: Restricted cash 47 260,145 93 ‐ ‐ ‐ 1,040,280 1,300,565 Investment in joint venture ‐ 3,369,614 ‐ ‐ ‐ ‐ ‐ 3,369,614 Capital Assets: Land 2,155,313 455,921 1,691,650 326,336 ‐ ‐ 2,344,849 6,974,069 Buildings 919,021 949,132 3,410,311 819,374 ‐ ‐ ‐ 6,097,838 Improvements 26,447,023 12,222,810 76,519,089 3,734,149 ‐ ‐ 33,303,318 152,226,389 Machinery and equipment 2,931,329 1,117,862 13,127,960 983,602 ‐ 54,613 1,149,473 19,364,839 Intangibles ‐ ‐ 3,759,027 ‐ ‐ ‐ ‐ 3,759,027 Construction in progress 2,631,790 9,090 139,550 21,000 ‐ ‐ 2,474,970 5,276,400 Accumulated depreciation (15,494,007) (6,834,919) (61,379,124) (4,843,689) ‐ (6,088) (24,567,017) (113,124,844) Total noncurrent assets 19,590,516 11,549,655 37,268,556 1,040,772 ‐ 48,525 15,745,873 85,243,897 Liabilities Current liabilities: Accrued Liabilities 13,250 103,473 4,090,438 54,122 ‐ ‐ 667 4,261,950 Due to other funds ‐ ‐ ‐ 84,422 ‐ ‐ ‐ 84,422 Notes payable ‐ ‐ ‐ ‐ 461,219 ‐ ‐ 461,219 Interest payable ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Compensated absences 121,978 63,400 418,721 78,609 ‐ 2,522 37,739 722,969 Bonds & leases payable ‐ ‐ 1,200,000 ‐ ‐ ‐ 210,000 1,410,000 Total current liabilities 135,228 166,873 5,709,159 217,153 461,219 2,522 248,406 6,940,560 Noncurrent liabilities: Compensated absences 69,102 35,916 237,212 44,533 ‐ 1,430 21,380 409,573 Net OPEB payable 84,714 ‐ 226,696 ‐ ‐ ‐ ‐ 311,410 Bonds payable 2,871,870 3,026,644 8,328,565 ‐ ‐ ‐ 2,676,594 16,903,673 Total noncurrent liabilities 3,025,686 3,062,560 8,792,473 44,533 ‐ 1,430 2,697,974 17,624,656 Total liabilities 3,160,914 3,229,433 14,501,632 261,686 461,219 3,952 2,946,380 24,565,216 Net Position Beginning net position 21,048,269 11,510,943 39,789,394 1,499,580 108,049 596,999 14,270,997 88,824,231 Change in net position 1,177,138 564,346 1,748,242 11,653 3,470 67,179 (409,574) 3,162,454 Total net position 22,225,407 $ 12,075,289 $ 41,537,636 $ 1,511,233 $ 111,519 $ 664,178 $ 13,861,423 $ 91,986,685 $ ---PAGE BREAK--- December 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,478,058 $ 2,109,342 $ 18,745,714 $ 726,159 $ 34,804 $ 692,601 $ 806,018 $ 26,592,696 $ Connection fees 6,074 1,150 107,745 ‐ ‐ ‐ ‐ 114,969 Miscellaneous 919 ‐ 989,505 (48,708) ‐ ‐ 608 942,324 Total operating revenues 3,485,051 2,110,492 19,842,964 677,451 34,804 692,601 806,626 27,649,989 Operating expenses: Wages and benefits 660,791 300,299 2,496,476 386,641 ‐ 38,505 251,720 4,134,432 Administrative fees 315,366 196,116 817,008 378 ‐ 55,650 46,902 1,431,420 Purchase power ‐ ‐ 10,881,062 ‐ ‐ ‐ ‐ 10,881,062 Operations and maintenance 647,684 763,432 1,068,054 190,516 31,637 459,270 228,329 3,388,922 Depreciation and amortization 505,792 235,761 1,481,073 80,837 ‐ 2,731 605,179 2,911,373 Total operating expenses 2,129,633 1,495,608 16,743,673 658,372 31,637 556,156 1,132,130 22,747,209 Operating income (loss) 1,355,418 614,884 3,099,291 19,079 3,167 136,445 (325,504) 4,902,780 Nonoperating revenues (expenses) Investment earnings 24,126 7,894 141,992 1,741 303 1,177 6,184 183,417 Interest and fiscal charges (19,924) (19,734) (170,134) (3,127) ‐ ‐ (9,440) (222,359) Impact fees 110,820 166,464 111,384 ‐ ‐ ‐ 9,375 398,043 Gain (loss) on sale of fixed assets 741 ‐ ‐ 900 ‐ ‐ ‐ 1,641 Total nonoperating revenues (expenses) 115,763 154,624 83,242 (486) 303 1,177 6,119 360,742 Income (loss) before transfers 1,471,181 769,508 3,182,533 18,593 3,470 137,622 (319,385) 5,263,522 Transfers in ‐ 7,920 7,920 ‐ ‐ ‐ 7,506 23,346 Transfers out (294,043) (213,082) (1,616,428) (6,940) ‐ (70,443) (97,695) (2,298,631) Change in net position 1,177,138 $ 564,346 $ 1,748,242 $ 11,653 $ 3,470 $ 67,179 $ (409,574) $ 3,162,454 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) December 31, 2014 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents 60,000 $ 1,661,578 $ Investments 16,859 ‐ Inventory 77,422 ‐ Total current assets 154,281 1,661,578 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (105,454) ‐ Total noncurrent assets 45,680 ‐ Total assets 199,961 1,661,578 Liabilities Current liabilities: Accrued Liabilities 27 250,000 Due to other funds ‐ ‐ Compensated absences 22,455 7,033 Total current liabilities 22,482 257,033 Noncurrent liabilities: Compensated absences 9,751 3,054 Total noncurrent liabilities 9,751 3,054 Total liabilities 32,233 260,087 Net Assets Beginning net position 157,593 1,268,857 Change in net position 10,135 132,634 Total net position 167,728 $ 1,401,491 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) December 31, 2014 Central Garage Fund Operating revenues: Charges for services 190,137 $ Miscellaneous 587 Total operating revenues 190,724 Operating expenses: Wages and benefits 152,005 Administrative fees 378 Operations and maintenance 23,984 Depreciation and amortization 1,968 Total operating expenses 178,335 Operating income (loss) 12,389 Nonoperating revenues (expenses) Investment earnings 57 Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) 57 Income (loss) before transfers 12,446 Transfers out (2,311) Change in net position 10,135 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) December 31, 2014 Retained Risk Fund Operating revenues: Charges for services 503,928 $ Miscellaneous ‐ Total operating revenues 503,928 Operating expenses: Wages and benefits 104,951 Administrative fees 252 Operations and maintenance 5,326 Professional Fees 62,236 Insurance 175,221 Claims by department: ADS 250 Police 1,304 Public Works 551 Water 5,743 Fire 2,443 Murray Park Golf 182 Power 10,151 Storm Water 1,665 Total operating expenses 370,275 Operating income (loss) 133,653 Nonoperating revenues (expenses) Investment earnings 3,547 Total nonoperating revenues (expenses) 3,547 Income (loss) before transfers 137,200 Transfers out (4,566) Change in net position 132,634 $ ---PAGE BREAK--- Balance Sheet ‐ Governmental Fund (Unaudited) December 31, 2014 DEA Assets Cash and cash equivalents 1,355,464 $ Total assets 1,355,464 Liabilities Accrued Liabilities 5,729 Total liabilities 5,729 Fund Balance Restricted 924,053 Beginning fund balance 600,015 Change in fund balance (174,333) Total fund balance 1,349,735 $ ‐ ---PAGE BREAK--- YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) DEA Fund December 31, 2014 Prior YTD Current YTD Original Budget Final Budget Variance Revenue Rocky mountain HIDTA 148,218 $ 156,462 $ 1,065,708 $ 1,065,708 $ (909,246) $ Federal asset forfeiture 135,096 100,646 817,500 817,500 (716,854) Restitution 8,169 10,838 50,000 50,000 (39,162) Investment income 3,308 3,080 ‐ ‐ 3,080 Total revenue 305,411 271,026 1,933,208 1,933,208 Expenditures Payroll HIDTA 2012 113,343 119,972 524,638 407,314 287,342 HIDTA 2013 ‐ ‐ 27,070 ‐ ‐ Federal asset forfeiture ‐ ‐ 100,000 100,000 100,000 Operations and Maintenance HIDTA 2012 196,363 107,394 504,000 107,396 2 HIDTA 2014 ‐ 74,930 ‐ 428,052 353,122 Federal asset forfeiture 47,886 95,885 573,500 573,500 477,615 Restitution 23,680 28,266 50,000 50,000 21,734 Marijuana Eradication 17,106 12,338 19,000 19,000 6,662 Capital Outlay Federal asset forfeiture 101,961 6,574 135,000 135,000 128,426 Total Expenditures 500,339 445,359 1,933,208 1,820,262 Net change in fund balance (194,928) $ (174,333) $ ‐