Civic Intelligence

Merced Pipe & Steel Inc.

Plan context: Merced Pipe & Steel Inc. Profit Sharing Plan

EIN 77-0325686 • Modesto, CA • 12 filings • 3 plans

P.O. Box 1597Modesto, CA 95353
Current Snapshot

Latest Year

2010

2010 Participants

6

2010 Assets

$103,764

2010 Contributions

$7,250

Historical Graphs

Total Assets Over Time

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

$187,212$93,606$0199920042009YearValue
$103,764Latest year 2009

Participants Over Time

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

630199920042009YearValue
6Latest year 2009

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
201010$0$0-
Merced Pipe & Steel Inc. Profit Sharing Plan-0---
200916$103,764$7,250$1,208iApproximate average salary by contribution assumption: employee only about $30,208 at 4% or $20,139 at 6%; with 50% employer match about $20,139 at 4% or $13,426 at 6%; with 100% employer match about $15,104 at 4% or $10,069 at 6%.
Merced Pipe & Steel Inc. Profit Sharing Plan-6$103,764$7,250$1,208iApproximate average salary by contribution assumption: employee only about $30,208 at 4% or $20,139 at 6%; with 50% employer match about $20,139 at 4% or $13,426 at 6%; with 100% employer match about $15,104 at 4% or $10,069 at 6%.
200815$173,743$18,000$3,600iApproximate average salary by contribution assumption: employee only about $90,000 at 4% or $60,000 at 6%; with 50% employer match about $60,000 at 4% or $40,000 at 6%; with 100% employer match about $45,000 at 4% or $30,000 at 6%.
Merced Pipe & Steel Inc. Profit Sharing Plan-5$173,743$18,000$3,600iApproximate average salary by contribution assumption: employee only about $90,000 at 4% or $60,000 at 6%; with 50% employer match about $60,000 at 4% or $40,000 at 6%; with 100% employer match about $45,000 at 4% or $30,000 at 6%.
200715$0$0-
Merced Pipe & Steel Inc. Profit Sharing Plan-5---
200615$187,212$18,000$3,600iApproximate average salary by contribution assumption: employee only about $90,000 at 4% or $60,000 at 6%; with 50% employer match about $60,000 at 4% or $40,000 at 6%; with 100% employer match about $45,000 at 4% or $30,000 at 6%.
Merced Pipe & Steel Inc. Profit Sharing Plan-5$187,212$18,000$3,600iApproximate average salary by contribution assumption: employee only about $90,000 at 4% or $60,000 at 6%; with 50% employer match about $60,000 at 4% or $40,000 at 6%; with 100% employer match about $45,000 at 4% or $30,000 at 6%.
200516$160,201$17,400$2,900iApproximate average salary by contribution assumption: employee only about $72,500 at 4% or $48,333 at 6%; with 50% employer match about $48,333 at 4% or $32,222 at 6%; with 100% employer match about $36,250 at 4% or $24,167 at 6%.
Merced Pipe & Steel Inc. Profit Sharing Plan-6$160,201$17,400$2,900iApproximate average salary by contribution assumption: employee only about $72,500 at 4% or $48,333 at 6%; with 50% employer match about $48,333 at 4% or $32,222 at 6%; with 100% employer match about $36,250 at 4% or $24,167 at 6%.
200415$134,455$17,000$3,400iApproximate average salary by contribution assumption: employee only about $85,000 at 4% or $56,667 at 6%; with 50% employer match about $56,667 at 4% or $37,778 at 6%; with 100% employer match about $42,500 at 4% or $28,333 at 6%.
Merced Pipe & Steel Inc. Profit Sharing Plan-5$134,455$17,000$3,400iApproximate average salary by contribution assumption: employee only about $85,000 at 4% or $56,667 at 6%; with 50% employer match about $56,667 at 4% or $37,778 at 6%; with 100% employer match about $42,500 at 4% or $28,333 at 6%.
200315$120,118$18,000$3,600iApproximate average salary by contribution assumption: employee only about $90,000 at 4% or $60,000 at 6%; with 50% employer match about $60,000 at 4% or $40,000 at 6%; with 100% employer match about $45,000 at 4% or $30,000 at 6%.
Merced Pipe & Steel Inc. Profit Sharing Plan-5$120,118$18,000$3,600iApproximate average salary by contribution assumption: employee only about $90,000 at 4% or $60,000 at 6%; with 50% employer match about $60,000 at 4% or $40,000 at 6%; with 100% employer match about $45,000 at 4% or $30,000 at 6%.
200215$82,488$16,000$3,200iApproximate average salary by contribution assumption: employee only about $80,000 at 4% or $53,333 at 6%; with 50% employer match about $53,333 at 4% or $35,556 at 6%; with 100% employer match about $40,000 at 4% or $26,667 at 6%.
Merced Pipe & Steel Inc. Profit Sharing Plan-5$82,488$16,000$3,200iApproximate average salary by contribution assumption: employee only about $80,000 at 4% or $53,333 at 6%; with 50% employer match about $53,333 at 4% or $35,556 at 6%; with 100% employer match about $40,000 at 4% or $26,667 at 6%.
200116$0$0-
Merced Pipe & Steel Inc. Profit Sharing Plan-6---
200016$86,500$7,500$1,250iApproximate average salary by contribution assumption: employee only about $31,250 at 4% or $20,833 at 6%; with 50% employer match about $20,833 at 4% or $13,889 at 6%; with 100% employer match about $15,625 at 4% or $10,417 at 6%.
Merced Pipe & Steel Inc. Profit Sharing Plan-6$86,500$7,500$1,250iApproximate average salary by contribution assumption: employee only about $31,250 at 4% or $20,833 at 6%; with 50% employer match about $20,833 at 4% or $13,889 at 6%; with 100% employer match about $15,625 at 4% or $10,417 at 6%.
199915$75,919$10,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%.
Merced Pipe & Steel Inc. Profit Sharing Plan-5$75,919$10,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%.