Civic Intelligence

Joshua C H Tan MD Inc

Plan context: Joshua C H Tan MD Inc Profit-Sharing Plan

EIN 99-0334984 • Honolulu, HI • 22 filings • 3 plans

550 South Beretania St 608Honolulu, HI 96813
Current Snapshot

Latest Year

2021

2021 Participants

1

2021 Assets

$36,117

2021 Contributions

$63,000

Historical Graphs

Total Assets Over Time

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

$1,438,755$719,378$0200020112020YearValue
$36,117Latest year 2020

Participants Over Time

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

420200020102020YearValue
1Latest 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
202110$0$0-
Joshua C H Tan MD Inc Profit-Sharing Plan-0---
202011$36,117$0-
Joshua C H Tan MD Inc Profit-Sharing Plan-1$36,117--
201913$1,438,755$0-
Joshua C H Tan MD Inc Profit-Sharing Plan-3$1,438,755--
201813$1,269,834$63,000$21,000iApproximate average salary by contribution assumption: employee only about $525,000 at 4% or $350,000 at 6%; with 50% employer match about $350,000 at 4% or $233,333 at 6%; with 100% employer match about $262,500 at 4% or $175,000 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-3$1,269,834$63,000$21,000iApproximate average salary by contribution assumption: employee only about $525,000 at 4% or $350,000 at 6%; with 50% employer match about $350,000 at 4% or $233,333 at 6%; with 100% employer match about $262,500 at 4% or $175,000 at 6%.
201713$1,224,548$60,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%.
Joshua C H Tan MD Inc Profit-Sharing Plan-3$1,224,548$60,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%.
201613$1,042,449$64,877$21,626iApproximate average salary by contribution assumption: employee only about $540,642 at 4% or $360,428 at 6%; with 50% employer match about $360,428 at 4% or $240,285 at 6%; with 100% employer match about $270,321 at 4% or $180,214 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-3$1,042,449$64,877$21,626iApproximate average salary by contribution assumption: employee only about $540,642 at 4% or $360,428 at 6%; with 50% employer match about $360,428 at 4% or $240,285 at 6%; with 100% employer match about $270,321 at 4% or $180,214 at 6%.
201513$985,420$60,109$20,036iApproximate average salary by contribution assumption: employee only about $500,908 at 4% or $333,939 at 6%; with 50% employer match about $333,939 at 4% or $222,626 at 6%; with 100% employer match about $250,454 at 4% or $166,969 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-3$985,420$60,109$20,036iApproximate average salary by contribution assumption: employee only about $500,908 at 4% or $333,939 at 6%; with 50% employer match about $333,939 at 4% or $222,626 at 6%; with 100% employer match about $250,454 at 4% or $166,969 at 6%.
201413$911,258$60,803$20,268iApproximate average salary by contribution assumption: employee only about $506,692 at 4% or $337,794 at 6%; with 50% employer match about $337,794 at 4% or $225,196 at 6%; with 100% employer match about $253,346 at 4% or $168,897 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-3$911,258$60,803$20,268iApproximate average salary by contribution assumption: employee only about $506,692 at 4% or $337,794 at 6%; with 50% employer match about $337,794 at 4% or $225,196 at 6%; with 100% employer match about $253,346 at 4% or $168,897 at 6%.
201314$839,930$59,450$14,863iApproximate average salary by contribution assumption: employee only about $371,563 at 4% or $247,708 at 6%; with 50% employer match about $247,708 at 4% or $165,139 at 6%; with 100% employer match about $185,781 at 4% or $123,854 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-4$839,930$59,450$14,863iApproximate average salary by contribution assumption: employee only about $371,563 at 4% or $247,708 at 6%; with 50% employer match about $247,708 at 4% or $165,139 at 6%; with 100% employer match about $185,781 at 4% or $123,854 at 6%.
201214$773,255$59,000$14,750iApproximate average salary by contribution assumption: employee only about $368,750 at 4% or $245,833 at 6%; with 50% employer match about $245,833 at 4% or $163,889 at 6%; with 100% employer match about $184,375 at 4% or $122,917 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-4$773,255$59,000$14,750iApproximate average salary by contribution assumption: employee only about $368,750 at 4% or $245,833 at 6%; with 50% employer match about $245,833 at 4% or $163,889 at 6%; with 100% employer match about $184,375 at 4% or $122,917 at 6%.
201114$663,740$58,000$14,500iApproximate average salary by contribution assumption: employee only about $362,500 at 4% or $241,667 at 6%; with 50% employer match about $241,667 at 4% or $161,111 at 6%; with 100% employer match about $181,250 at 4% or $120,833 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-4$663,740$58,000$14,500iApproximate average salary by contribution assumption: employee only about $362,500 at 4% or $241,667 at 6%; with 50% employer match about $241,667 at 4% or $161,111 at 6%; with 100% employer match about $181,250 at 4% or $120,833 at 6%.
201014$536,643$58,000$14,500iApproximate average salary by contribution assumption: employee only about $362,500 at 4% or $241,667 at 6%; with 50% employer match about $241,667 at 4% or $161,111 at 6%; with 100% employer match about $181,250 at 4% or $120,833 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-4$536,643$58,000$14,500iApproximate average salary by contribution assumption: employee only about $362,500 at 4% or $241,667 at 6%; with 50% employer match about $241,667 at 4% or $161,111 at 6%; with 100% employer match about $181,250 at 4% or $120,833 at 6%.
200914$456,642$58,000$14,500iApproximate average salary by contribution assumption: employee only about $362,500 at 4% or $241,667 at 6%; with 50% employer match about $241,667 at 4% or $161,111 at 6%; with 100% employer match about $181,250 at 4% or $120,833 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-4$456,642$58,000$14,500iApproximate average salary by contribution assumption: employee only about $362,500 at 4% or $241,667 at 6%; with 50% employer match about $241,667 at 4% or $161,111 at 6%; with 100% employer match about $181,250 at 4% or $120,833 at 6%.
200814$337,433$55,823$13,956iApproximate average salary by contribution assumption: employee only about $348,894 at 4% or $232,596 at 6%; with 50% employer match about $232,596 at 4% or $155,064 at 6%; with 100% employer match about $174,447 at 4% or $116,298 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-4$337,433$55,823$13,956iApproximate average salary by contribution assumption: employee only about $348,894 at 4% or $232,596 at 6%; with 50% employer match about $232,596 at 4% or $155,064 at 6%; with 100% employer match about $174,447 at 4% or $116,298 at 6%.
200714$0$0-
Joshua C H Tan MD Inc Profit-Sharing Plan-4---
200614$307,908$46,000$11,500iApproximate average salary by contribution assumption: employee only about $287,500 at 4% or $191,667 at 6%; with 50% employer match about $191,667 at 4% or $127,778 at 6%; with 100% employer match about $143,750 at 4% or $95,833 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-4$307,908$46,000$11,500iApproximate average salary by contribution assumption: employee only about $287,500 at 4% or $191,667 at 6%; with 50% employer match about $191,667 at 4% or $127,778 at 6%; with 100% employer match about $143,750 at 4% or $95,833 at 6%.
200514$238,316$45,000$11,250iApproximate average salary by contribution assumption: employee only about $281,250 at 4% or $187,500 at 6%; with 50% employer match about $187,500 at 4% or $125,000 at 6%; with 100% employer match about $140,625 at 4% or $93,750 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-4$238,316$45,000$11,250iApproximate average salary by contribution assumption: employee only about $281,250 at 4% or $187,500 at 6%; with 50% employer match about $187,500 at 4% or $125,000 at 6%; with 100% employer match about $140,625 at 4% or $93,750 at 6%.
200414$182,370$45,000$11,250iApproximate average salary by contribution assumption: employee only about $281,250 at 4% or $187,500 at 6%; with 50% employer match about $187,500 at 4% or $125,000 at 6%; with 100% employer match about $140,625 at 4% or $93,750 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-4$182,370$45,000$11,250iApproximate average salary by contribution assumption: employee only about $281,250 at 4% or $187,500 at 6%; with 50% employer match about $187,500 at 4% or $125,000 at 6%; with 100% employer match about $140,625 at 4% or $93,750 at 6%.
200313$129,093$45,000$15,000iApproximate average salary by contribution assumption: employee only about $375,000 at 4% or $250,000 at 6%; with 50% employer match about $250,000 at 4% or $166,667 at 6%; with 100% employer match about $187,500 at 4% or $125,000 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-3$129,093$45,000$15,000iApproximate average salary by contribution assumption: employee only about $375,000 at 4% or $250,000 at 6%; with 50% employer match about $250,000 at 4% or $166,667 at 6%; with 100% employer match about $187,500 at 4% or $125,000 at 6%.
200214$81,744$37,000$9,250iApproximate average salary by contribution assumption: employee only about $231,250 at 4% or $154,167 at 6%; with 50% employer match about $154,167 at 4% or $102,778 at 6%; with 100% employer match about $115,625 at 4% or $77,083 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-4$81,744$37,000$9,250iApproximate average salary by contribution assumption: employee only about $231,250 at 4% or $154,167 at 6%; with 50% employer match about $154,167 at 4% or $102,778 at 6%; with 100% employer match about $115,625 at 4% or $77,083 at 6%.
200114$0$0-
Joshua C H Tan MD Inc Profit-Sharing Plan-4---
200014$63,297$33,000$8,250iApproximate average salary by contribution assumption: employee only about $206,250 at 4% or $137,500 at 6%; with 50% employer match about $137,500 at 4% or $91,667 at 6%; with 100% employer match about $103,125 at 4% or $68,750 at 6%.
Joshua C H Tan MD Inc Profit-Sharing Plan-4$63,297$33,000$8,250iApproximate average salary by contribution assumption: employee only about $206,250 at 4% or $137,500 at 6%; with 50% employer match about $137,500 at 4% or $91,667 at 6%; with 100% employer match about $103,125 at 4% or $68,750 at 6%.