Loading...
HomeMy WebLinkAboutAgenda - 03-10-20; 12-5 - Information Item - Financial Report for Second Quarter of FY2019-20 1 ORANGE COUNTY NORTH CAROLINA FINANCE and ADMINISTRATIVE SERVICES Gary Donaldson,CTP,Chief Financial Officer I gdonaldson@orangecountync.gov 1200 S.Cameron Street,Hillsborough,NC 27278 1 919.245.2453 To: Board of County Commissioners From: Gary Donaldson, Chief Financial Officer Date: February 18, 2020 Re: Financial Report for Second Quarter of FY 2019-20 OVERVIEW The County financial report for the second quarter of fiscal year 2019-20 provides information on the economy, revenues, expenditures, cash balances through December 31, 2019.The summary tables below covers the General Fund, Enterprise Funds, and Special Revenue Funds.The notes at the end of each table provide variance explanations which compares the current fiscal year year-to-date with the prior fiscal year. Based on six-months of fiscal year activity and updates to our long-term financial model, the General Fund is projected to end FY 2019- 20 with no use of fund balance. Further General Fund detail is included for additional review. The Enterprise Funds and Special Revenue Funds are projected to end the fiscal year consistent with the FY 2019-20 operating budget as well. Economy The economic research centers at both UNC-Charlotte and NC State University indicate moderate economic growth as measured by U.S. Gross Domestic Product and Gross State Product growth rates are at 2%through FY 2019-20.The County's financial model and forecast assumptions are predicated on continued economic growth. Economic data from the NC economist views can be found at the following links: UNC-Charlotte NC State University Revenues-General Fund General Fund revenues represent 64.2%of total revenues as compared with the prior fiscal year of 62.6%. The property tax base which is growing by 2%and projected collection rate are forecasted to meet the budgeted amount. Sales tax has experienced solid growth primarily attributed to the NC Department of Revenue enforcement of online sales tax transactions and has indicated by the historical sales tax trends. Expenditures-General Fund General Fund expenditures represent 45.3%of total expenditure as compared with the prior fiscal year of 45.5%. Expenditures are projected to be within budget primarily attributed to personnel savings and prudent management of non-personnel expenditures. There are no major expenditure variances among the Functional Leadership Teams that warrant additional attention at this juncture. Other County Funds There are no major variances among the other County Funds and these operating funds are expected to perform within budget as indicated by the enclosed table. cc: Bonnie Hammersley, County Manager Enclosures Orange County Government I www.orangecountync.gov 1919.732.8181 2 ORANGE COUNTY NQRTH CAROLINA Finance and Administrative Services FY 2019-20 Second Quarter FY 2020 FY 2019 FYs 2020 vs 2019 GENERAL FUND Original Budget Revised Budget YTDActual* Percentage YTDActual* Percentage YTD %Variance' Property Tax $165,153,931 $165,153,931 $135,702,146 82.2% $125,016,481 78.8% $10,685,665 3.3%0 Sales&Use Tax $25,372,861 $25,372,861 $7,081,317 27.9% $6,296,944 26.1% $784,373 1.8% Licenses and Permits $313,260 $313,260 $65,299 20.8% $71,599 22.9% -$6,300 -2.0%0 Charges for Services $12,704,833 $12,731,515 $6,034,138 47.4% $4,658,463 37.4% $1,375,675 10.0% 1 Intergovernmental $18,278,612 $18,874,594 $5,226,123 27.7% $5,501,396 30.8% -$275,273 -3.2% W Transfers In $4,034,600 $4,034,600 $0 0.0% $0 0.0% $0 0.0%- Investment Earnings $415,000 $415,000 $336,883 81.2% $165,355 39.8% $171,528 41.3%0 Z Miscellaneous $3,040,769 $3,250,663 $548,974 16.9% $657,031 20.7% -$108,057 -3.8%0 Appropriated Fund Balance $7,808,006 $9,327,952 $0 0.0% $0 0.0% $0 0.0%- Total $237,121,872 $239,474,376 $153,691,283 64.2% $142,367,270 62.6% $11,324,013 1.6%0 Community Services $14,421,090 $14,850,152 $6,703,250 45.1% $5,951,317 44.2% $751,933 1.0%0 General Government $10,556,767 $10,839,786 $5,581,438 51.5% $5,627,469 56.0% -$46,031 -4.5%0 Public Safety $26,643,096 $27,442,780 $12,519,973 45.6% $12,057,161 46.9% $462,812 -1.2%0 :g Human Services $40,822,906 $42,024,436 $18,470,470 44.0% $19,482,725 48.7% -$1,012,255 -4.7%0 a Education $93,508,573 $93,508,573 $45,026,694 48.2% $43,719,891 47.4% $1,306,803 0.8%0 ,X Support Services $12,465,362 $11,971,571 $6,668,694 55.7% $7,099,828 52.3% -$431,134 3.4%0 a Debt Service $30,754,428 $30,754,428 $13,478,282 43.8% $10,346,219 34.5% $3,132,063 9.3% 4 Transfers Out $7,949,650 $8,082,650 $0 0.0% $0 0.0% $0 0.0%o Total $237,121,872 $239,474,376 $108,448,801 45.3% $104,284,611 45.5% $4,164,190 -0.2% Notes: *-Actual amounts include Encumbrances. +-Based on percentage. 1-Higher fee collections at Register of Deeds,Health Department,Planning and Inspections,Sheriff,and Emergency Services compared to FY 2018-19. 2-Investment earnings reflect the timing of interest allocations. 3-Finance Department is reviewing material variances with affected departments. 4-Based on increased Debt Service payments in FY 2019-20. 3 ORANGE COUNTY NORTH CAMUNA Finance and Administrative Services FY 2019-20 Second Quarter FY 2020 FY 2019 FYs 2020 vs 2019 OTHER FUNDS Original Budget Revised Budget YTDActual* Percentage YTDActual* Percentage YTD %Variance' 29-Annual Grants Project Fund $141,464 $143,155 $22,360 15.6% $49,722 35.3% -$27,362 -19.6% 6 30-Multi-Year Grant Projects Fund $129,765 $538,821 $211,587 39.3% $235,740 7.0% -$24,153 32.3%0 6 32-Multi-Year Community Development Fund $1,724,544 $1,804,547 $224,512 12.4% $100,830 2.8% $123,682 9.6%06 33-Housing Fund $4,422,324 $4,433,976 $2,157,088 48.6% $2,376,666 52.9% -$219,578 -4.3%06 35-Emergency Telephone Fund $768,078 $782,023 $238,844 30.5% $262,115 28.5% -$23,271 2.0% 6 t 37-Visitor's Bureau Fund $1,924,380 $1,931,018 $949,872 49.2% $1,002,204 53.1% -$52,332 -3.9%0 W 38-Spay/Neuter Fund $71,726 $96,851 $19,208 19.8% $22,908 24.5% -$3,700 -4.7%0 50-Solid Waste Enterprise Fund $11,884,383 $12,576,403 $8,765,964 69.7% $7,883,783 75.2% $882,181 -5.5%0 51-Efland Sewer Operating Fund $480 $480 $2,233 465.2% $92,865 38.4% -$90,632 426.8%07 53-Sportsplex Fund $4,025,654 $4,579,481 $1,818,196 39.7% $1,692,962 43.6% $125,234 -3.9% 70-Employee Health&Dental Fund $17,114,072 $17,114,072 $5,766,730 33.7% $5,718,895 32.0% $47,835 1.7% 29-Annual Grants Project Fund $141,464 $143,155 $85,841 60.0% $95,981 65.3% -$10,140 -5.3% 30-Multi-Year Grant Projects Fund $129,765 $538,821 $363,178 67.4% $253,977 6.0% $109,201 61.4%196 32-Multi-Year Community Development Fund $1,724,544 $1,804,547 $669,340 37.1% $348,718 8.6% $320,622 28.5%06 w 33-Housing Fund $4,422,324 $4,433,976 $2,149,541 48.5% $2,219,198 49.4% -$69,657 -0.9%i9 35-Emergency Telephone Fund $768,078 $782,023 $433,793 55.5% $448,861 47.7% -$15,068 7.8%0 8 c 37-Visitor's Bureau Fund $1,924,380 $1,931,018 $1,233,357 63.9% $985,503 52.2% $247,854 11.6%19 9 x 38-Spay/Neuter Fund $71,726 $96,851 $27,589 28.5% $28,218 29.1% -$629 -0.7%0 W 50-Solid Waste Enterprise Fund $11,884,383 $12,576,403 $5,509,920 43.8% $6,547,600 55.0% -$1,037,680 -11.2%19 51-Efland Sewer Operating Fund $480 $480 $285 59.4% $159,058 65.8% -$158,773 -6.4% 53-Sportsplex Fund $4,025,654 $4,579,481 $1,618,692 35.3% $3,940,357 63.8% -$2,321,665 -28.4%19 10 70-Employee Health&Dental Fund $17,114,072 $17,114,072 $7,344,800 42.9% $7,887,971 44.1% -$543,171 -1.2%1911 Notes: *-Actual amounts include Encumbrances. +-Based on percentage. 5-Based on timing of receipt of funds. 6-Multi Year Fund budgets only reflect budget authority authorized in current fiscal year. 7-Efland Sewer System operations transferred over the the City of Mebane starting in FY 2019-20. 8-Finance Department is reviewing material variances with affected department. 9-Reflects higher encumbrances for advertising in FY 2019-20. 10-Reflects higher encumbrances for Field House in FY 2018-19. 11-FY 2018-19 included Run Out Claims during the transition from United Health Care to Blue Cross Blue Shield.