401k Plan data: NILS BERLIN DEFINED BENEFIT PENSION PLAN plan

NILS BERLIN DEFINED BENEFIT PENSION PLAN 401k Plan overview

Plan Name	NILS BERLIN DEFINED BENEFIT PENSION PLAN
Plan identification number	002

NILS BERLIN DEFINED BENEFIT PENSION PLAN Benefits

401k Plan Type	Defined Benefit Pension
Plan Features/Benefits	Benefits are primarily pay related 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

NILS HUNTER BERLIN PC has sponsored the creation of one or more 401k plans.

Company Name: NILS HUNTER BERLIN PC

Employer identification number (EIN): 113447447

NAIC Classification: 541110
NAIC Description: Offices of Lawyers

Form 5500 Filing Information

Submission information for form 5500 for 401k plan NILS BERLIN DEFINED BENEFIT PENSION PLAN

Plan id# Filing Submission Date Name of Administrator Date Administrator Signed Name of Company Sponsor Date Sponsor Signed
002 2023-01-01 JOHN SATTLER 2024-09-20
002 2022-01-01 JOHN SATTLER 2023-09-27
002 2021-01-01 NILS BERLIN 2022-10-04
002 2020-01-01 NILS BERLIN 2021-10-05
002 2020-01-01 NILS H. BERLIN 2021-10-04
002 2019-01-01 NILS H. BERLIN 2020-06-29
002 2018-01-01 NILS H. BERLIN 2019-09-11
002 2017-01-01 NILS H. BERLIN 2018-06-21
002 2016-01-01 NILS H. BERLIN 2017-08-16

Plan id#	Filing Submission Date	Name of Administrator	Date Administrator Signed
002	2023-01-01	JOHN SATTLER	2024-09-20
002	2022-01-01	JOHN SATTLER	2023-09-27
002	2021-01-01	NILS BERLIN	2022-10-04
002	2020-01-01	NILS BERLIN	2021-10-05
002	2020-01-01	NILS H. BERLIN	2021-10-04
002	2019-01-01	NILS H. BERLIN	2020-06-29
002	2018-01-01	NILS H. BERLIN	2019-09-11
002	2017-01-01	NILS H. BERLIN	2018-06-21
002	2016-01-01	NILS H. BERLIN	2017-08-16

Plan Statistics for NILS BERLIN DEFINED BENEFIT PENSION PLAN

401k plan membership statisitcs for NILS BERLIN DEFINED BENEFIT PENSION PLAN

