Retirement plan

SPAHN & ROSE LUMBER CO EMPLOYEE'S 401(K) PROFIT SHARING PLAN

Name: SPAHN & ROSE LUMBER CO. - SPAHN & ROSE LUMBER CO EMPLOYEE'S 401(K) PROFIT SHARING PLAN (2024) Form 5500
Creator: SPAHN & ROSE LUMBER CO.
License: https://www.dol.gov/general/disclaim
Keywords: Form 5500, ERISA, retirement plan, SPAHN & ROSE LUMBER CO EMPLOYEE'S 401(K) PROFIT SHARING PLAN, SPAHN & ROSE LUMBER CO.

SPAHN & ROSE LUMBER CO.EIN 42-0536450Plan #001PY 2024

1100 ROCKDALE ROAD - DUBUQUE, IA 52003563-582-3606spahnandrose.comLinkedIn201-500 employeesbuilding materials

Prospect flagsCorrective distributions

How to read this page

Total assets (EOY)

$34.3M

+16.2% from 2023

Total participants

506

-9.5% from 2023

Average account balance

$68,953

+29.1% from 2023

Annual return

14.90%

-0.10 pp from 2023

Benchmarks

See 1,308 peers

Peer group

Industry44 - Retail Trade

Plan typeDefined contribution

Participants250-999

Cohort1,308 peers

Snapshot2024

See peer percentile detail. $4.99 for your first month.

Solo adds 10-year history, peer benchmarks, provider and welfare analytics, saves, and exports. Then $34.99 a month.

Start for $4.99 See plans

Analytics

Total assets (EOY)

Plan-year ending balance

$34.27M

Not enough data

1 years with asset history on file

Average account balance

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

$69K

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.

497

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.

97.7%

Not enough data

1 years with eligibility data

Contributions (total)

Employer and participant dollars contributed each year

$3.55M

Not enough data

1 years with contributions on file

Contributions per participant

Average employer and participant contribution per enrolled participant

$9K

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

+14.90%

Not enough data

1 years with return on file

Admin fee / account holder

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

$191

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

See the 10-year trajectory. $4.99 for your first month.

Solo adds 10-year history, peer benchmarks, provider and welfare analytics, saves, and exports. Then $34.99 a month.

Start for $4.99 See plans

Service providers

Top 3 by compensation

Provider	Service type	Compensation
THE VANGUARD GROUP, INC.7 years Service code 15 · EIN 23-1945930	Recordkeeping	$53,345
GLOBAL RETIREMENT PARTNERS LLC5 years Filed as: GLOBAL RETIREMENT PARTNERS Service code 27 4340 REDWOOD HIGHWAY · SAN RAFAEL, CA 94903	Advisory (Plan)	$30,938
WELLTH ADVISORY SERVICES LLC1 year Filed as: WELLTH ADVISORY SERVICES Service code 27 · EIN 99-2539506	Advisory (Plan)	$10,874

Plan features & details

Pension benefit codes2S2E3D2G2J2K2F2T

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

ComplianceCorrective distributions
Plan reported corrective distributions (failed ADP/ACP testing).

Expense breakdown

Schedule H Part II

Admin total

$95K

$243 / participant

Investment mgmt$42K43.9%
Contract admin$53K56.1%

% of EOY assets

0.278%

all-in expense ratio

Categories reported

2 / 9

subdivided buckets used

Audit opinion

Schedule H Part III

Unqualified opinion

The auditor signed off without reservation. This is the cleanest opinion.

Auditor firm: RSM US LLP
Auditor EIN: 420714325
Audit fees: (not subdivided)
Opinion code: Unqualified

Look up a plan sponsor by EIN. Free Form 5500 search. No signup.

Metric

This plan

Peer set

Industry

Size

Avg account balance

$68,953

$54,193+27.2%

$93,654-26.4%

$77,671-11.2%

Participation rate

97.7%

63.9%+33.8pp

68.7%+29.0pp

70.6%+27.1pp

Annual return

14.90%

30.54%-15.6pp

133.34%-118.4pp

31.21%-16.3pp

Employer contribution / active EE

$5,111

$1,168+337.6%

$2,421+111.1%

$2,726+87.5%

Participant deferral / active EE

$3,953

$3,144+25.7%

$4,413-10.4%

$4,648-15.0%

Admin fee / account holder

$191

$576-66.7%

$8,282-97.7%

$430-55.5%

Provider

Service type

Compensation

THE VANGUARD GROUP, INC.7 years

Service code 15 · EIN 23-1945930

Recordkeeping

$53,345

GLOBAL RETIREMENT PARTNERS LLC5 years

Filed as: GLOBAL RETIREMENT PARTNERS

Service code 27

4340 REDWOOD HIGHWAY · SAN RAFAEL, CA 94903

Advisory (Plan)

$30,938

WELLTH ADVISORY SERVICES LLC1 year

Filed as: WELLTH ADVISORY SERVICES

Service code 27 · EIN 99-2539506

Advisory (Plan)

$10,874

SPAHN & ROSE LUMBER CO EMPLOYEE'S 401(K) PROFIT SHARING PLAN

Summary metrics

Benchmarksi

Analytics

Service providersi

Plan features & details

Opportunity flagsi

Expense breakdowni

Audit opinioni

SPAHN & ROSE LUMBER CO EMPLOYEE'S 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