HomeMy WebLinkAboutAgenda 12-12-23; 12-2 - Information Item - Memorandum Regarding Other Post-Employment Benefits Cash Flow 1
ORANGE COUNTY
NORTH CAROLINA
FINANCE and ADMINISTRATIVE SERVICES
Gary Donaldson,CTP,Chief Financial Officer I gdonaldson@orangecountync.gov I PO Box 8181, Hillsborough, NC 272781 919.245.2453
To: Board of County Commissioners
From: Gary Donaldson, Chief Financial Officer
Date: December 12, 2023
Re: Other Post-Employment Benefits Cash Flow
At the November 9, 2023, work session, our actuary firm Cavanagh MacDonald provided an overview of our
Other Post-Employment Benefits (OPEB) and our Net OPEB Liability (NOL).
There was an additional request to provide the NOL cash flow (County benefit payments for the OPEB liability).
Cavanagh MacDonald has provided additional information in the following attachment. It is important to note
that as part of the County's long-term planning, the County incorporates health-care trends information by
Arthur J. Gallagher Insurance Co. as well.
1
2
3enefit Oavmtints
Year for Total _i abi I ity
2022 a,974,566
202a 4e 179..199
2024 4o298,866
2025 40 51ao 188
2026 4e 721,876
2027 4o985,058
2028 5e 225e 664
20219 5e419e 989
20 o 5,685o aOl
20x1 5,832eO42
2oa2 6,119,494
20aa 6d aOO,978
2Oa4 6,327,304
203{5 6,483,460
2Oa6 6,56a,876
2oa8 6,988,X28
20aQ 7..116,890
2040 7,4a2,918
2041 7,.722,604,
2042 7,911,798
2a 8,059,596
2044 8,1101,272
z
2045 8,217,114
2046 8,aaO f402
2047 8,500,7a7
/-AWL
FN
11111 i I� '1' 11-ti-1 1.,Q1.IhI��'�N ill ill
Cavanaugh Macdonald -
CQNSULTING , LLC -i- -_
Ae experience and dedication Yru deserve —
E: —
Orange Count
Other Postern to ment Benefits Plan
Valuation Results as of June 30, 2022 =
GASB 74/75 Results as of
June 30, 2023 Measurement Date
November 9, 2023
wwwcavMacConsulting.com _
What Is an OPEB
➢ OPEB stands for Other Postemployment Benefits
➢ OPEB refers to benefits, other than pensions, that are paid in the period
after employment. OPEB includes:
➢ Postemployment healthcare benefits such as medical, dental, vision,
hearing, etc., whether provided through a pension plan or
separately; and
➢ Other benefits such as death benefits, life insurance, disability, long-
term care, etc., when provided separately from a pension plan.
➢ Orange County's OPEB benefits include medical, prescription drug, and
a Health Savings Account contribution.
C"01
`g`h eaa""e
What Is GASB 74 and 75? ( A)
➢ Governmental Accounting Standards Board Statement No. 74 (GASB
74) Financial reporting for OPEB p. lans (a.k.a. the Irrevocable Trust).
➢ We need 6/30 Trust information and employer amounts paid outside the
Trust annually.
➢ Some plans may need a blended discount rate developed. We call this the
Single Equivalent Interest Rate or SEIR.
➢ Effective starting with fiscal years after June 15, 2016.
➢ GASB 75: Accounting and financial reporting for employers who have
OPEB plans.
➢ Effective starting with fiscal years after June 15, 2017.
➢ Orange County receives a combined report meaning the GASB 74 and
GASB 75 information uses the same measurement date.
How Liability /
➢ Liability calculations are based on the following:
■ Provisions of the plan
■ Demographics of active and retired employees
■ Benefit costs
■ Demographic and economic assumptions
`g`h eaa""e
Basic Retirement Funding Formula OCM
0
C = Contributions
I = Investment Income
Earned on Contributions c + i B + E
B = Benefits Paid
E = Expenses (Admin Fees )
Plan Provisions
➢ Permanent employees hired on or before 6/30/2012 who retire from
Orange County and meet one of the following conditions:
■ A minimum of 10 years of service with Orange County
■ Age 65 with a minimum of 5 years of service with Orange County
■ Disabled retirement with a minimum of 5 years of service with Orange
County
➢ Permanent employees hired after 6/30/2012 who retire from Orange
County and meet one of the following conditions:
■ A minimum of 20 years of service with Orange County
■ Age 65 with a minimum of 10 years of service with Orange County
■ Disabled retirement with a minimum of 10 years of service with Orange
County
`g`h eaa""e
Active and Retired Membership
1,200
1,000
800 -
600
400 -
200
0
2018 2020 2022
❑ Actives 945 1,057 878
■ Retirees 396 431 471
9.1% annual increase for retired members since 2018; 9.3% increase for 2022.
Benefit Costs OCM
➢ If hired on or before 6/30/2012:
■ The County will contribute 100% towards the cost of medical
coverage for retirees with 10 or more years of service at retirement.
■ The County will contribute 50% towards the cost of medical
coverage for retirees age 65 and with 5-9 years of service at
retirement.
➢ If hired after 6/30/2012:
■ The County will contribute 100% towards the cost of medical
coverage for retirees with 20 or more years of service at retirement.
■ The County will contribute 50% towards the cost of medical
coverage for retirees age 65 and with 10-19 years of service at
retirement.
m $ °° ➢ Contribution to a health saving account for retirees on the high
deductible health plan.
`g`h ear° o
Actuarial Assumptions
OM
Health Care Single
Turnover Retirement Mortality Equivalent
Costs Interest Rate
Will an employee When will the How long will How much will What rate will
work long employee retire monthly benefits health care benefit payments
enough to vest and start be paid? expenses be? be discounted at
and qualify for collecting to produce the
monthly benefits? benefits? liability?
`fig`4 -A,a""e J
GASB 74/75
Healthcare Trend
1% Decrease Current 1% Increase
i 1 1 1 44
Discount Rate
1% Decrease Current 1% Increase
(2.65%) (3.65%) (4.65%)
i $120,541J871 � 1
9
�r
GASB 74/75 - Comments on •
,Changes in the Total OPEB Liability
Actuarial Concepts
Total OPEB Liability June 30, 2022 $132,737,808
Service Cost 4,123,410
Interest Cost 4,636,990
Benefit Payments (3,529,472) Service Cost is one year's worth
Actual vs. Experience Deferred Outflows/Inflows of liability for actives accruing
age and service towards benefit
Demographic Changes (5,590,403) eligiblity
Health Care Costs (10,534,054)
Actual vs. Expected Benefit Payments (510,512)
Interest Cost is one year's
Assumption Deferred Outflows/Inflows
worth of interest on the
Health Care Trend Change 1,635,621 beginning of year liability less
Single Equivalent Interest Rate Change (2,046,466) interest on benefit payments
Total OPEB Liability June 30, 2023 $120,922,922 made on based on the single
equivalent interest rate
Assumption Changes
➢ Pre-Medicare trend rates changed to 7% in 2022 decreasing to an ultimate rate of 4.5% by 2032
➢ Medicare trend rates changed to 5.125% in 2022 decreasing to an ultimate rate of 4.5% by 2025
➢ Single Equivalent Interest Rate increased from 3.54% to 3.65%
Gains/Losses
➢ Gain due to reduction in active employee counts, offset by increase in retiree counts
➢ Gain due to very small increase in Medicare rates relative to expected increases
GASB 74/75 - Collective `
Valuation Date (VD): June 30, 2022 June 30, 2020
Prior Measurement Date: June 30, 2022 June 30, 2021
Measurement Date (MD): June 30, 2023 June 30, 2022
Reporting Date (RD): June 30, 2023 June 30, 2022
Single Equivalent Interest Rate (SEIR):
Single Equivalent Interest Rate at Prior Measurement Date 3.54% 2.16%
Single Equivalent Interest Rate at Measurement Date 3.65% 3.54%
Net OPEB Liability:
Total OPEB Liability (TOL) $120,922,922 $132,737,808
Fiduciary Net Position of Irrevocable Trust (FNP) 381,73.5 363,033
Net OPEB Liability (NOL = TOL — FNP) $120,541,187 $132,374,775
FNP as a percentage of TOL 0.32% 0.27%
Collective OPEB Expense/(Income): $7,281,287 $10,851,676
Deferred Outflow of Resources: $24,420,296 $33,263,669
Deferred Inflow of Resources: $421254,407 $35,512,377
®°age �a4 rb
ii sa
o
Q'rfi nc0`
GASB 74/75 — Collective Results
,OPEB Expense
Service Cost $4,123,410
Interest Cost 4,636,990
Current-period benefit changes 0
Expensed portion of current-period difference between expected and actual experience (2,878,022)
Expensed portion of current-period difference between changes of assumptions (71,080)
Active member contributions 0
Projected earnings on plan investments (25,412)
Expensed portion of current-period differences between actual and projected earnings 1,342
Administrative Costs 0
Other 0
Recognition of beginning Deferred Outflows 8,870,567
Recognition of beginning Deferred Inflows (7,376,508)
OPEB Expense/(Income) $7,281,287
®°age �a4 rb
ii sa
o
Q'rfi �nc0"
(Gain )/Loss Analysis from1 • 2023
Fiscal Year Ending June s 2023 2022ii 2019 2018 2017
Discount Rate 3.65% 3.54% 2.16% 2.21% 3.50% 3.89% 3.57%
Total OPEB Liability (TOL) $120,922,922 $132,737,808 $161,879,726 $137,498,540 $107,019,636 $96,207,886 $96,763,784
Fiduciary Net Position (FNP) 381,735 363,033 429,766 308,196 300,941 283,778 259,918
Net OPEB Liability (NOL = TOL - FNP) $120,541,187 $132,374,775 $161,449,960 $137,190,344 $106,718,695 $95,924,108 $96,503,866
Assumptions ($410,845) ($34,822,029) ($5,075,957) $26,272,770 $6,841,423 ($5,125,557) ($9,448,990)
Actual vs. Expected Experience ($16,634,969) ($709,451) $23,633,991 ($804,583) ($793,706) $574,520 $0
Plan Investments $6,710 $96,817 ($106,160) $7,792 ($2,974) ($10,864) $0
➢ Primary drivers of the Assumption (gain)/loss are discount rate changes and
demographic assumption changes. Demographic assumptions were based on the
1/1/2010 through 12/31/2014 LGERS board experience study prior to 6/30/2021 and
the 1/1/2015 through 12/31/2019 LGERS experience study starting with the
6/30/2021 report.
➢ Primary drivers of the Actual vs. Expected Experience (gain)/loss are demographic
changes, premium changes, and benefit payment differences.
➢ Plan Investments are relatively stable except for large gain in 2021 and large loss in
2022.
`fig`4 ea'a""e
Single
➢ Single Equivalent Interest Rate (SEIR) solvency test for 2023 fiscal year
end equals the 20-year Municipal Bond Index Rate.
■ The irrevocable trust is expected to be depleted in its initial year.
■ Contributions to the irrevocable trust were $250,000 in 2017 and $0
for 2018-2023.
■ Irrevocable trust will grow nominally without contributions
relative to the liability.
➢ Around 38 employers have assets and only around 15 employers in
North Carolina have SEIR = Long Term Rate of Return (LTRoR) based
on our valuation work with around 375 employers.
Actuarial Sensitivity OM
➢ The June 30, 2020 valuation was used as the basis.
➢ The following table presents the estimated Total OPEB Liability (TOL)
as of June 30, 2021 .
TOL at 2. 16% TOL at 7.00%
Total OPEB Liability $ 161,879,726 $78,3911244
Plan Net Position $429,766 $429,766
Net OPEB Liability $161,449,960 $77,961,478
➢ The County can attain a 7/o Single Equivalent Interest Rate with a 7/0
Long Term Rate of Return (LTRoR) and annual employer contribution
equal to the Actuarial Determined Contribution (ADC). The ADC at
7/o for FY24 and FY25 is about $7.7 million.
➢ The County would need to adopt a formal funding policy including a
written agreement to make annual contributions equal to the ADC.
`g`h eaa""e
Ar�� glt6\\Q