Civic Intelligence

Substance LLC

Plan context: Substance LLC 401(K) Profit Sharing Plan

EIN 42-1522174 • Des Moines, IA • 23 filings • 4 plans

1300 WalnutSuite 201Des Moines, IA 50309-3401
Current Snapshot

Latest Year

2024

2024 Participants

28

2024 Assets

$3,583,002

2024 Contributions

$215,783

Historical Graphs

Total Assets Over Time

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

$4,334,747$2,167,374$0200120142024YearValue
$3,583,002Latest year 2024

Participants Over Time

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

30150200120142024YearValue
28Latest year 2024

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
2024128$3,583,002$215,783$7,707iApproximate average salary by contribution assumption: employee only about $192,663 at 4% or $128,442 at 6%; with 50% employer match about $128,442 at 4% or $85,628 at 6%; with 100% employer match about $96,332 at 4% or $64,221 at 6%.
Substance LLC 401(K) Profit Sharing Plan-28$3,583,002$215,783$7,707iApproximate average salary by contribution assumption: employee only about $192,663 at 4% or $128,442 at 6%; with 50% employer match about $128,442 at 4% or $85,628 at 6%; with 100% employer match about $96,332 at 4% or $64,221 at 6%.
2023127$3,634,211$196,754$7,287iApproximate average salary by contribution assumption: employee only about $182,180 at 4% or $121,453 at 6%; with 50% employer match about $121,453 at 4% or $80,969 at 6%; with 100% employer match about $91,090 at 4% or $60,727 at 6%.
Substance LLC 401(K) Profit Sharing Plan-27$3,634,211$196,754$7,287iApproximate average salary by contribution assumption: employee only about $182,180 at 4% or $121,453 at 6%; with 50% employer match about $121,453 at 4% or $80,969 at 6%; with 100% employer match about $91,090 at 4% or $60,727 at 6%.
2022127$3,450,421$194,808$7,215iApproximate average salary by contribution assumption: employee only about $180,378 at 4% or $120,252 at 6%; with 50% employer match about $120,252 at 4% or $80,168 at 6%; with 100% employer match about $90,189 at 4% or $60,126 at 6%.
Substance LLC 401(K) Profit Sharing Plan-27$3,450,421$194,808$7,215iApproximate average salary by contribution assumption: employee only about $180,378 at 4% or $120,252 at 6%; with 50% employer match about $120,252 at 4% or $80,168 at 6%; with 100% employer match about $90,189 at 4% or $60,126 at 6%.
2021130$4,334,747$255,831$8,528iApproximate average salary by contribution assumption: employee only about $213,193 at 4% or $142,128 at 6%; with 50% employer match about $142,128 at 4% or $94,752 at 6%; with 100% employer match about $106,596 at 4% or $71,064 at 6%.
Substance LLC 401(K) Profit Sharing Plan-30$4,334,747$255,831$8,528iApproximate average salary by contribution assumption: employee only about $213,193 at 4% or $142,128 at 6%; with 50% employer match about $142,128 at 4% or $94,752 at 6%; with 100% employer match about $106,596 at 4% or $71,064 at 6%.
2020129$3,642,508$253,980$8,758iApproximate average salary by contribution assumption: employee only about $218,948 at 4% or $145,966 at 6%; with 50% employer match about $145,966 at 4% or $97,310 at 6%; with 100% employer match about $109,474 at 4% or $72,983 at 6%.
Substance LLC 401(K) Profit Sharing Plan-29$3,642,508$253,980$8,758iApproximate average salary by contribution assumption: employee only about $218,948 at 4% or $145,966 at 6%; with 50% employer match about $145,966 at 4% or $97,310 at 6%; with 100% employer match about $109,474 at 4% or $72,983 at 6%.
2019128$2,850,469$337,103$12,039iApproximate average salary by contribution assumption: employee only about $300,985 at 4% or $200,657 at 6%; with 50% employer match about $200,657 at 4% or $133,771 at 6%; with 100% employer match about $150,492 at 4% or $100,328 at 6%.
Substance LLC 401(K) Profit Sharing Plan-28$2,850,469$337,103$12,039iApproximate average salary by contribution assumption: employee only about $300,985 at 4% or $200,657 at 6%; with 50% employer match about $200,657 at 4% or $133,771 at 6%; with 100% employer match about $150,492 at 4% or $100,328 at 6%.
2018125$2,091,564$198,544$7,942iApproximate average salary by contribution assumption: employee only about $198,544 at 4% or $132,363 at 6%; with 50% employer match about $132,363 at 4% or $88,242 at 6%; with 100% employer match about $99,272 at 4% or $66,181 at 6%.
Substance LLC 401(K) Profit Sharing Plan-25$2,091,564$198,544$7,942iApproximate average salary by contribution assumption: employee only about $198,544 at 4% or $132,363 at 6%; with 50% employer match about $132,363 at 4% or $88,242 at 6%; with 100% employer match about $99,272 at 4% or $66,181 at 6%.
2017127$2,151,379$214,506$7,945iApproximate average salary by contribution assumption: employee only about $198,617 at 4% or $132,411 at 6%; with 50% employer match about $132,411 at 4% or $88,274 at 6%; with 100% employer match about $99,308 at 4% or $66,206 at 6%.
Substance LLC 401(K) Profit Sharing Plan-27$2,151,379$214,506$7,945iApproximate average salary by contribution assumption: employee only about $198,617 at 4% or $132,411 at 6%; with 50% employer match about $132,411 at 4% or $88,274 at 6%; with 100% employer match about $99,308 at 4% or $66,206 at 6%.
2016124$1,903,661$216,692$9,029iApproximate average salary by contribution assumption: employee only about $225,721 at 4% or $150,481 at 6%; with 50% employer match about $150,481 at 4% or $100,320 at 6%; with 100% employer match about $112,860 at 4% or $75,240 at 6%.
Substance LLC 401(K) Profit Sharing Plan-24$1,903,661$216,692$9,029iApproximate average salary by contribution assumption: employee only about $225,721 at 4% or $150,481 at 6%; with 50% employer match about $150,481 at 4% or $100,320 at 6%; with 100% employer match about $112,860 at 4% or $75,240 at 6%.
2015126$1,645,708$196,640$7,563iApproximate average salary by contribution assumption: employee only about $189,077 at 4% or $126,051 at 6%; with 50% employer match about $126,051 at 4% or $84,034 at 6%; with 100% employer match about $94,538 at 4% or $63,026 at 6%.
Substance LLC 401(K) Profit Sharing Plan-26$1,645,708$196,640$7,563iApproximate average salary by contribution assumption: employee only about $189,077 at 4% or $126,051 at 6%; with 50% employer match about $126,051 at 4% or $84,034 at 6%; with 100% employer match about $94,538 at 4% or $63,026 at 6%.
2014125$1,526,309$191,824$7,673iApproximate average salary by contribution assumption: employee only about $191,824 at 4% or $127,883 at 6%; with 50% employer match about $127,883 at 4% or $85,255 at 6%; with 100% employer match about $95,912 at 4% or $63,941 at 6%.
Substance LLC 401(K) Profit Sharing Plan-25$1,526,309$191,824$7,673iApproximate average salary by contribution assumption: employee only about $191,824 at 4% or $127,883 at 6%; with 50% employer match about $127,883 at 4% or $85,255 at 6%; with 100% employer match about $95,912 at 4% or $63,941 at 6%.
2013123$1,286,933$172,409$7,496iApproximate average salary by contribution assumption: employee only about $187,401 at 4% or $124,934 at 6%; with 50% employer match about $124,934 at 4% or $83,289 at 6%; with 100% employer match about $93,701 at 4% or $62,467 at 6%.
Substance LLC 401(K) Profit Sharing Plan-23$1,286,933$172,409$7,496iApproximate average salary by contribution assumption: employee only about $187,401 at 4% or $124,934 at 6%; with 50% employer match about $124,934 at 4% or $83,289 at 6%; with 100% employer match about $93,701 at 4% or $62,467 at 6%.
2012121$924,763$146,466$6,975iApproximate average salary by contribution assumption: employee only about $174,364 at 4% or $116,243 at 6%; with 50% employer match about $116,243 at 4% or $77,495 at 6%; with 100% employer match about $87,182 at 4% or $58,121 at 6%.
Substance LLC 401(K) Profit Sharing Plan-21$924,763$146,466$6,975iApproximate average salary by contribution assumption: employee only about $174,364 at 4% or $116,243 at 6%; with 50% employer match about $116,243 at 4% or $77,495 at 6%; with 100% employer match about $87,182 at 4% or $58,121 at 6%.
2011118$688,043$191,608$10,645iApproximate average salary by contribution assumption: employee only about $266,122 at 4% or $177,415 at 6%; with 50% employer match about $177,415 at 4% or $118,277 at 6%; with 100% employer match about $133,061 at 4% or $88,707 at 6%.
Substance LLC 401(K) Profit Sharing Plan-18$688,043$191,608$10,645iApproximate average salary by contribution assumption: employee only about $266,122 at 4% or $177,415 at 6%; with 50% employer match about $177,415 at 4% or $118,277 at 6%; with 100% employer match about $133,061 at 4% or $88,707 at 6%.
2010113$529,397$100,904$7,762iApproximate average salary by contribution assumption: employee only about $194,046 at 4% or $129,364 at 6%; with 50% employer match about $129,364 at 4% or $86,243 at 6%; with 100% employer match about $97,023 at 4% or $64,682 at 6%.
Substance LLC 401(K) Profit Sharing Plan-13$529,397$100,904$7,762iApproximate average salary by contribution assumption: employee only about $194,046 at 4% or $129,364 at 6%; with 50% employer match about $129,364 at 4% or $86,243 at 6%; with 100% employer match about $97,023 at 4% or $64,682 at 6%.
2009112$373,939$90,756$7,563iApproximate average salary by contribution assumption: employee only about $189,075 at 4% or $126,050 at 6%; with 50% employer match about $126,050 at 4% or $84,033 at 6%; with 100% employer match about $94,538 at 4% or $63,025 at 6%.
Substance LLC 401(K) Profit Sharing Plan-12$373,939$90,756$7,563iApproximate average salary by contribution assumption: employee only about $189,075 at 4% or $126,050 at 6%; with 50% employer match about $126,050 at 4% or $84,033 at 6%; with 100% employer match about $94,538 at 4% or $63,025 at 6%.
2008113$238,017$98,351$7,565iApproximate average salary by contribution assumption: employee only about $189,137 at 4% or $126,091 at 6%; with 50% employer match about $126,091 at 4% or $84,061 at 6%; with 100% employer match about $94,568 at 4% or $63,046 at 6%.
Substance LLC 401(K) Profit Sharing Plan-13$238,017$98,351$7,565iApproximate average salary by contribution assumption: employee only about $189,137 at 4% or $126,091 at 6%; with 50% employer match about $126,091 at 4% or $84,061 at 6%; with 100% employer match about $94,568 at 4% or $63,046 at 6%.
2007115$272,550$106,242$7,083iApproximate average salary by contribution assumption: employee only about $177,070 at 4% or $118,047 at 6%; with 50% employer match about $118,047 at 4% or $78,698 at 6%; with 100% employer match about $88,535 at 4% or $59,023 at 6%.
Substance LLC 401(K) Profit Sharing Plan-15$272,550$106,242$7,083iApproximate average salary by contribution assumption: employee only about $177,070 at 4% or $118,047 at 6%; with 50% employer match about $118,047 at 4% or $78,698 at 6%; with 100% employer match about $88,535 at 4% or $59,023 at 6%.
2006113$179,645$205,022$15,771iApproximate average salary by contribution assumption: employee only about $394,273 at 4% or $262,849 at 6%; with 50% employer match about $262,849 at 4% or $175,232 at 6%; with 100% employer match about $197,137 at 4% or $131,424 at 6%.
Substance LLC 401(K) Profit Sharing Plan-13$179,645$205,022$15,771iApproximate average salary by contribution assumption: employee only about $394,273 at 4% or $262,849 at 6%; with 50% employer match about $262,849 at 4% or $175,232 at 6%; with 100% employer match about $197,137 at 4% or $131,424 at 6%.
200410$0$0-
Substance LLC 401(K) Profit Sharing Plan-0---
200313$115,633$0-
Substance LLC 401(K) Profit Sharing Plan-3$115,633--
200213$93,686$0-
Substance LLC 401(K) Profit Sharing Plan-3$93,686--
200112$106,419$102,561$51,281iApproximate average salary by contribution assumption: employee only about $1,282,013 at 4% or $854,675 at 6%; with 50% employer match about $854,675 at 4% or $569,783 at 6%; with 100% employer match about $641,006 at 4% or $427,338 at 6%.
Substance LLC 401(K) Profit Sharing Plan-2$106,419$102,561$51,281iApproximate average salary by contribution assumption: employee only about $1,282,013 at 4% or $854,675 at 6%; with 50% employer match about $854,675 at 4% or $569,783 at 6%; with 100% employer match about $641,006 at 4% or $427,338 at 6%.