Civic Intelligence

Frank E Sparr

Plan context: Frank E Sparr Simplified 401(K) Profit Sharing P

EIN 25-1479260 • Wexford, PA • 22 filings • 5 plans

2000 Corporate Dr Ste 500Wexford, PA 15090-7605
Current Snapshot

Latest Year

2025

2025 Participants

4

2025 Assets

$1,344,262

2025 Contributions

$60,599

Historical Graphs

Total Assets Over Time

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

$1,344,262$672,131$0200420152025YearValue
$1,344,262Latest year 2025

Participants Over Time

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

530200420152025YearValue
4Latest 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
202514$1,344,262$60,599$15,150iApproximate average salary by contribution assumption: employee only about $378,744 at 4% or $252,496 at 6%; with 50% employer match about $252,496 at 4% or $168,331 at 6%; with 100% employer match about $189,372 at 4% or $126,248 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-4$1,344,262$60,599$15,150iApproximate average salary by contribution assumption: employee only about $378,744 at 4% or $252,496 at 6%; with 50% employer match about $252,496 at 4% or $168,331 at 6%; with 100% employer match about $189,372 at 4% or $126,248 at 6%.
202414$1,123,438$56,304$14,076iApproximate average salary by contribution assumption: employee only about $351,900 at 4% or $234,600 at 6%; with 50% employer match about $234,600 at 4% or $156,400 at 6%; with 100% employer match about $175,950 at 4% or $117,300 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-4$1,123,438$56,304$14,076iApproximate average salary by contribution assumption: employee only about $351,900 at 4% or $234,600 at 6%; with 50% employer match about $234,600 at 4% or $156,400 at 6%; with 100% employer match about $175,950 at 4% or $117,300 at 6%.
202314$890,912$51,304$12,826iApproximate average salary by contribution assumption: employee only about $320,650 at 4% or $213,767 at 6%; with 50% employer match about $213,767 at 4% or $142,511 at 6%; with 100% employer match about $160,325 at 4% or $106,883 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-4$890,912$51,304$12,826iApproximate average salary by contribution assumption: employee only about $320,650 at 4% or $213,767 at 6%; with 50% employer match about $213,767 at 4% or $142,511 at 6%; with 100% employer match about $160,325 at 4% or $106,883 at 6%.
202214$687,104$45,195$11,299iApproximate average salary by contribution assumption: employee only about $282,469 at 4% or $188,313 at 6%; with 50% employer match about $188,313 at 4% or $125,542 at 6%; with 100% employer match about $141,234 at 4% or $94,156 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-4$687,104$45,195$11,299iApproximate average salary by contribution assumption: employee only about $282,469 at 4% or $188,313 at 6%; with 50% employer match about $188,313 at 4% or $125,542 at 6%; with 100% employer match about $141,234 at 4% or $94,156 at 6%.
202113$773,928$42,462$14,154iApproximate average salary by contribution assumption: employee only about $353,850 at 4% or $235,900 at 6%; with 50% employer match about $235,900 at 4% or $157,267 at 6%; with 100% employer match about $176,925 at 4% or $117,950 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-3$773,928$42,462$14,154iApproximate average salary by contribution assumption: employee only about $353,850 at 4% or $235,900 at 6%; with 50% employer match about $235,900 at 4% or $157,267 at 6%; with 100% employer match about $176,925 at 4% or $117,950 at 6%.
202013$618,649$32,038$10,679iApproximate average salary by contribution assumption: employee only about $266,983 at 4% or $177,989 at 6%; with 50% employer match about $177,989 at 4% or $118,659 at 6%; with 100% employer match about $133,492 at 4% or $88,994 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-3$618,649$32,038$10,679iApproximate average salary by contribution assumption: employee only about $266,983 at 4% or $177,989 at 6%; with 50% employer match about $177,989 at 4% or $118,659 at 6%; with 100% employer match about $133,492 at 4% or $88,994 at 6%.
201913$480,010$29,353$9,784iApproximate average salary by contribution assumption: employee only about $244,608 at 4% or $163,072 at 6%; with 50% employer match about $163,072 at 4% or $108,715 at 6%; with 100% employer match about $122,304 at 4% or $81,536 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-3$480,010$29,353$9,784iApproximate average salary by contribution assumption: employee only about $244,608 at 4% or $163,072 at 6%; with 50% employer match about $163,072 at 4% or $108,715 at 6%; with 100% employer match about $122,304 at 4% or $81,536 at 6%.
201813$362,389$28,262$9,421iApproximate average salary by contribution assumption: employee only about $235,517 at 4% or $157,011 at 6%; with 50% employer match about $157,011 at 4% or $104,674 at 6%; with 100% employer match about $117,758 at 4% or $78,506 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-3$362,389$28,262$9,421iApproximate average salary by contribution assumption: employee only about $235,517 at 4% or $157,011 at 6%; with 50% employer match about $157,011 at 4% or $104,674 at 6%; with 100% employer match about $117,758 at 4% or $78,506 at 6%.
201714$369,879$29,799$7,450iApproximate average salary by contribution assumption: employee only about $186,244 at 4% or $124,163 at 6%; with 50% employer match about $124,163 at 4% or $82,775 at 6%; with 100% employer match about $93,122 at 4% or $62,081 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-4$369,879$29,799$7,450iApproximate average salary by contribution assumption: employee only about $186,244 at 4% or $124,163 at 6%; with 50% employer match about $124,163 at 4% or $82,775 at 6%; with 100% employer match about $93,122 at 4% or $62,081 at 6%.
201614$284,924$15,637$3,909iApproximate average salary by contribution assumption: employee only about $97,731 at 4% or $65,154 at 6%; with 50% employer match about $65,154 at 4% or $43,436 at 6%; with 100% employer match about $48,866 at 4% or $32,577 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-4$284,924$15,637$3,909iApproximate average salary by contribution assumption: employee only about $97,731 at 4% or $65,154 at 6%; with 50% employer match about $65,154 at 4% or $43,436 at 6%; with 100% employer match about $48,866 at 4% or $32,577 at 6%.
201515$269,245$12,600$2,520iApproximate average salary by contribution assumption: employee only about $63,000 at 4% or $42,000 at 6%; with 50% employer match about $42,000 at 4% or $28,000 at 6%; with 100% employer match about $31,500 at 4% or $21,000 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-5$269,245$12,600$2,520iApproximate average salary by contribution assumption: employee only about $63,000 at 4% or $42,000 at 6%; with 50% employer match about $42,000 at 4% or $28,000 at 6%; with 100% employer match about $31,500 at 4% or $21,000 at 6%.
201415$254,117$12,434$2,487iApproximate average salary by contribution assumption: employee only about $62,170 at 4% or $41,447 at 6%; with 50% employer match about $41,447 at 4% or $27,631 at 6%; with 100% employer match about $31,085 at 4% or $20,723 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-5$254,117$12,434$2,487iApproximate average salary by contribution assumption: employee only about $62,170 at 4% or $41,447 at 6%; with 50% employer match about $41,447 at 4% or $27,631 at 6%; with 100% employer match about $31,085 at 4% or $20,723 at 6%.
201315$225,398$12,576$2,515iApproximate average salary by contribution assumption: employee only about $62,880 at 4% or $41,920 at 6%; with 50% employer match about $41,920 at 4% or $27,947 at 6%; with 100% employer match about $31,440 at 4% or $20,960 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-5$225,398$12,576$2,515iApproximate average salary by contribution assumption: employee only about $62,880 at 4% or $41,920 at 6%; with 50% employer match about $41,920 at 4% or $27,947 at 6%; with 100% employer match about $31,440 at 4% or $20,960 at 6%.
201215$174,898$14,950$2,990iApproximate average salary by contribution assumption: employee only about $74,750 at 4% or $49,833 at 6%; with 50% employer match about $49,833 at 4% or $33,222 at 6%; with 100% employer match about $37,375 at 4% or $24,917 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-5$174,898$14,950$2,990iApproximate average salary by contribution assumption: employee only about $74,750 at 4% or $49,833 at 6%; with 50% employer match about $49,833 at 4% or $33,222 at 6%; with 100% employer match about $37,375 at 4% or $24,917 at 6%.
201115$152,781$28,921$5,784iApproximate average salary by contribution assumption: employee only about $144,605 at 4% or $96,403 at 6%; with 50% employer match about $96,403 at 4% or $64,269 at 6%; with 100% employer match about $72,303 at 4% or $48,202 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-5$152,781$28,921$5,784iApproximate average salary by contribution assumption: employee only about $144,605 at 4% or $96,403 at 6%; with 50% employer match about $96,403 at 4% or $64,269 at 6%; with 100% employer match about $72,303 at 4% or $48,202 at 6%.
201014$123,116$16,545$4,136iApproximate average salary by contribution assumption: employee only about $103,406 at 4% or $68,938 at 6%; with 50% employer match about $68,938 at 4% or $45,958 at 6%; with 100% employer match about $51,703 at 4% or $34,469 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-4$123,116$16,545$4,136iApproximate average salary by contribution assumption: employee only about $103,406 at 4% or $68,938 at 6%; with 50% employer match about $68,938 at 4% or $45,958 at 6%; with 100% employer match about $51,703 at 4% or $34,469 at 6%.
200913$92,261$14,941$4,980iApproximate average salary by contribution assumption: employee only about $124,508 at 4% or $83,006 at 6%; with 50% employer match about $83,006 at 4% or $55,337 at 6%; with 100% employer match about $62,254 at 4% or $41,503 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-3$92,261$14,941$4,980iApproximate average salary by contribution assumption: employee only about $124,508 at 4% or $83,006 at 6%; with 50% employer match about $83,006 at 4% or $55,337 at 6%; with 100% employer match about $62,254 at 4% or $41,503 at 6%.
200813$61,904$13,590$4,530iApproximate average salary by contribution assumption: employee only about $113,250 at 4% or $75,500 at 6%; with 50% employer match about $75,500 at 4% or $50,333 at 6%; with 100% employer match about $56,625 at 4% or $37,750 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-3$61,904$13,590$4,530iApproximate average salary by contribution assumption: employee only about $113,250 at 4% or $75,500 at 6%; with 50% employer match about $75,500 at 4% or $50,333 at 6%; with 100% employer match about $56,625 at 4% or $37,750 at 6%.
200714$0$0-
Frank E Sparr Simplified 401(K) Profit Sharing P-4---
200612$120,136$22,800$11,400iApproximate average salary by contribution assumption: employee only about $285,000 at 4% or $190,000 at 6%; with 50% employer match about $190,000 at 4% or $126,667 at 6%; with 100% employer match about $142,500 at 4% or $95,000 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-2$120,136$22,800$11,400iApproximate average salary by contribution assumption: employee only about $285,000 at 4% or $190,000 at 6%; with 50% employer match about $190,000 at 4% or $126,667 at 6%; with 100% employer match about $142,500 at 4% or $95,000 at 6%.
200512$87,747$21,390$10,695iApproximate average salary by contribution assumption: employee only about $267,375 at 4% or $178,250 at 6%; with 50% employer match about $178,250 at 4% or $118,833 at 6%; with 100% employer match about $133,688 at 4% or $89,125 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-2$87,747$21,390$10,695iApproximate average salary by contribution assumption: employee only about $267,375 at 4% or $178,250 at 6%; with 50% employer match about $178,250 at 4% or $118,833 at 6%; with 100% employer match about $133,688 at 4% or $89,125 at 6%.
200412$62,168$20,065$10,033iApproximate average salary by contribution assumption: employee only about $250,813 at 4% or $167,208 at 6%; with 50% employer match about $167,208 at 4% or $111,472 at 6%; with 100% employer match about $125,406 at 4% or $83,604 at 6%.
Frank E Sparr Simplified 401(K) Profit Sharing P-2$62,168$20,065$10,033iApproximate average salary by contribution assumption: employee only about $250,813 at 4% or $167,208 at 6%; with 50% employer match about $167,208 at 4% or $111,472 at 6%; with 100% employer match about $125,406 at 4% or $83,604 at 6%.