No preview available
HomeMy WebLinkAboutAugust 2014 - Financial Statements HARNETT COUNTY FINANCIAL SUMMARY REPORT August, 2014 GENERAL FUND FYE 2015 Activity (includes 2014 - 2015 2014 - 2015 Original BudgetAdjusted Budgetencumbrances) DepartmentFYE 2013FYE 2014 Governing Body $ 180,854 $ 164,631 $ 188,313 $ 188,313 $ 51,155 Administration 339,722 250,759 298,463 295,629 76,179 Legal Services 122,070 103,351 120,966 119,294 53,976 Engineering - 1 - - 9,353 Human Resources 224,821 254,738 274,623 272,012 55,618 Board of Elections 357,108 303,532 365,189 358,674 56,860 Finance 961,984 729,469 897,440 877,440 154,923 Clerk of Court 98,086 77,704 90,842 89,554 15,597 Tax 1,664,758 1,569,231 1,767,369 1,741,896 237,400 General Services 473,759 140,485 154,752 153,902 25,133 Fleet Maintenance - 438,847 701,293 700,730 75,639 Transportation 940,206 1,004,266 1,435,000 1,421,900 56,158 Transportation - Admin 188,721 194,790 225,479 219,288 28,380 Facilities Maintenance 3,285,478 3,400,887 4,187,163 4,184,554 473,773 Register of Deeds 761,273 730,166 828,767 813,812 88,606 Information Technology 1,256,973 1,301,628 1,451,480 1,776,660 442,522 GIS 440,731 432,327 458,523 448,798 65,247 Sheriff 9,344,007 10,166,283 10,617,396 10,511,034 1,457,651 Campbell Deputies 357,903 354,232 433,165 433,165 56,906 Harnett CJPP 53,836 80,119 - - - Sheriff's Department Grants 38,810 15,213 - - - Child Support Enforcement 67,192 66,257 77,977 77,977 10,594 Governor's Highway Safety 112,332 26,536 - - - Life is Fragile (NCGCC) 29,531 - - - - Communications 1,116,529 1,219,142 1,549,815 1,549,815 191,521 Jail 4,187,264 4,306,490 4,891,294 4,886,316 573,978 Emergency Services 712,960 737,021 816,311 808,957 95,170 Emergency Services Grant 1,000 32,000 - - - Emergency Medical Service 4,179,979 3,991,897 4,071,973 4,056,454 586,885 EMS Transport 960,370 1,083,318 1,202,067 1,197,127 142,239 Rescue Districts 3,225,144 3,314,704 3,361,704 3,361,704 560,285 Animal Services 381,748 376,744 478,055 476,149 53,490 Medical Examiner 40,200 50,000 65,000 65,000 6,750 Public Safety Appropriations 126,278 124,334 79,756 79,756 8,958 Emergency Telephone System 243,460 240,521 261,116 258,736 40,325 Radio System 474,341 300,204 302,100 302,100 34,178 Harnett Regional Jetport 179,592 174,955 180,244 205,244 18,922 Soil & Water 119,598 124,133 177,482 175,754 21,580 Environmental Protection 4,000 4,000 14,000 14,000 - Forestry Program 113,334 114,849 114,849 114,849 - Economic/Physical Dev. App. 1,509,397 449,748 595,500 595,500 61,996 Industrial Development 1,462,725 776,301 887,853 884,353 188,108 Planning & Inspections 1,437,604 1,321,571 1,390,709 1,387,900 199,040 Community Development (BG) - 1,129 1,300 1,300 99 Abandoned MFG Home - 31,903 45,628 45,628 5,282 Cooperative Extension 427,644 351,557 426,277 423,078 31,992 CCR&R - Block Grant 27,369 31,419 45,675 33,039 6,076 CCR&R - United Way - 2,483 2,678 2,678 - Parents As Teachers 226,262 158,263 - 61,000 - Adolescent Parenting 60,003 59,107 58,835 59,835 10,212 \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\August 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT August, 2014 GENERAL FUND FYE 2015 Activity (includes 2014 - 2015 2014 - 2015 Original BudgetAdjusted Budgetencumbrances) DepartmentFYE 2013FYE 2014 CCR&R - Smart Start 17,922 - - - - 4-H Teen Court & At Risk 30,804 45,686 48,987 48,987 7,765 Child Care Youth Training - 27,367 17,897 17,897 - Race to the Top - 13,570 16,038 30,168 1,633 Adolescent Parenting - 3,789 - - - Department on Aging 293,761 283,332 305,150 314,750 32,462 Family Caregiver Support 38,363 51,769 61,036 60,353 8,913 RSVP 72,852 73,276 75,205 77,705 10,586 CAP - Disabled Adults 291,181 326,783 331,970 331,970 54,833 Nutrition for Elderly 405,545 378,087 432,711 432,711 57,880 Health 5,932,196 5,787,018 7,007,971 7,007,721 855,003 Mental Health 615,679 815,679 605,679 605,679 51,420 Social Services 9,418,756 9,359,396 10,313,676 10,313,676 1,454,801 Public Assistance 7,944,608 7,829,453 9,691,288 9,691,288 1,154,798 Veteran's Services 166,579 172,197 178,003 176,245 27,721 Restitution 127,765 110,369 120,868 120,868 15,970 Human Services App. 174,635 99,840 99,000 99,000 67,557 Library 881,506 928,107 1,055,629 1,082,480 155,035 Cultural & Recreational App. 167,000 100,000 150,000 150,000 - Parks & Recreation 319,254 363,011 437,558 436,081 81,359 Education Board of Education - current 20,288,004 20,523,700 21,523,700 21,523,700 3,587,283 Board of Education - capital - - - - - Central Carolina - current 638,841 927,711 917,467 917,467 152,911 Central Carolina - capital 23,973 - - - - Central Carolina - works - 25,000 25,000 25,000 - Interfund Transfers 455,491 1,903,876 43,334 43,334 - Debt Service 11,486,712 13,902,144 15,185,209 15,185,209 29,353 Contingency - - - - - Total$ 102,308,383$ 105,234,405$ 114,237,797$ 114,423,193$ 14,136,039 FYE 2015 Activity 2014 - 2015 2014 - 2015 Original BudgetAdjusted Budget(includes FYE 2013FYE 2014 Taxes$ 69,522,222$ 73,993,017$ 74,032,270$ 74,032,270$ 273,991 Permits & Fees 3,089,188 2,763,205 2,927,767 2,927,767 163,552 Intergovernmental Revenue 20,204,388 19,304,274 19,801,584 19,838,856 505,310 Sales & Services 9,422,096 7,658,151 9,638,797 9,638,797 227,004 Other Revenues 2,902,980 3,451,519 3,709,317 3,804,292 624,271 Rents, Concessions. & Fees 83,870 77,898 84,251 84,251 1,027 Other Finance Sources 960,622 857,548 450,000 450,000 - Interfund Transfers 438,263 460,947 400,000 400,000 - Fund Balance Appropriated - - 3,193,811 3,246,960 - Total$ 106,623,629$ 108,566,559$ 114,237,797$ 114,423,193$ 1,795,155 Revenues over/(under) expenditures$ (12,340,884) \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\August 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT August, 2014 GENERAL FUND Cash and Investments CashTax LockboxNCCMTTotal July, 2014$ -$ 475$ 20,554,835$ 20,555,310 June, 2014$ 2,799,637$ 475$ 21,645,331$ 24,445,443 May, 2014$ 5,325,561$ 27,888$ 20,305,523$ 25,658,972 April, 2014$ 12,798,914$ 27,888$ 20,164,065$ 32,990,868 March, 2014$ 14,373,115$ 27,887$ 18,787,339$ 33,188,341 February, 2014$ 16,560,067$ 27,845$ 16,075,525$ 32,663,437 January, 2014$ 17,860,088$ 27,845$ 15,963,619$ 33,851,552 December, 2013$ 10,145,781$ 27,845$ 14,551,933$ 24,725,559 November, 2013$ 16,621,211$ 27,858$ 12,624,371$ 29,273,440 October, 2013$ 6,725,797$ 27,405$ 13,767,699$ 20,520,901 September, 2013$ 4,446,957$ 611$ 13,644,045$ 18,091,613 August, 2013$ 5,727,362$ 611$ 12,480,364$ 18,208,337 July, 2013$ 9,974,228$ 611$ 10,954,310$ 20,929,149 Debt Service and Transfer Requirements Current YearOutstanding Interest$ 5,465,931$ 58,811,027 Principal 9,719,278 143,630,869 Transfers Out 43,334 - $ 15,228,543$ 202,441,896 Estimated Fund Balance Inthegovernmentalfundfinancialstatements,fundbalanceiscomposedoffiveclassificationsdesignedtodisclosethehierarchyof constraints placed on how fund balance can be spent. They are as follows: Thisclassificationincludesamountsthatcannotbespentbecausetheyareeither(a)notin Non-Spendable Fund Balance - spendable form or (b) legally or contractually required to be maintained intact. Theclassificationincludesamountthatarerestrictedtospecificpurposesexternallyimposedby Restricted Fund Balance - creditors or imposed by law. Thisclassificationrepresentstheportionoffundbalancethatcanonlybeusedforspecificpurposes imposedbymajorityvotebyaquorumoftheCountyCommissioners,thatcanbyadoptionofan Committed Fund Balance - ordinance, commit fund balance. ThatportionoffundbalancethattheCountyintendstouseforspecificpurposes.TheCounty Commissionershavetheauthoritytoassignfundbalances.TheManagerandFinanceOfficer,as Assigned Fund Balance - granted in the budge ordinance, have been granted limited authority to assign fund balance. Thisclassificationrepresentstheportionoffundbalancethathasnotbeenassignedtoanother Unassigned Fund Balance - fund or is not restricted, committed, or assigned to specific purposes within the general fund. \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\August 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT August, 2014 GENERAL FUND Unassigned Fund Balance at June 30, 2013$ 17,959,942 Unaudited 06/30/2014 Revenues over/(under) Expenditures$ 3,332,154 Year to Date Revenues over/(under) Expenditures (12,340,884) 8,951,211.72 Remaining Debt Payments for this Year (15,155,856) Outstanding budget amendments - Year to Date Fund Balance Appropriated (3,246,960) (18,402,816) IftheCountywheretostopoperationsattheendofthismonthandhadno $ (9,451,604) furtherreceivablesorpayables,thenthiswouldbetheestimatedfund balance amount and its percentage of expenditures. -8.26% Amount by which fund balance percentage will change$ 1,144,232 The County Board of Commissioners have approved a fund balance policy which strives to maintain a fund balance of 15%. \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\August 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT August, 2014 PUBLIC UTILITIES FYE 2015 Activity 2014 - 2015 Adjusted (includes 2014 - 2015 Original BudgetBudgetencumbrances) FYE 2013FYE 2014 Admin/CSR/Meter Services$ 37,598,026$ 19,229,033$ 12,381,841$ 13,146,523$ 1,536,786 Water Treatment 3,571,705 3,671,291 4,397,498 4,397,498 2,068,283 Wastewater Treatment 1,790,807 1,965,319 2,349,238 2,349,238 804,018 Wastewater Treatment SHWW 1,358,206 1,860,402 2,336,717 2,336,717 760,041 Distribution 3,349,268 3,383,463 4,167,901 4,167,901 1,401,541 Collections 3,056,462 2,975,052 3,486,170 3,486,170 1,220,040 Total$ 50,724,474$ 33,084,560$ 29,119,365$ 29,884,047$ 7,790,710 2014 - 2015 Adjusted 2014 - 2015 FYE 2015 Original BudgetBudgetActivity FYE 2013FYE 2014 Intergovernmental Revenue$ 3,703$ 3,703$ 3,600$ 3,600$ - Sales & Services 27,670,467 30,275,723 26,921,865 26,921,865 2,267,013 Other Revenues 4,934,826 13,281,536 1,788,900 1,788,900 43,003 Rents, Concess. & Feees 5,531 96 5,000 5,000 - Other Finance Sources 20,065,000 473,683 - - 610,494 Interfund Transfers - 150,000 - - - Fund Balance Appropriated - - 400,000 1,164,682 - Total$ 52,679,527$ 44,184,741$ 29,119,365$ 29,884,047$ 2,920,509 Revenues over/(under) expenditures-$4,870,200 Cash and Investments CashLockbox *NCCMTTotal July, 2014$ 25,392,786$ -$ 515,469 $ 25,908,254 June, 2014$ 23,566,116$ -$ 512,929 $ 24,079,044 May, 2014$ 22,909,362$ -$ 511,160 $ 23,420,522 April, 2014$ 24,890,282$ -$ 505,012 $ 25,395,294 March, 2014$ 25,824,291$ -$ 497,945 $ 26,322,236 February, 2014$ 21,864,353$ -$ 458,673 $ 22,323,026 January, 2014$ 21,428,607$ -$ 455,673 $ 21,884,280 December, 2013$ 19,879,494$ -$ 454,890 $ 20,334,384 November, 2013$ 19,734,711$ -$ 453,440 $ 20,188,151 October, 2013$ 17,751,137$ -$ 453,180 $ 18,204,317 September, 2013$ 18,085,580$ -$ 452,951 $ 18,538,531 August, 2013$ 16,432,674$ -$ 448,888 $ 16,881,562 July, 2013$ 14,961,277$ -$ 446,603 $ 15,407,880 * The balance in the lockbox account is rolled into the cash account before each month closes. Debt Service and Transfer Requirements Current YearOutstanding Interest$ 2,999,352$ 36,944,577 Principal$ 4,922,410 87,739,896 Transfers Out$ 1,164,682 - $ 9,086,444$ 124,684,473 \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\August 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT August, 2014 SOLID WASTE FYE 2015 Activity 2014 - 2015 Adjusted (includes 2014 - 2015 Original BudgetBudgetencumbrances) FYE 2013FYE 2014 Solid Waste$ 5,073,308 $ 5,161,897$ 5,358,790$ 5,358,790$ 853,728 Total$ 5,073,308 $ 5,161,897$ 5,358,790$ 5,358,790$ 853,728 2014 - 2015 Adjusted 2014 - 2015 FYE 2015 Original BudgetBudgetActivity Revenues:FYE 2013FYE 2014 Taxes$ 227,228$ 237,297$ 259,000 $ 259,000$ - Intergovernmental Revenue - - - - - Sales & Services 4,776,288 5,006,315 5,097,390 5,097,390 27,807 Other Revenues 638,962 378,116 2,400 2,400 25 Rents, Concess. & Feees 430 243 - - - Other Finance Sources 582,662 739,763 - - - Interfund Transfers - - - - - Fund Balance Appropriated - - - - - Total$ 6,225,570 $ 6,361,734$ 5,358,790$ 5,358,790$ 27,832 Revenues over/(under) expenditures$ (825,895) Cash and Investments CashSun TrustFirst BankNCCMTTotal July, 2014$ 481,103$ 193,679$ 199,824 $ 242,829$ 1,117,436 June, 2014$ 709,310$ 153,450$ 169,118 $ 242,829$ 1,274,707 May, 2014$ 1,018,519 $ 153,450$ 169,118 $ 242,829$ 1,583,916 April, 2014$ 517,264$ 144,082$ 159,723 $ 190,383$ 1,011,453 March, 2014$ 659,891$ 122,417$ 153,463 $ 190,282$ 1,126,053 February, 2014$ 929,101$ 98,860$ 110,949 $ 190,282$ 1,329,192 January, 2014$ 1,206,501 $ 94,942$ 110,849 $ 127,968$ 1,540,260 December, 2013$ 462,549$ 77,362$ 102,262 $ 127,968$ 770,141 November, 2013$ 463,532$ 70,276$ 88,219$ 127,968$ 749,995 October, 2013$ 598,623$ 62,630$ 80,153$ 58,925 $ 800,331 September, 2013$ (389,231) $ 37,986$ 53,459$ 58,925 $ (238,861) August, 2013$ (436,599) $ 23,987$ 34,636$ 58,925 $ (319,051) July, 2013$ (229,256) $ 11,068$ 26,666$ -$ (191,522) Debt Service and Transfer Requirements Current YearOutstanding Interest$ 127,786$ 796,081 Principal 403,867 3,338,828 Transfers Out 200,000 - $ 731,653$ 4,134,909 \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\August 2014 - Financial Statements.xlsx