Civic Intelligence

John W. Sparkman, D.D.S. Inc.

Plan context: John W. Sparkman, D.D.S. Inc. Defined Benefit Pension Plan and Trust

EIN 75-1682166 • Pampa, TX • 17 filings • 2 plans

2401 N. HobartPampa, TX 79065-2723
Current Snapshot

Latest Year

2014

2014 Participants

6

2014 Assets

$1,726,365

2014 Contributions

$185,000

Historical Graphs

Total Assets Over Time

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

$1,726,365$863,183$0199920082013YearValue
$1,726,365Latest year 2013

Participants Over Time

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

630199920072013YearValue
6Latest year 2013

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
201410$0$0-
John W. Sparkman, D.D.S. Inc. Defined Benefit Pension Plan and Trust-0$0--
201316$1,726,365$185,000$30,833iApproximate average salary by contribution assumption: employee only about $770,833 at 4% or $513,889 at 6%; with 50% employer match about $513,889 at 4% or $342,593 at 6%; with 100% employer match about $385,417 at 4% or $256,944 at 6%.
John W. Sparkman, D.D.S. Inc. Defined Benefit Pension Plan and Trust-6$1,726,365$185,000$30,833iApproximate average salary by contribution assumption: employee only about $770,833 at 4% or $513,889 at 6%; with 50% employer match about $513,889 at 4% or $342,593 at 6%; with 100% employer match about $385,417 at 4% or $256,944 at 6%.
201216$1,312,475$150,000$25,000iApproximate average salary by contribution assumption: employee only about $625,000 at 4% or $416,667 at 6%; with 50% employer match about $416,667 at 4% or $277,778 at 6%; with 100% employer match about $312,500 at 4% or $208,333 at 6%.
John W. Sparkman, D.D.S. Inc. Defined Benefit Pension Plan and Trust-6$1,312,475$150,000$25,000iApproximate average salary by contribution assumption: employee only about $625,000 at 4% or $416,667 at 6%; with 50% employer match about $416,667 at 4% or $277,778 at 6%; with 100% employer match about $312,500 at 4% or $208,333 at 6%.
201115$1,029,676$60,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%.
John W. Sparkman, D.D.S. Inc. Defined Benefit Pension Plan and Trust-5$1,029,676$60,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%.
201014$940,351$198,479$49,620iApproximate average salary by contribution assumption: employee only about $1,240,494 at 4% or $826,996 at 6%; with 50% employer match about $826,996 at 4% or $551,331 at 6%; with 100% employer match about $620,247 at 4% or $413,498 at 6%.
John W. Sparkman, D.D.S. Inc. Defined Benefit Pension Plan and Trust-4$940,351$198,479$49,620iApproximate average salary by contribution assumption: employee only about $1,240,494 at 4% or $826,996 at 6%; with 50% employer match about $826,996 at 4% or $551,331 at 6%; with 100% employer match about $620,247 at 4% or $413,498 at 6%.
200915$641,200$135,350$27,070iApproximate average salary by contribution assumption: employee only about $676,750 at 4% or $451,167 at 6%; with 50% employer match about $451,167 at 4% or $300,778 at 6%; with 100% employer match about $338,375 at 4% or $225,583 at 6%.
John W. Sparkman, D.D.S. Inc. Defined Benefit Pension Plan and Trust-5$641,200$135,350$27,070iApproximate average salary by contribution assumption: employee only about $676,750 at 4% or $451,167 at 6%; with 50% employer match about $451,167 at 4% or $300,778 at 6%; with 100% employer match about $338,375 at 4% or $225,583 at 6%.
200814$403,999$150,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%.
John W. Sparkman, D.D.S. Inc. Defined Benefit Pension Plan and Trust-4$403,999$150,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%.
200714$0$0-
John W. Sparkman, D.D.S. Inc. Defined Benefit Pension Plan and Trust-4---
200625$239,794$112,454$22,491iApproximate average salary by contribution assumption: employee only about $562,270 at 4% or $374,847 at 6%; with 50% employer match about $374,847 at 4% or $249,898 at 6%; with 100% employer match about $281,135 at 4% or $187,423 at 6%.
John W. Sparkman, D.D.S. Inc. Defined Benefit Pension Plan and Trust-5$239,794$112,454$22,491iApproximate average salary by contribution assumption: employee only about $562,270 at 4% or $374,847 at 6%; with 50% employer match about $374,847 at 4% or $249,898 at 6%; with 100% employer match about $281,135 at 4% or $187,423 at 6%.
John W. Sparkman, D.D.S. Inc. Profit Sharing Plan and Trust-0---
200524$638,993$107,726$26,932iApproximate average salary by contribution assumption: employee only about $673,288 at 4% or $448,858 at 6%; with 50% employer match about $448,858 at 4% or $299,239 at 6%; with 100% employer match about $336,644 at 4% or $224,429 at 6%.
John W. Sparkman, D.D.S. Inc. Profit Sharing Plan and Trust-4$531,267--
John W. Sparkman, D.D.S. Inc. Defined Benefit Pension Plan and Trust-4$107,726$107,726$26,932iApproximate average salary by contribution assumption: employee only about $673,288 at 4% or $448,858 at 6%; with 50% employer match about $448,858 at 4% or $299,239 at 6%; with 100% employer match about $336,644 at 4% or $224,429 at 6%.
200314$0$0-
John W. Sparkman, D.D.S. Inc. Profit Sharing Plan and Trust-4---
200214$277,212$44,881$11,220iApproximate average salary by contribution assumption: employee only about $280,506 at 4% or $187,004 at 6%; with 50% employer match about $187,004 at 4% or $124,669 at 6%; with 100% employer match about $140,253 at 4% or $93,502 at 6%.
John W. Sparkman, D.D.S. Inc. Profit Sharing Plan and Trust-4$277,212$44,881$11,220iApproximate average salary by contribution assumption: employee only about $280,506 at 4% or $187,004 at 6%; with 50% employer match about $187,004 at 4% or $124,669 at 6%; with 100% employer match about $140,253 at 4% or $93,502 at 6%.
200111$285,896$25,500$25,500iApproximate average salary by contribution assumption: employee only about $637,500 at 4% or $425,000 at 6%; with 50% employer match about $425,000 at 4% or $283,333 at 6%; with 100% employer match about $318,750 at 4% or $212,500 at 6%.
John W. Sparkman, D.D.S. Inc. Profit Sharing Plan and Trust-1$285,896$25,500$25,500iApproximate average salary by contribution assumption: employee only about $637,500 at 4% or $425,000 at 6%; with 50% employer match about $425,000 at 4% or $283,333 at 6%; with 100% employer match about $318,750 at 4% or $212,500 at 6%.
200011$314,081$13,050$13,050iApproximate average salary by contribution assumption: employee only about $326,250 at 4% or $217,500 at 6%; with 50% employer match about $217,500 at 4% or $145,000 at 6%; with 100% employer match about $163,125 at 4% or $108,750 at 6%.
John W. Sparkman, D.D.S. Inc. Profit Sharing Plan and Trust-1$314,081$13,050$13,050iApproximate average salary by contribution assumption: employee only about $326,250 at 4% or $217,500 at 6%; with 50% employer match about $217,500 at 4% or $145,000 at 6%; with 100% employer match about $163,125 at 4% or $108,750 at 6%.
199911$309,916$23,400$23,400iApproximate average salary by contribution assumption: employee only about $585,000 at 4% or $390,000 at 6%; with 50% employer match about $390,000 at 4% or $260,000 at 6%; with 100% employer match about $292,500 at 4% or $195,000 at 6%.
John W. Sparkman, D.D.S. Inc. Profit Sharing Plan and Trust-1$309,916$23,400$23,400iApproximate average salary by contribution assumption: employee only about $585,000 at 4% or $390,000 at 6%; with 50% employer match about $390,000 at 4% or $260,000 at 6%; with 100% employer match about $292,500 at 4% or $195,000 at 6%.