Loading...
HomeMy WebLinkAboutJuly 2017 - Financial StatementsHARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 GENERAL FUND FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 208,357$ 254,969$ 325,151$ 70,940$ 21.82%88,512$ 294,293 403,671 502,462 31,347 6.24%29,442 53,919 77,852 160,511 9,083 5.66%9,820 205,162 245,482 286,243 24,232 8.47%22,714 381,191 406,505 528,246 37,135 7.03%37,231 811,001 835,098 1,021,531 69,942 6.85%48,203 - 326,831 520,000 36,299 6.98%19,972 81,438 92,784 87,273 8,320 9.53%11,740 1,709,486 1,587,900 1,743,220 136,445 7.83%140,883 158,173 155,139 188,368 8,328 4.42%6,632 543,249 526,986 610,237 24,775 4.06%57,196 1,523,150 1,680,191 1,550,350 44,663 2.88%40,924 194,529 241,628 283,858 27,848 9.81%5,948 3,667,427 2,691,807 2,894,508 535,091 18.49%120,210 759,735 767,909 837,668 28,990 3.46%30,070 1,787,734 1,960,616 2,218,957 212,964 9.60%316,605 581,109 591,881 656,685 30,287 4.61%41,496 9,677,549 9,596,512 10,547,735 533,195 5.06%499,712 442,623 456,980 521,648 22,262 4.27%19,952 26,924 19,237 - - - 66,653 78,800 84,647 3,540 4.18%3,309 1,624,091 1,611,476 1,925,480 168,145 8.73%153,783 School Resource Officers 682,489 731,356 778,555 39,647 5.09%32,492 4,551,465 4,549,392 5,304,517 339,912 6.41%386,395 730,739 816,266 965,819 33,265 3.44%33,450 - 58,000 17,959 - - 4,414,723 6,203,591 6,922,831 352,257 5.09%326,310 1,151,492 14 - - 14 3,361,704 3,361,704 3,462,557 288,546 8.33%560,284 438,575 436,128 514,075 20,287 3.95%20,150 89,900 65,900 90,000 - 3,700 6,886 5,016 5,037 - - 71,908 75,361 75,000 - - - - - - - - - - - - 198,422 189,136 188,816 21,642 11.46%16,698 178,736 174,501 198,518 5,993 3.02%8,001 4,000 4,000 4,000 4,000 100.00%4,000 101,648 100,108 115,111 - - 509,983 575,679 575,000 - - Animal Services Soil & Water EMS Transport Rescue Districts Emergency Medical Service Insurance - Retirees Clerk of Court Board of Elections Finance Tax Department Governing Body Administration General Services Fleet Maintenance Transportation Transportation - Admin Sheriff's Department Grants Child Support Enforcement Communications Jail Emergency Services Legal Services Environmental Protection Forestry Program Economic/Physical Dev. App. JCPC Admin Public Safety Appropriations Emergency Telephone System Radio System Harnett Regional Jetport Medical Examiner Human Resources Facilities Maintenance Register of Deeds Information Technology GIS Sheriff Campbell Deputies Emergency Services Grant U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 1 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 GENERAL FUND FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 436,558 1,013,262 1,266,367 84,859 6.70%28,954 1,309,860 1,346,739 1,544,371 73,546 4.76%71,840 192 19,116 1,500 - - 32,171 21,672 24,126 1,047 4.34%966 314,013 362,908 441,981 22,069 4.99%22,642 24,494 25,676 31,903 1,766 5.54%713 150 - - - - 59,354 - - - - 76,776 77,114 80,643 3,108 3.85%3,656 72,035 45,232 55,741 1,641 2.94%1,442 - - - - - 4,034 657 - - - - - - - - 30,035 20,764 34,500 - 854 315,244 316,827 337,114 7,049 2.09%19,955 61,164 67,657 70,714 2,819 3.99%2,801 77,511 83,864 90,228 3,403 3.77%3,208 329,421 324,799 363,487 14,483 3.98%16,273 432,337 405,411 439,938 23,314 5.30%49,164 6,082,878 5,745,786 5,899,716 284,627 4.82%310,125 605,679 605,679 605,679 151,420 25.00%151,420 10,324,942 11,805,835 12,667,464 518,341 4.09%613,907 9,351,002 9,115,140 9,193,826 544,412 5.92%480,489 180,399 209,801 270,472 11,644 4.31%9,326 103,322 100,593 113,530 4,385 3.86%4,755 136,805 35,964 45,000 - - 910,122 956,129 1,143,603 41,096 3.59%46,829 153,000 185,000 150,000 - - 435,005 784,296 1,024,702 140,809 13.74%145,347 - - 920,000 - - - 72,542 200,000 - - 21,267,993 21,420,138 21,068,027 1,755,669 8.33%3,538,336 280,707 122,625 750,000 - - 993,967 1,055,200 2,199,000 - - - 1,019,467 1,080,450 90,038 8.33%84,956 - 26,197 30,000 - - - 798,517 - - 66,543 - - - - - 70,000 - - - - $ 95,761,633 $ 100,147,013 $ 108,856,655 $ 6,950,925 6.39% $ 8,770,349 CCR&R - United Way Child Care Youth Training Race to the Top Adolescent Parenting - BJRH Department on Aging Restitution CAP - Disabled Adults 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 4-H Teen Court & At Risk Adolescent Parenting Parents As Teachers Cultural & Recreational App. Parks & Recreation Education Special Programs Subtotal - Operating Expenditures Development Services Community Development (BG) Abandoned MFG Home Cooperative Extension CCR&R - Block Grant Central Carolina - health sciences Department Central Carolina - DOT Social Services Public Assistance Veteran's Services Family Caregiver Support RSVP Board of Education - teachers Industrial Development Board of Education - add teach Mental Health Board of Education - reserve U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 2 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 GENERAL FUND FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 2,145,446 3,628,409 1,026,667 - - 4,745,868 3,797,744 5,086,417 43,630 0.86%19,566 11,551,602 12,916,628 14,204,731 1,009,285 7.11%562,228 213,601 (3,131) - - - 36,177,890 - - - - - - 495,558 - - 54,834,407$ 20,339,650$ 20,813,373$ 1,052,915$ 5.06% 581,794$ 150,596,040$ 120,486,663$ 129,670,028$ 8,003,840$ 6.17% 9,352,143$ FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 55,082,717$ 56,343,022$ 685,000$ 60,512$ 8.83%160,736$ 6,190,412 6,637,839 5,000 - - 19,279,813 18,959,961 20,655,250 - - 1,220,493 1,209,416 1,325,000 109,133 8.24%104,953 2,965,577 2,961,556 3,834,840 216,459 5.64%259,993 20,274,012 18,892,825 21,595,840 480,011 2.22%522,799 9,204,896 9,662,383 8,214,195 160,105 1.95%316,819 3,343,042 3,204,306 6,164,683 19,218 0.31%280,373 73,655 67,075 74,808 5,697 7.62%6,386 117,634,617$ 117,938,383$ 62,554,616$ 1,051,135$ 1.68% 1,652,059$ 97,339 274,949 225,000 7,694 3.42%3 37,018,000 24,951 - - - 7,501 2,746 6,045,468 - - - - (5,040) - - 37,122,840$ 302,646$ 6,265,428$ 7,694$ 0.12% 3$ 154,757,457$ 118,241,029$ 68,820,044$ 1,058,829$ 1.54% 1,652,062$ 4,161,417$ (2,245,634)$ (6,945,011)$ (7,700,081)$ Department Real and Personal Other Financing Sources Interfund Transfers Fund Balance Appropriated Total Revenues Permits & Fees Intergovernmental Revenue Sales & Services Other Revenues Revenues over / (under) expenditures Rents, Concessions & Fees Ad Valorem Taxes Subtotal Other Financing Uses: Subtotal - Operating Revenues Subtotal Other Financing Sources: Motor Vehicles Other taxes Investment Earnings Sales Tax Interfund Transfers Debt Service Contingency Total Expenditures Source Cost of Issuance Interest Principal Other Financing Uses U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 3 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 GENERAL FUND PNC Fidelity MBS NCCMT Total July 2017 257,261$ 52,430$ 12,833,501$ 14,699,895$ 27,843,087$ June 2017 7,182,432$ 52,430$ 12,833,501$ 13,721,198$ 33,789,562$ May 2017 2,108,133$ 52,430$ 12,883,875$ 21,669,408$ 36,713,847$ April 2017 -$ 102,890$ 12,883,875$ 29,247,908$ 42,234,673$ March 2017 9,318,753$ 50,000$ 10,900,020$ 28,346,806$ 48,615,578$ February 2017 10,966,173$ 50,000$ 10,900,020$ 23,550,367$ 45,466,559$ January 2017 16,539,974$ 50,000$ 10,900,020$ 21,778,696$ 49,268,690$ December 2016 6,112,440$ 50,000$ 10,399,391$ 20,139,559$ 36,701,391$ November 2016 -$ 8,950,242$ 10,149,294$ 11,410,145$ 30,509,681$ October 2016 -$ 11,893,456$ 9,598,367$ 4,576,239$ 26,068,062$ September 2016 -$ 1,401,847$ 9,611,806$ 9,898,592$ 20,912,246$ August 2016 -$ -$ 10,830,323$ 13,870,895$ 24,701,218$ July 2016 -$ -$ 10,288,522$ 14,611,996$ 24,900,517$ June 2016 4,836,176$ -$ 10,288,522$ 15,052,435$ 30,177,132$ May 2016 -$ -$ 6,310,697$ 22,909,111$ 29,219,808$ April 2016 -$ -$ 5,910,697$ 28,256,262$ 34,166,959$ March 2016 3,888,938$ -$ 5,910,697$ 31,321,226$ 41,120,861$ February 2016 6,184,218$ -$ 5,460,397$ 29,217,771$ 40,862,386$ Cash and Investments $15,000,000 $25,000,000 $35,000,000 $45,000,000 $55,000,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 4 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 GENERAL FUND 2013 2014 2015 2016 2017 UNAUDITED Non Spendable 451,088$ 111,181$ 159,625$ 1,418,606$ 1,418,606$ Restricted 9,433,149$ 9,260,952$ 11,496,063$ 11,966,027$ 11,966,027$ Committed -$ -$ -$ -$ -$ Assigned -$ 3,193,811$ 2,600,000$ -$ -$ Unassigned 17,959,942$ 18,732,095$ 19,417,388$ 26,311,973$ 29,924,402$ $ 27,844,179 $ 31,298,039 $ 33,673,076 $ 39,696,606 $ 43,309,035 General Fund Expenditures $ 101,852,867 $ 103,330,529 $ 108,508,715 $ 112,272,703 $ 116,858,254 17.63% 18.13% 17.89% 23.44% 25.61% Estimated 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. 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. Total General Fund Unassigned Fund Balance as a % of Expenditures That portion of fund balance that the County intends to use for specific purposes. The County Commissioners have the authority to assign fund balances. Unassigned Fund Balance - Assigned Fund Balance - U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 5 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 GENERAL FUND The Harnett County Board of Commissioners have approved a fund balance policy which strives to maintain a minimum fund balance of 15%. 1.00% 11.00% 21.00% 2013 2014 2015 2016 2017 17.63%18.13%17.89% 23.44%25.61% Fund Balance % U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 6 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 PUBLIC UTILITIES FUND FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 3,452,612$ 11,045,313$ 5,500,217$ 26,892$ 0.49%41,880$ 4,376,387 4,636,704 5,669,326 273,332 4.82%270,263 2,005,668 2,365,344 3,235,710 175,942 5.44%105,543 1,993,304 2,255,344 2,906,061 150,369 5.17%117,787 3,634,241 3,983,077 4,597,259 221,037 4.81%270,940 2,742,752 3,407,806 4,647,186 100,503 2.16%109,334 18,204,964$ 27,693,588$ 26,555,759$ 948,075$ 3.57% 915,747$ - - - - - 9,327,622 - - - - 1,070,704 4,784,003 6,256,849 182,762 2.92%182,421 10,398,325$ 4,784,003$ 6,256,849$ 182,762$ 2.92% 182,421$ 28,603,289$ 32,477,591$ 32,812,608$ 1,130,837$ 3.45% 1,098,168$ FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 3,703$ 3,703$ 3,703$ -$ -$ 32,563,219 33,494,516 32,117,905 2,895,381 9.01%3,415,855 3,704,119 4,957,710 691,000 48,841 7.07%19,041 2,105 (3,018) - - - 36,273,146$ 38,452,911$ 32,812,608$ 2,944,222$ 8.97% 3,434,896$ 320,484 - - - - 450,000 45,034 - - - - - - - - 770,484$ 45,034$ -$ -$ -$ 37,043,630$ 38,497,945$ 32,812,608$ 2,944,222$ 8.97% 3,434,896$ 8,440,341$ 6,020,354$ 1,813,385$ 2,336,728$ Subtotal - Operating Revenues Total Expenditures Source Intergovernmental Revenue Interfund Transfers Fund Balance Appropriated Total Revenues Subtotal Other Financing Sources: Department Admin/CSR/Meter Services Water Treatment Wastewater Treatment Wastewater Treatment SHWW Distribution Collections Revenues over / (under) expenditures Rents, Concess. & Feees Other Finance Sources Debt Service Subtotal Other Financing Uses: Sales & Services Other Revenues Subtotal - Operating Expenditures Interfund Transfers Depreciation U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 7 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 PUBLIC UTILITIES FUND PNC Lockbox Money Mkt NCCMT Total July 2017 23,098,741$ 5,739,955$ 5,005,756$ 26,874$ 33,871,325$ June 2017 22,125,214$ 5,549,386$ 5,005,756$ 26,474$ 32,706,830$ May 2017 25,982,342$ 5,236,513$ 5,003,631$ 624,363$ 36,846,849$ April 2017 32,934,935$ 4,914,027$ 5,001,575$ 614,100$ 43,464,638$ March 2017 31,893,934$ 9,713,915$ -$ 599,368$ 42,207,217$ January 2017 34,586,445$ 4,491,557$ -$ 588,277$ 39,666,278$ December 2016 33,153,787$ 4,255,513$ -$ 588,277$ 37,997,576$ February 2017 35,929,010$ 4,553,808$ -$ 588,943$ 41,071,761$ November 2016 31,878,365$ 4,312,453$ -$ 588,228$ 36,779,046$ October 2016 31,059,095$ 4,075,830$ -$ 585,783$ 35,720,707$ September 2016 29,921,800$ 4,030,784$ -$ 585,023$ 34,537,607$ August 2016 30,074,922$ 3,836,649$ -$ 585,023$ 34,496,594$ July 2016 28,301,352$ 3,467,807$ -$ 583,368$ 32,352,527$ June 2016 27,213,474$ 3,582,342$ -$ 583,368$ 31,379,183$ May 2016 28,848,875$ 3,432,473$ -$ 581,211$ 32,862,559$ April 2016 30,683,192$ 3,316,449$ -$ 577,919$ 34,577,560$ March 2016 31,388,435$ 3,343,019$ -$ 570,299$ 35,301,753$ February 2016 29,859,796$ 3,507,930$ -$ 555,108$ 33,922,833$ Cash and Investments $25,000,000 $30,000,000 $35,000,000 $40,000,000 $45,000,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 8 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 SOLID WASTE FUND FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 4,207,775$ 5,349,462$ 5,137,096$ 93,388$ 1.82%189,324$ 4,207,775$ 5,349,462$ 5,137,096$ 93,388$ 1.82% 189,324$ - - - - - - - - - - 445,290 - - - - 88,150 542,278 540,352 13,720 2.54%88,150 533,439$ 542,278$ 540,352$ 13,720$ 2.54% 88,150$ 4,741,214$ 5,891,740$ 5,677,448$ 107,108$ 1.89% 277,474$ FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 268,129$ 216,910$ 250,000$ -$ -$ 133,790 60,036 90,000 - - 5,313,693 5,731,760 5,335,248 55,326 1.04%69,159 139,437 884,013 700 4,200 600.00%- 1,291 2,548 1,500 - - 5,856,340$ 6,895,267$ 5,677,448$ 59,526$ 1.05% 69,159$ 917 - - - - - - - - - - - - - - 917$ -$ -$ -$ -$ 5,857,257$ 6,895,267$ 5,677,448$ 59,526$ 1.05% 69,159$ 1,116,043$ 1,003,527$ (47,582)$ (208,315)$ Fund Balance Appropriated Total Revenues Subtotal Other Financing Sources: Revenues over / (under) expenditures Interfund Transfers Subtotal - Operating Expenditures Subtotal Other Financing Uses: Interfund Transfers Other Financing Uses Debt Service Department Solid Waste Total Expenditures Rents, Concess. & Feees Other Finance Sources Subtotal - Operating Revenues Source Taxes Intergovernmental Revenue Sales & Services Other Revenues Depreciation U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 9 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 SOLID WASTE FUND PNC BB&T First Bank NCCMT Total July 2017 -$ 804,053$ 846,637$ 944$ 1,651,635$ June 2017 189,827$ 873,490$ 822,923$ 944$ 1,887,184$ May 2017 146,657$ 849,369$ 798,541$ 295,485$ 2,090,052$ April 2017 252,605$ 813,116$ 768,637$ 235,646$ 2,070,004$ March 2017 697,465$ 796,560$ 738,482$ 316,381$ 2,548,889$ February 2017 1,010,246$ 774,615$ 715,054$ 316,381$ 2,816,296$ January 2017 933,046$ 733,821$ 679,357$ 240,324$ 2,586,547$ December 2016 1,221,468$ 712,874$ 660,335$ 159,310$ 2,753,988$ November 2016 143,512$ 679,050$ 628,517$ 78,246$ 1,529,324$ October 2016 -$ 623,360$ 608,194$ 78,246$ 1,309,800$ September 2016 723,455$ 703,192$ 649,795$ 159,310$ 2,235,752$ August 2016 596,631$ 637,923$ 589,976$ 78,243$ 1,902,774$ July 2016 706,906$ 613,495$ 567,589$ 4,902$ 1,892,893$ June 2016 953,476$ 595,845$ 549,127$ 4,902$ 2,103,350$ May 2016 1,030,073$ 577,211$ 534,532$ 254,500$ 2,396,316$ April 2016 1,106,636$ 555,533$ 517,182$ 185,532$ 2,364,882$ March 2016 1,322,008$ 533,722$ 501,869$ 185,532$ 2,543,131$ February 2016 1,453,177$ 504,847$ 477,173$ 60,920$ 2,496,117$ Cash and Investments $1,000,000 $2,000,000 $3,000,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 10 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 WORKER'S COMPENSATION FUND FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 21,000$ 21,000$ 32,000$ 9,125$ 28.52%-$ 1,243,316 3,179,514 1,093,000 - 160 - - 455,537 - - 1,264,316$ 3,200,514$ 1,580,537$ 9,125$ 0.58% 160$ FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 1,711,483$ 1,157,287$ 975,000$ 88,745$ 9.10%80,533$ 441,714 2,563,155 150,000 - -$ - - 455,537 - - 2,153,197$ 3,720,442$ 1,580,537$ 88,745$ 5.61% 80,533$ 888,881$ 519,928$ 79,620$ 80,373$ Category Fixed Cost Claims Funded Total Expenditures Source Departmental Charge Other revenues Fund Balance Appropriated Total Revenues Revenues over / (under) expenditures Transfer to Capital Reserve U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 11 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 WORKER'S COMPENSATION FUND PNC NCCMT Total July 2017 2,759,812$ 1,211,772$ 3,971,584$ June 2017 2,904,633$ 1,211,772$ 4,116,405$ May 2017 2,809,436$ 1,211,772$ 4,021,208$ April 2017 265,521$ 1,211,772$ 1,477,293$ March 2017 2,833,889$ 1,211,772$ 4,045,661$ February 2017 2,717,622$ 1,211,772$ 3,929,394$ January 2017 2,768,040$ 1,211,772$ 3,979,812$ December 2016 2,687,499$ 1,211,772$ 3,899,271$ November 2016 2,582,294$ 1,211,772$ 3,794,066$ October 2016 2,487,719$ 1,211,772$ 3,699,491$ September 2016 2,533,314$ 1,211,772$ 3,745,086$ August 2016 1,669,764$ 1,211,772$ 2,881,536$ July 2016 1,705,014$ 1,211,772$ 2,916,786$ June 2016 1,624,481$ 1,211,772$ 2,836,253$ May 2016 1,692,068$ 1,211,772$ 2,903,840$ April 2016 1,643,553$ 1,211,772$ 2,855,325$ March 2016 1,711,933$ 1,211,772$ 2,923,705$ February 2016 1,532,422$ 1,211,772$ 2,744,194$ Cash and Investments $2,000,000 $3,000,000 $4,000,000 $5,000,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 12 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 WORKER'S COMPENSATION FUND 2,379,247$ 145 2,395,920$ Liability 16,818 # of Claims this fiscal year 6changes in estimates Actual claim payments Liability as of end of month Liability as of July 1 Current year claims and U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 13 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 EMPLOYEE CLINIC FUND FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 140,835$ 150,473$ 175,301$ 8,946$ 5.10%5,382$ 140,835$ 150,473$ 175,301$ 8,946$ 5.10% 5,382$ FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 242,612$ 153,291$ 175,301$ 12,540$ 7.15%12,150$ - - - - - - - - - - 242,612$ 153,291$ 175,301$ 12,540$ 7.15% 12,150$ 101,777$ 2,818$ 3,594$ 6,768$ Fund Balance Appropriated Department Employee Clinic Total Expenditures Source Departmental Charge Other revenues Total Revenues Revenues over / (under) expenditures U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 14 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 EMPLOYEE CLINIC FUND PNC NCCMT Total July 2017 627,671$ 29,241$ 656,913$ June 2017 638,529$ 29,241$ 667,771$ May 2017 643,317$ 29,241$ 672,559$ April 2017 645,207$ 29,241$ 674,448$ March 2017 642,930$ 29,241$ 672,171$ February 2017 644,551$ 29,241$ 673,792$ January 2017 641,202$ 29,241$ 670,443$ December 2016 641,529$ 29,241$ 670,770$ November 2016 644,850$ 29,241$ 674,091$ October 2016 646,455$ 29,241$ 675,697$ September 2016 647,665$ 29,241$ 676,906$ August 2016 645,243$ 29,241$ 674,484$ July 2016 643,903$ 29,241$ 673,145$ June 2016 640,890$ 29,241$ 670,132$ May 2016 629,731$ 29,241$ 658,972$ April 2016 634,966$ 29,241$ 664,207$ March 2016 626,534$ 29,241$ 655,776$ February 2016 619,752$ 29,241$ 648,994$ Cash and Investments $650,000 $655,000 $660,000 $665,000 $670,000 $675,000 $680,000 $685,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 15 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 EMPLOYEE CLINIC FUND July 2017 132 June 2017 120 May 2017 185 April 2017 109 March 2017 201 February 2017 198 January 2016 177 December 2016 165 November 2016 141 October 2016 116 September 2016 150 August 2016 145 July 2016 144 Employee Clinic Utilization 0 0 Health Prevention # of Visits # Flu shots # Pneumonia shots 0 50 100 150 200 250 Patient Flow U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 16 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 MEDICAL INSURANCE FUND FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 6,818,253$ 6,839,112$ 7,150,000$ 439,441$ 6.15%797,979$ 634,709 704,945 882,000 2,433 0.28%118,774 8,355 2,919 10,000 - 762 7,461,317$ 7,546,976$ 8,042,000$ 441,874$ 5.49% 917,515$ FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 7,892,453$ 7,719,991$ 8,000,000$ 733,143$ 9.16%618,468$ 26,178 19,851 42,000 - 656 7,918,631$ 7,739,842$ 8,042,000$ 733,143$ 9.12% 619,124$ 457,314$ 192,866$ 291,269$ (298,391)$ Category Paid Claims Wellness Total Expenditures Source Medical Premium Equivilents Other revenues Total Revenues Fixed Cost Revenues over / (under) expenditures U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 17 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 MEDICAL INSURANCE FUND PNC NCCMT Total July 2017 2,199,920$ 543,297$ 2,743,218$ June 2017 1,911,518$ 543,297$ 2,454,816$ May 2017 2,028,010$ 543,297$ 2,571,307$ April 2017 2,033,963$ 543,297$ 2,577,260$ March 2017 1,870,174$ 543,297$ 2,413,471$ February 2017 2,024,627$ 543,297$ 2,567,925$ January 2017 2,084,544$ 543,297$ 2,627,841$ December 2016 2,014,553$ 543,297$ 2,557,850$ November 2016 1,952,986$ 543,297$ 2,496,283$ October 2016 1,869,553$ 543,297$ 2,412,851$ September 2016 1,877,798$ 543,297$ 2,421,096$ August 2016 1,125,368$ 543,297$ 1,668,665$ July 2016 967,054$ 543,297$ 1,510,351$ June 2016 1,035,476$ 543,297$ 1,578,773$ May 2016 866,947$ 543,297$ 1,410,244$ April 2016 964,355$ 543,297$ 1,507,653$ March 2016 1,196,881$ 543,297$ 1,740,178$ February 2016 1,354,214$ 543,297$ 1,897,511$ 3.97 2.63 Cash and Investments 2.87 Number of Months Average Monthly Cost on Hand 2.28 2.39 2.13 2.28 3.86 3.77 3.65 3.66 2.52 3.88 3.89 3.65 3.88 3.71 4.14 $1,500,000 $1,700,000 $1,900,000 $2,100,000 $2,300,000 $2,500,000 $2,700,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 18 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 MEDICAL INSURANCE FUND Employees & Pre-65 Retirees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent July 2017 863 1,319 565,579.25$ 63,092.85$ 85.52%735,091.65$ June 2017 858 1,309 707,456.46$ 63,092.85$ 104.82%735,091.65$ May 2017 859 1,308 585,092.44$ 59,071.95$ 99.37%648,269.01$ April 2017 850 1,288 426,323.43$ 60,687.61$ 74.69%652,008.78$ March 2017 847 1,280 700,824.81$ 62,056.67$ 120.25%634,433.13$ February 2017 838 1,270 697,396.28$ 38,867.77$ 116.07%634,310.54$ January 2017 843 1,275 451,584.71$ 46,679.99$ 79.47%626,993.27$ December 2016 843 1,271 562,043.76$ 50,371.79$ 96.89%632,074.10$ November 2016 841 1,265 450,496.19$ 58,245.17$ 80.80%629,611.56$ October 2016 835 1,253 475,315.79$ 93,186.53$ 90.35%629,233.60$ September 2016 830 1,242 949,451.70$ 58,166.03$ 161.13%625,355.69$ August 2016 827 1,238 472,478.84$ 58,462.25$ 85.98%617,534.95$ July 2016 830 1,237 567,120.08$ 117,732.75$ 110.59%619,266.87$ June 2016 826 1,201 749,785.30$ (48,146.18)$ 112.65%622,838.33$ May 2016 821 1,195 644,458.97$ 18,765.56$ 121.42%546,217.69$ April 2016 819 1,190 846,544.07$ 59,316.96$ 166.24%544,921.50$ March 2016 824 1,192 613,689.61$ 55,057.79$ 122.98%543,783.54$ February 2016 829 1,199 476,696.71$ 57,028.00$ 97.08%549,770.71$ 838 1,252 10,942,338.40$ 971,736.34$ 106.12% 11,226,806.57$ Year to Date (membership = avg) Medical Paid Claims Summary 50% 75% 100% 125% 150% 175% Medical Plan Loss Ratio U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 19 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 DENTAL INSURANCE FUND FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 295,849$ 374,180$ 325,000$ 27,310$ 8.40%43,444$ 36,698 37,022 50,000 3,894 7.79%7,101 332,547$ 411,202$ 375,000$ 31,204$ 8.32% 50,545$ FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 369,211$ 473,118$ 375,000$ 40,511$ 10.80%37,753$ - - - - - 369,211$ 473,118$ 375,000$ 40,511$ 10.80% 37,753$ 36,664$ 61,916$ 9,307$ (12,792)$ Category Paid Claims Fixed Cost Total Expenditures Source Dental Premium Equivilents Other revenues Total Revenues Revenues over / (under) expenditures U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 20 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 DENTAL INSURANCE FUND PNC NCCMT Total July 2017 325,009$ -$ 325,009$ June 2017 315,701$ -$ 315,701$ May 2017 311,609$ -$ 311,609$ April 2017 313,273$ -$ 313,273$ March 2017 294,393$ -$ 294,393$ February 2017 296,096$ -$ 296,096$ January 2017 290,366$ -$ 290,366$ December 2016 290,231$ -$ 290,231$ November 2016 280,718$ -$ 280,718$ October 2016 278,083$ -$ 278,083$ September 2016 283,750$ -$ 283,750$ August 2016 269,750$ -$ 269,750$ July 2016 278,279$ -$ 278,279$ June 2016 270,084$ -$ 270,084$ May 2016 262,899$ -$ 262,899$ April 2016 259,621$ -$ 259,621$ March 2016 255,744$ -$ 255,744$ February 2016 262,475$ -$ 262,475$ Cash and Investments Number of Months Average Monthly Cost on Hand 9.69 9.29 9.34 9.41 8.78 8.83 8.66 8.65 8.37 7.84 7.74 7.63 7.83 8.29 8.46 8.04 8.30 8.05 $250,000 $275,000 $300,000 $325,000 $350,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 21 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 July, 2017 DENTAL INSURANCE FUND Total Employees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent July 2017 890 1,443 37,352.60$ 3,893.67$ 101.81%40,511.14$ June 2017 878 1,401 31,838.61$ 3,815.01$ 86.37%41,280.65$ May 2017 877 1,401 29,071.76$ 3,828.12$ 84.48%38,943.34$ April 2017 867 1,386 30,843.30$ 3,797.53$ 84.96%40,772.75$ March 2017 866 1,382 37,039.68$ 3,810.64$ 117.25%34,840.92$ February 2017 853 1,366 29,052.10$ 3,731.98$ 89.50%36,632.24$ January 2017 852 1,363 24,691.39$ 3,701.39$ 74.34%38,194.96$ December 2016 849 1,352 30,584.03$ 3,683.91$ 90.36%37,925.31$ November 2016 847 1,350 27,494.20$ 3,749.46$ 82.49%37,877.15$ October 2016 838 1,341 20,172.90$ 3,412.97$ 62.44%37,772.52$ September 2016 812 1,312 38,929.95$ 3,600.88$ 113.34%37,526.11$ August 2016 813 1,323 35,594.70$ 3,570.29$ 104.91%37,330.66$ July 2016 810 1,316 31,416.37$ 4,006.42$ 93.83%37,752.67$ June 2016 671 1,114 28,488.90$ 6,202.76$ 90.84%38,188.97$ May 2016 667 1,110 22,062.20$ 3,084.92$ 84.50%29,760.98$ April 2016 659 1,100 31,526.79$ 3,033.66$ 115.55%29,909.42$ March 2016 660 1,101 29,696.70$ 3,122.20$ 110.76%29,629.84$ February 2016 660 1,101 20,728.10$ 3,075.60$ 76.42%31,147.59$ 798 1,292 536,584.28$ 67,121.41$ 92.03% 655,997.22$ Dental Paid Claims Summary Year to Date (membership = avg) 50% 75% 100% 125% Dental Plan Loss Ratio U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 22 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 May, 2017 BOARD OF EDUCATION FYE 2016 FYE 2017 UNAUDITED FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 115,268,881$ 106,092,900$ -$ -$ 102,207,084$ 115,268,881$ 106,100,707$ -$ -$ 102,223,378$ -$ 7,807$ -$ -$ 16,295$ 22,838,609 20,553,383 - - 19,279,878$ 21,557,719 21,058,298 - - 21,520,806$ (1,280,890)$ 504,915$ -$ -$ 2,240,928$ 11,365,474 10,646,921 - - 9,658,731$ 11,365,474 10,649,134 - - 9,670,260$ -$ 2,213$ -$ -$ 11,528$ 3,165,403 3,395,126 - - 2,990,946$ 2,844,295 3,534,258 - - 2,681,150$ (321,108)$ 139,132$ -$ -$ (309,796)$ 10,013,377 9,236,883 - - 9,324,806$ 10,608,154 10,202,351 - - 9,246,428$ 594,777$ 965,468$ -$ -$ (78,378)$ 304,258 250,473 - - 292,697$ 299,648 292,574 - - 284,577$ (4,609)$ 42,101$ -$ -$ (8,120)$ 4,720,189 5,456,564 - - 3,813,528$ 5,253,011 6,017,872 - - 4,694,184$ 532,822$ 561,307$ -$ -$ 880,656$ 167,676,190 155,632,250 - - 147,567,670 167,197,181 157,855,193 - - 150,320,783 (479,009)$ 2,222,943$ -$ -$ 2,753,113$ * Latest available numbers from the Board of Education's web site. State Fund Fund Group Expenditures Revenues Dunn District Fund Expenditures Revenues Local Current Expense Fund Expenditures Revenues Federal Grant Fund Expenditures Revenues Capital Outlay Fund Expenditures Revenues Expenditures Revenues Local Restricted Fund Expenditures Revenues Total All Funds Child Nutrition Fund Expenditures Revenues U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 23 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 May, 2017 BOARD OF EDUCATION 2013 2014 2015 2016 2017 UNAUDITED Non Spendable 1,417,080$ 2,130,098$ 1,849,351$ 1,796,064$ -$ Restricted 2,813$ 67,971$ 21,420$ 25,507$ -$ Committed -$ -$ -$ -$ -$ Assigned 4,004,023$ 3,508,927$ 5,466,811$ 3,845,000$ -$ Unassigned 5,426,606$ 3,000,000$ 2,889,118$ 3,274,629$ -$ 10,850,522$ 8,706,996$ 10,226,700$ 8,941,200$ -$ General Fund Expenditures 20,262,634$ 22,848,788$ 20,369,083$ 23,089,579$ -$ 26.78% 13.13% 14.18% 14.18% 0.00% 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. 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. Estimated Fund Balance 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. Unassigned Fund Balance as a % of Expenditures Total General Fund U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 24 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 May, 2017 BOARD OF EDUCATION ADM MLD ADM Change MLD Change Month 1 20,483 20,615 Month 1 Revd 20,469 20,573 (14)(42) Month 2 20,563 20,566 94 (7) Month 3 20,538 20,554 (25)(12) Month 4 20,443 20,480 (95)(74) Month 5 20,340 20,310 (103)(170) Month 6 20,280 20,325 (60)15 Month 7 20,271 20,282 (9)(43) Month 8 20,236 20,259 (35)(23) Month 9 20,201 20,182 (35)(77) Final 0 20,182 0 Public School Membership Fiscal Year 2016-2017 Initial Allotment20,850 1.00% 11.00% 21.00% 2012 2013 2014 2015 2016 60.26% 26.78% 13.13%14.18%14.18% Fund Balance % U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 25 HARNETT COUNTY FINANCIAL SUMMARY REPORT 8/21/2017 May, 2017 BOARD OF EDUCATION 19,500 20,000 20,500 21,000 Harnett County School Membership ADM MLD U:\My Documents\Monthly Reports\2017 - 2018\July 2017 - Financial Statements 26