Civic Intelligence

Dr. Wilfred Lee Alcorn

Plan context: Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan

EIN 62-1174405 • Shelbyville, TN • 32 filings • 6 plans

PO Box 901Shelbyville, TN 37162-0901
Current Snapshot

Latest Year

2024

2024 Participants

7

2024 Assets

$269,182

2024 Contributions

$57,019

Historical Graphs

Total Assets Over Time

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

$443,614$221,807$0199920132024YearValue
$269,182Latest year 2024

Participants Over Time

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

740199920122024YearValue
7Latest 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
202417$269,182$57,019$8,146iApproximate average salary by contribution assumption: employee only about $203,639 at 4% or $135,760 at 6%; with 50% employer match about $135,760 at 4% or $90,506 at 6%; with 100% employer match about $101,820 at 4% or $67,880 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-7$269,182$57,019$8,146iApproximate average salary by contribution assumption: employee only about $203,639 at 4% or $135,760 at 6%; with 50% employer match about $135,760 at 4% or $90,506 at 6%; with 100% employer match about $101,820 at 4% or $67,880 at 6%.
202317$198,319$68,778$9,825iApproximate average salary by contribution assumption: employee only about $245,636 at 4% or $163,757 at 6%; with 50% employer match about $163,757 at 4% or $109,171 at 6%; with 100% employer match about $122,818 at 4% or $81,879 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-7$198,319$68,778$9,825iApproximate average salary by contribution assumption: employee only about $245,636 at 4% or $163,757 at 6%; with 50% employer match about $163,757 at 4% or $109,171 at 6%; with 100% employer match about $122,818 at 4% or $81,879 at 6%.
202217$115,317$65,806$9,401iApproximate average salary by contribution assumption: employee only about $235,021 at 4% or $156,681 at 6%; with 50% employer match about $156,681 at 4% or $104,454 at 6%; with 100% employer match about $117,511 at 4% or $78,340 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-7$115,317$65,806$9,401iApproximate average salary by contribution assumption: employee only about $235,021 at 4% or $156,681 at 6%; with 50% employer match about $156,681 at 4% or $104,454 at 6%; with 100% employer match about $117,511 at 4% or $78,340 at 6%.
202117$49,780$0-
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-7$49,780$0-
202017$49,277$0-
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-7$49,277$0-
201917$48,719$0-
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-7$48,719$0-
201817$47,767$0-
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-7$47,767$0-
201717$62,292$3,750$536iApproximate average salary by contribution assumption: employee only about $13,393 at 4% or $8,929 at 6%; with 50% employer match about $8,929 at 4% or $5,952 at 6%; with 100% employer match about $6,696 at 4% or $4,464 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-7$62,292$3,750$536iApproximate average salary by contribution assumption: employee only about $13,393 at 4% or $8,929 at 6%; with 50% employer match about $8,929 at 4% or $5,952 at 6%; with 100% employer match about $6,696 at 4% or $4,464 at 6%.
201617$286,323$1,600$229iApproximate average salary by contribution assumption: employee only about $5,714 at 4% or $3,810 at 6%; with 50% employer match about $3,810 at 4% or $2,540 at 6%; with 100% employer match about $2,857 at 4% or $1,905 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-7$286,323$1,600$229iApproximate average salary by contribution assumption: employee only about $5,714 at 4% or $3,810 at 6%; with 50% employer match about $3,810 at 4% or $2,540 at 6%; with 100% employer match about $2,857 at 4% or $1,905 at 6%.
201517$281,984$10,000$1,429iApproximate average salary by contribution assumption: employee only about $35,714 at 4% or $23,810 at 6%; with 50% employer match about $23,810 at 4% or $15,873 at 6%; with 100% employer match about $17,857 at 4% or $11,905 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-7$281,984$10,000$1,429iApproximate average salary by contribution assumption: employee only about $35,714 at 4% or $23,810 at 6%; with 50% employer match about $23,810 at 4% or $15,873 at 6%; with 100% employer match about $17,857 at 4% or $11,905 at 6%.
201417$269,362$3,991$570iApproximate average salary by contribution assumption: employee only about $14,254 at 4% or $9,502 at 6%; with 50% employer match about $9,502 at 4% or $6,335 at 6%; with 100% employer match about $7,127 at 4% or $4,751 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-7$269,362$3,991$570iApproximate average salary by contribution assumption: employee only about $14,254 at 4% or $9,502 at 6%; with 50% employer match about $9,502 at 4% or $6,335 at 6%; with 100% employer match about $7,127 at 4% or $4,751 at 6%.
201316$262,840$2,100$350iApproximate average salary by contribution assumption: employee only about $8,750 at 4% or $5,833 at 6%; with 50% employer match about $5,833 at 4% or $3,889 at 6%; with 100% employer match about $4,375 at 4% or $2,917 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-6$262,840$2,100$350iApproximate average salary by contribution assumption: employee only about $8,750 at 4% or $5,833 at 6%; with 50% employer match about $5,833 at 4% or $3,889 at 6%; with 100% employer match about $4,375 at 4% or $2,917 at 6%.
201216$258,282$8,542$1,424iApproximate average salary by contribution assumption: employee only about $35,592 at 4% or $23,728 at 6%; with 50% employer match about $23,728 at 4% or $15,819 at 6%; with 100% employer match about $17,796 at 4% or $11,864 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-6$258,282$8,542$1,424iApproximate average salary by contribution assumption: employee only about $35,592 at 4% or $23,728 at 6%; with 50% employer match about $23,728 at 4% or $15,819 at 6%; with 100% employer match about $17,796 at 4% or $11,864 at 6%.
201116$243,885$3,500$583iApproximate average salary by contribution assumption: employee only about $14,583 at 4% or $9,722 at 6%; with 50% employer match about $9,722 at 4% or $6,481 at 6%; with 100% employer match about $7,292 at 4% or $4,861 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-6$243,885$3,500$583iApproximate average salary by contribution assumption: employee only about $14,583 at 4% or $9,722 at 6%; with 50% employer match about $9,722 at 4% or $6,481 at 6%; with 100% employer match about $7,292 at 4% or $4,861 at 6%.
201024$243,296$1,894$474iApproximate average salary by contribution assumption: employee only about $11,838 at 4% or $7,892 at 6%; with 50% employer match about $7,892 at 4% or $5,261 at 6%; with 100% employer match about $5,919 at 4% or $3,946 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-4$243,296$1,894$474iApproximate average salary by contribution assumption: employee only about $11,838 at 4% or $7,892 at 6%; with 50% employer match about $7,892 at 4% or $5,261 at 6%; with 100% employer match about $5,919 at 4% or $3,946 at 6%.
Dr Wilfred Lee Alcorn - Vanguard Psp 004 Prototype Defined Contribution Plan-0---
200924$312,418$2,946$737iApproximate average salary by contribution assumption: employee only about $18,413 at 4% or $12,275 at 6%; with 50% employer match about $12,275 at 4% or $8,183 at 6%; with 100% employer match about $9,206 at 4% or $6,138 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-4$197,420$2,946$737iApproximate average salary by contribution assumption: employee only about $18,413 at 4% or $12,275 at 6%; with 50% employer match about $12,275 at 4% or $8,183 at 6%; with 100% employer match about $9,206 at 4% or $6,138 at 6%.
Dr Wilfred Lee Alcorn - Vanguard Psp 004 Prototype Defined Contribution Plan-4$114,998--
200824$389,218$13,296$3,324iApproximate average salary by contribution assumption: employee only about $83,100 at 4% or $55,400 at 6%; with 50% employer match about $55,400 at 4% or $36,933 at 6%; with 100% employer match about $41,550 at 4% or $27,700 at 6%.
Dr Wilfred Lee Alcorn - Vanguard Psp 004 Prototype Defined Contribution Plan-4$212,370--
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-4$176,848$13,296$3,324iApproximate average salary by contribution assumption: employee only about $83,100 at 4% or $55,400 at 6%; with 50% employer match about $55,400 at 4% or $36,933 at 6%; with 100% employer match about $41,550 at 4% or $27,700 at 6%.
200724$0$0-
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-4---
Dr Wilfred Lee Alcorn - Vanguard Psp 004 Prototype Defined Contribution Plan-4---
200625$443,614$52,261$10,452iApproximate average salary by contribution assumption: employee only about $261,305 at 4% or $174,203 at 6%; with 50% employer match about $174,203 at 4% or $116,136 at 6%; with 100% employer match about $130,653 at 4% or $87,102 at 6%.
Dr Wilfred Lee Alcorn - Vanguard Psp 004 Prototype Defined Contribution Plan-5$295,324--
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-4$148,290$52,261$13,065iApproximate average salary by contribution assumption: employee only about $326,631 at 4% or $217,754 at 6%; with 50% employer match about $217,754 at 4% or $145,169 at 6%; with 100% employer match about $163,316 at 4% or $108,877 at 6%.
200515$92,737$44,637$8,927iApproximate average salary by contribution assumption: employee only about $223,185 at 4% or $148,790 at 6%; with 50% employer match about $148,790 at 4% or $99,193 at 6%; with 100% employer match about $111,593 at 4% or $74,395 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-5$92,737$44,637$8,927iApproximate average salary by contribution assumption: employee only about $223,185 at 4% or $148,790 at 6%; with 50% employer match about $148,790 at 4% or $99,193 at 6%; with 100% employer match about $111,593 at 4% or $74,395 at 6%.
200425$306,147$47,478$9,496iApproximate average salary by contribution assumption: employee only about $237,390 at 4% or $158,260 at 6%; with 50% employer match about $158,260 at 4% or $105,507 at 6%; with 100% employer match about $118,695 at 4% or $79,130 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-5$258,669--
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-4$47,478$47,478$11,870iApproximate average salary by contribution assumption: employee only about $296,738 at 4% or $197,825 at 6%; with 50% employer match about $197,825 at 4% or $131,883 at 6%; with 100% employer match about $148,369 at 4% or $98,913 at 6%.
200315$246,451$51,685$10,337iApproximate average salary by contribution assumption: employee only about $258,425 at 4% or $172,283 at 6%; with 50% employer match about $172,283 at 4% or $114,856 at 6%; with 100% employer match about $129,213 at 4% or $86,142 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-5$246,451$51,685$10,337iApproximate average salary by contribution assumption: employee only about $258,425 at 4% or $172,283 at 6%; with 50% employer match about $172,283 at 4% or $114,856 at 6%; with 100% employer match about $129,213 at 4% or $86,142 at 6%.
200214$177,644$46,402$11,601iApproximate average salary by contribution assumption: employee only about $290,013 at 4% or $193,342 at 6%; with 50% employer match about $193,342 at 4% or $128,894 at 6%; with 100% employer match about $145,006 at 4% or $96,671 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-4$177,644$46,402$11,601iApproximate average salary by contribution assumption: employee only about $290,013 at 4% or $193,342 at 6%; with 50% employer match about $193,342 at 4% or $128,894 at 6%; with 100% employer match about $145,006 at 4% or $96,671 at 6%.
200112$0$0-
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-2---
200015$199,598$18,240$3,648iApproximate average salary by contribution assumption: employee only about $91,200 at 4% or $60,800 at 6%; with 50% employer match about $60,800 at 4% or $40,533 at 6%; with 100% employer match about $45,600 at 4% or $30,400 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-5$199,598$18,240$3,648iApproximate average salary by contribution assumption: employee only about $91,200 at 4% or $60,800 at 6%; with 50% employer match about $60,800 at 4% or $40,533 at 6%; with 100% employer match about $45,600 at 4% or $30,400 at 6%.
199914$179,330$22,240$5,560iApproximate average salary by contribution assumption: employee only about $139,000 at 4% or $92,667 at 6%; with 50% employer match about $92,667 at 4% or $61,778 at 6%; with 100% employer match about $69,500 at 4% or $46,333 at 6%.
Vanguard Psp 004 Vanguard Prototype Defined Contribution Plan-4$179,330$22,240$5,560iApproximate average salary by contribution assumption: employee only about $139,000 at 4% or $92,667 at 6%; with 50% employer match about $92,667 at 4% or $61,778 at 6%; with 100% employer match about $69,500 at 4% or $46,333 at 6%.