Civic Intelligence

Ed Mcgill Sole Proprietor

Plan context: Ed Mcgill Sole Proprietor 401(K) P/S Plan

EIN 42-1420360 • Clive, IA • 8 filings • 2 plans

12289 Stratford DriveClive, IA 50325
Current Snapshot

Latest Year

2021

2021 Participants

19

2021 Assets

$1,961,766

2021 Contributions

$598,004

Historical Graphs

Total Assets Over Time

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

$1,961,766$980,883$0201420182021YearValue
$1,961,766Latest year 2021

Participants Over Time

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

19100201420182021YearValue
19Latest year 2021

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
2021119$1,961,766$598,004$31,474iApproximate average salary by contribution assumption: employee only about $786,847 at 4% or $524,565 at 6%; with 50% employer match about $524,565 at 4% or $349,710 at 6%; with 100% employer match about $393,424 at 4% or $262,282 at 6%.
Ed Mcgill Sole Proprietor 401(K) P/S Plan-19$1,961,766$598,004$31,474iApproximate average salary by contribution assumption: employee only about $786,847 at 4% or $524,565 at 6%; with 50% employer match about $524,565 at 4% or $349,710 at 6%; with 100% employer match about $393,424 at 4% or $262,282 at 6%.
2020114$1,118,758$169,987$12,142iApproximate average salary by contribution assumption: employee only about $303,548 at 4% or $202,365 at 6%; with 50% employer match about $202,365 at 4% or $134,910 at 6%; with 100% employer match about $151,774 at 4% or $101,183 at 6%.
Ed Mcgill Sole Proprietor 401(K) P/S Plan-14$1,118,758$169,987$12,142iApproximate average salary by contribution assumption: employee only about $303,548 at 4% or $202,365 at 6%; with 50% employer match about $202,365 at 4% or $134,910 at 6%; with 100% employer match about $151,774 at 4% or $101,183 at 6%.
2019114$716,467$169,969$12,141iApproximate average salary by contribution assumption: employee only about $303,516 at 4% or $202,344 at 6%; with 50% employer match about $202,344 at 4% or $134,896 at 6%; with 100% employer match about $151,758 at 4% or $101,172 at 6%.
Ed Mcgill Sole Proprietor 401(K) P/S Plan-14$716,467$169,969$12,141iApproximate average salary by contribution assumption: employee only about $303,516 at 4% or $202,344 at 6%; with 50% employer match about $202,344 at 4% or $134,896 at 6%; with 100% employer match about $151,758 at 4% or $101,172 at 6%.
2018112$454,223$142,058$11,838iApproximate average salary by contribution assumption: employee only about $295,954 at 4% or $197,303 at 6%; with 50% employer match about $197,303 at 4% or $131,535 at 6%; with 100% employer match about $147,977 at 4% or $98,651 at 6%.
Ed Mcgill Sole Proprietor 401(K) P/S Plan-12$454,223$142,058$11,838iApproximate average salary by contribution assumption: employee only about $295,954 at 4% or $197,303 at 6%; with 50% employer match about $197,303 at 4% or $131,535 at 6%; with 100% employer match about $147,977 at 4% or $98,651 at 6%.
2017113$400,727$94,866$7,297iApproximate average salary by contribution assumption: employee only about $182,435 at 4% or $121,623 at 6%; with 50% employer match about $121,623 at 4% or $81,082 at 6%; with 100% employer match about $91,217 at 4% or $60,812 at 6%.
Ed Mcgill Sole Proprietor 401(K) P/S Plan-13$400,727$94,866$7,297iApproximate average salary by contribution assumption: employee only about $182,435 at 4% or $121,623 at 6%; with 50% employer match about $121,623 at 4% or $81,082 at 6%; with 100% employer match about $91,217 at 4% or $60,812 at 6%.
201618$253,881$110,817$13,852iApproximate average salary by contribution assumption: employee only about $346,303 at 4% or $230,869 at 6%; with 50% employer match about $230,869 at 4% or $153,913 at 6%; with 100% employer match about $173,152 at 4% or $115,434 at 6%.
Ed Mcgill Sole Proprietor 401(K) P/S Plan-8$253,881$110,817$13,852iApproximate average salary by contribution assumption: employee only about $346,303 at 4% or $230,869 at 6%; with 50% employer match about $230,869 at 4% or $153,913 at 6%; with 100% employer match about $173,152 at 4% or $115,434 at 6%.
201518$123,010$79,677$9,960iApproximate average salary by contribution assumption: employee only about $248,991 at 4% or $165,994 at 6%; with 50% employer match about $165,994 at 4% or $110,663 at 6%; with 100% employer match about $124,495 at 4% or $82,997 at 6%.
Ed Mcgill Sole Proprietor 401(K) P/S Plan-8$123,010$79,677$9,960iApproximate average salary by contribution assumption: employee only about $248,991 at 4% or $165,994 at 6%; with 50% employer match about $165,994 at 4% or $110,663 at 6%; with 100% employer match about $124,495 at 4% or $82,997 at 6%.
201415$54,827$53,825$10,765iApproximate average salary by contribution assumption: employee only about $269,125 at 4% or $179,417 at 6%; with 50% employer match about $179,417 at 4% or $119,611 at 6%; with 100% employer match about $134,563 at 4% or $89,708 at 6%.
Ed Mcgill Sole Proprietor 401(K) P/S Plan-5$54,827$53,825$10,765iApproximate average salary by contribution assumption: employee only about $269,125 at 4% or $179,417 at 6%; with 50% employer match about $179,417 at 4% or $119,611 at 6%; with 100% employer match about $134,563 at 4% or $89,708 at 6%.