Civic Intelligence

William H. Shibata, D.D.S.

Plan context: WILLIAM H. SHIBATA, D.D.S. 401(K) PROFIT SHARING PLAN

EIN 33-0180795 • Cathedral City, CA • 26 filings • 4 plans

34400 Date Palm Drive, #ECathedral City, CA 92234
Current Snapshot

Latest Year

2019

2019 Participants

1

2019 Assets

$2,728,180

2019 Contributions

$20,000

Historical Graphs

Total Assets Over Time

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

$2,728,180$1,364,090$0199920102019YearValue
$2,728,180Latest year 2019

Participants Over Time

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

530199920092019YearValue
1Latest 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
201911$2,728,180$20,000$20,000iApproximate average salary by contribution assumption: employee only about $500,000 at 4% or $333,333 at 6%; with 50% employer match about $333,333 at 4% or $222,222 at 6%; with 100% employer match about $250,000 at 4% or $166,667 at 6%.
WILLIAM H. SHIBATA, D.D.S. 401(K) PROFIT SHARING PLAN-1$2,728,180$20,000$20,000iApproximate average salary by contribution assumption: employee only about $500,000 at 4% or $333,333 at 6%; with 50% employer match about $333,333 at 4% or $222,222 at 6%; with 100% employer match about $250,000 at 4% or $166,667 at 6%.
201821$2,474,414$2,499,782$2,499,782iApproximate average salary by contribution assumption: employee only about $62,494,550 at 4% or $41,663,033 at 6%; with 50% employer match about $41,663,033 at 4% or $27,775,356 at 6%; with 100% employer match about $31,247,275 at 4% or $20,831,517 at 6%.
WILLIAM H. SHIBATA, D.D.S. 401(K) PROFIT SHARING PLAN-1$2,474,414$2,499,782$2,499,782iApproximate average salary by contribution assumption: employee only about $62,494,550 at 4% or $41,663,033 at 6%; with 50% employer match about $41,663,033 at 4% or $27,775,356 at 6%; with 100% employer match about $31,247,275 at 4% or $20,831,517 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-0$0$0-
201713$1,689,409$0-
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-3$1,689,409$0-
201613$1,683,757$90,000$30,000iApproximate average salary by contribution assumption: employee only about $750,000 at 4% or $500,000 at 6%; with 50% employer match about $500,000 at 4% or $333,333 at 6%; with 100% employer match about $375,000 at 4% or $250,000 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-3$1,683,757$90,000$30,000iApproximate average salary by contribution assumption: employee only about $750,000 at 4% or $500,000 at 6%; with 50% employer match about $500,000 at 4% or $333,333 at 6%; with 100% employer match about $375,000 at 4% or $250,000 at 6%.
201514$1,588,520$80,000$20,000iApproximate average salary by contribution assumption: employee only about $500,000 at 4% or $333,333 at 6%; with 50% employer match about $333,333 at 4% or $222,222 at 6%; with 100% employer match about $250,000 at 4% or $166,667 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-4$1,588,520$80,000$20,000iApproximate average salary by contribution assumption: employee only about $500,000 at 4% or $333,333 at 6%; with 50% employer match about $333,333 at 4% or $222,222 at 6%; with 100% employer match about $250,000 at 4% or $166,667 at 6%.
201414$1,503,039$70,000$17,500iApproximate average salary by contribution assumption: employee only about $437,500 at 4% or $291,667 at 6%; with 50% employer match about $291,667 at 4% or $194,444 at 6%; with 100% employer match about $218,750 at 4% or $145,833 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-4$1,503,039$70,000$17,500iApproximate average salary by contribution assumption: employee only about $437,500 at 4% or $291,667 at 6%; with 50% employer match about $291,667 at 4% or $194,444 at 6%; with 100% employer match about $218,750 at 4% or $145,833 at 6%.
201314$1,427,344$80,000$20,000iApproximate average salary by contribution assumption: employee only about $500,000 at 4% or $333,333 at 6%; with 50% employer match about $333,333 at 4% or $222,222 at 6%; with 100% employer match about $250,000 at 4% or $166,667 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-4$1,427,344$80,000$20,000iApproximate average salary by contribution assumption: employee only about $500,000 at 4% or $333,333 at 6%; with 50% employer match about $333,333 at 4% or $222,222 at 6%; with 100% employer match about $250,000 at 4% or $166,667 at 6%.
201214$1,342,468$120,000$30,000iApproximate average salary by contribution assumption: employee only about $750,000 at 4% or $500,000 at 6%; with 50% employer match about $500,000 at 4% or $333,333 at 6%; with 100% employer match about $375,000 at 4% or $250,000 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-4$1,342,468$120,000$30,000iApproximate average salary by contribution assumption: employee only about $750,000 at 4% or $500,000 at 6%; with 50% employer match about $500,000 at 4% or $333,333 at 6%; with 100% employer match about $375,000 at 4% or $250,000 at 6%.
201112$1,217,061$150,000$75,000iApproximate average salary by contribution assumption: employee only about $1,875,000 at 4% or $1,250,000 at 6%; with 50% employer match about $1,250,000 at 4% or $833,333 at 6%; with 100% employer match about $937,500 at 4% or $625,000 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-2$1,217,061$150,000$75,000iApproximate average salary by contribution assumption: employee only about $1,875,000 at 4% or $1,250,000 at 6%; with 50% employer match about $1,250,000 at 4% or $833,333 at 6%; with 100% employer match about $937,500 at 4% or $625,000 at 6%.
201012$1,063,361$200,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%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-2$1,063,361$200,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%.
200915$873,081$150,000$30,000iApproximate average salary by contribution assumption: employee only about $750,000 at 4% or $500,000 at 6%; with 50% employer match about $500,000 at 4% or $333,333 at 6%; with 100% employer match about $375,000 at 4% or $250,000 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-5$873,081$150,000$30,000iApproximate average salary by contribution assumption: employee only about $750,000 at 4% or $500,000 at 6%; with 50% employer match about $500,000 at 4% or $333,333 at 6%; with 100% employer match about $375,000 at 4% or $250,000 at 6%.
200811$716,632$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%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-1$716,632$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%.
200711$0$0-
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-1---
200613$502,347$97,211$32,404iApproximate average salary by contribution assumption: employee only about $810,092 at 4% or $540,061 at 6%; with 50% employer match about $540,061 at 4% or $360,041 at 6%; with 100% employer match about $405,046 at 4% or $270,031 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-3$502,347$97,211$32,404iApproximate average salary by contribution assumption: employee only about $810,092 at 4% or $540,061 at 6%; with 50% employer match about $540,061 at 4% or $360,041 at 6%; with 100% employer match about $405,046 at 4% or $270,031 at 6%.
200513$399,727$93,873$31,291iApproximate average salary by contribution assumption: employee only about $782,275 at 4% or $521,517 at 6%; with 50% employer match about $521,517 at 4% or $347,678 at 6%; with 100% employer match about $391,138 at 4% or $260,758 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-3$399,727$93,873$31,291iApproximate average salary by contribution assumption: employee only about $782,275 at 4% or $521,517 at 6%; with 50% employer match about $521,517 at 4% or $347,678 at 6%; with 100% employer match about $391,138 at 4% or $260,758 at 6%.
200411$302,317$84,584$84,584iApproximate average salary by contribution assumption: employee only about $2,114,600 at 4% or $1,409,733 at 6%; with 50% employer match about $1,409,733 at 4% or $939,822 at 6%; with 100% employer match about $1,057,300 at 4% or $704,867 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-1$302,317$84,584$84,584iApproximate average salary by contribution assumption: employee only about $2,114,600 at 4% or $1,409,733 at 6%; with 50% employer match about $1,409,733 at 4% or $939,822 at 6%; with 100% employer match about $1,057,300 at 4% or $704,867 at 6%.
200312$215,993$75,564$37,782iApproximate average salary by contribution assumption: employee only about $944,550 at 4% or $629,700 at 6%; with 50% employer match about $629,700 at 4% or $419,800 at 6%; with 100% employer match about $472,275 at 4% or $314,850 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-2$215,993$75,564$37,782iApproximate average salary by contribution assumption: employee only about $944,550 at 4% or $629,700 at 6%; with 50% employer match about $629,700 at 4% or $419,800 at 6%; with 100% employer match about $472,275 at 4% or $314,850 at 6%.
200212$164,414$55,343$27,672iApproximate average salary by contribution assumption: employee only about $691,788 at 4% or $461,192 at 6%; with 50% employer match about $461,192 at 4% or $307,461 at 6%; with 100% employer match about $345,894 at 4% or $230,596 at 6%.
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-2$164,414$55,343$27,672iApproximate average salary by contribution assumption: employee only about $691,788 at 4% or $461,192 at 6%; with 50% employer match about $461,192 at 4% or $307,461 at 6%; with 100% employer match about $345,894 at 4% or $230,596 at 6%.
200133$0$0-
WILLIAM H. SHIBATA, D.D.S. MONEY PURCHASE PLAN-0---
William H. Shibata, D.D.S. Profit Sharing Plan-0---
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-3---
200032$427,050$56,892$28,446iApproximate average salary by contribution assumption: employee only about $711,150 at 4% or $474,100 at 6%; with 50% employer match about $474,100 at 4% or $316,067 at 6%; with 100% employer match about $355,575 at 4% or $237,050 at 6%.
William H. Shibata, D.D.S. Profit Sharing Plan-1$272,210--
WILLIAM H. SHIBATA, D.D.S. MONEY PURCHASE PLAN-1$97,948--
WILLIAM H. SHIBATA, D.D.S. DEFINED BENEFIT PENSION PLAN-2$56,892$56,892$28,446iApproximate average salary by contribution assumption: employee only about $711,150 at 4% or $474,100 at 6%; with 50% employer match about $474,100 at 4% or $316,067 at 6%; with 100% employer match about $355,575 at 4% or $237,050 at 6%.
199912$782,589$37,346$18,673iApproximate average salary by contribution assumption: employee only about $466,825 at 4% or $311,217 at 6%; with 50% employer match about $311,217 at 4% or $207,478 at 6%; with 100% employer match about $233,413 at 4% or $155,608 at 6%.
William H. Shibata, D.D.S. Profit Sharing Plan-2$782,589$37,346$18,673iApproximate average salary by contribution assumption: employee only about $466,825 at 4% or $311,217 at 6%; with 50% employer match about $311,217 at 4% or $207,478 at 6%; with 100% employer match about $233,413 at 4% or $155,608 at 6%.