Civic Intelligence

Robert B. Ancell & Associates Inc.

Plan context: Robert B. Ancell and Associates Inc. Profit Sharing Plan

EIN 38-2102810 • Farmington Hills, MI • 31 filings • 5 plans

37524 Burton CTFarmington Hills, MI 48331-3071
Current Snapshot

Latest Year

2021

2021 Participants

4

2021 Assets

$3,460,090

2021 Contributions

$2,000

Historical Graphs

Total Assets Over Time

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

$3,460,090$1,730,045$0199920102020YearValue
$3,460,090Latest year 2020

Participants Over Time

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

740199920102020YearValue
4Latest 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$2,000-
Robert B. Ancell and Associates Inc. Profit Sharing Plan-0$0$2,000-
202014$3,460,090$132,626$33,157iApproximate average salary by contribution assumption: employee only about $828,913 at 4% or $552,608 at 6%; with 50% employer match about $552,608 at 4% or $368,406 at 6%; with 100% employer match about $414,456 at 4% or $276,304 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-4$3,460,090$132,626$33,157iApproximate average salary by contribution assumption: employee only about $828,913 at 4% or $552,608 at 6%; with 50% employer match about $552,608 at 4% or $368,406 at 6%; with 100% employer match about $414,456 at 4% or $276,304 at 6%.
201914$3,212,500$125,889$31,472iApproximate average salary by contribution assumption: employee only about $786,806 at 4% or $524,538 at 6%; with 50% employer match about $524,538 at 4% or $349,692 at 6%; with 100% employer match about $393,403 at 4% or $262,269 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-4$3,212,500$125,889$31,472iApproximate average salary by contribution assumption: employee only about $786,806 at 4% or $524,538 at 6%; with 50% employer match about $524,538 at 4% or $349,692 at 6%; with 100% employer match about $393,403 at 4% or $262,269 at 6%.
201814$2,795,487$108,975$27,244iApproximate average salary by contribution assumption: employee only about $681,094 at 4% or $454,063 at 6%; with 50% employer match about $454,063 at 4% or $302,708 at 6%; with 100% employer match about $340,547 at 4% or $227,031 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-4$2,795,487$108,975$27,244iApproximate average salary by contribution assumption: employee only about $681,094 at 4% or $454,063 at 6%; with 50% employer match about $454,063 at 4% or $302,708 at 6%; with 100% employer match about $340,547 at 4% or $227,031 at 6%.
201714$3,026,788$105,936$26,484iApproximate average salary by contribution assumption: employee only about $662,100 at 4% or $441,400 at 6%; with 50% employer match about $441,400 at 4% or $294,267 at 6%; with 100% employer match about $331,050 at 4% or $220,700 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-4$3,026,788$105,936$26,484iApproximate average salary by contribution assumption: employee only about $662,100 at 4% or $441,400 at 6%; with 50% employer match about $441,400 at 4% or $294,267 at 6%; with 100% employer match about $331,050 at 4% or $220,700 at 6%.
201614$2,705,114$105,240$26,310iApproximate average salary by contribution assumption: employee only about $657,750 at 4% or $438,500 at 6%; with 50% employer match about $438,500 at 4% or $292,333 at 6%; with 100% employer match about $328,875 at 4% or $219,250 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-4$2,705,114$105,240$26,310iApproximate average salary by contribution assumption: employee only about $657,750 at 4% or $438,500 at 6%; with 50% employer match about $438,500 at 4% or $292,333 at 6%; with 100% employer match about $328,875 at 4% or $219,250 at 6%.
201514$2,501,957$105,276$26,319iApproximate average salary by contribution assumption: employee only about $657,975 at 4% or $438,650 at 6%; with 50% employer match about $438,650 at 4% or $292,433 at 6%; with 100% employer match about $328,988 at 4% or $219,325 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-4$2,501,957$105,276$26,319iApproximate average salary by contribution assumption: employee only about $657,975 at 4% or $438,650 at 6%; with 50% employer match about $438,650 at 4% or $292,433 at 6%; with 100% employer match about $328,988 at 4% or $219,325 at 6%.
201414$2,642,563$102,232$25,558iApproximate average salary by contribution assumption: employee only about $638,950 at 4% or $425,967 at 6%; with 50% employer match about $425,967 at 4% or $283,978 at 6%; with 100% employer match about $319,475 at 4% or $212,983 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-4$2,642,563$102,232$25,558iApproximate average salary by contribution assumption: employee only about $638,950 at 4% or $425,967 at 6%; with 50% employer match about $425,967 at 4% or $283,978 at 6%; with 100% employer match about $319,475 at 4% or $212,983 at 6%.
201314$2,606,279$101,575$25,394iApproximate average salary by contribution assumption: employee only about $634,844 at 4% or $423,229 at 6%; with 50% employer match about $423,229 at 4% or $282,153 at 6%; with 100% employer match about $317,422 at 4% or $211,615 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-4$2,606,279$101,575$25,394iApproximate average salary by contribution assumption: employee only about $634,844 at 4% or $423,229 at 6%; with 50% employer match about $423,229 at 4% or $282,153 at 6%; with 100% employer match about $317,422 at 4% or $211,615 at 6%.
201214$2,476,861$93,761$23,440iApproximate average salary by contribution assumption: employee only about $586,006 at 4% or $390,671 at 6%; with 50% employer match about $390,671 at 4% or $260,447 at 6%; with 100% employer match about $293,003 at 4% or $195,335 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-4$2,476,861$93,761$23,440iApproximate average salary by contribution assumption: employee only about $586,006 at 4% or $390,671 at 6%; with 50% employer match about $390,671 at 4% or $260,447 at 6%; with 100% employer match about $293,003 at 4% or $195,335 at 6%.
201115$2,251,418$98,884$19,777iApproximate average salary by contribution assumption: employee only about $494,420 at 4% or $329,613 at 6%; with 50% employer match about $329,613 at 4% or $219,742 at 6%; with 100% employer match about $247,210 at 4% or $164,807 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-5$2,251,418$98,884$19,777iApproximate average salary by contribution assumption: employee only about $494,420 at 4% or $329,613 at 6%; with 50% employer match about $329,613 at 4% or $219,742 at 6%; with 100% employer match about $247,210 at 4% or $164,807 at 6%.
201016$2,301,394$103,508$17,251iApproximate average salary by contribution assumption: employee only about $431,283 at 4% or $287,522 at 6%; with 50% employer match about $287,522 at 4% or $191,681 at 6%; with 100% employer match about $215,642 at 4% or $143,761 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-6$2,301,394$103,508$17,251iApproximate average salary by contribution assumption: employee only about $431,283 at 4% or $287,522 at 6%; with 50% employer match about $287,522 at 4% or $191,681 at 6%; with 100% employer match about $215,642 at 4% or $143,761 at 6%.
200916$2,002,363$102,102$17,017iApproximate average salary by contribution assumption: employee only about $425,425 at 4% or $283,617 at 6%; with 50% employer match about $283,617 at 4% or $189,078 at 6%; with 100% employer match about $212,713 at 4% or $141,808 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-6$2,002,363$102,102$17,017iApproximate average salary by contribution assumption: employee only about $425,425 at 4% or $283,617 at 6%; with 50% employer match about $283,617 at 4% or $189,078 at 6%; with 100% employer match about $212,713 at 4% or $141,808 at 6%.
200816$1,529,390$76,132$12,689iApproximate average salary by contribution assumption: employee only about $317,217 at 4% or $211,478 at 6%; with 50% employer match about $211,478 at 4% or $140,985 at 6%; with 100% employer match about $158,608 at 4% or $105,739 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-6$1,529,390$76,132$12,689iApproximate average salary by contribution assumption: employee only about $317,217 at 4% or $211,478 at 6%; with 50% employer match about $211,478 at 4% or $140,985 at 6%; with 100% employer match about $158,608 at 4% or $105,739 at 6%.
200715$1,935,711$71,521$14,304iApproximate average salary by contribution assumption: employee only about $357,605 at 4% or $238,403 at 6%; with 50% employer match about $238,403 at 4% or $158,936 at 6%; with 100% employer match about $178,803 at 4% or $119,202 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-5$1,935,711$71,521$14,304iApproximate average salary by contribution assumption: employee only about $357,605 at 4% or $238,403 at 6%; with 50% employer match about $238,403 at 4% or $158,936 at 6%; with 100% employer match about $178,803 at 4% or $119,202 at 6%.
200615$1,775,344$79,175$15,835iApproximate average salary by contribution assumption: employee only about $395,875 at 4% or $263,917 at 6%; with 50% employer match about $263,917 at 4% or $175,944 at 6%; with 100% employer match about $197,938 at 4% or $131,958 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-5$1,775,344$79,175$15,835iApproximate average salary by contribution assumption: employee only about $395,875 at 4% or $263,917 at 6%; with 50% employer match about $263,917 at 4% or $175,944 at 6%; with 100% employer match about $197,938 at 4% or $131,958 at 6%.
200527$1,568,656$382,463$54,638iApproximate average salary by contribution assumption: employee only about $1,365,939 at 4% or $910,626 at 6%; with 50% employer match about $910,626 at 4% or $607,084 at 6%; with 100% employer match about $682,970 at 4% or $455,313 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-7$1,568,656$66,288$9,470iApproximate average salary by contribution assumption: employee only about $236,743 at 4% or $157,829 at 6%; with 50% employer match about $157,829 at 4% or $105,219 at 6%; with 100% employer match about $118,371 at 4% or $78,914 at 6%.
Robert B. Ancell & Associates Inc. Pension Plan-0-$316,175-
200436$2,979,900$47,332$7,889iApproximate average salary by contribution assumption: employee only about $197,217 at 4% or $131,478 at 6%; with 50% employer match about $131,478 at 4% or $87,652 at 6%; with 100% employer match about $98,608 at 4% or $65,739 at 6%.
Robert B. Ancell & Associates Inc. Pension Plan-4$1,540,895--
Robert B. Ancell and Associates Inc. Profit Sharing Plan-6$1,439,005$47,332$7,889iApproximate average salary by contribution assumption: employee only about $197,217 at 4% or $131,478 at 6%; with 50% employer match about $131,478 at 4% or $87,652 at 6%; with 100% employer match about $98,608 at 4% or $65,739 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-6---
200323$2,689,206$474,259$158,086iApproximate average salary by contribution assumption: employee only about $3,952,158 at 4% or $2,634,772 at 6%; with 50% employer match about $2,634,772 at 4% or $1,756,515 at 6%; with 100% employer match about $1,976,079 at 4% or $1,317,386 at 6%.
Robert B. Ancell & Associates Inc. Pension Plan-3$1,430,276$474,259$158,086iApproximate average salary by contribution assumption: employee only about $3,952,158 at 4% or $2,634,772 at 6%; with 50% employer match about $2,634,772 at 4% or $1,756,515 at 6%; with 100% employer match about $1,976,079 at 4% or $1,317,386 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-3$1,258,930--
200223$1,866,032$291,617$97,206iApproximate average salary by contribution assumption: employee only about $2,430,142 at 4% or $1,620,094 at 6%; with 50% employer match about $1,620,094 at 4% or $1,080,063 at 6%; with 100% employer match about $1,215,071 at 4% or $810,047 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-3$1,053,102--
Robert B. Ancell & Associates Inc. Pension Plan-2$812,930$291,617$145,809iApproximate average salary by contribution assumption: employee only about $3,645,213 at 4% or $2,430,142 at 6%; with 50% employer match about $2,430,142 at 4% or $1,620,094 at 6%; with 100% employer match about $1,822,606 at 4% or $1,215,071 at 6%.
200123$0$0-
Robert B. Ancell and Associates Inc. Profit Sharing Plan-3---
Robert B. Ancell & Associates Inc. Pension Plan-3---
200023$1,830,650$57,860$19,287iApproximate average salary by contribution assumption: employee only about $482,167 at 4% or $321,444 at 6%; with 50% employer match about $321,444 at 4% or $214,296 at 6%; with 100% employer match about $241,083 at 4% or $160,722 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-3$1,194,543--
Robert B. Ancell & Associates Inc. Pension Plan-3$636,107$57,860$19,287iApproximate average salary by contribution assumption: employee only about $482,167 at 4% or $321,444 at 6%; with 50% employer match about $321,444 at 4% or $214,296 at 6%; with 100% employer match about $241,083 at 4% or $160,722 at 6%.
199923$1,788,510$85,000$28,333iApproximate average salary by contribution assumption: employee only about $708,333 at 4% or $472,222 at 6%; with 50% employer match about $472,222 at 4% or $314,815 at 6%; with 100% employer match about $354,167 at 4% or $236,111 at 6%.
Robert B. Ancell and Associates Inc. Profit Sharing Plan-3$1,185,848--
Robert B. Ancell & Associates Inc. Pension Plan-3$602,662$85,000$28,333iApproximate average salary by contribution assumption: employee only about $708,333 at 4% or $472,222 at 6%; with 50% employer match about $472,222 at 4% or $314,815 at 6%; with 100% employer match about $354,167 at 4% or $236,111 at 6%.