401k Plan data: THE KEYSPAN RETIREMENT PLAN plan

THE KEYSPAN RETIREMENT PLAN 401k Plan overview

Plan Name	THE KEYSPAN RETIREMENT PLAN
Plan identification number	004

THE KEYSPAN RETIREMENT PLAN Benefits

401k Plan Type

Defined Benefit Pension

Plan Features/Benefits

Benefits are primarily pay related
Benefits are primarily flat dollar (includes dollars per year of service)
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).
Code section 401(h) arrangement - Plan contains separate accounts under Code section 401(h) to provide employee health benefits.
Plan sponsor(s) is (are) a member(s) of a controlled group (Code sections 414(b), (c), or (m)).

401k Sponsoring company profile

NATIONAL GRID USA SERVICE COMPANY, INC. has sponsored the creation of one or more 401k plans.

Company Name: NATIONAL GRID USA SERVICE COMPANY, INC.

Employer identification number (EIN): 041663150

NAIC Classification: 221100

Form 5500 Filing Information

Submission information for form 5500 for 401k plan THE KEYSPAN RETIREMENT PLAN

Plan id# Filing Submission Date Name of Administrator Date Administrator Signed Name of Company Sponsor Date Sponsor Signed
004 2022-01-01
004 2021-01-01
004 2020-01-01
004 2019-01-01
004 2018-01-01

Plan Statistics for THE KEYSPAN RETIREMENT PLAN

401k plan membership statisitcs for THE KEYSPAN RETIREMENT PLAN

