Press Alt + R to read the document text or Alt + P to download or print.

No preview available

The URL can be used to link to this page

Home My WebLink AboutMay 2018 - Financial Statements HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 GENERAL FUND FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 208,357$ 272,690$ 325,151$ 354,061$ 108.89%344,197$ 294,293 404,153 502,462 502,882 100.08%520,084 53,919 95,207 171,203 282,694 165.12%223,198 205,162 257,066 312,115 333,630 106.89%305,811 381,191 415,400 528,246 343,650 65.05%374,959 811,001 848,360 1,021,531 1,092,319 106.93%992,152 - 415,000 520,000 400,275 76.98%291,764 81,438 92,784 102,625 93,009 90.63%86,790 1,709,486 1,594,220 1,743,220 1,404,791 80.59%1,424,135 158,173 156,539 201,883 184,345 91.31%132,664 543,249 540,424 625,237 527,920 84.44%482,474 1,523,150 1,707,476 1,575,194 1,269,899 80.62%1,442,209 194,529 247,359 283,858 210,025 73.99%182,383 3,667,427 2,700,087 3,004,508 2,362,987 78.65%2,007,501 759,735 769,621 837,668 703,817 84.02%682,192 1,787,734 1,962,777 2,223,238 2,051,018 92.25%1,971,322 581,109 592,936 656,704 601,111 91.53%593,376 9,677,549 9,596,512 10,699,916 8,961,654 83.75%8,337,589 442,623 461,128 521,648 422,615 81.02%400,977 26,924 19,237 22,240 22,202 99.83%7,461 66,653 79,381 84,647 63,687 75.24%62,212 - - 123,300 62,802 50.93%- 1,624,091 1,648,761 1,925,480 1,584,574 82.30%1,439,881 School Resource Officers 682,489 738,896 778,555 657,135 84.40%642,467 4,551,465 4,669,491 5,444,017 4,403,981 80.90%4,013,115 730,739 829,545 1,069,761 742,250 69.38%712,740 - 58,000 54,017 44,268 81.95%58,000 4,414,723 6,296,462 6,997,743 5,821,236 83.19%5,433,528 1,151,492 14 - - 14 3,361,704 3,361,704 3,462,557 3,174,011 91.67%3,081,558 438,575 437,729 554,475 441,818 79.68%380,964 89,900 65,900 90,000 66,350 73.72%55,850 6,886 5,016 3,837 3,537 92.18%4,900 71,908 75,361 88,403 57,881 65.47%68,399 - - - - - - - - - - 198,422 189,136 284,277 174,021 61.22%149,666 178,736 177,452 198,518 132,825 66.91%159,669 4,000 4,000 4,000 4,000 100.00%4,000 101,648 100,108 115,111 91,216 79.24%83,332 509,983 575,679 775,000 679,014 87.61%472,027 Human Resources Facilities Maintenance Register of Deeds Information Technology GIS Sheriff Campbell Deputies Emergency Services Grant JCPC Admin Public Safety Appropriations Emergency Telephone System Radio System Harnett Regional Jetport Medical Examiner Environmental Protection Forestry Program Economic/Physical Dev. App. 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 Governor's Highway Safety Communications Jail Emergency Services Legal Services Animal Services Soil & Water EMS Transport Rescue Districts U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 1 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 GENERAL FUND FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 436,558 1,017,433 1,266,367 880,653 69.54%603,842 1,309,860 1,363,085 1,544,371 1,265,184 81.92%1,226,894 192 19,116 31,997 (206) 19,091 32,171 23,216 24,126 20,184 83.66%18,959 314,013 364,853 441,981 298,604 67.56%327,227 24,494 25,877 26,333 13,404 50.90%21,426 150 - - - - 59,354 - - - - 76,776 77,605 71,408 66,325 92.88%67,734 72,035 45,234 54,000 43,290 80.17%37,931 - - - - - 4,034 657 - - 657 - - - - - 30,035 20,764 52,483 28,980 55.22%18,645 315,244 316,827 337,294 284,994 84.49%264,789 61,164 67,657 75,144 60,767 80.87%60,250 77,511 83,864 90,228 72,959 80.86%70,498 329,421 324,799 374,045 313,857 83.91%285,704 432,337 405,411 441,270 357,597 81.04%328,519 6,082,878 5,745,786 6,394,640 4,845,991 75.78%4,935,966 605,679 605,679 605,679 605,679 100.00%605,679 10,324,942 12,216,121 12,713,027 10,359,744 81.49%10,148,699 9,351,002 9,118,139 9,214,313 5,382,080 58.41%8,224,165 180,399 213,802 270,472 217,556 80.44%181,987 103,322 101,763 120,949 75,329 62.28%86,376 136,805 36,059 45,000 31,103 69.12%28,223 910,122 971,658 1,162,803 900,977 77.48%815,769 153,000 185,000 184,014 181,014 98.37%185,000 435,005 800,422 1,024,702 818,254 79.85%692,295 - - - - - - 72,542 524,195 483,691 92.27%69,732 21,267,993 21,420,138 21,068,027 19,312,358 91.67%19,635,127 280,707 122,625 2,164,583 1,141,018 52.71%122,625 993,967 1,055,200 1,776,084 1,776,084 100.00%1,055,200 - 1,019,467 1,080,450 990,413 91.67%934,511 - 26,197 30,000 28,595 95.32%26,197 - - - - 731,974 - - - - - 70,000 - - - - $ 95,761,633 $ 100,328,607 $ 111,142,330 $ 91,185,988 82.04% $ 89,457,251 Industrial Development Board of Education - add teach Mental Health Board of Education - reserve Board of Education - teachers Central Carolina - health sciences Department Central Carolina - DOT Social Services Public Assistance Veteran's Services Family Caregiver Support RSVP 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 4-H Teen Court & At Risk Adolescent Parenting Parents As Teachers 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 U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 2 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 GENERAL FUND FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 2,145,446 3,628,409 2978167 1,903,167 63.90%1,454,409 4,745,868 3,852,362 4,694,305 4,542,043 96.76%3,797,415 11,551,602 13,660,527 14,596,843 14,511,973 99.42%12,902,280 213,601 (3,131) 10,000 3,775 37.75%(3,131) 36,177,890 - - - - - - 215,337 - - 54,834,407$ 21,138,167$ 22,494,652$ 20,960,958$ 93.18% 18,150,973$ 150,596,040$ 121,466,774$ 133,636,982$ 112,146,946$ 83.92% 107,608,224$ FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 55,082,717$ 56,335,636$ 55,393,772$ 55,996,166$ 101.09%56,344,748$ 6,190,412 6,637,839 6,146,212 5,720,467 93.07%5,429,391 19,279,813 20,518,531 20,655,250 14,781,174 71.56%13,913,381 1,220,493 1,259,723 1,325,000 1,144,316 86.36%1,096,607 2,965,577 2,961,556 3,893,090 2,542,254 65.30%2,640,064 20,274,012 18,900,426 22,285,443 13,475,619 60.47%15,306,251 9,204,896 9,857,148 8,286,349 7,211,899 87.03%9,089,872 3,343,042 3,204,306 6,285,062 2,782,678 44.27%2,952,939 73,655 67,075 74,808 69,263 92.59%61,831 117,634,617$ 119,742,240$ 124,344,986$ 103,723,836$ 83.42% 106,835,084$ 97,339 247,493 225,000 460,237 204.55%178,769 37,018,000 24,951 - - - 7,501 1,657,613 6,264,889 9,012 0.14%- - - 2,802,107 - - 37,122,840$ 1,930,057$ 9,291,996$ 469,249$ 5.05% 178,769$ 154,757,457$ 121,672,297$ 133,636,982$ 104,193,085$ 77.97% 107,013,853$ 4,161,417$ 205,523$ (7,953,861)$ (594,370)$ Cost of Issuance Interest Principal Other Financing Uses Investment Earnings Sales Tax Interfund Transfers Debt Service Contingency Total Expenditures Source 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 Other Financing Sources Interfund Transfers Fund Balance Appropriated Total Revenues Permits & Fees Intergovernmental Revenue Sales & Services Other Revenues Department Real and Personal U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 3 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 GENERAL FUND PNC Regions MBS NCCMT Total May 2018 8,898,291$ 1,004,448$ 14,766,685$ 5,062,010$ 29,731,434$ April 2018 12,886,383$ 1,003,681$ 14,773,770$ 5,054,169$ 33,718,002$ March 2018 19,890,955$ 1,002,939$ 14,773,770$ 5,047,045$ 40,714,709$ February 2018 22,170,874$ 1,002,247$ 14,789,794$ 5,041,201$ 43,004,116$ January 2018 28,841,128$ 1,001,432$ 12,844,050$ 5,030,757$ 47,717,367$ December 2017 13,800,471$ 1,000,000$ 14,823,361$ 5,025,186$ 34,649,018$ November 2017 17,599,360$ 1,000,000$ 11,855,892$ 5,020,334$ 35,475,586$ October 2017 12,391,103$ -$ 13,834,305$ 5,015,388$ 31,240,796$ September 2017 9,026,314$ -$ 13,051,245$ 5,010,651$ 27,088,210$ August 2017 8,262,632$ -$ 12,825,076$ 5,005,796$ 26,093,504$ July 2017 10,008,526$ -$ 12,833,501$ 5,001,060$ 27,843,087$ June 2017 15,955,001$ -$ 12,833,501$ 5,001,060$ 33,789,562$ May 2017 18,829,971$ -$ 12,883,875$ 5,000,000$ 36,713,847$ April 2017 24,350,798$ -$ 12,883,875$ 5,000,000$ 42,234,673$ March 2017 37,665,559$ -$ 10,900,020$ -$ 48,565,578$ February 2017 34,566,540$ -$ 10,900,020$ -$ 45,466,559$ January 2017 38,368,671$ -$ 10,900,020$ -$ 49,268,690$ December 2016 26,302,000$ -$ 10,399,391$ -$ 36,701,391$ 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\May 2018 - Financial Statements 4 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 GENERAL FUND 2013 2014 2015 2016 2017 Non Spendable 451,088$ 111,181$ 159,625$ 1,418,606$ 232,245$ Restricted 9,433,149$ 9,260,952$ 11,496,063$ 11,966,027$ 9,068,575$ Committed -$ -$ -$ -$ -$ Assigned -$ 3,193,811$ 2,600,000$ -$ -$ Unassigned 17,959,942$ 18,732,095$ 19,417,388$ 26,311,973$ 32,547,008$ $ 27,844,179 $ 31,298,039 $ 33,673,076 $ 39,696,606 $ 41,847,828 General Fund Expenditures $ 101,852,867 $ 103,330,529 $ 108,508,715 $ 112,272,703 $ 119,688,680 17.63% 18.13% 17.89% 23.44% 27.19% 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 - 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. 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 U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 5 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 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% 27.19% Fund Balance % U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 6 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 PUBLIC UTILITIES FUND FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 3,452,612$ 4,068,457$ 6,800,473$ 4,512,568$ 66.36%6,728,909$ 4,376,387 4,701,727 5,789,326 4,062,865 70.18%3,768,817 2,005,668 2,442,732 3,220,710 2,345,952 72.84%1,832,507 1,993,304 2,312,626 2,863,061 1,885,193 65.85%1,760,521 3,634,241 4,079,847 4,669,659 3,193,686 68.39%3,180,839 2,742,752 3,509,807 4,648,786 3,059,588 65.81%2,821,148 18,204,964$ 21,115,196$ 27,992,015$ 19,059,852$ 68.09% 20,092,741$ - 11,684,213 1,996,590 1,996,590 100.00%- 9,327,622 9,488,101 - - - 1,070,704 2,250,846 1,658,566 1,299,561 78.35%1,738,661 3,113,936 3,162,027 2,946,027 93.17%2,835,342 10,398,325$ 26,537,096$ 6,817,183$ 6,242,178$ 91.57% 4,574,003$ 28,603,289$ 47,652,292$ 34,809,198$ 25,302,030$ 72.69% 24,666,744$ FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 3,703$ 3,703$ 3,703$ 3,703$ 100.00%3,703$ 32,563,219 35,382,681 32,117,905 32,202,002 100.26%29,900,882 3,704,119 5,091,063 691,000 783,043 113.32%625,657 2,105 (3,018) - 22,124 5,682 36,273,146$ 40,474,429$ 32,812,608$ 33,010,872$ 100.60% 30,535,924$ 320,484 - - 52,357 - 450,000 45,034 - - - - - 1,996,590 - - 770,484$ 45,034$ 1,996,590$ 52,357$ 2.62% -$ 37,043,630$ 40,519,463$ 34,809,198$ 33,063,229$ 94.98% 30,535,924$ 8,440,341$ (7,132,829)$ 7,761,199$ 5,869,180$ Sales & Services Other Revenues Subtotal - Operating Expenditures Interfund Transfers Depreciation Interest Principal 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: Subtotal - Operating Revenues Total Expenditures Source Intergovernmental Revenue Interfund Transfers Fund Balance Appropriated Total Revenues Subtotal Other Financing Sources: U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 7 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 PUBLIC UTILITIES FUND PNC Lockbox Money Mkt NCCMT Total May 2018 24,549,937$ 8,702,997$ 5,029,608$ 57,652$ 38,340,195$ April 2018 22,572,546$ 8,216,795$ 5,024,507$ 38,039$ 35,851,887$ March 2018 22,572,546$ 8,216,795$ 5,024,507$ 38,039$ 35,851,887$ February 2018 26,782,449$ 8,062,325$ 5,022,580$ 31,099$ 39,898,454$ January 2018 30,506,523$ 7,782,284$ 5,018,391$ 30,919$ 43,338,118$ December 2017 28,953,329$ 7,750,772$ 5,016,260$ 30,526$ 41,750,887$ November 2017 27,807,215$ 7,213,780$ 5,014,199$ 30,382$ 40,065,576$ October 2017 26,818,623$ 6,886,050$ 5,012,069$ 29,701$ 38,746,444$ September 2017 25,541,516$ 6,526,813$ 5,010,010$ 27,553$ 37,105,892$ August 2017 24,609,773$ 6,454,907$ 5,007,882$ 27,402$ 36,099,964$ 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$ February 2017 35,929,010$ 4,553,808$ -$ 588,943$ 41,071,761$ 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$ 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\May 2018 - Financial Statements 8 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 SOLID WASTE FUND FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 4,207,775$ 5,468,996$ 5,313,961$ 4,172,186$ 78.51%3,921,406$ 4,207,775$ 5,468,996$ 5,313,961$ 4,172,186$ 78.51% 3,921,406$ - - - - - - - - - - 445,290 584,770 - - - 88,150 87,349 66,027 66,024 100.00%78,205 466,362 474,325 474,324 100.00%907,148 - - - - 533,439$ 1,138,481$ 540,352$ 540,348$ 100.00% 985,353$ 4,741,214$ 6,607,477$ 5,854,313$ 4,712,534$ 80.50% 4,906,759$ FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 268,129$ 282,599$ 250,000$ 193,346$ 77.34%216,910$ 133,790 60,036 90,000 10,287 11.43%- 5,313,693 5,731,760 5,335,248 5,408,936 101.38%5,152,700 139,437 2,472,394 3,700 45,036 1217.19%63,025 1,291 2,548 1,500 2,693 179.53%1,657 5,856,340$ 8,549,337$ 5,680,448$ 5,660,298$ 99.65% 5,434,292$ 917 - 185 - - - - - - - - - 173,680 - - 917$ -$ 173,865$ -$ -$ 5,857,257$ 8,549,337$ 5,854,313$ 5,660,298$ 96.69% 5,434,292$ 1,116,043$ 1,941,860$ 947,764$ 527,533$ Rents, Concess. & Feees Other Finance Sources Subtotal - Operating Revenues Source Taxes Intergovernmental Revenue Sales & Services Other Revenues Depreciation Interest Principal Cost of Issuance 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 Fund Balance Appropriated Total Revenues U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 9 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 SOLID WASTE FUND PNC BB&T First Bank NCCMT Total May 2018 184,366$ 1,143,210$ 1,067,012$ 261,251$ 2,655,839$ April 2018 634,963$ 1,119,269$ 1,037,313$ 197,528$ 2,989,074$ March 2018 1,153,950$ 1,088,353$ 1,006,545$ 197,298$ 3,446,145$ February 2018 1,256,443$ 1,073,776$ 993,141$ 197,084$ 3,520,444$ January 2018 1,463,498$ 1,046,347$ 971,956$ 135,322$ 3,617,122$ December 2017 1,607,649$ 1,008,334$ 937,891$ 135,202$ 3,689,077$ November 2017 1,558,757$ 999,310$ 928,889$ 135,104$ 3,622,059$ October 2017 -$ 973,412$ 911,171$ 66,727$ 1,951,310$ September 2017 -$ 936,540$ 886,499$ 66,681$ 1,889,720$ August 2017 -$ 624,648$ 866,139$ 66,634$ 1,557,421$ 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$ Cash and Investments $1,000,000 $2,000,000 $3,000,000 $4,000,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 10 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 CAPITAL RESERVE FUNDS Sheriff EM SRVC Gen Govt BoE Spcl Proj P & R Radio Sys Jetport May 2018 576,132$ 261,140$ 1,598,405$ 1,023,565$ 130,017$ 275,291$ -$ -$ April 2018 710,226$ 261,140$ 2,010,139$ 808,780$ 250,897$ -$ -$ -$ March 2018 702,353$ 261,140$ 2,057,308$ 758,524$ 260,131$ -$ -$ -$ February 2018 704,689$ 261,140$ 2,103,954$ 823,944$ 419,013$ -$ -$ -$ January 2018 786,663$ 265,703$ 698,353$ 614,039$ 171,532$ -$ -$ -$ December 2017 394,855$ 1,550$ 824,864$ 309,290$ 181,945$ -$ -$ -$ November 2017 516,477$ 257,339$ 844,648$ 610,428$ 197,034$ -$ -$ -$ October 2017 516,477$ 343,323$ 1,068,957$ 702,361$ 197,034$ -$ -$ -$ September 2017 516,477$ 83,889$ 803,226$ 747,289$ 233,175$ -$ -$ -$ August 2017 516,477$ 103,064$ 770,920$ 651,969$ 233,175$ -$ -$ -$ July 2017 516,477$ 353,453$ 617,434$ 750,000$ 233,175$ -$ -$ -$ June 2017 517,361$ 383,593$ 529,414$ -$ 233,175$ -$ -$ -$ May 2017 506,380$ 463,866$ 545,040$ -$ 233,175$ -$ -$ -$ April 2017 238,141$ 113,866$ 145,199$ -$ 200,000$ -$ -$ -$ March 2017 239,825$ 152,782$ 189,497$ -$ 200,000$ -$ -$ -$ February 2017 217,968$ 154,026$ 197,402$ -$ 200,000$ -$ -$ -$ January 2017 217,453$ 392,036$ 220,305$ -$ 200,000$ -$ -$ -$ December 2016 453,869$ 379,797$ 292,036$ -$ 200,000$ -$ -$ -$ Cash and Investments HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 CAPITAL RESERVE FUNDS $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 MAY MARCH JANUARY NOVEMBER SEPTEMBER JULY MAY Cash Flow HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 WORKER'S COMPENSATION FUND FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 21,000$ 198,426$ 32,000$ 181,278$ 566.49%21,000$ 1,243,316 2,743,792 1,093,000 720,000 65.87%3,010,116 - - 455,537 455,537 100.00%- 1,264,316$ 2,942,218$ 1,580,537$ 1,356,815$ 85.85% 3,031,116$ FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 1,711,483$ 1,599,984$ 975,000$ 628,518$ 64.46%910,921$ 441,714 2,563,155 150,000 173,330 115.55%2,541,109 - - - 6,243 - - - 455,537 - - 2,153,197$ 4,163,139$ 1,580,537$ 808,091$ 51.13% 3,452,030$ 888,881$ 1,220,921$ (548,724)$ 420,914$ 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 Interest U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 13 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 WORKER'S COMPENSATION FUND PNC NCCMT Total May 2018 2,587,744$ 1,587,822$ 4,175,567$ April 2018 2,647,139$ 1,585,153$ 4,232,292$ March 2018 2,571,216$ 1,583,295$ 4,154,511$ February 2018 2,610,529$ 1,581,579$ 4,192,108$ January 2018 2,310,482$ 1,211,772$ 3,522,254$ December 2017 2,339,792$ 1,211,772$ 3,551,564$ November 2017 2,287,808$ 1,211,772$ 3,499,580$ October 2017 2,387,268$ 1,211,772$ 3,599,040$ September 2017 2,730,366$ 1,211,772$ 3,942,138$ August 2017 2,814,262$ 1,211,772$ 4,026,034$ 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$ Cash and Investments 2,000,000 3,000,000 4,000,000 5,000,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 14 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 WORKER'S COMPENSATION FUND 2,573,365$ 179,136 2,871,742$ Liability 477,514 # of Claims this fiscal year 81changes 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\May 2018 - Financial Statements 15 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 EMPLOYEE CLINIC FUND FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 140,835$ 150,473$ 175,301$ 147,701$ 84.26%130,992$ 140,835$ 150,473$ 175,301$ 147,701$ 84.26% 130,992$ FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 242,612$ 172,135$ 175,301$ 138,750$ 79.15%135,120$ - - - 162 - - - - - - 242,612$ 172,135$ 175,301$ 138,912$ 79.24% 135,120$ 101,777$ 21,662$ (8,789)$ 4,128$ Total Revenues Revenues over / (under) expenditures Fund Balance Appropriated Department Employee Clinic Total Expenditures Source Departmental Charge Interest U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 16 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 EMPLOYEE CLINIC FUND PNC NCCMT Total May 2018 640,894$ 40,408$ 681,302$ April 2018 624,433$ 40,339$ 664,772$ March 2018 647,934$ 40,291$ 688,225$ February 2018 647,192$ 40,246$ 687,438$ January 2018 632,311$ 29,241$ 661,552$ December 2017 631,457$ 29,241$ 660,698$ November 2017 639,213$ 29,241$ 668,454$ October 2017 640,629$ 29,241$ 669,870$ September 2017 640,059$ 29,241$ 669,300$ August 2017 639,388$ 29,241$ 668,629$ 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$ Cash and Investments $650,000 $660,000 $670,000 $680,000 $690,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 17 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 EMPLOYEE CLINIC FUND May 2018 152 April 2018 137 March 2018 151 February 2018 165 January 2018 174 December 2017 131 November 2017 135 October 2017 153 September 2017 133 August 2017 142 July 2017 132 June 2017 120 May 2017 185 Employee Clinic Utilization 0 365 Health Prevention # of Visits # Flu shots # Pneumonia shots 0 20 40 60 80 100 120 140 160 180 200 Patient Flow U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 18 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 MEDICAL INSURANCE FUND FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 6,818,253$ 6,904,230$ 7,150,000$ 6,539,059$ 91.46%6,103,954$ 634,709 704,945 982,000 705,891 71.88%584,268 8,355 2,919 10,000 5,096 50.96%2,541 7,461,317$ 7,612,094$ 8,142,000$ 7,250,046$ 89.05% 6,690,763$ FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 7,892,453$ 7,994,131$ 8,100,000$ 8,050,058$ 99.38%6,647,269$ 26,178 19,851 42,000 6,789 16.16%19,123 - - - 4,396 - 7,918,631$ 8,013,982$ 8,142,000$ 8,061,243$ 99.01% 6,666,392$ 457,314$ 401,888$ 811,197$ (24,371)$ Interest 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\May 2018 - Financial Statements 19 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 MEDICAL INSURANCE FUND PNC NCCMT Total May 2018 2,755,640$ 1,118,243$ 3,873,883$ April 2018 3,213,447$ 1,116,364$ 4,329,811$ March 2018 2,655,902$ 1,115,056$ 3,770,958$ February 2018 2,729,825$ 1,113,846$ 3,843,671$ January 2018 2,642,643$ 543,297$ 3,185,941$ December 2017 2,724,166$ 543,297$ 3,267,463$ November 2017 2,724,166$ 543,297$ 3,267,463$ October 2017 2,503,575$ 543,297$ 3,046,872$ September 2017 2,511,895$ 543,297$ 3,055,192$ August 2017 2,336,726$ 543,297$ 2,880,023$ 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$ 3.73 4.44 3.75 3.76 3.52 3.74 Cash and Investments 4.00 *Number of Months Average Monthly Cost on Hand 4.76 4.76 5.65 4.20 4.45 4.64 5.60 6.36 3.83 * Based on running average (18 month, see below) cost of claims. 5.62 3.58 $2,400,000 $2,900,000 $3,400,000 $3,900,000 $4,400,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 20 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 MEDICAL INSURANCE FUND Employees & Pre-65 Retirees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent May 2018 873 1,331 532,418.76$ 62,794.89$ 81.57%729,687.82$ April 2018 878 1,336 690,936.21$ 64,977.27$ 103.05%733,556.92$ March 2018 873 1,328 987,547.70$ 66,284.37$ 142.55%739,264.99$ February 2018 868 1,320 674,392.56$ 64,528.27$ 100.27%736,956.69$ January 2018 868 1,318 496,888.52$ 62,435.24$ 77.07%725,712.40$ December 2017 866 1,322 764,148.08$ 66,112.11$ 113.77%729,765.50$ November 2017 867 1,332 761,805.97$ 64,198.44$ 113.19%729,765.50$ October 2017 863 1,324 581,206.37$ 62,181.09$ 87.65%734,013.78$ September 2017 862 1,315 614,099.71$ 65,346.44$ 92.95%731,001.65$ August 2017 861 1,316 465,032.05$ 62,291.38$ 72.08%731,553.84$ July 2017 863 1,319 565,579.25$ 62,926.27$ 85.73%733,143.41$ 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$ 860 1,309 11,264,777.07$ 1,084,904.40$ 97.88% 12,617,602.98$ Medical Paid Claims Summary Year to Date (membership = avg) 50% 75% 100% 125% 150% 175% Medical Plan Loss Ratio U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 21 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 DENTAL INSURANCE FUND FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 295,849$ 378,215$ 425,000$ 356,598$ 83.91%340,806$ 36,698 37,022 50,000 44,403 88.81%33,207 332,547$ 415,237$ 475,000$ 401,001$ 84.42% 374,013$ FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 369,211$ 490,944$ 475,000$ 434,137$ 91.40%415,539$ - - - 118 - 369,211$ 490,944$ 475,000$ 434,255$ 91.42% 415,539$ 36,664$ 75,707$ 33,254$ 41,526$ Category Paid Claims Fixed Cost Total Expenditures Source Dental Premium Equivilents Interest Total Revenues Revenues over / (under) expenditures U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 22 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 DENTAL INSURANCE FUND PNC NCCMT Total May 2018 352,968$ 30,111$ 383,079$ April 2018 376,226$ 30,060$ 406,286$ March 2018 344,934$ 30,025$ 374,959$ February 2018 346,156$ 29,993$ 376,149$ January 2018 342,004$ -$ 342,004$ December 2017 338,261$ -$ 338,261$ November 2017 322,359$ -$ 322,359$ October 2017 312,464$ -$ 312,464$ September 2017 318,326$ -$ 318,326$ August 2017 331,188$ -$ 331,188$ 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$ * Based on running average (18 month, see below) cost of claims. 8.22 8.27 8.11 8.11 *Number of Months Average Monthly Cost on Hand 10.70 8.70 8.75 8.82 9.08 9.25 8.89 8.73 9.00 9.45 9.55 10.51 10.93 11.43 Cash and Investments $250,000 $275,000 $300,000 $325,000 $350,000 $375,000 $400,000 $425,000 Cash Flow U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 23 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 DENTAL INSURANCE FUND Total Employees Total Membership Net Paid Claims Fixed Cost Loss Ratio Premium Equivalent May 2018 914 1,472 35,608.70$ 3,976.70$ 101.31%39,074.37$ April 2018 918 1,479 29,321.69$ 4,016.03$ 84.86%39,284.51$ March 2018 912 1,469 41,737.71$ 3,972.33$ 115.43%39,600.33$ February 2018 907 1,461 32,845.62$ 3,981.07$ 93.03%39,585.78$ January 2018 902 1,454 22,587.20$ 3,963.59$ 68.12%38,975.72$ December 2017 902 1,456 23,656.70$ 3,950.48$ 70.85%38,963.56$ November 2017 902 1,456 23,656.70$ 3,950.48$ 70.85%38,963.56$ October 2017 898 1,458 31,749.70$ 3,937.37$ 90.76%39,318.72$ September 2017 897 1,452 40,606.95$ 3,911.15$ 113.17%39,336.03$ August 2017 892 1,443 42,338.35$ 3,902.41$ 113.76%40,647.93$ 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$ 888 1,427 574,582.79$ 69,823.86$ 91.68% 702,851.82$ Dental Paid Claims Summary Year to Date (membership = avg) 50% 75% 100% 125% Dental Plan Loss Ratio U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 24 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 BOARD OF EDUCATION FYE 2016 FYE 2017 FYE 2018 Adjusted Budget FYE 2018 Activity Total Percent to Date Same Period Last Fiscal Year 115,268,881$ 120,677,046$ 127,199,960$ 109,760,363$ 86.29%106,092,900$ 115,268,881$ 120,677,046$ 127,199,960$ 109,784,568$ 86.31%106,100,707$ -$ -$ -$ 24,205$ 7,807$ 22,838,609 22,952,031 27,404,111 20,699,839 75.54%20,553,383 21,557,719 22,897,852 27,404,111 21,756,746 79.39%21,058,298 (1,280,890)$ (54,179)$ -$ 1,056,907$ 504,915$ 11,365,474 12,038,613 13,899,212 9,701,703 69.80%10,646,921 11,365,474 12,038,613 13,899,212 8,544,813 61.48%10,649,134 -$ -$ -$ (1,156,890)$ 2,213$ 3,165,403 3,423,972 4,749,913 118,017 2.48%3,395,126 2,844,295 3,534,301 4,749,913 12,871 0.27%3,534,258 (321,108)$ 110,329$ -$ (105,146)$ 139,132$ 10,013,377 10,201,124 11,365,310 9,459,470 83.23%9,236,883 10,608,154 10,538,806 11,365,310 8,672,751 76.31%10,202,351 594,777$ 337,683$ -$ (786,719)$ 965,468$ 304,258 269,520 282,502 143,342 50.74%250,473 299,648 307,645 282,502 278,709 98.66%292,574 (4,609)$ 38,125$ -$ 135,367$ 42,101$ 4,720,189 6,661,462 9,820,785 4,892,074 49.81%5,456,564 5,253,011 6,540,994 9,820,785 4,979,166 50.70%6,017,872 532,822$ (120,468)$ -$ 87,092$ 561,307$ 167,676,190 176,223,768 194,721,792 154,774,810 79.49%155,632,250 167,197,181 176,535,258 194,721,792 154,029,624 79.10%157,855,193 (479,009)$ 311,490$ -$ (745,186)$ 2,222,943$ * Latest available numbers from the Board of Education's web site. Capital Outlay Fund Expenditures Revenues Expenditures Revenues Local Restricted Fund Expenditures Revenues Total All Funds Child Nutrition Fund Expenditures Revenues Expenditures Revenues Dunn District Fund Expenditures Revenues Local Current Expense Fund Expenditures Revenues Federal Grant Fund Expenditures Revenues State Fund Fund Group U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 25 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 BOARD OF EDUCATION 2013 2014 2015 2016 2017 Non Spendable 1,417,080$ 2,130,098$ 1,849,351$ 1,796,064$ 1,762,157$ Restricted 2,813$ 67,971$ 21,420$ 25,507$ 31,744$ Committed -$ -$ -$ -$ -$ Assigned 4,004,023$ 3,508,927$ 5,466,811$ 3,845,000$ 3,750,000$ Unassigned 5,426,606$ 3,000,000$ 2,889,118$ 3,274,629$ 3,425,107$ 10,850,522$ 8,706,996$ 10,226,700$ 8,941,200$ 8,969,008$ General Fund Expenditures 20,262,634$ 22,848,788$ 20,369,083$ 23,089,579$ 23,143,782$ 26.78% 13.13% 14.18% 14.18% 14.80% Unassigned Fund Balance as a % of Expenditures Total General Fund Estimated Fund Balance 1.00% 11.00% 21.00% 2013 2014 2015 2016 2017 26.78% 13.13%14.18%14.18%14.80% Fund Balance % U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 26 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 May, 2018 BOARD OF EDUCATION ADM * MLD ** ADM Change MLD Change Month 1 20,390 20,515 Month 1 Revd 20,372 20,460 (18)(55) Month 2 20,463 20,481 91 21 Month 3 20,420 20,497 (43)16 Month 4 20,428 20,489 8 (8) Month 5 20,383 20,340 (45)(149) Month 6 20,260 20,256 (123)(84) Month 7 Month 8 Month 9 Final * ADM = Average Daily Membership is an average over across a school month ** MLD + Membership Last Day is for the last day of the school month Public School Membership Fiscal Year 2017-2018 Initial Allotment 20,979 ADM MLD 19,500 20,000 20,500 21,000 Harnett County School Membership ADM MLD U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 27 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 June 30, 2017 HARNETT COUNTY TOWNS 1 0.00% 20.00% 40.00% 60.00% 80.00% 100.00% ANGIER (5,041) COATS (2,301) DUNN (9,675) ERWIN (4,674) LILLINGTON (3,361) 101.06% 78.91% 27.64% 59.61% 167.99%Fund Balance % Towns Pier Group (population based) Angier Coats Dunn Erwin Lillington $ 3.5 M $ 1.4 M $ 10.1 M $ 2.7 M $ 5.1 M $ 3.7 M $ 1.5 M $ 10.0 M $ 3.1 M $ 3.7 M Revenues / Expenditures Revenues Expenditures U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 28 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 June 30, 2017 HARNETT COUNTY TOWNS 1 1 https://www.nctreasurer.com/slg/lfm/financial-analysis/Pages/Analysis-by-Population.aspx $9,041,191 $1,960,064 $5,735,903 $4,849,443 $5,697,648 Cash Angier Coats Dunn Erwin Lillington U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 29 HARNETT COUNTY FINANCIAL SUMMARY REPORT 6/26/2018 June 30, 2017 HARNETT COUNTY TOWNS 1 2017 2016 2015 2014 2013 Angier 3,690,393$ 3,373,615$ 3,244,678$ 3,070,761$ 3,046,623$ Coats 1,530,611$ 1,422,963$ 1,298,168$ 1,355,209$ 1,259,920$ Dunn 10,024,782$ 9,405,895$ 8,566,657$ 8,722,646$ 8,427,866$ Erwin 3,105,786$ 2,817,330$ 2,717,591$ 2,729,123$ 2,700,706$ Lillington 3,717,756$ 3,597,039$ 3,323,632$ 3,157,018$ 2,796,363$ 2017 2016 2015 2014 2013 Angier 3,456,701$ 3,488,463$ 3,048,201$ 2,904,756$ 2,871,727$ Coats 1,410,692$ 1,277,106$ 1,200,095$ 1,332,261$ 1,162,626$ Dunn 10,081,309$ 8,678,014$ 8,557,297$ 8,823,733$ 8,928,070$ Erwin 2,650,771$ 3,445,542$ 3,283,518$ 3,113,100$ 2,744,155$ Lillington 5,055,946$ 3,433,360$ 3,302,294$ 3,031,109$ 2,839,535$ 2017 2016 2015 2014 2013 Angier 101.06% 91.40% 113.06% 116.07% 104.22% Coats 78.91% 76.19% 68.96% 56.41% 54.02% Dunn 27.64% 27.10% 28.99% 28.54% 29.31% Erwin 59.61% 34.00% 51.22% 67.16% 85.28% Lillington 167.99% 90.65% 71.52% 75.44% 77.23% 2017 2016 2015 2014 2013 Angier 9,041,191$ 7,449,366$ 7,606,498$ 7,239,088$ 6,813,845$ Coats 1,960,064$ 1,793,914$ 1,602,899$ 1,624,126$ 1,023,278$ Dunn 5,735,903$ 5,091,071$ 4,274,726$ 3,975,762$ 4,853,633$ Erwin 4,849,443$ 4,349,190$ 5,093,880$ 6,498,775$ 6,950,055$ Lillington 5,697,648$ 4,091,241$ 3,741,672$ 3,312,572$ 3,539,495$ 1 https://www.nctreasurer.com/slg/lfm/financial-analysis/Pages/Analysis-by-Population.aspx Revenues Expenditures Fund Balance % Cash U:\My Documents\Monthly Reports\2017 - 2018\May 2018 - Financial Statements 30