Retirement plan
WALMART PUERTO RICO 401(K) PLAN
WALMART INC.EIN 71-0415188Plan #004PY 2018
Other plans on this EIN
3 filingsProspect flagsLow assets / participantLow participant contribution
Filing contacts
From the Form 5500, federal recordPlan administrator signer
HOGANTAYLOR LLP PREPARER
Signed 10/02/2018
Summary metrics
Total assets (EOY)
$146.8M
-15.6% from 2017
Total participants
13,787
+1.6% from 2017
Average account balance
$14,201
-14.6% from 2017
Annual return
25.55%
-21.97 pp from 2017
Benchmarks
Peer group
Industry45 - Retail Trade
Plan typeDefined contribution
Participants>=10,000
Cohort42 peers
Snapshot2018
17
Participant deferral / active EE
$524
median $941
51
Employer contribution / active EE
$480
median $429
83
Participation rate
73.2%
median 44.2%
5
Avg account balance
$14,201
median $31,756
54
Admin fee / account holder
$47
median $51
93
Annual return
25.55%
median -4.30%
Overall peer rank
50of 100
50th 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 8 by compensation
| Provider | Service type | Compensation |
|---|---|---|
Service code 13 · EIN 13-5674085 | Contract Administrator | $274,248 |
BANCO POPULAR DE PUERTO RICO3+ years Service code 21 · EIN 66-0561870 | Bank Trustee | $74,597 |
Service code 27 · EIN 94-3112180 | Advisory (Plan) | $33,560 |
WESTWOOD MANAGEMENT CORP.2 years Service code 28 · EIN 13-3160186 | Investment Management | $23,037 |
INVESCO CAPITAL MANAGEMENT3+ years Service code 28 · EIN 58-1707262 | Investment Management | $20,941 |
Service code 28 · EIN 04-2755549 | Investment Management | $18,985 |
ELK CREEK PARTNERS, LLC3+ years Service code 28 · EIN 27-5463196 | Investment Management | $18,142 |
Service code 18 · EIN 36-1561860 | Custodial (securities); Trustee (dire... | $15,731 |
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 codes2E2F2G2J2K2O2T3C3H
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
2 tripped
- OpportunityLow participant contribution
Participant contribution per participant is in the bottom quintile of the peer cohort.
- 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
$489K
$38 / participant
- Investment mgmt$124K25.4%
- Contract admin$274K56.1%
- Other / not subdivided$90K18.5%
% of EOY assets
0.333%
all-in expense ratio
Categories reported
2 / 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