?>
Plan Name | JOE SCHEMBRI DEFINED BENEFIT PENSION PLAN |
Plan identification number | 003 |
401k Plan Type | Defined Benefit Pension |
Plan Features/Benefits |
|
Company Name: | JOE SCHEMBRI REAL ESTATE TEAM, INC. |
Employer identification number (EIN): | 943141143 |
NAIC Classification: | 531210 |
NAIC Description: | Offices of Real Estate Agents and Brokers |
Additional information about JOE SCHEMBRI REAL ESTATE TEAM, INC.
Jurisdiction of Incorporation: | California Department of State |
Incorporation Date: | 2014-01-01 |
Company Identification Number: | C3630824 |
Legal Registered Office Address: |
1283 Bedford Street Fremont United States of America (USA) 94539 |
More information about JOE SCHEMBRI REAL ESTATE TEAM, INC.
Plan id# | Filing Submission Date | Name of Administrator | Date Administrator Signed | Name of Company Sponsor | Date Sponsor Signed |
---|---|---|---|---|---|
003 | 2022-01-01 | JOE SCHEMBRI | 2023-09-28 | ||
003 | 2021-01-01 | JOE SCHEMBRI | 2022-07-13 | ||
003 | 2020-01-01 | JOE SCHEMBRI | 2021-10-05 | ||
003 | 2019-01-01 | JOE SCHEMBRI | 2020-10-08 | ||
003 | 2018-01-01 |
Measure | Date | Value |
---|---|---|
2022: JOE SCHEMBRI DEFINED BENEFIT PENSION PLAN 2022 401k membership | ||
Market value of plan assets | 2022-12-31 | 574,760 |
Acturial value of plan assets | 2022-12-31 | 574,760 |
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 | 0 |
Active participant vested funding target | 2022-12-31 | 407,944 |
Number of active participants | 2022-12-31 | 5 |
Total funding liabilities for active participants | 2022-12-31 | 509,930 |
Total participant count | 2022-12-31 | 6 |
Total funding target for all participants | 2022-12-31 | 509,930 |
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 | 201,670 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2022-12-31 | 201,670 |
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 | 0 |
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 | 0 |
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 | 0 |
Unpaid minimum required contributions for current year | 2022-12-31 | 0 |
Unpaid minimum required contributions for all years | 2022-12-31 | 0 |
2021: JOE SCHEMBRI DEFINED BENEFIT PENSION PLAN 2021 401k membership | ||
Market value of plan assets | 2021-12-31 | 475,806 |
Acturial value of plan assets | 2021-12-31 | 475,806 |
Funding target for retired participants and beneficiaries receiving payment | 2021-12-31 | 0 |
Number of terminated vested participants | 2021-12-31 | 0 |
Fundng target for terminated vested participants | 2021-12-31 | 0 |
Active participant vested funding target | 2021-12-31 | 193,388 |
Number of active participants | 2021-12-31 | 4 |
Total funding liabilities for active participants | 2021-12-31 | 483,469 |
Total participant count | 2021-12-31 | 4 |
Total funding target for all participants | 2021-12-31 | 483,469 |
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 | 3 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2021-12-31 | 3 |
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 | 206,630 |
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 | 202,502 |
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 | 0 |
Net shortfall amortization installment of oustanding balance | 2021-12-31 | 7,663 |
Waiver amortization installment | 2021-12-31 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2021-12-31 | 832 |
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 | 832 |
Contributions allocatedtoward minimum required contributions for current year | 2021-12-31 | 202,502 |
Unpaid minimum required contributions for current year | 2021-12-31 | 0 |
Unpaid minimum required contributions for all years | 2021-12-31 | 0 |
2020: JOE SCHEMBRI DEFINED BENEFIT PENSION PLAN 2020 401k membership | ||
Market value of plan assets | 2020-12-31 | 433,674 |
Acturial value of plan assets | 2020-12-31 | 433,674 |
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 | 92,292 |
Number of active participants | 2020-12-31 | 4 |
Total funding liabilities for active participants | 2020-12-31 | 461,462 |
Total participant count | 2020-12-31 | 4 |
Total funding target for all participants | 2020-12-31 | 461,462 |
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 | 60,624 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2020-12-31 | 60,624 |
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 | 2,782 |
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 | 2,612 |
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 | 27,788 |
Waiver amortization installment | 2020-12-31 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2020-12-31 | 2,609 |
Additional cash requirement | 2020-12-31 | 2,609 |
Contributions allocatedtoward minimum required contributions for current year | 2020-12-31 | 2,612 |
Unpaid minimum required contributions for current year | 2020-12-31 | 0 |
Unpaid minimum required contributions for all years | 2020-12-31 | 0 |
2019: JOE SCHEMBRI DEFINED BENEFIT PENSION PLAN 2019 401k membership | ||
Market value of plan assets | 2019-12-31 | 337,283 |
Acturial value of plan assets | 2019-12-31 | 337,283 |
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 | 0 |
Number of active participants | 2019-12-31 | 4 |
Total funding liabilities for active participants | 2019-12-31 | 457,915 |
Total participant count | 2019-12-31 | 4 |
Total funding target for all participants | 2019-12-31 | 457,915 |
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 | 89,163 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2019-12-31 | 89,163 |
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 | 88,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 | 84,157 |
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 | 120,632 |
Waiver amortization installment | 2019-12-31 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2019-12-31 | 23,533 |
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 | 23,533 |
Contributions allocatedtoward minimum required contributions for current year | 2019-12-31 | 84,157 |
Unpaid minimum required contributions for current year | 2019-12-31 | 0 |
Unpaid minimum required contributions for all years | 2019-12-31 | 0 |
2018: JOE SCHEMBRI DEFINED BENEFIT PENSION PLAN 2018 401k membership | ||
Market value of plan assets | 2018-12-31 | 0 |
Acturial value of plan assets | 2018-12-31 | 0 |
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 | 0 |
Number of active participants | 2018-12-31 | 2 |
Total funding liabilities for active participants | 2018-12-31 | 202,659 |
Total participant count | 2018-12-31 | 2 |
Total funding target for all participants | 2018-12-31 | 202,659 |
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 | 0 |
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2018-12-31 | 0 |
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 | 337,143 |
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 | 325,030 |
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 | 202,783 |
Net shortfall amortization installment of oustanding balance | 2018-12-31 | 202,659 |
Waiver amortization installment | 2018-12-31 | 0 |
Total funding amount beforereflecting carryover/prefunding balances | 2018-12-31 | 235,867 |
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 | 235,867 |
Contributions allocatedtoward minimum required contributions for current year | 2018-12-31 | 325,030 |
Unpaid minimum required contributions for current year | 2018-12-31 | 0 |
Unpaid minimum required contributions for all years | 2018-12-31 | 0 |
Total participants, beginning-of-year | 2018-01-01 | 2 |
Total number of active participants reported on line 7a of the Form 5500 | 2018-01-01 | 2 |
Number of retired or separated participants receiving benefits | 2018-01-01 | 0 |
Number of other retired or separated participants entitled to future benefits | 2018-01-01 | 0 |
Total of all active and inactive participants | 2018-01-01 | 2 |
Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2018-01-01 | 0 |
Total participants | 2018-01-01 | 2 |
Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2018-01-01 | 0 |
Measure | Date | Value |
---|---|---|
2018 : JOE SCHEMBRI DEFINED BENEFIT PENSION PLAN 2018 401k financial data | ||
Total plan liabilities at end of year | 2018-12-31 | $0 |
Total plan liabilities at beginning of year | 2018-12-31 | $0 |
Total income from all sources | 2018-12-31 | $337,143 |
Expenses. Total of all expenses incurred | 2018-12-31 | $0 |
Total plan assets at end of year | 2018-12-31 | $337,143 |
Total plan assets at beginning of year | 2018-12-31 | $0 |
Value of fidelity bond covering the plan | 2018-12-31 | $265,000 |
Net income (gross income less expenses) | 2018-12-31 | $337,143 |
Net plan assets at end of year (total assets less liabilities) | 2018-12-31 | $337,143 |
Net plan assets at beginning of year (total assets less liabilities) | 2018-12-31 | $0 |
Total contributions received or receivable from employer(s) | 2018-12-31 | $337,143 |
2018: JOE SCHEMBRI DEFINED BENEFIT PENSION PLAN 2018 form 5500 responses | ||
---|---|---|
2018-01-01 | Type of plan entity | Single employer plan |
2018-01-01 | First time form 5500 has been submitted | Yes |
2018-01-01 | Submission has been amended | No |
2018-01-01 | This submission is the final filing | No |
2018-01-01 | This return/report is a short plan year return/report (less than 12 months) | No |
2018-01-01 | Plan is a collectively bargained plan | No |
2018-01-01 | Plan funding arrangement – Trust | Yes |
2018-01-01 | Plan benefit arrangement - Trust | Yes |