Retirement plan

THE PROPHET CORPORATION TAX DEFERRED SAVINGS PLAN & TRUST

Name: THE PROPHET CORPORATION - THE PROPHET CORPORATION TAX DEFERRED SAVINGS PLAN & TRUST (2017) Form 5500
Creator: THE PROPHET CORPORATION
License: https://www.dol.gov/general/disclaim
Keywords: Form 5500, ERISA, retirement plan, THE PROPHET CORPORATION TAX DEFERRED SAVINGS PLAN & TRUST, THE PROPHET CORPORATION

THE PROPHET CORPORATIONEIN 41-1362423Plan #002PY 2017

2525 LEMOND ST - OWATONNA, MN 55060507-444-1522

Prospect flagsLow assets / participant

How to read this page

Total assets (EOY)

$7.6M

+19.3% from 2016

Total participants

280

+6.1% from 2016

Average account balance

$27,454

+9.8% from 2016

Annual return

14.26%

+6.87 pp from 2016

Benchmarks

See 2,371 peers

Peer group

Industry42 - Wholesale Trade

Plan typeDefined contribution

Participants100-249

Cohort2,371 peers

Snapshot2017

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

Analytics

Total assets (EOY)

Plan-year ending balance

$10.66M

Not enough data

1 years with asset history on file

Average account balance

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

$56K

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.

192

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.

96.2%

Not enough data

1 years with eligibility data

Contributions (total)

Employer and participant dollars contributed each year

$1.09M

Not enough data

1 years with contributions on file

Contributions per participant

Average employer and participant contribution per enrolled participant

$7K

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

+13.65%

Not enough data

1 years with return on file

Admin fee / account holder

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

$309

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 3 by compensation

Provider	Service type	Compensation
WELLS FARGO BANK, N.A.3+ years Service code 15 · EIN 94-1347393	Recordkeeping	$29,690
KESTRA INVESTMENT SERVICES LLC1 year Filed as: KESTRA ADVISORY SERVICES LLC Service code 27 5707 SW PKWY BLDG 2 STE 400 · AUSTIN, TX 78735	Advisory (Plan)	$2,178
GREAT-WEST LIFE & ANNUITY INSURANCE1 year Service code 64 8515 EAST ORCHARD ROAD · GREENWOOD VILLAGE, CO 80111	Recordkeeping Fees	$151

Plan features & details

Pension benefit codes2E2F2G2J2S2T3D

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.
2J
Code section 401(k) feature
Cash 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.
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.
3D
Pre-approved pension plan
A master prototype or volume submitter plan that is the subject of a favorable opinion or advisory letter from the IRS.

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

$29K

$190 / participant

Contract admin$29K100.0%

% of EOY assets

0.386%

all-in expense ratio

Categories reported

1 / 9

subdivided buckets used

Audit opinion

Schedule H Part III

Disclaimer opinion

Auditor declined to express an opinion - usually a 103(a)(3)(C) limited-scope election.

Auditor firm: EIDE BAILLEY
Auditor EIN: 450250958
Audit fees: (not subdivided)
Opinion code: Disclaimer

Metric

This plan

Peer set

Industry

Size

Avg account balance

$27,454

$71,192-61.4%

$117,861-76.7%

$62,293-55.9%

Participation rate

97.4%

74.2%+23.2pp

79.7%+17.7pp

69.5%+27.9pp

Annual return

14.26%

18.66%-4.4pp

335.11%-320.8pp

28.90%-14.6pp

Employer contribution / active EE

$2,045

$1,934+5.8%

$3,786-46.0%

$2,042+0.2%

Participant deferral / active EE

$2,739

$3,189-14.1%

$4,482-38.9%

$3,169-13.6%

Admin fee / account holder

$106

$587-81.9%

$8,021-98.7%

$479-77.9%

Provider

Service type

Compensation

WELLS FARGO BANK, N.A.3+ years

Service code 15 · EIN 94-1347393

Recordkeeping

$29,690

KESTRA INVESTMENT SERVICES LLC1 year

Filed as: KESTRA ADVISORY SERVICES LLC

Service code 27

5707 SW PKWY BLDG 2 STE 400 · AUSTIN, TX 78735

Advisory (Plan)

$2,178

GREAT-WEST LIFE & ANNUITY INSURANCE1 year

Service code 64

8515 EAST ORCHARD ROAD · GREENWOOD VILLAGE, CO 80111

Recordkeeping Fees

$151

THE PROPHET CORPORATION TAX DEFERRED SAVINGS PLAN & TRUST

Summary metrics

Benchmarksi

Analytics

Service providersi

Plan features & details

Opportunity flagsi

Expense breakdowni

Audit opinioni

THE PROPHET CORPORATION TAX DEFERRED SAVINGS PLAN & TRUST

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