401k Plan data: JOHN J SHEPTOCK LLC CASH BALANCE PLAN plan

JOHN J SHEPTOCK LLC CASH BALANCE PLAN 401k Plan overview

Plan Name	JOHN J SHEPTOCK LLC CASH BALANCE PLAN
Plan identification number	001

JOHN J SHEPTOCK LLC CASH BALANCE PLAN Benefits

401k Plan Type

Defined Benefit Pension

Plan Features/Benefits

Benefits are primarily pay related
Cash balance or similar plan - Plan has a "cash balance" formula. For this purpose, a "cash balance" formula is a benefit formula in a defined benefit plan by whatever name (for example, personal account plan, pension equity plan, life cycle plan, cash account plan, etc.) that rather than, or in addition to, expressing the accrued benefit as a life annuity commencing at normal retirement age, defines benefits for each employee in terms more common to a defined contribution plan such as a single sum distribution amount (for example, 10 percent of final average pay times years of service, or the amount of the employee's hypothetical account balance).
Plan covering Self-Employed individuals.
Master plan - A pension plan that is made available by a sponsor for adoption by employers; that is the subject of a favorable opinion letter; and for which a single funding medium (for example, a trust or custodial account) is established for the joint use of all adopting employers.

401k Sponsoring company profile

JOHN J SHEPTOCK has sponsored the creation of one or more 401k plans.

Company Name: JOHN J SHEPTOCK

Employer identification number (EIN): 223732241

NAIC Classification: 541110
NAIC Description: Offices of Lawyers

Form 5500 Filing Information

Submission information for form 5500 for 401k plan JOHN J SHEPTOCK LLC CASH BALANCE PLAN

Plan id# Filing Submission Date Name of Administrator Date Administrator Signed Name of Company Sponsor Date Sponsor Signed
001 2020-01-01
001 2019-01-01
001 2018-01-01
001 2017-01-01
001 2016-01-01
001 2015-01-01 JOHN J. SHEPTOCK 2016-06-09
001 2014-01-01 JOHN J. SHEPTOCK 2015-10-05
001 2013-01-01 JOHN J. SHEPTOCK 2014-10-10 JOHN J. SHEPTOCK 2014-10-10
001 2012-01-01 JOHN J. SHEPTOCK 2013-07-06
001 2011-01-01 JOHN J SHEPTOCK 2012-09-14
001 2010-01-01 JOHN J SHEPTOCK 2011-10-03

Plan id#	Filing Submission Date	Name of Administrator	Date Administrator Signed	Name of Company Sponsor	Date Sponsor Signed
001	2020-01-01
001	2019-01-01
001	2018-01-01
001	2017-01-01
001	2016-01-01
001	2015-01-01	JOHN J. SHEPTOCK	2016-06-09
001	2014-01-01	JOHN J. SHEPTOCK	2015-10-05
001	2013-01-01	JOHN J. SHEPTOCK	2014-10-10	JOHN J. SHEPTOCK	2014-10-10
001	2012-01-01	JOHN J. SHEPTOCK	2013-07-06
001	2011-01-01	JOHN J SHEPTOCK	2012-09-14
001	2010-01-01	JOHN J SHEPTOCK	2011-10-03

Plan Statistics for JOHN J SHEPTOCK LLC CASH BALANCE PLAN

401k plan membership statisitcs for JOHN J SHEPTOCK LLC CASH BALANCE PLAN

Measure Date Value
2019: JOHN J SHEPTOCK LLC CASH BALANCE PLAN 2019 401k membership
Market value of plan assets 2019-12-31 2,728,316
Acturial value of plan assets 2019-12-31 2,728,316
Funding target for retired participants and beneficiaries receiving payment 2019-12-31 0
Number of terminated vested participants 2019-12-31 1
Fundng target for terminated vested participants 2019-12-31 3,683
Active participant vested funding target 2019-12-31 2,447,431
Number of active participants 2019-12-31 8
Total funding liabilities for active participants 2019-12-31 2,447,431
Total participant count 2019-12-31 9
Total funding target for all participants 2019-12-31 2,451,114
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 186,465
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 186,465
Present value of excess contributions 2019-12-31 46,570
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2019-12-31 46,570
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2019-12-31 46,570
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 218,640
Total employer contributions 2019-12-31 620,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 593,597
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 711,323
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 662,141
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 68,544
Additional cash requirement 2019-12-31 593,597
Contributions allocatedtoward minimum required contributions for current year 2019-12-31 593,597
Unpaid minimum required contributions for current year 2019-12-31 0
Unpaid minimum required contributions for all years 2019-12-31 0
2018: JOHN J SHEPTOCK LLC CASH BALANCE PLAN 2018 401k membership
Market value of plan assets 2018-12-31 1,906,695
Acturial value of plan assets 2018-12-31 1,906,695
Funding target for retired participants and beneficiaries receiving payment 2018-12-31 0
Number of terminated vested participants 2018-12-31 2
Fundng target for terminated vested participants 2018-12-31 15,055
Active participant vested funding target 2018-12-31 2,099,923
Number of active participants 2018-12-31 8
Total funding liabilities for active participants 2018-12-31 2,099,923
Total participant count 2018-12-31 10
Total funding target for all participants 2018-12-31 2,114,978
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 212,233
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 49,225
Amount remaining of carryover balance 2018-12-31 0
Amount remaining of prefunding balance 2018-12-31 163,008
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 186,465
Total employer contributions 2018-12-31 378,099
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 363,326
Liquidity shortfalls end of Q1 2018-12-31 0
Liquidity shortfalls end of Q2 2018-12-31 0
Liquidity shortfalls end of Q3 2018-12-31 0
Liquidity shortfalls end of Q4 2018-12-31 0
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 238,110
Net shortfall amortization installment of oustanding balance 2018-12-31 402,897
Waiver amortization installment 2018-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2018-12-31 316,756
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 316,756
Contributions allocatedtoward minimum required contributions for current year 2018-12-31 363,326
Unpaid minimum required contributions for current year 2018-12-31 0
Unpaid minimum required contributions for all years 2018-12-31 0
2017: JOHN J SHEPTOCK LLC CASH BALANCE PLAN 2017 401k membership
Market value of plan assets 2017-12-31 1,854,284
Acturial value of plan assets 2017-12-31 1,854,284
Funding target for retired participants and beneficiaries receiving payment 2017-12-31 0
Number of terminated vested participants 2017-12-31 2
Fundng target for terminated vested participants 2017-12-31 10,886
Active participant vested funding target 2017-12-31 1,627,663
Number of active participants 2017-12-31 7
Total funding liabilities for active participants 2017-12-31 1,627,663
Total participant count 2017-12-31 9
Total funding target for all participants 2017-12-31 1,638,549
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 196,742
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 196,742
Present value of excess contributions 2017-12-31 1,975
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2017-12-31 1,975
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2017-12-31 1,975
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 212,233
Total employer contributions 2017-12-31 200,000
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 183,287
Liquidity shortfalls end of Q1 2017-12-31 0
Liquidity shortfalls end of Q2 2017-12-31 0
Liquidity shortfalls end of Q3 2017-12-31 0
Liquidity shortfalls end of Q4 2017-12-31 0
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 222,985
Net shortfall amortization installment of oustanding balance 2017-12-31 8,765
Waiver amortization installment 2017-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2017-12-31 235,021
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 51,734
Additional cash requirement 2017-12-31 183,287
Contributions allocatedtoward minimum required contributions for current year 2017-12-31 183,287
Unpaid minimum required contributions for current year 2017-12-31 0
Unpaid minimum required contributions for all years 2017-12-31 0
2016: JOHN J SHEPTOCK LLC CASH BALANCE PLAN 2016 401k membership
Market value of plan assets 2016-12-31 1,349,396
Acturial value of plan assets 2016-12-31 1,349,396
Funding target for retired participants and beneficiaries receiving payment 2016-12-31 0
Number of terminated vested participants 2016-12-31 1
Fundng target for terminated vested participants 2016-12-31 2,616
Active participant vested funding target 2016-12-31 1,291,102
Number of active participants 2016-12-31 9
Total funding liabilities for active participants 2016-12-31 1,291,102
Total participant count 2016-12-31 10
Total funding target for all participants 2016-12-31 1,293,718
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 80,605
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 80,605
Present value of excess contributions 2016-12-31 117,531
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2016-12-31 117,531
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2016-12-31 117,531
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 196,742
Total employer contributions 2016-12-31 282,933
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 272,287
Liquidity shortfalls end of Q1 2016-12-31 0
Liquidity shortfalls end of Q2 2016-12-31 0
Liquidity shortfalls end of Q3 2016-12-31 0
Liquidity shortfalls end of Q4 2016-12-31 0
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 238,243
Net shortfall amortization installment of oustanding balance 2016-12-31 156,110
Waiver amortization installment 2016-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2016-12-31 270,312
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 270,312
Contributions allocatedtoward minimum required contributions for current year 2016-12-31 272,287
Unpaid minimum required contributions for current year 2016-12-31 0
Unpaid minimum required contributions for all years 2016-12-31 0

Measure	Date	Value
2019: JOHN J SHEPTOCK LLC CASH BALANCE PLAN 2019 401k membership
Market value of plan assets	2019-12-31	2,728,316
Acturial value of plan assets	2019-12-31	2,728,316
Funding target for retired participants and beneficiaries receiving payment	2019-12-31	0
Number of terminated vested participants	2019-12-31	1
Fundng target for terminated vested participants	2019-12-31	3,683
Active participant vested funding target	2019-12-31	2,447,431
Number of active participants	2019-12-31	8
Total funding liabilities for active participants	2019-12-31	2,447,431
Total participant count	2019-12-31	9
Total funding target for all participants	2019-12-31	2,451,114
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	186,465
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	186,465
Present value of excess contributions	2019-12-31	46,570
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2019-12-31	46,570
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2019-12-31	46,570
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	218,640
Total employer contributions	2019-12-31	620,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	593,597
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	711,323
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	662,141
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	68,544
Additional cash requirement	2019-12-31	593,597
Contributions allocatedtoward minimum required contributions for current year	2019-12-31	593,597
Unpaid minimum required contributions for current year	2019-12-31	0
Unpaid minimum required contributions for all years	2019-12-31	0
2018: JOHN J SHEPTOCK LLC CASH BALANCE PLAN 2018 401k membership
Market value of plan assets	2018-12-31	1,906,695
Acturial value of plan assets	2018-12-31	1,906,695
Funding target for retired participants and beneficiaries receiving payment	2018-12-31	0
Number of terminated vested participants	2018-12-31	2
Fundng target for terminated vested participants	2018-12-31	15,055
Active participant vested funding target	2018-12-31	2,099,923
Number of active participants	2018-12-31	8
Total funding liabilities for active participants	2018-12-31	2,099,923
Total participant count	2018-12-31	10
Total funding target for all participants	2018-12-31	2,114,978
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	212,233
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	49,225
Amount remaining of carryover balance	2018-12-31	0
Amount remaining of prefunding balance	2018-12-31	163,008
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	186,465
Total employer contributions	2018-12-31	378,099
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	363,326
Liquidity shortfalls end of Q1	2018-12-31	0
Liquidity shortfalls end of Q2	2018-12-31	0
Liquidity shortfalls end of Q3	2018-12-31	0
Liquidity shortfalls end of Q4	2018-12-31	0
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	238,110
Net shortfall amortization installment of oustanding balance	2018-12-31	402,897
Waiver amortization installment	2018-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2018-12-31	316,756
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	316,756
Contributions allocatedtoward minimum required contributions for current year	2018-12-31	363,326
Unpaid minimum required contributions for current year	2018-12-31	0
Unpaid minimum required contributions for all years	2018-12-31	0
2017: JOHN J SHEPTOCK LLC CASH BALANCE PLAN 2017 401k membership
Market value of plan assets	2017-12-31	1,854,284
Acturial value of plan assets	2017-12-31	1,854,284
Funding target for retired participants and beneficiaries receiving payment	2017-12-31	0
Number of terminated vested participants	2017-12-31	2
Fundng target for terminated vested participants	2017-12-31	10,886
Active participant vested funding target	2017-12-31	1,627,663
Number of active participants	2017-12-31	7
Total funding liabilities for active participants	2017-12-31	1,627,663
Total participant count	2017-12-31	9
Total funding target for all participants	2017-12-31	1,638,549
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	196,742
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	196,742
Present value of excess contributions	2017-12-31	1,975
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2017-12-31	1,975
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2017-12-31	1,975
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	212,233
Total employer contributions	2017-12-31	200,000
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	183,287
Liquidity shortfalls end of Q1	2017-12-31	0
Liquidity shortfalls end of Q2	2017-12-31	0
Liquidity shortfalls end of Q3	2017-12-31	0
Liquidity shortfalls end of Q4	2017-12-31	0
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	222,985
Net shortfall amortization installment of oustanding balance	2017-12-31	8,765
Waiver amortization installment	2017-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2017-12-31	235,021
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	51,734
Additional cash requirement	2017-12-31	183,287
Contributions allocatedtoward minimum required contributions for current year	2017-12-31	183,287
Unpaid minimum required contributions for current year	2017-12-31	0
Unpaid minimum required contributions for all years	2017-12-31	0
2016: JOHN J SHEPTOCK LLC CASH BALANCE PLAN 2016 401k membership
Market value of plan assets	2016-12-31	1,349,396
Acturial value of plan assets	2016-12-31	1,349,396
Funding target for retired participants and beneficiaries receiving payment	2016-12-31	0
Number of terminated vested participants	2016-12-31	1
Fundng target for terminated vested participants	2016-12-31	2,616
Active participant vested funding target	2016-12-31	1,291,102
Number of active participants	2016-12-31	9
Total funding liabilities for active participants	2016-12-31	1,291,102
Total participant count	2016-12-31	10
Total funding target for all participants	2016-12-31	1,293,718
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	80,605
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	80,605
Present value of excess contributions	2016-12-31	117,531
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2016-12-31	117,531
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2016-12-31	117,531
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	196,742
Total employer contributions	2016-12-31	282,933
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	272,287
Liquidity shortfalls end of Q1	2016-12-31	0
Liquidity shortfalls end of Q2	2016-12-31	0
Liquidity shortfalls end of Q3	2016-12-31	0
Liquidity shortfalls end of Q4	2016-12-31	0
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	238,243
Net shortfall amortization installment of oustanding balance	2016-12-31	156,110
Waiver amortization installment	2016-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2016-12-31	270,312
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	270,312
Contributions allocatedtoward minimum required contributions for current year	2016-12-31	272,287
Unpaid minimum required contributions for current year	2016-12-31	0
Unpaid minimum required contributions for all years	2016-12-31	0

Potentially related plans

Was this data useful?

If you found the data here useful, PLEASE HELP US. We are a start-up and believe in making information freely available. By linking to us, posting on twitter, facebook and linkedin about us and generally spreading the word, you'll help us to grow. Our vision is to provide high quality data about the activities of all the companies in the world and where possible make it free to use and view. Finding and integrating data from thousands of data sources is time consuming and needs lots of effort. By simply spreading the word about us, you will help us. Please use the share buttons. It will only take a few seconds of your time. Thanks for helping

Information Disclaimer

The information provided on this website is not advice, endorsement or recommendation
The information published is supplied by third parties so we make no warranty on the accuracy, completeness etc. This information is provided "as-is". The information is subject to change as we obtain updates and corrections from the primary information sources.
You are free to use the information for your own personal research on the understanding to do so is at your own risk.

See full terms and conditions

Company Name:	JOHN J SHEPTOCK
Employer identification number (EIN):	223732241
NAIC Classification:	541110
NAIC Description:	Offices of Lawyers