Measure Date Value
2022: THE KEYSPAN RETIREMENT PLAN 2022 401k membership
Market value of plan assets 2022-12-31 3,129,901,293
Acturial value of plan assets 2022-12-31 2,955,152,528
Funding target for retired participants and beneficiaries receiving payment 2022-12-31 1,289,480,179
Number of terminated vested participants 2022-12-31 2,180
Fundng target for terminated vested participants 2022-12-31 116,137,354
Active participant vested funding target 2022-12-31 548,553,303
Number of active participants 2022-12-31 2,403
Total funding liabilities for active participants 2022-12-31 618,102,423
Total participant count 2022-12-31 9,311
Total funding target for all participants 2022-12-31 2,023,719,956
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 658,330,400
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 658,330,400
Present value of excess contributions 2022-12-31 19,039,765
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2022-12-31 20,104,088
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2022-12-31 20,104,088
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 752,101,660
Total employer contributions 2022-12-31 20,894,778
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 20,170,120
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 27,158,370
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 20,170,120
Unpaid minimum required contributions for current year 2022-12-31 0
Unpaid minimum required contributions for all years 2022-12-31 0
Total participants, beginning-of-year 2022-01-01 8,990
Total number of active participants reported on line 7a of the Form 5500 2022-01-01 2,744
Number of retired or separated participants receiving benefits 2022-01-01 3,291
Number of other retired or separated participants entitled to future benefits 2022-01-01 1,407
Total of all active and inactive participants 2022-01-01 7,442
Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits 2022-01-01 513
Total participants 2022-01-01 7,955
Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested 2022-01-01 7
2021: THE KEYSPAN RETIREMENT PLAN 2021 401k membership
Market value of plan assets 2021-12-31 2,901,206,427
Acturial value of plan assets 2021-12-31 2,643,528,560
Funding target for retired participants and beneficiaries receiving payment 2021-12-31 1,251,626,346
Number of terminated vested participants 2021-12-31 1,645
Fundng target for terminated vested participants 2021-12-31 118,630,241
Active participant vested funding target 2021-12-31 533,352,875
Number of active participants 2021-12-31 3,242
Total funding liabilities for active participants 2021-12-31 601,306,469
Total participant count 2021-12-31 9,594
Total funding target for all participants 2021-12-31 1,971,563,056
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 583,773,658
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 583,773,658
Present value of excess contributions 2021-12-31 12,043,293
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2021-12-31 12,691,222
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2021-12-31 12,691,222
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 25,000,000
Balance of carryovers at beginning of current year 2021-12-31 0
Balance of prefunding at beginning of current year 2021-12-31 658,330,400
Total employer contributions 2021-12-31 33,519,019
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 32,478,220
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 27,073,559
Net shortfall amortization installment of oustanding balance 2021-12-31 0
Waiver amortization installment 2021-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2021-12-31 13,438,455
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 13,438,455
Contributions allocatedtoward minimum required contributions for current year 2021-12-31 32,478,220
Unpaid minimum required contributions for current year 2021-12-31 0
Unpaid minimum required contributions for all years 2021-12-31 0
Total participants, beginning-of-year 2021-01-01 9,220
Total number of active participants reported on line 7a of the Form 5500 2021-01-01 2,946
Number of retired or separated participants receiving benefits 2021-01-01 3,650
Number of other retired or separated participants entitled to future benefits 2021-01-01 1,435
Total of all active and inactive participants 2021-01-01 8,031
Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits 2021-01-01 959
Total participants 2021-01-01 8,990
Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested 2021-01-01 36
2020: THE KEYSPAN RETIREMENT PLAN 2020 401k membership
Market value of plan assets 2020-12-31 2,581,845,122
Acturial value of plan assets 2020-12-31 2,451,793,276
Funding target for retired participants and beneficiaries receiving payment 2020-12-31 1,234,482,686
Number of terminated vested participants 2020-12-31 1,726
Fundng target for terminated vested participants 2020-12-31 130,968,927
Active participant vested funding target 2020-12-31 555,118,929
Number of active participants 2020-12-31 3,404
Total funding liabilities for active participants 2020-12-31 627,317,614
Total participant count 2020-12-31 9,774
Total funding target for all participants 2020-12-31 1,992,769,227
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 469,776,502
Prefunding balanced used to offset prior years funding requirement 2020-12-31 8,908,523
Amount remaining of carryover balance 2020-12-31 0
Amount remaining of prefunding balance 2020-12-31 460,867,979
Present value of excess contributions 2020-12-31 24,116,289
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2020-12-31 26,814,705
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2020-12-31 26,814,705
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 583,773,658
Total employer contributions 2020-12-31 59,453,875
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 57,698,185
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 30,389,416
Net shortfall amortization installment of oustanding balance 2020-12-31 75,734,238
Total funding amount beforereflecting carryover/prefunding balances 2020-12-31 45,654,892
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 45,654,892
Contributions allocatedtoward minimum required contributions for current year 2020-12-31 57,698,185
Unpaid minimum required contributions for current year 2020-12-31 0
Unpaid minimum required contributions for all years 2020-12-31 0
Total participants, beginning-of-year 2020-01-01 9,418
Total number of active participants reported on line 7a of the Form 5500 2020-01-01 3,100
Number of retired or separated participants receiving benefits 2020-01-01 3,636
Number of other retired or separated participants entitled to future benefits 2020-01-01 1,546
Total of all active and inactive participants 2020-01-01 8,282
Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits 2020-01-01 938
Total participants 2020-01-01 9,220
Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested 2020-01-01 31
2019: THE KEYSPAN RETIREMENT PLAN 2019 401k membership
Market value of plan assets 2019-12-31 2,188,749,080
Acturial value of plan assets 2019-12-31 2,287,225,573
Funding target for retired participants and beneficiaries receiving payment 2019-12-31 1,213,300,059
Number of terminated vested participants 2019-12-31 2,495
Fundng target for terminated vested participants 2019-12-31 91,618,023
Active participant vested funding target 2019-12-31 529,132,026
Number of active participants 2019-12-31 2,865
Total funding liabilities for active participants 2019-12-31 599,635,028
Total participant count 2019-12-31 9,900
Total funding target for all participants 2019-12-31 1,904,553,110
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 426,597,083
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 12,619,298
Amount remaining of carryover balance 2019-12-31 0
Amount remaining of prefunding balance 2019-12-31 413,977,785
Present value of excess contributions 2019-12-31 72,035,462
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2019-12-31 74,841,695
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2019-12-31 74,841,695
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 469,776,502
Total employer contributions 2019-12-31 58,200,750
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 56,125,167
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 25,651,925
Net shortfall amortization installment of oustanding balance 2019-12-31 87,104,039
Waiver amortization installment 2019-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2019-12-31 40,917,401
Prefunding balance elected to use to offset funding requirement 2019-12-31 8,908,523
Additional cash requirement 2019-12-31 32,008,878
Contributions allocatedtoward minimum required contributions for current year 2019-12-31 56,125,167
Unpaid minimum required contributions for current year 2019-12-31 0
Unpaid minimum required contributions for all years 2019-12-31 0
Total participants, beginning-of-year 2019-01-01 9,543
Total number of active participants reported on line 7a of the Form 5500 2019-01-01 3,266
Number of retired or separated participants receiving benefits 2019-01-01 3,585
Number of other retired or separated participants entitled to future benefits 2019-01-01 1,613
Total of all active and inactive participants 2019-01-01 8,464
Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits 2019-01-01 954
Total participants 2019-01-01 9,418
Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested 2019-01-01 22
2018: THE KEYSPAN RETIREMENT PLAN 2018 401k membership
Market value of plan assets 2018-12-31 2,303,984,817
Acturial value of plan assets 2018-12-31 2,163,032,059
Funding target for retired participants and beneficiaries receiving payment 2018-12-31 1,166,768,886
Number of terminated vested participants 2018-12-31 2,457
Fundng target for terminated vested participants 2018-12-31 86,877,068
Active participant vested funding target 2018-12-31 478,183,185
Number of active participants 2018-12-31 2,991
Total funding liabilities for active participants 2018-12-31 540,106,978
Total participant count 2018-12-31 9,946
Total funding target for all participants 2018-12-31 1,793,752,932
Balance at beginning of prior year after applicable adjustments 2018-12-31 1,748,041
Prefunding balance at beginning of prior year after applicable adjustments 2018-12-31 401,416,977
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 1,748,041
Amount remaining of prefunding balance 2018-12-31 401,416,977
Present value of excess contributions 2018-12-31 25,946,046
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance 2018-12-31 27,474,268
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance 2018-12-31 27,474,268
Reductions in caryover balances due to elections or deemed elections 2018-12-31 2,034,021
Reductions in prefunding balances due to elections or deemed elections 2018-12-31 67,965,979
Balance of carryovers at beginning of current year 2018-12-31 0
Balance of prefunding at beginning of current year 2018-12-31 426,597,083
Total employer contributions 2018-12-31 100,445,250
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 95,600,969
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 26,827,658
Net shortfall amortization installment of oustanding balance 2018-12-31 57,317,956
Waiver amortization installment 2018-12-31 0
Total funding amount beforereflecting carryover/prefunding balances 2018-12-31 36,184,805
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 12,619,298
Additional cash requirement 2018-12-31 23,565,507
Contributions allocatedtoward minimum required contributions for current year 2018-12-31 95,600,969
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 9,632
Total number of active participants reported on line 7a of the Form 5500 2018-01-01 3,403
Number of retired or separated participants receiving benefits 2018-01-01 3,513
Number of other retired or separated participants entitled to future benefits 2018-01-01 1,690
Total of all active and inactive participants 2018-01-01 8,606
Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits 2018-01-01 937
Total participants 2018-01-01 9,543
Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested 2018-01-01 18

