Retirement plan

THE SAVINGS PLAN FOR LILLY AFFILIATE EMPLOYEES IN PUERTO RICO

Name: LILLY DEL CARIBE, INC. - THE SAVINGS PLAN FOR LILLY AFFILIATE EMPLOYEES IN PUERTO RICO (2017) Form 5500
Creator: LILLY DEL CARIBE, INC.
License: https://www.dol.gov/general/disclaim
Keywords: Form 5500, ERISA, retirement plan, THE SAVINGS PLAN FOR LILLY AFFILIATE EMPLOYEES IN PUERTO RICO, LILLY DEL CARIBE, INC.

LILLY DEL CARIBE, INC.EIN 98-0167031Plan #004PY 2017

P.O. BOX 1198 - CAROLINA, PR 009861198787-257-5437

Other plans on this EIN

1 filing

#020Retirement-$280.5M assets

Prospect flagsLow returnsLow participation

How to read this page

Total assets (EOY)

$202.7M

-3.7% from 2016

Total participants

2,150

+13.5% from 2016

Average account balance

$124,230

-5.9% from 2016

Annual return

14.15%

+3.02 pp from 2016

Benchmarks

See 384 peers

Peer group

Industry32 - Manufacturing

Plan typeDefined contribution

Participants1,000-4,999

Cohort384 peers

Snapshot2017

Free accounts unlock saves, downloads, and 3-year history.

Analytics

Total assets (EOY)

Plan-year ending balance

$519.25M

Not enough data

1 years with asset history on file

Average account balance

Total assets / participants with a balance (line 6g)

$275K

Not enough data

1 years with per-participant data

Participants with account balance

Stacked by status: active / separated vested / retired or beneficiary. Total = line 6g.

1,888

Not enough data

1 years with headcount on file

Eligible Participants and Participation

Bars: eligible actives (line 6a). Line: derived rate = active employees with a balance / 6a.

95.9%

Not enough data

1 years with eligibility data

Contributions (total)

Employer and participant dollars contributed each year

$14.72M

Not enough data

1 years with contributions on file

Contributions per participant

Average employer and participant contribution per enrolled participant

$13K

Not enough data

1 years with per-participant contribution data

Asset flow

BOY + contributions + return - distributions = EOY

Year

Annual return

Diverging bars; negative years highlighted

+21.09%

Not enough data

1 years with return on file

Admin fee / account holder

Total admin expenses / participants with a balance (line 6g)

$121

Not enough data

1 years with admin cost on file

Asset composition

Cash / stocks / bonds / mutual funds / real estate / loans over time

Not enough data

1 years with F_SCH_H allocation on file

Free accounts unlock saves, downloads, and 3-year history.

Service providers

Top 8 by compensation

Provider	Service type	Compensation
HEWITT ASSOCIATES LLC3+ years Service code 15 · EIN 36-2235791	Recordkeeping	$63,581
BANCO POPULAR DE PUERTO RICO3+ years Service code 21 · EIN 66-0561870	Bank Trustee	$43,699
ERNST & YOUNG LLP3+ years Service code 10 · EIN 34-6565596	Accounting	$31,909
ALIGHT SOLUTIONS LLC1 year Filed as: ALIGHT SOLUTIONS Service code 15 · EIN 82-1061233	Recordkeeping	$21,601
ELI LILLY AND COMPANY3+ years Service code 14 · EIN 35-0470950	Plan Administrator	$16,174
PLANTE & MORAN, PLLC2 years Filed as: PLANTE & MORAN PLLC Service code 10 · EIN 38-1357951	Accounting	$15,781
ALIGHT SOLUTIONS LLC1 year Filed as: ALIGHT FINANCIAL SOLUTIONS, LLC Service code 33 · EIN 82-1061233	Shareholder servicing fees; Securitie...	$1,265
HEWITT ASSOCIATES LLC2 years Filed as: HEWITT FINANCIAL SERVICES LLC Service code 33 · EIN 36-3943169	Securities brokerage; Finders' fees /...	$0

Plan features & details

Pension benefit codes2E2F2G2I2K2R2S2T3C3F3H

Plan features

