Retirement plan

COLUSA INDIAN COMMUNITY COUNCIL 401(K) PROFIT SHARING PLAN

Name: COLUSA INDIAN COMMUNITY COUNCIL - COLUSA INDIAN COMMUNITY COUNCIL 401(K) PROFIT SHARING PLAN (2023) Form 5500
Creator: COLUSA INDIAN COMMUNITY COUNCIL
License: https://www.dol.gov/general/disclaim
Keywords: Form 5500, ERISA, retirement plan, COLUSA INDIAN COMMUNITY COUNCIL 401(K) PROFIT SHARING PLAN, COLUSA INDIAN COMMUNITY COUNCIL

COLUSA INDIAN COMMUNITY COUNCILEIN 68-0259444Plan #001PY 2023

3730 HIGHWAY 45 - COLUSA, CA 95932530-458-8231colusa-nsn.govLinkedIn51-200 employeesgovernment relations

Prospect flagsFailed to transmit contributions

How to read this page

Total assets (EOY)

$11.2M

+19.4% from 2022

Total participants

241

+7.1% from 2022

Average account balance

$48,597

+16.3% from 2022

Annual return

16.71%

+28.17 pp from 2022

Benchmarks

See 6,234 peers

Peer group

Industry54 - Professional, Scientific, and Technical Services

Plan typeDefined contribution

Participants100-249

Cohort6,234 peers

Snapshot2023

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

Analytics

Total assets (EOY)

Plan-year ending balance

$12.71M

Not enough data

1 years with asset history on file

Average account balance

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

$49K

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.

262

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

Not enough data

1 years with eligibility data

Contributions (total)

Employer and participant dollars contributed each year

$1.39M

Not enough data

1 years with contributions on file

Contributions per participant

Average employer and participant contribution per enrolled participant

$8K

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

+10.93%

Not enough data

1 years with return on file

Admin fee / account holder

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

$250

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
RYAN WEALTH MANAGEMENT8 years Service code 27 · EIN 20-3860544	Advisory (Plan)	$39,839
BUCKINGHAM STRATEGIC PARTNERS4 years Filed as: BUCKINGHAM STRATEGIC PARTNERS, LLC Service code 27 · EIN 16-1728260	Advisory (Plan)	$11,925

Plan features & details

Pension benefit codes2E2F2G2J2S3D3F3H

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

1 tripped

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

$56K

$313 / participant

Recordkeeping$3K6.1%
Investment mgmt$52K91.9%
Contract admin$1K2.0%

% of EOY assets

0.504%

all-in expense ratio

Categories reported

3 / 9

subdivided buckets used

Audit opinion

Schedule H Part III

Unqualified opinion

Auditor signed off without reservation - the cleanest possible opinion.

Auditor firm: BLUEBIRD, CPAS
Auditor EIN: 261571066
Audit fees: (not subdivided)
Opinion code: Unqualified

Metric

This plan

Peer set

Industry

Size

Avg account balance

$48,597

$91,424-46.8%

$135,942-64.3%

$71,495-32.0%

Participation rate

93.9%

75.7%+18.2pp

81.9%+12.0pp

67.9%+26.0pp

Annual return

16.71%

29.90%-13.2pp

68.28%-51.6pp

28.85%-12.1pp

Employer contribution / active EE

$2,718

$3,704-26.6%

$4,858-44.0%

$2,589+5.0%

Participant deferral / active EE

$4,676

$7,092-34.1%

$7,759-39.7%

$4,291+9.0%

Admin fee / account holder

$245

$1,266-80.7%

$10,764-97.7%

$1,588-84.6%

Provider

Service type

Compensation

RYAN WEALTH MANAGEMENT8 years

Service code 27 · EIN 20-3860544

Advisory (Plan)

$39,839

BUCKINGHAM STRATEGIC PARTNERS4 years

Filed as: BUCKINGHAM STRATEGIC PARTNERS, LLC

Service code 27 · EIN 16-1728260

Advisory (Plan)

$11,925

COLUSA INDIAN COMMUNITY COUNCIL 401(K) PROFIT SHARING PLAN

Summary metrics

Benchmarksi

Analytics

Service providersi

Plan features & details

Opportunity flagsi

Expense breakdowni

Audit opinioni

COLUSA INDIAN COMMUNITY COUNCIL 401(K) PROFIT SHARING 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