Retirement plan

SPARTAN INSURANCE AGENCY, LLC 401 K PLAN

Name: SPARTAN INSURANCE AGENCY, LLC - SPARTAN INSURANCE AGENCY, LLC 401 K PLAN (2023) Form 5500
Creator: SPARTAN INSURANCE AGENCY, LLC
License: https://www.dol.gov/general/disclaim
Keywords: Form 5500, ERISA, retirement plan, SPARTAN INSURANCE AGENCY, LLC 401 K PLAN, SPARTAN INSURANCE AGENCY, LLC

SPARTAN INSURANCE AGENCY, LLCEIN 38-3365033Plan #002PY 2023

125 SOUTH PINE RIVER - ITHACA, MI 48847800-888-2767spartancrop.comLinkedIn1-10 employeesinsurance

Other plans on this EIN

1 filing

#001Retirement-$2.1M assets

Prospect flagsLow returnsHigh fees

How to read this page

Total assets (EOY)

$1.2M

+22.3% from 2022

Total participants

0.0% from 2022

Average account balance

$143,933

+22.3% from 2022

Annual return

9.13%

+17.62 pp from 2022

Benchmarks

See 36,154 peers

Peer group

Industry52 - Finance and Insurance

Plan typeDefined contribution

Participants<25

Cohort36,154 peers

Snapshot2023

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

Analytics

Total assets (EOY)

Plan-year ending balance

$1.56M

Not enough data

1 years with asset history on file

Average account balance

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

$195K

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.

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.

100.0%

Not enough data

1 years with eligibility data

Contributions (total)

Employer and participant dollars contributed each year

$165K

Not enough data

1 years with contributions on file

Contributions per participant

Average employer and participant contribution per enrolled participant

$21K

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

+7.81%

Not enough data

1 years with return on file

Admin fee / account holder

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

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

0 years with F_SCH_H allocation on file

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

Service providers

Providers data not reported

Schedule C was not filed on this plan's most recent Form 5500, so no compensated service providers are available to display.

Plan features & details

Pension benefit codes2A2E2J3H

Plan features

2A
Age/service weighted or new comparability plan
Age/service weighted plan where allocations are based on age service or age and service; or new comparability or similar plan where allocations are based on participant classifications consisting entirely or predominantly of highly compensated employees or the plan provides an additional allocation rate on compensation above a specified threshold that exceeds the permitted disparity limits of Code section 401(l).
2E
Profit-sharing
Profit-sharing plan.
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.
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

OpportunityHigh fees
Administrative expenses exceed $300 per participant per year - possible fee-review opportunity. (Recordkeeping / audit / legal; excludes investment management.)
OpportunityLow returns
Annual investment return is in the bottom quintile of the peer cohort.

Expense breakdown

Schedule H Part II

Admin total

$35K

$3894 / participant

Other / not subdivided$35K100.0%

% of EOY assets

3.043%

all-in expense ratio

Categories reported

0 / 9

subdivided buckets used

Audit opinion

Schedule H Part III

No opinion code on file for this filing.

Auditor firm: (not reported)
Auditor EIN: -
Audit fees: (not subdivided)
Opinion code: -

Metric

This plan

Peer set

Industry

Size

Avg account balance

$143,933

$185,905-22.6%

$170,057-15.4%

$139,487+3.2%

Participation rate

77.8%

87.8%-10.0pp

87.0%-9.2pp

80.3%-2.6pp

Annual return

9.13%

60.56%-51.4pp

53.42%-44.3pp

373.84%-364.7pp

Employer contribution / active EE

$17,665

$7,597+132.5%

$6,790+160.1%

$4,755+271.5%

Participant deferral / active EE

$11,627-100.0%

$10,411-100.0%

$6,713-100.0%

Admin fee / account holder

$4,380

$15,397-71.6%

$12,826-65.8%

$11,407-61.6%

SPARTAN INSURANCE AGENCY, LLC 401 K PLAN

Summary metrics

Benchmarksi

Analytics

Service providersi

Plan features & details

Opportunity flagsi

Expense breakdowni

Audit opinioni

SPARTAN INSURANCE AGENCY, LLC 401 K 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