Measure	Date	Value
2022: THE KEYSPAN RETIREMENT PLAN 2022 401k membership
Market value of plan assets	2022-12-31	3,129,901,293
Acturial value of plan assets	2022-12-31	2,955,152,528
Funding target for retired participants and beneficiaries receiving payment	2022-12-31	1,289,480,179
Number of terminated vested participants	2022-12-31	2,180
Fundng target for terminated vested participants	2022-12-31	116,137,354
Active participant vested funding target	2022-12-31	548,553,303
Number of active participants	2022-12-31	2,403
Total funding liabilities for active participants	2022-12-31	618,102,423
Total participant count	2022-12-31	9,311
Total funding target for all participants	2022-12-31	2,023,719,956
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	658,330,400
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	658,330,400
Present value of excess contributions	2022-12-31	19,039,765
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2022-12-31	20,104,088
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2022-12-31	20,104,088
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	752,101,660
Total employer contributions	2022-12-31	20,894,778
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	20,170,120
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	27,158,370
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	20,170,120
Unpaid minimum required contributions for current year	2022-12-31	0
Unpaid minimum required contributions for all years	2022-12-31	0
Total participants, beginning-of-year	2022-01-01	8,990
Total number of active participants reported on line 7a of the Form 5500	2022-01-01	2,744
Number of retired or separated participants receiving benefits	2022-01-01	3,291
Number of other retired or separated participants entitled to future benefits	2022-01-01	1,407
Total of all active and inactive participants	2022-01-01	7,442
Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits	2022-01-01	513
Total participants	2022-01-01	7,955
Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested	2022-01-01	7
2021: THE KEYSPAN RETIREMENT PLAN 2021 401k membership
Market value of plan assets	2021-12-31	2,901,206,427
Acturial value of plan assets	2021-12-31	2,643,528,560
Funding target for retired participants and beneficiaries receiving payment	2021-12-31	1,251,626,346
Number of terminated vested participants	2021-12-31	1,645
Fundng target for terminated vested participants	2021-12-31	118,630,241
Active participant vested funding target	2021-12-31	533,352,875
Number of active participants	2021-12-31	3,242
Total funding liabilities for active participants	2021-12-31	601,306,469
Total participant count	2021-12-31	9,594
Total funding target for all participants	2021-12-31	1,971,563,056
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	583,773,658
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	583,773,658
Present value of excess contributions	2021-12-31	12,043,293
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2021-12-31	12,691,222
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2021-12-31	12,691,222
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	25,000,000
Balance of carryovers at beginning of current year	2021-12-31	0
Balance of prefunding at beginning of current year	2021-12-31	658,330,400
Total employer contributions	2021-12-31	33,519,019
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	32,478,220
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	27,073,559
Net shortfall amortization installment of oustanding balance	2021-12-31	0
Waiver amortization installment	2021-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2021-12-31	13,438,455
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	13,438,455
Contributions allocatedtoward minimum required contributions for current year	2021-12-31	32,478,220
Unpaid minimum required contributions for current year	2021-12-31	0
Unpaid minimum required contributions for all years	2021-12-31	0
Total participants, beginning-of-year	2021-01-01	9,220
Total number of active participants reported on line 7a of the Form 5500	2021-01-01	2,946
Number of retired or separated participants receiving benefits	2021-01-01	3,650
Number of other retired or separated participants entitled to future benefits	2021-01-01	1,435
Total of all active and inactive participants	2021-01-01	8,031
Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits	2021-01-01	959
Total participants	2021-01-01	8,990
Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested	2021-01-01	36
2020: THE KEYSPAN RETIREMENT PLAN 2020 401k membership
Market value of plan assets	2020-12-31	2,581,845,122
Acturial value of plan assets	2020-12-31	2,451,793,276
Funding target for retired participants and beneficiaries receiving payment	2020-12-31	1,234,482,686
Number of terminated vested participants	2020-12-31	1,726
Fundng target for terminated vested participants	2020-12-31	130,968,927
Active participant vested funding target	2020-12-31	555,118,929
Number of active participants	2020-12-31	3,404
Total funding liabilities for active participants	2020-12-31	627,317,614
Total participant count	2020-12-31	9,774
Total funding target for all participants	2020-12-31	1,992,769,227
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	469,776,502
Prefunding balanced used to offset prior years funding requirement	2020-12-31	8,908,523
Amount remaining of carryover balance	2020-12-31	0
Amount remaining of prefunding balance	2020-12-31	460,867,979
Present value of excess contributions	2020-12-31	24,116,289
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2020-12-31	26,814,705
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2020-12-31	26,814,705
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	583,773,658
Total employer contributions	2020-12-31	59,453,875
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	57,698,185
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	30,389,416
Net shortfall amortization installment of oustanding balance	2020-12-31	75,734,238
Total funding amount beforereflecting carryover/prefunding balances	2020-12-31	45,654,892
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	45,654,892
Contributions allocatedtoward minimum required contributions for current year	2020-12-31	57,698,185
Unpaid minimum required contributions for current year	2020-12-31	0
Unpaid minimum required contributions for all years	2020-12-31	0
Total participants, beginning-of-year	2020-01-01	9,418
Total number of active participants reported on line 7a of the Form 5500	2020-01-01	3,100
Number of retired or separated participants receiving benefits	2020-01-01	3,636
Number of other retired or separated participants entitled to future benefits	2020-01-01	1,546
Total of all active and inactive participants	2020-01-01	8,282
Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits	2020-01-01	938
Total participants	2020-01-01	9,220
Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested	2020-01-01	31
2019: THE KEYSPAN RETIREMENT PLAN 2019 401k membership
Market value of plan assets	2019-12-31	2,188,749,080
Acturial value of plan assets	2019-12-31	2,287,225,573
Funding target for retired participants and beneficiaries receiving payment	2019-12-31	1,213,300,059
Number of terminated vested participants	2019-12-31	2,495
Fundng target for terminated vested participants	2019-12-31	91,618,023
Active participant vested funding target	2019-12-31	529,132,026
Number of active participants	2019-12-31	2,865
Total funding liabilities for active participants	2019-12-31	599,635,028
Total participant count	2019-12-31	9,900
Total funding target for all participants	2019-12-31	1,904,553,110
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	426,597,083
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	12,619,298
Amount remaining of carryover balance	2019-12-31	0
Amount remaining of prefunding balance	2019-12-31	413,977,785
Present value of excess contributions	2019-12-31	72,035,462
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2019-12-31	74,841,695
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2019-12-31	74,841,695
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	469,776,502
Total employer contributions	2019-12-31	58,200,750
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	56,125,167
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	25,651,925
Net shortfall amortization installment of oustanding balance	2019-12-31	87,104,039
Waiver amortization installment	2019-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2019-12-31	40,917,401
Prefunding balance elected to use to offset funding requirement	2019-12-31	8,908,523
Additional cash requirement	2019-12-31	32,008,878
Contributions allocatedtoward minimum required contributions for current year	2019-12-31	56,125,167
Unpaid minimum required contributions for current year	2019-12-31	0
Unpaid minimum required contributions for all years	2019-12-31	0
Total participants, beginning-of-year	2019-01-01	9,543
Total number of active participants reported on line 7a of the Form 5500	2019-01-01	3,266
Number of retired or separated participants receiving benefits	2019-01-01	3,585
Number of other retired or separated participants entitled to future benefits	2019-01-01	1,613
Total of all active and inactive participants	2019-01-01	8,464
Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits	2019-01-01	954
Total participants	2019-01-01	9,418
Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested	2019-01-01	22
2018: THE KEYSPAN RETIREMENT PLAN 2018 401k membership
Market value of plan assets	2018-12-31	2,303,984,817
Acturial value of plan assets	2018-12-31	2,163,032,059
Funding target for retired participants and beneficiaries receiving payment	2018-12-31	1,166,768,886
Number of terminated vested participants	2018-12-31	2,457
Fundng target for terminated vested participants	2018-12-31	86,877,068
Active participant vested funding target	2018-12-31	478,183,185
Number of active participants	2018-12-31	2,991
Total funding liabilities for active participants	2018-12-31	540,106,978
Total participant count	2018-12-31	9,946
Total funding target for all participants	2018-12-31	1,793,752,932
Balance at beginning of prior year after applicable adjustments	2018-12-31	1,748,041
Prefunding balance at beginning of prior year after applicable adjustments	2018-12-31	401,416,977
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	1,748,041
Amount remaining of prefunding balance	2018-12-31	401,416,977
Present value of excess contributions	2018-12-31	25,946,046
Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance	2018-12-31	27,474,268
Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance	2018-12-31	27,474,268
Reductions in caryover balances due to elections or deemed elections	2018-12-31	2,034,021
Reductions in prefunding balances due to elections or deemed elections	2018-12-31	67,965,979
Balance of carryovers at beginning of current year	2018-12-31	0
Balance of prefunding at beginning of current year	2018-12-31	426,597,083
Total employer contributions	2018-12-31	100,445,250
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	95,600,969
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	26,827,658
Net shortfall amortization installment of oustanding balance	2018-12-31	57,317,956
Waiver amortization installment	2018-12-31	0
Total funding amount beforereflecting carryover/prefunding balances	2018-12-31	36,184,805
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	12,619,298
Additional cash requirement	2018-12-31	23,565,507
Contributions allocatedtoward minimum required contributions for current year	2018-12-31	95,600,969
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	9,632
Total number of active participants reported on line 7a of the Form 5500	2018-01-01	3,403
Number of retired or separated participants receiving benefits	2018-01-01	3,513
Number of other retired or separated participants entitled to future benefits	2018-01-01	1,690
Total of all active and inactive participants	2018-01-01	8,606
Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits	2018-01-01	937
Total participants	2018-01-01	9,543
Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested	2018-01-01	18

