Retirement plan
WALMART PUERTO RICO 401(K) PLAN
WALMART INC.EIN 71-0415188Plan #004PY 2022
Other plans on this EIN
2 filingsProspect flagsLow assets / participant
Filing contacts
From the Form 5500, federal recordPlan administrator signer
HOGANTAYLOR LLP PREPARER
Signed 09/12/2022
Summary metrics
Total assets (EOY)
$148.5M
-15.6% from 2017
Total participants
13,045
+1.6% from 2017
Average account balance
$14,353
-14.6% from 2017
Annual return
9.12%
-21.97 pp from 2017
Benchmarks
Peer group
Industry45 - Retail Trade
Plan typeDefined contribution
Participants>=10,000
Cohort40 peers
Snapshot2022
23
Participant deferral / active EE
$880
median $1,351
64
Employer contribution / active EE
$795
median $690
79
Participation rate
76.8%
median 37.5%
0
Avg account balance
$14,353
median $38,162
90
Admin fee / account holder
$25
median $54
95
Annual return
9.12%
median -15.91%
Overall peer rank
59of 100
59th percentileavg across 6 metrics
Analytics
2016 - 2025
Total assets (EOY)
Plan-year ending balance
$180.20M
Average account balance
Total assets / participants with a balance (line 6g)
$19K
Participants with account balance
Stacked by status: active / separated vested / retired or beneficiary. Total = line 6g.
9,532
Eligible Participants and Participation
Bars: eligible actives (line 6a). Line: derived rate = active employees with a balance / 6a.
71.9%
Contributions (total)
Employer and participant dollars contributed each year
$19.03M
Contributions per participant
Average employer and participant contribution per enrolled participant
$2K
Asset flow
BOY + contributions + return - distributions = EOY
Year
Annual return
Diverging bars; negative years highlighted
+21.05%
Admin fee / account holder
Total admin expenses / participants with a balance (line 6g)
$36
Asset composition
Cash / stocks / bonds / mutual funds / real estate / loans over time
- Mutual / pooled
- Stocks
- Bonds
- Cash
- Real estate
- Loans
Service providers
Top 2 by compensation
| Provider | Service type | Compensation |
|---|---|---|
Service code 13 · EIN 13-5674085 | Contract Administrator | $201,479 |
BANCO POPULAR DE PUERTO RICO7+ years Service code 21 · EIN 66-0561870 | Bank Trustee | $53,009 |
Top hat statement on fileNQDC
Filed February 24, 2012 (most recent of 3 filings on file)
This is a legacy paper filing. Plan administrator and contact details are recorded in the original filing, which has not been digitised into structured fields.
Plan features & details
Pension benefit codes2E2F2G2J2K2T3C3H2O
Plan features
- 2EProfit-sharingProfit-sharing plan.
- 2FERISA section 404(c) planThis plan or any part of it is intended to meet the conditions of 29 CFR 2550.404c-1 (shifting investment responsibility to participants).
- 2GTotal participant-directed account planParticipants have the opportunity to direct the investment of all of the assets allocated to their individual accounts regardless of whether 29 CFR 2550.404c-1 is intended to be met.
- 2JCode section 401(k) featureCash or deferred arrangement described in Code section 401(k) that is part of a qualified defined contribution plan under which employees may elect to defer part of their compensation or receive these amounts in cash.
- 2KCode section 401(m) arrangementEmployee contributions are allocated to separate accounts under the plan or employer contributions are based in whole or in part on employee deferrals or contributions to the plan. Not applicable to 401(k) plans with only QNECs and/or QMACs or to 403(b)(1) 403(b)(7) or 408 arrangements.
- 2OESOP other than a leveraged ESOPEmployee stock ownership plan that is not leveraged.
- 2TDefault investment accountTotal or partial participant-directed account plan where plan uses a default investment account for participants who fail to direct assets in their account.
- 3CPlan not intended to be qualifiedA plan not intended to be qualified under Code sections 401 403 or 408.
- 3HControlled group memberPlan sponsor(s) is (are) a member(s) of a controlled group (Code sections 414(b) (c) or (m)).
Opportunity flags
1 tripped
- OpportunityLow assets / participant
Assets per participant are in the bottom quintile of the peer cohort - savings-rate / match opportunity.
Expense breakdown
Schedule H Part II
Admin total
$254K
$22 / participant
- Contract admin$201K79.2%
- Other / not subdivided$53K20.8%
% of EOY assets
0.171%
all-in expense ratio
Categories reported
1 / 9
subdivided buckets used
Audit opinion
Schedule H Part III
Unqualified opinion
Auditor signed off without reservation - the cleanest possible opinion.
- Auditor firm
- ERNST & YOUNG, LLP
- Auditor EIN
- 346565596
- Audit fees
- (not subdivided)
- Opinion code
- Unqualified