Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) July 31, 2013 General Fund Library Capital Projects RDA MBA CDBG Cemetery Total Assets Cash and cash equivalents 7,500,787 $ 239,855 $ 8,461,699 $ 2,026,100 $ 1,851 $ (804) $ 1,364,140 $ 19,593,628 $ Accounts receivable (net) 8,148,210 1,464,738 ‐ 2,339,342 ‐ ‐ ‐ 11,952,290 Due from other governments 18,711 ‐ ‐ ‐ ‐ 804 ‐ 19,515 Prepaids 19,804 ‐ ‐ ‐ ‐ ‐ ‐ 19,804 Restricted cash 202 15,737 200,000 250,000 ‐ ‐ ‐ 465,939 Total assets 15,687,714 1,720,330 8,661,699 4,615,442 1,851 ‐ 1,364,140 32,051,176 Liabilities Accrued Liabilities 696,113 49 27,013 ‐ ‐ ‐ ‐ 723,175 Total liabilities 696,113 49 27,013 ‐ ‐ ‐ ‐ 723,175 Deferred Inflows of Resources Deferred Inflows‐ property taxes 6,014,202 1,464,738 ‐ 2,339,342 ‐ ‐ ‐ 9,818,282 Total deferred inflows of resources 6,014,202 1,464,738 ‐ 2,339,342 ‐ ‐ ‐ 9,818,282 Fund Balance Restricted 362,764 15,730 638,349 827,056 ‐ ‐ 520,000 2,363,899 Beginning fund balance 9,962,698 314,520 8,050,744 1,529,669 1,768 ‐ 839,593 20,698,992 Change in fund balance (1,348,063) (74,707) (54,407) (80,625) 83 ‐ 4,547 (1,553,172) Total fund balance 8,977,399 $ 255,543 $ 8,634,686 $ 2,276,100 $ 1,851 $ ‐ $ 1,364,140 $ 21,509,719 $ ---PAGE BREAK--- July 31, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) General Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Property tax ‐ $ ‐ $ 6,619,202 $ 6,619,202 $ (6,619,202) $ Sales tax ‐ ‐ 12,682,000 12,682,000 (12,682,000) Franchise tax 215,888 211,994 4,825,000 4,825,000 (4,613,006) Business license 56,254 53,702 645,000 645,000 (591,298) Building permits 45,639 86,426 518,000 518,000 (431,574) Fines and forfeitures 125,468 126,701 1,703,000 1,703,000 (1,576,299) Miscellaneous 15,747 11,294 187,000 187,000 (175,706) Sale of fixed assets 17,243 ‐ ‐ ‐ ‐ Intergovernmental 46,654 70,718 1,586,017 1,586,017 (1,515,299) Public safety 109,783 1,199 1,002,000 1,002,000 (1,000,801) Parks and recreation 296,789 287,779 1,504,500 1,504,500 (1,216,721) Transfers in 385,008 387,301 4,647,611 4,647,611 (4,260,310) Administrative fees 251,098 247,317 2,983,289 2,983,289 (2,735,972) Investment income 16,562 4,205 75,000 75,000 (70,795) Total revenue 1,582,133 1,488,636 38,977,619 38,977,619 Expenditures Payroll General Government 206,280 163,338 3,000,243 3,000,243 2,836,905 Police 423,643 448,805 8,278,453 8,278,453 7,829,648 Fire 349,164 324,417 5,953,177 5,953,177 5,628,760 Public works 93,264 100,884 1,645,816 1,645,816 1,544,932 Parks 247,265 255,186 3,628,515 3,628,515 3,373,329 ADS 198,813 214,196 3,796,992 3,796,992 3,582,796 Operations and maintenance General Government 180,346 375,179 1,549,596 1,549,596 1,174,417 Police 287,492 401,436 1,963,774 2,042,664 1,641,228 Fire 97,813 105,354 900,819 900,819 795,465 Public works 18,413 17,839 620,844 810,844 793,005 Class C 47,179 ‐ 428,000 428,000 428,000 Parks 216,749 141,568 1,970,029 1,970,029 1,828,461 ADS 202,253 62,612 1,314,604 1,314,604 1,251,992 Capital Outlay Class C 3,320 ‐ 879,000 879,000 879,000 Parks ‐ 2,361 ‐ ‐ (2,361) ADS 514 ‐ ‐ ‐ ‐ Debt Service Principle ‐ 86,066 1,255,000 1,255,000 1,168,934 UTOPIA payments 131,742 134,377 1,619,333 1,619,333 1,484,956 Interest and fiscal charge ‐ 175 363,551 363,551 363,376 Transfer out 2,906 2,906 2,034,873 2,034,873 2,031,967 Total Expenditures 2,707,156 2,836,699 41,202,619 41,471,509 Net change in fund balance (1,125,023) $ (1,348,063) $ ---PAGE BREAK--- July 31, 2013 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 1,858 2,794 45,000 45,000 (42,206) Miscellaneous 231 405 6,500 6,500 (6,095) Intergovernmental ‐ ‐ 12,500 12,500 (12,500) Investment income 396 151 6,000 6,000 (5,849) Total revenue 2,485 3,350 1,689,738 1,689,738 Expenditures Payroll 56,490 54,719 1,011,204 1,011,204 956,485 Operations and maintenance 54,142 13,366 503,871 503,871 490,505 Capital Outlay ‐ ‐ 55,000 55,000 55,000 Debt Service Principle ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ ‐ ‐ ‐ ‐ Administrative Fee 8,233 9,972 119,663 119,663 109,691 Total Expenditures 118,865 78,057 1,689,738 1,689,738 Net change in fund balance (116,380) $ (74,707) $ ---PAGE BREAK--- July 31, 2013 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,200,000 (2,200,000) Intergovernmental ‐ 725,000 725,000 (725,000) Sale of fixed assets ‐ ‐ ‐ ‐ Miscellaneous ‐ 425,000 425,000 (425,000) Investment income 2,786 ‐ ‐ 2,786 Total revenue 2,786 3,350,000 3,350,000 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police ‐ 59,320 59,320 59,320 Fire ‐ 36,420 36,420 36,420 Public works 7,331 362,313 363,865 356,534 Parks ‐ 43,000 43,000 43,000 ADS ‐ 110,500 110,500 110,500 Capital Outlay General Government ‐ ‐ ‐ ‐ Police ‐ 57,700 57,700 57,700 Fire ‐ 217,282 217,282 217,282 Public works ‐ 1,636,000 1,634,448 1,634,448 Parks 45,000 139,000 139,000 94,000 ADS ‐ 466,120 466,120 466,120 Transfer out ‐ ‐ ‐ ‐ Total Expenditures 57,193 3,156,155 3,156,155 Net change in fund balance (54,407) $ ---PAGE BREAK--- July 31, 2013 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,339,342 $ 2,339,342 $ (2,339,342) $ Miscellaneous ‐ ‐ ‐ ‐ ‐ Investment income 1,004 890 8,000 8,000 (7,110) Total revenue 1,004 890 2,347,342 2,347,342 Expenditures Operations and maintenance 380 319 1,243,091 1,243,091 1,242,772 Capital Outlay ‐ ‐ 280,000 280,000 280,000 Debt Service Principle ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ ‐ ‐ ‐ ‐ Administrative Fee 6,417 9,176 110,118 110,118 100,942 Transfer out 74,845 72,020 1,064,246 1,064,246 992,226 Total Expenditures 81,642 81,515 2,697,455 2,697,455 Net change in fund balance (80,638) $ (80,625) $ ---PAGE BREAK--- July 31, 2013 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 83 $ 83 $ 1,000 $ 1,000 $ (917) $ Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue 83 83 1,000 1,000 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Debt Service Principle ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ ‐ 1,000 1,000 1,000 Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ 1,000 1,000 Net change in fund balance 83 $ 83 $ ---PAGE BREAK--- July 31, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) CDBG Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Intergovernmental 3,292 $ ‐ $ 116,679 $ 116,679 $ (116,679) $ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue 3,292 ‐ 116,679 116,679 Expenditures Operations and maintenance ‐ ‐ 101,178 101,178 101,178 Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ 15,501 15,501 15,501 Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ 116,679 116,679 Net change in fund balance 3,292 $ ‐ $ ---PAGE BREAK--- July 31, 2013 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,823 $ 33,873 $ 33,873 $ (31,050) $ Miscellaneous 450 1,150 ‐ ‐ 1,150 Investment income 856 574 7,000 7,000 (6,426) Total revenue 4,129 4,547 40,873 40,873 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 4,129 $ 4,547 $ ---PAGE BREAK--- July 31, 2013 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 5,763,291 $ 2,180,574 $ 12,039,001 $ 653,911 $ 100,866 $ 490,046 $ 1,083,083 $ 22,310,772 $ Accounts receivable (net) 613,506 227,813 3,101,297 ‐ 4,167 62,749 78,569 4,088,101 Notes receivable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Due from other funds 164,776 ‐ ‐ ‐ ‐ ‐ ‐ 164,776 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,111,383 84,507 ‐ ‐ ‐ 2,195,890 Total current assets 6,541,573 2,519,537 17,251,681 738,418 523,623 552,795 1,161,652 29,289,279 Noncurrent assets: Restricted cash 15 123,947 295 ‐ ‐ ‐ 3,084,144 3,208,401 Investment in joint venture ‐ 3,296,433 ‐ ‐ ‐ ‐ ‐ 3,296,433 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,243,203 3,734,149 ‐ ‐ 32,791,516 148,855,519 Machinery and equipment 3,110,450 1,231,707 12,424,002 926,244 ‐ ‐ 1,141,285 18,833,688 Intangibles ‐ ‐ 4,309,027 ‐ ‐ ‐ ‐ 4,309,027 Construction in progress 550,926 1,270,950 ‐ ‐ ‐ ‐ 236,190 2,058,066 Accumulated depreciation (14,507,473) (6,340,995) (58,307,376) (4,684,326) ‐ ‐ (22,881,899) (106,722,069) Total noncurrent assets 17,608,581 11,678,420 39,771,112 1,099,937 ‐ ‐ 16,716,085 86,874,135 Deferred Outflows of Resources Bond defeasance costs ‐ ‐ 131,513 ‐ ‐ ‐ ‐ 131,513 Total deferred outflows of resources ‐ ‐ 131,513 ‐ ‐ ‐ ‐ 131,513 Total assets & deferred outflows of resources 24,150,154 14,197,957 57,154,306 1,838,355 523,623 552,795 17,877,737 116,294,927 Liabilities Current liabilities: Accrued Liabilities 25,219 81,630 4,235,182 13,467 ‐ ‐ ‐ 4,355,498 Due to other funds ‐ ‐ ‐ 164,776 ‐ ‐ ‐ 164,776 Notes payable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Interest payable 25,237 21,523 49,017 ‐ ‐ ‐ 25,421 121,198 Compensated absences 139,994 60,921 368,312 71,739 ‐ 2,038 36,985 679,989 Bonds & leases payable 284,777 272,223 1,545,000 ‐ ‐ ‐ 210,000 2,312,000 Total current liabilities 475,227 436,297 6,197,511 249,982 418,590 2,038 272,406 8,052,051 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 3,150,446 2,811,172 13,040,883 ‐ ‐ ‐ 2,897,326 21,899,827 Total noncurrent liabilities 3,323,674 2,846,489 13,591,955 41,588 ‐ 1,182 2,918,768 22,723,656 Total liabilities 3,798,901 3,282,786 19,789,466 291,570 418,590 3,220 3,191,174 30,775,707 Net Position Beginning net position 19,688,332 10,803,893 36,387,176 1,464,610 105,065 454,154 14,662,743 83,565,973 Change in net position 662,921 111,278 977,664 82,175 (32) 95,421 23,820 1,953,247 Total net position 20,351,253 $ 10,915,171 $ 37,364,840 $ 1,546,785 $ 105,033 $ 549,575 $ 14,686,563 $ 85,519,220 $ ---PAGE BREAK--- July 31, 2013 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 954,460 $ 333,249 $ 3,583,454 $ 184,991 $ 6,583 $ 115,103 $ 177,563 $ 5,355,403 $ Connection fees 585 325 81,938 ‐ ‐ ‐ ‐ 82,848 Miscellaneous 250 ‐ 134,722 (3,459) ‐ ‐ ‐ 131,513 Total operating revenues 955,295 333,574 3,800,114 181,532 6,583 115,103 177,563 5,569,764 Operating expenses: Wages and benefits 77,201 40,675 288,071 56,032 ‐ 2,508 28,933 493,420 Administrative fees 48,651 31,652 130,771 63 ‐ 9,479 7,448 228,064 Purchase power ‐ ‐ 1,720,818 ‐ ‐ ‐ ‐ 1,720,818 Operations and maintenance 64,674 96,525 210,289 30,278 6,667 1,179 4,893 414,505 Depreciation and amortization 85,097 35,439 268,099 13,229 ‐ ‐ 99,875 501,739 Total operating expenses 275,623 204,291 2,618,048 99,602 6,667 13,166 141,149 3,358,546 Operating income (loss) 679,672 129,283 1,182,066 81,930 (84) 101,937 36,414 2,211,218 Nonoperating revenues (expenses) Investment earnings 2,296 896 18,243 245 52 213 1,706 23,651 Interest and fiscal charges ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Impact fees 24,093 7,052 12,645 ‐ ‐ ‐ 2,213 46,003 Gain (loss) on sale of fixed assets ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total nonoperating revenues (expenses) 26,389 7,948 30,888 245 52 213 3,919 69,654 Income (loss) before transfers 706,061 137,231 1,212,954 82,175 (32) 102,150 40,333 2,280,872 Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers in ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers out (37,973) (25,953) (235,290) ‐ ‐ (6,729) (9,336) (315,281) Change in net position 662,921 $ 111,278 $ 977,664 $ 82,175 $ (32) $ 95,421 $ 23,820 $ 1,953,247 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) July 31, 2013 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents (4,617) $ 1,512,119 $ Accounts receivable (net) ‐ ‐ Due from other funds ‐ ‐ Due from other governments ‐ ‐ Inventory 67,256 ‐ Prepaid items ‐ ‐ Total current assets 62,639 1,512,119 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (99,879) ‐ Total noncurrent assets 51,255 ‐ Total assets 113,894 1,512,119 Liabilities Current liabilities: Accrued Liabilities ‐ 251,473 Compensated absences 21,101 4,474 Total current liabilities 21,101 255,947 Noncurrent liabilities: Compensated absences 9,698 2,057 Net OPEB payable ‐ ‐ Total noncurrent liabilities 9,698 2,057 Total liabilities 30,799 258,004 Net Assets Beginning net position 69,476 1,371,921 Change in net position 13,619 (117,806) Total net position 83,095 $ 1,254,115 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) July 31, 2013 Central Garage Fund Operating revenues: Charges for services 29,785 $ Miscellaneous ‐ Total operating revenues 29,785 Operating expenses: Wages and benefits 17,216 Administrative fees 62 Operations and maintenance (1,440) Depreciation and amortization 328 Total operating expenses 16,166 Operating income (loss) 13,619 Nonoperating revenues (expenses) Investment earnings ‐ Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) ‐ Income (loss) before transfers 13,619 Change in net position 13,619 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) July 31, 2013 Retained Risk Fund Operating revenues: Charges for services 75,141 $ Miscellaneous ‐ Total operating revenues 75,141 Operating expenses: Wages and benefits 7,042 Administrative fees 42 Operations and maintenance 13,071 Legal Fees ‐ Insurance 173,406 Claims by department: Fire ‐ Police ‐ Parks & Recreation ‐ Public Works ‐ Waste Water ‐ Power ‐ Murray Park Golf ‐ Total operating expenses 193,561 Operating income (loss) (118,420) Nonoperating revenues (expenses) Investment earnings 614 Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) 614 Income (loss) before transfers (117,806) Transfers in ‐ Transfers out ‐ Change in net position (117,806) $