Civic Intelligence

Alan Spiegelman

Plan context: Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan

EIN 94-3095355 • San Francisco, CA • 17 filings • 8 plans

111 Sutter Street, Suite 1800San Francisco, CA 94104
Current Snapshot

Latest Year

2013

2013 Participants

6

2013 Assets

$1,337,544

2013 Contributions

$376,308

Historical Graphs

Total Assets Over Time

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

$1,337,544$668,772$0200320092012YearValue
$1,337,544Latest year 2012

Participants Over Time

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

630200320082012YearValue
6Latest year 2012

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
201310$0$0-
Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan-0$0--
201226$1,337,544$376,308$62,718iApproximate average salary by contribution assumption: employee only about $1,567,950 at 4% or $1,045,300 at 6%; with 50% employer match about $1,045,300 at 4% or $696,867 at 6%; with 100% employer match about $783,975 at 4% or $522,650 at 6%.
Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan-6$1,337,544$376,308$62,718iApproximate average salary by contribution assumption: employee only about $1,567,950 at 4% or $1,045,300 at 6%; with 50% employer match about $1,045,300 at 4% or $696,867 at 6%; with 100% employer match about $783,975 at 4% or $522,650 at 6%.
ALAN SPIEGELMAN DEFINED BENEFIT PENSION PLAN-0$0$0-
201125$1,145,603$15,325$3,065iApproximate average salary by contribution assumption: employee only about $76,625 at 4% or $51,083 at 6%; with 50% employer match about $51,083 at 4% or $34,056 at 6%; with 100% employer match about $38,313 at 4% or $25,542 at 6%.
Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan-5$843,063$15,325$3,065iApproximate average salary by contribution assumption: employee only about $76,625 at 4% or $51,083 at 6%; with 50% employer match about $51,083 at 4% or $34,056 at 6%; with 100% employer match about $38,313 at 4% or $25,542 at 6%.
ALAN SPIEGELMAN DEFINED BENEFIT PENSION PLAN-5$302,540$0-
201025$1,161,902$30,653$6,131iApproximate average salary by contribution assumption: employee only about $153,265 at 4% or $102,177 at 6%; with 50% employer match about $102,177 at 4% or $68,118 at 6%; with 100% employer match about $76,633 at 4% or $51,088 at 6%.
Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan-5$847,761$30,653$6,131iApproximate average salary by contribution assumption: employee only about $153,265 at 4% or $102,177 at 6%; with 50% employer match about $102,177 at 4% or $68,118 at 6%; with 100% employer match about $76,633 at 4% or $51,088 at 6%.
ALAN SPIEGELMAN DEFINED BENEFIT PENSION PLAN-5$314,141$0-
200925$997,853$56,109$11,222iApproximate average salary by contribution assumption: employee only about $280,545 at 4% or $187,030 at 6%; with 50% employer match about $187,030 at 4% or $124,687 at 6%; with 100% employer match about $140,273 at 4% or $93,515 at 6%.
Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan-5$718,783$25,500$5,100iApproximate average salary by contribution assumption: employee only about $127,500 at 4% or $85,000 at 6%; with 50% employer match about $85,000 at 4% or $56,667 at 6%; with 100% employer match about $63,750 at 4% or $42,500 at 6%.
ALAN SPIEGELMAN DEFINED BENEFIT PLAN-5$279,070$30,609$6,122iApproximate average salary by contribution assumption: employee only about $153,045 at 4% or $102,030 at 6%; with 50% employer match about $102,030 at 4% or $68,020 at 6%; with 100% employer match about $76,523 at 4% or $51,015 at 6%.
200826$0$0-
ALAN SPIEGELMAN DEFINED BENEFIT PLAN-6---
Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan-6---
200725$0$0-
Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan-5---
ALAN SPIEGELMAN DEFINED BENEFIT PLAN-5---
200615$582,619$47,295$9,459iApproximate average salary by contribution assumption: employee only about $236,475 at 4% or $157,650 at 6%; with 50% employer match about $157,650 at 4% or $105,100 at 6%; with 100% employer match about $118,238 at 4% or $78,825 at 6%.
Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan-5$582,619$47,295$9,459iApproximate average salary by contribution assumption: employee only about $236,475 at 4% or $157,650 at 6%; with 50% employer match about $157,650 at 4% or $105,100 at 6%; with 100% employer match about $118,238 at 4% or $78,825 at 6%.
200514$517,793$35,900$8,975iApproximate average salary by contribution assumption: employee only about $224,375 at 4% or $149,583 at 6%; with 50% employer match about $149,583 at 4% or $99,722 at 6%; with 100% employer match about $112,188 at 4% or $74,792 at 6%.
Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan-4$517,793$35,900$8,975iApproximate average salary by contribution assumption: employee only about $224,375 at 4% or $149,583 at 6%; with 50% employer match about $149,583 at 4% or $99,722 at 6%; with 100% employer match about $112,188 at 4% or $74,792 at 6%.
200414$444,725$22,251$5,563iApproximate average salary by contribution assumption: employee only about $139,069 at 4% or $92,713 at 6%; with 50% employer match about $92,713 at 4% or $61,808 at 6%; with 100% employer match about $69,534 at 4% or $46,356 at 6%.
Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan-4$444,725$22,251$5,563iApproximate average salary by contribution assumption: employee only about $139,069 at 4% or $92,713 at 6%; with 50% employer match about $92,713 at 4% or $61,808 at 6%; with 100% employer match about $69,534 at 4% or $46,356 at 6%.
200314$385,820$329,654$82,414iApproximate average salary by contribution assumption: employee only about $2,060,338 at 4% or $1,373,558 at 6%; with 50% employer match about $1,373,558 at 4% or $915,706 at 6%; with 100% employer match about $1,030,169 at 4% or $686,779 at 6%.
Alan Spiegelman 401(K) Age Weighted Profit Sharing Plan-4$385,820$329,654$82,414iApproximate average salary by contribution assumption: employee only about $2,060,338 at 4% or $1,373,558 at 6%; with 50% employer match about $1,373,558 at 4% or $915,706 at 6%; with 100% employer match about $1,030,169 at 4% or $686,779 at 6%.