Civic Intelligence

Ellen W. Lin M.D.

Plan context: Advanced Spine and Pain Center 401(K) Dtd 07/01/2007

EIN 26-0386592 • San Antonio, TX • 19 filings • 4 plans

21 Spurs Lane Suite 240San Antonio, TX 78240
Current Snapshot

Latest Year

2024

2024 Participants

47

2024 Assets

$1,884,097

2024 Contributions

$134,055

Historical Graphs

Total Assets Over Time

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

$1,884,097$942,049$0200820162024YearValue
$1,884,097Latest year 2024

Participants Over Time

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

47240200720162024YearValue
47Latest year 2024

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
2024147$1,884,097$134,055$2,852iApproximate average salary by contribution assumption: employee only about $71,306 at 4% or $47,537 at 6%; with 50% employer match about $47,537 at 4% or $31,691 at 6%; with 100% employer match about $35,653 at 4% or $23,769 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-47$1,884,097$134,055$2,852iApproximate average salary by contribution assumption: employee only about $71,306 at 4% or $47,537 at 6%; with 50% employer match about $47,537 at 4% or $31,691 at 6%; with 100% employer match about $35,653 at 4% or $23,769 at 6%.
2023145$1,523,751$165,929$3,687iApproximate average salary by contribution assumption: employee only about $92,183 at 4% or $61,455 at 6%; with 50% employer match about $61,455 at 4% or $40,970 at 6%; with 100% employer match about $46,091 at 4% or $30,728 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-45$1,523,751$165,929$3,687iApproximate average salary by contribution assumption: employee only about $92,183 at 4% or $61,455 at 6%; with 50% employer match about $61,455 at 4% or $40,970 at 6%; with 100% employer match about $46,091 at 4% or $30,728 at 6%.
2022145$1,395,459$232,804$5,173iApproximate average salary by contribution assumption: employee only about $129,336 at 4% or $86,224 at 6%; with 50% employer match about $86,224 at 4% or $57,482 at 6%; with 100% employer match about $64,668 at 4% or $43,112 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-45$1,395,459$232,804$5,173iApproximate average salary by contribution assumption: employee only about $129,336 at 4% or $86,224 at 6%; with 50% employer match about $86,224 at 4% or $57,482 at 6%; with 100% employer match about $64,668 at 4% or $43,112 at 6%.
2021135$1,513,404$463,399$13,240iApproximate average salary by contribution assumption: employee only about $330,999 at 4% or $220,666 at 6%; with 50% employer match about $220,666 at 4% or $147,111 at 6%; with 100% employer match about $165,500 at 4% or $110,333 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-35$1,513,404$463,399$13,240iApproximate average salary by contribution assumption: employee only about $330,999 at 4% or $220,666 at 6%; with 50% employer match about $220,666 at 4% or $147,111 at 6%; with 100% employer match about $165,500 at 4% or $110,333 at 6%.
2020129$908,123$106,438$3,670iApproximate average salary by contribution assumption: employee only about $91,757 at 4% or $61,171 at 6%; with 50% employer match about $61,171 at 4% or $40,781 at 6%; with 100% employer match about $45,878 at 4% or $30,586 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-29$908,123$106,438$3,670iApproximate average salary by contribution assumption: employee only about $91,757 at 4% or $61,171 at 6%; with 50% employer match about $61,171 at 4% or $40,781 at 6%; with 100% employer match about $45,878 at 4% or $30,586 at 6%.
2019125$659,867$89,750$3,590iApproximate average salary by contribution assumption: employee only about $89,750 at 4% or $59,833 at 6%; with 50% employer match about $59,833 at 4% or $39,889 at 6%; with 100% employer match about $44,875 at 4% or $29,917 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-25$659,867$89,750$3,590iApproximate average salary by contribution assumption: employee only about $89,750 at 4% or $59,833 at 6%; with 50% employer match about $59,833 at 4% or $39,889 at 6%; with 100% employer match about $44,875 at 4% or $29,917 at 6%.
2018126$591,605$154,471$5,941iApproximate average salary by contribution assumption: employee only about $148,530 at 4% or $99,020 at 6%; with 50% employer match about $99,020 at 4% or $66,013 at 6%; with 100% employer match about $74,265 at 4% or $49,510 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-26$591,605$154,471$5,941iApproximate average salary by contribution assumption: employee only about $148,530 at 4% or $99,020 at 6%; with 50% employer match about $99,020 at 4% or $66,013 at 6%; with 100% employer match about $74,265 at 4% or $49,510 at 6%.
2017122$492,241$83,335$3,788iApproximate average salary by contribution assumption: employee only about $94,699 at 4% or $63,133 at 6%; with 50% employer match about $63,133 at 4% or $42,088 at 6%; with 100% employer match about $47,349 at 4% or $31,566 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-22$492,241$83,335$3,788iApproximate average salary by contribution assumption: employee only about $94,699 at 4% or $63,133 at 6%; with 50% employer match about $63,133 at 4% or $42,088 at 6%; with 100% employer match about $47,349 at 4% or $31,566 at 6%.
2016120$358,297$66,458$3,323iApproximate average salary by contribution assumption: employee only about $83,073 at 4% or $55,382 at 6%; with 50% employer match about $55,382 at 4% or $36,921 at 6%; with 100% employer match about $41,536 at 4% or $27,691 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-20$358,297$66,458$3,323iApproximate average salary by contribution assumption: employee only about $83,073 at 4% or $55,382 at 6%; with 50% employer match about $55,382 at 4% or $36,921 at 6%; with 100% employer match about $41,536 at 4% or $27,691 at 6%.
2015216$413,053$92,681$5,793iApproximate average salary by contribution assumption: employee only about $144,814 at 4% or $96,543 at 6%; with 50% employer match about $96,543 at 4% or $64,362 at 6%; with 100% employer match about $72,407 at 4% or $48,271 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-16$222,897$62,711$3,919iApproximate average salary by contribution assumption: employee only about $97,986 at 4% or $65,324 at 6%; with 50% employer match about $65,324 at 4% or $43,549 at 6%; with 100% employer match about $48,993 at 4% or $32,662 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-8$190,156$29,970$3,746iApproximate average salary by contribution assumption: employee only about $93,656 at 4% or $62,438 at 6%; with 50% employer match about $62,438 at 4% or $41,625 at 6%; with 100% employer match about $46,828 at 4% or $31,219 at 6%.
201418$195,186$42,799$5,350iApproximate average salary by contribution assumption: employee only about $133,747 at 4% or $89,165 at 6%; with 50% employer match about $89,165 at 4% or $59,443 at 6%; with 100% employer match about $66,873 at 4% or $44,582 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-8$195,186$42,799$5,350iApproximate average salary by contribution assumption: employee only about $133,747 at 4% or $89,165 at 6%; with 50% employer match about $89,165 at 4% or $59,443 at 6%; with 100% employer match about $66,873 at 4% or $44,582 at 6%.
201315$154,914$43,256$8,651iApproximate average salary by contribution assumption: employee only about $216,280 at 4% or $144,187 at 6%; with 50% employer match about $144,187 at 4% or $96,124 at 6%; with 100% employer match about $108,140 at 4% or $72,093 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-5$154,914$43,256$8,651iApproximate average salary by contribution assumption: employee only about $216,280 at 4% or $144,187 at 6%; with 50% employer match about $144,187 at 4% or $96,124 at 6%; with 100% employer match about $108,140 at 4% or $72,093 at 6%.
201216$130,475$26,245$4,374iApproximate average salary by contribution assumption: employee only about $109,354 at 4% or $72,903 at 6%; with 50% employer match about $72,903 at 4% or $48,602 at 6%; with 100% employer match about $54,677 at 4% or $36,451 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-6$130,475$26,245$4,374iApproximate average salary by contribution assumption: employee only about $109,354 at 4% or $72,903 at 6%; with 50% employer match about $72,903 at 4% or $48,602 at 6%; with 100% employer match about $54,677 at 4% or $36,451 at 6%.
201115$104,230$24,854$4,971iApproximate average salary by contribution assumption: employee only about $124,270 at 4% or $82,847 at 6%; with 50% employer match about $82,847 at 4% or $55,231 at 6%; with 100% employer match about $62,135 at 4% or $41,423 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-5$104,230$24,854$4,971iApproximate average salary by contribution assumption: employee only about $124,270 at 4% or $82,847 at 6%; with 50% employer match about $82,847 at 4% or $55,231 at 6%; with 100% employer match about $62,135 at 4% or $41,423 at 6%.
201014$79,376$24,652$6,163iApproximate average salary by contribution assumption: employee only about $154,075 at 4% or $102,717 at 6%; with 50% employer match about $102,717 at 4% or $68,478 at 6%; with 100% employer match about $77,038 at 4% or $51,358 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-4$79,376$24,652$6,163iApproximate average salary by contribution assumption: employee only about $154,075 at 4% or $102,717 at 6%; with 50% employer match about $102,717 at 4% or $68,478 at 6%; with 100% employer match about $77,038 at 4% or $51,358 at 6%.
200915$60,398$24,818$4,964iApproximate average salary by contribution assumption: employee only about $124,090 at 4% or $82,727 at 6%; with 50% employer match about $82,727 at 4% or $55,151 at 6%; with 100% employer match about $62,045 at 4% or $41,363 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-5$60,398$24,818$4,964iApproximate average salary by contribution assumption: employee only about $124,090 at 4% or $82,727 at 6%; with 50% employer match about $82,727 at 4% or $55,151 at 6%; with 100% employer match about $62,045 at 4% or $41,363 at 6%.
200814$36,459$17,917$4,479iApproximate average salary by contribution assumption: employee only about $111,981 at 4% or $74,654 at 6%; with 50% employer match about $74,654 at 4% or $49,769 at 6%; with 100% employer match about $55,991 at 4% or $37,327 at 6%.
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-4$36,459$17,917$4,479iApproximate average salary by contribution assumption: employee only about $111,981 at 4% or $74,654 at 6%; with 50% employer match about $74,654 at 4% or $49,769 at 6%; with 100% employer match about $55,991 at 4% or $37,327 at 6%.
200714$0$0-
Advanced Spine and Pain Center 401(K) Dtd 07/01/2007-4---