Civic Intelligence

Barbara E. Spangler, DMD, Msd LLC

Plan context: Barbara E. Spangler, DMD, Msd LLC Cash Balance Plan

EIN 46-1546925 • Hummelstown, PA • 17 filings • 4 plans

1305 Middletown Rd. Suite 1Hummelstown, PA 17036-8825
Current Snapshot

Latest Year

2021

2021 Participants

4

2021 Assets

$2,272,458

2021 Contributions

$9,145

Historical Graphs

Total Assets Over Time

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

$2,272,458$1,136,229$0201320172020YearValue
$2,272,458Latest year 2020

Participants Over Time

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

420201320172020YearValue
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
202120$0$9,145-
SUMMIT ORTHODONTICS, LLC RETIREMENT PLAN-0$0$0-
Barbara E. Spangler, DMD, Msd LLC Cash Balance Plan-0$0$9,145-
202024$2,272,458$73,904$18,476iApproximate average salary by contribution assumption: employee only about $461,900 at 4% or $307,933 at 6%; with 50% employer match about $307,933 at 4% or $205,289 at 6%; with 100% employer match about $230,950 at 4% or $153,967 at 6%.
SUMMIT ORTHODONTICS, LLC RETIREMENT PLAN-4$1,597,171$64,404$16,101iApproximate average salary by contribution assumption: employee only about $402,525 at 4% or $268,350 at 6%; with 50% employer match about $268,350 at 4% or $178,900 at 6%; with 100% employer match about $201,263 at 4% or $134,175 at 6%.
Barbara E. Spangler, DMD, Msd LLC Cash Balance Plan-2$675,287$9,500$4,750iApproximate average salary by contribution assumption: employee only about $118,750 at 4% or $79,167 at 6%; with 50% employer match about $79,167 at 4% or $52,778 at 6%; with 100% employer match about $59,375 at 4% or $39,583 at 6%.
201924$2,127,799$119,735$29,934iApproximate average salary by contribution assumption: employee only about $748,344 at 4% or $498,896 at 6%; with 50% employer match about $498,896 at 4% or $332,597 at 6%; with 100% employer match about $374,172 at 4% or $249,448 at 6%.
SUMMIT ORTHODONTICS, LLC RETIREMENT PLAN-4$1,387,851$44,735$11,184iApproximate average salary by contribution assumption: employee only about $279,594 at 4% or $186,396 at 6%; with 50% employer match about $186,396 at 4% or $124,264 at 6%; with 100% employer match about $139,797 at 4% or $93,198 at 6%.
Barbara E. Spangler, DMD, Msd LLC Cash Balance Plan-2$739,948$75,000$37,500iApproximate average salary by contribution assumption: employee only about $937,500 at 4% or $625,000 at 6%; with 50% employer match about $625,000 at 4% or $416,667 at 6%; with 100% employer match about $468,750 at 4% or $312,500 at 6%.
201823$1,742,326$111,106$37,035iApproximate average salary by contribution assumption: employee only about $925,883 at 4% or $617,256 at 6%; with 50% employer match about $617,256 at 4% or $411,504 at 6%; with 100% employer match about $462,942 at 4% or $308,628 at 6%.
SUMMIT ORTHODONTICS, LLC RETIREMENT PLAN-3$1,168,455$36,106$12,035iApproximate average salary by contribution assumption: employee only about $300,883 at 4% or $200,589 at 6%; with 50% employer match about $200,589 at 4% or $133,726 at 6%; with 100% employer match about $150,442 at 4% or $100,294 at 6%.
Barbara E. Spangler, DMD, Msd LLC Cash Balance Plan-2$573,871$75,000$37,500iApproximate average salary by contribution assumption: employee only about $937,500 at 4% or $625,000 at 6%; with 50% employer match about $625,000 at 4% or $416,667 at 6%; with 100% employer match about $468,750 at 4% or $312,500 at 6%.
201724$1,719,691$155,211$38,803iApproximate average salary by contribution assumption: employee only about $970,069 at 4% or $646,713 at 6%; with 50% employer match about $646,713 at 4% or $431,142 at 6%; with 100% employer match about $485,034 at 4% or $323,356 at 6%.
BARBARA E. SPANGLER, DMD, MSD LLC RETIREMENT PLAN-4$1,186,068$35,211$8,803iApproximate average salary by contribution assumption: employee only about $220,069 at 4% or $146,713 at 6%; with 50% employer match about $146,713 at 4% or $97,808 at 6%; with 100% employer match about $110,034 at 4% or $73,356 at 6%.
Barbara E. Spangler, DMD, Msd LLC Cash Balance Plan-2$533,623$120,000$60,000iApproximate average salary by contribution assumption: employee only about $1,500,000 at 4% or $1,000,000 at 6%; with 50% employer match about $1,000,000 at 4% or $666,667 at 6%; with 100% employer match about $750,000 at 4% or $500,000 at 6%.
201624$1,399,159$159,972$39,993iApproximate average salary by contribution assumption: employee only about $999,825 at 4% or $666,550 at 6%; with 50% employer match about $666,550 at 4% or $444,367 at 6%; with 100% employer match about $499,913 at 4% or $333,275 at 6%.
BARBARA E. SPANGLER, DMD, MSD LLC RETIREMENT PLAN-4$1,027,293$37,872$9,468iApproximate average salary by contribution assumption: employee only about $236,700 at 4% or $157,800 at 6%; with 50% employer match about $157,800 at 4% or $105,200 at 6%; with 100% employer match about $118,350 at 4% or $78,900 at 6%.
Barbara E. Spangler, DMD, Msd LLC Cash Balance Plan-2$371,866$122,100$61,050iApproximate average salary by contribution assumption: employee only about $1,526,250 at 4% or $1,017,500 at 6%; with 50% employer match about $1,017,500 at 4% or $678,333 at 6%; with 100% employer match about $763,125 at 4% or $508,750 at 6%.
201522$1,163,782$124,000$62,000iApproximate average salary by contribution assumption: employee only about $1,550,000 at 4% or $1,033,333 at 6%; with 50% employer match about $1,033,333 at 4% or $688,889 at 6%; with 100% employer match about $775,000 at 4% or $516,667 at 6%.
BARBARA E. SPANGLER, DMD, MSD LLC RETIREMENT PLAN-2$930,442$24,000$12,000iApproximate average salary by contribution assumption: employee only about $300,000 at 4% or $200,000 at 6%; with 50% employer match about $200,000 at 4% or $133,333 at 6%; with 100% employer match about $150,000 at 4% or $100,000 at 6%.
Barbara E. Spangler, DMD, Msd LLC Cash Balance Plan-1$233,340$100,000$100,000iApproximate average salary by contribution assumption: employee only about $2,500,000 at 4% or $1,666,667 at 6%; with 50% employer match about $1,666,667 at 4% or $1,111,111 at 6%; with 100% employer match about $1,250,000 at 4% or $833,333 at 6%.
201424$918,107$28,984$7,246iApproximate average salary by contribution assumption: employee only about $181,150 at 4% or $120,767 at 6%; with 50% employer match about $120,767 at 4% or $80,511 at 6%; with 100% employer match about $90,575 at 4% or $60,383 at 6%.
BARBARA E. SPANGLER, DMD, MSD LLC RETIREMENT PLAN-4$918,107$28,984$7,246iApproximate average salary by contribution assumption: employee only about $181,150 at 4% or $120,767 at 6%; with 50% employer match about $120,767 at 4% or $80,511 at 6%; with 100% employer match about $90,575 at 4% or $60,383 at 6%.
Barbara E. Spangler, DMD, Msd LLC Cash Balance Plan-3$0$0-
201314$883,301$58,342$14,586iApproximate average salary by contribution assumption: employee only about $364,638 at 4% or $243,092 at 6%; with 50% employer match about $243,092 at 4% or $162,061 at 6%; with 100% employer match about $182,319 at 4% or $121,546 at 6%.
BARBARA E. SPANGLER, DMD, MSD, LLC RETIREMENT PLAN-4$883,301$58,342$14,586iApproximate average salary by contribution assumption: employee only about $364,638 at 4% or $243,092 at 6%; with 50% employer match about $243,092 at 4% or $162,061 at 6%; with 100% employer match about $182,319 at 4% or $121,546 at 6%.