Civic Intelligence

Randy Horn, D.D.S. Inc.

Plan context: Randy Horn, D.D.S. Inc. Profit Sharing Plan

EIN 94-2709331 • 17 filings • 1 plans

Current Snapshot

Latest Year

2017

2017 Participants

3

2017 Assets

$2,410,049

2017 Contributions

$5,000

Historical Graphs

Total Assets Over Time

Aggregate end-of-year assets by filing year, excluding zero-asset years

$2,410,049$1,205,025$0200120092016YearValue
$2,410,049Latest year 2016

Participants Over Time

Largest reported end-of-year plan headcount by filing year, used to avoid double-counting participants across overlapping plans

320200120092016YearValue
3Latest year 2016

Company Timeline

Year summaries and individual filings are combined here so you can stay in one place while moving across years and plan filings.

Year / FilingFilingsParticipantsAssetsContributionsContrib./Participant
201710$0$0-
Randy Horn, D.D.S. Inc. Profit Sharing Plan-0---
201613$2,410,049$5,000$1,667iApproximate average salary by contribution assumption: employee only about $41,667 at 4% or $27,778 at 6%; with 50% employer match about $27,778 at 4% or $18,519 at 6%; with 100% employer match about $20,833 at 4% or $13,889 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-3$2,410,049$5,000$1,667iApproximate average salary by contribution assumption: employee only about $41,667 at 4% or $27,778 at 6%; with 50% employer match about $27,778 at 4% or $18,519 at 6%; with 100% employer match about $20,833 at 4% or $13,889 at 6%.
201513$2,288,901$1,500$500iApproximate average salary by contribution assumption: employee only about $12,500 at 4% or $8,333 at 6%; with 50% employer match about $8,333 at 4% or $5,556 at 6%; with 100% employer match about $6,250 at 4% or $4,167 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-3$2,288,901$1,500$500iApproximate average salary by contribution assumption: employee only about $12,500 at 4% or $8,333 at 6%; with 50% employer match about $8,333 at 4% or $5,556 at 6%; with 100% employer match about $6,250 at 4% or $4,167 at 6%.
201413$2,164,821$5,500$1,833iApproximate average salary by contribution assumption: employee only about $45,833 at 4% or $30,556 at 6%; with 50% employer match about $30,556 at 4% or $20,370 at 6%; with 100% employer match about $22,917 at 4% or $15,278 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-3$2,164,821$5,500$1,833iApproximate average salary by contribution assumption: employee only about $45,833 at 4% or $30,556 at 6%; with 50% employer match about $30,556 at 4% or $20,370 at 6%; with 100% employer match about $22,917 at 4% or $15,278 at 6%.
201313$2,021,630$6,000$2,000iApproximate average salary by contribution assumption: employee only about $50,000 at 4% or $33,333 at 6%; with 50% employer match about $33,333 at 4% or $22,222 at 6%; with 100% employer match about $25,000 at 4% or $16,667 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-3$2,021,630$6,000$2,000iApproximate average salary by contribution assumption: employee only about $50,000 at 4% or $33,333 at 6%; with 50% employer match about $33,333 at 4% or $22,222 at 6%; with 100% employer match about $25,000 at 4% or $16,667 at 6%.
201213$2,089,348$10,000$3,333iApproximate average salary by contribution assumption: employee only about $83,333 at 4% or $55,556 at 6%; with 50% employer match about $55,556 at 4% or $37,037 at 6%; with 100% employer match about $41,667 at 4% or $27,778 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-3$2,089,348$10,000$3,333iApproximate average salary by contribution assumption: employee only about $83,333 at 4% or $55,556 at 6%; with 50% employer match about $55,556 at 4% or $37,037 at 6%; with 100% employer match about $41,667 at 4% or $27,778 at 6%.
201113$1,990,263$0-
Randy Horn, D.D.S. Inc. Profit Sharing Plan-3$1,990,263--
201013$1,908,847$2,000$667iApproximate average salary by contribution assumption: employee only about $16,667 at 4% or $11,111 at 6%; with 50% employer match about $11,111 at 4% or $7,407 at 6%; with 100% employer match about $8,333 at 4% or $5,556 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-3$1,908,847$2,000$667iApproximate average salary by contribution assumption: employee only about $16,667 at 4% or $11,111 at 6%; with 50% employer match about $11,111 at 4% or $7,407 at 6%; with 100% employer match about $8,333 at 4% or $5,556 at 6%.
200913$1,828,122$10,000$3,333iApproximate average salary by contribution assumption: employee only about $83,333 at 4% or $55,556 at 6%; with 50% employer match about $55,556 at 4% or $37,037 at 6%; with 100% employer match about $41,667 at 4% or $27,778 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-3$1,828,122$10,000$3,333iApproximate average salary by contribution assumption: employee only about $83,333 at 4% or $55,556 at 6%; with 50% employer match about $55,556 at 4% or $37,037 at 6%; with 100% employer match about $41,667 at 4% or $27,778 at 6%.
200813$1,726,173$20,000$6,667iApproximate average salary by contribution assumption: employee only about $166,667 at 4% or $111,111 at 6%; with 50% employer match about $111,111 at 4% or $74,074 at 6%; with 100% employer match about $83,333 at 4% or $55,556 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-3$1,726,173$20,000$6,667iApproximate average salary by contribution assumption: employee only about $166,667 at 4% or $111,111 at 6%; with 50% employer match about $111,111 at 4% or $74,074 at 6%; with 100% employer match about $83,333 at 4% or $55,556 at 6%.
200713$1,608,279$10,000$3,333iApproximate average salary by contribution assumption: employee only about $83,333 at 4% or $55,556 at 6%; with 50% employer match about $55,556 at 4% or $37,037 at 6%; with 100% employer match about $41,667 at 4% or $27,778 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-3$1,608,279$10,000$3,333iApproximate average salary by contribution assumption: employee only about $83,333 at 4% or $55,556 at 6%; with 50% employer match about $55,556 at 4% or $37,037 at 6%; with 100% employer match about $41,667 at 4% or $27,778 at 6%.
200612$1,455,032$16,000$8,000iApproximate average salary by contribution assumption: employee only about $200,000 at 4% or $133,333 at 6%; with 50% employer match about $133,333 at 4% or $88,889 at 6%; with 100% employer match about $100,000 at 4% or $66,667 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-2$1,455,032$16,000$8,000iApproximate average salary by contribution assumption: employee only about $200,000 at 4% or $133,333 at 6%; with 50% employer match about $133,333 at 4% or $88,889 at 6%; with 100% employer match about $100,000 at 4% or $66,667 at 6%.
200512$1,300,387$12,000$6,000iApproximate average salary by contribution assumption: employee only about $150,000 at 4% or $100,000 at 6%; with 50% employer match about $100,000 at 4% or $66,667 at 6%; with 100% employer match about $75,000 at 4% or $50,000 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-2$1,300,387$12,000$6,000iApproximate average salary by contribution assumption: employee only about $150,000 at 4% or $100,000 at 6%; with 50% employer match about $100,000 at 4% or $66,667 at 6%; with 100% employer match about $75,000 at 4% or $50,000 at 6%.
200412$1,157,430$0-
Randy Horn, D.D.S. Inc. Profit Sharing Plan-2$1,157,430--
200312$1,051,247$0-
Randy Horn, D.D.S. Inc. Profit Sharing Plan-2$1,051,247--
200212$949,042$0-
Randy Horn, D.D.S. Inc. Profit Sharing Plan-2$949,042--
200112$875,458$7,000$3,500iApproximate average salary by contribution assumption: employee only about $87,500 at 4% or $58,333 at 6%; with 50% employer match about $58,333 at 4% or $38,889 at 6%; with 100% employer match about $43,750 at 4% or $29,167 at 6%.
Randy Horn, D.D.S. Inc. Profit Sharing Plan-2$875,458$7,000$3,500iApproximate average salary by contribution assumption: employee only about $87,500 at 4% or $58,333 at 6%; with 50% employer match about $58,333 at 4% or $38,889 at 6%; with 100% employer match about $43,750 at 4% or $29,167 at 6%.