Financial Data on THE KEYSPAN RETIREMENT PLAN

Measure	Date	Value
2022 : THE KEYSPAN RETIREMENT PLAN 2022 401k financial data
Total unrealized appreciation/depreciation of assets	2022-12-31	$0
Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities)	2022-12-31	$1,508,874
Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities)	2022-12-31	$1,140,687
Total income from all sources (including contributions)	2022-12-31	$-608,025,468
Total loss/gain on sale of assets	2022-12-31	$0
Total of all expenses incurred	2022-12-31	$224,368,917
Benefit payments and payments to participlants,beneficiaries,insurance carriers and others	2022-12-31	$214,989,951
Total contributions o plan (from employers,participants, others, non cash contrinutions)	2022-12-31	$20,894,778
Value of total assets at end of year	2022-12-31	$2,300,957,771
Value of total assets at beginning of year	2022-12-31	$3,132,983,969
Total of administrative expenses incurred including professional, contract, advisory and management fees	2022-12-31	$9,378,966
Total interest from all sources	2022-12-31	$0
Total dividends received (eg from common stock, registered investment company shares)	2022-12-31	$0
Has a resolution to terminate the plan been adopted during the plan year or any prior plan year	2022-12-31	No
Was this plan covered by a fidelity bond	2022-12-31	Yes
Value of fidelity bond cover	2022-12-31	$25,000,000
If this is an individual account plan, was there a blackout period	2022-12-31	No
Were there any nonexempt tranactions with any party-in-interest	2022-12-31	No
Expenses. Other payments made (not to insurance carriers or or participants/beneficiaries)	2022-12-31	$91,783,708
Value of other receiveables (less allowance for doubtful accounts) at end of year	2022-12-31	$2,448,292
Value of other receiveables (less allowance for doubtful accounts) at beginning of year	2022-12-31	$0
Administrative expenses (other) incurred	2022-12-31	$9,378,966
Liabilities. Value of operating payables at end of year	2022-12-31	$1,508,874
Liabilities. Value of operating payables at beginning of year	2022-12-31	$1,140,687
Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser	2022-12-31	No
Value of net income/loss	2022-12-31	$-832,394,385
Value of net assets at end of year (total assets less liabilities)	2022-12-31	$2,299,448,897
Value of net assets at beginning of year (total assets less liabilities)	2022-12-31	$3,131,843,282
Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond)	2022-12-31	No
Were any loans by the plan or fixed income obligations due to the plan in default	2022-12-31	No
Were any leases to which the plan was party in default or uncollectible	2022-12-31	No
Value of interest in master investment trust accounts at end of year	2022-12-31	$2,294,878,201
Value of interest in master investment trust accounts at beginning of year	2022-12-31	$3,130,287,079
Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets	2022-12-31	No
Was there a failure to transmit to the plan any participant contributions	2022-12-31	No
Has the plan failed to provide any benefit when due under the plan	2022-12-31	No
Contributions received in cash from employer	2022-12-31	$20,894,778
Employer contributions (assets) at end of year	2022-12-31	$3,631,278
Employer contributions (assets) at beginning of year	2022-12-31	$2,696,890
Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers	2022-12-31	$123,206,243
Did the plan have assets held for investment	2022-12-31	No
Did the plan hold any assets whose current value was neither redily determinable on an established market nor set by an independent third party appraiser	2022-12-31	No
Were all the plan assets eitehr distributed to particpants/beneficiaries, transferred to another plan or brought under the control of the PBGC	2022-12-31	No
Opinion of an independent qualified public accountant for this plan	2022-12-31	Unqualified
Accountancy firm name	2022-12-31	CLIFTONLARSONALLEN LLP
Accountancy firm EIN	2022-12-31	410746749
2021 : THE KEYSPAN RETIREMENT PLAN 2021 401k financial data
Total unrealized appreciation/depreciation of assets	2021-12-31	$0
Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities)	2021-12-31	$1,140,687
Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities)	2021-12-31	$1,304,618
Total income from all sources (including contributions)	2021-12-31	$368,826,611
Total loss/gain on sale of assets	2021-12-31	$0
Total of all expenses incurred	2021-12-31	$139,988,823
Benefit payments and payments to participlants,beneficiaries,insurance carriers and others	2021-12-31	$128,849,510
Total contributions o plan (from employers,participants, others, non cash contrinutions)	2021-12-31	$33,519,019
Value of total assets at end of year	2021-12-31	$3,132,983,969
Value of total assets at beginning of year	2021-12-31	$2,904,310,112
Total of administrative expenses incurred including professional, contract, advisory and management fees	2021-12-31	$11,139,313
Total interest from all sources	2021-12-31	$0
Total dividends received (eg from common stock, registered investment company shares)	2021-12-31	$0
Has a resolution to terminate the plan been adopted during the plan year or any prior plan year	2021-12-31	No
Was this plan covered by a fidelity bond	2021-12-31	Yes
Value of fidelity bond cover	2021-12-31	$25,000,000
If this is an individual account plan, was there a blackout period	2021-12-31	No
Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities	2021-12-31	$0
Were there any nonexempt tranactions with any party-in-interest	2021-12-31	No
Expenses. Other payments made (not to insurance carriers or or participants/beneficiaries)	2021-12-31	$7,907,632
Administrative expenses (other) incurred	2021-12-31	$11,139,313
Liabilities. Value of operating payables at end of year	2021-12-31	$1,140,687
Liabilities. Value of operating payables at beginning of year	2021-12-31	$1,304,618
Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser	2021-12-31	No
Value of net income/loss	2021-12-31	$228,837,788
Value of net assets at end of year (total assets less liabilities)	2021-12-31	$3,131,843,282
Value of net assets at beginning of year (total assets less liabilities)	2021-12-31	$2,903,005,494
Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond)	2021-12-31	No
Were any loans by the plan or fixed income obligations due to the plan in default	2021-12-31	No
Were any leases to which the plan was party in default or uncollectible	2021-12-31	No
Value of interest in master investment trust accounts at end of year	2021-12-31	$3,130,287,079
Value of interest in master investment trust accounts at beginning of year	2021-12-31	$2,895,792,743
Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets	2021-12-31	No
Was there a failure to transmit to the plan any participant contributions	2021-12-31	No
Has the plan failed to provide any benefit when due under the plan	2021-12-31	No
Contributions received in cash from employer	2021-12-31	$33,519,019
Employer contributions (assets) at end of year	2021-12-31	$2,696,890
Employer contributions (assets) at beginning of year	2021-12-31	$8,517,369
Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers	2021-12-31	$120,941,878
Did the plan have assets held for investment	2021-12-31	No
Did the plan hold any assets whose current value was neither redily determinable on an established market nor set by an independent third party appraiser	2021-12-31	No
Were all the plan assets eitehr distributed to particpants/beneficiaries, transferred to another plan or brought under the control of the PBGC	2021-12-31	No
Opinion of an independent qualified public accountant for this plan	2021-12-31	Unqualified
Accountancy firm name	2021-12-31	CLIFTONLARSONALLEN LLP
Accountancy firm EIN	2021-12-31	410746749
2020 : THE KEYSPAN RETIREMENT PLAN 2020 401k financial data
Total unrealized appreciation/depreciation of assets	2020-12-31	$0
Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities)	2020-12-31	$1,304,618
Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities)	2020-12-31	$1,339,718
Total income from all sources (including contributions)	2020-12-31	$446,117,473
Total loss/gain on sale of assets	2020-12-31	$0
Total of all expenses incurred	2020-12-31	$126,469,241
Benefit payments and payments to participlants,beneficiaries,insurance carriers and others	2020-12-31	$117,237,055
Total contributions o plan (from employers,participants, others, non cash contrinutions)	2020-12-31	$59,453,875
Value of total assets at end of year	2020-12-31	$2,904,310,112
Value of total assets at beginning of year	2020-12-31	$2,584,696,980
Total of administrative expenses incurred including professional, contract, advisory and management fees	2020-12-31	$9,232,186
Total interest from all sources	2020-12-31	$0
Total dividends received (eg from common stock, registered investment company shares)	2020-12-31	$0
Has a resolution to terminate the plan been adopted during the plan year or any prior plan year	2020-12-31	No
Was this plan covered by a fidelity bond	2020-12-31	Yes
Value of fidelity bond cover	2020-12-31	$25,000,000
If this is an individual account plan, was there a blackout period	2020-12-31	No
Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities	2020-12-31	$0
Were there any nonexempt tranactions with any party-in-interest	2020-12-31	No
Administrative expenses (other) incurred	2020-12-31	$9,232,186
Liabilities. Value of operating payables at end of year	2020-12-31	$1,304,618
Liabilities. Value of operating payables at beginning of year	2020-12-31	$1,339,718
Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser	2020-12-31	No
Value of net income/loss	2020-12-31	$319,648,232
Value of net assets at end of year (total assets less liabilities)	2020-12-31	$2,903,005,494
Value of net assets at beginning of year (total assets less liabilities)	2020-12-31	$2,583,357,262
Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond)	2020-12-31	No
Were any loans by the plan or fixed income obligations due to the plan in default	2020-12-31	No
Were any leases to which the plan was party in default or uncollectible	2020-12-31	No
Value of interest in master investment trust accounts at end of year	2020-12-31	$2,895,792,743
Value of interest in master investment trust accounts at beginning of year	2020-12-31	$2,584,696,980
Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets	2020-12-31	No
Was there a failure to transmit to the plan any participant contributions	2020-12-31	No
Has the plan failed to provide any benefit when due under the plan	2020-12-31	No
Contributions received in cash from employer	2020-12-31	$59,453,875
Employer contributions (assets) at end of year	2020-12-31	$8,517,369
Employer contributions (assets) at beginning of year	2020-12-31	$0
Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers	2020-12-31	$117,237,055
Did the plan have assets held for investment	2020-12-31	No
Did the plan hold any assets whose current value was neither redily determinable on an established market nor set by an independent third party appraiser	2020-12-31	No
Were all the plan assets eitehr distributed to particpants/beneficiaries, transferred to another plan or brought under the control of the PBGC	2020-12-31	No
Opinion of an independent qualified public accountant for this plan	2020-12-31	Disclaimer
Accountancy firm name	2020-12-31	CLIFTONLARSONALLEN LLP
Accountancy firm EIN	2020-12-31	410746749
2019 : THE KEYSPAN RETIREMENT PLAN 2019 401k financial data
Total unrealized appreciation/depreciation of assets	2019-12-31	$0
Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities)	2019-12-31	$1,339,718
Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities)	2019-12-31	$1,037,245
Total income from all sources (including contributions)	2019-12-31	$513,456,499
Total loss/gain on sale of assets	2019-12-31	$0
Total of all expenses incurred	2019-12-31	$120,257,790
Benefit payments and payments to participlants,beneficiaries,insurance carriers and others	2019-12-31	$111,660,530
Total contributions o plan (from employers,participants, others, non cash contrinutions)	2019-12-31	$58,200,750
Value of total assets at end of year	2019-12-31	$2,584,696,980
Value of total assets at beginning of year	2019-12-31	$2,191,195,798
Total of administrative expenses incurred including professional, contract, advisory and management fees	2019-12-31	$8,597,260
Total interest from all sources	2019-12-31	$0
Total dividends received (eg from common stock, registered investment company shares)	2019-12-31	$0
Has a resolution to terminate the plan been adopted during the plan year or any prior plan year	2019-12-31	No
Was this plan covered by a fidelity bond	2019-12-31	Yes
Value of fidelity bond cover	2019-12-31	$25,000,000
If this is an individual account plan, was there a blackout period	2019-12-31	No
Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities	2019-12-31	$0
Were there any nonexempt tranactions with any party-in-interest	2019-12-31	No
Administrative expenses (other) incurred	2019-12-31	$8,597,260
Liabilities. Value of operating payables at end of year	2019-12-31	$1,339,718
Liabilities. Value of operating payables at beginning of year	2019-12-31	$1,037,245
Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser	2019-12-31	No
Value of net income/loss	2019-12-31	$393,198,709
Value of net assets at end of year (total assets less liabilities)	2019-12-31	$2,583,357,262
Value of net assets at beginning of year (total assets less liabilities)	2019-12-31	$2,190,158,553
Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond)	2019-12-31	No
Were any loans by the plan or fixed income obligations due to the plan in default	2019-12-31	No
Were any leases to which the plan was party in default or uncollectible	2019-12-31	No
Value of interest in master investment trust accounts at end of year	2019-12-31	$2,584,696,980
Value of interest in master investment trust accounts at beginning of year	2019-12-31	$2,157,714,048
Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets	2019-12-31	No
Was there a failure to transmit to the plan any participant contributions	2019-12-31	No
Has the plan failed to provide any benefit when due under the plan	2019-12-31	No
Contributions received in cash from employer	2019-12-31	$58,200,750
Employer contributions (assets) at end of year	2019-12-31	$0
Employer contributions (assets) at beginning of year	2019-12-31	$33,481,750
Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers	2019-12-31	$111,660,530
Did the plan have assets held for investment	2019-12-31	No
Did the plan hold any assets whose current value was neither redily determinable on an established market nor set by an independent third party appraiser	2019-12-31	No
Were all the plan assets eitehr distributed to particpants/beneficiaries, transferred to another plan or brought under the control of the PBGC	2019-12-31	No
Accountant perfomed limited scope audit pursuant to 29 CFR 2520.103-8 and/or 103-12(d)	2019-12-31	Yes
Opinion of an independent qualified public accountant for this plan	2019-12-31	Disclaimer
Accountancy firm name	2019-12-31	CLIFTONLARSONALLEN LLP
Accountancy firm EIN	2019-12-31	410746749
2018 : THE KEYSPAN RETIREMENT PLAN 2018 401k financial data
Total unrealized appreciation/depreciation of assets	2018-12-31	$0
Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities)	2018-12-31	$1,037,245
Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities)	2018-12-31	$1,119,312
Total income from all sources (including contributions)	2018-12-31	$1,813,940
Total loss/gain on sale of assets	2018-12-31	$0
Total of all expenses incurred	2018-12-31	$118,007,097
Benefit payments and payments to participlants,beneficiaries,insurance carriers and others	2018-12-31	$111,670,417
Total contributions o plan (from employers,participants, others, non cash contrinutions)	2018-12-31	$100,445,250
Value of total assets at end of year	2018-12-31	$2,191,195,798
Value of total assets at beginning of year	2018-12-31	$2,307,471,022
Total of administrative expenses incurred including professional, contract, advisory and management fees	2018-12-31	$6,336,680
Total interest from all sources	2018-12-31	$0
Total dividends received (eg from common stock, registered investment company shares)	2018-12-31	$0
Has a resolution to terminate the plan been adopted during the plan year or any prior plan year	2018-12-31	No
Was this plan covered by a fidelity bond	2018-12-31	Yes
Value of fidelity bond cover	2018-12-31	$25,000,000
If this is an individual account plan, was there a blackout period	2018-12-31	No
Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities	2018-12-31	$0
Were there any nonexempt tranactions with any party-in-interest	2018-12-31	No
Administrative expenses (other) incurred	2018-12-31	$6,336,680
Liabilities. Value of operating payables at end of year	2018-12-31	$1,037,245
Liabilities. Value of operating payables at beginning of year	2018-12-31	$1,119,312
Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser	2018-12-31	No
Value of net income/loss	2018-12-31	$-116,193,157
Value of net assets at end of year (total assets less liabilities)	2018-12-31	$2,190,158,553
Value of net assets at beginning of year (total assets less liabilities)	2018-12-31	$2,306,351,710
Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond)	2018-12-31	No
Were any loans by the plan or fixed income obligations due to the plan in default	2018-12-31	No
Were any leases to which the plan was party in default or uncollectible	2018-12-31	No
Value of interest in master investment trust accounts at end of year	2018-12-31	$2,157,714,048
Value of interest in master investment trust accounts at beginning of year	2018-12-31	$2,252,237,772
Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets	2018-12-31	No
Was there a failure to transmit to the plan any participant contributions	2018-12-31	No
Has the plan failed to provide any benefit when due under the plan	2018-12-31	No
Contributions received in cash from employer	2018-12-31	$100,445,250
Employer contributions (assets) at end of year	2018-12-31	$33,481,750
Employer contributions (assets) at beginning of year	2018-12-31	$55,233,250
Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers	2018-12-31	$111,670,417
Did the plan have assets held for investment	2018-12-31	No
Did the plan hold any assets whose current value was neither redily determinable on an established market nor set by an independent third party appraiser	2018-12-31	No
Were all the plan assets eitehr distributed to particpants/beneficiaries, transferred to another plan or brought under the control of the PBGC	2018-12-31	No
Accountant perfomed limited scope audit pursuant to 29 CFR 2520.103-8 and/or 103-12(d)	2018-12-31	Yes
Opinion of an independent qualified public accountant for this plan	2018-12-31	Disclaimer
Accountancy firm name	2018-12-31	CLIFTONLARSONALLEN LLP
Accountancy firm EIN	2018-12-31	410746749

