No preview available
HomeMy WebLinkAboutOctober 2015 - Financial Statements11/23/2015 FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year $ 164,631 $ 158,070 $ 252,888 $ 96,553 38.18% $ 90,053 250,759 280,372 258,472 133,560 51.67% 153,021 103,351 8,609 69,617 59,332 85.23% 115,827 1 - - - 18,714 254,738 247,154 238,649 90,442 37.90% 104,909 303,532 305,481 442,442 94,436 21.34% 104,920 729,469 833,532 842,115 324,065 38.48% 332,077 77,704 79,320 411,771 23,226 5.64% 31,654 1,569,231 1,588,997 1,695,468 493,088 29.08% 504,211 140,485 153,360 161,852 42,454 26.23% 49,625 438,847 603,102 579,622 154,058 26.58% 183,551 1,004,266 839,486 1,699,404 284,892 16.76% 179,442 194,790 209,741 219,108 46,007 21.00% 50,184 3,400,887 3,736,788 3,581,926 1,131,860 31.60% 983,321 730,166 695,654 790,642 183,387 23.19% 189,444 1,301,628 1,726,510 1,917,855 743,011 38.74% 725,598 432,327 436,602 615,987 204,508 33.20% 129,046 10,166,283 10,205,366 10,106,545 2,621,840 25.94% 3,003,078 354,232 389,674 480,900 124,861 25.96% 126,843 80,119 - - - - 15,213 1,607 46,161 9,228 19.99% - 66,257 70,126 76,867 19,011 24.73% 22,202 26,536 - - - - 1,219,142 1,389,574 1,646,452 413,472 25.11% 387,317 School Resource Officers - - 691,067 161,814 23.42% - 4,306,490 4,407,161 4,792,299 1,364,228 28.47% 1,412,188 737,021 765,164 843,812 210,022 24.89% 197,337 32,000 - - - - 3,991,897 4,080,768 4,324,060 1,131,757 26.17% 1,267,921 1,083,318 1,144,801 1,151,414 309,336 26.87% 321,697 3,314,704 3,361,704 3,361,704 1,400,710 41.67% 1,400,710 376,744 431,707 493,913 113,372 22.95% 120,275 50,000 47,050 65,000 10,000 15.38% 16,800 - 4,516 8,040 954 11.87%225 124,334 79,180 66,168 22,068 33.35% 19,025 240,521 236,688 - - 81,467 300,204 246,495 285,000 55,151 19.35% 71,170 174,955 208,990 209,736 44,656 21.29% 43,868 124,133 161,801 183,879 49,485 26.91% 43,180 4,000 4,000 4,000 4,000 100.00% 4,000 114,849 112,289 111,511 25,156 22.56% - 449,748 458,253 575,000 129,043 22.44% 132,275 776,301 1,382,346 611,047 136,723 22.38% 207,485 1,321,571 1,362,552 1,365,164 391,640 28.69% 418,314 1,129 735 300 2 0.67% 319 31,903 57,241 36,298 9,721 26.78% 12,181 351,557 289,118 382,276 53,722 14.05% 90,820 31,419 25,623 12,256 1,459 11.90% 10,754 2,483 379 600 83 13.83% 298 158,263 44,813 19,133 12,052 62.99% 6,085 59,107 60,321 70,295 20,111 28.61% 20,330 Environmental Protection Forestry Program Economic/Physical Dev. App. Industrial Development JCPC Admin Public Safety Appropriations Emergency Telephone System Radio System Harnett Regional Jetport Parents As Teachers Adolescent Parenting Planning & Inspections Community Development (BG) Abandoned MFG Home Cooperative Extension CCR&R - Block Grant Soil & Water HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2015 GENERAL FUND CCR&R - United Way Emergency Medical Service EMS Transport Rescue Districts Animal Services Medical Examiner Emergency Services Grant Facilities Maintenance Register of Deeds Information Technology GIS Sheriff Tax General Services Fleet Maintenance Transportation Transportation - Admin Campbell Deputies Harnett CJPP Sheriff's Department Grants Child Support Enforcement Governor's Highway Safety Communications Jail Emergency Services Department Governing Body Administration Legal Services Engineering Human Resources Board of Elections Finance Clerk of Court U:\My Documents\Monthly Reports\2015 - 2016\October 2015 - Financial Statements.xlsx 1 11/23/2015HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2015 GENERAL FUND FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 45,686 - 49,773 11,692 23.49% - 27,367 50,723 - - 13,865 13,570 - 38,877 847 2.18% - 3,789 14,200 - - 4,845 - - 22,950 6,627 28.88% - 283,332 307,602 317,411 85,716 27.00% 85,459 51,769 64,108 62,029 18,807 30.32% 19,868 73,276 77,658 77,258 21,410 27.71% 26,363 326,783 328,753 378,328 91,651 24.23% 104,831 378,087 414,989 433,933 129,320 29.80% 124,290 5,787,018 6,014,268 7,228,968 1,685,968 23.32% 1,752,457 815,679 605,679 605,679 302,840 50.00% 302,840 9,359,396 10,155,398 10,585,495 3,070,132 29.00% 2,966,275 7,829,453 7,905,017 9,254,809 2,700,411 29.18% 2,297,603 172,197 178,634 178,173 51,985 29.18% 56,988 110,369 100,304 120,965 29,009 23.98% 38,150 99,840 90,780 99,000 67,557 68.24% 67,557 928,107 941,972 981,229 264,695 26.98% 303,982 100,000 150,000 150,000 - 0.00% - 363,011 403,871 455,928 153,892 33.75% 136,931 20,523,700 21,523,700 21,267,993 7,089,331 33.33% 7,174,567 - - 255,707 111,885 43.76% - 927,711 928,467 1,002,467 305,822 30.51% 305,822 - - - - - 25,000 25,000 25,000 - 0.00% - 1,903,876 64,701 283,334 43,334 15.29% 26,667 13,902,144 44,265,436 16,033,752 2,021,307 12.61% 99,246 - - 999,000 - 0.00% - 105,234,405$ 137,544,080$ 116,706,773$ 31,214,794$ 26.75%29,292,367$ FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 54,120,822$ 53,930,707$ 54,295,343$ 7,570,456$ 13.94%13,219,378$ 3,949,979 5,712,141 5,654,182 1,564,293 27.67%1,446,662 14,884,497 16,757,810 16,154,459 1,422,538 8.81%1,041,524 1,037,719 1,053,493 1,200,000 326,901 27.24%271,138 2,763,205 2,515,489 3,718,955 781,936 21.03%666,695 19,304,274 18,884,854 18,734,753 4,054,014 21.64%3,904,395 7,658,151 7,818,258 8,799,292 2,027,688 23.04%1,991,661 3,451,519 3,737,358 3,424,751 313,960 9.17%999,381 77,898 77,652 78,779 28,986 36.79%18,778 857,548 29,108,938 1,008,803 - 0.00%- 460,947 322,415 55,656 7,501 13.48%- - - 3,581,800 - 0.00%- 108,566,559$ 139,919,115$ 116,706,773$ 18,098,273$ 15.51%23,559,612$ 2,375,035$ (13,116,521)$ (5,732,755) Cultural & Recreational App. Parks & Recreation Education Special Programs Department Revenues over/(under) expenditures Other Finance Sources Interfund Transfers Fund Balance Appropriated Total Permits & Fees Intergovernmental Revenue Sales & Services Other Revenues Rents, Concessions. & Fees Ad Valorem Taxes Mental Health Social Services Public Assistance Veteran's Services Family Caregiver Support RSVP Motor Vehicles Sales Tax Other taxes Interfund Transfers Debt Service Contingency Total Revenues: 4-H Teen Court & At Risk Child Care Youth Training Race to the Top Adolescent Parenting - BJRH Department on Aging Restitution CAP - Disabled Adults Real and Personal Nutrition for Elderly Health Board of Education - current Board of Education - capital Central Carolina - current Central Carolina - capital Central Carolina - works Human Services App. Library U:\My Documents\Monthly Reports\2015 - 2016\October 2015 - Financial Statements.xlsx 2 11/23/2015HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2015 GENERAL FUND Cash Tax Lockbox MBS NCCMT Total -$ -$ 3,415,750$ 15,184,900$ 18,600,650$ -$ -$ 1,799,750$ 16,262,992$ 18,062,742$ -$ -$ 1,799,750$ 14,138,439$ 15,938,189$ 482,070$ -$ 1,199,750$ 19,037,670$ 20,719,491$ 6,004,643$ -$ 999,750$ 18,681,713$ 25,686,107$ 3,587,900$ -$ 1,149,750$ 22,024,531$ 26,762,181$ 10,758,278$ -$ 1,099,750$ 20,688,202$ 32,546,230$ 19,176,680$ -$ 1,099,750$ 19,219,802$ 39,496,232$ 20,516,681$ 475$ 1,099,750$ 16,737,860$ 38,354,765$ 25,124,005$ 475$ 874,750$ 15,004,637$ 41,003,866$ 2,815,021$ 475$ 624,759$ 32,414,000$ 35,854,255$ 2,599,381$ 475$ 400,000$ 26,992,531$ 29,992,387$ -$ 475$ -$ 24,307,459$ 24,307,934$ Current Year Outstanding Interest 4,627,480$ 44,149,422$ Principal 9,760,978 121,114,540 Transfers Out - - 14,388,459$ 165,263,961$ January, 2015 November, 2014 October, 2014 October, 2015 June, 2015 Cash and Investments Estimated Fund Balance March, 2015 September, 2015 Unassigned Fund Balance - This classification represents the portion of fund balance that has not been assigned to another fund or is not restricted, committed, or assigned to specific purposes within the general fund. February, 2015 In the governmental fund financial statements, fund balance is composed of five classifications designed to disclose the hierarchy of constraints placed on how fund balance can be spent. They are as follows: Non-Spendable Fund Balance - This classification includes amounts that cannot be spent because they are either (a) not in spendable form or (b) legally or contractually required to be maintained intact. Restricted Fund Balance - The classification includes amount that are restricted to specific purposes externally imposed by creditors or imposed by law. Committed Fund Balance - This classification represents the portion of fund balance that can only be used for specific purposes imposed by majority vote by a quorum of the County Commissioners, that can by adoption of an ordinance, commit fund balance. Assigned Fund Balance - That portion of fund balance that the County intends to use for specific purposes. The County Commissioners have the authority to assign fund balances. December, 2014 Debt Service and Transfer Requirements April, 2015 May, 2015 July, 2015 August, 2015 U:\My Documents\Monthly Reports\2015 - 2016\October 2015 - Financial Statements.xlsx 3 11/23/2015HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2015 GENERAL FUND Unassigned Fund Balance at June 30, 2015 18,732,095$ 17.89% Unaudited 06/30/2014 Revenues over/(under) Expenditures 2,375,035$ Year to Date Revenues over/(under) Expenditures (13,116,521) 7,990,609 Remaining Debt Payments for this Year (14,012,445) Outstanding budget amendments - Year to Date Fund Balance Appropriated (3,581,800) (17,594,245) (9,603,636)$ -8.23% Amount by which fund balance percentage will change 1,167,068$ If the County were to stop operations at the end of this month and had no further receivables or payables, then this would be the estimated fund balance amount and its percentage of expenditures. The County Board of Commissioners have approved a fund balance policy which strives to maintain a minimum fund balance of 15%. U:\My Documents\Monthly Reports\2015 - 2016\October 2015 - Financial Statements.xlsx 4 11/23/2015 FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 19,229,033$ 40,477,963$ 11,750,244$ 1,688,327$ 14.37%2,327,925$ 3,671,291 3,965,881 4,336,822 1,298,128 29.93%990,167 1,965,319 1,908,016 2,397,828 471,763 19.67%447,439 1,860,402 1,869,169 2,354,624 511,243 21.71%461,723 3,383,463 3,607,800 4,578,923 1,047,283 22.87%1,202,695 2,975,052 3,006,906 3,363,958 785,220 23.34%791,780 33,084,560$ 54,835,735$ 28,782,399$ 5,801,964$ 20.16%6,221,729$ FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 3,703$ 3,703$ 3,703$ -$ 0.00%-$ 30,275,723 30,134,602 26,984,920 11,526,672 42.72%10,469,816 13,281,536 2,023,404 1,793,776 101,630 5.67%115,844 96 172 - - 14 473,683 13,731,430 - - 1,230,196 150,000 1,452,130 - - - - - - - - 44,184,741$ 47,345,441$ 28,782,399$ 11,628,302$ 40.40%11,815,870$ 5,826,338$ 5,594,141$ Cash Lockbox NCCMT Total 23,345,138$ 3,268,625$ 549,916$ 27,163,678$ 22,373,066$ 3,142,028$ 549,700$ 26,064,794$ 20,802,670$ 3,162,849$ 549,270$ 24,514,789$ 19,413,391$ 3,411,495$ 549,057$ 23,373,942$ 21,051,962$ 2,602,443$ 548,475$ 24,202,879$ 20,248,407$ 2,565,016$ 547,616$ 23,361,038$ 22,900,249$ 2,178,132$ 544,445$ 25,622,825$ 24,744,895$ 1,692,081$ 543,143$ 26,980,119$ 25,190,426$ 1,237,290$ 524,212$ 26,951,928$ 24,654,644$ 878,473$ 520,942$ 26,054,059$ 28,444,625$ 391,704$ 520,942$ 29,357,270$ 29,119,405$ 38,435$ 519,270$ 29,677,110$ 29,394,358$ -$ 517,712$ 29,912,069$ Current Year Outstanding Interest 2,660,203$ 29,561,667$ Principal 4,621,391$ 80,736,891 Transfers Out -$ - 7,281,594$ 110,298,558$ October, 2014 January, 2015 February, 2015 March, 2015 Revenues over/(under) expenses April, 2015 October, 2015 December, 2014 November, 2014 May, 2015 June, 2015 July, 2015 August, 2015 September, 2015 Rents, Concess. & Feees Other Finance Sources Interfund Transfers Fund Balance Appropriated Total Total Revenues: Intergovernmental Revenue Sales & Services Other Revenues HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2015 PUBLIC UTILITIES FUND Cash and Investments Debt Service and Transfer Requirements Department Admin/CSR/Meter Services Water Treatment Wastewater Treatment Wastewater Treatment SHWW Distribution Collections U:\My Documents\Monthly Reports\2015 - 2016\October 2015 - Financial Statements.xlsx 5 11/23/2015 FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 5,161,897$ 6,827,067$ 5,943,005$ 1,219,993$ 20.53%1,146,526$ 5,161,897$ 6,827,067$ 5,943,005$ 1,219,993$ 20.53%1,146,526$ FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 237,297$ 234,276$ 239,000$ 113$ 0.05%-$ - 25,000 130,000 - 0.00%- 5,006,315 5,153,491 5,111,300 1,057,473 20.69%1,247,240 378,116 2,081 400 10,139 #######175 243 276 - - 27 739,763 1,402,161 - - - - - - - - - - 462,305 - 0.00%- 6,361,734$ 6,817,285$ 5,943,005$ 1,067,725$ 17.97%1,247,442$ (152,268)$ 100,916$ Cash Sun Trust/BB&T First Bank NCCMT Total 160,831$ 456,391$ 422,540$ 59,824$ 1,099,587$ 182,041$ 425,002$ 394,917$ 59,824$ 1,061,785$ 372,508$ 425,018$ 395,198$ 59,824$ 1,252,548$ 350,504$ 379,409$ 365,494$ -$ 1,095,407$ 575,612$ 375,758$ 368,150$ -$ 1,319,520$ 954,650$ 359,056$ 333,965$ 443,279$ 2,090,950$ 1,166,505$ 343,248$ 333,965$ 387,764$ 2,231,482$ 1,347,614$ 316,331$ 312,432$ 387,764$ 2,364,141$ 1,654,243$ 296,898$ 294,942$ 415,261$ 2,661,345$ 2,189,209$ 290,527$ 289,211$ 356,254$ 3,125,201$ 1,734,168$ 294,082$ 268,860$ 356,254$ 2,653,365$ 1,239,986$ 267,007$ 268,860$ 356,254$ 2,132,107$ 635,163$ 256,610$ 253,226$ 296,324$ 1,441,322$ 783,054$ 237,379$ 234,622$ 296,324$ 1,551,379$ Current Year Outstanding Interest 127,831$ 335,060$ Principal 510,937 2,700,856 Transfers Out - - 638,767$ 3,035,917$ November, 2014 October, 2014 September, 2014 January, 2015 February, 2015 July, 2015 Revenues over/(under) expenses April, 2015 October, 2015 December, 2014 March, 2015 June, 2015 May, 2015 August, 2015 September, 2015 Rents, Concess. & Feees Other Finance Sources Interfund Transfers Fund Balance Appropriated Total HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2015 SOLID WASTE FUND Cash and Investments Debt Service and Transfer Requirements Department Solid Waste Total Revenues: Taxes Intergovernmental Revenue Sales & Services Other Revenues U:\My Documents\Monthly Reports\2015 - 2016\October 2015 - Financial Statements.xlsx 6 11/23/2015 FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year -$ 29,000$ 35,000$ 7,000$ 20.00%15,000$ 2,979,815 123,636 1,865,000 439,646 23.57%123,064 2,979,815$ 152,636$ 1,900,000$ 446,646$ 23.51%138,064$ FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 1,704,822$ 1,821,371$ 1,750,000$ 301,129$ 17.21%292,337$ 280,523 250,795 150,000 90,292 60.19%27,888$ - - - - 1,985,345$ 2,072,166$ 1,900,000$ 391,421$ 20.60%320,225$ (55,225)$ 182,161$ Cash NCCMT Total 1,329,590$ 1,211,772$ 2,541,362$ 1,238,990$ 1,211,772$ 2,450,762$ 1,234,512$ 1,211,772$ 2,446,284$ July, 2015 1,140,351$ 1,211,772$ 2,352,123$ 1,588,872$ 1,234,390$ 2,823,262$ May, 2015 1,273,019$ 562,026$ 1,835,045$ April, 2015 1,248,082$ 562,026$ 1,810,108$ March, 2015 1,114,579$ 562,026$ 1,676,605$ February, 2015 710,218$ 562,026$ 1,272,244$ January, 2015 678,017$ 562,026$ 1,240,043$ December, 2014 603,529$ 562,026$ 1,165,555$ November, 2014 740,749$ 562,026$ 1,302,775$ October, 2014 667,246$ 562,026$ 1,229,273$ 2,839,689$ 24,672 2,925,668$ Revenues over/(under) expenses Liability as of July 1 Current year claims and changes in estimates October, 2015 June, 2015 September, 2015 Actual claim payments Liability as of end of month Revenues: Departmental Charge Other revenues Fund Balance Appropriated Total August, 2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2015 WORKER'S COMPENSATION FUND Cash and Investments Liability 110,651 # of Claims this fiscal year 28 Category Fixed Cost Claims Funded Total U:\My Documents\Monthly Reports\2015 - 2016\October 2015 - Financial Statements.xlsx 7 11/23/2015 FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 83,514$ 121,440$ 254,588$ 33,468$ 13.15%31,493$ 83,514$ 121,440$ 254,588$ 33,468$ 13.15%31,493$ FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 282,984$ 228,950$ 254,588$ 77,925$ 30.61%74,900$ - - - - - - - - - - 282,984$ 228,950$ 254,588$ 77,925$ 30.61%74,900$ 44,457$ 43,407$ Cash NCCMT Total October, 2015 582,054$ 29,241$ 611,295$ September, 2015 554,324$ 29,241$ 583,566$ August, 2015 544,121$ 29,241$ 573,362$ July, 2015 533,487$ 29,241$ 562,729$ June, 2015 542,686$ 29,241$ 571,928$ May, 2015 534,685$ 29,241$ 563,926$ April, 2015 529,175$ 29,241$ 558,416$ March, 2015 520,088$ 29,241$ 549,330$ February, 2015 487,335$ 29,241$ 516,576$ January, 2015 502,826$ 29,241$ 532,068$ December, 2014 491,748$ 29,241$ 520,990$ November, 2014 461,196$ 29,241$ 490,437$ October, 2014 469,068$ 29,241$ 498,309$ September, 2014 402,040$ 29,241$ 431,281$ Total Revenues over/(under) expenses Cash and Investments Fund Balance Appropriated HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2015 EMPLOYEE CLINIC FUND Category Employee Clinic Total Revenues: Departmental Charge Other revenues U:\My Documents\Monthly Reports\2015 - 2016\October 2015 - Financial Statements.xlsx 8 11/23/2015 FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year -$ 5,205,337$ 5,500,000$ 1,922,541$ 34.96%1,200,569$ - 655,329 685,000 325,317 47.49%305,262 - 1,507 15,000 5,472 36.48%- -$ 5,862,173$ 6,200,000$ 2,253,330$ 36.34%1,505,831$ FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year -$ 6,687,178$ 6,200,000$ 2,142,403$ 34.55%2,442,382$ 588,107 10,783 - 15,504 10,783 588,107$ 6,697,961$ 6,200,000$ 2,157,907$ 34.80%2,453,165$ (95,423)$ 947,334$ Cash NCCMT Total 1,290,451$ 543,297$ 1,833,748$ 1,502,651$ 543,297$ 2,045,949$ 1,387,676$ 543,297$ 1,930,973$ 1,204,970$ 543,297$ 1,748,267$ 1,393,258$ 543,297$ 1,936,555$ 1,272,924$ 543,297$ 1,816,222$ 1,300,653$ 543,297$ 1,843,950$ 1,212,904$ 543,297$ 1,756,201$ 1,154,305$ 543,297$ 1,697,602$ 1,085,587$ 543,297$ 1,628,884$ 1,252,111$ 543,297$ 1,795,409$ 1,271,922$ 543,297$ 1,815,219$ 970,266$ 543,297$ 1,513,564$ Employees & Pre-65 Retirees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent 800 1,162 320,633.21$ 54,321.22$ 69.90%536,400.67$ 802 1,167 383,357.49$ 56,855.83$ 82.22%535,395.42$ 802 1,169 465,117.51$ 55,311.71$ 96.87%537,247.45$ 808 1,174 650,383.71$ 103,099.20$ 141.27%533,359.40$ 803 1,168 1,819,491.92$ 269,587.96$ 97.51%2,142,402.94$ December, 2014 May, 2016 July, 2015 August, 2015 September, 2015 October, 2015 November, 2015 December, 2015 January, 2016 February, 2016 March, 2016 April, 2016 HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2015 MEDICAL INSURANCE FUND Cash and Investments Medical Paid Claims Summary Category Paid Claims Wellness Total Revenues: Medical Premium Equivilents Other revenues Total Revenues over/(under) expenses October, 2015 April, 2015 Fixed Cost March, 2015 November, 2014 October, 2014 January, 2015 February, 2015 June, 2015 May, 2015 Year to Date (membership = avg) August, 2015 July, 2015 June, 2016 September, 2015 U:\My Documents\Monthly Reports\2015 - 2016\October 2015 - Financial Statements.xlsx 9 11/23/2015 FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year -$ 306,584$ 506,000$ 97,760$ 19.32%67,877$ - 35,323 40,000 12,158 30.40%11,818 -$ 341,907$ 546,000$ 109,918$ 20.13%79,695$ FYE 2014 UNAUDITED FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year -$ 544,448$ 546,000$ 118,547$ 21.71%124,169$ - - - - 166,433 -$ 544,448$ 546,000$ 118,547$ 21.71%290,602$ 8,629$ 210,907$ Cash NCCMT Total 242,621$ -$ 242,621$ 249,844$ -$ 249,844$ 249,852$ -$ 249,852$ 248,309$ -$ 248,309$ 247,472$ -$ 247,472$ 246,685$ -$ 246,685$ 246,310$ -$ 246,310$ 245,180$ -$ 245,180$ 232,347$ -$ 232,347$ 232,396$ -$ 232,396$ 228,907$ -$ 228,907$ 222,170$ -$ 222,170$ 210,907$ -$ 210,907$ Total Employees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent 399 653 14,975.40$ 6,090.62$ 70.66%29,813.15$ 398 651 31,428.55$ 3,033.66$ 116.21%29,654.93$ 399 650 28,953.57$ 3,033.66$ 106.13%30,140.02$ 403 654 30,171.44$ 3,033.66$ 114.74%28,939.38$ 400 652 105,528.96$ 15,191.60$ 101.83%118,547.48$ Dental Paid Claims Summary July, 2015 August, 2015 September, 2015 October, 2015 November, 2015 December, 2015 Year to Date (membership = avg) February, 2016 March, 2016 June, 2016 April, 2016 HARNETT COUNTY FINANCIAL SUMMARY REPORT October, 2015 DENTAL INSURANCE FUND Cash and Investments Category Paid Claims Fixed Cost Total Revenues: Dental Premium Equivilents Other revenues Total Revenues over/(under) expenses October, 2015 November, 2014 October, 2014 January, 2016 June, 2015 May, 2015 July, 2015 August, 2015 September, 2015 May, 2016 April, 2015 March, 2015 February, 2015 January, 2015 December, 2014 U:\My Documents\Monthly Reports\2015 - 2016\October 2015 - Financial Statements.xlsx 10