Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) August 31, 2013 General Fund Library Capital Projects RDA MBA CDBG Cemetery Total Assets Cash and cash equivalents 7,787,327 $ 119,551 $ 10,773,688 $ 1,930,324 $ 1,934 $ ‐ $ 1,367,536 $ 21,980,360 $ Accounts receivable (net) 6,469,833 1,464,738 ‐ 2,339,342 ‐ ‐ ‐ 10,273,913 Due from other governments 18,711 ‐ ‐ ‐ ‐ ‐ ‐ 18,711 Prepaids 39,635 ‐ ‐ ‐ ‐ ‐ ‐ 39,635 Restricted cash 70,673 15,744 200,000 250,000 ‐ ‐ ‐ 536,417 Total assets 14,386,179 1,600,033 10,973,688 4,519,666 1,934 ‐ 1,367,536 32,849,036 Liabilities Accrued Liabilities 783,392 48 ‐ ‐ ‐ ‐ ‐ 783,440 Total liabilities 783,392 48 ‐ ‐ ‐ ‐ ‐ 783,440 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 (2,736,877) (195,003) 2,284,595 (176,401) 166 ‐ 7,943 (815,577) Total fund balance 7,588,585 $ 135,247 $ 10,973,688 $ 2,180,324 $ 1,934 $ ‐ $ 1,367,536 $ 22,247,314 $ ---PAGE BREAK--- August 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 79,363 $ 85,988 $ 6,619,202 $ 6,619,202 $ (6,533,214) $ Sales tax ‐ ‐ 12,682,000 12,682,000 (12,682,000) Franchise tax 609,409 521,757 4,825,000 4,825,000 (4,303,243) Business license 107,269 103,392 645,000 645,000 (541,608) Building permits 110,829 226,343 518,000 518,000 (291,657) Fines and forfeitures 274,556 245,992 1,703,000 1,703,000 (1,457,008) Miscellaneous 28,867 27,900 187,000 187,000 (159,100) Sale of fixed assets 42,924 ‐ ‐ ‐ ‐ Intergovernmental 48,454 104,118 1,586,017 1,586,017 (1,481,899) Public safety 205,486 99,183 1,002,000 1,002,000 (902,817) Parks and recreation 438,470 429,351 1,504,500 1,504,500 (1,075,149) Transfers in 770,016 774,602 4,647,611 4,647,611 (3,873,009) Administrative fees 502,196 494,634 2,983,289 2,983,289 (2,488,655) Investment income 32,908 7,656 75,000 75,000 (67,344) Total revenue 3,250,747 3,120,916 38,977,619 38,977,619 Expenditures Payroll General Government 420,758 384,535 3,000,243 3,000,243 2,615,708 Police 993,436 1,047,506 8,278,453 8,278,453 7,230,947 Fire 788,860 759,718 5,953,177 5,953,177 5,193,459 Public works 222,952 232,123 1,645,816 1,645,816 1,413,693 Parks 570,457 579,581 3,628,515 3,628,515 3,048,934 ADS 465,795 488,553 3,796,992 3,796,992 3,308,439 Operations and maintenance General Government 239,317 467,242 1,549,596 1,549,596 1,082,354 Police 531,949 553,575 1,963,774 2,042,664 1,489,089 Fire 141,681 151,762 900,819 900,819 749,057 Public works 69,291 50,634 620,844 810,844 760,210 Class C 62,717 ‐ 428,000 428,000 428,000 Parks 474,627 455,012 1,970,029 1,970,029 1,515,017 ADS 309,841 312,551 1,314,604 1,314,604 1,002,053 Capital Outlay Class C 54,032 11,833 879,000 879,000 867,167 Parks ‐ 2,361 ‐ ‐ (2,361) ADS ‐ ‐ ‐ ‐ ‐ Debt Service Principle ‐ 86,066 1,255,000 1,255,000 1,168,934 UTOPIA payments 263,485 268,754 1,619,333 1,619,333 1,350,579 Interest and fiscal charge ‐ 175 363,551 363,551 363,376 Transfer out 5,812 5,812 2,034,873 2,034,873 2,029,061 Total Expenditures 5,615,010 5,857,793 41,202,619 41,471,509 Net change in fund balance (2,364,263) $ (2,736,877) $ ---PAGE BREAK--- August 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 19,302 $ 20,917 $ 1,619,738 $ 1,619,738 $ (1,598,821) $ Fines and forfeitures 5,870 8,365 45,000 45,000 (36,635) Miscellaneous 788 1,103 6,500 6,500 (5,397) Intergovernmental ‐ ‐ 12,500 12,500 (12,500) Investment income 738 330 6,000 6,000 (5,670) Total revenue 26,698 30,715 1,689,738 1,689,738 Expenditures Payroll 132,716 129,862 1,011,204 1,011,204 881,342 Operations and maintenance 80,985 75,912 503,871 503,871 427,959 Capital Outlay 1,481 ‐ 55,000 55,000 55,000 Administrative Fee 16,466 19,944 119,663 119,663 99,719 Total Expenditures 231,648 225,718 1,689,738 1,689,738 Net change in fund balance (204,950) $ (195,003) $ ---PAGE BREAK--- August 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 2,525,000 725,000 725,000 1,800,000 Sale of fixed assets ‐ ‐ ‐ ‐ Miscellaneous ‐ 425,000 425,000 (425,000) Investment income 6,919 ‐ ‐ 6,919 Total revenue 2,531,919 3,350,000 3,350,000 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police ‐ 59,320 59,320 59,320 Fire 2,457 36,420 36,420 33,963 Public works 81,586 362,313 363,865 282,279 Parks 11,455 43,000 43,000 31,545 ADS ‐ 110,500 110,500 110,500 Capital Outlay General Government ‐ ‐ ‐ ‐ Police ‐ 57,700 57,700 57,700 Fire 99,865 217,282 217,282 117,417 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 247,324 3,156,155 3,156,155 Net change in fund balance 2,284,595 $ ---PAGE BREAK--- August 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,889 1,668 8,000 8,000 (6,332) Total revenue 1,889 1,668 2,347,342 2,347,342 Expenditures Operations and maintenance 5,532 15,677 1,243,091 1,243,091 1,227,414 Capital Outlay ‐ ‐ 280,000 280,000 280,000 Debt Service Principle ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ ‐ ‐ ‐ ‐ Administrative Fee 12,834 18,352 110,118 110,118 91,766 Transfer out 149,690 144,040 1,064,246 1,064,246 920,206 Total Expenditures 168,056 178,069 2,697,455 2,697,455 Net change in fund balance (166,167) $ (176,401) $ ---PAGE BREAK--- August 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 166 $ 166 $ 1,000 $ 1,000 $ (834) $ Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue 166 166 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 166 $ 166 $ ---PAGE BREAK--- August 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 (190) $ ‐ $ 116,679 $ 116,679 $ (116,679) $ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue (190) ‐ 116,679 116,679 Expenditures Operations and maintenance 511 ‐ 101,178 101,178 101,178 Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ 15,501 15,501 15,501 Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures 511 ‐ 116,679 116,679 Net change in fund balance (701) $ ‐ $ ---PAGE BREAK--- August 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 5,646 $ 5,646 $ 33,873 $ 33,873 $ (28,227) $ Miscellaneous 550 1,150 ‐ ‐ 1,150 Investment income 1,743 1,147 7,000 7,000 (5,853) Total revenue 7,939 7,943 40,873 40,873 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 7,939 $ 7,943 $ ---PAGE BREAK--- August 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,842,641 $ 1,943,188 $ 11,695,644 $ 724,189 $ 101,033 $ 490,642 $ 871,742 $ 21,669,079 $ Accounts receivable (net) 621,335 244,806 3,383,017 ‐ 4,060 67,898 80,974 4,402,090 Notes receivable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Due from other funds 164,776 ‐ ‐ ‐ ‐ ‐ ‐ 164,776 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,090,115 84,507 ‐ ‐ ‐ 2,174,622 Total current assets 6,628,752 2,299,144 17,168,776 808,696 523,683 558,540 952,716 28,940,307 Noncurrent assets: Restricted cash 335,249 456,811 295 ‐ ‐ ‐ 3,051,742 3,844,097 Investment in joint venture ‐ 3,297,248 ‐ ‐ ‐ ‐ ‐ 3,297,248 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,592,570) (6,376,434) (58,589,909) (4,697,554) ‐ ‐ (22,981,774) (107,238,241) Total noncurrent assets 17,858,718 11,976,660 39,488,579 1,086,709 ‐ ‐ 16,583,808 86,994,474 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,487,470 14,275,804 56,788,868 1,895,405 523,683 558,540 17,536,524 116,066,294 Liabilities Current liabilities: Accrued Liabilities 19,399 87,431 2,929,543 12,964 ‐ ‐ ‐ 3,049,337 Due to other funds ‐ ‐ ‐ 164,776 ‐ ‐ ‐ 164,776 Notes payable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Interest payable 25,237 21,523 49,017 ‐ ‐ ‐ 25,420 121,197 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 469,407 442,098 4,891,872 249,479 418,590 2,038 272,405 6,745,889 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,793,081 3,288,587 18,483,827 291,067 418,590 3,220 3,191,173 29,469,545 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 1,006,057 183,324 1,917,865 139,728 28 101,166 (317,392) 3,030,776 Total net position 20,694,389 $ 10,987,217 $ 38,305,041 $ 1,604,338 $ 105,093 $ 555,320 $ 14,345,351 $ 86,596,749 $ ---PAGE BREAK--- August 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 1,819,203 $ 670,410 $ 7,543,479 $ 381,917 $ 10,743 $ 227,413 $ 275,356 $ 10,928,521 $ Connection fees 6,333 475 85,590 ‐ ‐ ‐ ‐ 92,398 Miscellaneous 450 ‐ 272,221 (5,570) ‐ ‐ ‐ 267,101 Total operating revenues 1,825,986 670,885 7,901,290 376,347 10,743 227,413 275,356 11,288,020 Operating expenses: Wages and benefits 172,053 92,138 675,609 124,270 ‐ 6,883 66,167 1,137,120 Administrative fees 97,302 63,304 261,542 126 ‐ 18,958 14,896 456,128 Purchase power ‐ ‐ 3,671,597 ‐ ‐ ‐ ‐ 3,671,597 Operations and maintenance 207,208 204,675 438,447 61,074 10,783 87,333 14,628 1,024,148 Depreciation and amortization 170,194 70,878 536,198 26,457 ‐ ‐ 199,750 1,003,477 Total operating expenses 646,757 430,995 5,583,393 211,927 10,783 113,174 295,441 7,292,470 Operating income (loss) 1,179,229 239,890 2,317,897 164,420 (40) 114,239 (20,085) 3,995,550 Nonoperating revenues (expenses) Investment earnings 4,612 1,747 36,420 505 68 385 3,474 47,211 Interest and fiscal charges ‐ ‐ ‐ ‐ ‐ ‐ (33,742) (33,742) Impact fees 29,447 75,309 60,374 ‐ ‐ ‐ 3,397 168,527 Gain (loss) on sale of fixed assets ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Total nonoperating revenues (expenses) 34,059 77,056 96,794 505 68 385 (26,871) 181,996 Income (loss) before transfers 1,213,288 316,946 2,414,691 164,925 28 114,624 (46,956) 4,177,546 Transfers in ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Transfers out (75,946) (51,906) (470,580) ‐ ‐ (13,458) (18,672) (630,562) Change in net position 1,006,057 $ 183,324 $ 1,917,865 $ 139,728 $ 28 $ 101,166 $ (317,392) $ 3,030,776 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) August 31, 2013 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents (12,438) $ 1,561,465 $ Accounts receivable (net) ‐ ‐ Due from other funds ‐ ‐ Due from other governments ‐ ‐ Inventory 69,397 ‐ Prepaid items ‐ ‐ Total current assets 56,959 1,561,465 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (100,207) ‐ Total noncurrent assets 50,927 ‐ Total assets 107,886 1,561,465 Liabilities Current liabilities: Accrued Liabilities ‐ 266,405 Compensated absences 21,101 4,474 Total current liabilities 21,101 270,879 Noncurrent liabilities: Compensated absences 9,698 2,057 Net OPEB payable ‐ ‐ Total noncurrent liabilities 9,698 2,057 Total liabilities 30,799 272,936 Net Assets Beginning net position 69,476 1,371,921 Change in net position 7,611 (83,392) Total net position 77,087 $ 1,288,529 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) August 31, 2013 Central Garage Fund Operating revenues: Charges for services 58,835 $ Miscellaneous ‐ Total operating revenues 58,835 Operating expenses: Wages and benefits 39,973 Administrative fees 126 Operations and maintenance 10,469 Depreciation and amortization 656 Total operating expenses 51,224 Operating income (loss) 7,611 Nonoperating revenues (expenses) Investment earnings ‐ Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) ‐ Income (loss) before transfers 7,611 Change in net position 7,611 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) August 31, 2013 Retained Risk Fund Operating revenues: Charges for services 150,282 $ Miscellaneous ‐ Total operating revenues 150,282 Operating expenses: Wages and benefits 16,651 Administrative fees 84 Operations and maintenance 13,214 Legal Fees 15,147 Insurance 173,406 Claims by department: Fire ‐ Police ‐ Parks & Recreation ‐ Public Works 16,405 Water ‐ Waste Water ‐ Power ‐ Murray Park Golf ‐ Storm Water ‐ Total operating expenses 234,907 Operating income (loss) (84,625) Nonoperating revenues (expenses) Investment earnings 1,233 Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) 1,233 Income (loss) before transfers (83,392) Transfers in ‐ Transfers out ‐ Change in net position (83,392) $