Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) July 31, 2014 General Fund Library Capital Projects RDA CDBG Cemetery Total Assets Cash and cash equivalents 6,643,246 $ 272,860 $ 7,075,981 $ 2,381,198 $ (12,218) $ 1,407,651 $ 17,768,718 $ Investments 3,007,430 ‐ 3,007,430 ‐ ‐ ‐ 6,014,860 Accounts receivable (net) 6,526,097 1,460,991 ‐ 3,074,312 ‐ ‐ 11,061,400 Due from other governments ‐ ‐ ‐ ‐ 24,738 ‐ 24,738 Prepaids 122,186 ‐ ‐ ‐ ‐ ‐ 122,186 Restricted cash 398 15,816 104,521 324,532 ‐ ‐ 445,267 Total assets 16,299,357 1,749,667 10,187,932 5,780,042 12,520 1,407,651 35,437,169 Liabilities Accrued Liabilities 1,193,698 43,616 ‐ 401,000 12,520 ‐ 1,650,834 Due to other funds ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total liabilities 1,193,698 43,616 ‐ 401,000 12,520 ‐ 1,650,834 Deferred Inflows of Resources Deferred Inflows‐ property taxes 6,003,221 1,460,991 ‐ 3,074,312 ‐ ‐ 10,538,524 Deferred Inflows‐ ambulance billing 145,945 ‐ ‐ ‐ ‐ ‐ 145,945 Total deferred inflows of resources 6,149,166 1,460,991 ‐ 3,074,312 ‐ ‐ 10,684,469 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,976,538 321,813 9,699,425 1,558,836 ‐ 883,958 22,440,570 Change in fund balance (1,438,309) (92,483) (149,842) (81,162) ‐ 3,693 (1,758,103) Total fund balance 8,956,493 $ 245,060 $ 10,187,932 $ 2,304,730 $ ‐ $ 1,407,651 $ 23,101,866 $ ---PAGE BREAK--- July 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 ‐ $ ‐ $ 12,943,703 $ 12,943,703 $ (12,943,703) $ Property tax ‐ ‐ 6,618,221 6,618,221 (6,618,221) Transfers in 387,301 388,817 4,665,816 4,665,816 (4,276,999) Franchise tax 211,994 91,819 4,842,000 4,842,000 (4,750,181) Administrative fees 247,317 258,792 3,105,489 3,105,489 (2,846,697) Parks and recreation 287,779 281,356 1,564,500 1,564,500 (1,283,144) Fines and forfeitures 126,701 145,818 1,818,000 1,818,000 (1,672,182) Intergovernmental 70,718 30,396 1,609,284 1,649,662 (1,619,266) Public safety 1,199 106,249 1,039,500 1,039,500 (933,251) Business license 53,702 54,144 655,000 655,000 (600,856) Building permits 86,426 78,033 525,250 525,250 (447,217) Miscellaneous 11,294 15,518 226,500 226,500 (210,982) Investment income 4,203 4,428 60,000 60,000 (55,572) Total revenue 1,488,634 1,455,370 39,673,263 39,713,641 Expenditures Payroll General Government 163,338 166,756 3,174,759 3,178,259 3,011,503 Police 448,805 423,086 8,369,388 8,369,388 7,946,302 Fire 324,417 313,329 6,122,724 6,131,224 5,817,895 Public works 100,884 100,048 1,718,878 1,718,878 1,618,830 Parks 255,186 244,913 3,717,183 3,717,183 3,472,270 ADS 214,196 209,984 3,959,412 3,959,412 3,749,428 Operations and maintenance General Government 375,179 333,175 1,024,356 1,282,522 949,347 Police 238,100 280,495 1,713,702 1,818,963 1,538,468 Fire 33,397 41,104 821,482 821,482 780,378 Emergency 911 Services 235,293 251,070 503,620 503,620 252,550 Public works 17,839 19,276 834,732 834,732 815,456 Class C ‐ 11,480 325,000 325,000 313,520 Parks 141,568 196,207 2,056,046 2,056,046 1,859,839 ADS 62,612 162,858 1,293,334 1,293,334 1,130,476 Capital Outlay Class C ‐ ‐ 1,000,000 1,068,298 1,068,298 Parks 2,361 ‐ ‐ 16,000 16,000 Debt Service Principal 86,066 ‐ 1,278,566 1,278,566 1,278,566 UTOPIA payments 134,377 137,065 1,647,520 1,647,520 1,510,455 Interest and fiscal charge 175 ‐ 308,061 308,061 308,061 Transfer out 2,906 2,833 34,000 34,000 31,167 Total Expenditures 2,836,699 2,893,679 39,902,763 40,362,488 Net change in fund balance (1,348,065) $ (1,438,309) $ ---PAGE BREAK--- July 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,619,738 $ 1,619,738 $ (1,619,738) $ Fines and forfeitures 2,794 3,533 45,000 45,000 (41,467) Miscellaneous 405 482 6,500 6,500 (6,018) Intergovernmental ‐ ‐ 12,000 50,300 (50,300) Investment income 151 155 6,131 6,131 (5,976) Total revenue 3,350 4,170 1,689,369 1,727,669 Expenditures Payroll 54,719 58,071 1,036,140 1,036,140 978,069 Operations and maintenance 13,366 28,180 473,404 511,704 483,524 Capital Outlay ‐ ‐ 55,000 55,000 55,000 Administrative Fee 9,972 10,402 124,825 124,825 114,423 Total Expenditures 78,057 96,653 1,689,369 1,727,669 Net change in fund balance (74,707) $ (92,483) $ ---PAGE BREAK--- July 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 ‐ 200,000 213,442 (213,442) Intergovernmental 49,847 ‐ 959,847 (910,000) Investment income 5,009 ‐ ‐ 5,009 Total revenue 54,856 200,000 1,173,289 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police ‐ 85,500 85,500 85,500 Fire ‐ 42,800 42,800 42,800 Public works 83 192,392 252,392 252,309 Parks ‐ 170,000 170,000 170,000 ADS ‐ 50,000 150,000 150,000 Capital Outlay General Government ‐ ‐ ‐ ‐ Police 132,831 295,000 295,000 162,169 Fire ‐ 452,863 452,863 452,863 Public works 49,394 732,000 2,767,870 2,718,476 Parks ‐ 475,000 475,000 475,000 ADS 19,874 219,602 1,032,318 1,012,444 Debt Service Principal 2,099 24,139 24,139 22,040 Interest and fiscal charge ‐ 1,050 1,050 1,050 Transfer out 417 5,000 5,000 4,583 Total Expenditures 204,698 2,745,346 5,753,932 Net change in fund balance (149,842) $ ---PAGE BREAK--- July 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 ‐ $ ‐ $ 3,074,312 $ 3,074,312 $ (3,074,312) $ Investment income 890 982 9,500 9,500 (8,518) Total revenue 890 982 3,083,812 3,083,812 Expenditures Operations and maintenance 319 352 1,670,778 1,670,778 1,670,426 Capital Outlay ‐ ‐ 100,000 350,000 350,000 Debt Service Principal ‐ ‐ 262,000 262,000 262,000 Interest and fiscal charge ‐ ‐ 22,040 22,040 22,040 Administrative Fee 9,176 9,715 116,567 116,567 106,852 Transfer out 72,020 72,077 1,064,937 1,078,379 1,006,302 Total Expenditures 81,515 82,144 3,236,322 3,499,764 Net change in fund balance (80,625) $ (81,162) $ ---PAGE BREAK--- July 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 $ 52,619 $ (52,619) $ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue ‐ ‐ 50,000 52,619 Expenditures Operations and maintenance ‐ ‐ 50,000 52,619 52,619 Total Expenditures ‐ ‐ 50,000 52,619 Net change in fund balance ‐ $ ‐ $ ---PAGE BREAK--- July 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 2,823 $ 2,833 $ 34,000 $ 34,000 $ (31,167) $ Miscellaneous 1,150 300 ‐ ‐ 300 Investment income 574 560 8,000 8,000 (7,440) Total revenue 4,547 3,693 42,000 42,000 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 4,547 $ 3,693 $ ---PAGE BREAK--- July 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,543,185 $ 2,459,815 $ 7,272,782 $ 727,762 $ 104,546 $ 537,460 $ 868,145 $ 15,513,695 $ Investments 2,004,953 ‐ 4,009,907 ‐ ‐ ‐ ‐ 6,014,860 Accounts receivable (net) 821,081 298,010 3,199,028 ‐ 7,738 102,893 140,636 4,569,386 Notes receivable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Due from other funds 125,095 ‐ ‐ ‐ ‐ ‐ ‐ 125,095 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,303,187 84,507 ‐ ‐ ‐ 2,387,694 Total current assets 6,494,314 2,868,975 16,784,904 812,269 530,874 640,353 1,008,781 29,140,470 Noncurrent assets: Restricted cash 24 354,631 1,388 ‐ ‐ ‐ 1,985,173 2,341,216 Investment in joint venture ‐ 3,390,664 ‐ ‐ ‐ ‐ ‐ 3,390,664 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,760,754 1,102,902 12,731,528 918,168 ‐ 54,613 1,134,823 18,702,788 Intangibles ‐ ‐ 3,759,027 ‐ ‐ ‐ ‐ 3,759,027 Construction in progress 1,091,111 4,034 30,842 ‐ ‐ ‐ 1,548,551 2,674,538 Accumulated depreciation (15,078,090) (6,638,459) (60,118,210) (4,796,635) ‐ (3,812) (24,062,827) (110,698,033) Total noncurrent assets 18,295,156 11,841,635 38,025,625 1,001,392 ‐ 50,801 16,253,887 85,468,496 Liabilities Current liabilities: Accrued Liabilities 10,849 110,380 4,050,304 13,691 ‐ ‐ ‐ 4,185,224 Due to other funds ‐ ‐ ‐ 125,095 ‐ ‐ ‐ 125,095 Notes payable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Interest payable 19,924 29,310 33,777 ‐ ‐ ‐ 28,156 111,167 Compensated absences 121,978 63,400 418,721 78,609 ‐ 2,522 37,739 722,969 Bonds & leases payable 40,682 128,318 1,200,000 ‐ ‐ ‐ 210,000 1,579,000 Total current liabilities 193,433 331,408 5,702,802 217,395 418,590 2,522 275,895 7,142,045 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 2,540,644 8,328,565 ‐ ‐ ‐ 2,676,594 16,417,673 Total noncurrent liabilities 3,025,686 2,576,560 8,792,473 44,533 ‐ 1,430 2,697,974 17,138,656 Total liabilities 3,219,119 2,907,968 14,495,275 261,928 418,590 3,952 2,973,869 24,280,701 Net Position Beginning net position 21,081,219 11,687,535 39,818,985 1,522,311 109,420 588,872 14,267,427 89,075,769 Change in net position 489,132 115,107 496,269 29,422 2,864 98,330 21,372 1,252,496 Total net position 21,570,351 $ 11,802,642 $ 40,315,254 $ 1,551,733 $ 112,284 $ 687,202 $ 14,288,799 $ 90,328,265 $ ---PAGE BREAK--- July 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 813,141 $ 341,975 $ 3,151,776 $ 176,889 $ 7,428 $ 120,896 $ 180,053 $ 4,792,158 $ Connection fees 155 100 77,475 ‐ ‐ ‐ ‐ 77,730 Miscellaneous 50 ‐ 160,040 (3,995) ‐ ‐ 460 156,555 Total operating revenues 813,346 342,075 3,389,291 172,894 7,428 120,896 180,513 5,026,443 Operating expenses: Wages and benefits 76,018 34,863 292,565 52,874 ‐ 3,698 28,881 488,899 Administrative fees 52,561 32,686 136,168 63 ‐ 9,275 7,817 238,570 Purchase power ‐ ‐ 1,861,156 ‐ ‐ ‐ ‐ 1,861,156 Operations and maintenance 81,240 122,433 135,623 48,389 4,628 1,264 17,850 411,427 Depreciation and amortization 85,459 39,302 252,055 12,532 ‐ 455 100,989 490,792 Total operating expenses 295,278 229,284 2,677,567 113,858 4,628 14,692 155,537 3,490,844 Operating income (loss) 518,068 112,791 711,724 59,036 2,800 106,204 24,976 1,535,599 Nonoperating revenues (expenses) Investment earnings 2,905 1,060 23,934 286 64 204 1,302 29,755 Interest and fiscal charges ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Impact fees 13,919 26,856 17,791 ‐ ‐ ‐ 3,229 61,795 Total nonoperating revenues (expenses) 16,824 27,916 41,725 286 64 204 4,531 91,550 Income (loss) before transfers 534,892 140,707 753,449 59,322 2,864 106,408 29,507 1,627,149 Transfers in ‐ 1,320 1,320 ‐ ‐ ‐ 1,251 3,891 Transfers out (39,122) (26,920) (236,708) ‐ ‐ (8,078) (9,386) (320,214) Change in net position 489,132 $ 115,107 $ 496,269 $ 29,422 $ 2,864 $ 98,330 $ 21,372 $ 1,252,496 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) July 31, 2014 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents 4,484 $ 1,597,534 $ Investments 68,451 ‐ Inventory 74,694 ‐ Total current assets 147,629 1,597,534 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (103,814) ‐ Total noncurrent assets 47,320 ‐ Total assets 194,949 1,597,534 Liabilities Current liabilities: Accrued Liabilities (4,358) 250,000 Compensated absences 22,455 7,033 Total current liabilities 18,097 257,033 Noncurrent liabilities: Compensated absences 9,751 3,054 Total noncurrent liabilities 9,751 3,054 Total liabilities 27,848 260,087 Net Assets Beginning net position 149,219 1,268,848 Change in net position 17,882 68,599 Total net position 167,101 $ 1,337,447 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) July 31, 2014 Central Garage Fund Operating revenues: Charges for services 39,893 $ Miscellaneous (229) Total operating revenues 39,664 Operating expenses: Wages and benefits 17,413 Administrative fees 63 Operations and maintenance 3,986 Depreciation and amortization 328 Total operating expenses 21,790 Operating income (loss) 17,874 Nonoperating revenues (expenses) Investment earnings 8 Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) 8 Income (loss) before transfers 17,882 Change in net position 17,882 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) July 31, 2014 Retained Risk Fund Operating revenues: Charges for services 83,988 $ Miscellaneous ‐ Total operating revenues 83,988 Operating expenses: Wages and benefits 11,594 Administrative fees 42 Operations and maintenance 288 Professional Fees ‐ Insurance 4,066 Claims by department: ADS ‐ Police ‐ Parks & Recreation ‐ Public Works ‐ Water ‐ Murray Park Golf ‐ Power ‐ Storm Water ‐ Total operating expenses 15,990 Operating income (loss) 67,998 Nonoperating revenues (expenses) Investment earnings 601 Total nonoperating revenues (expenses) 601 Income (loss) before transfers 68,599 Change in net position 68,599 $