Civic Intelligence

Hemmer, Spoor, Pangburn, Defrank & Kasson

Plan context: Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan

EIN 61-1348045 • Fort Mitchell, KY • 29 filings • 8 plans

250 Grandview DriveSuite 500Fort Mitchell, KY 41017
Current Snapshot

Latest Year

2024

2024 Participants

16

2024 Assets

$5,386,125

2024 Contributions

$414,052

Historical Graphs

Total Assets Over Time

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

$8,298,819$4,149,410$0199920132024YearValue
$5,386,125Latest year 2024

Participants Over Time

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

20100199920122024YearValue
16Latest 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
2024216$5,386,125$414,052$25,878iApproximate average salary by contribution assumption: employee only about $646,956 at 4% or $431,304 at 6%; with 50% employer match about $431,304 at 4% or $287,536 at 6%; with 100% employer match about $323,478 at 4% or $215,652 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-16$5,378,096$320,831$20,052iApproximate average salary by contribution assumption: employee only about $501,298 at 4% or $334,199 at 6%; with 50% employer match about $334,199 at 4% or $222,799 at 6%; with 100% employer match about $250,649 at 4% or $167,099 at 6%.
HEMMER DEFRANK WESSELS PLLC CBS BENEFIT PLAN-8$8,029$93,221$11,653iApproximate average salary by contribution assumption: employee only about $291,316 at 4% or $194,210 at 6%; with 50% employer match about $194,210 at 4% or $129,474 at 6%; with 100% employer match about $145,658 at 4% or $97,105 at 6%.
2023215$5,180,178$369,303$24,620iApproximate average salary by contribution assumption: employee only about $615,505 at 4% or $410,337 at 6%; with 50% employer match about $410,337 at 4% or $273,558 at 6%; with 100% employer match about $307,753 at 4% or $205,168 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-15$5,175,722$281,208$18,747iApproximate average salary by contribution assumption: employee only about $468,680 at 4% or $312,453 at 6%; with 50% employer match about $312,453 at 4% or $208,302 at 6%; with 100% employer match about $234,340 at 4% or $156,227 at 6%.
HEMMER DEFRANK WESSELS PLLC CBS BENEFIT PLAN-8$4,456$88,095$11,012iApproximate average salary by contribution assumption: employee only about $275,297 at 4% or $183,531 at 6%; with 50% employer match about $183,531 at 4% or $122,354 at 6%; with 100% employer match about $137,648 at 4% or $91,766 at 6%.
2022216$6,274,229$405,443$25,340iApproximate average salary by contribution assumption: employee only about $633,505 at 4% or $422,336 at 6%; with 50% employer match about $422,336 at 4% or $281,558 at 6%; with 100% employer match about $316,752 at 4% or $211,168 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-16$6,274,080$390,808$24,426iApproximate average salary by contribution assumption: employee only about $610,638 at 4% or $407,092 at 6%; with 50% employer match about $407,092 at 4% or $271,394 at 6%; with 100% employer match about $305,319 at 4% or $203,546 at 6%.
HEMMER DEFRANK WESSELS PLLC CBS BENEFIT PLAN-8$149$14,635$1,829iApproximate average salary by contribution assumption: employee only about $45,734 at 4% or $30,490 at 6%; with 50% employer match about $30,490 at 4% or $20,326 at 6%; with 100% employer match about $22,867 at 4% or $15,245 at 6%.
2021117$8,298,819$180,495$10,617iApproximate average salary by contribution assumption: employee only about $265,434 at 4% or $176,956 at 6%; with 50% employer match about $176,956 at 4% or $117,971 at 6%; with 100% employer match about $132,717 at 4% or $88,478 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-17$8,298,819$180,495$10,617iApproximate average salary by contribution assumption: employee only about $265,434 at 4% or $176,956 at 6%; with 50% employer match about $176,956 at 4% or $117,971 at 6%; with 100% employer match about $132,717 at 4% or $88,478 at 6%.
2020116$7,386,690$304,989$19,062iApproximate average salary by contribution assumption: employee only about $476,545 at 4% or $317,697 at 6%; with 50% employer match about $317,697 at 4% or $211,798 at 6%; with 100% employer match about $238,273 at 4% or $158,848 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-16$7,386,690$304,989$19,062iApproximate average salary by contribution assumption: employee only about $476,545 at 4% or $317,697 at 6%; with 50% employer match about $317,697 at 4% or $211,798 at 6%; with 100% employer match about $238,273 at 4% or $158,848 at 6%.
2019118$6,395,647$349,354$19,409iApproximate average salary by contribution assumption: employee only about $485,214 at 4% or $323,476 at 6%; with 50% employer match about $323,476 at 4% or $215,651 at 6%; with 100% employer match about $242,607 at 4% or $161,738 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-18$6,395,647$349,354$19,409iApproximate average salary by contribution assumption: employee only about $485,214 at 4% or $323,476 at 6%; with 50% employer match about $323,476 at 4% or $215,651 at 6%; with 100% employer match about $242,607 at 4% or $161,738 at 6%.
2018118$5,175,953$336,935$18,719iApproximate average salary by contribution assumption: employee only about $467,965 at 4% or $311,977 at 6%; with 50% employer match about $311,977 at 4% or $207,985 at 6%; with 100% employer match about $233,983 at 4% or $155,988 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-18$5,175,953$336,935$18,719iApproximate average salary by contribution assumption: employee only about $467,965 at 4% or $311,977 at 6%; with 50% employer match about $311,977 at 4% or $207,985 at 6%; with 100% employer match about $233,983 at 4% or $155,988 at 6%.
2017118$5,186,706$308,790$17,155iApproximate average salary by contribution assumption: employee only about $428,875 at 4% or $285,917 at 6%; with 50% employer match about $285,917 at 4% or $190,611 at 6%; with 100% employer match about $214,438 at 4% or $142,958 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-18$5,186,706$308,790$17,155iApproximate average salary by contribution assumption: employee only about $428,875 at 4% or $285,917 at 6%; with 50% employer match about $285,917 at 4% or $190,611 at 6%; with 100% employer match about $214,438 at 4% or $142,958 at 6%.
2016119$4,505,641$296,769$15,619iApproximate average salary by contribution assumption: employee only about $390,486 at 4% or $260,324 at 6%; with 50% employer match about $260,324 at 4% or $173,549 at 6%; with 100% employer match about $195,243 at 4% or $130,162 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-19$4,505,641$296,769$15,619iApproximate average salary by contribution assumption: employee only about $390,486 at 4% or $260,324 at 6%; with 50% employer match about $260,324 at 4% or $173,549 at 6%; with 100% employer match about $195,243 at 4% or $130,162 at 6%.
2015118$3,997,077$293,449$16,303iApproximate average salary by contribution assumption: employee only about $407,568 at 4% or $271,712 at 6%; with 50% employer match about $271,712 at 4% or $181,141 at 6%; with 100% employer match about $203,784 at 4% or $135,856 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-18$3,997,077$293,449$16,303iApproximate average salary by contribution assumption: employee only about $407,568 at 4% or $271,712 at 6%; with 50% employer match about $271,712 at 4% or $181,141 at 6%; with 100% employer match about $203,784 at 4% or $135,856 at 6%.
2014118$4,071,789$315,993$17,555iApproximate average salary by contribution assumption: employee only about $438,879 at 4% or $292,586 at 6%; with 50% employer match about $292,586 at 4% or $195,057 at 6%; with 100% employer match about $219,440 at 4% or $146,293 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-18$4,071,789$315,993$17,555iApproximate average salary by contribution assumption: employee only about $438,879 at 4% or $292,586 at 6%; with 50% employer match about $292,586 at 4% or $195,057 at 6%; with 100% employer match about $219,440 at 4% or $146,293 at 6%.
2013118$3,690,435$282,850$15,714iApproximate average salary by contribution assumption: employee only about $392,847 at 4% or $261,898 at 6%; with 50% employer match about $261,898 at 4% or $174,599 at 6%; with 100% employer match about $196,424 at 4% or $130,949 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-18$3,690,435$282,850$15,714iApproximate average salary by contribution assumption: employee only about $392,847 at 4% or $261,898 at 6%; with 50% employer match about $261,898 at 4% or $174,599 at 6%; with 100% employer match about $196,424 at 4% or $130,949 at 6%.
2012119$2,911,819$391,093$20,584iApproximate average salary by contribution assumption: employee only about $514,596 at 4% or $343,064 at 6%; with 50% employer match about $343,064 at 4% or $228,709 at 6%; with 100% employer match about $257,298 at 4% or $171,532 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-19$2,911,819$391,093$20,584iApproximate average salary by contribution assumption: employee only about $514,596 at 4% or $343,064 at 6%; with 50% employer match about $343,064 at 4% or $228,709 at 6%; with 100% employer match about $257,298 at 4% or $171,532 at 6%.
2011117$2,279,301$240,097$14,123iApproximate average salary by contribution assumption: employee only about $353,084 at 4% or $235,389 at 6%; with 50% employer match about $235,389 at 4% or $156,926 at 6%; with 100% employer match about $176,542 at 4% or $117,695 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-17$2,279,301$240,097$14,123iApproximate average salary by contribution assumption: employee only about $353,084 at 4% or $235,389 at 6%; with 50% employer match about $235,389 at 4% or $156,926 at 6%; with 100% employer match about $176,542 at 4% or $117,695 at 6%.
2010117$2,108,175$163,238$9,602iApproximate average salary by contribution assumption: employee only about $240,056 at 4% or $160,037 at 6%; with 50% employer match about $160,037 at 4% or $106,692 at 6%; with 100% employer match about $120,028 at 4% or $80,019 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-17$2,108,175$163,238$9,602iApproximate average salary by contribution assumption: employee only about $240,056 at 4% or $160,037 at 6%; with 50% employer match about $160,037 at 4% or $106,692 at 6%; with 100% employer match about $120,028 at 4% or $80,019 at 6%.
2009116$1,933,874$253,442$15,840iApproximate average salary by contribution assumption: employee only about $396,003 at 4% or $264,002 at 6%; with 50% employer match about $264,002 at 4% or $176,001 at 6%; with 100% employer match about $198,002 at 4% or $132,001 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-16$1,933,874$253,442$15,840iApproximate average salary by contribution assumption: employee only about $396,003 at 4% or $264,002 at 6%; with 50% employer match about $264,002 at 4% or $176,001 at 6%; with 100% employer match about $198,002 at 4% or $132,001 at 6%.
2008119$1,551,744$127,885$6,731iApproximate average salary by contribution assumption: employee only about $168,270 at 4% or $112,180 at 6%; with 50% employer match about $112,180 at 4% or $74,787 at 6%; with 100% employer match about $84,135 at 4% or $56,090 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-19$1,551,744$127,885$6,731iApproximate average salary by contribution assumption: employee only about $168,270 at 4% or $112,180 at 6%; with 50% employer match about $112,180 at 4% or $74,787 at 6%; with 100% employer match about $84,135 at 4% or $56,090 at 6%.
2007120$0$0-
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-20---
2006119$1,662,423$252,181$13,273iApproximate average salary by contribution assumption: employee only about $331,817 at 4% or $221,211 at 6%; with 50% employer match about $221,211 at 4% or $147,474 at 6%; with 100% employer match about $165,909 at 4% or $110,606 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-19$1,662,423$252,181$13,273iApproximate average salary by contribution assumption: employee only about $331,817 at 4% or $221,211 at 6%; with 50% employer match about $221,211 at 4% or $147,474 at 6%; with 100% employer match about $165,909 at 4% or $110,606 at 6%.
2005117$2,115,074$235,773$13,869iApproximate average salary by contribution assumption: employee only about $346,725 at 4% or $231,150 at 6%; with 50% employer match about $231,150 at 4% or $154,100 at 6%; with 100% employer match about $173,363 at 4% or $115,575 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-17$2,115,074$235,773$13,869iApproximate average salary by contribution assumption: employee only about $346,725 at 4% or $231,150 at 6%; with 50% employer match about $231,150 at 4% or $154,100 at 6%; with 100% employer match about $173,363 at 4% or $115,575 at 6%.
2004117$1,912,347$260,877$15,346iApproximate average salary by contribution assumption: employee only about $383,643 at 4% or $255,762 at 6%; with 50% employer match about $255,762 at 4% or $170,508 at 6%; with 100% employer match about $191,821 at 4% or $127,881 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-17$1,912,347$260,877$15,346iApproximate average salary by contribution assumption: employee only about $383,643 at 4% or $255,762 at 6%; with 50% employer match about $255,762 at 4% or $170,508 at 6%; with 100% employer match about $191,821 at 4% or $127,881 at 6%.
2003115$1,496,341$82,955$5,530iApproximate average salary by contribution assumption: employee only about $138,258 at 4% or $92,172 at 6%; with 50% employer match about $92,172 at 4% or $61,448 at 6%; with 100% employer match about $69,129 at 4% or $46,086 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-15$1,496,341$82,955$5,530iApproximate average salary by contribution assumption: employee only about $138,258 at 4% or $92,172 at 6%; with 50% employer match about $92,172 at 4% or $61,448 at 6%; with 100% employer match about $69,129 at 4% or $46,086 at 6%.
2002113$1,134,767$146,965$11,305iApproximate average salary by contribution assumption: employee only about $282,625 at 4% or $188,417 at 6%; with 50% employer match about $188,417 at 4% or $125,611 at 6%; with 100% employer match about $141,313 at 4% or $94,208 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-13$1,134,767$146,965$11,305iApproximate average salary by contribution assumption: employee only about $282,625 at 4% or $188,417 at 6%; with 50% employer match about $188,417 at 4% or $125,611 at 6%; with 100% employer match about $141,313 at 4% or $94,208 at 6%.
2001113$0$0-
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-13---
2000115$1,281,225$88,392$5,893iApproximate average salary by contribution assumption: employee only about $147,320 at 4% or $98,213 at 6%; with 50% employer match about $98,213 at 4% or $65,476 at 6%; with 100% employer match about $73,660 at 4% or $49,107 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-15$1,281,225$88,392$5,893iApproximate average salary by contribution assumption: employee only about $147,320 at 4% or $98,213 at 6%; with 50% employer match about $98,213 at 4% or $65,476 at 6%; with 100% employer match about $73,660 at 4% or $49,107 at 6%.
1999113$1,296,750$1,194,972$91,921iApproximate average salary by contribution assumption: employee only about $2,298,023 at 4% or $1,532,015 at 6%; with 50% employer match about $1,532,015 at 4% or $1,021,344 at 6%; with 100% employer match about $1,149,012 at 4% or $766,008 at 6%.
Hemmer, Spoor, Pangburn, Defrank & Kasson Profit Sharing 401K Plan-13$1,296,750$1,194,972$91,921iApproximate average salary by contribution assumption: employee only about $2,298,023 at 4% or $1,532,015 at 6%; with 50% employer match about $1,532,015 at 4% or $1,021,344 at 6%; with 100% employer match about $1,149,012 at 4% or $766,008 at 6%.