Civic Intelligence

Red Cedar Consultancy LLC

Plan context: Red Cedar Consultancy LLC 401(K) Profit Sharing Plan & Trust

EIN 45-1634437 • Leesburg, VA • 10 filings • 3 plans

161 Fort Evans Rd NE Ste 200Leesburg, VA 20176
Current Snapshot

Latest Year

2021

2021 Participants

34

2021 Assets

$1,288,785

2021 Contributions

$16,956

Historical Graphs

Total Assets Over Time

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

$1,288,785$644,393$0201220162020YearValue
$1,288,785Latest year 2020

Participants Over Time

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

34170201220162020YearValue
34Latest year 2020

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
202110$0$16,956-
Red Cedar Consultancy LLC 401(K) Profit Sharing Plan & Trust-0$0$16,956-
2020134$1,288,785$344,438$10,131iApproximate average salary by contribution assumption: employee only about $253,263 at 4% or $168,842 at 6%; with 50% employer match about $168,842 at 4% or $112,561 at 6%; with 100% employer match about $126,632 at 4% or $84,421 at 6%.
Red Cedar Consultancy LLC 401(K) Profit Sharing Plan & Trust-34$1,288,785$344,438$10,131iApproximate average salary by contribution assumption: employee only about $253,263 at 4% or $168,842 at 6%; with 50% employer match about $168,842 at 4% or $112,561 at 6%; with 100% employer match about $126,632 at 4% or $84,421 at 6%.
2019123$811,540$194,269$8,446iApproximate average salary by contribution assumption: employee only about $211,162 at 4% or $140,775 at 6%; with 50% employer match about $140,775 at 4% or $93,850 at 6%; with 100% employer match about $105,581 at 4% or $70,387 at 6%.
Red Cedar Consultancy LLC 401(K) Profit Sharing Plan & Trust-23$811,540$194,269$8,446iApproximate average salary by contribution assumption: employee only about $211,162 at 4% or $140,775 at 6%; with 50% employer match about $140,775 at 4% or $93,850 at 6%; with 100% employer match about $105,581 at 4% or $70,387 at 6%.
2018117$520,402$112,606$6,624iApproximate average salary by contribution assumption: employee only about $165,597 at 4% or $110,398 at 6%; with 50% employer match about $110,398 at 4% or $73,599 at 6%; with 100% employer match about $82,799 at 4% or $55,199 at 6%.
Red Cedar Consultancy LLC 401(K) Profit Sharing Plan & Trust-17$520,402$112,606$6,624iApproximate average salary by contribution assumption: employee only about $165,597 at 4% or $110,398 at 6%; with 50% employer match about $110,398 at 4% or $73,599 at 6%; with 100% employer match about $82,799 at 4% or $55,199 at 6%.
2017110$501,585$44,424$4,442iApproximate average salary by contribution assumption: employee only about $111,060 at 4% or $74,040 at 6%; with 50% employer match about $74,040 at 4% or $49,360 at 6%; with 100% employer match about $55,530 at 4% or $37,020 at 6%.
Red Cedar Consultancy LLC 401(K) Profit Sharing Plan & Trust-10$501,585$44,424$4,442iApproximate average salary by contribution assumption: employee only about $111,060 at 4% or $74,040 at 6%; with 50% employer match about $74,040 at 4% or $49,360 at 6%; with 100% employer match about $55,530 at 4% or $37,020 at 6%.
2016119$391,936$25,862$1,361iApproximate average salary by contribution assumption: employee only about $34,029 at 4% or $22,686 at 6%; with 50% employer match about $22,686 at 4% or $15,124 at 6%; with 100% employer match about $17,014 at 4% or $11,343 at 6%.
Red Cedar Consultancy LLC 401(K) Profit Sharing Plan & Trust-19$391,936$25,862$1,361iApproximate average salary by contribution assumption: employee only about $34,029 at 4% or $22,686 at 6%; with 50% employer match about $22,686 at 4% or $15,124 at 6%; with 100% employer match about $17,014 at 4% or $11,343 at 6%.
201513$289,912$15,238$5,079iApproximate average salary by contribution assumption: employee only about $126,983 at 4% or $84,656 at 6%; with 50% employer match about $84,656 at 4% or $56,437 at 6%; with 100% employer match about $63,492 at 4% or $42,328 at 6%.
Red Cedar Consultancy LLC 401(K) Profit Sharing Plan & Trust-3$289,912$15,238$5,079iApproximate average salary by contribution assumption: employee only about $126,983 at 4% or $84,656 at 6%; with 50% employer match about $84,656 at 4% or $56,437 at 6%; with 100% employer match about $63,492 at 4% or $42,328 at 6%.
201413$278,361$51,063$17,021iApproximate average salary by contribution assumption: employee only about $425,525 at 4% or $283,683 at 6%; with 50% employer match about $283,683 at 4% or $189,122 at 6%; with 100% employer match about $212,763 at 4% or $141,842 at 6%.
Red Cedar Consultancy LLC 401(K) Profit Sharing Plan & Trust-3$278,361$51,063$17,021iApproximate average salary by contribution assumption: employee only about $425,525 at 4% or $283,683 at 6%; with 50% employer match about $283,683 at 4% or $189,122 at 6%; with 100% employer match about $212,763 at 4% or $141,842 at 6%.
201312$212,620$72,800$36,400iApproximate average salary by contribution assumption: employee only about $910,000 at 4% or $606,667 at 6%; with 50% employer match about $606,667 at 4% or $404,444 at 6%; with 100% employer match about $455,000 at 4% or $303,333 at 6%.
Red Cedar Consultancy LLC 401(K) Profit Sharing Plan & Trust-2$212,620$72,800$36,400iApproximate average salary by contribution assumption: employee only about $910,000 at 4% or $606,667 at 6%; with 50% employer match about $606,667 at 4% or $404,444 at 6%; with 100% employer match about $455,000 at 4% or $303,333 at 6%.
201212$112,538$109,641$54,821iApproximate average salary by contribution assumption: employee only about $1,370,513 at 4% or $913,675 at 6%; with 50% employer match about $913,675 at 4% or $609,117 at 6%; with 100% employer match about $685,256 at 4% or $456,838 at 6%.
Red Cedar Consultancy LLC 401(K) Profit Sharing Plan & Trust-2$112,538$109,641$54,821iApproximate average salary by contribution assumption: employee only about $1,370,513 at 4% or $913,675 at 6%; with 50% employer match about $913,675 at 4% or $609,117 at 6%; with 100% employer match about $685,256 at 4% or $456,838 at 6%.