HomeMy WebLinkAboutReports - 2021.08.12 - 34773BPAS offices in Rochester, Syracuse, Utica & New York | Philadelphia & Pittsburgh, PA | Houston, TX | E. Hanover, NJ | San Juan, PR
Justin Kemmerlin, VEBA Plan Consultant |p: (713)744-3804 | 866-401-5272e: JKemmerlin@bpas.com | w: bpas.com
Solving Tomorrow's Benefit Plan Challenges Today
Retirement Plan Administration | Actuarial and Benefit Consulting Services | Collective Fund Adminstration | VEBA/HRA
Adminstration | Trust and Fiduciary Services | IRA Services
Oakland County Retirement Health Savings Plan
2021 - 2Q Report
April 1 - June 30
Oakland County Retirement Health Savings Plan
As of 06/30/2021
460112 - Oakland County Retirement Health Savings Plan
Plan Review Report Introduction
"How is your employer-sponsored trust helping employees pay for eligible medical expenses?"
A Voluntary Employees' Beneficiary Association (VEBA) allows an employer to contribute money to a tax-exempt trust on behalf of their employees. The funds in
this account can be used to help pay for eligible medical expenses through a health reimbursement arrangement (HRA). The HRA gives employees more control
over health care purchase decisions by:
- Helping pay for eligible expenses
- Giving employees online access to information and tools to monitor their account and make more informed decisions
- Providing employees the convenience of debit cards for purchases, which means no extra paperwork
- Allowing employees to receive reimbursements tax-free
Plan Sponsors and VEBA plan committees spend a tremendous amount of time devoted to employees' day-to-day matters. This includes large plan level tasks
such as compliance testing, tax form preparation and plan audit support as well as routine daily activity such as contributions, reimbursements and of course,
helping participants with daily questions concerning the Plan.
Recognizing that the ultimate goal of your VEBA/HRA Plan is to allow for tax-free accumulation of assets to be used by the participant to pay for eligible medicale
xpenses now and into retirement, it is important for Plan Sponsors and VEBA plan committees to periodically review the day-to-day activity within their Plan.For example:
- What are the most common participant questions or concerns?
- What are average participant balances within the Plan?
- How many claims are being filed and what filing methods are being utilized?
- If multiple plans are offered, how do each of the Plan' activities compare?
- Are participants taking advantage of the debit card submission availability?
This Plan Review Report will present an itemized breakdown of participant inquiries received through our call center, a breakdown of claims statistics by source
and plan type, a summary of debit card substantiation and auto adjudication rates, and the average participant balances by age and service within the Plan.
Plan Summary
$ 38,800,403 $ 16,610
Plan ID and Plan Name Ppts Plan Market Value Avg Ppt Balance
460112 - Oakland County Retirement Health Savings Plan 2336
Please note, due to whole dollar amounts used throughout for reporting purposes, some slight variance may occur due to rounding ussues.
Oakland County Retirement Health Savings Plan Plan Rate of Return
As of 06/30/2021
460112 - Oakland County Retirement Health Savings Plan
Your Plan's YTD Rate of Return as of 6/30/2021 9.37 %
As fiduciaries oversee your VEBA plan, one factor they monitor is the plan-wide rate of return -- seeking to understand how the investment decisions
of participants are driving outcomes. This report (updated quarterly) shows the average rate of return for your entire VEBA plan, along with the
breakdown of the rate of return for one year, three years and five years.. For a more detailed report showing the YTD rate of return for each
participant, please see the YTD Rate of Return Report - Participant Level under the Demographics section of the Resource Center on the plan
sponsor website.
Qtr YTD 1 Year 3 Year 5 Year
Rate of Return 5.90 % 9.37 % 29.40 % 15.51 % N/A
Please see the
YTD Rate of
Return Report -
Participant Level
in the Resource
Center for more
detailed break
down
QTR
YTD
1 Year
3 Year
5 Year
0 10 20 30 40
Oakland County Retirement Health Savings Plan Asset Summary
Asset Reconciliation
As of 06/30/2021
460112 - Oakland County Retirement Health Savings Plan
Stable Value $1,170,953.37
Bonds $255,276.43
Equities $3,035,691.91
Balanced $34,338,480.81
Employer Stock $0.00
Collective Inv Trust $0.00
Participant Loans $0.00
Insurance $0.00
Other $0.00
Stable Value 3.02%
Bonds 0.66%
Equities 7.82%
Balanced 88.5%
Employer Stock 0%
Collective Inv Trust 0%
Participant Loans 0%
Insurance 0%
Other 0%
$ 70.18 $ 126,028.88
$66.91 $ 71,716.99
$48.03 $ 141,733.01
$22.56 $ 6,855.21
$40.11 $ 15,722.82
$73.64 $ 19,240.00
$35.38 $ 2,237.36
$13.19 $ 47,773.99
$149.59 $ 1,243,646.26
$22.25 $ 31,506.15
$49.58 $ 18,935.70
$1.00 $ 0.00
$29.29 $ 125,769.96
$14.22 $ 200.46
$22.78 $ 227,547.38
$68.18 $ 641,081.96
$53.74 $ 59,841.48
$5.61 $ 13,711.51
$14.67 $ 163,925.25
$12.09 $ 20,773.11
$90.41 $ 279,429.08
$20.92 $ 2,109,484.56
$22.62 $ 3,041,637.76
$24.38 $ 3,230,251.91
$26.12 $ 3,759,844.23
$27.58 $ 6,220,858.55
Fund Name Ticker Share Price Share Balance Market Value Pct of
Total Assets Ppt Count
AMERICAN FUNDS EUROPACFIC R5E RERHX 1,795.7947 0.32% 31
AMERICAN FUNDS NW PRSPCTV R5 RNPFX 1,071.8426 0.18% 24
BLACKROCK MID-CAP GR EQUITY I CMGIX 2,950.9267 0.37% 45
BNY MELLON GLBL FIXED INCOME A DHGAX 303.8655 0.02% 2
BNY MELLON NATURAL RESOURCES I DLDRX 391.9925 0.04% 8
COHEN & STEERS REALTY SHARES CSRSX 261.2711 0.05% 12
COLUMBIA FLOATING RATE I3 CFRYX 63.2381 0.01% 1
DFA INFLATPROTECT SECUR PORTFO DIPSX 3,621.9853 0.12% 12
FIDELITY 500 INDEX INST'L PREM FXAIX 8,313.6992 3.21% 86
FIDELITY GROWTH COMPANY K6 FGKFX 1,416.0069 0.08% 13
FIDELITY INT'L INDEX INSTL PRE FSPSX 381.9221 0.05% 7
FIDELITY INV MM GOV'T PORT III FCGXX 0.0000 0.00% 0
FIDELITY SM CP IDX INSTL PREM FSSNX 4,293.9556 0.32% 41
GS INT'L SM CAP INSIGHTS INV GIRLX 14.0972 0.00% 2
JPMORGAN EQUITY INCOME R5 OIERX 9,988.9105 0.59% 36
JPMORGAN LRG CAP GROWTH JLGMX 9,402.7861 1.65% 68
MFS INT' L INTRINSIC VAL R3 MINGX 1,113.5370 0.15% 18
PGIM HIGH YIELD Z PHYZX 2,444.1192 0.04% 7
PGIM TOTAL RTRN BOND Z PDBZX 11,174.1819 0.42% 26
PIMCO INCOME A PONAX 1,718.2062 0.05% 10
T. ROWE PRICE NEW HORIZONS PRNHX 3,090.6878 0.72% 41
TIAA-CREF LIFECYCLE IDX 2020 I TLWIX 100,835.7822 5.44% 148
TIAA-CREF LIFECYCLE IDX 2025 I TLQIX 134,466.7443 7.84% 241
TIAA-CREF LIFECYCLE IDX 2030 I TLHIX 132,495.9765 8.33% 291
TIAA-CREF LIFECYCLE IDX 2035 I TLYIX 143,945.0315 9.69% 347
TIAA-CREF LIFECYCLE IDX 2040 I TLZIX 225,556.8729 16.03% 560
Total Plan Assets:
$ 38,800,402.52
Note: The default fund for your
participants is based on their
age. Each participant who does
not make fund elections will be
invested by default in the Age
Based fund.
Oakland County Retirement Health Savings Plan Asset Summary
Asset Reconciliation
As of 06/30/2021
Oakland County Retirement Health Savings Plan
continued
$ 28.39 $ 6,934,014.25
$28.68 $ 3,670,367.41
$23.04 $ 3,617,512.59
$17.79 $ 160,074.41
$12.64 $ 10,541.32
$17.30 $ 1,583,893.82
$1.00 $ 1,170,953.37
$41.83 $ 3,454.71
$49.83 $ 29,837.07
$ 38,800,402.52
Fund Name Ticker Share Price Share Balance Market Value Pct of
Total Assets Ppt Count
TIAA-CREF LIFECYCLE IDX 2045 I TLXIX 244,241.4318 17.87% 783
TIAA-CREF LIFECYCLE IDX 2050 I TLLIX 127,976.5485 9.46% 567
TIAA-CREF LIFECYCLE IDX 2055 I TTIIX 157,010.0950 9.32% 592
TIAA-CREF LIFECYCLE IDX 2060 I TVIIX 8,997.9993 0.41% 187
TIAA-CREF LIFECYCLE IDX 2065 I TFITX 833.9655 0.03% 17
TIAA-CREF LIFECYCLE IDX RET IN TRILX 91,554.5560 4.08% 117
VANGUARD FEDERAL MONEY MARKET VMFXX 1,170,953.3700 3.02% 27
VANGUARD FTSE SOCIAL INDEX ADM VFTAX 82.5894 0.01% 5
VICTORY SYCAMORE ESTAB VALUE A VETAX 598.7772 0.08% 12
Oakland County Retirement Health Savings Plan Asset Reconciliation
Quarterly Fund Activity
As of 06/30/2021
460112 - Oakland County Retirement Health Savings Plan$120,722.00 $1,670.00 $8,281.80 $0.00 $0.00 $-4,609.87 $-35.05 $126,028.88 $64,681.73 $1,617.25 $5,414.62 $0.00 $0.00 $30.16 $-26.77 $71,716.99 $127,564.14 $2,789.50 $12,439.14 $0.00 $0.00 $-1,006.77 $-53.00 $141,733.01 $6,687.04 $31.50 $70.02 $0.00 $0.00 $69.56 $-2.91 $6,855.21 $14,280.71 $349.50 $1,180.67 $0.00 $0.00 $-83.97 $-4.09 $15,722.82 $17,925.91 $261.50 $2,122.46 $0.00 $0.00 $-1,060.88 $-8.99 $19,240.00 $0.00 $0.00 $24.28 $0.00 $0.00 $2,213.38 $-0.30 $2,237.36 $46,870.92 $1,197.00 $1,481.62 $0.00 $0.00 $-1,762.51 $-13.04 $47,773.99 $1,141,925.69 $18,466.75 $97,644.56 $0.00 $0.00 $-14,021.41 $-369.33 $1,243,646.26 $31,151.82 $1,689.25 $3,891.58 $0.00 $0.00 $-5,201.87 $-24.63 $31,506.15 $17,547.36 $582.75 $926.05 $0.00 $0.00 $-113.20 $-7.26 $18,935.70 $759,556.47 $1,525.00 $7.59 $0.00 $0.00 $-761,017.69 $-71.37 $0.00 $118,143.29 $2,779.00 $4,980.28 $0.00 $0.00 $-79.71 $-52.90 $125,769.96 $3,265.05 $37.50 $190.46 $0.00 $0.00 $-3,288.64 $-3.91 $200.46 $217,755.85 $3,117.00 $13,441.74 $0.00 $0.00 $-6,692.31 $-74.90 $227,547.38 $584,615.45 $11,525.50 $51,407.78 $0.00 $0.00 $-6,257.26 $-209.51 $641,081.96 $55,000.65 $1,180.75 $3,710.13 $0.00 $0.00 $-25.17 $-24.88 $59,841.48 $13,729.41 $394.50 $392.35 $0.00 $0.00 $-796.90 $-7.85 $13,711.51 $155,549.76 $2,681.00 $4,911.03 $0.00 $0.00 $828.80 $-45.34 $163,925.25 $23,955.16 $542.50 $428.81 $0.00 $0.00 $-4,144.91 $-8.45 $20,773.11 $252,607.41 $5,124.50 $30,103.20 $0.00 $0.00 $-8,307.27 $-98.76 $279,429.08 $2,088,232.66 $30,231.25 $89,933.56 $0.00 $0.00 $-98,029.22 $-883.69 $2,109,484.56 $2,881,815.27 $69,355.00 $139,063.92 $0.00 $0.00 $-47,172.70 $-1,423.73 $3,041,637.76 $3,009,599.10 $82,787.50 $159,650.99 $0.00 $0.00 $-20,069.85 $-1,715.83 $3,230,251.91 $3,466,670.81 $112,356.25 $199,522.87 $0.00 $0.00 $-16,812.62 $-1,893.08 $3,759,844.23 $5,767,444.70 $135,159.75 $359,324.52 $0.00 $0.00 $-38,197.09 $-2,873.33 $6,220,858.55 $6,422,189.54 $155,901.25 $426,790.45 $0.00 $0.00 $-67,387.13 $-3,479.86 $6,934,014.25 $3,282,144.22 $201,437.50 $225,679.06 $0.00 $0.00 $-36,372.13 $-2,521.24 $3,670,367.41 $3,228,840.93 $238,310.00 $223,880.84 $0.00 $0.00 $-69,871.87 $-3,647.31 $3,617,512.59
Fund Name Beginning
Balance Contributions Earnings
Gain/Loss Withdrawals Loan Activity Transfers/Other Fees/Expenses Ending Balance
AMERICAN FUNDS EUROPACFIC R5E
AMERICAN FUNDS NW PRSPCTV R5
BLACKROCK MID-CAP GR EQUITY I
BNY MELLON GLBL FIXED INCOME A
BNY MELLON NATURAL RESOURCES I
COHEN & STEERS REALTY SHARES
COLUMBIA FLOATING RATE I3
DFA INFLATPROTECT SECUR PORTFO
FIDELITY 500 INDEX INST'L PREM
FIDELITY GROWTH COMPANY K6
FIDELITY INT'L INDEX INSTL PRE
FIDELITY INV MM GOV'T PORT III
FIDELITY SM CP IDX INSTL PREM
GS INT'L SM CAP INSIGHTS INV
JPMORGAN EQUITY INCOME R5
JPMORGAN LRG CAP GROWTH
MFS INT' L INTRINSIC VAL R3
PGIM HIGH YIELD Z
PGIM TOTAL RTRN BOND Z
PIMCO INCO ME AT
. ROWE PRICE NEW HORIZONS
TIAA-CREF LIFECYCLE IDX 2020 I
TIAA-CREF LIFECYCLE IDX 2025 I
TIAA-CREF LIFECYCLE IDX 2030 I
TIAA-CREF LIFECYCLE IDX 2035 I
TIAA-CREF LIFECYCLE IDX 2040 I
TIAA-CREF LIFECYCLE IDX 2045 I
TIAA-CREF LIFECYCLE IDX 2050 I
TIAA-CREF LIFECYCLE IDX 2055 I
Oakland County Retirement Health Savings Plan Asset Reconciliation
Quarterly Fund Activity
As of 06/30/2021
460112 - Oakland County Retirement Health Savings Plan
continued$47,134.44 $113,300.00 $5,440.78 $0.00 $0.00 $-5,363.70 $-437.11 $160,074.41 $3,313.95 $8,550.00 $396.32 $0.00 $0.00 $-1,662.93 $-56.02 $10,541.32 $1,575,107.44 $10,831.25 $59,538.56 $0.00 $0.00 $-60,844.18 $-739.25 $1,583,893.82 $0.00 $1,143.75 $15.38 $0.00 $0.00 $1,169,829.76 $-35.52 $1,170,953.37 $2,846.04 $372.75 $275.32 $0.00 $0.00 $-34.83 $-4.57 $3,454.71 $27,833.39 $626.50 $1,511.54 $0.00 $0.00 $-120.84 $-13.52 $29,837.07 $35,576,708.31 $1,217,925.00 $2,134,074.28 $0.00 $0.00 $-107,437.77 $-20,867.30 $38,800,402.52
Fund Name Beginning
Balance Contributions Earnings
Gain/Loss Withdrawals Loan Activity Transfers/Other Fees/Expenses Ending Balance
TIAA-CREF LIFECYCLE IDX 2060 I
TIAA-CREF LIFECYCLE IDX 2065 I
TIAA-CREF LIFECYCLE IDX RET INV
ANGUARD FEDERAL MONEY MARKETV
ANGUARD FTSE SOCIAL INDEX ADM
VICTORY SYCAMORE ESTAB VALUE A
Oakland County Retirement Health Savings Plan Look Back Report
As of 06/30/2021
460112 - Oakland County Retirement Health Savings Plan
$ 20,043,697 $ 24,979,716 $ 26,863,529 $ 38,800,403
Total Plan Balance ($)
Average Participant Balance ($)
$ 9,504 $ 10,553 $ 11,905 $ 16,224
36 months
prior
24 months
prior
12 months
prior
As of
06/30/2021
10,000,000
20,000,000
30,000,000
40,000,000
36 months
prior
24 months
prior
12 months
prior
As of
06/30/2021
8,000
10,000
12,000
14,000
16,000
18,000
Oakland County Retirement Health Savings Plan Average Balances
Balance by Age and Service Groups
As of 06/30/2021
460112 - Oakland County Retirement Health Savings Plan
Percent of Total Balance By Service
$ 3,314,395 $ 8,520 9.98 %
$11,711,202 $ 16,754 35.27 %
$9,113,226 $ 18,598 27.44 %
$6,275,997 $ 17,983 18.90 %
$2,792,887 $ 18,871 8.41 %
$33,207,706 $ 16,004 100.00 %
Age
Group Nbr of Ppts Total
Balance
Avg
Balance
Pct by
Age
<30 389
30-39 699
40-49 490
50-59 349
60+ 148
Total 2,075
Average Balances by Age Group
The balance illustrated in the "Balance by Age" table below depicts the average balances by Age Group within the Plan. For purposes of the
illustration, the 'Nbr of Ppts" (Number of Participants) includes all employess with a balance. (See Additional Criteria).
Average Balances by Length of Service
The data illustrated in the "Balance by Service" table below depicts the average balances by Service Group wthin the Plan. For purposes of the
illustration, the "Nbr of Ppts" (Number of Participants) includes all employess with a balance. (See Additional Criteria).
$ 0 $ 0 0 %
$23,335,573 $ 12,893 70.27 %
$9,480,669 $ 37,473 28.55 %
$391,464 $ 32,622 1.18 %
$33,207,706 $ 16,004 100 %
Yrs of Svc Nbr of Ppts Total Balance Avg Balance Pct by Svc
<1 0
1-9 1,810
10-19 253
20+ 12
Total 2,075
Percent of Total Balance by Age
Additional Criteria used to
calculate Averages:
The total illustrated in the
sections above may differ
from other Plan level reports
based on the following
criteria. If applicable, those
differences are accounted for
below:
-Participants not Counted
-Misc Unallocated Balances
Oakland County Retirement Health Savings Plan Plan Participation
As of 06/30/2021
460112 - Oakland County Retirement Health Savings Plan
Active 2,081 89.08% Terminated 273 11.69% Total 2,336 100%
Employees recently hired and others not reported as of 06/30/2021 are not included in the illustration below.
Active 88.40%
Terminated 11.60%
Oakland County Retirement Health Savings Plan Web Statistics
Breakdown of Web and Go Green Usage
As of 06/30/2021
460112 - Oakland County Retirement Health Savings Plan
Total Participants with a balance 2336
Count Percent
Total unique Ppt logins to the website 2 0.09 %
Total Ppts who have 'Gone Green' for Quarterly Statements 10 0.43 %
Total Ppts who have 'Gone Green' for Notices and Confirms 2,280 97.60 %
Total Ppts who have provided their e-mail address 2,321 99.36 %
BPAS strongly encourages participant
activity through the website. It allows for
mor e immediate communication. The "Go
Green" initiative to increase participant
web activity includes data for the last 3
months.
Participant Web Go Green Statistics (Quarterly)
Participant Web Activity (this does not include IVR transactions)
Encourage your
plan p articipants
to join BPAS in
helping the
environment and
Go Green
Percent to Percent Transfer 3
Investment Election Change 4
Rebalance 1