No preview available
HomeMy WebLinkAboutJanuary 2016 - Financial Statements2/22/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year $ 164,631 $ 158,070 $ 277,153 $ 160,829 58.03% $ 167,931 250,759 280,372 263,472 267,338 101.47% 254,176 103,351 8,609 69,617 114,879 165.02% 153,869 1 - - - 32,829 254,738 247,154 238,649 177,402 74.34% 184,967 303,532 305,481 442,442 166,642 37.66% 212,131 729,469 833,532 842,115 599,734 71.22% 613,244 77,704 79,320 411,771 50,724 12.32% 49,555 1,569,231 1,588,997 1,695,468 886,906 52.31% 879,185 140,485 153,360 161,852 80,973 50.03% 88,785 438,847 603,102 579,622 301,751 52.06%331,413 1,004,266 839,486 1,859,552 654,139 35.18% 357,939 194,790 209,741 219,108 88,257 40.28% 92,273 3,400,887 3,736,788 3,708,493 1,946,931 52.50% 1,718,652 730,166 695,654 790,642 417,040 52.75% 411,677 1,301,628 1,726,510 1,917,855 1,137,644 59.32% 1,133,023 432,327 436,602 615,987 348,342 56.55% 235,857 10,166,283 10,205,366 10,142,126 4,960,063 48.91% 5,484,463 354,232 389,674 480,900 232,879 48.43% 224,297 80,119 - - - - 15,213 1,607 46,161 23,765 51.48% 1,607 66,257 70,126 76,867 36,082 46.94% 40,050 26,536 - - - - 1,219,142 1,389,574 1,722,028 832,615 48.35% 706,053 School Resource Officers - - 691,067 335,654 48.57% - 4,306,490 4,407,161 4,792,299 2,362,223 49.29% 2,460,872 737,021 765,164 843,812 368,067 43.62% 403,512 32,000 - 60,000 - 0.00% - 3,991,897 4,080,768 4,323,965 2,193,049 50.72% 2,201,479 1,083,318 1,144,801 1,152,716 612,550 53.14% 569,275 3,314,704 3,361,704 3,361,704 2,241,136 66.67% 2,147,653 376,744 431,707 498,413 211,737 42.48% 218,884 50,000 47,050 65,000 23,950 36.85% 26,900 - 4,516 8,040 1,940 24.13%916 124,334 79,180 71,168 42,755 60.08% 48,027 240,521 236,688 - - 141,411 300,204 246,495 285,000 88,909 31.20% 122,778 174,955 208,990 209,736 84,980 40.52% 112,384 124,133 161,801 183,879 93,770 51.00% 82,837 4,000 4,000 4,000 4,000 100.00% 4,000 114,849 112,289 111,511 40,398 36.23% 43,572 449,748 458,253 576,000 239,449 41.57% 227,267 776,301 1,382,346 744,272 331,341 44.52% 413,097 1,321,571 1,362,552 1,365,164 715,481 52.41% 739,537 1,129 735 300 2 0.67% 140 31,903 57,241 36,298 19,331 53.26% 22,478 351,557 289,118 382,276 134,360 35.15% 136,380 31,419 25,623 16,836 7,799 46.32% 18,064 2,483 379 600 83 13.83% 298 158,263 44,813 58,354 24,104 41.31% 20,285 59,107 60,321 70,295 40,303 57.33% 35,078 Facilities Maintenance Register of Deeds 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 Animal Services Medical Examiner Planning & Inspections Community Development (BG) Abandoned MFG Home Cooperative Extension CCR&R - Block Grant Soil & Water Emergency Services Grant Transportation - Admin Campbell Deputies HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2016 GENERAL FUND CCR&R - United Way Emergency Medical Service EMS Transport Rescue Districts 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 Information Technology GIS Sheriff Tax General Services Fleet Maintenance Transportation U:\My Documents\Monthly Reports\2015 - 2016\January 2016 - Financial Statements.xlsx 1 2/22/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2016 GENERAL FUND FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 45,686 - 49,773 22,205 44.61% 24,502 27,367 50,723 - - - 13,570 - 11,107 3,492 31.44% 10,696 3,789 14,200 - - - - - 22,950 11,169 48.67% - 283,332 307,602 317,411 163,422 51.49% 160,842 51,769 64,108 63,870 33,753 52.85% 35,114 73,276 77,658 77,258 38,521 49.86% 43,309 326,783 328,753 378,328 181,658 48.02% 189,306 378,087 414,989 437,457 234,886 53.69% 223,986 5,787,018 6,014,268 7,269,516 3,285,061 45.19% 3,201,844 815,679 605,679 605,679 454,259 75.00% 354,259 9,359,396 10,155,398 10,585,495 5,641,522 53.29% 5,325,403 7,829,453 7,905,017 9,254,809 5,177,494 55.94% 4,344,022 172,197 178,634 183,173 99,498 54.32% 100,974 110,369 100,304 120,965 55,181 45.62% 59,641 99,840 90,780 145,000 121,298 83.65% 75,298 928,107 941,972 1,001,229 458,410 45.78% 518,821 100,000 150,000 153,000 3,000 1.96% - 363,011 403,871 455,928 242,419 53.17% 225,730 20,523,700 21,523,700 21,267,993 12,406,319 58.33% 12,555,492 - - 272,207 136,885 50.29% - 927,711 928,467 1,002,467 569,189 56.78% 535,189 - - - - - 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 21,922,023 16,696,675 76.16% 10,330,708 - - 489,926 - 0.00% - 105,234,405$ 137,544,080$ 122,870,483$ 69,781,956$ 56.79%61,912,903$ FYE 2014 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$ 51,513,025$ 94.88%49,739,342$ 3,949,979 5,712,141 5,654,182 2,955,314 52.27%2,758,254 14,884,497 16,757,810 16,154,459 5,246,063 32.47%4,587,955 1,037,719 1,053,493 1,200,000 586,109 48.84%444,763 2,763,205 2,515,489 3,723,455 1,508,575 40.52%1,161,999 19,304,274 18,884,854 18,919,176 8,225,746 43.48%7,561,992 7,658,151 7,838,973 8,839,415 3,804,918 43.04%3,476,753 3,451,519 3,741,739 3,501,185 1,336,214 38.16%1,976,229 77,898 77,652 78,779 47,570 60.38%25,351 857,548 29,108,938 6,388,000 5,938,000 92.96%3,896 460,947 322,415 55,656 7,501 13.48%- - - 4,060,833 - 0.00%- 108,566,559$ 139,944,211$ 122,870,483$ 81,169,035$ 66.06%71,736,534$ 2,400,131$ 11,387,079$ 9,823,631 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\January 2016 - Financial Statements.xlsx 2 2/22/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2016 GENERAL FUND Cash Tax Lockbox MBS NCCMT Total 10,575,231$ -$ 4,715,250$ 27,749,119$ 43,039,600$ 638,944$ -$ 4,715,250$ 27,050,869$ 32,405,064$ -$ -$ 4,715,250$ 24,697,474$ 29,412,724$ -$ -$ 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$ 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$ Unassigned Fund Balance - January, 2015 January, 2016 June, 2015 Cash and Investments Estimated Fund Balance March, 2015 October, 2015 September, 2015 December, 2015 November, 2015 April, 2015 May, 2015 July, 2015 August, 2015 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. Debt Service and Transfer Requirements U:\My Documents\Monthly Reports\2015 - 2016\January 2016 - Financial Statements.xlsx 3 2/22/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2016 GENERAL FUND Unassigned Fund Balance at June 30, 2015 19,417,388$ 17.89% Year to Date Revenues over/(under) Expenditures 11,387,079 30,804,467 Remaining Debt Payments for this Year (5,225,348) Outstanding budget amendments - Year to Date Fund Balance Appropriated (4,060,833) (9,286,181) 21,518,286$ 17.51% Amount by which fund balance percentage will change 1,228,705$ 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 Harnett 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\January 2016 - Financial Statements.xlsx 4 2/22/2016 FYE 2014 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,620,244$ 3,541,079$ 30.47%11,862,211$ 3,671,291 3,965,881 4,466,822 2,142,043 47.95%1,803,167 1,965,319 1,908,016 2,397,828 873,496 36.43%955,190 1,860,402 1,869,169 2,354,624 973,614 41.35%845,474 3,383,463 3,607,800 4,578,923 1,909,933 41.71%1,933,098 2,975,052 3,006,906 3,363,958 1,431,700 42.56%1,397,963 33,084,560$ 54,835,735$ 28,782,399$ 10,871,865$ 37.77%18,797,103$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 3,703$ 3,703$ 3,703$ 3,703$ 100.00%3,703$ 30,275,723 30,134,602 26,984,920 17,018,975 63.07%17,338,314 13,281,536 119,895,351 1,793,776 577,838 32.21%616,542 96 172 - - 14 473,683 13,731,430 - - 1,440,315 150,000 1,452,130 - - 652,130 - - - - - 44,184,741$ 165,217,388$ 28,782,399$ 17,600,516$ 61.15%20,051,018$ 6,728,651$ 1,253,915$ Cash Lockbox NCCMT Total 29,009,846$ 3,010,381$ 554,829$ 32,575,057$ 24,228,551$ 3,662,494$ 553,621$ 28,444,666$ 24,058,100$ 3,267,333$ 552,071$ 27,877,505$ 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$ 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$ January, 2015 February, 2015 March, 2015 Revenues over/(under) expenses April, 2015 January, 2016 August, 2015 September, 2015 October, 2015 November, 2015 December, 2015 May, 2015 June, 2015 July, 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 January, 2016 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\January 2016 - Financial Statements.xlsx 5 2/22/2016 FYE 2014 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$ 6,034,005$ 2,631,670$ 43.61%2,228,944$ 5,161,897$ 6,827,067$ 6,034,005$ 2,631,670$ 43.61%2,228,944$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 237,297$ 234,276$ 239,000$ 63,515$ 26.58%59,931$ - 25,000 130,000 - 0.00%- 5,006,315 5,165,089 5,111,300 3,800,806 74.36%4,027,364 378,116 499,631 91,400 133,743 146.33%1,323 243 276 - 251 119 739,763 1,402,161 - - - - - - - - - - 462,305 - 0.00%- 6,361,734$ 7,326,433$ 6,034,005$ 3,998,315$ 66.26%4,088,737$ 1,366,645$ 1,859,793$ Cash Sun Trust/BB&T First Bank NCCMT Total 1,838,468$ 495,010$ 469,484$ 123,226$ 2,926,188$ 1,157,547$ 482,090$ 451,079$ 123,226$ 2,213,942$ 795,755$ 469,359$ 439,402$ 123,226$ 1,827,742$ 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$ Current Year Outstanding Interest 127,831$ 335,060$ Principal 510,937 2,700,856 Transfers Out - - 638,767$ 3,035,917$ August, 2015 January, 2015 February, 2015 July, 2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2016 SOLID WASTE FUND Cash and Investments Debt Service and Transfer Requirements Department Solid Waste Total Revenues: Taxes Intergovernmental Revenue Sales & Services Other Revenues Rents, Concess. & Feees Other Finance Sources Interfund Transfers December, 2015 Fund Balance Appropriated Total Revenues over/(under) expenses April, 2015 January, 2016 September, 2015 October, 2015 November, 2015 March, 2015 June, 2015 May, 2015 U:\My Documents\Monthly Reports\2015 - 2016\January 2016 - Financial Statements.xlsx 6 2/22/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year -$ 29,000$ 35,000$ 14,000$ 40.00%-$ 2,979,815 123,636 1,865,000 739,646 39.66%395,064 2,979,815$ 152,636$ 1,900,000$ 753,646$ 39.67%395,064$ FYE 2014 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$ 534,141$ 30.52%513,464$ 280,523 250,795 150,000 106,600 71.07%74,532$ - - - - 1,985,345$ 2,072,166$ 1,900,000$ 640,741$ 33.72%587,996$ (112,905)$ 192,932$ Cash NCCMT Total 1,556,134$ 1,211,772$ 2,767,906$ 1,193,599$ 1,211,772$ 2,405,371$ 1,273,094$ 1,211,772$ 2,484,866$ 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$ 2,839,689$ 72,627 2,903,170$ Revenues over/(under) expenses Liability as of July 1 Current year claims and changes in estimates January, 2016 June, 2015 September, 2015 Actual claim payments Liability as of end of month Revenues: Departmental Charge Other revenues Fund Balance Appropriated Total August, 2015 October, 2015 November, 2015 December, 2015 HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2016 WORKER'S COMPENSATION FUND Cash and Investments Liability 136,107 # of Claims this fiscal year 44 Category Fixed Cost Claims Funded Total U:\My Documents\Monthly Reports\2015 - 2016\January 2016 - Financial Statements.xlsx 7 2/22/2016 FYE 2014 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$ 63,132$ 24.80%62,224$ 83,514$ 121,440$ 254,588$ 63,132$ 24.80%62,224$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 282,984$ 228,950$ 254,588$ 137,800$ 54.13%132,500$ - - - - - - - - - - 282,984$ 228,950$ 254,588$ 137,800$ 54.13%132,500$ 74,668$ 70,276$ Cash NCCMT Total January, 2016 612,081$ 29,241$ 641,322$ December, 2015 602,255$ 29,241$ 631,496$ November, 2015 592,428$ 29,241$ 621,670$ 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$ Total Revenues over/(under) expenses Cash and Investments Fund Balance Appropriated HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2016 EMPLOYEE CLINIC FUND Category Employee Clinic Total Revenues: Departmental Charge Other revenues U:\My Documents\Monthly Reports\2015 - 2016\January 2016 - Financial Statements.xlsx 8 2/22/2016 FYE 2014 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$ 3,339,440$ 60.72%2,482,274$ - 655,329 685,000 495,508 72.34%468,410 - 1,507 15,000 7,174 47.83%- -$ 5,862,173$ 6,200,000$ 3,842,122$ 61.97%2,950,683$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year -$ 6,687,178$ 6,200,000$ 3,777,520$ 60.93%4,032,376$ 588,107 10,783 - 23,422 10,783 588,107$ 6,697,961$ 6,200,000$ 3,800,942$ 61.31%4,043,159$ (41,180)$ 1,092,476$ Cash NCCMT Total 1,351,919$ 543,297$ 1,895,216$ 1,222,061$ 543,297$ 1,765,358$ 1,387,910$ 543,297$ 1,931,207$ 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$ 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$ 808 1,173 531,699.65$ 59,136.25$ 108.27%545,697.46$ 812 1,177 448,829.22$ 52,614.19$ 92.18%544,006.75$ 820 1,191 418,525.31$ 56,097.08$ 86.93%545,957.33$ 807 1,173 3,218,546.10$ 437,435.48$ 96.77%3,778,064.48$ February, 2016 March, 2016 April, 2016 HARNETT COUNTY FINANCIAL SUMMARY REPORT January, 2016 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 January, 2016 April, 2015 January, 2015 February, 2015 Year to Date (membership = avg) June, 2016 May, 2016 July, 2015 August, 2015 September, 2015 October, 2015 November, 2015 December, 2015 January, 2016 December, 2015 November, 2015 October, 2015 Fixed Cost March, 2015 June, 2015 May, 2015 August, 2015 July, 2015 September, 2015 U:\My Documents\Monthly Reports\2015 - 2016\January 2016 - Financial Statements.xlsx 9 2/22/2016 FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year -$ 306,584$ 506,000$ 165,883$ 32.78%133,287$ - 35,323 40,000 21,273 53.18%20,467 -$ 341,907$ 546,000$ 187,156$ 34.28%153,753$ FYE 2014 FYE 2015 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year -$ 544,448$ 546,000$ 208,818$ 38.25%386,148$ - - - - 166,433 -$ 544,448$ 546,000$ 208,818$ 38.25%552,581$ 21,662$ 398,828$ Cash NCCMT Total 255,653$ -$ 255,653$ 257,742$ -$ 257,742$ 251,362$ -$ 251,362$ 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$ 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 651 19,987.80$ 3,010.36$ 74.83%30,735.68$ 400 651 20,264.80$ 3,047.64$ 77.38%30,126.24$ 409 661 27,163.98$ 3,056.96$ 102.76%29,408.35$ 401 653 172,945.54$ 24,306.56$ 94.46%208,817.75$ 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 January, 2016 DENTAL INSURANCE FUND Cash and Investments Category Paid Claims Fixed Cost Total Revenues: Dental Premium Equivilents Other revenues Total Revenues over/(under) expenses January, 2016 January, 2016 June, 2015 May, 2015 July, 2015 August, 2015 September, 2015 October, 2015 November, 2015 December, 2015 May, 2016 April, 2015 March, 2015 February, 2015 January, 2015 U:\My Documents\Monthly Reports\2015 - 2016\January 2016 - Financial Statements.xlsx 10