HomeMy WebLinkAboutAgenda - 11-12-20; ITEM 1 - Financial Report for the First Quarter of FY 2020-21 1
ORANGE COUNTY
BOARD OF COMMISSIONERS
ACTION AGENDA ITEM ABSTRACT
Meeting Date: November 12, 2020
Action Agenda
Item No. 1
SUBJECT: Financial Report for the First Quarter of FY 2020-21
DEPARTMENT(S): Finance and Administrative
Services
ATTACHMENT(S): INFORMATION CONTACT:
Gary Donaldson, (919) 245-2453
1. Narrative: Financial Report for the Paul Laughton, (919) 245-2152
First Quarter of FY 2020-21
2. PowerPoint
PURPOSE: To provide a quarterly financial report to the BOCC and Manager on First Quarter
General Fund, Special Revenue and Enterprise Funds for the period July 1, 2020 through
September 30, 2020.
BACKGROUND: The COVID-19 induced recession resulted in County measures as part of the
FY 2020-21 Adopted Budget. This first quarter report provides a status of Revenue and
Expenditure of the County's Operating Funds as compared with the prior fiscal year. Budget
versus Actual financial analysis are a key focus to identify and report any material performance
variances.
FINANCIAL IMPACT: There is no financial impact in receiving this Financial Report.
SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to
this agenda item:
• GOAL: ENSURE ECONOMIC SELF-SUFFICIENCY
The creation and preservation of infrastructure, policies, programs and funding necessary
for residents to provide shelter, food, clothing and medical care for themselves and their
dependents.
ENVIRONMENTAL IMPACT: There is no environmental impact from approval of this action.
RECOMMENDATION(S): The Manager recommends that the Board of Commissioners receive
this Financial Report.
2
ORANGE COUNTY
NORTH CAROLINA
FINANCE and ADMINISTRATIVE SERVICES
Gary Donaldson,CTP,Chief Financial Officer I gdonaldson@orangecountync.gov I PO Box 8181, Hillsborough, NC 27278 919.245.2453
MEMORANDUM
To: Board of County Commissioners
From: Gary Donaldson, Chief Financial Officer
Date: November 12, 2020
Re: Financial Report- First Quarter FY 2020-21
This Financial Report for the First Quarter of FY 2020-21 provides Economic Outlook and Budget versus Actual
variances with comparisons to the prior fiscal year. Greater emphasis is focused on economically sensitive
revenue sources in view of the COVID-19 induced recession.
Near to Mid Term Economic Outlook
Near Term Phase 3- Executive Order 169 which eased public health restrictions represents the near term
economic prospect for governments and businesses. The Phase 3 extension will continue to be monitored in
relationship with any impact on sales tax and charges for services revenues.
Mid Term UNC-Charlotte 2021 Economic Forecast released September 23, 2020 is enclosed for your
review. UNC-Charlotte Economic Forecast the Gross State Product (GSP) at 3.6% for 2021 as compared to a
forecasted GSP of-4.5 %for 2020. The next UNC-Charlotte update is scheduled to be released December 10,
2020.
General Fund Summary(Chart on next page)
1
3
FY 2021 FY 2020 FYs 2021 vs 2020
GENERAL FUND Original Budget Revised Budget YTDActual* Percentage Original Budget Revised Budget YTD Actual* Percentage YTO %Variance'
Property Tax $167,694,880 $167,694,880 $27,769,949 16.56% $165,153,931 $165,153,931 $23,516,712 14.2491 $4,253,237 2.32%� '
Sales&Use Tax $23,827,353 $23,827,353 $0 0.00% $25,372,861 $25,372,861 $0 0.00% $0 0.00%
m Licenses and Permits $274,550 $274,550 $1,945 0.71% $313,260 $313,260 $630 0.20% $1,315 0.51%
w Charges for Services $12,645,090 $12,645,090 $2,196,872 17.37% $12,704,833 $12,704,833 $2,644,895 20.82% -$448,023 -3.44%0 t
w Intergovernmental $17,710,005 $22,515,000 $5,702,405 25.33% $18,278,612 $18,719,854 $1,557,262 8.32% $4,145,143 17.01%0 3
Transfers In $5,486,817 $5,486,817 $0 0.00% $4,034,600 $4,034,600 $0 0.00% $0 0.00%
Miscellaneous $3,139,009 $3,188,204 $216,956 6.80% $3,455,769 $3,658,827 $334,904 9.15% -$117,948 -2.35%4& 4
Appropriated Fund Balance $8,268,603 $8,268,603 $0 0.00% $7,808,006 $7,859,141 $0 0.00% $0 0.00%
Total $239,046,307 $243,900,497 $35,888,127 14.71% $237,121,872 $237,817,307 $28,054,403 11.80% $7,933,724
Community Services $14,322,250 $14,395,502 $3,296,522 22.90% $14,421,090 $14,675,219 $3,214,346 21.90% $82,176 1.00%
General Government $10,525,739 $10,719,505 $2,428,703 22.66% $10,556,767 $10,726,427 $3,313,916 30.89% -$885,213 -8.24%�
Public Safety $27,994,203 $28,142,669 $6,134,466 21.80% $26,643,096 $26,969,195 $5,731,541 21.25% $402,925 0.55%
y Human Services $41,614,328 $42,402,827 $8,198,164 19.33% $40,822,906 $41,573,165 $8,869,548 21.33% -$671,384 -2.00%0
o. Education $93,440,414 $93,440,414 $22,452,704 24.03% $93,508,573 $93,508,573 $22,404,745 23.96% $47,959 0.07%
w Support Services $12,773,209 $15,123,079 $6,169,382 40.79% $12,465,362 $11,400,650 $4,009,451 35.17% $2,159,931 5.63%0 s
Debt Service $33,410,925 $33,410,925 $18,197,238 54.46% $30,754,428 $30,754,428 $12,036,931 39.14% $6,160,307 15.33%0 s
Transfers Out $4,965,239 $6,265,576 $0 0.00% $7,949,650 $8,209,650 $0 0.00% $0 0.00%
Total $239,046,307 $243,900,497 $66,877,179 27.42% $237,221,872 $237,817,307 $59,580,478 25.05% $7,296,701 2.37%0.
Notes:
*-Actual amounts include Encumbrances.
+-Based on percentage.
1-Property tax collections are attributed to timing of taxpayer payments.
2-Charges for services decrease due to lower Detention Center bed utilization and Inspection fees due to COVID-19.
3-Intergovernmental represents CARES funds from the State.
4-Miscellaneous includes County facility lease rentals,donations and lower investment earnings.
5-Support services increase reflects$1.3 million of Non-Departmental expenditures per capita payments to the towns.
6-Debt service increase reflects the Series 2019 A and B Bonds to support the County's Capital Improvement Program.
General Fund revenues are 14.7% of budgeted revenues compared to 11.8%the prior fiscal year. The variance
is due to FY 2020-21 Intergovernmental revenues which includes $2.8 million in Round 2 CARES funds and $1.3
million in Deferred Revenues from Round 1 CARES funding from the State via the U.S. Treasury.
General Fund Revenues
• Property Tax collections are 16.5% of the total Property tax budget compared to 14.2%the prior fiscal
year; this represents a timing variance in collections. Real and personal taxes are due September 1 with
peak tax collections occurring in December prior to the assessment of penalties and interest. Assessed
Values for FY 2020-21 by statute are as of January 1, 2020. The property tax category includes real,
personal, and motor vehicle taxes.
• Motor vehicles are 29% of the Motor Vehicle budget as compared to 26% in the prior fiscal year
represents a timing variance. COVID related State legislation allowed taxpayers to delay renewing their
registrations and tax payments for five months from March through August 2020. The FY 2020-21
increase is due to accrued payments over the five month period.
• Motor vehicle taxes are payable on the vehicle renewal date and the tax is based on market value of the
vehicle. The State remits this tax to the County on a monthly basis.
2
4
• Sales Tax has a three-month revenue lag from the NC Department of Revenue (NCDOR) with the first
month of July to be received in October. Note: The County received NCDOR notification of our July Sales
Tax which is 8.2% above the July 2019 sales tax and the August Sales Tax is 4.4% above the August 2019
sales tax. The NCACC Research Center attributes the July and August 2020 sales tax performance to the
following factors:
- Online Sales Tax collections resulting from NCDOR enforcement of online retailers as consumers
increased their Internet purchases.
- Federal Stimulus spending from CARES Payroll Protection Program
- Gradual Easing of Business restrictions
Below is a three-year historical sales tax revenues and the FY 2020-21 budgeted reduction in sales tax in
response to the recession. The FY 2020-21 sales tax budget is -9% below the prior fiscal year after
factoring in the easing of public health business closures.
FY 2017-18 FY 2018-19 FY 2019-20 FY 2020-21 Budget
$25,678,025.00 $27,844,578.66 $28,126,261.22 $ 25,595,372.00
Percent Change 8.4% 1.0% -9.0%
• Charges for services are 17.4% of the budget as compared to 20.8% lower the prior fiscal year. The
decline is attributed to COVID-19 public health measures for inmate inhabitants at the County Detention
Center which reduced population and commensurate cost recovery from the Federal Government.
Aging, Animal Services and DEAPR, Planning and Inspection fees are slightly lower as well due to COVID-
19 related preventive measures.
• Miscellaneous revenue variance of 6.8% of budgeted revenues as compared to 9.1%the prior fiscal year
is due to the reclassification of$252, 411 in Aging Grants from the General Fund to the Grant Fund. The
timing of Asset Management lease rental revenues for County facilities and lower investment earnings
attributed to interest rate declines.
General Fund expenditures are 27.4% of budgeted expenditures as compared to 25% the prior fiscal year. The
variance is due to an increase in debt service payments as the County funds the County and Schools bonds.
3
5
General Fund Expenditures
• First quarter debt service represents 54.5% of total debt service as compared to 39.1% the prior fiscal
year.
• Series 2019 A and B bonds accounted for an additional $6 million in debt service. These bonds are paid
on October 1 but the bond covenants requires that payments be transferred to the bank trustee five
days prior or by September 25.
• General government represented 22.6% of total general government as compared to 30.9% the prior
fiscal year. This is a timing variance attributed to property casualty and workers compensation premium
being paid in installments as compared to upfront payments in the prior fiscal year.
• Support services represented 40.8% of total support service as compared to 35.2%the prior fiscal year.
The increase reflects $1.3 million in Round 2 CARES funds paid out of a Non-Departmental to the towns.
Retiree Health fund post-employment benefits are now paid from the General Fund this fiscal year
rather than the Health and Dental Fund in the prior fiscal year.
• The remaining Functional Leadership teams are consistent with historical spending rates and compliance
with the County's proactive measures in response to the COVID related economic crisis.
• Education appropriations are 24% of its budget as compared with 23.9% the prior fiscal year. School
appropriations are paid to both School systems by the 15t" of each month. The remaining Education
budget includes School Health and Safety Contracts, Deferred Maintenance, Durham Tech Current
Expense and Recurring Capital.
Summary of Other Funds
4
6
FY 2021 FY 2020 FYs 2021 vs 2020
OTHER FUNDS Original Budget Revised Budget YTD Actual* Percentage Original Budget Revised Budget YTDActual* Percentage YTD %Variance'
29-Annual Grants Project Fund $149,095 $149,095 $309 0.21% $141,464 $141,464 $22,360 15.81% -$22,051 -15.60%
30-Multi-Year Grant Projects Fund $631,947 $859,124 $297,630 34.64% $129,765 $427,012 $46,306 10.84% $251,324 23.80% 7
32-Multi-Year Community Development Fund $1,899,076 $2,583,376 $378,419 14.65% $1,724,544 $1,724,544 $5,655 0.33% $372,764 14.32%
m 33-Housing Fund $4,448,289 $4,577,659 $1,067,893 23.33% $4,422,324 $4,422,324 $1,180,228 26.69% -$112,335 -3.36%
35-Emergency Telephone Fund $755,471 $755,471 $125,912 16.67% $768,078 $768,078 $95,538 12.44% $30,374 4.23%6� 8
m 37-Visitor's Bureau Fund $1,621,017 $1,751,017 $195,292 11.15% $1,924,380 $1,928,580 $421,944 21.88% -$226,652 -10.73%�
38-Spay/Neuter Fund $82,350 $82,350 $11,312 13.74% $71,726 $79,021 $10,177 12.88% $1,135 0.86%
50-Solid Waste Enterprise Fund $12,092,884 $12,092,894 $1,906,537 15.77% $11,894,383 $11,884,383 $1,710,296 14.39% $196,241 1.37%0-
53-Sportsplex Fund $3,796,991 $3,796,991 $431,000 11.35% $4,025,654 $4,025,654 $928,467 23.06% -$497,467 -11.71%*
70-Employee Health&Dental Fund $14,085,214 $14,085,214 $2,643,732 18.77% $17,114,072 $17,114,072 $2,748,394 16.06% -$304,662 2.71%0
29-Annual Grants Project Fund $149,095 $149,095 $16,170 10.85% $141,464 $141,464 $46,116 32.60% -$29,946 -21.75%
30-Multi-Year Grant Projects Fund $631,947 $859,124 $150,380 17.50% $129,765 $427,012 $116,093 27.19% $34,287 -9.68%
32-Multi-Year Community Development Fund $1,899,076 $2,583,376 $1,242,408 48.09% $1,724,544 $1,724,544 $262,929 15.25% $979,479 32.85% v
33-Housing Fund $4,448,289 $4,577,659 $1,033,899 22.59% $4,422,324 $4,422,324 $1,071,048 24.22% -$37,149 -1.63%
v 35-Emergency Telephone Fund $755,471 $755,471 $397,153 52.57% $768,078 $768,078 $146,420 19.06% $250,733 33.51% 10
c 37-Visitor's Bureau Fund $1,621,017 $1,751,017 $605,721 34.59% $1,924,380 $1,928,580 $847,487 43.94% -$241,766 -9.35% "
W 38-Spay/Neuter Fund $82,350 $82,350 $7,646 9.28% $71,726 $79,021 $7,605 9.62% $41 -0.34%
50-Solid Waste Enterprise Fund $12,092,884 $12,092,894 $3,821,549 31.60% $11,894,383 $11,884,383 $4,123,318 34.70% -$301,769 -3.09%6
53-Sportsplex Fund $3,796,991 $3,796,991 $516,309 13.60% $4,025,654 $4,025,654 $901,831 22.40% -$385,522 -8.80% 12
70-Employee Health&Dental Fund $14,085,214 $14,085,214 $3,051,981 21.67% $17,114,072 $17,114,072 $3,706,465 21.66% -$654,484 0.019,
Notes:
*-Actual amounts include Encumbrances.
+-Based on percentage.
7-Multi-Year Grant includes reclassification of Carol Woods Grant from the General Fund.
8-Emergency Fund fees for two month at higher subscriber fees.
9-Community Development includes CARES spending to support Emergency Housing Assistance.
10-Emergency Telephone Fund includes$277K in encumbrances for Motorola Communications
11-Decrease spending in view of lower Occupancy Tax revenues due to COVID-19
12-Decrease spending in view of lower Sportsplex revenue due to COVID-19
Sportsplex Fund
Sportsplex revenues are 11.4% of budget as compared to 23%the prior fiscal year due to the public health
restrictions. Sportsplex expenditures are 13.6% of budget as compared to 32%the prior fiscal year. FY 2020-21
revenues are $430,999 and expenditures are $516,308 for the first quarter. FY 2019-20 revenues were
$928,467 and expenditures were $901,830 for the first quarter.
The monthly Sportsplex revenues below provides comparative trends for the past two fiscal years and FY 2020-
21 Year-To-Date Actuals and Forecasted October 2020 through June 2021 forecasted. As noted the public
health restrictions has resulted in a revised revenue estimate of$2.2 million. Sportsplex management projects
the months of December and January to peak in revenues due to ice skating activities, ice rink rentals, and a
new adult league hockey season. Sportsplex management will continue with cost containment measures in
response to the revised revenue estimates.
5
7
Sportsplex Monthly Revenues
$600,000
$500,000
$400,000
$300,000 —
$200,000
$100,000
Jul Aug Sept Oct Nov Dec Jan Feb Mar April May Jun
FY 2018-19 FY 2019-20 FY 2020-21
Visitors Bureau Fund
Visitors Bureau revenues are 11.1% of budget as compared to 22% the prior fiscal year due to the public health
restrictions. Visitors Bureau expenditures are 35% of budget as compared to 44%the prior fiscal year. FY 2020-
21 revenues are $195,292 and expenditures are $381,603 for the first quarter. FY 2019-20 revenues were
$421,962 and expenditures were $511,596 for the first quarter.
The monthly occupancy tax revenues below provides comparative trends for the past two fiscal years and FY
2020-21 Year-To-Date Actuals and Forecasted October 2020 through June 2021 forecasted. Staff has identified
contractual expenses in the amount of$327,352 to counter declining revenues however Visitors Bureau fund
balance may still be needed.
6
8
Monthly Occupancy Tax
$200,000
$180,000 -
$160,000
$140,000
$120,000
$100,000
$80,000
$60,000
$40,000
$20,000
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
FY2018-19 —FY2019-20 —FY2020-21
Solid Waste Fund
Solid Waste revenues are 15.7% of the total revenues as compared to 14.4%the prior fiscal year. The solid
waste program fee of$142 is billed as a line item on the Property Tax bill. As noted previously, peak collections
occur by the end of December. Solid waste expenditures are 31.6% of total expenditures as compared to 34.7%
the prior fiscal year.
Functional Leadership Teams by Department
Community Services-Animal Services, NC Cooperative Extension, DEAPR, Economic Development, Orange
Public Transportation, Planning and Inspections.
General Government- Board of Elections, Clerk to the Board, County Attorney, County Manager, Register of
Deeds and Tax Administration
Public Safety—Courts, Emergency Services, Criminal Justice Resource Department, and Sheriff's Office
7
9
Human Services— Department on Aging, Child Support, Housing, Human Rights, and Community Development,
Library, Public Health and Social Services
Support Services-Asset Management Services, Community Relations, Finance, Human Resources, and
Information Technology
Thanks to the Budget Division for their support in the preparation of this quarterly report.
cc: Bonnie Hammersley, County Manager
8
10
ORANGE COUNTY
NORTH CAROLINA
Financial Report- First Quarter FY 2020-21
November 12, 2020
Board of County Commissioners
11
Economic Outlook
• Near Term Phase 3- Executive Order 169 which eased public
health restrictions represents the near term economic prospect
for governments and businesses. The Phase 3 extension will
continue to be monitored in relationship with any impact on sales
tax and charges for services revenues.
• Mid Term UNC-Charlotte 2021 Economic Forecast released
September 23, 2020 is enclosed for your review. UNC-Charlotte
Economic Forecast the Gross State Product (GSP) at 3 . 6% for 2021
as compared to a forecasted GSP of -4.5 % for 2020. The next
UNC-Charlotte update is scheduled to be released December 10,
2020. --
ORANGE COUNTY
NORTH CAROLINA
12
General Fund Revenue Budget
Licenses and Permits Investment Earnings
0.1% 0.2%
Miscellaneous
Sales Tax q
Appropriated Fund
Balance
3.5%
Charges for Services
5.3%
Intergovernmental
Property
i
Transfers
2.1%
ORANGE COUNTY
NORTH CAROLINA
13
General Fund Expenditure Budget
Transfers to Other Funds Community Services
2.1% 6.0%
Support
Durham Tech(Orange Service
Campus)(3) Aw
0.3
Human Services
Public Safety
_LM Education(2) 11.7%
W�,_
(1) Includes County debt service.
(2) Includes CHCCS and OCS current expenses, debt service, short-and long-range capital, health ORANGE COUNTY
and safety contracts. NORTH CAROLINA
(3) Includes Durham Technical Community College's current and recurring capital expenses.
14
General Fund
FY 2021 FY 2020 FYs 2021 vs 2020
GENERAL FUND Original Budget Revised Budget YFDActual- Percentage OriginolSudget RewsedSudger YrDActuol• Percentage YTD %Variance,
ProperEV Tax S167,694,880 S167,694,880 S27,769,949 16.56% S16S1S3,931 S165,153,931 S23,516,712 14.24% S4,253,237 2.32%0 '
Sales&Use Tax S23,827,3S3 S23,827,3S3 SO 0.00% S2S,372,861 S25,372,861 SO 0.00% SO 0.00%
Licenses and Permits S274,5S0 S274,SS0 S1,945 0.71% S313,260 S313,260 S630 0.20% S1,315 MA
Charges for Services S12,64S,090 S12,645,090 S2,196,872 17,37% S12,704,833 S12,704,833 S2,644,895 20.82% -S448,023 -3.44% _
Intergovernmental S17,710,00S S22,S15,000 SS,702,40S 25.33� S18,278,612 S18,719,854 S1,SS7,262 8.32% S4,145,143 17.01%0 n
z Transfers In SS,486,817 SS,486,817 so 0.00:- S4,034,600 S4,034,600 So 0.00% SO 0.00%
Miscellaneous S3,139,009 S3,188,204 S216,9S6 6,80% S3.455,769 S3,6S8,827 S334,904 9.1S% -S317,948 -2.35% '
Appropriated Fund Balance S8,268,603 58.268.603 SO 0.00% 908,006 S7859,141 SO 0,00% S0 0.00%
Total $239,046X7 $243,90Q497 $35AW,127 14.71% S237,121,872 S237,817,307 $28,054,403 11.80% $7,833,724 2.92%0
Community Services S14,322,250 S14,395,502 S3,296,522 22,90% S14,421,090 S14,675,219 $3,214,346 21.90% $82,176 1.00%
General Government S10,525,739 510,719,505 S2,428,703 22,66% S10,556,767 S10,726,427 S3,313,916 30.89% -S885,213 -&24%
Public Safety S27,994,203 S28,142,669 S6,134,466 21,80% $26,643,096 S26,969,195 S5,731,541 21.25% S402,925 0.55%
Human Services S41,614,328 S42,402,827 S8,198,164 19,33% S40,822,906 S41573,165 S8,869548 21.33% -S671,384 -2.00%0
Education S93,440,414 S93,440,414 S22,452,704 24,03% S93,508573 S93508,573 S22,404,745 23,96% 547,959 0.07%
Support Services S12,773,209 S15,123,079 56,169,382 40,79% S12,465,362 S11,400,650 S4,009,451 35.17% S2,159,931 5.63%•
Debt Service S33,410,925 S33,410,925 S18,197,238 54,46% 530,754,428 S30,754,428 S12,036,931 39.14% S6,160,307 15.33%6 6
Transfers 0ut S4,965,239 S6,265,576 SO 0.00% S7949.650 S8209.650 SO 0.00% SO 0.00%
Total $239,046,3137 S243,900,497 $66,877,179 27.42% #237,121,872 $237,817,307 $59,580,478 25.05%1 $7,296,T01 Lv%je
Notes
-Actual amounts include Encumbrances,
+.Based on percentage
1-Property tax collections are attributed to tiring of taxpayer payments.
2-Charges for services decrease due to lower Detention Center bed util a cation and Inspection fees due to CDviD-19.
3.1rtergoverrmental represents CARES funds from the State.
4-M iscellaneousincludes county facility lease rentals,donations and bwer investment earnings.
5-Support services increase reflects$13 mil ion of Non Depa rtmental expenditures par capita payments to the towns,
6-Debt service increase reflects the Series 2019 A and 8 Bonds to support the County's Capital improvement Program.
ORANGE COUNTY
NORTH CAROLINA
15
PropertyTax Revenues
• Property Tax collections are 16.5% of the total Property tax budget compared to 14.2% the prior fiscal
year; this represents a timing variance in collections. Real and personal taxes are due September 1 with
peak tax collections occurring in December prior to the assessment of penalties and interest. Assessed
Values for FY 2020-21 by statute are as of January 1, 2020. The property tax category includes real,
personal, and motor vehicle taxes.
• Motor vehicles are 29% of the Motor Vehicle budget as compared to 26% in the prior fiscal year
represents a timing variance. COVID related State legislation allowed taxpayers to delay renewing their
registrations and tax payments for five months from March through August 2020. The FY 2020-21
increase is due to accrued payments over the five month period.
• Motor vehicle taxes are payable on the vehicle renewal date and the tax is based on market value of the
vehicle. The State remits this tax to the County on a monthly basis.
ORANGE COUNTY
NORTH CAROLINA
16
Sa I es Tax Reve n u es
Saes Tax has a three-month revenue lag from the NC Department of Revenue (NCDOR) with the first
month of July to be received in October. Note: The County received NCDOR notification of our July Saes
Tax which is 8.2% above the July 2019 saes tax and the August Saes Tax is 4.4% above the August 2019
sales tax. The NCACC Research Center attributes the July and August 2020 sales tax performance to the
following factors:
- Online Saes Tax co ections resulting from NCDOR enforcement of online retailers as consumers
increased their Internet purchases.
- Federal Stimulus spending from CARES Payroll Protection Program
- Gradual Easing of Business restrictions
ORANGE COUNTY
NORTH CAROLINA
17
Sales Tax Annual Trend
Below is a three-year historical sales tax revenues and the FY 2020-21 budgeted reduction in sales tax in
response to the recession. The FY 2020-21 sales tax budget is -9% below the prior fiscal year after
factoring in the easing of public health business closures.
FY 2017-18 FY 2018-19 FY 2019-20 FY 2020-21 Budget
$ 25,678,025.00 $ 27,844,578.66 $ 28,126,261.22 $ 25,595,372.00
Percent Change 8.4% 1.0% -9.0%
ORANGE COUNTY
NORTH CAROLINA
18
Other General Fund Revenues
• Charges for services are 17.4% of the budget as compared to 20.8% lower the prior fiscal year. The
decline is attributed to COVID-19 public health measures for inmate inhabitants at the County Detention
Center which reduced population and commensurate cost recovery from the Federal Government.
Aging, Animal Services and DEAPR, Planning and Inspection fees are slightly lower as well due to COVID-
19 related preventive measures.
• Miscellaneous revenue variance of 6.8% of budgeted revenues as compared to 9.1%the prior fiscal year
is due to the reclassification of$252, 411 in Aging Grants from the General Fund to the Grant Fund. The
timing of Asset Management lease rental revenues for County facilities and lower investment earnings
attributed to interest rate declines.
ORANGE COUNTY
NORTH CAROLINA
19
General Fund Expenditures
General Fund expenditures are 27.4% of budgeted expenditures as compared to 25% the
prior fiscal year, this variance is attributed to:
• Increase in debt service payments from recent School and County bonds;
• General government represented 22.6% of total general government as compared to
30.9% the prior fiscal year and is a timing variance attributed to property casualty and
workers compensation premium being paid in installments as compared to upfront
payments in the prior fiscal year.
• Support services represented 40.8% of total support service as compared to 35.2% the
prior fiscal year. Increases reflects $1.3 million in Round 2 CARES funds paid out to the
towns. Retiree Health fund post-employment benefits are now paid from the General
Fund this fiscal year rather than the Health and Dental Fund in the prior fiscal year.
• The remaining Functional Leadership teams are consistent with historical spending
rates and compliance with the County's proactive measures;
• Education appropriations are 24% of its budget as compared with 23.9% the prior fiscal
year and paid on the 15th of each month.
ORANGE COUNTY
NORTH CAROLINA
20
Other County Funds
FY 2021 FY 2020 FYs 2021 vs 2020
OTHERRiND6 Originai8udger Revised&dger YMActuo1+ Peroenroge OnginalBudger RevisedBtrdger YTOAcruof• Percenroge YTD %Variance'
29-Annual Grants Project Fund $149,095 $149,D95 $309 0.21% 5141,464 $141,464 $22,360 am -$22,051 -15.60%
30-Muti-Year Grant PrgectsFund $631,947 $859,124 $297,630 34.64% 5129,765 $427,012 S46,306 10.84% $251,324 23.80%
32-MuftFYearCommunky Development Fund $1,999,076 $2,583,376 $378,419 14.65% $1,724,544 $1,724,544 $5,655 0.33% S372,764 14.32%
■ 33-Housing Fund 54,448,289 S4,577,659 51,067,893 23.33% S4,422,324 $4,422,324 S3,180,228 26.69% -S312,335 -3.36%
a 35-Emergency Telephone Fund S755,471 5755,471 5125,912 16.67% S768,078 S768,078 595,538 12.44% 530,374 4.23%0 °
0 37-Visitor's Bureau Fund 51,621,017 S1,751,017 5195,292 11.1S% S1�24,380 51,928,580 S421,944 21.89% -5226,652 -10.73%
Me 38-SpayMeuterFund $82,350 S82,350 $11,312 13,74% $71,726 579,021 $10,177 12.88% $1,135 0.86%
SO-Sold Waste Enterprise Fund $12,092,884 $12,092,884 $1,9D6,537 15.77% $11,884,383 $11,984,393 $1,710,296 14.39% 5196,241 1.37%0
53-Sportsplec Fund S3,796,991 53,796,991 5431,000 11.35% A025,654 54,025,654 S928,467 23.06% -5497,467 -11.71%i
70-EmployeeHeafth&Dental Fund 514,085,214 S14,085,214 $2,643,732 18.77% S17,114,072 $17,114,072 S2,748,394 16.D6% -5104,562 2.71%0
29-Annual Grants Project Fund 5149,095 S349,095 S16,170 10.85% 5141,464 S141,464 546,116 32.6D% -529,946 -21.75%
30-Muti-Year Grant PrgectsFund $631,947 S859,124 $150,380 17.SO% $129,765 S427,012 $116,093 27.19% $34,287 -9,69%
32-MultFYearCornmuntyDefe4opmentFund S3,899,076 $2,583,376 51,242,409 48,09% S1,724,544 S3,724,S44 $262,929 15.25% S979,479 32.85%
g 33-Housing Fund $4,448,289 $4,577,659 $1,033,899 22.59% S4,422,324 $4,422,324 $1,071,048 24.22% -$37,149 -1.63%
a� 35-Emergency Telephone Fund $755,471 S755,471 5397,153 52.57% $768P78 $769,078 $146,420 19.D6% $250,733 33.51% 10
IL 37-YsiEor's Bureau Fund $1,621,017 $1,751,017 S605,721 34.59% 51,924,380 51,929,590 5847,487 43,94% -S241,766 -9.35% u
W 38-Spay/NeutenFund S82,350 582,350 S7,646 9.28% S71,726 579,021 $7,605 9.62% 541 -0.34%
50-Sold Waste Enterprise Fund $12,092,884 $12,D92,884 S3,821,549 31.60% $11,884A3 $11,984,393 $4,123,319 34,70% -5301,769 3.0996
53-SportsplecFund $3,796,991 53,796,991 S516,309 13.60% 54P25,554 $4,025,654 S901,831 22.40% -5385,522 -8,80%
70-Employee Health&Dental Fund 514,085,214 514,085,214 53,051,981 21.67% 517,114P72 S17,114,072 S3,706,465 21.66% -S654,484 0.01%
hbter
'-Actual amounts include Encumbrances
+-Based on percentage
7-M ulti Year Grant includes redasfiiation of Q ml Woods Grant from the General Fund
8-Emergency Fund fees for two rrcnth at higher subscriber fees
9-Community Development indudesCARES spending to support Emergency}lousing Assistance
SD-EmergencyTelephone Fund ircludes$277K in encumbrances for MGwrclaCommunications
11-Decrease spending in view of ewer Occupancy Tax revenues due to COVI D-19
12-Decrease spending in view of I ower Sportsplec revenue due to CO VI D-19
ORANGE COUNTY
NORTH CAROLINA
21
COVID Impact
Sportsplex Monthly Revenues
$600,000
$500,000
$400,000
$300,000
$200,000
$100,000
Jul Aug Sept Oct Nov Dec Jan Feb Mar April May Jun
—FY 2018-19 —FY 2019-20 —FY 2020-21
ORANGE COUNTY
NORTH CAROLINA
22
COVID Impact
Monthly Occupancy Tax
$200,000
$180,000
$160,000 -
$140,000
$120,000
$100,000
$80,000
$60,000
$40,000
$20,000
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
FY2018-19 -FY2019-20 -FY2020-21
ORANGE COUNTY
NORTH CAROLINA
23
Management Response
• Visitors Bureau Fund- Identified $329 , 000
in additional cost containment measures
• Sportsplex Fund- Initiatives include
furloughs and discretionary spending
• Second Quarter Update and monthly
monitoring of key revenue and expenses
ORANGE COUNTY
NORTH CAROLINA
24
Thank you
ORANGE COUNTY
NORTH CAROLINA