Retirement plan

DAN E. HORNSBY, D.D.S., P.C. 401(K) PROFIT SHARING PLAN

Name: DAN E. HORNSBY, D.D.S., P.C. - DAN E. HORNSBY, D.D.S., P.C. 401(K) PROFIT SHARING PLAN (2017) Form 5500
Creator: DAN E. HORNSBY, D.D.S., P.C.
License: https://www.dol.gov/general/disclaim
Keywords: Form 5500, ERISA, retirement plan, DAN E. HORNSBY, D.D.S., P.C. 401(K) PROFIT SHARING PLAN, DAN E. HORNSBY, D.D.S., P.C.

DAN E. HORNSBY, D.D.S., P.C.EIN 86-0849840Plan #001PY 2017

1238 W. ORANGE GROVE ROAD, STE. 102 - TUCSON, AZ 85704520-742-4128

Prospect flagsHigh fees

How to read this page

Total assets (EOY)

$1.3M

+1.8% from 2016

Total participants

0.0% from 2016

Average account balance

$219,043

+1.8% from 2016

Annual return

14.29%

+7.04 pp from 2016

Benchmarks

See 106,910 peers

Peer group

Industry62 - Health Care and Social Assistance

Plan typeDefined contribution

Participants<25

Cohort106,910 peers

Snapshot2017

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

$1.98M

Not enough data

1 years with asset history on file

Average account balance

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

$989K

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.

200.0%

Not enough data

1 years with eligibility data

Contributions (total)

Employer and participant dollars contributed each year

$76K

Not enough data

1 years with contributions on file

Contributions per participant

Average employer and participant contribution per enrolled participant

$76K

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

+2.39%

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

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

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 codes2E2J2K3D

Plan features

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

OpportunityHigh fees
Administrative expenses exceed $300 per participant per year - possible fee-review opportunity. (Recordkeeping / audit / legal; excludes investment management.)

Expense breakdown

Schedule H Part II

Admin total

$208K

$41598 / participant

Other / not subdivided$208K100.0%

% of EOY assets

15.826%

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

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

Metric

This plan

Peer set

Industry

Size

Avg account balance

$219,043

$198,466+10.4%

$170,442+28.5%

$147,584+48.4%

Participation rate

100.0%

88.0%+12.0pp

83.6%+16.4pp

82.8%+17.2pp

Annual return

14.29%

257.29%-243.0pp

205.93%-191.6pp

578.55%-564.3pp

Employer contribution / active EE

$2,289

$6,184-63.0%

$5,433-57.9%

$4,876-53.1%

Participant deferral / active EE

$6,912

$5,629+22.8%

$4,939+39.9%

$5,439+27.1%

Admin fee / account holder

$34,665

$16,852+105.7%

$13,880+149.7%

$10,885+218.5%

DAN E. HORNSBY, D.D.S., P.C. 401(K) PROFIT SHARING PLAN

Summary metrics

Benchmarksi

Analytics

Service providersi

Plan features & details

Opportunity flagsi

Expense breakdowni

Audit opinioni

DAN E. HORNSBY, D.D.S., P.C. 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