Civic Intelligence

Brett Mcsparron Insurance Agency

Plan context: Brett Mcsparron Insurance Agency 401K Plan

EIN 77-0612057 • Apple Valley, MN • 3 filings • 1 plans

15030 Glazier Ave Ste 100Apple Valley, MN 55124
Current Snapshot

Latest Year

2025

2025 Participants

5

2025 Assets

$121,649

2025 Contributions

$52,543

Historical Graphs

Total Assets Over Time

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

$121,649$60,825$0202320242025YearValue
$121,649Latest year 2025

Participants Over Time

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

530202320242025YearValue
5Latest year 2025

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
202515$121,649$52,543$10,509iApproximate average salary by contribution assumption: employee only about $262,715 at 4% or $175,143 at 6%; with 50% employer match about $175,143 at 4% or $116,762 at 6%; with 100% employer match about $131,358 at 4% or $87,572 at 6%.
Brett Mcsparron Insurance Agency 401K Plan-5$121,649$52,543$10,509iApproximate average salary by contribution assumption: employee only about $262,715 at 4% or $175,143 at 6%; with 50% employer match about $175,143 at 4% or $116,762 at 6%; with 100% employer match about $131,358 at 4% or $87,572 at 6%.
202414$68,211$48,476$12,119iApproximate average salary by contribution assumption: employee only about $302,975 at 4% or $201,983 at 6%; with 50% employer match about $201,983 at 4% or $134,656 at 6%; with 100% employer match about $151,488 at 4% or $100,992 at 6%.
Brett Mcsparron Insurance Agency 401K Plan-4$68,211$48,476$12,119iApproximate average salary by contribution assumption: employee only about $302,975 at 4% or $201,983 at 6%; with 50% employer match about $201,983 at 4% or $134,656 at 6%; with 100% employer match about $151,488 at 4% or $100,992 at 6%.
202314$15,471$14,434$3,609iApproximate average salary by contribution assumption: employee only about $90,213 at 4% or $60,142 at 6%; with 50% employer match about $60,142 at 4% or $40,094 at 6%; with 100% employer match about $45,106 at 4% or $30,071 at 6%.
Brett Mcsparron Insurance Agency 401K Plan-4$15,471$14,434$3,609iApproximate average salary by contribution assumption: employee only about $90,213 at 4% or $60,142 at 6%; with 50% employer match about $60,142 at 4% or $40,094 at 6%; with 100% employer match about $45,106 at 4% or $30,071 at 6%.