Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) August 31, 2014 General Fund Library Capital Projects RDA CDBG Cemetery Total Assets Cash and cash equivalents 6,195,610 $ 166,610 $ 7,377,823 $ 2,287,077 $ ‐ $ 1,411,194 $ 17,438,314 $ Investments 3,009,853 ‐ 3,009,853 ‐ ‐ ‐ 6,019,706 Accounts receivable (net) 4,954,963 1,460,991 ‐ 3,074,312 ‐ ‐ 9,490,266 Due from other governments ‐ ‐ ‐ ‐ ‐ ‐ ‐ Prepaids 27,684 ‐ ‐ ‐ ‐ ‐ 27,684 Restricted cash 60,175 15,822 104,521 324,562 ‐ ‐ 505,080 Total assets 14,248,285 1,643,423 10,492,197 5,685,951 ‐ 1,411,194 33,481,050 Liabilities Accrued Liabilities 652,936 45 ‐ 401,000 ‐ ‐ 1,053,981 Due to other funds ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total liabilities 652,936 45 ‐ 401,000 ‐ ‐ 1,053,981 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,348 827,056 ‐ 520,000 2,363,898 Beginning fund balance 9,976,538 321,813 9,699,425 1,558,836 ‐ 883,958 22,440,570 Change in fund balance (2,948,619) (155,156) 154,424 (175,253) ‐ 7,236 (3,117,368) Total fund balance 7,446,183 $ 182,387 $ 10,492,197 $ 2,210,639 $ ‐ $ 1,411,194 $ 21,742,600 $ ---PAGE BREAK--- August 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 85,988 81,466 6,618,221 6,618,221 (6,536,755) Transfers in 774,602 777,634 4,665,816 4,665,816 (3,888,182) Franchise tax 521,757 505,483 4,842,000 4,842,000 (4,336,517) Administrative fees 494,634 517,584 3,105,489 3,105,489 (2,587,905) Parks and recreation 429,351 415,863 1,564,500 1,564,500 (1,148,637) Fines and forfeitures 245,992 270,844 1,818,000 1,818,000 (1,547,156) Intergovernmental 104,118 34,646 1,609,284 1,649,662 (1,615,016) Public safety 99,183 231,189 1,039,500 1,039,500 (808,311) Business license 103,392 102,445 655,000 655,000 (552,555) Building permits 226,343 152,837 525,250 525,250 (372,413) Miscellaneous 27,900 37,762 226,500 226,500 (188,738) Investment income 7,657 9,786 60,000 60,000 (50,214) Total revenue 3,120,917 3,137,539 39,673,263 39,713,641 Expenditures Payroll General Government 384,535 407,717 3,174,759 3,178,259 2,770,542 Police 1,047,506 1,040,973 8,369,388 8,369,388 7,328,415 Fire 759,718 810,963 6,122,724 6,131,224 5,320,261 Public works 232,123 238,548 1,718,878 1,718,878 1,480,330 Parks 579,581 577,091 3,717,183 3,717,183 3,140,092 ADS 488,553 499,435 3,959,412 3,959,412 3,459,977 Operations and maintenance General Government 467,242 449,996 1,024,356 1,322,522 872,526 Police 390,239 410,558 1,713,702 1,818,963 1,408,405 Fire 79,805 118,144 821,482 821,482 703,338 Emergency 911 Services 235,293 251,070 503,620 503,620 252,550 Public works 50,634 63,776 834,732 834,732 770,956 Class C ‐ 17,003 325,000 325,000 307,997 Parks 455,012 418,941 2,056,046 2,056,046 1,637,105 ADS 312,551 225,676 1,293,334 1,293,334 1,067,658 Capital Outlay Class C 11,833 190,406 1,000,000 1,068,298 877,892 Parks 2,361 ‐ ‐ 16,000 16,000 Debt Service Principal 86,066 83,565 1,278,566 1,278,566 1,195,001 UTOPIA payments 268,754 274,129 1,647,520 1,647,520 1,373,391 Interest and fiscal charge 175 2,501 308,061 308,061 305,560 Transfer out 5,812 5,666 34,000 34,000 28,334 Total Expenditures 5,857,793 6,086,158 39,902,763 40,402,488 Net change in fund balance (2,736,876) $ (2,948,619) $ ---PAGE BREAK--- August 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 20,917 $ 19,840 $ 1,619,738 $ 1,619,738 $ (1,599,898) $ Fines and forfeitures 8,365 8,605 45,000 45,000 (36,395) Miscellaneous 1,103 1,137 6,500 6,500 (5,363) Intergovernmental ‐ 38,300 12,000 50,300 (12,000) Investment income 330 269 6,131 6,131 (5,862) Total revenue 30,715 68,151 1,689,369 1,727,669 Expenditures Payroll 129,862 140,559 1,036,140 1,036,140 895,581 Operations and maintenance 75,912 52,894 473,404 511,704 458,810 Capital Outlay ‐ ‐ 55,000 55,000 55,000 Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ ‐ ‐ ‐ ‐ Transfer out ‐ 9,050 ‐ 9,050 ‐ Administrative Fee 19,944 20,804 124,825 124,825 104,021 Total Expenditures 225,718 223,307 1,689,369 1,736,719 Net change in fund balance (195,003) $ (155,156) $ ---PAGE BREAK--- August 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 49,847 ‐ 959,847 (910,000) Investment income 10,186 ‐ ‐ 10,186 Total revenue 466,749 200,000 1,566,563 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police ‐ 85,500 85,500 85,500 Fire 7,167 42,800 42,800 35,633 Public works 2,970 192,392 252,392 249,422 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 67,107 732,000 2,767,870 2,700,763 Parks 13,175 475,000 475,000 461,825 ADS 84,044 219,602 1,032,318 948,274 Debt Service Principal 4,197 24,139 24,139 19,942 Interest and fiscal charge ‐ 1,050 1,050 1,050 Transfer out 834 5,000 5,000 4,166 Total Expenditures 312,325 2,745,346 5,753,932 Net change in fund balance 154,424 $ ---PAGE BREAK--- August 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 1,668 1,862 9,500 9,500 (7,638) Total revenue 1,668 3,131 3,083,812 3,083,812 Expenditures Operations and maintenance 15,677 1,358 1,670,778 1,670,778 1,669,420 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 18,352 19,430 116,567 116,567 97,137 Transfer out 144,040 157,596 1,064,937 1,078,379 920,783 Total Expenditures 178,069 178,384 3,236,322 3,499,764 Net change in fund balance (176,401) $ (175,253) $ ---PAGE BREAK--- August 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--- August 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 5,646 $ 5,666 $ 34,000 $ 34,000 $ (28,334) $ Miscellaneous 1,150 450 ‐ ‐ 450 Investment income 1,147 1,120 8,000 8,000 (6,880) Total revenue 7,943 7,236 42,000 42,000 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 7,943 $ 7,236 $ ---PAGE BREAK--- August 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,661,107 $ 2,313,161 $ 7,873,590 $ 804,084 $ 104,507 $ 516,291 $ 502,575 $ 15,775,315 $ Investments 2,006,569 ‐ 4,013,138 ‐ ‐ ‐ ‐ 6,019,707 Accounts receivable (net) 919,449 314,787 4,095,959 ‐ 7,869 106,861 141,022 5,585,947 Notes receivable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Due from other funds 125,095 ‐ ‐ ‐ ‐ ‐ ‐ 125,095 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,278,253 84,507 ‐ ‐ ‐ 2,362,760 Total current assets 6,712,220 2,739,098 18,260,940 888,591 530,966 623,152 643,597 30,398,564 Noncurrent assets: Restricted cash 80,530 1,015,504 1,388 ‐ ‐ ‐ 1,948,366 3,045,788 Investment in joint venture ‐ 3,404,271 ‐ ‐ ‐ ‐ ‐ 3,404,271 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,163,549) (6,677,760) (60,376,644) (4,809,167) ‐ (4,267) (24,163,815) (111,195,202) Total noncurrent assets 18,290,203 12,476,814 37,767,191 988,860 ‐ 50,346 16,116,092 85,689,506 Liabilities Current liabilities: Accrued Liabilities 10,260 80,313 3,487,681 12,446 ‐ ‐ ‐ 3,590,700 Due to other funds ‐ ‐ ‐ 125,095 ‐ ‐ ‐ 125,095 Notes payable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Interest payable 19,924 29,310 33,777 ‐ ‐ ‐ ‐ 83,011 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 192,844 301,341 5,140,179 216,150 418,590 2,522 247,739 6,519,365 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,218,530 3,363,901 13,932,652 260,683 418,590 3,952 2,945,713 24,144,021 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 702,674 164,476 2,276,494 94,457 2,956 80,674 (453,451) 2,868,280 Total net position 21,783,893 $ 11,852,011 $ 42,095,479 $ 1,616,768 $ 112,376 $ 669,546 $ 13,813,976 $ 91,944,049 $ ---PAGE BREAK--- August 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 1,706,807 $ 687,452 $ 7,206,155 $ 365,621 $ 12,138 $ 234,207 $ 291,214 $ 10,503,594 $ Connection fees 3,074 300 83,025 ‐ ‐ ‐ ‐ 86,399 Miscellaneous 519 ‐ 167,161 (8,317) ‐ ‐ 460 159,823 Total operating revenues 1,710,400 687,752 7,456,341 357,304 12,138 234,207 291,674 10,749,816 Operating expenses: Wages and benefits 179,340 82,461 685,704 121,432 ‐ 10,366 66,858 1,146,161 Administrative fees 105,122 65,372 272,336 126 ‐ 18,550 15,634 477,140 Purchase power ‐ ‐ 2,769,770 ‐ ‐ ‐ ‐ 2,769,770 Operations and maintenance 194,758 213,595 330,068 79,965 9,291 85,981 33,780 947,438 Depreciation and amortization 170,917 78,603 504,110 25,065 ‐ 910 201,977 981,582 Total operating expenses 650,137 440,031 4,561,988 226,588 9,291 115,807 318,249 6,322,091 Operating income (loss) 1,060,263 247,721 2,894,353 130,716 2,847 118,400 (26,575) 4,427,725 Nonoperating revenues (expenses) Investment earnings 5,877 2,133 41,944 581 109 405 2,315 53,364 Interest and fiscal charges ‐ ‐ ‐ ‐ ‐ ‐ (9,440) (9,440) Impact fees 29,981 32,344 29,033 ‐ ‐ ‐ 3,229 94,587 Total nonoperating revenues (expenses) 35,858 34,477 70,977 581 109 405 (3,896) 138,511 Income (loss) before transfers 1,096,121 282,198 2,965,330 131,297 2,956 118,805 (30,471) 4,566,236 Transfers in ‐ 2,640 2,640 ‐ ‐ ‐ 2,502 7,782 Transfers out (137,555) (105,402) (669,596) (6,940) ‐ (38,131) (60,151) (1,017,775) Change in net position 702,674 $ 164,476 $ 2,276,494 $ 94,457 $ 2,956 $ 80,674 $ (453,451) $ 2,868,280 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) August 31, 2014 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents 12,962 $ 1,475,661 $ Investments 68,451 ‐ Inventory 76,324 ‐ Total current assets 157,737 1,475,661 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (104,142) ‐ Total noncurrent assets 46,992 ‐ Total assets 204,729 1,475,661 Liabilities Current liabilities: Accrued Liabilities ‐ 250,000 Compensated absences 22,455 7,033 Total current liabilities 22,455 257,033 Noncurrent liabilities: Compensated absences 9,750 3,053 Total noncurrent liabilities 9,750 3,053 Total liabilities 32,205 260,086 Net Assets Beginning net position 149,219 1,268,848 Change in net position 23,305 (53,273) Total net position 172,524 $ 1,215,575 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) August 31, 2014 Central Garage Fund Operating revenues: Charges for services 75,473 $ Miscellaneous ‐ Total operating revenues 75,473 Operating expenses: Wages and benefits 41,507 Administrative fees 126 Operations and maintenance 7,576 Depreciation and amortization 656 Total operating expenses 49,865 Operating income (loss) 25,608 Nonoperating revenues (expenses) Investment earnings 8 Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) 8 Income (loss) before transfers 25,616 Change in net position 23,305 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) August 31, 2014 Retained Risk Fund Operating revenues: Charges for services 167,976 $ Miscellaneous ‐ Total operating revenues 167,976 Operating expenses: Wages and benefits 28,311 Administrative fees 84 Operations and maintenance 4,000 Professional Fees 5,199 Insurance 173,086 Claims by department: ADS ‐ Police 1,304 Fire 2,443 Murray Park Golf 182 Power 3,214 Storm Water ‐ Total operating expenses 217,823 Operating income (loss) (49,847) Nonoperating revenues (expenses) Investment earnings 1,140 Total nonoperating revenues (expenses) 1,140 Income (loss) before transfers (48,707) Change in net position (53,273) $