Civic Intelligence

Rainbow Gas Company

Plan context: Rainbow Gas Company Employees' Profit Sharing Plan

EIN 91-1853065 • Bismarck, ND • 28 filings • 3 plans

PO Box 837Bismarck, ND 58502
Current Snapshot

Latest Year

2024

2024 Participants

70

2024 Assets

$36,489,155

2024 Contributions

$1,640,268

Historical Graphs

Total Assets Over Time

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

$36,489,155$18,244,578$0200420152024YearValue
$36,489,155Latest year 2024

Participants Over Time

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

76380200420142024YearValue
70Latest 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
2024170$36,489,155$1,640,268$23,432iApproximate average salary by contribution assumption: employee only about $585,810 at 4% or $390,540 at 6%; with 50% employer match about $390,540 at 4% or $260,360 at 6%; with 100% employer match about $292,905 at 4% or $195,270 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-70$36,489,155$1,640,268$23,432iApproximate average salary by contribution assumption: employee only about $585,810 at 4% or $390,540 at 6%; with 50% employer match about $390,540 at 4% or $260,360 at 6%; with 100% employer match about $292,905 at 4% or $195,270 at 6%.
2023170$31,355,430$1,562,094$22,316iApproximate average salary by contribution assumption: employee only about $557,891 at 4% or $371,927 at 6%; with 50% employer match about $371,927 at 4% or $247,951 at 6%; with 100% employer match about $278,945 at 4% or $185,964 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-70$31,355,430$1,562,094$22,316iApproximate average salary by contribution assumption: employee only about $557,891 at 4% or $371,927 at 6%; with 50% employer match about $371,927 at 4% or $247,951 at 6%; with 100% employer match about $278,945 at 4% or $185,964 at 6%.
2022176$27,305,093$1,907,639$25,101iApproximate average salary by contribution assumption: employee only about $627,513 at 4% or $418,342 at 6%; with 50% employer match about $418,342 at 4% or $278,895 at 6%; with 100% employer match about $313,756 at 4% or $209,171 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-76$27,305,093$1,907,639$25,101iApproximate average salary by contribution assumption: employee only about $627,513 at 4% or $418,342 at 6%; with 50% employer match about $418,342 at 4% or $278,895 at 6%; with 100% employer match about $313,756 at 4% or $209,171 at 6%.
2021175$30,085,272$2,383,246$31,777iApproximate average salary by contribution assumption: employee only about $794,415 at 4% or $529,610 at 6%; with 50% employer match about $529,610 at 4% or $353,073 at 6%; with 100% employer match about $397,208 at 4% or $264,805 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-75$30,085,272$2,383,246$31,777iApproximate average salary by contribution assumption: employee only about $794,415 at 4% or $529,610 at 6%; with 50% employer match about $529,610 at 4% or $353,073 at 6%; with 100% employer match about $397,208 at 4% or $264,805 at 6%.
2020169$23,621,261$1,332,627$19,313iApproximate average salary by contribution assumption: employee only about $482,836 at 4% or $321,891 at 6%; with 50% employer match about $321,891 at 4% or $214,594 at 6%; with 100% employer match about $241,418 at 4% or $160,945 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-69$23,621,261$1,332,627$19,313iApproximate average salary by contribution assumption: employee only about $482,836 at 4% or $321,891 at 6%; with 50% employer match about $321,891 at 4% or $214,594 at 6%; with 100% employer match about $241,418 at 4% or $160,945 at 6%.
2019173$21,151,745$1,610,049$22,055iApproximate average salary by contribution assumption: employee only about $551,387 at 4% or $367,591 at 6%; with 50% employer match about $367,591 at 4% or $245,061 at 6%; with 100% employer match about $275,693 at 4% or $183,796 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-73$21,151,745$1,610,049$22,055iApproximate average salary by contribution assumption: employee only about $551,387 at 4% or $367,591 at 6%; with 50% employer match about $367,591 at 4% or $245,061 at 6%; with 100% employer match about $275,693 at 4% or $183,796 at 6%.
2018173$16,667,989$1,225,600$16,789iApproximate average salary by contribution assumption: employee only about $419,726 at 4% or $279,817 at 6%; with 50% employer match about $279,817 at 4% or $186,545 at 6%; with 100% employer match about $209,863 at 4% or $139,909 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-73$16,667,989$1,225,600$16,789iApproximate average salary by contribution assumption: employee only about $419,726 at 4% or $279,817 at 6%; with 50% employer match about $279,817 at 4% or $186,545 at 6%; with 100% employer match about $209,863 at 4% or $139,909 at 6%.
2017160$17,250,074$1,117,456$18,624iApproximate average salary by contribution assumption: employee only about $465,607 at 4% or $310,404 at 6%; with 50% employer match about $310,404 at 4% or $206,936 at 6%; with 100% employer match about $232,803 at 4% or $155,202 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-60$17,250,074$1,117,456$18,624iApproximate average salary by contribution assumption: employee only about $465,607 at 4% or $310,404 at 6%; with 50% employer match about $310,404 at 4% or $206,936 at 6%; with 100% employer match about $232,803 at 4% or $155,202 at 6%.
2016163$14,894,452$1,031,213$16,368iApproximate average salary by contribution assumption: employee only about $409,212 at 4% or $272,808 at 6%; with 50% employer match about $272,808 at 4% or $181,872 at 6%; with 100% employer match about $204,606 at 4% or $136,404 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-63$14,894,452$1,031,213$16,368iApproximate average salary by contribution assumption: employee only about $409,212 at 4% or $272,808 at 6%; with 50% employer match about $272,808 at 4% or $181,872 at 6%; with 100% employer match about $204,606 at 4% or $136,404 at 6%.
2015159$12,204,382$1,041,889$17,659iApproximate average salary by contribution assumption: employee only about $441,478 at 4% or $294,319 at 6%; with 50% employer match about $294,319 at 4% or $196,213 at 6%; with 100% employer match about $220,739 at 4% or $147,159 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-59$12,204,382$1,041,889$17,659iApproximate average salary by contribution assumption: employee only about $441,478 at 4% or $294,319 at 6%; with 50% employer match about $294,319 at 4% or $196,213 at 6%; with 100% employer match about $220,739 at 4% or $147,159 at 6%.
2014153$13,076,749$865,825$16,336iApproximate average salary by contribution assumption: employee only about $408,408 at 4% or $272,272 at 6%; with 50% employer match about $272,272 at 4% or $181,515 at 6%; with 100% employer match about $204,204 at 4% or $136,136 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-53$13,076,749$865,825$16,336iApproximate average salary by contribution assumption: employee only about $408,408 at 4% or $272,272 at 6%; with 50% employer match about $272,272 at 4% or $181,515 at 6%; with 100% employer match about $204,204 at 4% or $136,136 at 6%.
2013147$14,113,815$776,678$16,525iApproximate average salary by contribution assumption: employee only about $413,127 at 4% or $275,418 at 6%; with 50% employer match about $275,418 at 4% or $183,612 at 6%; with 100% employer match about $206,563 at 4% or $137,709 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-47$14,113,815$776,678$16,525iApproximate average salary by contribution assumption: employee only about $413,127 at 4% or $275,418 at 6%; with 50% employer match about $275,418 at 4% or $183,612 at 6%; with 100% employer match about $206,563 at 4% or $137,709 at 6%.
2012149$10,980,763$822,398$16,784iApproximate average salary by contribution assumption: employee only about $419,591 at 4% or $279,727 at 6%; with 50% employer match about $279,727 at 4% or $186,485 at 6%; with 100% employer match about $209,795 at 4% or $139,864 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-49$10,980,763$822,398$16,784iApproximate average salary by contribution assumption: employee only about $419,591 at 4% or $279,727 at 6%; with 50% employer match about $279,727 at 4% or $186,485 at 6%; with 100% employer match about $209,795 at 4% or $139,864 at 6%.
2011149$9,596,084$927,703$18,933iApproximate average salary by contribution assumption: employee only about $473,318 at 4% or $315,545 at 6%; with 50% employer match about $315,545 at 4% or $210,363 at 6%; with 100% employer match about $236,659 at 4% or $157,773 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-49$9,596,084$927,703$18,933iApproximate average salary by contribution assumption: employee only about $473,318 at 4% or $315,545 at 6%; with 50% employer match about $315,545 at 4% or $210,363 at 6%; with 100% employer match about $236,659 at 4% or $157,773 at 6%.
2010252$8,513,343$1,794,083$34,502iApproximate average salary by contribution assumption: employee only about $862,540 at 4% or $575,027 at 6%; with 50% employer match about $575,027 at 4% or $383,351 at 6%; with 100% employer match about $431,270 at 4% or $287,513 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-52$8,513,343$1,794,083$34,502iApproximate average salary by contribution assumption: employee only about $862,540 at 4% or $575,027 at 6%; with 50% employer match about $575,027 at 4% or $383,351 at 6%; with 100% employer match about $431,270 at 4% or $287,513 at 6%.
RAINBOW GAS COMPANY EMPLOYEES DEFINED BENEFIT PLAN-0$0--
2009249$6,430,586$832,167$16,983iApproximate average salary by contribution assumption: employee only about $424,575 at 4% or $283,050 at 6%; with 50% employer match about $283,050 at 4% or $188,700 at 6%; with 100% employer match about $212,288 at 4% or $141,525 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-49$5,449,349$832,167$16,983iApproximate average salary by contribution assumption: employee only about $424,575 at 4% or $283,050 at 6%; with 50% employer match about $283,050 at 4% or $188,700 at 6%; with 100% employer match about $212,288 at 4% or $141,525 at 6%.
RAINBOW GAS COMPANY EMPLOYEES DEFINED BENEFIT PLAN-1$981,237--
2008244$4,808,948$1,041,885$23,679iApproximate average salary by contribution assumption: employee only about $591,980 at 4% or $394,653 at 6%; with 50% employer match about $394,653 at 4% or $263,102 at 6%; with 100% employer match about $295,990 at 4% or $197,327 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-44$3,845,925$1,041,885$23,679iApproximate average salary by contribution assumption: employee only about $591,980 at 4% or $394,653 at 6%; with 50% employer match about $394,653 at 4% or $263,102 at 6%; with 100% employer match about $295,990 at 4% or $197,327 at 6%.
RAINBOW GAS COMPANY EMPLOYEES DEFINED BENEFIT PLAN-1$963,023--
2007244$0$0-
RAINBOW GAS COMPANY EMPLOYEES DEFINED BENEFIT PLAN-24---
Rainbow Gas Company Employees' Profit Sharing Plan-44---
2006236$5,237,536$839,321$23,314iApproximate average salary by contribution assumption: employee only about $582,862 at 4% or $388,575 at 6%; with 50% employer match about $388,575 at 4% or $259,050 at 6%; with 100% employer match about $291,431 at 4% or $194,287 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-36$3,277,894$553,122$15,365iApproximate average salary by contribution assumption: employee only about $384,113 at 4% or $256,075 at 6%; with 50% employer match about $256,075 at 4% or $170,717 at 6%; with 100% employer match about $192,056 at 4% or $128,038 at 6%.
RAINBOW GAS COMPANY EMPLOYEES DEFINED BENEFIT PLAN-25$1,959,642$286,199$11,448iApproximate average salary by contribution assumption: employee only about $286,199 at 4% or $190,799 at 6%; with 50% employer match about $190,799 at 4% or $127,200 at 6%; with 100% employer match about $143,100 at 4% or $95,400 at 6%.
2005236$3,923,499$682,230$18,951iApproximate average salary by contribution assumption: employee only about $473,771 at 4% or $315,847 at 6%; with 50% employer match about $315,847 at 4% or $210,565 at 6%; with 100% employer match about $236,885 at 4% or $157,924 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-36$2,414,877$427,123$11,865iApproximate average salary by contribution assumption: employee only about $296,613 at 4% or $197,742 at 6%; with 50% employer match about $197,742 at 4% or $131,828 at 6%; with 100% employer match about $148,307 at 4% or $98,871 at 6%.
RAINBOW GAS COMPANY EMPLOYEES DEFINED BENEFIT PLAN-17$1,508,622$255,107$15,006iApproximate average salary by contribution assumption: employee only about $375,157 at 4% or $250,105 at 6%; with 50% employer match about $250,105 at 4% or $166,737 at 6%; with 100% employer match about $187,579 at 4% or $125,052 at 6%.
2004233$2,938,113$503,174$15,248iApproximate average salary by contribution assumption: employee only about $381,192 at 4% or $254,128 at 6%; with 50% employer match about $254,128 at 4% or $169,419 at 6%; with 100% employer match about $190,596 at 4% or $127,064 at 6%.
Rainbow Gas Company Employees' Profit Sharing Plan-33$1,748,011$306,107$9,276iApproximate average salary by contribution assumption: employee only about $231,899 at 4% or $154,599 at 6%; with 50% employer match about $154,599 at 4% or $103,066 at 6%; with 100% employer match about $115,950 at 4% or $77,300 at 6%.
RAINBOW GAS COMPANY EMPLOYEES DEFINED BENEFIT PLAN-19$1,190,102$197,067$10,372iApproximate average salary by contribution assumption: employee only about $259,299 at 4% or $172,866 at 6%; with 50% employer match about $172,866 at 4% or $115,244 at 6%; with 100% employer match about $129,649 at 4% or $86,433 at 6%.