THE CHILDRENS GUILD, INC. has sponsored the creation of one or more 401k plans.
Submission information for form 5500 for 401k plan THE CHILDREN'S GUILD, INC. DEFINED BENEFIT PENSION PLAN & TRUST
401k plan membership statisitcs for THE CHILDREN'S GUILD, INC. DEFINED BENEFIT PENSION PLAN & TRUST
Measure | Date | Value |
---|
2023: THE CHILDREN'S GUILD, INC. DEFINED BENEFIT PENSION PLAN & TRUST 2023 401k membership |
---|
Market value of plan assets | 2023-06-30 | 302,902 |
Acturial value of plan assets | 2023-06-30 | 302,902 |
Funding target for retired participants and beneficiaries receiving payment | 2023-06-30 | 124,702 |
Number of terminated vested participants | 2023-06-30 | 9 |
Fundng target for terminated vested participants | 2023-06-30 | 254,618 |
Active participant vested funding target | 2023-06-30 | 15,930 |
Number of active participants | 2023-06-30 | 1 |
Total funding liabilities for active participants | 2023-06-30 | 15,930 |
Total participant count | 2023-06-30 | 13 |
Total funding target for all participants | 2023-06-30 | 395,250 |
Balance at beginning of prior year after applicable adjustments | 2023-06-30 | 31,869 |
Prefunding balance at beginning of prior year after applicable adjustments | 2023-06-30 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2023-06-30 | 14,349 |
Prefunding balanced used to offset prior years funding requirement | 2023-06-30 | 0 |
Amount remaining of carryover balance | 2023-06-30 | 17,520 |
Amount remaining of prefunding balance | 2023-06-30 | 0 |
Present value of excess contributions | 2023-06-30 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2023-06-30 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2023-06-30 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2023-06-30 | 0 |
Balance of carryovers at beginning of current year | 2023-06-30 | 18,117 |
Balance of prefunding at beginning of current year | 2023-06-30 | 0 |
Total employer contributions | 2023-06-30 | 0 |
Total employee contributions | 2023-06-30 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2023-06-30 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2023-06-30 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2023-06-30 | 0 |
Unpaid minimum required contributions for all prior years | 2023-06-30 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2023-06-30 | 0 |
Remaining amount of unpaid minimum required contributions | 2023-06-30 | 0 |
Minimum required contributions for current year target normal cost | 2023-06-30 | 5,955 |
Net shortfall amortization installment of oustanding balance | 2023-06-30 | 110,465 |
Waiver amortization installment | 2023-06-30 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2023-06-30 | 16,557 |
Carryover balance elected to use to offset funding requirement | 2023-06-30 | 16,557 |
Prefunding balance elected to use to offset funding requirement | 2023-06-30 | 0 |
Additional cash requirement | 2023-06-30 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2023-06-30 | 0 |
Unpaid minimum required contributions for current year | 2023-06-30 | 0 |
Unpaid minimum required contributions for all years | 2023-06-30 | 0 |
2022: THE CHILDREN'S GUILD, INC. DEFINED BENEFIT PENSION PLAN & TRUST 2022 401k membership |
---|
Market value of plan assets | 2022-06-30 | 390,932 |
Acturial value of plan assets | 2022-06-30 | 390,932 |
Funding target for retired participants and beneficiaries receiving payment | 2022-06-30 | 142,026 |
Number of terminated vested participants | 2022-06-30 | 10 |
Fundng target for terminated vested participants | 2022-06-30 | 289,002 |
Active participant vested funding target | 2022-06-30 | 20,641 |
Number of active participants | 2022-06-30 | 2 |
Total funding liabilities for active participants | 2022-06-30 | 20,641 |
Total participant count | 2022-06-30 | 16 |
Total funding target for all participants | 2022-06-30 | 451,669 |
Balance at beginning of prior year after applicable adjustments | 2022-06-30 | 56,581 |
Prefunding balance at beginning of prior year after applicable adjustments | 2022-06-30 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2022-06-30 | 25,976 |
Prefunding balanced used to offset prior years funding requirement | 2022-06-30 | 0 |
Amount remaining of carryover balance | 2022-06-30 | 30,605 |
Amount remaining of prefunding balance | 2022-06-30 | 0 |
Present value of excess contributions | 2022-06-30 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2022-06-30 | 0 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2022-06-30 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2022-06-30 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2022-06-30 | 0 |
Balance of carryovers at beginning of current year | 2022-06-30 | 31,869 |
Balance of prefunding at beginning of current year | 2022-06-30 | 0 |
Total employer contributions | 2022-06-30 | 0 |
Total employee contributions | 2022-06-30 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2022-06-30 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2022-06-30 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2022-06-30 | 0 |
Unpaid minimum required contributions for all prior years | 2022-06-30 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2022-06-30 | 0 |
Remaining amount of unpaid minimum required contributions | 2022-06-30 | 0 |
Minimum required contributions for current year target normal cost | 2022-06-30 | 5,714 |
Net shortfall amortization installment of oustanding balance | 2022-06-30 | 92,606 |
Waiver amortization installment | 2022-06-30 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2022-06-30 | 14,349 |
Carryover balance elected to use to offset funding requirement | 2022-06-30 | 14,349 |
Prefunding balance elected to use to offset funding requirement | 2022-06-30 | 0 |
Additional cash requirement | 2022-06-30 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2022-06-30 | 0 |
Unpaid minimum required contributions for current year | 2022-06-30 | 0 |
Unpaid minimum required contributions for all years | 2022-06-30 | 0 |
2020: THE CHILDREN'S GUILD, INC. DEFINED BENEFIT PENSION PLAN & TRUST 2020 401k membership |
---|
Market value of plan assets | 2020-06-30 | 562,435 |
Acturial value of plan assets | 2020-06-30 | 562,435 |
Funding target for retired participants and beneficiaries receiving payment | 2020-06-30 | 194,549 |
Number of terminated vested participants | 2020-06-30 | 10 |
Fundng target for terminated vested participants | 2020-06-30 | 233,746 |
Active participant vested funding target | 2020-06-30 | 169,971 |
Number of active participants | 2020-06-30 | 4 |
Total funding liabilities for active participants | 2020-06-30 | 169,971 |
Total participant count | 2020-06-30 | 19 |
Total funding target for all participants | 2020-06-30 | 598,266 |
Balance at beginning of prior year after applicable adjustments | 2020-06-30 | 274,290 |
Prefunding balance at beginning of prior year after applicable adjustments | 2020-06-30 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2020-06-30 | 6,573 |
Prefunding balanced used to offset prior years funding requirement | 2020-06-30 | 0 |
Amount remaining of carryover balance | 2020-06-30 | 267,717 |
Amount remaining of prefunding balance | 2020-06-30 | 0 |
Present value of excess contributions | 2020-06-30 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2020-06-30 | 0 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2020-06-30 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2020-06-30 | 195,000 |
Reductions in prefunding balances due to elections or deemed elections | 2020-06-30 | 0 |
Balance of carryovers at beginning of current year | 2020-06-30 | 79,972 |
Balance of prefunding at beginning of current year | 2020-06-30 | 0 |
Total employer contributions | 2020-06-30 | 0 |
Total employee contributions | 2020-06-30 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2020-06-30 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2020-06-30 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2020-06-30 | 0 |
Unpaid minimum required contributions for all prior years | 2020-06-30 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2020-06-30 | 0 |
Remaining amount of unpaid minimum required contributions | 2020-06-30 | 0 |
Minimum required contributions for current year target normal cost | 2020-06-30 | 6,323 |
Net shortfall amortization installment of oustanding balance | 2020-06-30 | 115,803 |
Waiver amortization installment | 2020-06-30 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2020-06-30 | 25,140 |
Carryover balance elected to use to offset funding requirement | 2020-06-30 | 25,140 |
Prefunding balance elected to use to offset funding requirement | 2020-06-30 | 0 |
Additional cash requirement | 2020-06-30 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2020-06-30 | 0 |
Unpaid minimum required contributions for current year | 2020-06-30 | 0 |
Unpaid minimum required contributions for all years | 2020-06-30 | 0 |
2019: THE CHILDREN'S GUILD, INC. DEFINED BENEFIT PENSION PLAN & TRUST 2019 401k membership |
---|
Market value of plan assets | 2019-06-30 | 734,614 |
Acturial value of plan assets | 2019-06-30 | 734,614 |
Funding target for retired participants and beneficiaries receiving payment | 2019-06-30 | 204,053 |
Number of terminated vested participants | 2019-06-30 | 17 |
Fundng target for terminated vested participants | 2019-06-30 | 358,120 |
Active participant vested funding target | 2019-06-30 | 123,979 |
Number of active participants | 2019-06-30 | 4 |
Total funding liabilities for active participants | 2019-06-30 | 123,979 |
Total participant count | 2019-06-30 | 26 |
Total funding target for all participants | 2019-06-30 | 686,152 |
Balance at beginning of prior year after applicable adjustments | 2019-06-30 | 271,616 |
Prefunding balance at beginning of prior year after applicable adjustments | 2019-06-30 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2019-06-30 | 6,243 |
Prefunding balanced used to offset prior years funding requirement | 2019-06-30 | 0 |
Amount remaining of carryover balance | 2019-06-30 | 265,373 |
Amount remaining of prefunding balance | 2019-06-30 | 0 |
Present value of excess contributions | 2019-06-30 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2019-06-30 | 0 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2019-06-30 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2019-06-30 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2019-06-30 | 0 |
Balance of carryovers at beginning of current year | 2019-06-30 | 274,290 |
Balance of prefunding at beginning of current year | 2019-06-30 | 0 |
Total employer contributions | 2019-06-30 | 0 |
Total employee contributions | 2019-06-30 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2019-06-30 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2019-06-30 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2019-06-30 | 0 |
Unpaid minimum required contributions for all prior years | 2019-06-30 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2019-06-30 | 0 |
Remaining amount of unpaid minimum required contributions | 2019-06-30 | 0 |
Minimum required contributions for current year target normal cost | 2019-06-30 | 6,573 |
Net shortfall amortization installment of oustanding balance | 2019-06-30 | 0 |
Waiver amortization installment | 2019-06-30 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2019-06-30 | 6,573 |
Carryover balance elected to use to offset funding requirement | 2019-06-30 | 6,573 |
Prefunding balance elected to use to offset funding requirement | 2019-06-30 | 0 |
Additional cash requirement | 2019-06-30 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2019-06-30 | 0 |
Unpaid minimum required contributions for current year | 2019-06-30 | 0 |
Unpaid minimum required contributions for all years | 2019-06-30 | 0 |
2018: THE CHILDREN'S GUILD, INC. DEFINED BENEFIT PENSION PLAN & TRUST 2018 401k membership |
---|
Market value of plan assets | 2018-06-30 | 744,652 |
Acturial value of plan assets | 2018-06-30 | 744,652 |
Funding target for retired participants and beneficiaries receiving payment | 2018-06-30 | 252,907 |
Number of terminated vested participants | 2018-06-30 | 17 |
Fundng target for terminated vested participants | 2018-06-30 | 295,428 |
Active participant vested funding target | 2018-06-30 | 118,845 |
Number of active participants | 2018-06-30 | 4 |
Total funding liabilities for active participants | 2018-06-30 | 118,845 |
Total participant count | 2018-06-30 | 26 |
Total funding target for all participants | 2018-06-30 | 667,180 |
Balance at beginning of prior year after applicable adjustments | 2018-06-30 | 267,951 |
Prefunding balance at beginning of prior year after applicable adjustments | 2018-06-30 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2018-06-30 | 6,228 |
Prefunding balanced used to offset prior years funding requirement | 2018-06-30 | 0 |
Amount remaining of carryover balance | 2018-06-30 | 261,723 |
Amount remaining of prefunding balance | 2018-06-30 | 0 |
Present value of excess contributions | 2018-06-30 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2018-06-30 | 0 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2018-06-30 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2018-06-30 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2018-06-30 | 0 |
Balance of carryovers at beginning of current year | 2018-06-30 | 271,616 |
Balance of prefunding at beginning of current year | 2018-06-30 | 0 |
Total employer contributions | 2018-06-30 | 0 |
Total employee contributions | 2018-06-30 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2018-06-30 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2018-06-30 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2018-06-30 | 0 |
Unpaid minimum required contributions for all prior years | 2018-06-30 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2018-06-30 | 0 |
Remaining amount of unpaid minimum required contributions | 2018-06-30 | 0 |
Minimum required contributions for current year target normal cost | 2018-06-30 | 6,243 |
Net shortfall amortization installment of oustanding balance | 2018-06-30 | 0 |
Waiver amortization installment | 2018-06-30 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2018-06-30 | 6,243 |
Carryover balance elected to use to offset funding requirement | 2018-06-30 | 6,243 |
Prefunding balance elected to use to offset funding requirement | 2018-06-30 | 0 |
Additional cash requirement | 2018-06-30 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2018-06-30 | 0 |
Unpaid minimum required contributions for current year | 2018-06-30 | 0 |
Unpaid minimum required contributions for all years | 2018-06-30 | 0 |
2017: THE CHILDREN'S GUILD, INC. DEFINED BENEFIT PENSION PLAN & TRUST 2017 401k membership |
---|
Market value of plan assets | 2017-06-30 | 756,366 |
Acturial value of plan assets | 2017-06-30 | 756,366 |
Funding target for retired participants and beneficiaries receiving payment | 2017-06-30 | 280,736 |
Number of terminated vested participants | 2017-06-30 | 17 |
Fundng target for terminated vested participants | 2017-06-30 | 287,365 |
Active participant vested funding target | 2017-06-30 | 118,467 |
Number of active participants | 2017-06-30 | 4 |
Total funding liabilities for active participants | 2017-06-30 | 118,467 |
Total participant count | 2017-06-30 | 27 |
Total funding target for all participants | 2017-06-30 | 686,568 |
Balance at beginning of prior year after applicable adjustments | 2017-06-30 | 263,569 |
Prefunding balance at beginning of prior year after applicable adjustments | 2017-06-30 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2017-06-30 | 6,147 |
Prefunding balanced used to offset prior years funding requirement | 2017-06-30 | 0 |
Amount remaining of carryover balance | 2017-06-30 | 257,422 |
Amount remaining of prefunding balance | 2017-06-30 | 0 |
Present value of excess contributions | 2017-06-30 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2017-06-30 | 0 |
Balance of carryovers at beginning of current year | 2017-06-30 | 267,951 |
Balance of prefunding at beginning of current year | 2017-06-30 | 0 |
Total employer contributions | 2017-06-30 | 0 |
Total employee contributions | 2017-06-30 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2017-06-30 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2017-06-30 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2017-06-30 | 0 |
Unpaid minimum required contributions for all prior years | 2017-06-30 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2017-06-30 | 0 |
Remaining amount of unpaid minimum required contributions | 2017-06-30 | 0 |
Minimum required contributions for current year target normal cost | 2017-06-30 | 6,123 |
Net shortfall amortization installment of oustanding balance | 2017-06-30 | 0 |
Waiver amortization installment | 2017-06-30 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2017-06-30 | 6,123 |
Carryover balance elected to use to offset funding requirement | 2017-06-30 | 6,123 |
Additional cash requirement | 2017-06-30 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2017-06-30 | 0 |
Unpaid minimum required contributions for current year | 2017-06-30 | 0 |
Unpaid minimum required contributions for all years | 2017-06-30 | 0 |