Civic Intelligence

Rainbow Motor Sales LLC

Plan context: RAINBOW MOTOR SALES, LLC CASH BALANCE PENSION PLAN

EIN 38-3582035 • Coldwater, MI • 12 filings • 6 plans

395 N. Fremont Rd.Coldwater, MI 49036-9413
Current Snapshot

Latest Year

2024

2024 Participants

10

2024 Assets

$1,281,741

2024 Contributions

$273,141

Historical Graphs

Total Assets Over Time

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

$1,281,741$640,871$0200620222024YearValue
$1,281,741Latest year 2024

Participants Over Time

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

1050200620222024YearValue
10Latest 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
2024310$1,281,741$273,141$27,314iApproximate average salary by contribution assumption: employee only about $682,853 at 4% or $455,235 at 6%; with 50% employer match about $455,235 at 4% or $303,490 at 6%; with 100% employer match about $341,426 at 4% or $227,618 at 6%.
RAINBOW MOTOR SALES, LLC CASH BALANCE PENSION PLAN-6$969,456$250,000$41,667iApproximate average salary by contribution assumption: employee only about $1,041,667 at 4% or $694,444 at 6%; with 50% employer match about $694,444 at 4% or $462,963 at 6%; with 100% employer match about $520,833 at 4% or $347,222 at 6%.
RAINBOW MOTOR SALES, LLC 401(K) PLAN AND TRUST-10$312,285$23,141$2,314iApproximate average salary by contribution assumption: employee only about $57,853 at 4% or $38,568 at 6%; with 50% employer match about $38,568 at 4% or $25,712 at 6%; with 100% employer match about $28,926 at 4% or $19,284 at 6%.
RAINBOW MOTOR SALES, LLC PROFIT SHARING PLAN AND TRUST-0$0--
202339$1,025,855$366,692$40,744iApproximate average salary by contribution assumption: employee only about $1,018,589 at 4% or $679,059 at 6%; with 50% employer match about $679,059 at 4% or $452,706 at 6%; with 100% employer match about $509,294 at 4% or $339,530 at 6%.
RAINBOW MOTOR SALES, LLC CASH BALANCE PENSION PLAN AND TRUST-7$725,125$244,568$34,938iApproximate average salary by contribution assumption: employee only about $873,457 at 4% or $582,305 at 6%; with 50% employer match about $582,305 at 4% or $388,203 at 6%; with 100% employer match about $436,729 at 4% or $291,152 at 6%.
RAINBOW MOTOR SALES, LLC PROFIT-SHARING PLAN AND TRUST-9$257,973$93,409$10,379iApproximate average salary by contribution assumption: employee only about $259,469 at 4% or $172,980 at 6%; with 50% employer match about $172,980 at 4% or $115,320 at 6%; with 100% employer match about $129,735 at 4% or $86,490 at 6%.
RAINBOW MOTOR SALES, LLC 401(K) PLAN AND TRUST-8$42,757$28,715$3,589iApproximate average salary by contribution assumption: employee only about $89,734 at 4% or $59,823 at 6%; with 50% employer match about $59,823 at 4% or $39,882 at 6%; with 100% employer match about $44,867 at 4% or $29,911 at 6%.
202239$669,514$348,450$38,717iApproximate average salary by contribution assumption: employee only about $967,917 at 4% or $645,278 at 6%; with 50% employer match about $645,278 at 4% or $430,185 at 6%; with 100% employer match about $483,958 at 4% or $322,639 at 6%.
RAINBOW MOTOR SALES, LLC CASH BALANCE PENSION PLAN AND TRUST-7$493,102$251,204$35,886iApproximate average salary by contribution assumption: employee only about $897,157 at 4% or $598,105 at 6%; with 50% employer match about $598,105 at 4% or $398,737 at 6%; with 100% employer match about $448,579 at 4% or $299,052 at 6%.
RAINBOW MOTOR SALES, LLC PROFIT-SHARING PLAN AND TRUST-7$161,800$82,813$11,830iApproximate average salary by contribution assumption: employee only about $295,761 at 4% or $197,174 at 6%; with 50% employer match about $197,174 at 4% or $131,449 at 6%; with 100% employer match about $147,880 at 4% or $98,587 at 6%.
RAINBOW MOTOR SALES, LLC 401(K) PLAN AND TRUST-9$14,612$14,433$1,604iApproximate average salary by contribution assumption: employee only about $40,092 at 4% or $26,728 at 6%; with 50% employer match about $26,728 at 4% or $17,819 at 6%; with 100% employer match about $20,046 at 4% or $13,364 at 6%.
200910$0$826-
Rainbow Motor Sales LLC 401K P/S Plan-0-$826-
200814$45,798$19,599$4,900iApproximate average salary by contribution assumption: employee only about $122,494 at 4% or $81,663 at 6%; with 50% employer match about $81,663 at 4% or $54,442 at 6%; with 100% employer match about $61,247 at 4% or $40,831 at 6%.
Rainbow Motor Sales LLC 401K P/S Plan-4$45,798$19,599$4,900iApproximate average salary by contribution assumption: employee only about $122,494 at 4% or $81,663 at 6%; with 50% employer match about $81,663 at 4% or $54,442 at 6%; with 100% employer match about $61,247 at 4% or $40,831 at 6%.
200614$19,279$19,145$4,786iApproximate average salary by contribution assumption: employee only about $119,656 at 4% or $79,771 at 6%; with 50% employer match about $79,771 at 4% or $53,181 at 6%; with 100% employer match about $59,828 at 4% or $39,885 at 6%.
Rainbow Motor Sales LLC 401K P/S Plan-4$19,279$19,145$4,786iApproximate average salary by contribution assumption: employee only about $119,656 at 4% or $79,771 at 6%; with 50% employer match about $79,771 at 4% or $53,181 at 6%; with 100% employer match about $59,828 at 4% or $39,885 at 6%.