Civic Intelligence

Charles W. Guerra, Dds

Plan context: Charles W. Guerra, Dds Target Benefit Plan

EIN 16-1044446 • Whitesboro, NY • 16 filings • 6 plans

79 Bedford DriveWhitesboro, NY 13492
Current Snapshot

Latest Year

2013

2013 Participants

3,125

2013 Assets

$1,250,929

2013 Contributions

$37,840

Historical Graphs

Total Assets Over Time

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

$1,250,929$625,465$0199920062012YearValue
$1,250,929Latest year 2012

Participants Over Time

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

3,1251,5630199920062013YearValue
3,125Latest 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
201323,125$0$0-
Charles W. Guerra, Dds Target Benefit Plan-3,125$0$0-
Charles W. Guerra, Dds Target Benefit Plan-0$0$0-
201213$1,250,929$37,840$12,613iApproximate average salary by contribution assumption: employee only about $315,333 at 4% or $210,222 at 6%; with 50% employer match about $210,222 at 4% or $140,148 at 6%; with 100% employer match about $157,667 at 4% or $105,111 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-3$1,250,929$37,840$12,613iApproximate average salary by contribution assumption: employee only about $315,333 at 4% or $210,222 at 6%; with 50% employer match about $210,222 at 4% or $140,148 at 6%; with 100% employer match about $157,667 at 4% or $105,111 at 6%.
201113$1,147,770$40,992$13,664iApproximate average salary by contribution assumption: employee only about $341,600 at 4% or $227,733 at 6%; with 50% employer match about $227,733 at 4% or $151,822 at 6%; with 100% employer match about $170,800 at 4% or $113,867 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-3$1,147,770$40,992$13,664iApproximate average salary by contribution assumption: employee only about $341,600 at 4% or $227,733 at 6%; with 50% employer match about $227,733 at 4% or $151,822 at 6%; with 100% employer match about $170,800 at 4% or $113,867 at 6%.
201013$1,093,034$36,551$12,184iApproximate average salary by contribution assumption: employee only about $304,592 at 4% or $203,061 at 6%; with 50% employer match about $203,061 at 4% or $135,374 at 6%; with 100% employer match about $152,296 at 4% or $101,531 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-3$1,093,034$36,551$12,184iApproximate average salary by contribution assumption: employee only about $304,592 at 4% or $203,061 at 6%; with 50% employer match about $203,061 at 4% or $135,374 at 6%; with 100% employer match about $152,296 at 4% or $101,531 at 6%.
200913$967,584$36,475$12,158iApproximate average salary by contribution assumption: employee only about $303,958 at 4% or $202,639 at 6%; with 50% employer match about $202,639 at 4% or $135,093 at 6%; with 100% employer match about $151,979 at 4% or $101,319 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-3$967,584$36,475$12,158iApproximate average salary by contribution assumption: employee only about $303,958 at 4% or $202,639 at 6%; with 50% employer match about $202,639 at 4% or $135,093 at 6%; with 100% employer match about $151,979 at 4% or $101,319 at 6%.
200813$815,396$46,174$15,391iApproximate average salary by contribution assumption: employee only about $384,783 at 4% or $256,522 at 6%; with 50% employer match about $256,522 at 4% or $171,015 at 6%; with 100% employer match about $192,392 at 4% or $128,261 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-3$815,396$46,174$15,391iApproximate average salary by contribution assumption: employee only about $384,783 at 4% or $256,522 at 6%; with 50% employer match about $256,522 at 4% or $171,015 at 6%; with 100% employer match about $192,392 at 4% or $128,261 at 6%.
200713$994,051$46,829$15,610iApproximate average salary by contribution assumption: employee only about $390,242 at 4% or $260,161 at 6%; with 50% employer match about $260,161 at 4% or $173,441 at 6%; with 100% employer match about $195,121 at 4% or $130,081 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-3$994,051$46,829$15,610iApproximate average salary by contribution assumption: employee only about $390,242 at 4% or $260,161 at 6%; with 50% employer match about $260,161 at 4% or $173,441 at 6%; with 100% employer match about $195,121 at 4% or $130,081 at 6%.
200613$911,132$49,707$16,569iApproximate average salary by contribution assumption: employee only about $414,225 at 4% or $276,150 at 6%; with 50% employer match about $276,150 at 4% or $184,100 at 6%; with 100% employer match about $207,113 at 4% or $138,075 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-3$911,132$49,707$16,569iApproximate average salary by contribution assumption: employee only about $414,225 at 4% or $276,150 at 6%; with 50% employer match about $276,150 at 4% or $184,100 at 6%; with 100% employer match about $207,113 at 4% or $138,075 at 6%.
200513$779,082$47,031$15,677iApproximate average salary by contribution assumption: employee only about $391,925 at 4% or $261,283 at 6%; with 50% employer match about $261,283 at 4% or $174,189 at 6%; with 100% employer match about $195,963 at 4% or $130,642 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-3$779,082$47,031$15,677iApproximate average salary by contribution assumption: employee only about $391,925 at 4% or $261,283 at 6%; with 50% employer match about $261,283 at 4% or $174,189 at 6%; with 100% employer match about $195,963 at 4% or $130,642 at 6%.
200413$712,152$45,600$15,200iApproximate average salary by contribution assumption: employee only about $380,000 at 4% or $253,333 at 6%; with 50% employer match about $253,333 at 4% or $168,889 at 6%; with 100% employer match about $190,000 at 4% or $126,667 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-3$712,152$45,600$15,200iApproximate average salary by contribution assumption: employee only about $380,000 at 4% or $253,333 at 6%; with 50% employer match about $253,333 at 4% or $168,889 at 6%; with 100% employer match about $190,000 at 4% or $126,667 at 6%.
200312$616,069$38,727$19,364iApproximate average salary by contribution assumption: employee only about $484,088 at 4% or $322,725 at 6%; with 50% employer match about $322,725 at 4% or $215,150 at 6%; with 100% employer match about $242,044 at 4% or $161,363 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-2$616,069$38,727$19,364iApproximate average salary by contribution assumption: employee only about $484,088 at 4% or $322,725 at 6%; with 50% employer match about $322,725 at 4% or $215,150 at 6%; with 100% employer match about $242,044 at 4% or $161,363 at 6%.
200212$485,635$41,909$20,955iApproximate average salary by contribution assumption: employee only about $523,863 at 4% or $349,242 at 6%; with 50% employer match about $349,242 at 4% or $232,828 at 6%; with 100% employer match about $261,931 at 4% or $174,621 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-2$485,635$41,909$20,955iApproximate average salary by contribution assumption: employee only about $523,863 at 4% or $349,242 at 6%; with 50% employer match about $349,242 at 4% or $232,828 at 6%; with 100% employer match about $261,931 at 4% or $174,621 at 6%.
200112$550,682$36,633$18,317iApproximate average salary by contribution assumption: employee only about $457,913 at 4% or $305,275 at 6%; with 50% employer match about $305,275 at 4% or $203,517 at 6%; with 100% employer match about $228,956 at 4% or $152,638 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-2$550,682$36,633$18,317iApproximate average salary by contribution assumption: employee only about $457,913 at 4% or $305,275 at 6%; with 50% employer match about $305,275 at 4% or $203,517 at 6%; with 100% employer match about $228,956 at 4% or $152,638 at 6%.
200013$575,002$33,614$11,205iApproximate average salary by contribution assumption: employee only about $280,117 at 4% or $186,744 at 6%; with 50% employer match about $186,744 at 4% or $124,496 at 6%; with 100% employer match about $140,058 at 4% or $93,372 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-3$575,002$33,614$11,205iApproximate average salary by contribution assumption: employee only about $280,117 at 4% or $186,744 at 6%; with 50% employer match about $186,744 at 4% or $124,496 at 6%; with 100% employer match about $140,058 at 4% or $93,372 at 6%.
199913$623,362$29,700$9,900iApproximate average salary by contribution assumption: employee only about $247,500 at 4% or $165,000 at 6%; with 50% employer match about $165,000 at 4% or $110,000 at 6%; with 100% employer match about $123,750 at 4% or $82,500 at 6%.
Charles W. Guerra, Dds Target Benefit Plan-3$623,362$29,700$9,900iApproximate average salary by contribution assumption: employee only about $247,500 at 4% or $165,000 at 6%; with 50% employer match about $165,000 at 4% or $110,000 at 6%; with 100% employer match about $123,750 at 4% or $82,500 at 6%.