Civic Intelligence

Modern Piping Inc.

Plan context: Modern Piping Inc. Profit Sharing 401K Plan

EIN 42-0799994 • Cedar Rapids, IA • 17 filings • 5 plans

500 Walford Road SWCedar Rapids, IA 52404
Current Snapshot

Latest Year

2015

2015 Participants

74

2015 Assets

$5,133,902

2015 Contributions

$624,002

Historical Graphs

Total Assets Over Time

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

$5,133,902$2,566,951$0199920092015YearValue
$5,133,902Latest year 2015

Participants Over Time

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

74370199920072015YearValue
74Latest 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
2015174$5,133,902$624,002$8,432iApproximate average salary by contribution assumption: employee only about $210,811 at 4% or $140,541 at 6%; with 50% employer match about $140,541 at 4% or $93,694 at 6%; with 100% employer match about $105,406 at 4% or $70,270 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-74$5,133,902$624,002$8,432iApproximate average salary by contribution assumption: employee only about $210,811 at 4% or $140,541 at 6%; with 50% employer match about $140,541 at 4% or $93,694 at 6%; with 100% employer match about $105,406 at 4% or $70,270 at 6%.
2014166$4,802,227$645,638$9,782iApproximate average salary by contribution assumption: employee only about $244,560 at 4% or $163,040 at 6%; with 50% employer match about $163,040 at 4% or $108,693 at 6%; with 100% employer match about $122,280 at 4% or $81,520 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-66$4,802,227$645,638$9,782iApproximate average salary by contribution assumption: employee only about $244,560 at 4% or $163,040 at 6%; with 50% employer match about $163,040 at 4% or $108,693 at 6%; with 100% employer match about $122,280 at 4% or $81,520 at 6%.
2013147$3,923,274$1,010,574$21,502iApproximate average salary by contribution assumption: employee only about $537,539 at 4% or $358,360 at 6%; with 50% employer match about $358,360 at 4% or $238,906 at 6%; with 100% employer match about $268,770 at 4% or $179,180 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-47$3,923,274$1,010,574$21,502iApproximate average salary by contribution assumption: employee only about $537,539 at 4% or $358,360 at 6%; with 50% employer match about $358,360 at 4% or $238,906 at 6%; with 100% employer match about $268,770 at 4% or $179,180 at 6%.
2012130$2,404,156$306,938$10,231iApproximate average salary by contribution assumption: employee only about $255,782 at 4% or $170,521 at 6%; with 50% employer match about $170,521 at 4% or $113,681 at 6%; with 100% employer match about $127,891 at 4% or $85,261 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-30$2,404,156$306,938$10,231iApproximate average salary by contribution assumption: employee only about $255,782 at 4% or $170,521 at 6%; with 50% employer match about $170,521 at 4% or $113,681 at 6%; with 100% employer match about $127,891 at 4% or $85,261 at 6%.
2011125$1,828,426$250,247$10,010iApproximate average salary by contribution assumption: employee only about $250,247 at 4% or $166,831 at 6%; with 50% employer match about $166,831 at 4% or $111,221 at 6%; with 100% employer match about $125,123 at 4% or $83,416 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-25$1,828,426$250,247$10,010iApproximate average salary by contribution assumption: employee only about $250,247 at 4% or $166,831 at 6%; with 50% employer match about $166,831 at 4% or $111,221 at 6%; with 100% employer match about $125,123 at 4% or $83,416 at 6%.
2010123$1,853,175$211,411$9,192iApproximate average salary by contribution assumption: employee only about $229,795 at 4% or $153,196 at 6%; with 50% employer match about $153,196 at 4% or $102,131 at 6%; with 100% employer match about $114,897 at 4% or $76,598 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-23$1,853,175$211,411$9,192iApproximate average salary by contribution assumption: employee only about $229,795 at 4% or $153,196 at 6%; with 50% employer match about $153,196 at 4% or $102,131 at 6%; with 100% employer match about $114,897 at 4% or $76,598 at 6%.
2009119$1,399,009$182,362$9,598iApproximate average salary by contribution assumption: employee only about $239,950 at 4% or $159,967 at 6%; with 50% employer match about $159,967 at 4% or $106,644 at 6%; with 100% employer match about $119,975 at 4% or $79,983 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-19$1,399,009$182,362$9,598iApproximate average salary by contribution assumption: employee only about $239,950 at 4% or $159,967 at 6%; with 50% employer match about $159,967 at 4% or $106,644 at 6%; with 100% employer match about $119,975 at 4% or $79,983 at 6%.
2008119$862,327$160,145$8,429iApproximate average salary by contribution assumption: employee only about $210,717 at 4% or $140,478 at 6%; with 50% employer match about $140,478 at 4% or $93,652 at 6%; with 100% employer match about $105,359 at 4% or $70,239 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-19$862,327$160,145$8,429iApproximate average salary by contribution assumption: employee only about $210,717 at 4% or $140,478 at 6%; with 50% employer match about $140,478 at 4% or $93,652 at 6%; with 100% employer match about $105,359 at 4% or $70,239 at 6%.
2007121$1,233,479$163,574$7,789iApproximate average salary by contribution assumption: employee only about $194,731 at 4% or $129,821 at 6%; with 50% employer match about $129,821 at 4% or $86,547 at 6%; with 100% employer match about $97,365 at 4% or $64,910 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-21$1,233,479$163,574$7,789iApproximate average salary by contribution assumption: employee only about $194,731 at 4% or $129,821 at 6%; with 50% employer match about $129,821 at 4% or $86,547 at 6%; with 100% employer match about $97,365 at 4% or $64,910 at 6%.
2006116$985,870$106,936$6,684iApproximate average salary by contribution assumption: employee only about $167,088 at 4% or $111,392 at 6%; with 50% employer match about $111,392 at 4% or $74,261 at 6%; with 100% employer match about $83,544 at 4% or $55,696 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-16$985,870$106,936$6,684iApproximate average salary by contribution assumption: employee only about $167,088 at 4% or $111,392 at 6%; with 50% employer match about $111,392 at 4% or $74,261 at 6%; with 100% employer match about $83,544 at 4% or $55,696 at 6%.
2005116$1,102,180$18,998$1,187iApproximate average salary by contribution assumption: employee only about $29,684 at 4% or $19,790 at 6%; with 50% employer match about $19,790 at 4% or $13,193 at 6%; with 100% employer match about $14,842 at 4% or $9,895 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-16$1,102,180$18,998$1,187iApproximate average salary by contribution assumption: employee only about $29,684 at 4% or $19,790 at 6%; with 50% employer match about $19,790 at 4% or $13,193 at 6%; with 100% employer match about $14,842 at 4% or $9,895 at 6%.
2004116$1,080,853$112,113$7,007iApproximate average salary by contribution assumption: employee only about $175,177 at 4% or $116,784 at 6%; with 50% employer match about $116,784 at 4% or $77,856 at 6%; with 100% employer match about $87,588 at 4% or $58,392 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-16$1,080,853$112,113$7,007iApproximate average salary by contribution assumption: employee only about $175,177 at 4% or $116,784 at 6%; with 50% employer match about $116,784 at 4% or $77,856 at 6%; with 100% employer match about $87,588 at 4% or $58,392 at 6%.
2003118$964,031$174,856$9,714iApproximate average salary by contribution assumption: employee only about $242,856 at 4% or $161,904 at 6%; with 50% employer match about $161,904 at 4% or $107,936 at 6%; with 100% employer match about $121,428 at 4% or $80,952 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-18$964,031$174,856$9,714iApproximate average salary by contribution assumption: employee only about $242,856 at 4% or $161,904 at 6%; with 50% employer match about $161,904 at 4% or $107,936 at 6%; with 100% employer match about $121,428 at 4% or $80,952 at 6%.
2002113$0$0-
Modern Piping Inc. Profit Sharing 401K Plan-13---
2001112$0$0-
Modern Piping Inc. Profit Sharing 401K Plan-12---
2000110$0$0-
Modern Piping Inc. Profit Sharing 401K Plan-10---
199919$1,464,518$75,502$8,389iApproximate average salary by contribution assumption: employee only about $209,728 at 4% or $139,819 at 6%; with 50% employer match about $139,819 at 4% or $93,212 at 6%; with 100% employer match about $104,864 at 4% or $69,909 at 6%.
Modern Piping Inc. Profit Sharing 401K Plan-9$1,464,518$75,502$8,389iApproximate average salary by contribution assumption: employee only about $209,728 at 4% or $139,819 at 6%; with 50% employer match about $139,819 at 4% or $93,212 at 6%; with 100% employer match about $104,864 at 4% or $69,909 at 6%.