No preview available
HomeMy WebLinkAboutJuly 2015 - Financial Statements10/6/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 $ 33,955 13.43% $ 48,018 250,759 280,372 258,472 20,101 7.78% 46,236 103,351 8,609 69,617 10,221 14.68% 35,583 1 - - 2,899 4,681 254,738 247,154 238,649 19,146 8.02% 43,487 303,532 305,481 442,442 32,728 7.40% 44,569 729,469 833,532 842,115 38,022 4.52% 90,834 77,704 79,320 406,771 3,320 0.82% 70,284 1,569,231 1,588,997 1,695,468 93,278 5.50% 359,748 140,485 153,360 161,852 5,949 3.68% 13,045 438,847 603,102 579,622 17,989 3.10% 178,707 1,004,266 839,486 1,155,904 22,694 1.96% 113,027 194,790 209,741 228,181 7,051 3.09% 16,056 3,400,887 3,736,788 3,581,926 225,614 6.30% 1,467,789 730,166 695,654 790,642 22,367 2.83% 44,609 1,301,628 1,726,510 1,869,699 214,925 11.50% 342,389 432,327 436,602 615,987 30,713 4.99% 37,526 10,166,283 10,205,366 10,399,446 425,324 4.09% 1,308,104 354,232 389,674 480,900 16,494 3.43% 27,727 80,119 - - - - 15,213 1,607 - - - 66,257 70,126 76,867 2,775 3.61% 5,302 26,536 - - - - - - - - - 1,219,142 1,389,574 1,646,452 62,726 3.81% 109,368 School Resource Officer - - - - - 4,306,490 4,407,161 4,788,898 294,819 6.16% 648,968 737,021 765,164 832,708 23,248 2.79% 88,811 32,000 - - - - 3,991,897 4,080,768 4,192,145 146,159 3.49% 518,805 1,083,318 1,144,801 1,150,414 39,006 3.39% 176,832 3,314,704 3,361,704 3,361,704 280,142 8.33% 280,142 376,744 431,707 493,913 13,579 2.75% 52,878 50,000 47,050 65,000 - 0.00% 4,050 - 4,516 8,040 - 0.00%- 124,334 79,180 62,956 5,229 8.31% 4,479 240,521 236,688 - - 59,443 300,204 246,495 285,000 8,505 2.98% 120,265 174,955 208,990 184,736 6,167 3.34% 133,741 124,133 161,801 183,879 7,212 3.92% 12,634 4,000 4,000 4,000 - 0.00% - 114,849 112,289 111,511 - 0.00% - 449,748 458,253 575,000 - 0.00% 20,500 776,301 1,382,346 611,047 23,096 3.78% 152,616 1,321,571 1,362,552 1,329,816 60,771 4.57% 115,774 1,129 735 300 - 0.00% - 31,903 57,241 32,423 806 2.48% 2,641 351,557 289,118 382,326 4,378 1.15% 10,597 31,419 25,623 12,256 - 0.00% 3,770 2,483 379 600 - 0.00% - 158,263 44,813 14,688 - 0.00% - 59,107 60,321 66,898 2,964 4.43% 5,156 Planning & Inspections Community Development (BG) Abandoned MFG Home Cooperative Extension CCR&R - Block Grant Soil & Water Environmental Protection Forestry Program Economic/Physical Dev. App. Industrial Development JCPC Admin Public Safety Appropriations Emergency Telephone System Radio System Harnett Regional Jetport Emergency Medical Service EMS Transport Rescue Districts Animal Services Medical Examiner Transportation - Admin Life is Fragile (NCGCC) Communications Jail Emergency Services Emergency Services Grant Campbell Deputies Harnett CJPP Sheriff's Department Grants Child Support Enforcement Governor's Highway Safety HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2015 GENERAL FUND Department Governing Body Administration Legal Services Engineering Human Resources Board of Elections Finance Clerk of Court Facilities Maintenance Register of Deeds Information Technology GIS Sheriff Tax General Services Fleet Maintenance Transportation CCR&R - United Way Parents As Teachers Adolescent Parenting U:\My Documents\Monthly Reports\2015 - 2016\July 2015 - Financial Statements.xlsx 1 10/6/2015HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 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 50,723 49,773 955 1.92% 2,812 27,367 - - - - 13,570 14,200 50,422 395 0.78% - 3,789 - - - - - - 22,580 2,630 11.65% - 283,332 307,602 317,411 5,577 1.76% 7,681 51,769 64,108 63,339 2,079 3.28% 8,874 73,276 77,658 76,483 2,704 3.53% 5,238 326,783 328,753 336,137 15,611 4.64% 56,553 378,087 414,989 433,882 2,427 0.56% 284,144 5,787,018 6,014,268 6,809,798 241,058 3.54% 1,449,564 815,679 605,679 605,679 51,420 8.49% 51,420 9,359,396 10,155,398 10,584,895 536,346 5.07% 813,905 7,829,453 7,905,017 9,219,706 508,104 5.51% 476,279 172,197 178,634 178,173 7,473 4.19% 16,962 110,369 100,304 120,965 3,397 2.81% 7,535 99,840 90,780 99,000 6,000 6.06% 54,000 928,107 941,972 973,229 38,545 3.96% 141,456 100,000 150,000 150,000 - 0.00% - 363,011 403,871 455,928 61,747 13.54% 123,851 20,523,700 21,523,700 21,267,993 1,772,333 8.33% 1,793,642 - - 255,707 - 0.00% - 927,711 928,467 917,467 76,456 8.33% 76,456 - - - - - 25,000 25,000 25,000 - 0.00% - 1,903,876 64,701 283,334 - 0.00% - 13,902,144 44,265,436 16,033,752 596,069 3.72% 14,677 - - 1,019,000 - 0.00% - 105,234,405$ 137,544,080$ 114,893,811$ 6,155,699$ 5.36%12,204,238$ 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$ 103,363$ 0.19%-$ 3,949,979 5,712,141 5,654,182 247 0.00%- 14,884,497 16,757,810 16,154,459 - 0.00%- 1,037,719 1,053,493 1,200,000 97,146 8.10%- 2,763,205 2,515,489 3,106,455 195,441 6.29%163,552 19,304,274 18,884,854 18,726,881 550,835 2.94%505,310 7,658,151 7,818,258 8,745,830 162,507 1.86%227,004 3,451,519 3,737,358 3,303,891 20,368 0.62%624,271 77,898 77,652 78,779 1,014 1.29%1,027 857,548 29,108,938 1,008,803 - 0.00%- 460,947 322,415 - - - - - 2,600,000 - 0.00%- 108,566,559$ 139,919,115$ 114,874,623$ 1,130,921$ 0.98%1,521,164$ (5,024,778)$ (10,683,074) Special Programs 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 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 Cultural & Recreational App. Parks & Recreation Education CAP - Disabled Adults RSVP 4-H Teen Court & At Risk Child Care Youth Training Race to the Top Adolescent Parenting Department on Aging Department CCR&R - Smart Start Mental Health Social Services Public Assistance Veteran's Services Restitution Family Caregiver Support Motor Vehicles Sales Tax Other taxes Interfund Transfers Debt Service Contingency Total Revenues: U:\My Documents\Monthly Reports\2015 - 2016\July 2015 - Financial Statements.xlsx 2 10/6/2015HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2015 GENERAL FUND Cash Tax Lockbox MBS NCCMT Total 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$ -$ 475$ -$ 26,396,094$ 26,396,569$ -$ 475$ -$ 19,277,617$ 19,278,091$ -$ 475$ -$ 20,554,835$ 20,555,310$ 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$ April, 2015 May, 2015 July, 2014 January, 2015 November, 2014 October, 2014 September, 2014 August, 2014 July, 2015 Cash and Investments Debt Service and Transfer Requirements Estimated Fund Balance March, 2015 June, 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 U:\My Documents\Monthly Reports\2015 - 2016\July 2015 - Financial Statements.xlsx 3 10/6/2015HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2015 GENERAL FUND Unassigned Fund Balance at June 30, 2014 18,732,095$ 17.90% Unaudited 06/30/2015 Revenues over/(under) Expenditures 2,375,035$ Year to Date Revenues over/(under) Expenditures (5,024,778) 16,082,352 Remaining Debt Payments for this Year (15,437,683) Outstanding budget amendments - Year to Date Fund Balance Appropriated (2,600,000) (18,037,683) (1,955,331)$ -1.70% Amount by which fund balance percentage will change 1,148,938$ If the County were to stop operations at the end of this month and had nofurtherreceivablesorpayables,thenthiswouldbetheestimated 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\July 2015 - Financial Statements.xlsx 4 10/6/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$ 278,426$ 2.37%1,536,786$ 3,671,291 3,965,881 4,336,822 163,399 3.77%2,068,283 1,965,319 1,908,016 2,397,828 62,879 2.62%804,018 1,860,402 1,869,169 2,354,624 63,978 2.72%760,041 3,383,463 3,607,800 4,578,923 149,379 3.26%1,401,541 2,975,052 3,006,906 3,363,958 131,428 3.91%1,220,040 33,084,560$ 54,835,735$ 28,782,399$ 849,488$ 2.95%7,790,710$ 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 2,900,148 10.75%2,267,013 13,281,536 2,023,404 1,793,776 42,653 2.38%43,003 96 172 - - - 473,683 13,731,430 - - 610,494 150,000 1,452,130 - - - - - - - - 44,184,741$ 47,345,441$ 28,782,399$ 2,942,801$ 10.22%2,920,509$ 2,093,313$ (4,870,200)$ Cash Lockbox NCCMT Total 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$ 28,441,620$ -$ 517,378$ 28,958,997$ 25,475,483$ -$ 516,449$ 25,991,932$ 25,392,786$ -$ 515,469$ 25,908,254$ 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$ Revenues over/(under) expenses August, 2014 July, 2014 April, 2015 July, 2015 December, 2014 November, 2014 October, 2014 September, 2014 January, 2015 February, 2015 March, 2015 May, 2015 June, 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 July, 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\July 2015 - Financial Statements.xlsx 5 10/6/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$ 92,921$ 1.56%853,728$ 5,161,897$ 6,827,067$ 5,943,005$ 92,921$ 1.56%853,728$ 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$ -$ 0.00%-$ - 25,000 130,000 - 0.00%- 5,006,315 5,153,491 5,111,300 7,581 0.15%27,807 378,116 2,081 400 136 34.11%25 243 276 - - - 739,763 1,402,161 - - - - - - - - - - 462,305 - 0.00%- 6,361,734$ 6,817,285$ 5,943,005$ 7,717$ 0.13%27,832$ (85,204)$ (825,895)$ Cash Sun Trust First Bank NCCMT Total 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$ 513,937$ 202,029$ 206,671$ 296,324$ 1,218,960$ 481,103$ 193,679$ 199,824$ 242,829$ 1,117,436$ 709,310$ 153,450$ 169,118$ 242,829$ 1,274,707$ 1,018,519$ 153,450$ 169,118$ 242,829$ 1,583,916$ Current Year Outstanding Interest 127,831$ 335,060$ Principal 510,937 2,700,856 Transfers Out - - 638,767$ 3,035,917$ Revenues over/(under) expenses August, 2014 July, 2014 June, 2014 May, 2014 April, 2015 July, 2015 December, 2014 November, 2014 October, 2014 September, 2014 January, 2015 February, 2015 March, 2015 June, 2015 May, 2015 Rents, Concess. & Feees Other Finance Sources Interfund Transfers Fund Balance Appropriated Total HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 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\July 2015 - Financial Statements.xlsx 6 10/6/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$ -$ 0.00%-$ 2,979,815 123,636 1,865,000 267,146 14.32%131,064 2,979,815$ 152,636$ 1,900,000$ 267,146$ 14.06%131,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$ 74,261$ 4.24%8,634$ 280,523 250,795 150,000 22,682 15.12%- - - - - - 1,985,345$ 2,072,166$ 1,900,000$ 96,943$ 5.10%8,634$ (170,203)$ (122,430)$ Cash NCCMT Total July, 2015 1,140,351$ 1,211,772$ 2,352,123$ June, 2015 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$ September, 2014 361,074$ 562,026$ 923,101$ August, 2014 368,074$ 562,026$ 930,101$ July, 2014 362,656$ 562,026$ 924,682$ 2,839,689$ 120 2,854,048$ Revenues over/(under) expenses Liability as of July 1 Current year claims and changes in estimates Actual claim payments Liability as of end of month Revenues: Departmental Charge Other revenues Fund Balance Appropriated Total HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2015 WORKER'S COMPENSATION FUND Cash and Investments Liability 14,478 # of Claims this fiscal year 6 Category Fixed Cost Claims Funded Total U:\My Documents\Monthly Reports\2015 - 2016\July 2015 - Financial Statements.xlsx 7 10/6/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$ 4,110$ 1.61%5,905$ 83,514$ 121,440$ 254,588$ 4,110$ 1.61%5,905$ 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$ 19,400$ 7.62%-$ - - - - - - - - - - 282,984$ 228,950$ 254,588$ 19,400$ 7.62%-$ 15,290$ (5,905)$ Cash NCCMT Total 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$ August, 2014 409,914$ 29,241$ 439,155$ July, 2014 419,756$ 29,241$ 448,997$ Total Revenues over/(under) expenses Cash and Investments Fund Balance Appropriated HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2015 EMPLOYEE CLINIC FUND Category Employee Clinic Total Revenues: Departmental Charge Other revenues U:\My Documents\Monthly Reports\2015 - 2016\July 2015 - Financial Statements.xlsx 8 10/6/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$ 607,638$ 11.05%153,256$ - 655,329 685,000 109,667 16.01%- - 1,507 15,000 - 0.00%- -$ 5,862,173$ 6,200,000$ 717,305$ 11.57%153,256$ 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$ 536,401$ 8.65%516,539$ 588,107 10,783 - - - 588,107$ 6,697,961$ 6,200,000$ 536,401$ 8.65%516,539$ (180,904)$ 363,283$ Cash NCCMT Total 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$ 1,086,724$ 543,297$ 1,630,021$ 1,042,547$ 543,297$ 1,585,844$ 768,924$ 543,297$ 1,312,222$ 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$ 800 1,162 320,633.21$ 54,321.22$ 69.90%536,400.67$ June, 2016 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 July, 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 July, 2015 April, 2015 December, 2014 Fixed Cost March, 2015 November, 2014 October, 2014 January, 2015 February, 2015 September, 2014 August, 2014 July, 2014 June, 2015 May, 2015 Year to Date (membership = avg) U:\My Documents\Monthly Reports\2015 - 2016\July 2015 - Financial Statements.xlsx 9 10/6/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$ 12,461$ 2.46%5,132$ - 35,323 40,000 3,034 7.58%- -$ 341,907$ 546,000$ 15,495$ 2.84%5,132$ 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$ 29,813$ 5.46%31,075$ - - - - - -$ 544,448$ 546,000$ 29,813$ 5.46%31,075$ 14,318$ 25,943$ Cash NCCMT Total 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$ 203,941$ -$ 203,941$ 204,905$ -$ 204,905$ 192,296$ -$ 192,296$ 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$ 399 653 14,975.40$ 6,090.62$ 70.66%29,813.15$ 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 July, 2015 DENTAL INSURANCE FUND Cash and Investments Category Paid Claims Fixed Cost Total Revenues: Dental Premium Equivilents Other revenues Total Revenues over/(under) expenses July, 2015 November, 2014 October, 2014 September, 2014 January, 2016 August, 2014 July, 2014 June, 2015 May, 2015 May, 2016 April, 2015 March, 2015 February, 2015 January, 2015 December, 2014 U:\My Documents\Monthly Reports\2015 - 2016\July 2015 - Financial Statements.xlsx 10