Civic Intelligence

2Nd Spark Consulting LLC

Plan context: 2ND SPARK CONSULTING LLC 401(K) PROFIT SHARING PLAN

EIN 27-0815311 • Ambler, PA • 20 filings • 5 plans

14 E. Butler Avenue, Suite 202Ambler, PA 19002
Current Snapshot

Latest Year

2024

2024 Participants

27

2024 Assets

$2,601,107

2024 Contributions

$429,946

Historical Graphs

Total Assets Over Time

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

$2,601,107$1,300,554$0201020172024YearValue
$2,601,107Latest year 2024

Participants Over Time

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

27140201020172024YearValue
27Latest 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
2024127$2,601,107$429,946$15,924iApproximate average salary by contribution assumption: employee only about $398,098 at 4% or $265,399 at 6%; with 50% employer match about $265,399 at 4% or $176,933 at 6%; with 100% employer match about $199,049 at 4% or $132,699 at 6%.
2ND SPARK CONSULTING LLC 401(K) PROFIT SHARING PLAN-27$2,601,107$429,946$15,924iApproximate average salary by contribution assumption: employee only about $398,098 at 4% or $265,399 at 6%; with 50% employer match about $265,399 at 4% or $176,933 at 6%; with 100% employer match about $199,049 at 4% or $132,699 at 6%.
2023122$1,961,852$618,075$28,094iApproximate average salary by contribution assumption: employee only about $702,358 at 4% or $468,239 at 6%; with 50% employer match about $468,239 at 4% or $312,159 at 6%; with 100% employer match about $351,179 at 4% or $234,119 at 6%.
2ND SPARK CONSULTING LLC 401(K) PROFIT SHARING PLAN-22$1,961,852$618,075$28,094iApproximate average salary by contribution assumption: employee only about $702,358 at 4% or $468,239 at 6%; with 50% employer match about $468,239 at 4% or $312,159 at 6%; with 100% employer match about $351,179 at 4% or $234,119 at 6%.
2022119$1,083,060$192,652$10,140iApproximate average salary by contribution assumption: employee only about $253,489 at 4% or $168,993 at 6%; with 50% employer match about $168,993 at 4% or $112,662 at 6%; with 100% employer match about $126,745 at 4% or $84,496 at 6%.
2ND SPARK CONSULTING LLC 401(K) PROFIT SHARING PLAN-19$1,083,060$192,652$10,140iApproximate average salary by contribution assumption: employee only about $253,489 at 4% or $168,993 at 6%; with 50% employer match about $168,993 at 4% or $112,662 at 6%; with 100% employer match about $126,745 at 4% or $84,496 at 6%.
2021115$1,100,987$117,272$7,818iApproximate average salary by contribution assumption: employee only about $195,453 at 4% or $130,302 at 6%; with 50% employer match about $130,302 at 4% or $86,868 at 6%; with 100% employer match about $97,727 at 4% or $65,151 at 6%.
2ND SPARK CONSULTING LLC 401(K) PROFIT SHARING PLAN-15$1,100,987$117,272$7,818iApproximate average salary by contribution assumption: employee only about $195,453 at 4% or $130,302 at 6%; with 50% employer match about $130,302 at 4% or $86,868 at 6%; with 100% employer match about $97,727 at 4% or $65,151 at 6%.
2020110$869,429$196,302$19,630iApproximate average salary by contribution assumption: employee only about $490,755 at 4% or $327,170 at 6%; with 50% employer match about $327,170 at 4% or $218,113 at 6%; with 100% employer match about $245,378 at 4% or $163,585 at 6%.
2ND SPARK CONSULTING LLC 401(K) PROFIT SHARING PLAN-10$869,429$196,302$19,630iApproximate average salary by contribution assumption: employee only about $490,755 at 4% or $327,170 at 6%; with 50% employer match about $327,170 at 4% or $218,113 at 6%; with 100% employer match about $245,378 at 4% or $163,585 at 6%.
201918$651,658$148,651$18,581iApproximate average salary by contribution assumption: employee only about $464,534 at 4% or $309,690 at 6%; with 50% employer match about $309,690 at 4% or $206,460 at 6%; with 100% employer match about $232,267 at 4% or $154,845 at 6%.
2ND SPARK CONSULTING LLC 401(K) PROFIT SHARING PLAN-8$651,658$148,651$18,581iApproximate average salary by contribution assumption: employee only about $464,534 at 4% or $309,690 at 6%; with 50% employer match about $309,690 at 4% or $206,460 at 6%; with 100% employer match about $232,267 at 4% or $154,845 at 6%.
201829$429,633$131,083$14,565iApproximate average salary by contribution assumption: employee only about $364,119 at 4% or $242,746 at 6%; with 50% employer match about $242,746 at 4% or $161,831 at 6%; with 100% employer match about $182,060 at 4% or $121,373 at 6%.
2ND SPARK CONSULTING LLC 401(K) PROFIT SHARING PLAN-9$429,633$131,083$14,565iApproximate average salary by contribution assumption: employee only about $364,119 at 4% or $242,746 at 6%; with 50% employer match about $242,746 at 4% or $161,831 at 6%; with 100% employer match about $182,060 at 4% or $121,373 at 6%.
2Nd Spark Consulting LLC Cash Balance Plan-0$0$0-
2017210$350,732$44,197$4,420iApproximate average salary by contribution assumption: employee only about $110,493 at 4% or $73,662 at 6%; with 50% employer match about $73,662 at 4% or $49,108 at 6%; with 100% employer match about $55,246 at 4% or $36,831 at 6%.
2ND SPARK CONSULTING LLC 401(K) PROFIT SHARING PLAN-10$335,408$44,197$4,420iApproximate average salary by contribution assumption: employee only about $110,493 at 4% or $73,662 at 6%; with 50% employer match about $73,662 at 4% or $49,108 at 6%; with 100% employer match about $55,246 at 4% or $36,831 at 6%.
2Nd Spark Consulting LLC Cash Balance Plan-3$15,324$0-
201629$257,788$77,254$8,584iApproximate average salary by contribution assumption: employee only about $214,594 at 4% or $143,063 at 6%; with 50% employer match about $143,063 at 4% or $95,375 at 6%; with 100% employer match about $107,297 at 4% or $71,531 at 6%.
2ND SPARK CONSULTING LLC 401(K) PROFIT SHARING PLAN-9$242,470$63,286$7,032iApproximate average salary by contribution assumption: employee only about $175,794 at 4% or $117,196 at 6%; with 50% employer match about $117,196 at 4% or $78,131 at 6%; with 100% employer match about $87,897 at 4% or $58,598 at 6%.
2Nd Spark Consulting LLC Cash Balance Plan-2$15,318$13,968$6,984iApproximate average salary by contribution assumption: employee only about $174,600 at 4% or $116,400 at 6%; with 50% employer match about $116,400 at 4% or $77,600 at 6%; with 100% employer match about $87,300 at 4% or $58,200 at 6%.
201539$216,805$56,946$6,327iApproximate average salary by contribution assumption: employee only about $158,183 at 4% or $105,456 at 6%; with 50% employer match about $105,456 at 4% or $70,304 at 6%; with 100% employer match about $79,092 at 4% or $52,728 at 6%.
2ND SPARK CONSULTING LLC 401K PROFIT SHARING PLAN AND TRUST-9$215,455$55,596$6,177iApproximate average salary by contribution assumption: employee only about $154,433 at 4% or $102,956 at 6%; with 50% employer match about $102,956 at 4% or $68,637 at 6%; with 100% employer match about $77,217 at 4% or $51,478 at 6%.
2Nd Spark Consulting LLC Cash Balance Plan-3$1,350$1,350$450iApproximate average salary by contribution assumption: employee only about $11,250 at 4% or $7,500 at 6%; with 50% employer match about $7,500 at 4% or $5,000 at 6%; with 100% employer match about $5,625 at 4% or $3,750 at 6%.
2ND SPARK CONSULTING, LLC PROFIT SHARING PLAN-0$0--
201417$162,488$47,452$6,779iApproximate average salary by contribution assumption: employee only about $169,471 at 4% or $112,981 at 6%; with 50% employer match about $112,981 at 4% or $75,321 at 6%; with 100% employer match about $84,736 at 4% or $56,490 at 6%.
2ND SPARK CONSULTING LLC 401 K PROFIT SHARING PLAN TRUST-7$162,488$47,452$6,779iApproximate average salary by contribution assumption: employee only about $169,471 at 4% or $112,981 at 6%; with 50% employer match about $112,981 at 4% or $75,321 at 6%; with 100% employer match about $84,736 at 4% or $56,490 at 6%.
201316$110,815$28,372$4,729iApproximate average salary by contribution assumption: employee only about $118,217 at 4% or $78,811 at 6%; with 50% employer match about $78,811 at 4% or $52,541 at 6%; with 100% employer match about $59,108 at 4% or $39,406 at 6%.
2ND SPARK CONSULTING LLC 401 K PROFIT SHARING PLAN TRUST-6$110,815$28,372$4,729iApproximate average salary by contribution assumption: employee only about $118,217 at 4% or $78,811 at 6%; with 50% employer match about $78,811 at 4% or $52,541 at 6%; with 100% employer match about $59,108 at 4% or $39,406 at 6%.
201215$68,768$39,157$7,831iApproximate average salary by contribution assumption: employee only about $195,785 at 4% or $130,523 at 6%; with 50% employer match about $130,523 at 4% or $87,016 at 6%; with 100% employer match about $97,893 at 4% or $65,262 at 6%.
2ND SPARK CONSULTING LLC 401 K PROFIT SHARING PLAN TRUST-5$68,768$39,157$7,831iApproximate average salary by contribution assumption: employee only about $195,785 at 4% or $130,523 at 6%; with 50% employer match about $130,523 at 4% or $87,016 at 6%; with 100% employer match about $97,893 at 4% or $65,262 at 6%.
201113$24,874$9,826$3,275iApproximate average salary by contribution assumption: employee only about $81,883 at 4% or $54,589 at 6%; with 50% employer match about $54,589 at 4% or $36,393 at 6%; with 100% employer match about $40,942 at 4% or $27,294 at 6%.
2ND SPARK CONSULTING LLC 401 K PROFIT SHARING PLAN TRUST-3$24,874$9,826$3,275iApproximate average salary by contribution assumption: employee only about $81,883 at 4% or $54,589 at 6%; with 50% employer match about $54,589 at 4% or $36,393 at 6%; with 100% employer match about $40,942 at 4% or $27,294 at 6%.
201015$30,092$33,817$6,763iApproximate average salary by contribution assumption: employee only about $169,085 at 4% or $112,723 at 6%; with 50% employer match about $112,723 at 4% or $75,149 at 6%; with 100% employer match about $84,543 at 4% or $56,362 at 6%.
2ND SPARK CONSULTING LLC 401 K PROFIT SHARING PLAN TRUST-5$30,092$33,817$6,763iApproximate average salary by contribution assumption: employee only about $169,085 at 4% or $112,723 at 6%; with 50% employer match about $112,723 at 4% or $75,149 at 6%; with 100% employer match about $84,543 at 4% or $56,362 at 6%.