2E
Profit-sharing
Profit-sharing plan.
2F
ERISA section 404(c) plan
This plan or any part of it is intended to meet the conditions of 29 CFR 2550.404c-1 (shifting investment responsibility to participants).
2G
Total participant-directed account plan
Participants 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.
2I
Stock bonus
Stock bonus plan.
2K
Code section 401(m) arrangement
Employee 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.
2R
Participant-directed brokerage accounts
Participant-directed brokerage accounts provided as an investment option under the plan.
2S
Automatic enrollment
Plan provides for automatic enrollment in plan that has elective contributions deducted from payroll.
2T
Default investment account
Total or partial participant-directed account plan where plan uses a default investment account for participants who fail to direct assets in their account.
3C
Plan not intended to be qualified
A plan not intended to be qualified under Code sections 401 403 or 408.
3F
Leased employees
Plan sponsor(s) received services of leased employees as defined in Code section 414(n) during the plan year.
3H
Controlled group member
Plan sponsor(s) is (are) a member(s) of a controlled group (Code sections 414(b) (c) or (m)).

Opportunity flags

2 tripped

OpportunityLow participation
Participation rate is below 70% (account-balance holders / active employees) - enrollment or auto-enroll opportunity.
OpportunityLow returns
Annual investment return is in the bottom quintile of the peer cohort.

Expense breakdown

Schedule H Part II

Admin total

$198K

$174 / participant

Other / not subdivided$198K100.0%

% of EOY assets

0.098%

all-in expense ratio

Categories reported

0 / 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

Metric

This plan

Peer set

Industry

Size

Avg account balance

$124,230

$90,410+37.4%

$91,004+36.5%

$77,958+59.4%

Participation rate

54.4%

86.4%-32.0pp

75.6%-21.2pp

71.6%-17.2pp

Annual return

14.15%

21.34%-7.2pp

4.60%+9.6pp

20.87%-6.7pp

Employer contribution / active EE

$3,555

$3,392+4.8%

$2,456+44.8%

$2,310+53.9%

Participant deferral / active EE

$6,166

$4,816+28.0%

$3,548+73.8%

$3,537+74.3%

Admin fee / account holder

$121

$79+53.8%

$5,417-97.8%

$97+24.7%

Provider

Service type

Compensation

HEWITT ASSOCIATES LLC3+ years

Service code 15 · EIN 36-2235791

Recordkeeping

$63,581

BANCO POPULAR DE PUERTO RICO3+ years

Service code 21 · EIN 66-0561870

Bank Trustee

$43,699

ERNST & YOUNG LLP3+ years

Service code 10 · EIN 34-6565596

Accounting

$31,909

ALIGHT SOLUTIONS LLC1 year

Filed as: ALIGHT SOLUTIONS

Service code 15 · EIN 82-1061233

Recordkeeping

$21,601

ELI LILLY AND COMPANY3+ years

Service code 14 · EIN 35-0470950

Plan Administrator

$16,174

PLANTE & MORAN, PLLC2 years

Filed as: PLANTE & MORAN PLLC

Service code 10 · EIN 38-1357951

Accounting

$15,781

ALIGHT SOLUTIONS LLC1 year

Filed as: ALIGHT FINANCIAL SOLUTIONS, LLC

Service code 33 · EIN 82-1061233

Shareholder servicing fees; Securitie...

$1,265

HEWITT ASSOCIATES LLC2 years

Filed as: HEWITT FINANCIAL SERVICES LLC

Service code 33 · EIN 36-3943169

Securities brokerage; Finders' fees /...

THE SAVINGS PLAN FOR LILLY AFFILIATE EMPLOYEES IN PUERTO RICO

Summary metrics

Benchmarksi

Analytics

Service providersi

Plan features & details

Opportunity flagsi

Expense breakdowni

Audit opinioni

THE SAVINGS PLAN FOR LILLY AFFILIATE EMPLOYEES IN PUERTO RICO

Summary metrics

Benchmarksi

Analytics

Service providersi

Plan features & details

Opportunity flagsi

Expense breakdowni

Audit opinioni

Benchmarks

Service providers

Opportunity flags

Expense breakdown

Audit opinion

Benchmarks

Service providers

Opportunity flags

Expense breakdown

Audit opinion