Civic Intelligence

Roger W. Ranfranz, Pa

Plan context: TOWN DENTAL 401(K) PROFIT SHARING PLAN

EIN 41-0956284 • Excelsior, MN • 26 filings • 5 plans

425 Second StreetExcelsior, MN 55331
Current Snapshot

Latest Year

2024

2024 Participants

17

2024 Assets

$3,229,740

2024 Contributions

$182,225

Historical Graphs

Total Assets Over Time

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

$3,229,740$1,614,870$0199920142024YearValue
$3,229,740Latest year 2024

Participants Over Time

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

24120199920122024YearValue
17Latest 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
2024117$3,229,740$182,225$10,719iApproximate average salary by contribution assumption: employee only about $267,978 at 4% or $178,652 at 6%; with 50% employer match about $178,652 at 4% or $119,101 at 6%; with 100% employer match about $133,989 at 4% or $89,326 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-17$3,229,740$182,225$10,719iApproximate average salary by contribution assumption: employee only about $267,978 at 4% or $178,652 at 6%; with 50% employer match about $178,652 at 4% or $119,101 at 6%; with 100% employer match about $133,989 at 4% or $89,326 at 6%.
2023119$2,973,200$202,576$10,662iApproximate average salary by contribution assumption: employee only about $266,547 at 4% or $177,698 at 6%; with 50% employer match about $177,698 at 4% or $118,465 at 6%; with 100% employer match about $133,274 at 4% or $88,849 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-19$2,973,200$202,576$10,662iApproximate average salary by contribution assumption: employee only about $266,547 at 4% or $177,698 at 6%; with 50% employer match about $177,698 at 4% or $118,465 at 6%; with 100% employer match about $133,274 at 4% or $88,849 at 6%.
2022124$2,601,235$171,131$7,130iApproximate average salary by contribution assumption: employee only about $178,261 at 4% or $118,841 at 6%; with 50% employer match about $118,841 at 4% or $79,227 at 6%; with 100% employer match about $89,131 at 4% or $59,420 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-24$2,601,235$171,131$7,130iApproximate average salary by contribution assumption: employee only about $178,261 at 4% or $118,841 at 6%; with 50% employer match about $118,841 at 4% or $79,227 at 6%; with 100% employer match about $89,131 at 4% or $59,420 at 6%.
2021124$3,060,869$158,903$6,621iApproximate average salary by contribution assumption: employee only about $165,524 at 4% or $110,349 at 6%; with 50% employer match about $110,349 at 4% or $73,566 at 6%; with 100% employer match about $82,762 at 4% or $55,175 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-24$3,060,869$158,903$6,621iApproximate average salary by contribution assumption: employee only about $165,524 at 4% or $110,349 at 6%; with 50% employer match about $110,349 at 4% or $73,566 at 6%; with 100% employer match about $82,762 at 4% or $55,175 at 6%.
2020122$2,666,827$165,595$7,527iApproximate average salary by contribution assumption: employee only about $188,176 at 4% or $125,451 at 6%; with 50% employer match about $125,451 at 4% or $83,634 at 6%; with 100% employer match about $94,088 at 4% or $62,725 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-22$2,666,827$165,595$7,527iApproximate average salary by contribution assumption: employee only about $188,176 at 4% or $125,451 at 6%; with 50% employer match about $125,451 at 4% or $83,634 at 6%; with 100% employer match about $94,088 at 4% or $62,725 at 6%.
2019118$2,490,541$167,585$9,310iApproximate average salary by contribution assumption: employee only about $232,757 at 4% or $155,171 at 6%; with 50% employer match about $155,171 at 4% or $103,448 at 6%; with 100% employer match about $116,378 at 4% or $77,586 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-18$2,490,541$167,585$9,310iApproximate average salary by contribution assumption: employee only about $232,757 at 4% or $155,171 at 6%; with 50% employer match about $155,171 at 4% or $103,448 at 6%; with 100% employer match about $116,378 at 4% or $77,586 at 6%.
2018117$1,972,095$160,136$9,420iApproximate average salary by contribution assumption: employee only about $235,494 at 4% or $156,996 at 6%; with 50% employer match about $156,996 at 4% or $104,664 at 6%; with 100% employer match about $117,747 at 4% or $78,498 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-17$1,972,095$160,136$9,420iApproximate average salary by contribution assumption: employee only about $235,494 at 4% or $156,996 at 6%; with 50% employer match about $156,996 at 4% or $104,664 at 6%; with 100% employer match about $117,747 at 4% or $78,498 at 6%.
2017116$2,147,922$129,834$8,115iApproximate average salary by contribution assumption: employee only about $202,866 at 4% or $135,244 at 6%; with 50% employer match about $135,244 at 4% or $90,163 at 6%; with 100% employer match about $101,433 at 4% or $67,622 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-16$2,147,922$129,834$8,115iApproximate average salary by contribution assumption: employee only about $202,866 at 4% or $135,244 at 6%; with 50% employer match about $135,244 at 4% or $90,163 at 6%; with 100% employer match about $101,433 at 4% or $67,622 at 6%.
2016112$1,714,121$146,185$12,182iApproximate average salary by contribution assumption: employee only about $304,552 at 4% or $203,035 at 6%; with 50% employer match about $203,035 at 4% or $135,356 at 6%; with 100% employer match about $152,276 at 4% or $101,517 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-12$1,714,121$146,185$12,182iApproximate average salary by contribution assumption: employee only about $304,552 at 4% or $203,035 at 6%; with 50% employer match about $203,035 at 4% or $135,356 at 6%; with 100% employer match about $152,276 at 4% or $101,517 at 6%.
2015112$1,704,329$158,363$13,197iApproximate average salary by contribution assumption: employee only about $329,923 at 4% or $219,949 at 6%; with 50% employer match about $219,949 at 4% or $146,632 at 6%; with 100% employer match about $164,961 at 4% or $109,974 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-12$1,704,329$158,363$13,197iApproximate average salary by contribution assumption: employee only about $329,923 at 4% or $219,949 at 6%; with 50% employer match about $219,949 at 4% or $146,632 at 6%; with 100% employer match about $164,961 at 4% or $109,974 at 6%.
2014111$1,559,186$138,878$12,625iApproximate average salary by contribution assumption: employee only about $315,632 at 4% or $210,421 at 6%; with 50% employer match about $210,421 at 4% or $140,281 at 6%; with 100% employer match about $157,816 at 4% or $105,211 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-11$1,559,186$138,878$12,625iApproximate average salary by contribution assumption: employee only about $315,632 at 4% or $210,421 at 6%; with 50% employer match about $210,421 at 4% or $140,281 at 6%; with 100% employer match about $157,816 at 4% or $105,211 at 6%.
2013111$1,337,278$172,660$15,696iApproximate average salary by contribution assumption: employee only about $392,409 at 4% or $261,606 at 6%; with 50% employer match about $261,606 at 4% or $174,404 at 6%; with 100% employer match about $196,205 at 4% or $130,803 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-11$1,337,278$172,660$15,696iApproximate average salary by contribution assumption: employee only about $392,409 at 4% or $261,606 at 6%; with 50% employer match about $261,606 at 4% or $174,404 at 6%; with 100% employer match about $196,205 at 4% or $130,803 at 6%.
201219$1,003,863$147,677$16,409iApproximate average salary by contribution assumption: employee only about $410,214 at 4% or $273,476 at 6%; with 50% employer match about $273,476 at 4% or $182,317 at 6%; with 100% employer match about $205,107 at 4% or $136,738 at 6%.
TOWN DENTAL 401(K) PROFIT SHARING PLAN-9$1,003,863$147,677$16,409iApproximate average salary by contribution assumption: employee only about $410,214 at 4% or $273,476 at 6%; with 50% employer match about $273,476 at 4% or $182,317 at 6%; with 100% employer match about $205,107 at 4% or $136,738 at 6%.
201119$750,994$145,157$16,129iApproximate average salary by contribution assumption: employee only about $403,214 at 4% or $268,809 at 6%; with 50% employer match about $268,809 at 4% or $179,206 at 6%; with 100% employer match about $201,607 at 4% or $134,405 at 6%.
TOWN DENTAL 401(K) P/S PLAN-9$750,994$145,157$16,129iApproximate average salary by contribution assumption: employee only about $403,214 at 4% or $268,809 at 6%; with 50% employer match about $268,809 at 4% or $179,206 at 6%; with 100% employer match about $201,607 at 4% or $134,405 at 6%.
201019$658,653$141,062$15,674iApproximate average salary by contribution assumption: employee only about $391,839 at 4% or $261,226 at 6%; with 50% employer match about $261,226 at 4% or $174,151 at 6%; with 100% employer match about $195,919 at 4% or $130,613 at 6%.
TOWN DENTAL 401(K) P/S PLAN-9$658,653$141,062$15,674iApproximate average salary by contribution assumption: employee only about $391,839 at 4% or $261,226 at 6%; with 50% employer match about $261,226 at 4% or $174,151 at 6%; with 100% employer match about $195,919 at 4% or $130,613 at 6%.
200918$444,239$117,772$14,722iApproximate average salary by contribution assumption: employee only about $368,038 at 4% or $245,358 at 6%; with 50% employer match about $245,358 at 4% or $163,572 at 6%; with 100% employer match about $184,019 at 4% or $122,679 at 6%.
TOWN DENTAL 401(K) P/S PLAN-8$444,239$117,772$14,722iApproximate average salary by contribution assumption: employee only about $368,038 at 4% or $245,358 at 6%; with 50% employer match about $245,358 at 4% or $163,572 at 6%; with 100% employer match about $184,019 at 4% or $122,679 at 6%.
200818$228,886$87,211$10,901iApproximate average salary by contribution assumption: employee only about $272,534 at 4% or $181,690 at 6%; with 50% employer match about $181,690 at 4% or $121,126 at 6%; with 100% employer match about $136,267 at 4% or $90,845 at 6%.
TOWN DENTAL 401K P/S PLAN-8$228,886$87,211$10,901iApproximate average salary by contribution assumption: employee only about $272,534 at 4% or $181,690 at 6%; with 50% employer match about $181,690 at 4% or $121,126 at 6%; with 100% employer match about $136,267 at 4% or $90,845 at 6%.
200714$0$0-
TOWN DENTAL 401K P/S PLAN-4---
200617$187,351$69,790$9,970iApproximate average salary by contribution assumption: employee only about $249,250 at 4% or $166,167 at 6%; with 50% employer match about $166,167 at 4% or $110,778 at 6%; with 100% employer match about $124,625 at 4% or $83,083 at 6%.
TOWN DENTAL 401K P/S PLAN-7$187,351$69,790$9,970iApproximate average salary by contribution assumption: employee only about $249,250 at 4% or $166,167 at 6%; with 50% employer match about $166,167 at 4% or $110,778 at 6%; with 100% employer match about $124,625 at 4% or $83,083 at 6%.
200510$0$0-
Roger Ranfranz Pa Profit Sharing & Trust-0---
200414$104,230$0-
Roger Ranfranz Pa Profit Sharing & Trust-4$104,230--
200313$0$0-
Roger Ranfranz Pa Profit Sharing & Trust-3---
200214$77,850$54,989$13,747iApproximate average salary by contribution assumption: employee only about $343,681 at 4% or $229,121 at 6%; with 50% employer match about $229,121 at 4% or $152,747 at 6%; with 100% employer match about $171,841 at 4% or $114,560 at 6%.
Roger Ranfranz Pa Profit Sharing & Trust-4$77,850$54,989$13,747iApproximate average salary by contribution assumption: employee only about $343,681 at 4% or $229,121 at 6%; with 50% employer match about $229,121 at 4% or $152,747 at 6%; with 100% employer match about $171,841 at 4% or $114,560 at 6%.
200112$0$0-
Roger Ranfranz Pa Profit Sharing & Trust-2---
200013$474,140$0-
Roger Ranfranz Pa Profit Sharing & Trust-3$474,140--
199913$489,442$10,000$3,333iApproximate average salary by contribution assumption: employee only about $83,333 at 4% or $55,556 at 6%; with 50% employer match about $55,556 at 4% or $37,037 at 6%; with 100% employer match about $41,667 at 4% or $27,778 at 6%.
Roger Ranfranz Pa Profit Sharing & Trust-3$489,442$10,000$3,333iApproximate average salary by contribution assumption: employee only about $83,333 at 4% or $55,556 at 6%; with 50% employer match about $55,556 at 4% or $37,037 at 6%; with 100% employer match about $41,667 at 4% or $27,778 at 6%.