Civic Intelligence

Ted Mercado

Plan context: Ted Mercado 401(K) Plan

EIN 20-4838724 • Greencastle, PA • 10 filings • 2 plans

81 Chadwick DriveGreencastle, PA 17225
Current Snapshot

Latest Year

2015

2015 Participants

4

2015 Assets

$323,817

2015 Contributions

$18,875

Historical Graphs

Total Assets Over Time

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

$323,817$161,909$0200720112015YearValue
$323,817Latest year 2015

Participants Over Time

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

530200720112015YearValue
4Latest year 2015

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
201524$323,817$18,875$4,719iApproximate average salary by contribution assumption: employee only about $117,969 at 4% or $78,646 at 6%; with 50% employer match about $78,646 at 4% or $52,431 at 6%; with 100% employer match about $58,984 at 4% or $39,323 at 6%.
Ted Mercado 401(K) Plan-4$323,817$12,524$3,131iApproximate average salary by contribution assumption: employee only about $78,275 at 4% or $52,183 at 6%; with 50% employer match about $52,183 at 4% or $34,789 at 6%; with 100% employer match about $39,138 at 4% or $26,092 at 6%.
Ted Mercado 401(K) Plan-0$0$6,351-
201415$320,623$15,967$3,193iApproximate average salary by contribution assumption: employee only about $79,835 at 4% or $53,223 at 6%; with 50% employer match about $53,223 at 4% or $35,482 at 6%; with 100% employer match about $39,918 at 4% or $26,612 at 6%.
Ted Mercado 401(K) Plan-5$320,623$15,967$3,193iApproximate average salary by contribution assumption: employee only about $79,835 at 4% or $53,223 at 6%; with 50% employer match about $53,223 at 4% or $35,482 at 6%; with 100% employer match about $39,918 at 4% or $26,612 at 6%.
201315$294,696$41,373$8,275iApproximate average salary by contribution assumption: employee only about $206,865 at 4% or $137,910 at 6%; with 50% employer match about $137,910 at 4% or $91,940 at 6%; with 100% employer match about $103,433 at 4% or $68,955 at 6%.
Ted Mercado 401(K) Plan-5$294,696$41,373$8,275iApproximate average salary by contribution assumption: employee only about $206,865 at 4% or $137,910 at 6%; with 50% employer match about $137,910 at 4% or $91,940 at 6%; with 100% employer match about $103,433 at 4% or $68,955 at 6%.
201215$198,070$35,976$7,195iApproximate average salary by contribution assumption: employee only about $179,880 at 4% or $119,920 at 6%; with 50% employer match about $119,920 at 4% or $79,947 at 6%; with 100% employer match about $89,940 at 4% or $59,960 at 6%.
Ted Mercado 401(K) Plan-5$198,070$35,976$7,195iApproximate average salary by contribution assumption: employee only about $179,880 at 4% or $119,920 at 6%; with 50% employer match about $119,920 at 4% or $79,947 at 6%; with 100% employer match about $89,940 at 4% or $59,960 at 6%.
201115$158,990$39,835$7,967iApproximate average salary by contribution assumption: employee only about $199,175 at 4% or $132,783 at 6%; with 50% employer match about $132,783 at 4% or $88,522 at 6%; with 100% employer match about $99,588 at 4% or $66,392 at 6%.
Ted Mercado 401(K) Plan-5$158,990$39,835$7,967iApproximate average salary by contribution assumption: employee only about $199,175 at 4% or $132,783 at 6%; with 50% employer match about $132,783 at 4% or $88,522 at 6%; with 100% employer match about $99,588 at 4% or $66,392 at 6%.
201015$127,281$44,757$8,951iApproximate average salary by contribution assumption: employee only about $223,785 at 4% or $149,190 at 6%; with 50% employer match about $149,190 at 4% or $99,460 at 6%; with 100% employer match about $111,893 at 4% or $74,595 at 6%.
Ted Mercado 401(K) Plan-5$127,281$44,757$8,951iApproximate average salary by contribution assumption: employee only about $223,785 at 4% or $149,190 at 6%; with 50% employer match about $149,190 at 4% or $99,460 at 6%; with 100% employer match about $111,893 at 4% or $74,595 at 6%.
200915$69,267$38,676$7,735iApproximate average salary by contribution assumption: employee only about $193,380 at 4% or $128,920 at 6%; with 50% employer match about $128,920 at 4% or $85,947 at 6%; with 100% employer match about $96,690 at 4% or $64,460 at 6%.
Ted Mercado 401(K) Plan-5$69,267$38,676$7,735iApproximate average salary by contribution assumption: employee only about $193,380 at 4% or $128,920 at 6%; with 50% employer match about $128,920 at 4% or $85,947 at 6%; with 100% employer match about $96,690 at 4% or $64,460 at 6%.
200815$16,361$17,279$3,456iApproximate average salary by contribution assumption: employee only about $86,395 at 4% or $57,597 at 6%; with 50% employer match about $57,597 at 4% or $38,398 at 6%; with 100% employer match about $43,198 at 4% or $28,798 at 6%.
Ted Mercado 401(K) Plan-5$16,361$17,279$3,456iApproximate average salary by contribution assumption: employee only about $86,395 at 4% or $57,597 at 6%; with 50% employer match about $57,597 at 4% or $38,398 at 6%; with 100% employer match about $43,198 at 4% or $28,798 at 6%.
200715$2,601$2,571$514iApproximate average salary by contribution assumption: employee only about $12,855 at 4% or $8,570 at 6%; with 50% employer match about $8,570 at 4% or $5,713 at 6%; with 100% employer match about $6,428 at 4% or $4,285 at 6%.
Ted Mercado 401(K) Plan-5$2,601$2,571$514iApproximate average salary by contribution assumption: employee only about $12,855 at 4% or $8,570 at 6%; with 50% employer match about $8,570 at 4% or $5,713 at 6%; with 100% employer match about $6,428 at 4% or $4,285 at 6%.