Civic Intelligence

Brett Farnham Dds, Professional LLC

Plan context: BRETT FARNHAM DDS CASH BALANCE PLAN

EIN 46-0462941 • Mitchell, SD • 35 filings • 4 plans

2110 N. Minnesota AvenueMitchell, SD 57301
Current Snapshot

Latest Year

2025

2025 Participants

14

2025 Assets

$3,094,549

2025 Contributions

$81,088

Historical Graphs

Total Assets Over Time

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

$4,957,462$2,478,731$0200820172025YearValue
$3,094,549Latest year 2025

Participants Over Time

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

23120200820172025YearValue
14Latest 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
2025114$3,094,549$81,088$5,792iApproximate average salary by contribution assumption: employee only about $144,800 at 4% or $96,533 at 6%; with 50% employer match about $96,533 at 4% or $64,356 at 6%; with 100% employer match about $72,400 at 4% or $48,267 at 6%.
BRETT FARNHAM DDS CASH BALANCE PLAN-14$3,094,549$81,088$5,792iApproximate average salary by contribution assumption: employee only about $144,800 at 4% or $96,533 at 6%; with 50% employer match about $96,533 at 4% or $64,356 at 6%; with 100% employer match about $72,400 at 4% or $48,267 at 6%.
2024223$4,957,462$272,444$11,845iApproximate average salary by contribution assumption: employee only about $296,135 at 4% or $197,423 at 6%; with 50% employer match about $197,423 at 4% or $131,615 at 6%; with 100% employer match about $148,067 at 4% or $98,712 at 6%.
BRETT FARNHAM DDS CASH BALANCE PLAN-13$2,601,852$125,000$9,615iApproximate average salary by contribution assumption: employee only about $240,385 at 4% or $160,256 at 6%; with 50% employer match about $160,256 at 4% or $106,838 at 6%; with 100% employer match about $120,192 at 4% or $80,128 at 6%.
Brett Farnham Dds 401(K) Plan-23$2,355,610$147,444$6,411iApproximate average salary by contribution assumption: employee only about $160,265 at 4% or $106,843 at 6%; with 50% employer match about $106,843 at 4% or $71,229 at 6%; with 100% employer match about $80,133 at 4% or $53,422 at 6%.
2023220$4,197,691$243,622$12,181iApproximate average salary by contribution assumption: employee only about $304,528 at 4% or $203,018 at 6%; with 50% employer match about $203,018 at 4% or $135,346 at 6%; with 100% employer match about $152,264 at 4% or $101,509 at 6%.
BRETT FARNHAM DDS CASH BALANCE PLAN-14$2,229,769$100,000$7,143iApproximate average salary by contribution assumption: employee only about $178,571 at 4% or $119,048 at 6%; with 50% employer match about $119,048 at 4% or $79,365 at 6%; with 100% employer match about $89,286 at 4% or $59,524 at 6%.
Brett Farnham Dds 401(K) Plan-20$1,967,922$143,622$7,181iApproximate average salary by contribution assumption: employee only about $179,528 at 4% or $119,685 at 6%; with 50% employer match about $119,685 at 4% or $79,790 at 6%; with 100% employer match about $89,764 at 4% or $59,843 at 6%.
2022219$3,718,377$219,718$11,564iApproximate average salary by contribution assumption: employee only about $289,103 at 4% or $192,735 at 6%; with 50% employer match about $192,735 at 4% or $128,490 at 6%; with 100% employer match about $144,551 at 4% or $96,368 at 6%.
BRETT FARNHAM DDS CASH BALANCE PLAN-14$1,925,045$70,436$5,031iApproximate average salary by contribution assumption: employee only about $125,779 at 4% or $83,852 at 6%; with 50% employer match about $83,852 at 4% or $55,902 at 6%; with 100% employer match about $62,889 at 4% or $41,926 at 6%.
Brett Farnham Dds 401(K) Plan-19$1,793,332$149,282$7,857iApproximate average salary by contribution assumption: employee only about $196,424 at 4% or $130,949 at 6%; with 50% employer match about $130,949 at 4% or $87,299 at 6%; with 100% employer match about $98,212 at 4% or $65,475 at 6%.
2021217$4,131,286$161,799$9,518iApproximate average salary by contribution assumption: employee only about $237,940 at 4% or $158,626 at 6%; with 50% employer match about $158,626 at 4% or $105,751 at 6%; with 100% employer match about $118,970 at 4% or $79,313 at 6%.
BRETT FARNHAM DDS CASH BALANCE PLAN-12$2,132,938$0-
Brett Farnham Dds 401(K) Plan-17$1,998,348$161,799$9,518iApproximate average salary by contribution assumption: employee only about $237,940 at 4% or $158,626 at 6%; with 50% employer match about $158,626 at 4% or $105,751 at 6%; with 100% employer match about $118,970 at 4% or $79,313 at 6%.
2020216$3,506,432$90,842$5,678iApproximate average salary by contribution assumption: employee only about $141,941 at 4% or $94,627 at 6%; with 50% employer match about $94,627 at 4% or $63,085 at 6%; with 100% employer match about $70,970 at 4% or $47,314 at 6%.
BRETT FARNHAM DDS CASH BALANCE PLAN-14$1,899,286$0-
Brett Farnham Dds 401(K) Plan-16$1,607,146$90,842$5,678iApproximate average salary by contribution assumption: employee only about $141,941 at 4% or $94,627 at 6%; with 50% employer match about $94,627 at 4% or $63,085 at 6%; with 100% employer match about $70,970 at 4% or $47,314 at 6%.
2019215$3,144,513$127,614$8,508iApproximate average salary by contribution assumption: employee only about $212,690 at 4% or $141,793 at 6%; with 50% employer match about $141,793 at 4% or $94,529 at 6%; with 100% employer match about $106,345 at 4% or $70,897 at 6%.
BRETT FARNHAM DDS CASH BALANCE PLAN-15$1,760,377$0-
Brett Farnham Dds 401(K) Plan-15$1,384,136$127,614$8,508iApproximate average salary by contribution assumption: employee only about $212,690 at 4% or $141,793 at 6%; with 50% employer match about $141,793 at 4% or $94,529 at 6%; with 100% employer match about $106,345 at 4% or $70,897 at 6%.
2018214$2,539,842$63,288$4,521iApproximate average salary by contribution assumption: employee only about $113,014 at 4% or $75,343 at 6%; with 50% employer match about $75,343 at 4% or $50,229 at 6%; with 100% employer match about $56,507 at 4% or $37,671 at 6%.
BRETT FARNHAM DDS CASH BALANCE PLAN-14$1,510,112$0-
Brett Farnham Dds 401(K) Plan-12$1,029,730$63,288$5,274iApproximate average salary by contribution assumption: employee only about $131,850 at 4% or $87,900 at 6%; with 50% employer match about $87,900 at 4% or $58,600 at 6%; with 100% employer match about $65,925 at 4% or $43,950 at 6%.
2017212$2,433,707$196,236$16,353iApproximate average salary by contribution assumption: employee only about $408,825 at 4% or $272,550 at 6%; with 50% employer match about $272,550 at 4% or $181,700 at 6%; with 100% employer match about $204,413 at 4% or $136,275 at 6%.
BRETT FARNHAM DDS CASH BALANCE-12$1,468,446$137,436$11,453iApproximate average salary by contribution assumption: employee only about $286,325 at 4% or $190,883 at 6%; with 50% employer match about $190,883 at 4% or $127,256 at 6%; with 100% employer match about $143,163 at 4% or $95,442 at 6%.
Brett Farnham Dds 401(K) Plan-12$965,261$58,800$4,900iApproximate average salary by contribution assumption: employee only about $122,500 at 4% or $81,667 at 6%; with 50% employer match about $81,667 at 4% or $54,444 at 6%; with 100% employer match about $61,250 at 4% or $40,833 at 6%.
2016211$1,869,716$215,870$19,625iApproximate average salary by contribution assumption: employee only about $490,614 at 4% or $327,076 at 6%; with 50% employer match about $327,076 at 4% or $218,051 at 6%; with 100% employer match about $245,307 at 4% or $163,538 at 6%.
BRETT FARNHAM DDS CASH BALANCE-11$1,120,856$84,200$7,655iApproximate average salary by contribution assumption: employee only about $191,364 at 4% or $127,576 at 6%; with 50% employer match about $127,576 at 4% or $85,051 at 6%; with 100% employer match about $95,682 at 4% or $63,788 at 6%.
Brett Farnham Dds 401(K) Plan-11$748,860$131,670$11,970iApproximate average salary by contribution assumption: employee only about $299,250 at 4% or $199,500 at 6%; with 50% employer match about $199,500 at 4% or $133,000 at 6%; with 100% employer match about $149,625 at 4% or $99,750 at 6%.
2015211$1,618,076$61,777$5,616iApproximate average salary by contribution assumption: employee only about $140,402 at 4% or $93,602 at 6%; with 50% employer match about $93,602 at 4% or $62,401 at 6%; with 100% employer match about $70,201 at 4% or $46,801 at 6%.
BRETT FARNHAM DDS CASH BALANCE-11$1,002,838--
Brett Farnham Dds 401(K) Plan-11$615,238$61,777$5,616iApproximate average salary by contribution assumption: employee only about $140,402 at 4% or $93,602 at 6%; with 50% employer match about $93,602 at 4% or $62,401 at 6%; with 100% employer match about $70,201 at 4% or $46,801 at 6%.
2014211$1,519,756$165,320$15,029iApproximate average salary by contribution assumption: employee only about $375,727 at 4% or $250,485 at 6%; with 50% employer match about $250,485 at 4% or $166,990 at 6%; with 100% employer match about $187,864 at 4% or $125,242 at 6%.
BRETT FARNHAM DDS CASH BALANCE-11$970,934$100,000$9,091iApproximate average salary by contribution assumption: employee only about $227,273 at 4% or $151,515 at 6%; with 50% employer match about $151,515 at 4% or $101,010 at 6%; with 100% employer match about $113,636 at 4% or $75,758 at 6%.
Brett Farnham Dds 401(K) Plan-9$548,822$65,320$7,258iApproximate average salary by contribution assumption: employee only about $181,444 at 4% or $120,963 at 6%; with 50% employer match about $120,963 at 4% or $80,642 at 6%; with 100% employer match about $90,722 at 4% or $60,481 at 6%.
201329$1,283,911$44,871$4,986iApproximate average salary by contribution assumption: employee only about $124,642 at 4% or $83,094 at 6%; with 50% employer match about $83,094 at 4% or $55,396 at 6%; with 100% employer match about $62,321 at 4% or $41,547 at 6%.
BRETT FARNHAM DDS CASH BALANCE-9$803,695--
Brett Farnham Dds 401(K) Plan-9$480,216$44,871$4,986iApproximate average salary by contribution assumption: employee only about $124,642 at 4% or $83,094 at 6%; with 50% employer match about $83,094 at 4% or $55,396 at 6%; with 100% employer match about $62,321 at 4% or $41,547 at 6%.
2012210$958,673$267,215$26,722iApproximate average salary by contribution assumption: employee only about $668,038 at 4% or $445,358 at 6%; with 50% employer match about $445,358 at 4% or $296,906 at 6%; with 100% employer match about $334,019 at 4% or $222,679 at 6%.
BRETT FARNHAM DDS CASH BALANCE-9$616,293$203,245$22,583iApproximate average salary by contribution assumption: employee only about $564,569 at 4% or $376,380 at 6%; with 50% employer match about $376,380 at 4% or $250,920 at 6%; with 100% employer match about $282,285 at 4% or $188,190 at 6%.
Brett Farnham Dds 401(K) Plan-10$342,380$63,970$6,397iApproximate average salary by contribution assumption: employee only about $159,925 at 4% or $106,617 at 6%; with 50% employer match about $106,617 at 4% or $71,078 at 6%; with 100% employer match about $79,963 at 4% or $53,308 at 6%.
2011210$567,315$101,193$10,119iApproximate average salary by contribution assumption: employee only about $252,982 at 4% or $168,655 at 6%; with 50% employer match about $168,655 at 4% or $112,437 at 6%; with 100% employer match about $126,491 at 4% or $84,328 at 6%.
BRETT FARNHAM DDS CASH BALANCE-8$338,757$32,781$4,098iApproximate average salary by contribution assumption: employee only about $102,441 at 4% or $68,294 at 6%; with 50% employer match about $68,294 at 4% or $45,529 at 6%; with 100% employer match about $51,220 at 4% or $34,147 at 6%.
Brett Farnham Dds 401(K) Plan-10$228,558$68,412$6,841iApproximate average salary by contribution assumption: employee only about $171,030 at 4% or $114,020 at 6%; with 50% employer match about $114,020 at 4% or $76,013 at 6%; with 100% employer match about $85,515 at 4% or $57,010 at 6%.
201029$512,471$87,409$9,712iApproximate average salary by contribution assumption: employee only about $242,803 at 4% or $161,869 at 6%; with 50% employer match about $161,869 at 4% or $107,912 at 6%; with 100% employer match about $121,401 at 4% or $80,934 at 6%.
BRETT FARNHAM DDS CASH BALANCE-8$332,018$50,000$6,250iApproximate average salary by contribution assumption: employee only about $156,250 at 4% or $104,167 at 6%; with 50% employer match about $104,167 at 4% or $69,444 at 6%; with 100% employer match about $78,125 at 4% or $52,083 at 6%.
Brett Farnham Dds 401(K) Plan-9$180,453$37,409$4,157iApproximate average salary by contribution assumption: employee only about $103,914 at 4% or $69,276 at 6%; with 50% employer match about $69,276 at 4% or $46,184 at 6%; with 100% employer match about $51,957 at 4% or $34,638 at 6%.
200928$377,982$188,670$23,584iApproximate average salary by contribution assumption: employee only about $589,594 at 4% or $393,063 at 6%; with 50% employer match about $393,063 at 4% or $262,042 at 6%; with 100% employer match about $294,797 at 4% or $196,531 at 6%.
BRETT FARNHAM DDS CASH BALANCE-8$246,509$127,809$15,976iApproximate average salary by contribution assumption: employee only about $399,403 at 4% or $266,269 at 6%; with 50% employer match about $266,269 at 4% or $177,513 at 6%; with 100% employer match about $199,702 at 4% or $133,134 at 6%.
Brett Farnham Dds 401(K) Plan-7$131,473$60,861$8,694iApproximate average salary by contribution assumption: employee only about $217,361 at 4% or $144,907 at 6%; with 50% employer match about $144,907 at 4% or $96,605 at 6%; with 100% employer match about $108,680 at 4% or $72,454 at 6%.
200827$121,992$147,822$21,117iApproximate average salary by contribution assumption: employee only about $527,936 at 4% or $351,957 at 6%; with 50% employer match about $351,957 at 4% or $234,638 at 6%; with 100% employer match about $263,968 at 4% or $175,979 at 6%.
BRETT FARNHAM DDS CASH BALANCE-7$79,940$93,799$13,400iApproximate average salary by contribution assumption: employee only about $334,996 at 4% or $223,331 at 6%; with 50% employer match about $223,331 at 4% or $148,887 at 6%; with 100% employer match about $167,498 at 4% or $111,665 at 6%.
Brett Farnham Dds 401(K) Plan-7$42,052$54,023$7,718iApproximate average salary by contribution assumption: employee only about $192,939 at 4% or $128,626 at 6%; with 50% employer match about $128,626 at 4% or $85,751 at 6%; with 100% employer match about $96,470 at 4% or $64,313 at 6%.