Measure Date Value
2022: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2022 401k membership
Market value of plan assets 2022-12-31 635,479
Acturial value of plan assets 2022-12-31 635,479
Funding target for retired participants and beneficiaries receiving payment 2022-12-31 0
Number of terminated vested participants 2022-12-31 0
Fundng target for terminated vested participants 2022-12-31 0
Active participant vested funding target 2022-12-31 508,487
Number of active participants 2022-12-31 2
Total funding liabilities for active participants 2022-12-31 508,487
Total participant count 2022-12-31 2
Total funding target for all participants 2022-12-31 508,487
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 497,581
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 497,581
Present value of excess contributions 2022-12-31 7,630
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2022-12-31 7,631
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2022-12-31 7,631
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 587,512
Total employer contributions 2022-12-31 95,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 98,961
Liquidity shortfalls end of Q1 2022-12-31 0
Liquidity shortfalls end of Q2 2022-12-31 0
Liquidity shortfalls end of Q3 2022-12-31 0
Liquidity shortfalls end of Q4 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 38,234
Net shortfall amortization installment of oustanding balance 2022-12-31 10,764
Waiver amortization installment 2022-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2022-12-31 39,229
Additional cash requirement 2022-12-31 39,229
Contributions allocatedtoward minimum required contributions for current year 2022-12-31 98,961
Unpaid minimum required contributions for current year 2022-12-31 0
Unpaid minimum required contributions for all years 2022-12-31 0
2021: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2021 401k membership
Market value of plan assets 2021-12-31 868,074
Acturial value of plan assets 2021-12-31 868,074
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 386,606
Number of active participants 2021-12-31 2
Total funding liabilities for active participants 2021-12-31 483,258
Total participant count 2021-12-31 2
Total funding target for all participants 2021-12-31 483,258
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 381,491
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 381,491
Present value of excess contributions 2021-12-31 36,763
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2021-12-31 36,769
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2021-12-31 36,769
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 497,581
Total employer contributions 2021-12-31 50,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 50,256
Liquidity shortfalls end of Q1 2021-12-31 0
Liquidity shortfalls end of Q2 2021-12-31 0
Liquidity shortfalls end of Q3 2021-12-31 0
Liquidity shortfalls end of Q4 2021-12-31 0
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 31,862
Net shortfall amortization installment of oustanding balance 2021-12-31 21,183
Waiver amortization installment 2021-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2021-12-31 42,626
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 42,626
Contributions allocatedtoward minimum required contributions for current year 2021-12-31 50,256
Unpaid minimum required contributions for current year 2021-12-31 0
Unpaid minimum required contributions for all years 2021-12-31 0
2020: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2020 401k membership
Market value of plan assets 2020-12-31 736,652
Acturial value of plan assets 2020-12-31 736,652
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 250,262
Number of active participants 2020-12-31 2
Total funding liabilities for active participants 2020-12-31 417,103
Total participant count 2020-12-31 2
Total funding target for all participants 2020-12-31 417,103
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 255,778
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 255,778
Present value of excess contributions 2020-12-31 59,624
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2020-12-31 59,633
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2020-12-31 59,633
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 8,684
Balance of carryovers at beginning of current year 2020-12-31 0
Balance of prefunding at beginning of current year 2020-12-31 381,491
Total employer contributions 2020-12-31 50,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 51,433
Liquidity shortfalls end of Q1 2020-12-31 0
Liquidity shortfalls end of Q2 2020-12-31 0
Liquidity shortfalls end of Q3 2020-12-31 0
Liquidity shortfalls end of Q4 2020-12-31 0
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 3,906
Net shortfall amortization installment of oustanding balance 2020-12-31 31,172
Waiver amortization installment 2020-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2020-12-31 14,670
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 14,670
Contributions allocatedtoward minimum required contributions for current year 2020-12-31 51,433
Unpaid minimum required contributions for current year 2020-12-31 0
Unpaid minimum required contributions for all years 2020-12-31 0
2019: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2019 401k membership
Market value of plan assets 2019-12-31 513,065
Acturial value of plan assets 2019-12-31 513,065
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 108,544
Number of active participants 2019-12-31 2
Total funding liabilities for active participants 2019-12-31 271,360
Total participant count 2019-12-31 2
Total funding target for all participants 2019-12-31 271,360
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 176,349
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 176,349
Present value of excess contributions 2019-12-31 102,691
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2019-12-31 102,707
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2019-12-31 102,707
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 255,778
Total employer contributions 2019-12-31 97,040
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 97,423
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 16,358
Net shortfall amortization installment of oustanding balance 2019-12-31 51,460
Waiver amortization installment 2019-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2019-12-31 37,799
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 37,799
Contributions allocatedtoward minimum required contributions for current year 2019-12-31 97,423
Unpaid minimum required contributions for current year 2019-12-31 0
Unpaid minimum required contributions for all years 2019-12-31 0
2018: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2018 401k membership
Market value of plan assets 2018-12-31 261,873
Acturial value of plan assets 2018-12-31 261,873
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 46,345
Number of active participants 2018-12-31 2
Total funding liabilities for active participants 2018-12-31 231,727
Total participant count 2018-12-31 2
Total funding target for all participants 2018-12-31 231,727
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 118,639
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 118,639
Present value of excess contributions 2018-12-31 30,703
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2018-12-31 30,708
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2018-12-31 30,708
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 176,349
Total employer contributions 2018-12-31 140,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 139,330
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 15,198
Net shortfall amortization installment of oustanding balance 2018-12-31 70,861
Waiver amortization installment 2018-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2018-12-31 36,639
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 36,639
Contributions allocatedtoward minimum required contributions for current year 2018-12-31 139,330
Unpaid minimum required contributions for current year 2018-12-31 0
Unpaid minimum required contributions for all years 2018-12-31 0
2017: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2017 401k membership
Market value of plan assets 2017-12-31 163,143
Acturial value of plan assets 2017-12-31 163,143
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 0
Number of active participants 2017-12-31 2
Total funding liabilities for active participants 2017-12-31 121,073
Total participant count 2017-12-31 2
Total funding target for all participants 2017-12-31 121,073
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 118,619
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2017-12-31 118,639
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2017-12-31 118,639
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 118,639
Total employer contributions 2017-12-31 134,985
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 135,542
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 83,398
Net shortfall amortization installment of oustanding balance 2017-12-31 88,609
Waiver amortization installment 2017-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2017-12-31 104,839
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 104,839
Contributions allocatedtoward minimum required contributions for current year 2017-12-31 135,542
Unpaid minimum required contributions for current year 2017-12-31 0
Unpaid minimum required contributions for all years 2017-12-31 0
2016: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2016 401k membership
Market value of plan assets 2016-12-31 0
Acturial value of plan assets 2016-12-31 0
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 0
Number of active participants 2016-12-31 2
Total funding liabilities for active participants 2016-12-31 105,217
Total participant count 2016-12-31 2
Total funding target for all participants 2016-12-31 105,217
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
Amount remaining of carryover 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 142,673
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 141,185
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 1,125
Net shortfall amortization installment of oustanding balance 2016-12-31 105,217
Waiver amortization installment 2016-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2016-12-31 18,509
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 18,509
Contributions allocatedtoward minimum required contributions for current year 2016-12-31 141,185
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
2022: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2022 401k membership
Market value of plan assets	2022-12-31	635,479
Acturial value of plan assets	2022-12-31	635,479
Funding target for retired participants and beneficiaries receiving payment	2022-12-31	0
Number of terminated vested participants	2022-12-31	0
Fundng target for terminated vested participants	2022-12-31	0
Active participant vested funding target	2022-12-31	508,487
Number of active participants	2022-12-31	2
Total funding liabilities for active participants	2022-12-31	508,487
Total participant count	2022-12-31	2
Total funding target for all participants	2022-12-31	508,487
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	497,581
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	497,581
Present value of excess contributions	2022-12-31	7,630
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2022-12-31	7,631
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2022-12-31	7,631
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	587,512
Total employer contributions	2022-12-31	95,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	98,961
Liquidity shortfalls end of Q1	2022-12-31	0
Liquidity shortfalls end of Q2	2022-12-31	0
Liquidity shortfalls end of Q3	2022-12-31	0
Liquidity shortfalls end of Q4	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	38,234
Net shortfall amortization installment of oustanding balance	2022-12-31	10,764
Waiver amortization installment	2022-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2022-12-31	39,229
Additional cash requirement	2022-12-31	39,229
Contributions allocatedtoward minimum required contributions for current year	2022-12-31	98,961
Unpaid minimum required contributions for current year	2022-12-31	0
Unpaid minimum required contributions for all years	2022-12-31	0
2021: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2021 401k membership
Market value of plan assets	2021-12-31	868,074
Acturial value of plan assets	2021-12-31	868,074
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	386,606
Number of active participants	2021-12-31	2
Total funding liabilities for active participants	2021-12-31	483,258
Total participant count	2021-12-31	2
Total funding target for all participants	2021-12-31	483,258
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	381,491
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	381,491
Present value of excess contributions	2021-12-31	36,763
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2021-12-31	36,769
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2021-12-31	36,769
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	497,581
Total employer contributions	2021-12-31	50,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	50,256
Liquidity shortfalls end of Q1	2021-12-31	0
Liquidity shortfalls end of Q2	2021-12-31	0
Liquidity shortfalls end of Q3	2021-12-31	0
Liquidity shortfalls end of Q4	2021-12-31	0
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	31,862
Net shortfall amortization installment of oustanding balance	2021-12-31	21,183
Waiver amortization installment	2021-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2021-12-31	42,626
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	42,626
Contributions allocatedtoward minimum required contributions for current year	2021-12-31	50,256
Unpaid minimum required contributions for current year	2021-12-31	0
Unpaid minimum required contributions for all years	2021-12-31	0
2020: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2020 401k membership
Market value of plan assets	2020-12-31	736,652
Acturial value of plan assets	2020-12-31	736,652
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	250,262
Number of active participants	2020-12-31	2
Total funding liabilities for active participants	2020-12-31	417,103
Total participant count	2020-12-31	2
Total funding target for all participants	2020-12-31	417,103
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	255,778
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	255,778
Present value of excess contributions	2020-12-31	59,624
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2020-12-31	59,633
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2020-12-31	59,633
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	8,684
Balance of carryovers at beginning of current year	2020-12-31	0
Balance of prefunding at beginning of current year	2020-12-31	381,491
Total employer contributions	2020-12-31	50,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	51,433
Liquidity shortfalls end of Q1	2020-12-31	0
Liquidity shortfalls end of Q2	2020-12-31	0
Liquidity shortfalls end of Q3	2020-12-31	0
Liquidity shortfalls end of Q4	2020-12-31	0
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	3,906
Net shortfall amortization installment of oustanding balance	2020-12-31	31,172
Waiver amortization installment	2020-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2020-12-31	14,670
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	14,670
Contributions allocatedtoward minimum required contributions for current year	2020-12-31	51,433
Unpaid minimum required contributions for current year	2020-12-31	0
Unpaid minimum required contributions for all years	2020-12-31	0
2019: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2019 401k membership
Market value of plan assets	2019-12-31	513,065
Acturial value of plan assets	2019-12-31	513,065
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	108,544
Number of active participants	2019-12-31	2
Total funding liabilities for active participants	2019-12-31	271,360
Total participant count	2019-12-31	2
Total funding target for all participants	2019-12-31	271,360
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	176,349
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	176,349
Present value of excess contributions	2019-12-31	102,691
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2019-12-31	102,707
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2019-12-31	102,707
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	255,778
Total employer contributions	2019-12-31	97,040
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	97,423
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	16,358
Net shortfall amortization installment of oustanding balance	2019-12-31	51,460
Waiver amortization installment	2019-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2019-12-31	37,799
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	37,799
Contributions allocatedtoward minimum required contributions for current year	2019-12-31	97,423
Unpaid minimum required contributions for current year	2019-12-31	0
Unpaid minimum required contributions for all years	2019-12-31	0
2018: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2018 401k membership
Market value of plan assets	2018-12-31	261,873
Acturial value of plan assets	2018-12-31	261,873
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	46,345
Number of active participants	2018-12-31	2
Total funding liabilities for active participants	2018-12-31	231,727
Total participant count	2018-12-31	2
Total funding target for all participants	2018-12-31	231,727
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	118,639
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	118,639
Present value of excess contributions	2018-12-31	30,703
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2018-12-31	30,708
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2018-12-31	30,708
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	176,349
Total employer contributions	2018-12-31	140,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	139,330
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	15,198
Net shortfall amortization installment of oustanding balance	2018-12-31	70,861
Waiver amortization installment	2018-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2018-12-31	36,639
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	36,639
Contributions allocatedtoward minimum required contributions for current year	2018-12-31	139,330
Unpaid minimum required contributions for current year	2018-12-31	0
Unpaid minimum required contributions for all years	2018-12-31	0
2017: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2017 401k membership
Market value of plan assets	2017-12-31	163,143
Acturial value of plan assets	2017-12-31	163,143
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	0
Number of active participants	2017-12-31	2
Total funding liabilities for active participants	2017-12-31	121,073
Total participant count	2017-12-31	2
Total funding target for all participants	2017-12-31	121,073
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	118,619
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2017-12-31	118,639
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2017-12-31	118,639
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	118,639
Total employer contributions	2017-12-31	134,985
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	135,542
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	83,398
Net shortfall amortization installment of oustanding balance	2017-12-31	88,609
Waiver amortization installment	2017-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2017-12-31	104,839
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	104,839
Contributions allocatedtoward minimum required contributions for current year	2017-12-31	135,542
Unpaid minimum required contributions for current year	2017-12-31	0
Unpaid minimum required contributions for all years	2017-12-31	0
2016: NILS BERLIN DEFINED BENEFIT PENSION PLAN 2016 401k membership
Market value of plan assets	2016-12-31	0
Acturial value of plan assets	2016-12-31	0
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	0
Number of active participants	2016-12-31	2
Total funding liabilities for active participants	2016-12-31	105,217
Total participant count	2016-12-31	2
Total funding target for all participants	2016-12-31	105,217
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
Amount remaining of carryover 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	142,673
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	141,185
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	1,125
Net shortfall amortization installment of oustanding balance	2016-12-31	105,217
Waiver amortization installment	2016-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2016-12-31	18,509
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	18,509
Contributions allocatedtoward minimum required contributions for current year	2016-12-31	141,185
Unpaid minimum required contributions for current year	2016-12-31	0
Unpaid minimum required contributions for all years	2016-12-31	0

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:	NILS HUNTER BERLIN PC
Employer identification number (EIN):	113447447
NAIC Classification:	541110
NAIC Description:	Offices of Lawyers