Civic Intelligence

David L. Hamel, D.D.S., P.A.

Plan context: DAVID L. HAMEL, D.D.S., P.A. DEFINED BENEFIT CASH BALANCE PLAN & TRUST

EIN 48-0952328 • Marysville, KS • 27 filings • 4 plans

1900 Jenkins StMarysville, KS 66508
Current Snapshot

Latest Year

2020

2020 Participants

9

2020 Assets

$959,799

2020 Contributions

$246,000

Historical Graphs

Total Assets Over Time

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

$2,302,182$1,151,091$0199920102019YearValue
$959,799Latest year 2019

Participants Over Time

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

950199920092019YearValue
9Latest year 2019

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
202010$0$0-
DAVID L. HAMEL, D.D.S., P.A. DEFINED BENEFIT CASH BALANCE PLAN & TRUST-0$0$0-
201919$959,799$0-
DAVID L. HAMEL, D.D.S., P.A. DEFINED BENEFIT CASH BALANCE PLAN & TRUST-9$959,799$0-
201819$857,460$246,000$27,333iApproximate average salary by contribution assumption: employee only about $683,333 at 4% or $455,556 at 6%; with 50% employer match about $455,556 at 4% or $303,704 at 6%; with 100% employer match about $341,667 at 4% or $227,778 at 6%.
DAVID L. HAMEL, D.D.S., P.A. DEFINED BENEFIT CASH BALANCE PLAN & TRUST-9$857,460$246,000$27,333iApproximate average salary by contribution assumption: employee only about $683,333 at 4% or $455,556 at 6%; with 50% employer match about $455,556 at 4% or $303,704 at 6%; with 100% employer match about $341,667 at 4% or $227,778 at 6%.
201718$663,611$231,316$28,915iApproximate average salary by contribution assumption: employee only about $722,863 at 4% or $481,908 at 6%; with 50% employer match about $481,908 at 4% or $321,272 at 6%; with 100% employer match about $361,431 at 4% or $240,954 at 6%.
DAVID L. HAMEL, D.D.S., P.A. DEFINED BENEFIT CASH BALANCE PLAN & TRUST-8$663,611$231,316$28,915iApproximate average salary by contribution assumption: employee only about $722,863 at 4% or $481,908 at 6%; with 50% employer match about $481,908 at 4% or $321,272 at 6%; with 100% employer match about $361,431 at 4% or $240,954 at 6%.
201629$2,302,182$200,313$22,257iApproximate average salary by contribution assumption: employee only about $556,425 at 4% or $370,950 at 6%; with 50% employer match about $370,950 at 4% or $247,300 at 6%; with 100% employer match about $278,213 at 4% or $185,475 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-8$1,899,797$110,313$13,789iApproximate average salary by contribution assumption: employee only about $344,728 at 4% or $229,819 at 6%; with 50% employer match about $229,819 at 4% or $153,213 at 6%; with 100% employer match about $172,364 at 4% or $114,909 at 6%.
DAVID L. HAMEL, D.D.S., P.A. DEFINED BENEFIT CASH-9$402,385$90,000$10,000iApproximate average salary by contribution assumption: employee only about $250,000 at 4% or $166,667 at 6%; with 50% employer match about $166,667 at 4% or $111,111 at 6%; with 100% employer match about $125,000 at 4% or $83,333 at 6%.
201528$1,977,315$197,152$24,644iApproximate average salary by contribution assumption: employee only about $616,100 at 4% or $410,733 at 6%; with 50% employer match about $410,733 at 4% or $273,822 at 6%; with 100% employer match about $308,050 at 4% or $205,367 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-8$1,686,024$108,152$13,519iApproximate average salary by contribution assumption: employee only about $337,975 at 4% or $225,317 at 6%; with 50% employer match about $225,317 at 4% or $150,211 at 6%; with 100% employer match about $168,988 at 4% or $112,658 at 6%.
DAVID L. HAMEL, D.D.S., P.A. DEFINED BENEFIT CASH-8$291,291$89,000$11,125iApproximate average salary by contribution assumption: employee only about $278,125 at 4% or $185,417 at 6%; with 50% employer match about $185,417 at 4% or $123,611 at 6%; with 100% employer match about $139,063 at 4% or $92,708 at 6%.
201428$1,889,685$171,513$21,439iApproximate average salary by contribution assumption: employee only about $535,978 at 4% or $357,319 at 6%; with 50% employer match about $357,319 at 4% or $238,213 at 6%; with 100% employer match about $267,989 at 4% or $178,659 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-8$1,678,998$101,513$12,689iApproximate average salary by contribution assumption: employee only about $317,228 at 4% or $211,485 at 6%; with 50% employer match about $211,485 at 4% or $140,990 at 6%; with 100% employer match about $158,614 at 4% or $105,743 at 6%.
DAVID L. HAMEL, D.D.S., P.A. DEFINED BENEFIT CASH-8$210,687$70,000$8,750iApproximate average salary by contribution assumption: employee only about $218,750 at 4% or $145,833 at 6%; with 50% employer match about $145,833 at 4% or $97,222 at 6%; with 100% employer match about $109,375 at 4% or $72,917 at 6%.
201327$1,679,069$170,889$24,413iApproximate average salary by contribution assumption: employee only about $610,318 at 4% or $406,879 at 6%; with 50% employer match about $406,879 at 4% or $271,252 at 6%; with 100% employer match about $305,159 at 4% or $203,439 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-7$1,543,423$105,889$15,127iApproximate average salary by contribution assumption: employee only about $378,175 at 4% or $252,117 at 6%; with 50% employer match about $252,117 at 4% or $168,078 at 6%; with 100% employer match about $189,088 at 4% or $126,058 at 6%.
DAVID L. HAMEL, D.D.S., P.A. DEFINED BENEFIT CASH-7$135,646$65,000$9,286iApproximate average salary by contribution assumption: employee only about $232,143 at 4% or $154,762 at 6%; with 50% employer match about $154,762 at 4% or $103,175 at 6%; with 100% employer match about $116,071 at 4% or $77,381 at 6%.
201227$1,394,220$163,329$23,333iApproximate average salary by contribution assumption: employee only about $583,318 at 4% or $388,879 at 6%; with 50% employer match about $388,879 at 4% or $259,252 at 6%; with 100% employer match about $291,659 at 4% or $194,439 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-7$1,328,777$97,886$13,984iApproximate average salary by contribution assumption: employee only about $349,593 at 4% or $233,062 at 6%; with 50% employer match about $233,062 at 4% or $155,375 at 6%; with 100% employer match about $174,796 at 4% or $116,531 at 6%.
DAVID L. HAMEL, D.D.S., P.A. DEFINED BENEFIT CASH-7$65,443$65,443$9,349iApproximate average salary by contribution assumption: employee only about $233,725 at 4% or $155,817 at 6%; with 50% employer match about $155,817 at 4% or $103,878 at 6%; with 100% employer match about $116,863 at 4% or $77,908 at 6%.
201117$1,128,088$91,896$13,128iApproximate average salary by contribution assumption: employee only about $328,200 at 4% or $218,800 at 6%; with 50% employer match about $218,800 at 4% or $145,867 at 6%; with 100% employer match about $164,100 at 4% or $109,400 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-7$1,128,088$91,896$13,128iApproximate average salary by contribution assumption: employee only about $328,200 at 4% or $218,800 at 6%; with 50% employer match about $218,800 at 4% or $145,867 at 6%; with 100% employer match about $164,100 at 4% or $109,400 at 6%.
201018$1,036,920$91,592$11,449iApproximate average salary by contribution assumption: employee only about $286,225 at 4% or $190,817 at 6%; with 50% employer match about $190,817 at 4% or $127,211 at 6%; with 100% employer match about $143,113 at 4% or $95,408 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-8$1,036,920$91,592$11,449iApproximate average salary by contribution assumption: employee only about $286,225 at 4% or $190,817 at 6%; with 50% employer match about $190,817 at 4% or $127,211 at 6%; with 100% employer match about $143,113 at 4% or $95,408 at 6%.
200916$871,105$88,532$14,755iApproximate average salary by contribution assumption: employee only about $368,883 at 4% or $245,922 at 6%; with 50% employer match about $245,922 at 4% or $163,948 at 6%; with 100% employer match about $184,442 at 4% or $122,961 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-6$871,105$88,532$14,755iApproximate average salary by contribution assumption: employee only about $368,883 at 4% or $245,922 at 6%; with 50% employer match about $245,922 at 4% or $163,948 at 6%; with 100% employer match about $184,442 at 4% or $122,961 at 6%.
200816$687,348$85,075$14,179iApproximate average salary by contribution assumption: employee only about $354,479 at 4% or $236,319 at 6%; with 50% employer match about $236,319 at 4% or $157,546 at 6%; with 100% employer match about $177,240 at 4% or $118,160 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-6$687,348$85,075$14,179iApproximate average salary by contribution assumption: employee only about $354,479 at 4% or $236,319 at 6%; with 50% employer match about $236,319 at 4% or $157,546 at 6%; with 100% employer match about $177,240 at 4% or $118,160 at 6%.
200715$0$0-
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-5---
200616$954,200$84,603$14,101iApproximate average salary by contribution assumption: employee only about $352,513 at 4% or $235,008 at 6%; with 50% employer match about $235,008 at 4% or $156,672 at 6%; with 100% employer match about $176,256 at 4% or $117,504 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-6$954,200$84,603$14,101iApproximate average salary by contribution assumption: employee only about $352,513 at 4% or $235,008 at 6%; with 50% employer match about $235,008 at 4% or $156,672 at 6%; with 100% employer match about $176,256 at 4% or $117,504 at 6%.
200516$848,842$82,715$13,786iApproximate average salary by contribution assumption: employee only about $344,646 at 4% or $229,764 at 6%; with 50% employer match about $229,764 at 4% or $153,176 at 6%; with 100% employer match about $172,323 at 4% or $114,882 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-6$848,842$82,715$13,786iApproximate average salary by contribution assumption: employee only about $344,646 at 4% or $229,764 at 6%; with 50% employer match about $229,764 at 4% or $153,176 at 6%; with 100% employer match about $172,323 at 4% or $114,882 at 6%.
200416$719,430$98,548$16,425iApproximate average salary by contribution assumption: employee only about $410,617 at 4% or $273,744 at 6%; with 50% employer match about $273,744 at 4% or $182,496 at 6%; with 100% employer match about $205,308 at 4% or $136,872 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-6$719,430$98,548$16,425iApproximate average salary by contribution assumption: employee only about $410,617 at 4% or $273,744 at 6%; with 50% employer match about $273,744 at 4% or $182,496 at 6%; with 100% employer match about $205,308 at 4% or $136,872 at 6%.
200316$532,044$73,881$12,314iApproximate average salary by contribution assumption: employee only about $307,838 at 4% or $205,225 at 6%; with 50% employer match about $205,225 at 4% or $136,817 at 6%; with 100% employer match about $153,919 at 4% or $102,613 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-6$532,044$73,881$12,314iApproximate average salary by contribution assumption: employee only about $307,838 at 4% or $205,225 at 6%; with 50% employer match about $205,225 at 4% or $136,817 at 6%; with 100% employer match about $153,919 at 4% or $102,613 at 6%.
200217$333,184$71,456$10,208iApproximate average salary by contribution assumption: employee only about $255,200 at 4% or $170,133 at 6%; with 50% employer match about $170,133 at 4% or $113,422 at 6%; with 100% employer match about $127,600 at 4% or $85,067 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-7$333,184$71,456$10,208iApproximate average salary by contribution assumption: employee only about $255,200 at 4% or $170,133 at 6%; with 50% employer match about $170,133 at 4% or $113,422 at 6%; with 100% employer match about $127,600 at 4% or $85,067 at 6%.
200117$326,737$44,144$6,306iApproximate average salary by contribution assumption: employee only about $157,657 at 4% or $105,105 at 6%; with 50% employer match about $105,105 at 4% or $70,070 at 6%; with 100% employer match about $78,829 at 4% or $52,552 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-7$326,737$44,144$6,306iApproximate average salary by contribution assumption: employee only about $157,657 at 4% or $105,105 at 6%; with 50% employer match about $105,105 at 4% or $70,070 at 6%; with 100% employer match about $78,829 at 4% or $52,552 at 6%.
200016$297,839$38,288$6,381iApproximate average salary by contribution assumption: employee only about $159,533 at 4% or $106,356 at 6%; with 50% employer match about $106,356 at 4% or $70,904 at 6%; with 100% employer match about $79,767 at 4% or $53,178 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-6$297,839$38,288$6,381iApproximate average salary by contribution assumption: employee only about $159,533 at 4% or $106,356 at 6%; with 50% employer match about $106,356 at 4% or $70,904 at 6%; with 100% employer match about $79,767 at 4% or $53,178 at 6%.
199919$269,053$27,020$3,002iApproximate average salary by contribution assumption: employee only about $75,056 at 4% or $50,037 at 6%; with 50% employer match about $50,037 at 4% or $33,358 at 6%; with 100% employer match about $37,528 at 4% or $25,019 at 6%.
David L. Hamel, D.D.S., P.A. 401K Profit Sharing Plan & Trust-9$269,053$27,020$3,002iApproximate average salary by contribution assumption: employee only about $75,056 at 4% or $50,037 at 6%; with 50% employer match about $50,037 at 4% or $33,358 at 6%; with 100% employer match about $37,528 at 4% or $25,019 at 6%.