Form 5500 Responses for THE KEYSPAN RETIREMENT PLAN

2022: THE KEYSPAN RETIREMENT PLAN 2022 form 5500 responses
2022-01-01	Type of plan entity	Single employer plan
2022-01-01	Submission has been amended	No
2022-01-01	This submission is the final filing	No
2022-01-01	This return/report is a short plan year return/report (less than 12 months)	No
2022-01-01	Plan is a collectively bargained plan	Yes
2022-01-01	Plan funding arrangement – Trust	Yes
2022-01-01	Plan benefit arrangement - Trust	Yes
2021: THE KEYSPAN RETIREMENT PLAN 2021 form 5500 responses
2021-01-01	Type of plan entity	Single employer plan
2021-01-01	Submission has been amended	No
2021-01-01	This submission is the final filing	No
2021-01-01	This return/report is a short plan year return/report (less than 12 months)	No
2021-01-01	Plan is a collectively bargained plan	Yes
2021-01-01	Plan funding arrangement – Trust	Yes
2021-01-01	Plan benefit arrangement - Trust	Yes
2020: THE KEYSPAN RETIREMENT PLAN 2020 form 5500 responses
2020-01-01	Type of plan entity	Single employer plan
2020-01-01	Submission has been amended	No
2020-01-01	This submission is the final filing	No
2020-01-01	This return/report is a short plan year return/report (less than 12 months)	No
2020-01-01	Plan is a collectively bargained plan	Yes
2020-01-01	Plan funding arrangement – Trust	Yes
2020-01-01	Plan benefit arrangement - Trust	Yes
2019: THE KEYSPAN RETIREMENT PLAN 2019 form 5500 responses
2019-01-01	Type of plan entity	Single employer plan
2019-01-01	Submission has been amended	No
2019-01-01	This submission is the final filing	No
2019-01-01	This return/report is a short plan year return/report (less than 12 months)	No
2019-01-01	Plan is a collectively bargained plan	Yes
2019-01-01	Plan funding arrangement – Trust	Yes
2019-01-01	Plan benefit arrangement - Trust	Yes
2018: THE KEYSPAN RETIREMENT PLAN 2018 form 5500 responses
2018-01-01	Type of plan entity	Single employer plan
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	Yes
2018-01-01	Plan funding arrangement – Trust	Yes
2018-01-01	Plan benefit arrangement - Trust	Yes

Potentially related plans

THE KEYSPAN RETIREMENT PLAN [EIN = 113431358]

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:	NATIONAL GRID USA SERVICE COMPANY, INC.
Employer identification number (EIN):	041663150
NAIC Classification:	221100