Retirement plan

COLVILLE TRIBAL ENTERPRISES CORP. RETIREMENT PLAN

Name: COLVILLE TRIBAL FEDERAL CORPORATION - COLVILLE TRIBAL ENTERPRISES CORP. RETIREMENT PLAN (2017) Form 5500
Creator: COLVILLE TRIBAL FEDERAL CORPORATION
License: https://www.dol.gov/general/disclaim
Keywords: Form 5500, ERISA, retirement plan, COLVILLE TRIBAL ENTERPRISES CORP. RETIREMENT PLAN, COLVILLE TRIBAL FEDERAL CORPORATION

COLVILLE TRIBAL FEDERAL CORPORATIONEIN 91-1523072Plan #001PY 2017

P.O. BOX 150 - NESPELEM, WA 99155509-634-2029LinkedIn201-500 employeeshospitality

Prospect flagsLow assets / participantFailed to transmit contributions

How to read this page

Total assets (EOY)

$8.1M

+17.2% from 2016

Total participants

2,118

+11.7% from 2016

Average account balance

$3,801

+4.9% from 2016

Annual return

13.60%

+4.83 pp from 2016

Benchmarks

See 808 peers

Peer group

Industry81 - Other Services (except Public Administration)

Plan typeDefined contribution

Participants250-999

Cohort808 peers

Snapshot2017

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

Analytics

Total assets (EOY)

Plan-year ending balance

$17.54M

Not enough data

1 years with asset history on file

Average account balance

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

$6K

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.

2,997

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.

92.4%

Not enough data

1 years with eligibility data

Contributions (total)

Employer and participant dollars contributed each year

$2.09M

Not enough data

1 years with contributions on file

Contributions per participant

Average employer and participant contribution per enrolled participant

$3K

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.53%

Not enough data

1 years with return on file

Admin fee / account holder

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

$13

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

Provider	Service type	Compensation
UNITED PLANNERS FINANCIAL SERVICES3+ years Filed as: UNITED PLANNERS' FINANCIAL SERVICES Service code 27 CHARLIE AUBERTIN · SCOTTSDALE, AZ 85261	Advisory (Plan)	$10,741
MATRIX TRUST COMPANY1 year Service code 19 · EIN 51-0099033	Securities Custodian	$6,233

Plan features & details

Pension benefit codes2E2G2J2K2F

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.
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.

Opportunity flags

2 tripped

OpportunityLow assets / participant
Assets per participant are in the bottom quintile of the peer cohort - savings-rate / match opportunity.
ComplianceFailed to transmit contributions
Form 5500 reported a failure to timely transmit participant contributions (Schedule H line 4a).

Expense breakdown

Schedule H Part II

Admin total

$19K

$23 / participant

Investment mgmt$11K57.4%
Other / not subdivided$8K42.6%

% of EOY assets

0.232%

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: STAUFFER & ASSOCIATES PLLC
Auditor EIN: 912003781
Audit fees: (not subdivided)
Opinion code: Unqualified

Metric

This plan

Peer set

Industry

Size

Avg account balance

$3,801

$46,100-91.8%

$86,582-95.6%

$69,631-94.5%

Participation rate

100.0%

67.2%+32.8pp

73.5%+26.5pp

70.7%+29.3pp

Annual return

13.60%

21.02%-7.4pp

965.08%-951.5pp

27571.02%-27557.4pp

Employer contribution / active EE

$862

$1,850-53.4%

$2,839-69.6%

$2,032-57.6%

Participant deferral / active EE

$596

$2,432-75.5%

$3,609-83.5%

$3,224-81.5%

Admin fee / account holder

$94-90.6%

$4,904-99.8%

$110-92.0%

Provider

Service type

Compensation

UNITED PLANNERS FINANCIAL SERVICES3+ years

Filed as: UNITED PLANNERS' FINANCIAL SERVICES

Service code 27

CHARLIE AUBERTIN · SCOTTSDALE, AZ 85261

Advisory (Plan)

$10,741

MATRIX TRUST COMPANY1 year

Service code 19 · EIN 51-0099033

Securities Custodian

$6,233

COLVILLE TRIBAL ENTERPRISES CORP. RETIREMENT PLAN

Summary metrics

Benchmarksi

Analytics

Service providersi

Plan features & details

Opportunity flagsi

Expense breakdowni

Audit opinioni

COLVILLE TRIBAL ENTERPRISES CORP. RETIREMENT PLAN

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