Civic Intelligence

John Spero, DMD LLC

Plan context: John Spero, DMD LLC 401(K) Profit Sharing Plan

EIN 27-1481066 • York, ME • 15 filings • 2 plans

1060 US Route 1 / P.O. Box 323York, ME 03909-5891
Current Snapshot

Latest Year

2024

2024 Participants

10

2024 Assets

$2,235,544

2024 Contributions

$151,732

Historical Graphs

Total Assets Over Time

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

$2,235,544$1,117,772$0201020172024YearValue
$2,235,544Latest year 2024

Participants Over Time

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

1370201020172024YearValue
10Latest 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
2024110$2,235,544$151,732$15,173iApproximate average salary by contribution assumption: employee only about $379,330 at 4% or $252,887 at 6%; with 50% employer match about $252,887 at 4% or $168,591 at 6%; with 100% employer match about $189,665 at 4% or $126,443 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-10$2,235,544$151,732$15,173iApproximate average salary by contribution assumption: employee only about $379,330 at 4% or $252,887 at 6%; with 50% employer match about $252,887 at 4% or $168,591 at 6%; with 100% employer match about $189,665 at 4% or $126,443 at 6%.
2023110$1,924,879$133,883$13,388iApproximate average salary by contribution assumption: employee only about $334,708 at 4% or $223,138 at 6%; with 50% employer match about $223,138 at 4% or $148,759 at 6%; with 100% employer match about $167,354 at 4% or $111,569 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-10$1,924,879$133,883$13,388iApproximate average salary by contribution assumption: employee only about $334,708 at 4% or $223,138 at 6%; with 50% employer match about $223,138 at 4% or $148,759 at 6%; with 100% employer match about $167,354 at 4% or $111,569 at 6%.
2022111$1,626,918$130,584$11,871iApproximate average salary by contribution assumption: employee only about $296,782 at 4% or $197,855 at 6%; with 50% employer match about $197,855 at 4% or $131,903 at 6%; with 100% employer match about $148,391 at 4% or $98,927 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-11$1,626,918$130,584$11,871iApproximate average salary by contribution assumption: employee only about $296,782 at 4% or $197,855 at 6%; with 50% employer match about $197,855 at 4% or $131,903 at 6%; with 100% employer match about $148,391 at 4% or $98,927 at 6%.
2021110$2,143,864$124,577$12,458iApproximate average salary by contribution assumption: employee only about $311,443 at 4% or $207,628 at 6%; with 50% employer match about $207,628 at 4% or $138,419 at 6%; with 100% employer match about $155,721 at 4% or $103,814 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-10$2,143,864$124,577$12,458iApproximate average salary by contribution assumption: employee only about $311,443 at 4% or $207,628 at 6%; with 50% employer match about $207,628 at 4% or $138,419 at 6%; with 100% employer match about $155,721 at 4% or $103,814 at 6%.
202019$1,881,173$115,780$12,864iApproximate average salary by contribution assumption: employee only about $321,611 at 4% or $214,407 at 6%; with 50% employer match about $214,407 at 4% or $142,938 at 6%; with 100% employer match about $160,806 at 4% or $107,204 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-9$1,881,173$115,780$12,864iApproximate average salary by contribution assumption: employee only about $321,611 at 4% or $214,407 at 6%; with 50% employer match about $214,407 at 4% or $142,938 at 6%; with 100% employer match about $160,806 at 4% or $107,204 at 6%.
2019110$1,659,947$132,047$13,205iApproximate average salary by contribution assumption: employee only about $330,118 at 4% or $220,078 at 6%; with 50% employer match about $220,078 at 4% or $146,719 at 6%; with 100% employer match about $165,059 at 4% or $110,039 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-10$1,659,947$132,047$13,205iApproximate average salary by contribution assumption: employee only about $330,118 at 4% or $220,078 at 6%; with 50% employer match about $220,078 at 4% or $146,719 at 6%; with 100% employer match about $165,059 at 4% or $110,039 at 6%.
2018110$1,320,512$132,373$13,237iApproximate average salary by contribution assumption: employee only about $330,933 at 4% or $220,622 at 6%; with 50% employer match about $220,622 at 4% or $147,081 at 6%; with 100% employer match about $165,466 at 4% or $110,311 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-10$1,320,512$132,373$13,237iApproximate average salary by contribution assumption: employee only about $330,933 at 4% or $220,622 at 6%; with 50% employer match about $220,622 at 4% or $147,081 at 6%; with 100% employer match about $165,466 at 4% or $110,311 at 6%.
2017110$1,261,633$132,563$13,256iApproximate average salary by contribution assumption: employee only about $331,408 at 4% or $220,938 at 6%; with 50% employer match about $220,938 at 4% or $147,292 at 6%; with 100% employer match about $165,704 at 4% or $110,469 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-10$1,261,633$132,563$13,256iApproximate average salary by contribution assumption: employee only about $331,408 at 4% or $220,938 at 6%; with 50% employer match about $220,938 at 4% or $147,292 at 6%; with 100% employer match about $165,704 at 4% or $110,469 at 6%.
2016112$994,440$124,568$10,381iApproximate average salary by contribution assumption: employee only about $259,517 at 4% or $173,011 at 6%; with 50% employer match about $173,011 at 4% or $115,341 at 6%; with 100% employer match about $129,758 at 4% or $86,506 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-12$994,440$124,568$10,381iApproximate average salary by contribution assumption: employee only about $259,517 at 4% or $173,011 at 6%; with 50% employer match about $173,011 at 4% or $115,341 at 6%; with 100% employer match about $129,758 at 4% or $86,506 at 6%.
2015113$847,094$78,032$6,002iApproximate average salary by contribution assumption: employee only about $150,062 at 4% or $100,041 at 6%; with 50% employer match about $100,041 at 4% or $66,694 at 6%; with 100% employer match about $75,031 at 4% or $50,021 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-13$847,094$78,032$6,002iApproximate average salary by contribution assumption: employee only about $150,062 at 4% or $100,041 at 6%; with 50% employer match about $100,041 at 4% or $66,694 at 6%; with 100% employer match about $75,031 at 4% or $50,021 at 6%.
2014113$737,001$136,085$10,468iApproximate average salary by contribution assumption: employee only about $261,702 at 4% or $174,468 at 6%; with 50% employer match about $174,468 at 4% or $116,312 at 6%; with 100% employer match about $130,851 at 4% or $87,234 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-13$737,001$136,085$10,468iApproximate average salary by contribution assumption: employee only about $261,702 at 4% or $174,468 at 6%; with 50% employer match about $174,468 at 4% or $116,312 at 6%; with 100% employer match about $130,851 at 4% or $87,234 at 6%.
2013112$570,660$110,730$9,228iApproximate average salary by contribution assumption: employee only about $230,688 at 4% or $153,792 at 6%; with 50% employer match about $153,792 at 4% or $102,528 at 6%; with 100% employer match about $115,344 at 4% or $76,896 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-12$570,660$110,730$9,228iApproximate average salary by contribution assumption: employee only about $230,688 at 4% or $153,792 at 6%; with 50% employer match about $153,792 at 4% or $102,528 at 6%; with 100% employer match about $115,344 at 4% or $76,896 at 6%.
2012112$364,674$94,357$7,863iApproximate average salary by contribution assumption: employee only about $196,577 at 4% or $131,051 at 6%; with 50% employer match about $131,051 at 4% or $87,368 at 6%; with 100% employer match about $98,289 at 4% or $65,526 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-12$364,674$94,357$7,863iApproximate average salary by contribution assumption: employee only about $196,577 at 4% or $131,051 at 6%; with 50% employer match about $131,051 at 4% or $87,368 at 6%; with 100% employer match about $98,289 at 4% or $65,526 at 6%.
2011111$286,175$91,196$8,291iApproximate average salary by contribution assumption: employee only about $207,264 at 4% or $138,176 at 6%; with 50% employer match about $138,176 at 4% or $92,117 at 6%; with 100% employer match about $103,632 at 4% or $69,088 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-11$286,175$91,196$8,291iApproximate average salary by contribution assumption: employee only about $207,264 at 4% or $138,176 at 6%; with 50% employer match about $138,176 at 4% or $92,117 at 6%; with 100% employer match about $103,632 at 4% or $69,088 at 6%.
201019$192,961$173,716$19,302iApproximate average salary by contribution assumption: employee only about $482,544 at 4% or $321,696 at 6%; with 50% employer match about $321,696 at 4% or $214,464 at 6%; with 100% employer match about $241,272 at 4% or $160,848 at 6%.
John Spero, DMD LLC 401(K) Profit Sharing Plan-9$192,961$173,716$19,302iApproximate average salary by contribution assumption: employee only about $482,544 at 4% or $321,696 at 6%; with 50% employer match about $321,696 at 4% or $214,464 at 6%; with 100% employer match about $241,272 at 4% or $160,848 at 6%.