No preview available
HomeMy WebLinkAboutJuly 2016 - Financial Statements9/2/2016 FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year $ 158,070 $ 300,587 $ 306,202 $ 88,512 28.91% $ 33,955 280,372 484,180 347,271 29,442 8.48% 20,101 8,609 197,703 68,915 9,820 14.25% 10,221 247,154 287,522 239,154 22,714 9.50% 19,146 305,481 366,008 410,912 37,231 9.06% 32,728 833,532 1,053,639 855,992 48,203 5.63% 38,022 - - 415,000 19,972 4.81% - 79,320 81,438 103,488 11,740 11.34% 3,320 1,588,997 1,612,412 1,705,915 140,883 8.26% 93,278 153,360 142,699 154,225 6,632 4.30% 5,949 603,102 523,170 575,174 57,196 9.94%17,989 839,486 1,421,224 1,640,135 40,924 2.50% 22,694 209,741 173,504 230,092 5,948 2.59% 7,051 3,736,788 3,532,098 3,113,730 120,210 3.86% 225,614 695,654 699,936 785,748 30,070 3.83% 22,367 1,726,510 1,865,702 1,862,057 316,605 17.00% 214,925 436,602 611,335 598,205 41,496 6.94% 30,713 10,205,366 8,976,207 9,780,391 499,712 5.11% 425,324 389,674 416,785 495,509 19,952 4.03% 16,494 1,607 23,765 - - - 70,126 63,446 84,599 3,309 3.91% 2,775 - - - - - 1,389,574 1,538,737 1,814,053 153,783 8.48% 62,726 School Resource Officers - 657,551 745,546 32,492 4.36% - 4,407,161 4,155,183 4,946,395 386,395 7.81% 294,819 765,164 651,711 876,869 33,450 3.81% 23,248 - - - - - 4,080,768 4,136,826 6,010,775 326,310 5.43% 146,159 1,144,801 1,115,807 - 14 39,006 3,361,704 3,361,704 3,361,704 560,284 16.67% 280,142 431,707 391,021 484,308 20,150 4.16% 13,579 47,050 76,800 85,000 3,700 4.35% - 4,516 6,886 - - - 79,180 71,908 6,000 - 5,229 236,688 - - - - 246,495 (7,131) - - 8,505 208,990 167,800 198,216 16,698 8.42% 6,167 161,801 165,510 181,799 8,001 4.40% 7,212 4,000 4,000 4,000 4,000 100.00% - 112,289 96,120 111,585 - - 458,253 417,055 575,000 - - 1,382,346 426,134 1,107,566 28,954 2.61% 23,096 1,362,552 1,263,168 1,403,293 71,840 5.12% 60,771 735 190 1,500 - - 57,241 31,401 34,606 966 2.79% 806 289,118 306,040 414,538 22,642 5.46% 4,378 25,623 22,677 43,445 713 1.64% - 379 150 1,000 - - 44,813 45,881 - - - 60,321 74,661 72,470 3,656 5.04% 2,964 Campbell Deputies Facilities Maintenance Register of Deeds Legal Services Environmental Protection Forestry Program Economic/Physical Dev. App. Industrial Development JCPC Admin Public Safety Appropriations Emergency Telephone System Radio System Harnett Regional Jetport Human Resources Board of Elections Finance Development Services Community Development (BG) Abandoned MFG Home Cooperative Extension CCR&R - Block Grant Soil & Water Department Governing Body Administration General Services Fleet Maintenance Transportation Transportation - Admin HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 GENERAL FUND CCR&R - United Way Emergency Medical Service Insurance - Retirees EMS Transport Rescue Districts Sheriff's Department Grants Child Support Enforcement Governor's Highway Safety Communications Jail Emergency Services Emergency Services Grant Animal Services Medical Examiner Parents As Teachers Adolescent Parenting Clerk of Court Information Technology GIS Sheriff Tax U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 1 9/2/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 GENERAL FUND FYE 2015 Unaudited FYE 2016 FYE 2016 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year - 70,409 49,100 1,442 2.94% 955 50,723 - - - - - 4,034 2,562 - 395 14,200 - - - - - 20,744 27,500 854 3.11% 2,630 307,602 294,274 318,187 19,955 6.27% 5,577 64,108 59,318 63,761 2,801 4.39% 2,079 77,658 75,207 78,709 3,208 4.08% 2,704 328,753 317,780 336,206 16,273 4.84% 15,611 414,989 405,092 432,345 49,164 11.37% 2,427 6,014,268 5,874,435 6,604,915 310,125 4.70% 241,058 605,679 605,679 605,679 151,420 25.00% 51,420 10,155,398 9,847,706 12,224,040 613,907 5.02% 536,346 7,905,017 8,869,847 8,271,854 480,489 5.81% 508,104 178,634 172,187 186,475 9,326 5.00% 7,473 100,304 96,466 114,212 4,755 4.16% 3,397 90,780 129,039 50,000 - 6,000 941,972 841,928 995,701 46,829 4.70% 38,545 150,000 3,000 150,000 - - 403,871 398,817 513,889 145,347 28.28% 61,747 21,523,700 21,267,993 21,230,016 3,538,336 16.67% 1,772,333 - 280,707 - - - - - 1,252,000 - - 928,467 993,967 1,019,467 84,956 8.33%76,456 - - 30,500 - - - - 798,517 66,543 8.33%- 25,000 - - - - - 70,000 - - - $ 93,213,943 $ 92,709,779 $ 101,608,017 $ 8,770,349 8.63% $ 5,559,630 64,701 43,334 1,359,842 - - 44,265,436 52,687,811 16,715,631 581,794 3.48% 596,069 - - 217,016 - - $ 44,330,137 $ 52,731,145 $ 18,292,489 $ 581,794 3.18% $ 596,069 137,544,080$ 145,440,924$ 119,900,506$ 9,352,143$ 7.80%6,155,699$ Central Carolina - DOT Central Carolina - health sciences Board of Education - teachers Cultural & Recreational App. Parks & Recreation Education Special Programs Subtotal - Operating Expenditures Subtotal Other Financing Uses: Department Mental Health Social Services Public Assistance Veteran's Services Family Caregiver Support RSVP Interfund Transfers Debt Service Contingency Total Expenditures 4-H Teen Court & At Risk 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\2016 - 2017\July 2016 - Financial Statements.xlsx 2 9/2/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 GENERAL FUND FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date Same Period Last Fiscal Year 53,930,707$ 54,809,711$ 55,606,980$ 160,736$ 0.29%103,363$ 5,712,141 5,604,875 5,888,405 - 247 16,757,810 14,272,536 19,008,522 - - 1,053,493 1,123,843 1,250,000 104,953 8.40%97,146 2,515,489 2,609,939 3,365,051 259,993 7.73%195,441 18,884,854 16,154,685 18,750,374 522,799 2.79%550,835 7,838,973 8,747,993 9,650,287 316,819 3.28%162,507 3,741,739 2,955,130 3,761,890 280,373 7.45%20,368 69,215 73,655 70,609 6,386 9.04%891 110,504,421 106,352,367 117,352,118 1,652,059 1.41%1,130,798 8,437 79,545 30,000 3 0.01%123 29,108,938 37,018,000 - - - 322,415 7,501 2,518,388 - - - - - - - 29,439,790 37,105,046 2,548,388 3 0.00%123 139,944,211$ 143,457,413$ 119,900,506$ 1,652,062$ 1.38%1,130,921$ 2,400,131$ (1,983,511)$ (7,700,081)$ (5,024,778) Investment Earnings Subtotal - Operating Revenues Subtotal Other Financing Sources: Revenues over / (under) expenditures Other Financing Sources Interfund Transfers Fund Balance Appropriated Total Revenues Permits & Fees Intergovernmental Revenue Sales & Services Other Revenues Rents, Concessions & Fees Ad Valorem Taxes Motor Vehicles Sales Tax Other taxes Revenues: Real and Personal U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 3 9/2/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 GENERAL FUND Cash MBS NCCMT Total 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$ January 2016 10,575,231$ 4,715,250$ 27,749,119$ 43,039,600$ December 2015 638,944$ 4,715,250$ 27,050,869$ 32,405,064$ November 2015 -$ 4,715,250$ 24,697,474$ 29,412,724$ October 2015 -$ 3,415,750$ 15,184,900$ 18,600,650$ September 2015 -$ 1,799,750$ 16,262,992$ 18,062,742$ August 2015 -$ 1,799,750$ 14,138,439$ 15,938,189$ July 2015 482,070$ 1,199,750$ 19,037,670$ 20,719,491$ 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$ Debt Service and Transfer Requirements Cash and Investments $15,000,000 $25,000,000 $35,000,000 $45,000,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 4 9/2/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 GENERAL FUND 2012 2013 2014 2015 2016 Non Spendable 748,224$ 451,088$ 111,181$ 159,625$ 159,625$ Restricted 8,789,704$ 9,433,149$ 9,260,952$ 11,496,063$ 11,496,063$ Committed 574,133$ -$ -$ -$ -$ Assigned -$ -$ 3,193,811$ 2,600,000$ -$ Unassigned 13,212,441$ 17,959,942$ 18,732,095$ 19,417,388$ 26,017,388$ Total General Fund 23,324,502$ 27,844,179$ 31,298,039$ 33,673,076$ 37,673,076$ General Fund Expenditures 100,900,981$ 101,852,867$ 103,330,529$ 108,508,715$ 110,000,000$ 13.09%17.63%18.13%17.89%23.65%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. The Harnett County Board of Commissioners have approved a fund balance policy which strives to maintain a minimum fund balance of 15%. 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 1.00% 11.00% 21.00% 2012 2013 2014 2015 2016 13.09%17.63%18.13%17.89%23.65% Fund Balance % U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 5 9/2/2016 FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 6,369,116$ 4,049,200$ 5,702,628$ 224,301$ 3.93%96,005$ 3,965,881 3,913,153 5,000,402 270,263 5.40%163,399 1,908,016 1,747,529 2,711,883 105,543 3.89%62,879 1,869,169 1,880,790 2,720,882 117,787 4.33%63,978 3,607,800 3,734,828 4,564,365 270,940 5.94%149,379 3,006,906 2,513,915 3,752,716 109,334 2.91%131,428 20,726,888$ 17,839,415$ 24,452,876$ 1,098,168$ 4.49%667,067$ 22,607,192 - - - - 6,395,389 - 5,106,266 5,230,476 5,273,907 - 182,421 34,108,847$ 5,230,476$ 5,273,907$ -$ 182,421$ 54,835,735$ 23,069,891$ 29,726,783$ 1,098,168$ 3.69%849,489$ FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date Same Period Last Fiscal Year 3,703$ 3,703$ 3,703$ -$ -$ 30,134,602 30,529,868 29,448,080 3,415,855 11.60%2,900,148 2,023,403 2,275,669 275,000 19,041 6.92%42,653 172 894 - - - 32,161,880$ 32,810,134$ 29,726,783$ 3,434,896$ 11.55%2,942,801$ 13,731,430 320,484 - - - 1,452,130 450,000 - - - - - - - - 15,183,560$ 770,484$ -$ -$ -$ 47,345,440$ 33,580,618$ 29,726,783$ 3,434,896$ 11.55%2,942,801$ (7,490,295)$ 10,510,727$ 2,336,728$ 2,093,313$ Sales & Services Other Revenues Subtotal - Operating Expenditures Interfund Transfers Depreciation HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 PUBLIC UTILITIES FUND Department Admin/CSR/Meter Services Water Treatment Wastewater Treatment Wastewater Treatment SHWW Distribution Collections Revenues over / (under) expenditures Rents, Concess. & Feees Other Finance Sources Interfund Transfers Fund Balance Appropriated Total Revenues Subtotal Other Financing Sources: Debt Service Subtotal Other Financing Uses: Subtotal - Operating Revenues Total Expenditures Revenues: Intergovernmental Revenue U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 6 9/2/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 PUBLIC UTILITIES FUND Cash Lockbox NCCMT Total 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$ January 2016 29,009,846$ 3,010,381$ 554,829$ 32,575,057$ December 2015 24,228,551$ 3,662,494$ 553,621$ 28,444,666$ November 2015 24,058,100$ 3,267,333$ 552,071$ 27,877,505$ October 2015 23,345,138$ 3,268,625$ 549,916$ 27,163,678$ September 2015 22,373,066$ 3,142,028$ 549,700$ 26,064,794$ August 2015 20,802,670$ 3,162,849$ 549,270$ 24,514,789$ July 2015 19,413,391$ 3,411,495$ 549,057$ 23,373,942$ 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$ Cash and Investments Debt Service and Transfer Requirements $20,000,000 $30,000,000 $40,000,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 7 9/2/2016 FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 4,555,419$ 4,601,713$ 5,461,118$ 235,570$ 4.31%62,021$ 4,555,419$ 4,601,713$ 5,461,118$ 235,570$ 4.31%62,021$ 1,396,177 - - - - - - - - - 345,724 - - - - 529,747 540,939 544,828 41,904 7.69%30,900 2,271,648$ 540,939$ 544,828$ 41,904$ 7.69%30,900$ 6,827,067$ 5,142,652$ 6,005,946$ 277,474$ 4.62%92,921$ FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date Same Period Last Fiscal Year 234,276$ 194,789$ 219,000$ -$ -$ 25,000 133,790 - - - 5,165,089 5,054,796 5,265,540 69,159 1.31%7,581 499,631 598,071 - - 136 276 1,165 20,000 - 0.00%- 5,924,272$ 5,982,611$ 5,504,540$ 69,159$ 1.26%7,717$ 1,402,161 - - - - - - - - - - - 501,406 - - 1,402,161$ -$ 501,406$ -$ -$ 7,326,433$ 5,982,611$ 6,005,946$ 69,159$ 1.15%7,717$ 499,366$ 839,959$ (208,315)$ (85,204)$ Rents, Concess. & Feees Other Finance Sources Subtotal - Operating Revenues Revenues: Taxes Intergovernmental Revenue Sales & Services Other Revenues Depreciation HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 SOLID WASTE FUND 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\2016 - 2017\July 2016 - Financial Statements.xlsx 8 9/2/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 SOLID WASTE FUND Cash BB&T First Bank NCCMT Total 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$ January 2016 1,838,468$ 495,010$ 469,484$ 123,226$ 2,926,188$ December 2015 1,157,547$ 482,090$ 451,079$ 123,226$ 2,213,942$ November 2015 795,755$ 469,359$ 439,402$ 123,226$ 1,827,742$ October 2015 160,831$ 456,391$ 422,540$ 59,824$ 1,099,587$ September 2015 182,041$ 425,002$ 394,917$ 59,824$ 1,061,785$ August 2015 372,508$ 425,018$ 395,198$ 59,824$ 1,252,548$ July 2015 350,504$ 379,409$ 365,494$ -$ 1,095,407$ Current Year Outstanding 127,831$ 335,060$ 510,937 2,700,856 - - 638,767$ 3,035,917$ Cash and Investments Debt Service and Transfer Requirements $1,000,000 $2,000,000 $3,000,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 9 9/2/2016 FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 29,000$ 21,000$ 32,000$ -$ -$ 123,636 1,243,316 1,093,000 160 0.01%267,146 152,636$ 1,264,316$ 1,125,000$ 160$ 0.01%267,146$ FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date Same Period Last Fiscal Year 1,821,371$ 1,034,824$ 975,000$ 80,533$ 8.26%74,261$ 250,795 354,332 150,000 - 22,682$ - - - - 2,072,166$ 1,389,156$ 1,125,000$ 80,533$ 7.16%96,943$ Revenues over/(under) expenses 1,919,530$ 124,840$ 80,373$ (170,203)$ Cash NCCMT Total 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$ January 2016 1,556,134$ 1,211,772$ 2,767,906$ December 2015 1,193,599$ 1,211,772$ 2,405,371$ November 2015 1,273,094$ 1,211,772$ 2,484,866$ October 2015 1,329,590$ 1,211,772$ 2,541,362$ September 2015 1,238,990$ 1,211,772$ 2,450,762$ August 2015 1,234,512$ 1,211,772$ 2,446,284$ July 2015 1,140,351$ 1,211,772$ 2,352,123$ 2,839,689$ - Liability as of end of month 2,841,249$ HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 WORKER'S COMPENSATION FUND Cash and Investments Category Fixed Cost Claims Funded Total Revenues: Departmental Charge Other revenues Fund Balance Appropriated Total Liability 1,560 # of Claims this fiscal year 6 Liability as of July 1 Current year claims and changes in estimates Actual claim payments $1,000,000 $2,000,000 $3,000,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 10 9/2/2016 FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 121,440$ 136,354$ 177,232$ 5,382$ 3.04%5,905$ 121,440$ 136,354$ 177,232$ 5,382$ 3.04%5,905$ FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date Same Period Last Fiscal Year 228,950$ 242,612$ 177,232$ 12,150$ 6.86%-$ - - - - - - - - - - 228,950$ 242,612$ 177,232$ 12,150$ 6.86%-$ Revenues over/(under) expenses 107,510$ 106,258$ 6,768$ (5,905)$ Cash NCCMT Total June 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$ 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$ Total Cash and Investments Fund Balance Appropriated HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 EMPLOYEE CLINIC FUND Department Employee Clinic Total Revenues: Departmental Charge Other revenues $500,000 $600,000 $700,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 11 9/2/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 EMPLOYEE CLINIC FUND # of Visits July 2016 144 June 2016 162 May 2016 171 April 2016 149 March 2016 163 February 2016 159 January 2016 182 December 2015 196 November 2015 132 October 2015 144 September 2015 131 August 2015 98 July 2015 113 Employee Clinic Utilization 0 0 Health Prevention # Flu shots # Pneumonia shots 0 50 100 150 200 Patient Flow U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 12 9/2/2016 FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 5,205,337$ 6,477,586$ 5,650,000$ 797,979$ 14.12%153,256$ 655,329 634,592 795,000 118,774 14.94%- 1,507 8,355 10,000 762 7.62%- 5,862,173$ 7,120,533$ 6,455,000$ 917,515$ 14.21%153,256$ FYE 2015 Unaudited FYE 2016 FYE 2017 Adjusted Budget FYE 2017 Activity Total Percent to Date Same Period Last Fiscal Year 6,687,178$ 6,737,032$ 6,443,000$ 618,468$ 9.60%516,539$ 10,783 26,178 12,000 656 5.47%- 6,697,961$ 6,763,210$ 6,455,000$ 619,124$ 9.59%516,539$ Revenues over/(under) expenses 835,788$ (357,323)$ (298,391)$ 363,283$ Cash NCCMT Total 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$ January 2016 1,351,919$ 543,297$ 1,895,216$ December 2015 1,222,061$ 543,297$ 1,765,358$ November 2015 1,387,910$ 543,297$ 1,931,207$ October 2015 1,290,451$ 543,297$ 1,833,748$ September 2015 1,502,651$ 543,297$ 2,045,949$ August 2015 1,387,676$ 543,297$ 1,930,973$ July 2015 1,204,970$ 543,297$ 1,748,267$ June 2015 1,393,258$ 543,297$ 1,936,555$ HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 MEDICAL INSURANCE FUND Cash and Investments Category Paid Claims Wellness Total Revenues: Medical Premium Equivilents Other revenues Total Fixed Cost $1,000,000 $1,500,000 $2,000,000 $2,500,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 13 9/2/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 MEDICAL INSURANCE FUND Employees & Pre-65 Retirees Total MembershipNet Paid ClaimsFixed Cost Loss Ratio Premium Equivalent July 2015 800 1,162 320,633.21$ 54,321.22$ 69.90%536,400.67$ August 2015 802 1,167 383,357.49$ 56,855.83$ 82.22%535,395.42$ September 2015 802 1,169 465,117.51$ 55,311.71$ 96.87%537,247.45$ October 2015 808 1,174 650,383.71$ 103,099.20$ 141.27%533,359.40$ November 2015 808 1,173 531,699.65$ 59,136.25$ 108.27%545,697.46$ December 2015 812 1,177 448,829.22$ 52,614.19$ 92.18%544,006.75$ January 2016 820 1,191 418,525.31$ 56,097.08$ 86.93%545,957.33$ February 2016 829 1,199 476,696.71$ 57,028.00$ 97.08%549,770.71$ March 2016 824 1,192 613,689.61$ 55,057.79$ 122.98%543,783.54$ April 2016 819 1,190 846,544.07$ 59,316.96$ 166.24%544,921.50$ May 2016 821 1,195 644,458.97$ 18,765.56$ 121.42%546,217.69$ June 2016 826 1,201 749,785.30$ (48,146.18)$ 112.65%622,838.33$ July 2016 830 1,237 567,120.08$ 117,732.75$ 110.73%618,468.30$ 815 1,187 7,116,840.84$ 697,190.36$ 108.47%7,204,064.55$ Medical Paid Claims Summary Year to Date (membership = avg) 50.00%75.00%100.00%125.00%150.00% 175.00% Medical Plan Loss Ratio U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 14 9/2/2016 FYE 2015 Unaudited FYE 2016 2016 - 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 306,584$ 296,421$ 500,000$ 43,444$ 8.69%12,461$ 35,323 36,698 45,000 7,101 15.78%3,034 341,907$ 333,119$ 545,000$ 50,545$ 9.27%15,495$ FYE 2015 Unaudited FYE 2016 2015 - 2016 Adjusted Budget FYE 2016 Activity Total Percent to Date Same Period Last Fiscal Year 544,448$ 369,211$ 545,000$ 37,753$ 6.93%29,813$ - - - - - 544,448$ 369,211$ 545,000$ 37,753$ 6.93%29,813$ Revenues over/(under) expenses 202,541$ 36,092$ (12,792)$ 14,318$ Cash NCCMT Total 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$ January 2016 255,653$ -$ 255,653$ December 2015 257,742$ -$ 257,742$ November 2015 251,362$ -$ 251,362$ October 2015 242,621$ -$ 242,621$ September 2015 249,844$ -$ 249,844$ August 2015 249,852$ -$ 249,852$ July 2015 248,309$ -$ 248,309$ HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 DENTAL INSURANCE FUND Cash and Investments Category Paid Claims Fixed Cost Total Revenues: Dental Premium Equivilents Other revenues Total $200,000 $225,000 $250,000 $275,000 $300,000 Cash Flow U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 15 9/2/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT July, 2016 DENTAL INSURANCE FUND Total Employees Total MembershipNet Paid ClaimsFixed Cost Loss Ratio Premium Equivalent July 2015 650 1,097 14,975.40$ 6,090.62$ 70.66%29,813.15$ August 2015 651 1,094 31,428.55$ 3,033.66$ 116.21%29,654.93$ September 2015 650 1,093 28,953.57$ 3,033.66$ 106.13%30,140.02$ October 2015 654 1,097 30,171.44$ 3,033.66$ 114.74%28,939.38$ November 2015 648 1,090 19,987.80$ 3,010.36$ 74.83%30,735.68$ December 2015 649 1,093 20,264.80$ 3,047.64$ 77.38%30,126.24$ January 2016 658 1,105 27,163.98$ 3,056.96$ 102.76%29,408.35$ February 2016 660 1,101 20,728.10$ 3,075.60$ 76.42%31,147.59$ March 2016 660 1,101 29,696.70$ 3,122.20$ 110.76%29,629.84$ April 2016 659 1,100 31,526.79$ 3,033.66$ 115.55%29,909.42$ May 2016 667 1,110 22,062.20$ 3,084.92$ 84.50%29,760.98$ June 2016 671 1,114 28,488.90$ 6,202.76$ 90.84%38,188.97$ July 2016 810 1,316 31,416.37$ 4,006.42$ 93.83%37,752.67$ 668 1,116 336,864.60$ 46,832.12$ 94.69%405,207.22$ Dental Paid Claims Summary Year to Date (membership = avg) 50.00% 75.00% 100.00% 125.00% Dental Plan Loss Ratio U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 16 9/2/2016 FYE 2015 Unaudited FYE 2016 2016 - 2017 Adjusted Budget FYE 2017 Activity (includes encumbrances) Total Percent to Date Same Period Last Fiscal Year 102,207,084$ 102,223,378$ -$ 16,295$ -$ -$ -$ 19,279,878 21,520,806 -$ 2,240,928$ -$ -$ -$ 9,658,731 9,670,260 -$ 11,528$ -$ -$ -$ 2,990,946 2,681,150 -$ (309,796)$ -$ -$ -$ 9,324,806 9,246,428 -$ (78,378)$ -$ -$ -$ 292,697 284,577 -$ (8,120)$ -$ -$ -$ 3,813,528 4,694,184 -$ 880,656$ -$ -$ -$ - 147,567,670 - - - - 150,320,783 - - - -$ 2,753,113$ -$ -$ -$ * 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 HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 * BOARD OF EDUCATION Fund Group: U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 17 9/2/2016HARNETT COUNTY FINANCIAL SUMMARY REPORT May, 2016 * BOARD OF EDUCATION Capital Outlay Total July 2016 -$ June 2016 May 2016 10,442,838$ 59,509$ 10,502,347$ April 2016 -$ March 2016 8,709,721$ 59,476$ 8,769,197$ February 2016 -$ January 2016 -$ December 2015 -$ November 2015 -$ October 2015 -$ September 2015 -$ August 2015 -$ July 2015 -$ ADM MLD ADM Change MLD Change Month 1 20,405 20,543 Month 1 Revd 20,387 20,495 (18)(48) Month 2 20,505 20,504 118 9 Month 3 20,468 20,465 (37)(39) Month 4 20,360 20,332 (108)(133) Month 5 20,229 20,190 (131)(142) Month 6 20,164 20,191 (65)1 Month 7 20,142 20,148 (22)(43) Month 8 20,097 20,121 (45)(27) Month 9 20,035 20,017 (62)(104) Final 20,252 20,017 217 0 Public School Membership Fiscal Year 2015-2016 Initial Allotment 20,725 Cash and Investments Local Currrent Expense $5,000,000 $7,000,000 $9,000,000 $11,000,000 Cash Flow 19,500 20,000 20,500 21,000 Harnett County School Membership ADM MLD U:\My Documents\Monthly Reports\2016 - 2017\July 2016 - Financial Statements.xlsx 18