JAMES F. SEXTON AND ASSOCIATES, LTD. has sponsored the creation of one or more 401k plans.
Submission information for form 5500 for 401k plan JAMES F. SEXTON & ASSOCIATES, LTD. DEFINED BENEFIT PLAN
401k plan membership statisitcs for JAMES F. SEXTON & ASSOCIATES, LTD. DEFINED BENEFIT PLAN
Measure | Date | Value |
---|
2022: JAMES F. SEXTON & ASSOCIATES, LTD. DEFINED BENEFIT PLAN 2022 401k membership |
---|
Market value of plan assets | 2022-12-31 | 2,203,374 |
Acturial value of plan assets | 2022-12-31 | 2,203,374 |
Funding target for retired participants and beneficiaries receiving payment | 2022-12-31 | 0 |
Number of terminated vested participants | 2022-12-31 | 1 |
Fundng target for terminated vested participants | 2022-12-31 | 124,363 |
Active participant vested funding target | 2022-12-31 | 1,927,300 |
Number of active participants | 2022-12-31 | 2 |
Total funding liabilities for active participants | 2022-12-31 | 1,927,300 |
Total participant count | 2022-12-31 | 3 |
Total funding target for all participants | 2022-12-31 | 2,051,663 |
Balance at beginning of prior year after applicable adjustments | 2022-12-31 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2022-12-31 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2022-12-31 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2022-12-31 | 0 |
Amount remaining of carryover balance | 2022-12-31 | 0 |
Amount remaining of prefunding balance | 2022-12-31 | 0 |
Present value of excess contributions | 2022-12-31 | 82,399 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2022-12-31 | 82,399 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2022-12-31 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2022-12-31 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2022-12-31 | 0 |
Balance of carryovers at beginning of current year | 2022-12-31 | 0 |
Balance of prefunding at beginning of current year | 2022-12-31 | 0 |
Total employer contributions | 2022-12-31 | 55,000 |
Total employee contributions | 2022-12-31 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2022-12-31 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2022-12-31 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2022-12-31 | 53,140 |
Unpaid minimum required contributions for all prior years | 2022-12-31 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2022-12-31 | 0 |
Remaining amount of unpaid minimum required contributions | 2022-12-31 | 0 |
Minimum required contributions for current year target normal cost | 2022-12-31 | 0 |
Net shortfall amortization installment of oustanding balance | 2022-12-31 | 0 |
Waiver amortization installment | 2022-12-31 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2022-12-31 | 0 |
Carryover balance elected to use to offset funding requirement | 2022-12-31 | 0 |
Prefunding balance elected to use to offset funding requirement | 2022-12-31 | 0 |
Additional cash requirement | 2022-12-31 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2022-12-31 | 53,140 |
Unpaid minimum required contributions for current year | 2022-12-31 | 0 |
Unpaid minimum required contributions for all years | 2022-12-31 | 0 |
2021: JAMES F. SEXTON & ASSOCIATES, LTD. DEFINED BENEFIT PLAN 2021 401k membership |
---|
Market value of plan assets | 2021-12-31 | 2,393,491 |
Acturial value of plan assets | 2021-12-31 | 2,393,491 |
Funding target for retired participants and beneficiaries receiving payment | 2021-12-31 | 0 |
Number of terminated vested participants | 2021-12-31 | 1 |
Fundng target for terminated vested participants | 2021-12-31 | 115,843 |
Active participant vested funding target | 2021-12-31 | 1,790,005 |
Number of active participants | 2021-12-31 | 2 |
Total funding liabilities for active participants | 2021-12-31 | 1,790,005 |
Total participant count | 2021-12-31 | 3 |
Total funding target for all participants | 2021-12-31 | 1,905,848 |
Balance at beginning of prior year after applicable adjustments | 2021-12-31 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2021-12-31 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2021-12-31 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2021-12-31 | 0 |
Amount remaining of carryover balance | 2021-12-31 | 0 |
Amount remaining of prefunding balance | 2021-12-31 | 0 |
Present value of excess contributions | 2021-12-31 | 96,771 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2021-12-31 | 96,771 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2021-12-31 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2021-12-31 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2021-12-31 | 0 |
Balance of carryovers at beginning of current year | 2021-12-31 | 0 |
Balance of prefunding at beginning of current year | 2021-12-31 | 0 |
Total employer contributions | 2021-12-31 | 85,000 |
Total employee contributions | 2021-12-31 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2021-12-31 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2021-12-31 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2021-12-31 | 82,399 |
Unpaid minimum required contributions for all prior years | 2021-12-31 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2021-12-31 | 0 |
Remaining amount of unpaid minimum required contributions | 2021-12-31 | 0 |
Minimum required contributions for current year target normal cost | 2021-12-31 | 743 |
Net shortfall amortization installment of oustanding balance | 2021-12-31 | 0 |
Waiver amortization installment | 2021-12-31 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2021-12-31 | 0 |
Carryover balance elected to use to offset funding requirement | 2021-12-31 | 0 |
Prefunding balance elected to use to offset funding requirement | 2021-12-31 | 0 |
Additional cash requirement | 2021-12-31 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2021-12-31 | 82,399 |
Unpaid minimum required contributions for current year | 2021-12-31 | 0 |
Unpaid minimum required contributions for all years | 2021-12-31 | 0 |
2020: JAMES F. SEXTON & ASSOCIATES, LTD. DEFINED BENEFIT PLAN 2020 401k membership |
---|
Market value of plan assets | 2020-12-31 | 2,090,371 |
Acturial value of plan assets | 2020-12-31 | 2,090,371 |
Funding target for retired participants and beneficiaries receiving payment | 2020-12-31 | 0 |
Number of terminated vested participants | 2020-12-31 | 0 |
Fundng target for terminated vested participants | 2020-12-31 | 0 |
Active participant vested funding target | 2020-12-31 | 1,705,425 |
Number of active participants | 2020-12-31 | 3 |
Total funding liabilities for active participants | 2020-12-31 | 1,705,425 |
Total participant count | 2020-12-31 | 3 |
Total funding target for all participants | 2020-12-31 | 1,705,425 |
Balance at beginning of prior year after applicable adjustments | 2020-12-31 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2020-12-31 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2020-12-31 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2020-12-31 | 0 |
Amount remaining of carryover balance | 2020-12-31 | 0 |
Amount remaining of prefunding balance | 2020-12-31 | 0 |
Present value of excess contributions | 2020-12-31 | 115,678 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2020-12-31 | 115,678 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2020-12-31 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2020-12-31 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2020-12-31 | 0 |
Balance of carryovers at beginning of current year | 2020-12-31 | 0 |
Balance of prefunding at beginning of current year | 2020-12-31 | 0 |
Total employer contributions | 2020-12-31 | 100,000 |
Total employee contributions | 2020-12-31 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2020-12-31 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2020-12-31 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2020-12-31 | 96,771 |
Unpaid minimum required contributions for all prior years | 2020-12-31 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2020-12-31 | 0 |
Remaining amount of unpaid minimum required contributions | 2020-12-31 | 0 |
Minimum required contributions for current year target normal cost | 2020-12-31 | 0 |
Net shortfall amortization installment of oustanding balance | 2020-12-31 | 0 |
Waiver amortization installment | 2020-12-31 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2020-12-31 | 0 |
Carryover balance elected to use to offset funding requirement | 2020-12-31 | 0 |
Prefunding balance elected to use to offset funding requirement | 2020-12-31 | 0 |
Additional cash requirement | 2020-12-31 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2020-12-31 | 96,771 |
Unpaid minimum required contributions for current year | 2020-12-31 | 0 |
Unpaid minimum required contributions for all years | 2020-12-31 | 0 |
2019: JAMES F. SEXTON & ASSOCIATES, LTD. DEFINED BENEFIT PLAN 2019 401k membership |
---|
Market value of plan assets | 2019-12-31 | 1,895,271 |
Acturial value of plan assets | 2019-12-31 | 1,895,271 |
Funding target for retired participants and beneficiaries receiving payment | 2019-12-31 | 0 |
Number of terminated vested participants | 2019-12-31 | 0 |
Fundng target for terminated vested participants | 2019-12-31 | 0 |
Active participant vested funding target | 2019-12-31 | 1,650,753 |
Number of active participants | 2019-12-31 | 3 |
Total funding liabilities for active participants | 2019-12-31 | 1,650,753 |
Total participant count | 2019-12-31 | 3 |
Total funding target for all participants | 2019-12-31 | 1,650,753 |
Balance at beginning of prior year after applicable adjustments | 2019-12-31 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2019-12-31 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2019-12-31 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2019-12-31 | 0 |
Amount remaining of carryover balance | 2019-12-31 | 0 |
Amount remaining of prefunding balance | 2019-12-31 | 0 |
Present value of excess contributions | 2019-12-31 | 112,754 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2019-12-31 | 112,754 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2019-12-31 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2019-12-31 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2019-12-31 | 0 |
Balance of carryovers at beginning of current year | 2019-12-31 | 0 |
Balance of prefunding at beginning of current year | 2019-12-31 | 0 |
Total employer contributions | 2019-12-31 | 120,000 |
Total employee contributions | 2019-12-31 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2019-12-31 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2019-12-31 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2019-12-31 | 115,678 |
Liquidity shortfalls end of Q1 | 2019-12-31 | 0 |
Liquidity shortfalls end of Q2 | 2019-12-31 | 0 |
Liquidity shortfalls end of Q3 | 2019-12-31 | 0 |
Liquidity shortfalls end of Q4 | 2019-12-31 | 0 |
Unpaid minimum required contributions for all prior years | 2019-12-31 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2019-12-31 | 0 |
Remaining amount of unpaid minimum required contributions | 2019-12-31 | 0 |
Minimum required contributions for current year target normal cost | 2019-12-31 | 0 |
Net shortfall amortization installment of oustanding balance | 2019-12-31 | 0 |
Waiver amortization installment | 2019-12-31 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2019-12-31 | 0 |
Carryover balance elected to use to offset funding requirement | 2019-12-31 | 0 |
Prefunding balance elected to use to offset funding requirement | 2019-12-31 | 0 |
Additional cash requirement | 2019-12-31 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2019-12-31 | 115,678 |
Unpaid minimum required contributions for current year | 2019-12-31 | 0 |
Unpaid minimum required contributions for all years | 2019-12-31 | 0 |
2018: JAMES F. SEXTON & ASSOCIATES, LTD. DEFINED BENEFIT PLAN 2018 401k membership |
---|
Market value of plan assets | 2018-12-31 | 1,569,655 |
Acturial value of plan assets | 2018-12-31 | 1,569,655 |
Funding target for retired participants and beneficiaries receiving payment | 2018-12-31 | 0 |
Number of terminated vested participants | 2018-12-31 | 0 |
Fundng target for terminated vested participants | 2018-12-31 | 0 |
Active participant vested funding target | 2018-12-31 | 1,581,142 |
Number of active participants | 2018-12-31 | 4 |
Total funding liabilities for active participants | 2018-12-31 | 1,591,680 |
Total participant count | 2018-12-31 | 4 |
Total funding target for all participants | 2018-12-31 | 1,591,680 |
Balance at beginning of prior year after applicable adjustments | 2018-12-31 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2018-12-31 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2018-12-31 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2018-12-31 | 0 |
Amount remaining of carryover balance | 2018-12-31 | 0 |
Amount remaining of prefunding balance | 2018-12-31 | 0 |
Present value of excess contributions | 2018-12-31 | 109,459 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2018-12-31 | 109,459 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2018-12-31 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2018-12-31 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2018-12-31 | 0 |
Balance of carryovers at beginning of current year | 2018-12-31 | 0 |
Balance of prefunding at beginning of current year | 2018-12-31 | 0 |
Total employer contributions | 2018-12-31 | 120,000 |
Total employee contributions | 2018-12-31 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2018-12-31 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2018-12-31 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2018-12-31 | 116,350 |
Unpaid minimum required contributions for all prior years | 2018-12-31 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2018-12-31 | 0 |
Remaining amount of unpaid minimum required contributions | 2018-12-31 | 0 |
Minimum required contributions for current year target normal cost | 2018-12-31 | 0 |
Net shortfall amortization installment of oustanding balance | 2018-12-31 | 22,025 |
Waiver amortization installment | 2018-12-31 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2018-12-31 | 3,596 |
Carryover balance elected to use to offset funding requirement | 2018-12-31 | 0 |
Prefunding balance elected to use to offset funding requirement | 2018-12-31 | 0 |
Additional cash requirement | 2018-12-31 | 3,596 |
Contributions allocatedtoward minimum required contributions for current year | 2018-12-31 | 116,350 |
Unpaid minimum required contributions for current year | 2018-12-31 | 0 |
Unpaid minimum required contributions for all years | 2018-12-31 | 0 |
2017: JAMES F. SEXTON & ASSOCIATES, LTD. DEFINED BENEFIT PLAN 2017 401k membership |
---|
Market value of plan assets | 2017-12-31 | 1,584,677 |
Acturial value of plan assets | 2017-12-31 | 1,584,677 |
Funding target for retired participants and beneficiaries receiving payment | 2017-12-31 | 0 |
Number of terminated vested participants | 2017-12-31 | 0 |
Fundng target for terminated vested participants | 2017-12-31 | 0 |
Active participant vested funding target | 2017-12-31 | 1,472,409 |
Number of active participants | 2017-12-31 | 4 |
Total funding liabilities for active participants | 2017-12-31 | 1,492,119 |
Total participant count | 2017-12-31 | 4 |
Total funding target for all participants | 2017-12-31 | 1,492,119 |
Balance at beginning of prior year after applicable adjustments | 2017-12-31 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2017-12-31 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2017-12-31 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2017-12-31 | 0 |
Amount remaining of carryover balance | 2017-12-31 | 0 |
Amount remaining of prefunding balance | 2017-12-31 | 0 |
Present value of excess contributions | 2017-12-31 | 573 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2017-12-31 | 573 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2017-12-31 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2017-12-31 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2017-12-31 | 0 |
Balance of carryovers at beginning of current year | 2017-12-31 | 0 |
Balance of prefunding at beginning of current year | 2017-12-31 | 0 |
Total employer contributions | 2017-12-31 | 112,696 |
Total employee contributions | 2017-12-31 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2017-12-31 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2017-12-31 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2017-12-31 | 109,459 |
Unpaid minimum required contributions for all prior years | 2017-12-31 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2017-12-31 | 0 |
Remaining amount of unpaid minimum required contributions | 2017-12-31 | 0 |
Minimum required contributions for current year target normal cost | 2017-12-31 | 0 |
Net shortfall amortization installment of oustanding balance | 2017-12-31 | 0 |
Waiver amortization installment | 2017-12-31 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2017-12-31 | 0 |
Carryover balance elected to use to offset funding requirement | 2017-12-31 | 0 |
Prefunding balance elected to use to offset funding requirement | 2017-12-31 | 0 |
Additional cash requirement | 2017-12-31 | 0 |
Contributions allocatedtoward minimum required contributions for current year | 2017-12-31 | 109,459 |
Unpaid minimum required contributions for current year | 2017-12-31 | 0 |
Unpaid minimum required contributions for all years | 2017-12-31 | 0 |
2016: JAMES F. SEXTON & ASSOCIATES, LTD. DEFINED BENEFIT PLAN 2016 401k membership |
---|
Market value of plan assets | 2016-12-31 | 1,260,386 |
Acturial value of plan assets | 2016-12-31 | 1,260,386 |
Funding target for retired participants and beneficiaries receiving payment | 2016-12-31 | 0 |
Number of terminated vested participants | 2016-12-31 | 0 |
Fundng target for terminated vested participants | 2016-12-31 | 0 |
Active participant vested funding target | 2016-12-31 | 1,094,424 |
Number of active participants | 2016-12-31 | 4 |
Total funding liabilities for active participants | 2016-12-31 | 1,108,438 |
Total participant count | 2016-12-31 | 4 |
Total funding target for all participants | 2016-12-31 | 1,108,438 |
Balance at beginning of prior year after applicable adjustments | 2016-12-31 | 0 |
Prefunding balance at beginning of prior year after applicable adjustments | 2016-12-31 | 0 |
Carryover balanced portion elected for use to offset prior years funding requirement | 2016-12-31 | 0 |
Prefunding balanced used to offset prior years funding requirement | 2016-12-31 | 0 |
Amount remaining of carryover balance | 2016-12-31 | 0 |
Amount remaining of prefunding balance | 2016-12-31 | 0 |
Present value of excess contributions | 2016-12-31 | 106,559 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2016-12-31 | 106,559 |
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2016-12-31 | 0 |
Reductions in caryover balances due to elections or deemed elections | 2016-12-31 | 0 |
Reductions in prefunding balances due to elections or deemed elections | 2016-12-31 | 0 |
Balance of carryovers at beginning of current year | 2016-12-31 | 0 |
Balance of prefunding at beginning of current year | 2016-12-31 | 0 |
Total employer contributions | 2016-12-31 | 164,492 |
Total employee contributions | 2016-12-31 | 0 |
Contributions allocated toward unpaid minimum require contributions from prior years | 2016-12-31 | 0 |
Contributions made to avoid restrictions adjusted to valuation date | 2016-12-31 | 0 |
Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2016-12-31 | 158,270 |
Unpaid minimum required contributions for all prior years | 2016-12-31 | 0 |
iDiscounted employer contributions allocated toward unpaid minimum required contributions from prior years | 2016-12-31 | 0 |
Remaining amount of unpaid minimum required contributions | 2016-12-31 | 0 |
Minimum required contributions for current year target normal cost | 2016-12-31 | 309,645 |
Net shortfall amortization installment of oustanding balance | 2016-12-31 | 0 |
Waiver amortization installment | 2016-12-31 | 0 |
Waived amount of outstanding balance | 2016-12-31 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2016-12-31 | 157,697 |
Carryover balance elected to use to offset funding requirement | 2016-12-31 | 0 |
Prefunding balance elected to use to offset funding requirement | 2016-12-31 | 0 |
Additional cash requirement | 2016-12-31 | 157,697 |
Contributions allocatedtoward minimum required contributions for current year | 2016-12-31 | 158,270 |
Unpaid minimum required contributions for current year | 2016-12-31 | 0 |
Unpaid minimum required contributions for all years | 2016-12-31 | 0 |