No preview available
HomeMy WebLinkAboutSeptember 2014 - Financial Statements HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 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 $ 69,168 Administration 339,722 250,759 298,463 295,629 115,377 Legal Services 122,070 103,351 120,966 119,294 80,319 Engineering - 1 - - 14,035 Human Resources 224,821 254,738 274,623 272,012 79,950 Board of Elections 357,108 303,532 365,189 358,674 71,926 Finance 961,984 729,469 897,440 877,440 249,306 Clerk of Court 98,086 77,704 90,842 89,554 21,189 Tax 1,664,758 1,569,231 1,767,369 1,741,896 386,236 General Services 473,759 140,485 154,752 153,902 37,510 Fleet Maintenance - 438,847 701,293 700,730 132,173 Transportation 940,206 1,004,266 1,435,000 1,516,440 124,446 Transportation - Admin 188,721 194,790 225,479 219,288 40,094 Facilities Maintenance 3,285,478 3,400,887 4,187,163 4,184,554 692,572 Register of Deeds 761,273 730,166 828,767 813,812 138,136 Information Technology 1,256,973 1,301,628 1,451,480 1,776,660 570,515 GIS 440,731 432,327 458,523 448,798 99,951 Sheriff 9,344,007 10,166,283 10,617,396 10,511,034 2,264,594 Campbell Deputies 357,903 354,232 433,165 433,165 89,149 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 16,734 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 285,391 Jail 4,187,264 4,306,490 4,891,294 4,886,316 932,551 Emergency Services 712,960 737,021 816,311 808,957 145,364 Emergency Services Grant 1,000 32,000 - - - Emergency Medical Service 4,179,979 3,991,897 4,071,973 4,056,454 909,400 EMS Transport 960,370 1,083,318 1,202,067 1,197,127 232,681 Rescue Districts 3,225,144 3,314,704 3,361,704 3,361,704 1,120,568 Animal Services 381,748 376,744 478,055 476,149 83,593 Medical Examiner 40,200 50,000 65,000 65,000 13,200 JCPC Admin - - - 5,000 - Public Safety Appropriations 126,278 124,334 79,756 74,756 14,937 Emergency Telephone System 243,460 240,521 261,116 258,736 60,319 Radio System 474,341 300,204 302,100 302,100 49,062 Harnett Regional Jetport 179,592 174,955 180,244 205,244 31,603 Soil & Water 119,598 124,133 177,482 175,754 32,530 Environmental Protection 4,000 4,000 14,000 14,000 4,000 Forestry Program 113,334 114,849 114,849 114,849 - Economic/Physical Dev. App. 1,509,397 449,748 595,500 595,500 100,482 Industrial Development 1,462,725 776,301 887,853 884,353 198,760 Planning & Inspections 1,437,604 1,321,571 1,390,709 1,387,900 313,428 Community Development (BG) - 1,129 1,300 1,300 121 Abandoned MFG Home - 31,903 45,628 45,628 9,541 Cooperative Extension 427,644 351,557 426,277 422,158 59,754 CCR&R - Block Grant 27,369 31,419 45,675 33,673 8,474 CCR&R - United Way - 2,483 2,678 2,678 55 Parents As Teachers 226,262 158,263 - 61,500 1,666 Adolescent Parenting 60,003 59,107 58,835 60,000 15,303 \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\September 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 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 49,773 10,998 Child Care Youth Training - 27,367 17,897 17,897 - Race to the Top - 13,570 16,038 27,775 3,337 Adolescent Parenting - 3,789 - - - Department on Aging 293,761 283,332 305,150 314,750 55,953 Family Caregiver Support 38,363 51,769 61,036 60,353 14,907 RSVP 72,852 73,276 75,205 77,705 15,968 CAP - Disabled Adults 291,181 326,783 331,970 331,970 84,205 Nutrition for Elderly 405,545 378,087 432,711 432,711 91,194 Health 5,932,196 5,787,018 7,007,971 7,162,520 1,294,470 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 2,211,446 Public Assistance 7,944,608 7,829,453 9,691,288 9,691,288 1,728,665 Veteran's Services 166,579 172,197 178,003 176,245 42,421 Restitution 127,765 110,369 120,868 120,868 28,566 Human Services App. 174,635 99,840 99,000 99,000 67,557 Library 881,506 928,107 1,055,629 1,082,480 230,369 Cultural & Recreational App. 167,000 100,000 150,000 150,000 - Parks & Recreation 319,254 363,011 437,558 436,081 103,235 Education Board of Education - current 20,288,004 20,523,700 21,523,700 21,523,700 5,380,925 Board of Education - capital - - - - - Central Carolina - current 638,841 927,711 917,467 917,467 229,367 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 44,030 Contingency - - - - - Total$ 102,308,383$ 105,234,405$ 114,237,797$ 114,671,304$ 21,605,196 FYE 2015 Activity 2014 - 2015 2014 - 2015 Original BudgetAdjusted Budget(includes FYE 2013FYE 2014 Ad Valorem Taxes$ 54,273,480$ 58,070,801$ 57,851,526$ 57,851,526$ 12,286,935 Sales Tax 14,238,193 14,884,497 14,980,744 14,980,744 - Other taxes 1,010,549 1,037,719 1,200,000 1,200,000 209,075 Permits & Fees 3,089,188 2,763,205 2,927,767 2,927,767 483,250 Intergovernmental Revenue 20,204,388 19,304,274 19,801,584 19,925,994 2,631,575 Sales & Services 9,422,096 7,658,151 9,638,797 9,635,807 1,344,952 Other Revenues 2,902,980 3,451,519 3,709,317 3,804,792 865,166 Rents, Concessions. & Fees 83,870 77,898 84,251 84,251 13,359 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,410,423 - Total$ 106,623,629$ 108,566,559$ 114,237,797$ 114,671,304$ 17,834,312 Revenues over/(under) expenditures$ (3,770,884) \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\September 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 GENERAL FUND Cash and Investments CashTax LockboxNCCMTTotal September, 2014$ -$ 475$ 26,396,094$ 26,396,569 August, 2014$ -$ 475$ 19,277,617$ 19,278,091 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 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 Assigned Fund Balance - Commissioners have the authority to assign fund balances. 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\\September 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 GENERAL FUND Unassigned Fund Balance at June 30, 2014$ 18,732,09518.20% Year to Date Revenues over/(under) Expenditures (3,770,884) 14,961,211 Remaining Debt Payments for this Year (15,141,179) Outstanding budget amendments - Year to Date Fund Balance Appropriated (3,410,423) (18,551,602) IftheCountyweretostopoperationsattheendofthismonthandhadno $ (3,590,391) furtherreceivablesorpayables,thenthiswouldbetheestimatedfund balance amount and its percentage of expenditures. -3.13% Amount by which fund balance percentage will change$ 1,146,713 The County Board of Commissioners have approved a fund balance policy which strives to maintain a minimum fund balance of 15%. \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\September 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 PUBLIC UTILITIES FUND 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,779,698 Water Treatment 3,571,705 3,671,291 4,397,498 4,397,498 646,115 Wastewater Treatment 1,790,807 1,965,319 2,349,238 2,349,238 303,334 Wastewater Treatment SHWW 1,358,206 1,860,402 2,336,717 2,336,717 312,051 Distribution 3,349,268 3,383,463 4,167,901 4,167,901 937,460 Collections 3,056,462 2,975,052 3,486,170 3,486,170 512,297 Total$ 50,724,474$ 33,084,560$ 29,119,365$ 29,884,047$ 4,490,955 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 7,581,031 Other Revenues 4,934,826 13,281,536 1,788,900 1,788,900 100,463 Rents, Concess. & Feees 5,531 96 5,000 5,000 14 Other Finance Sources 20,065,000 473,683 - - 1,230,196 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$ 8,911,704 Revenues over/(under) expenditures$4,420,749 Cash and Investments CashLockbox *NCCMTTotal September, 2014$ 28,441,620$ -$ 517,378 $ 28,958,997 August, 2014$ 25,475,483$ -$ 516,449 $ 25,991,932 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 * 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\\September 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 SOLID WASTE FUND 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,394,790$ 783,246 Total$ 5,073,308 $ 5,161,897$ 5,358,790$ 5,394,790$ 783,246 2014 - 2015 Adjusted 2014 - 2015 FYE 2015 Original BudgetBudgetActivity Revenues:FYE 2013FYE 2014 Taxes$ 227,228$ 237,297$ 259,000 $ 259,000$ - Intergovernmental Revenue - - - 25,000 - Sales & Services 4,776,288 5,006,315 5,097,390 5,097,390 1,051,342 Other Revenues 638,962 378,116 2,400 2,400 175 Rents, Concess. & Feees 430 243 - - - Other Finance Sources 582,662 739,763 - - - Interfund Transfers - - - - - Fund Balance Appropriated - - - 11,000 - Total$ 6,225,570 $ 6,361,734$ 5,358,790$ 5,394,790$ 1,051,517 Revenues over/(under) expenditures$ 268,271 Cash and Investments CashSun TrustFirst BankNCCMTTotal September, 2014$ 783,054$ 237,379$ 234,622 $ 296,324$ 1,551,379 August, 2014$ 513,937$ 202,029$ 206,671 $ 296,324$ 1,218,960 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) Debt Service and Transfer Requirements Current YearOutstanding Interest$ 127,786$ 796,081 Principal 403,867 3,338,828 Transfers Out - - $ 531,653$ 4,134,909 \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\September 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 MEDICAL INSURANCE FUND FYE 2015 Activity 2014 - 2015 Adjusted (includes 2014 - 2015 Original BudgetBudgetencumbrances) FYE 2013FYE 2014 Paid Claims$ -$ -$ 6,000,000$ 5,490,000$ 765,780 Fixed Cost$ -$ -$ 1,000,000$ 637,000$ 166,780 Total$ -$ -$ 7,000,000$ 6,127,000$ 932,561 2014 - 2015 Adjusted 2014 - 2015 FYE 2015 Original BudgetBudgetActivity Revenues:FYE 2013FYE 2014 Medical Premiums$ -$ -$ 7,000,000$ 6,127,000$ 1,556,901 Fund Balance Appropriated - - - - - Total$ -$ -$ 7,000,000$ 6,127,000$ 1,556,901 Revenues over/(under) expenditures$ 624,340 Loss Ratio59.90% Cash and Investments CashNCCMTTotal September, 2014$ 1,086,724 $ 543,297$ 1,630,021 August, 2014$ 1,042,547 $ 543,297$ 1,585,844 July, 2014$ 768,924$ 543,297$ 1,312,222 June, 2014$ -$ -$ - May, 2014$ -$ -$ - April, 2014$ -$ -$ - March, 2014$ -$ -$ - February, 2014$ -$ -$ - January, 2014$ -$ -$ - December, 2013$ -$ -$ - November, 2013$ -$ -$ - October, 2013$ -$ -$ - September, 2013$ -$ -$ - \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\September 2014 - Financial Statements.xlsx HARNETT COUNTY FINANCIAL SUMMARY REPORT September, 2014 DENTAL INSURANCE FUND FYE 2015 Activity 2014 - 2015 Adjusted (includes 2014 - 2015 Original BudgetBudgetencumbrances) FYE 2013FYE 2014 Paid Claims$ -$ -$ - $ 340,000$ 45,447 Fixed Cost$ -$ -$ - $ 36,000 $ 8,873 Total$ -$ -$ - $ 376,000$ 54,320 2014 - 2015 Adjusted 2014 - 2015 FYE 2015 Original BudgetBudgetActivity Revenues:FYE 2013FYE 2014 Dental Premiums$ -$ -$ - $ 376,000$ 92,688 Fund Balance Appropriated - - - - - Total$ -$ -$ - $ 376,000$ 92,688 Revenues over/(under) expenditures$ 38,368 Loss Ratio58.61% Cash and Investments CashNCCMTTotal September, 2014$ 203,941$ -$ 203,941 August, 2014$ 204,905$ -$ 204,905 July, 2014$ 192,296$ -$ 192,296 June, 2014$ -$ -$ - May, 2014$ -$ -$ - April, 2014$ -$ -$ - March, 2014$ -$ -$ - February, 2014$ -$ -$ - January, 2014$ -$ -$ - December, 2013$ -$ -$ - November, 2013$ -$ -$ - October, 2013$ -$ -$ - September, 2013$ -$ -$ - \\\\hcfile2\\finusers\\alcoats\\My Documents\\Monthly Reports\\2014 - 2015\\September 2014 - Financial Statements.xlsx