RED SPOT PAINT & VARNISH CO., INC. has sponsored the creation of one or more 401k plans.
Submission information for form 5500 for 401k plan RED SPOT-WESTLAND BARGAINING UNIT EMPLOYEES' PENSION PLAN
401k plan membership statisitcs for RED SPOT-WESTLAND BARGAINING UNIT EMPLOYEES' PENSION PLAN
Measure | Date | Value |
---|
2023: RED SPOT-WESTLAND BARGAINING UNIT EMPLOYEES' PENSION PLAN 2023 401k membership |
---|
Market value of plan assets | 2023-02-28 | 4,694,899 |
Acturial value of plan assets | 2023-02-28 | 4,510,398 |
Funding target for retired participants and beneficiaries receiving payment | 2023-02-28 | 1,332,097 |
Number of terminated vested participants | 2023-02-28 | 34 |
Fundng target for terminated vested participants | 2023-02-28 | 1,794,506 |
Active participant vested funding target | 2023-02-28 | 0 |
Number of active participants | 2023-02-28 | 0 |
Total funding liabilities for active participants | 2023-02-28 | 0 |
Total participant count | 2023-02-28 | 59 |
Total funding target for all participants | 2023-02-28 | 3,126,603 |
Balance at beginning of prior year after applicable adjustments | 2023-02-28 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2023-02-28 | 535,037 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2023-02-28 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2023-02-28 | 0 |
Amount remaining of carryover balance | 2023-02-28 | 0 |
Amount remaining of prefunding balance | 2023-02-28 | 535,037 |
Present value of excess contributions | 2023-02-28 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2023-02-28 | 0 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2023-02-28 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2023-02-28 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2023-02-28 | 0 |
Balance of carryovers at beginning of current year | 2023-02-28 | 0 |
Balance of prefunding at beginning of current year | 2023-02-28 | 557,402 |
Total employer contributions | 2023-02-28 | 0 |
Total employee contributions | 2023-02-28 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2023-02-28 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2023-02-28 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2023-02-28 | 0 |
Unpaid minimum required contributions for all prior years | 2023-02-28 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2023-02-28 | 0 |
Remaining amount of unpaid minimum required contributions | 2023-02-28 | 0 |
Minimum required contributions for current year target normal cost | 2023-02-28 | 12,000 |
Net shortfall amortization installment of oustanding balance | 2023-02-28 | 0 |
Waiver amortization installment | 2023-02-28 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2023-02-28 | 0 |
Carryover balance elected to use to offset funding requirement | 2023-02-28 | 0 |
Prefunding balance elected to use to offset funding requirement | 2023-02-28 | 0 |
Additional cash requirement | 2023-02-28 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2023-02-28 | 0 |
Unpaid minimum required contributions for current year | 2023-02-28 | 0 |
Unpaid minimum required contributions for all years | 2023-02-28 | 0 |
2022: RED SPOT-WESTLAND BARGAINING UNIT EMPLOYEES' PENSION PLAN 2022 401k membership |
---|
Market value of plan assets | 2022-02-28 | 4,627,027 |
Acturial value of plan assets | 2022-02-28 | 4,164,325 |
Funding target for retired participants and beneficiaries receiving payment | 2022-02-28 | 1,264,568 |
Number of terminated vested participants | 2022-02-28 | 36 |
Fundng target for terminated vested participants | 2022-02-28 | 1,822,316 |
Active participant vested funding target | 2022-02-28 | 0 |
Number of active participants | 2022-02-28 | 0 |
Total funding liabilities for active participants | 2022-02-28 | 0 |
Total participant count | 2022-02-28 | 59 |
Total funding target for all participants | 2022-02-28 | 3,086,884 |
Balance at beginning of prior year after applicable adjustments | 2022-02-28 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2022-02-28 | 426,324 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2022-02-28 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2022-02-28 | 0 |
Amount remaining of carryover balance | 2022-02-28 | 0 |
Amount remaining of prefunding balance | 2022-02-28 | 426,324 |
Present value of excess contributions | 2022-02-28 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2022-02-28 | 0 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2022-02-28 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2022-02-28 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2022-02-28 | 0 |
Balance of carryovers at beginning of current year | 2022-02-28 | 0 |
Balance of prefunding at beginning of current year | 2022-02-28 | 535,037 |
Total employer contributions | 2022-02-28 | 0 |
Total employee contributions | 2022-02-28 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2022-02-28 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2022-02-28 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2022-02-28 | 0 |
Unpaid minimum required contributions for all prior years | 2022-02-28 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2022-02-28 | 0 |
Remaining amount of unpaid minimum required contributions | 2022-02-28 | 0 |
Minimum required contributions for current year target normal cost | 2022-02-28 | 10,000 |
Net shortfall amortization installment of oustanding balance | 2022-02-28 | 0 |
Waiver amortization installment | 2022-02-28 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2022-02-28 | 0 |
Carryover balance elected to use to offset funding requirement | 2022-02-28 | 0 |
Prefunding balance elected to use to offset funding requirement | 2022-02-28 | 0 |
Additional cash requirement | 2022-02-28 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2022-02-28 | 0 |
Unpaid minimum required contributions for current year | 2022-02-28 | 0 |
Unpaid minimum required contributions for all years | 2022-02-28 | 0 |
2021: RED SPOT-WESTLAND BARGAINING UNIT EMPLOYEES' PENSION PLAN 2021 401k membership |
---|
Market value of plan assets | 2021-02-28 | 3,794,226 |
Acturial value of plan assets | 2021-02-28 | 3,837,148 |
Funding target for retired participants and beneficiaries receiving payment | 2021-02-28 | 1,336,149 |
Number of terminated vested participants | 2021-02-28 | 33 |
Fundng target for terminated vested participants | 2021-02-28 | 1,283,408 |
Active participant vested funding target | 2021-02-28 | 532,719 |
Number of active participants | 2021-02-28 | 5 |
Total funding liabilities for active participants | 2021-02-28 | 532,719 |
Total participant count | 2021-02-28 | 60 |
Total funding target for all participants | 2021-02-28 | 3,152,276 |
Balance at beginning of prior year after applicable adjustments | 2021-02-28 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2021-02-28 | 400,982 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2021-02-28 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2021-02-28 | 0 |
Amount remaining of carryover balance | 2021-02-28 | 0 |
Amount remaining of prefunding balance | 2021-02-28 | 400,982 |
Present value of excess contributions | 2021-02-28 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2021-02-28 | 0 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2021-02-28 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2021-02-28 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2021-02-28 | 0 |
Balance of carryovers at beginning of current year | 2021-02-28 | 0 |
Balance of prefunding at beginning of current year | 2021-02-28 | 426,324 |
Total employer contributions | 2021-02-28 | 0 |
Total employee contributions | 2021-02-28 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2021-02-28 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2021-02-28 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2021-02-28 | 0 |
Unpaid minimum required contributions for all prior years | 2021-02-28 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2021-02-28 | 0 |
Remaining amount of unpaid minimum required contributions | 2021-02-28 | 0 |
Minimum required contributions for current year target normal cost | 2021-02-28 | 18,248 |
Net shortfall amortization installment of oustanding balance | 2021-02-28 | 0 |
Waiver amortization installment | 2021-02-28 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2021-02-28 | 0 |
Carryover balance elected to use to offset funding requirement | 2021-02-28 | 0 |
Prefunding balance elected to use to offset funding requirement | 2021-02-28 | 0 |
Additional cash requirement | 2021-02-28 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2021-02-28 | 0 |
Unpaid minimum required contributions for current year | 2021-02-28 | 0 |
Unpaid minimum required contributions for all years | 2021-02-28 | 0 |
2020: RED SPOT-WESTLAND BARGAINING UNIT EMPLOYEES' PENSION PLAN 2020 401k membership |
---|
Market value of plan assets | 2020-02-29 | 3,664,228 |
Acturial value of plan assets | 2020-02-29 | 3,730,164 |
Funding target for retired participants and beneficiaries receiving payment | 2020-02-29 | 970,002 |
Number of terminated vested participants | 2020-02-29 | 38 |
Fundng target for terminated vested participants | 2020-02-29 | 1,553,316 |
Active participant vested funding target | 2020-02-29 | 502,441 |
Number of active participants | 2020-02-29 | 5 |
Total funding liabilities for active participants | 2020-02-29 | 502,441 |
Total participant count | 2020-02-29 | 60 |
Total funding target for all participants | 2020-02-29 | 3,025,759 |
Balance at beginning of prior year after applicable adjustments | 2020-02-29 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2020-02-29 | 397,169 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2020-02-29 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2020-02-29 | 0 |
Amount remaining of carryover balance | 2020-02-29 | 0 |
Amount remaining of prefunding balance | 2020-02-29 | 397,169 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2020-02-29 | 0 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2020-02-29 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2020-02-29 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2020-02-29 | 0 |
Balance of carryovers at beginning of current year | 2020-02-29 | 0 |
Balance of prefunding at beginning of current year | 2020-02-29 | 400,982 |
Total employer contributions | 2020-02-29 | 0 |
Total employee contributions | 2020-02-29 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2020-02-29 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2020-02-29 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2020-02-29 | 0 |
Unpaid minimum required contributions for all prior years | 2020-02-29 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2020-02-29 | 0 |
Remaining amount of unpaid minimum required contributions | 2020-02-29 | 0 |
Minimum required contributions for current year target normal cost | 2020-02-29 | 17,521 |
Net shortfall amortization installment of oustanding balance | 2020-02-29 | 0 |
Waiver amortization installment | 2020-02-29 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2020-02-29 | 0 |
Carryover balance elected to use to offset funding requirement | 2020-02-29 | 0 |
Prefunding balance elected to use to offset funding requirement | 2020-02-29 | 0 |
Additional cash requirement | 2020-02-29 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2020-02-29 | 0 |
Unpaid minimum required contributions for current year | 2020-02-29 | 0 |
Unpaid minimum required contributions for all years | 2020-02-29 | 0 |
2019: RED SPOT-WESTLAND BARGAINING UNIT EMPLOYEES' PENSION PLAN 2019 401k membership |
---|
Market value of plan assets | 2019-02-28 | 3,716,610 |
Acturial value of plan assets | 2019-02-28 | 3,530,742 |
Funding target for retired participants and beneficiaries receiving payment | 2019-02-28 | 932,094 |
Number of terminated vested participants | 2019-02-28 | 39 |
Fundng target for terminated vested participants | 2019-02-28 | 1,472,987 |
Active participant vested funding target | 2019-02-28 | 447,899 |
Number of active participants | 2019-02-28 | 5 |
Total funding liabilities for active participants | 2019-02-28 | 447,899 |
Total participant count | 2019-02-28 | 60 |
Total funding target for all participants | 2019-02-28 | 2,852,980 |
Balance at beginning of prior year after applicable adjustments | 2019-02-28 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2019-02-28 | 358,780 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2019-02-28 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2019-02-28 | 0 |
Amount remaining of carryover balance | 2019-02-28 | 0 |
Amount remaining of prefunding balance | 2019-02-28 | 358,780 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2019-02-28 | 0 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2019-02-28 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2019-02-28 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2019-02-28 | 0 |
Balance of carryovers at beginning of current year | 2019-02-28 | 0 |
Balance of prefunding at beginning of current year | 2019-02-28 | 397,169 |
Total employer contributions | 2019-02-28 | 0 |
Total employee contributions | 2019-02-28 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2019-02-28 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2019-02-28 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2019-02-28 | 0 |
Unpaid minimum required contributions for all prior years | 2019-02-28 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2019-02-28 | 0 |
Remaining amount of unpaid minimum required contributions | 2019-02-28 | 0 |
Minimum required contributions for current year target normal cost | 2019-02-28 | 22,153 |
Net shortfall amortization installment of oustanding balance | 2019-02-28 | 0 |
Waiver amortization installment | 2019-02-28 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2019-02-28 | 0 |
Carryover balance elected to use to offset funding requirement | 2019-02-28 | 0 |
Prefunding balance elected to use to offset funding requirement | 2019-02-28 | 0 |
Additional cash requirement | 2019-02-28 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2019-02-28 | 0 |
Unpaid minimum required contributions for current year | 2019-02-28 | 0 |
Unpaid minimum required contributions for all years | 2019-02-28 | 0 |
2018: RED SPOT-WESTLAND BARGAINING UNIT EMPLOYEES' PENSION PLAN 2018 401k membership |
---|
Market value of plan assets | 2018-02-28 | 3,440,295 |
Acturial value of plan assets | 2018-02-28 | 3,416,429 |
Funding target for retired participants and beneficiaries receiving payment | 2018-02-28 | 939,990 |
Number of terminated vested participants | 2018-02-28 | 40 |
Fundng target for terminated vested participants | 2018-02-28 | 1,341,323 |
Active participant vested funding target | 2018-02-28 | 386,465 |
Number of active participants | 2018-02-28 | 5 |
Total funding liabilities for active participants | 2018-02-28 | 386,465 |
Total participant count | 2018-02-28 | 62 |
Total funding target for all participants | 2018-02-28 | 2,667,778 |
Balance at beginning of prior year after applicable adjustments | 2018-02-28 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2018-02-28 | 64,021 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2018-02-28 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2018-02-28 | 0 |
Amount remaining of carryover balance | 2018-02-28 | 0 |
Amount remaining of prefunding balance | 2018-02-28 | 64,021 |
Present value of excess contributions | 2018-02-28 | 268,542 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2018-02-28 | 285,245 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2018-02-28 | 285,245 |
Reductions in caryover balances due to elections or deemed elections | 2018-02-28 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2018-02-28 | 0 |
Balance of carryovers at beginning of current year | 2018-02-28 | 0 |
Balance of prefunding at beginning of current year | 2018-02-28 | 358,780 |
Total employer contributions | 2018-02-28 | 0 |
Total employee contributions | 2018-02-28 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2018-02-28 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2018-02-28 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2018-02-28 | 0 |
Unpaid minimum required contributions for all prior years | 2018-02-28 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2018-02-28 | 0 |
Remaining amount of unpaid minimum required contributions | 2018-02-28 | 0 |
Minimum required contributions for current year target normal cost | 2018-02-28 | 19,573 |
Net shortfall amortization installment of oustanding balance | 2018-02-28 | 0 |
Waiver amortization installment | 2018-02-28 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2018-02-28 | 0 |
Carryover balance elected to use to offset funding requirement | 2018-02-28 | 0 |
Prefunding balance elected to use to offset funding requirement | 2018-02-28 | 0 |
Additional cash requirement | 2018-02-28 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2018-02-28 | 0 |
Unpaid minimum required contributions for current year | 2018-02-28 | 0 |
Unpaid minimum required contributions for all years | 2018-02-28 | 0 |
2017: RED SPOT-WESTLAND BARGAINING UNIT EMPLOYEES' PENSION PLAN 2017 401k membership |
---|
Market value of plan assets | 2017-02-28 | 2,829,785 |
Acturial value of plan assets | 2017-02-28 | 3,089,573 |
Funding target for retired participants and beneficiaries receiving payment | 2017-02-28 | 927,502 |
Number of terminated vested participants | 2017-02-28 | 40 |
Fundng target for terminated vested participants | 2017-02-28 | 1,228,730 |
Active participant vested funding target | 2017-02-28 | 354,294 |
Number of active participants | 2017-02-28 | 5 |
Total funding liabilities for active participants | 2017-02-28 | 354,294 |
Total participant count | 2017-02-28 | 62 |
Total funding target for all participants | 2017-02-28 | 2,510,526 |
Balance at beginning of prior year after applicable adjustments | 2017-02-28 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2017-02-28 | 68,729 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2017-02-28 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2017-02-28 | 0 |
Amount remaining of carryover balance | 2017-02-28 | 0 |
Amount remaining of prefunding balance | 2017-02-28 | 68,729 |
Present value of excess contributions | 2017-02-28 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2017-02-28 | 0 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2017-02-28 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2017-02-28 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2017-02-28 | 0 |
Balance of carryovers at beginning of current year | 2017-02-28 | 0 |
Balance of prefunding at beginning of current year | 2017-02-28 | 64,021 |
Total employer contributions | 2017-02-28 | 290,000 |
Total employee contributions | 2017-02-28 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2017-02-28 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2017-02-28 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2017-02-28 | 268,542 |
Unpaid minimum required contributions for all prior years | 2017-02-28 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2017-02-28 | 0 |
Remaining amount of unpaid minimum required contributions | 2017-02-28 | 0 |
Minimum required contributions for current year target normal cost | 2017-02-28 | 21,483 |
Net shortfall amortization installment of oustanding balance | 2017-02-28 | 0 |
Waiver amortization installment | 2017-02-28 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2017-02-28 | 0 |
Carryover balance elected to use to offset funding requirement | 2017-02-28 | 0 |
Prefunding balance elected to use to offset funding requirement | 2017-02-28 | 0 |
Additional cash requirement | 2017-02-28 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2017-02-28 | 268,542 |
Unpaid minimum required contributions for current year | 2017-02-28 | 0 |
Unpaid minimum required contributions for all years | 2017-02-28 | 0 |