Retirement plan

SQUIER REAL ESTATE INC 401 K PROFIT SHARING PLAN TRUST

Name: SQUIER REAL ESTATE INC - SQUIER REAL ESTATE INC 401 K PROFIT SHARING PLAN TRUST (2017) Form 5500
Creator: SQUIER REAL ESTATE INC
License: https://www.dol.gov/general/disclaim
Keywords: Form 5500, ERISA, retirement plan, SQUIER REAL ESTATE INC 401 K PROFIT SHARING PLAN TRUST, SQUIER REAL ESTATE INC

SQUIER REAL ESTATE INCEIN 55-0835338Plan #001PY 2017

5509 LANTERN GROVE LANE - ROSEVILLE, CA 957476834916-771-5444LinkedIn1-10 employeesreal estate

Prospect flagsLow returnsHigh feesLow fidelity bond

How to read this page

Total assets (EOY)

$297K

+6.3% from 2016

Total participants

0.0% from 2016

Average account balance

$148,744

+6.3% from 2016

Annual return

0.69%

+0.56 pp from 2016

Benchmarks

See 14,494 peers

Peer group

Industry53 - Real Estate and Rental and Leasing

Plan typeDefined contribution

Participants<25

Cohort14,494 peers

Snapshot2017

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

Analytics

Total assets (EOY)

Plan-year ending balance

$358K

Not enough data

1 years with asset history on file

Average account balance

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

$358K

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

$8K

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

+4.64%

Not enough data

1 years with return on file

Admin fee / account holder

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

$22335

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 codes2E2F2G2J2T3D

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

3 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.
ComplianceLow fidelity bond
Fidelity bond coverage is below the ERISA section 412 10%-of-assets minimum (capped at $500,000).

Expense breakdown

Schedule H Part II

Admin total

$25K

$25136 / participant

Other / not subdivided$25K100.0%

% of EOY assets

8.449%

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

$148,744

$232,540-36.0%

$185,117-19.6%

$147,586+0.8%

Participation rate

100.0%

82.4%+17.6pp

77.3%+22.7pp

82.8%+17.2pp

Annual return

0.69%

43.03%-42.3pp

40.50%-39.8pp

578.59%-577.9pp

Employer contribution / active EE

$4,002

$5,195-23.0%

$4,182-4.3%

$4,876-17.9%

Participant deferral / active EE

$36,750

$5,834+530.0%

$5,045+628.4%

$5,439+575.7%

Admin fee / account holder

$12,568

$10,275+22.3%

$8,159+54.0%

$10,886+15.5%

SQUIER REAL ESTATE INC 401 K PROFIT SHARING PLAN TRUST

Summary metrics

Benchmarksi

Analytics

Service providersi

Plan features & details

Opportunity flagsi

Expense breakdowni

Audit opinioni

SQUIER REAL ESTATE INC 401 K PROFIT SHARING 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