XCEL ENERGY INC has sponsored the creation of one or more 401k plans.
Submission information for form 5500 for 401k plan NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES
401k plan membership statisitcs for NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES
| Measure | Date | Value |
|---|
| 2023: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2023 401k membership |
|---|
| Total participants, beginning-of-year | 2023-01-01 | 6,502 |
| Total number of active participants reported on line 7a of the Form 5500 | 2023-01-01 | 1,953 |
| Number of retired or separated participants receiving benefits | 2023-01-01 | 3,489 |
| Number of other retired or separated participants entitled to future benefits | 2023-01-01 | 546 |
| Total of all active and inactive participants | 2023-01-01 | 5,988 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2023-01-01 | 521 |
| Total participants | 2023-01-01 | 6,509 |
| Number of participants with account balances | 2023-01-01 | 0 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2023-01-01 | 12 |
| 2022: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2022 401k membership |
|---|
| Market value of plan assets | 2022-12-31 | 1,218,755,868 |
| Acturial value of plan assets | 2022-12-31 | 1,165,359,529 |
| Funding target for retired participants and beneficiaries receiving payment | 2022-12-31 | 670,061,530 |
| Number of terminated vested participants | 2022-12-31 | 548 |
| Fundng target for terminated vested participants | 2022-12-31 | 35,734,211 |
| Active participant vested funding target | 2022-12-31 | 188,680,623 |
| Number of active participants | 2022-12-31 | 1,935 |
| Total funding liabilities for active participants | 2022-12-31 | 204,960,450 |
| Total participant count | 2022-12-31 | 6,689 |
| Total funding target for all participants | 2022-12-31 | 910,756,191 |
| 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 | 187,631,737 |
| 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 | 21,625,000 |
| Amount remaining of carryover balance | 2022-12-31 | 0 |
| Amount remaining of prefunding balance | 2022-12-31 | 166,006,737 |
| Present value of excess contributions | 2022-12-31 | 37,874,536 |
| Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2022-12-31 | 40,541,513 |
| Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2022-12-31 | 40,541,513 |
| 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 | 220,061,198 |
| Total employer contributions | 2022-12-31 | 0 |
| Total employee contributions | 2022-12-31 | 0 |
| Contributions allocated toward unpaid minimum require contributions from prior years | 2022-12-31 | 0 |
| Contributions made to avoid restrictions adjusted to valuation date | 2022-12-31 | 0 |
| Contributions allocated toward minimum required contributions for current year adjusted to valuation date | 2022-12-31 | 0 |
| 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 | 16,931,390 |
| Net shortfall amortization installment of oustanding balance | 2022-12-31 | 0 |
| Waiver amortization installment | 2022-12-31 | 0 |
| Total funding amount beforereflecting carryover/prefunding balances | 2022-12-31 | 0 |
| Carryover balance elected to use to offset funding requirement | 2022-12-31 | 0 |
| Prefunding balance elected to use to offset funding requirement | 2022-12-31 | 0 |
| Additional cash requirement | 2022-12-31 | 0 |
| Contributions allocatedtoward minimum required contributions for current year | 2022-12-31 | 0 |
| Unpaid minimum required contributions for current year | 2022-12-31 | 0 |
| Unpaid minimum required contributions for all years | 2022-12-31 | 0 |
| Total participants, beginning-of-year | 2022-01-01 | 6,521 |
| Total number of active participants reported on line 7a of the Form 5500 | 2022-01-01 | 1,942 |
| Number of retired or separated participants receiving benefits | 2022-01-01 | 3,515 |
| Number of other retired or separated participants entitled to future benefits | 2022-01-01 | 541 |
| Total of all active and inactive participants | 2022-01-01 | 5,998 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2022-01-01 | 504 |
| Total participants | 2022-01-01 | 6,502 |
| Number of participants with account balances | 2022-01-01 | 0 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2022-01-01 | 3 |
| 2021: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2021 401k membership |
|---|
| Market value of plan assets | 2021-12-31 | 1,154,639,463 |
| Acturial value of plan assets | 2021-12-31 | 1,039,175,517 |
| Funding target for retired participants and beneficiaries receiving payment | 2021-12-31 | 666,414,117 |
| Number of terminated vested participants | 2021-12-31 | 528 |
| Fundng target for terminated vested participants | 2021-12-31 | 30,741,270 |
| Active participant vested funding target | 2021-12-31 | 188,278,654 |
| Number of active participants | 2021-12-31 | 1,931 |
| Total funding liabilities for active participants | 2021-12-31 | 204,798,258 |
| Total participant count | 2021-12-31 | 6,682 |
| Total funding target for all participants | 2021-12-31 | 901,953,645 |
| Balance at beginning of prior year after applicable adjustments | 2021-12-31 | 6,524,790 |
| Prefunding balance at beginning of prior year after applicable adjustments | 2021-12-31 | 177,013,052 |
| Carryover balanced portion elected for use to offset prior years funding requirement | 2021-12-31 | 6,524,790 |
| Prefunding balanced used to offset prior years funding requirement | 2021-12-31 | 18,030,052 |
| Amount remaining of carryover balance | 2021-12-31 | 0 |
| Amount remaining of prefunding balance | 2021-12-31 | 158,983,000 |
| Present value of excess contributions | 2021-12-31 | 0 |
| Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2021-12-31 | 0 |
| Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2021-12-31 | 0 |
| Reductions in caryover balances due to elections or deemed elections | 2021-12-31 | 0 |
| Reductions in prefunding balances due to elections or deemed elections | 2021-12-31 | 0 |
| Balance of carryovers at beginning of current year | 2021-12-31 | 0 |
| Balance of prefunding at beginning of current year | 2021-12-31 | 187,631,737 |
| Total employer contributions | 2021-12-31 | 40,000,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 | 37,914,257 |
| 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 | 15,957,026 |
| Net shortfall amortization installment of oustanding balance | 2021-12-31 | 50,409,865 |
| Waiver amortization installment | 2021-12-31 | 0 |
| Total funding amount beforereflecting carryover/prefunding balances | 2021-12-31 | 21,624,136 |
| 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 | 21,624,136 |
| Additional cash requirement | 2021-12-31 | 0 |
| Contributions allocatedtoward minimum required contributions for current year | 2021-12-31 | 37,914,257 |
| 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 | 6,524 |
| Total number of active participants reported on line 7a of the Form 5500 | 2021-01-01 | 1,925 |
| Number of retired or separated participants receiving benefits | 2021-01-01 | 3,546 |
| Number of other retired or separated participants entitled to future benefits | 2021-01-01 | 548 |
| Total of all active and inactive participants | 2021-01-01 | 6,019 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2021-01-01 | 502 |
| Total participants | 2021-01-01 | 6,521 |
| Number of participants with account balances | 2021-01-01 | 0 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2021-01-01 | 4 |
| 2020: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2020 401k membership |
|---|
| Market value of plan assets | 2020-12-31 | 1,046,474,254 |
| Acturial value of plan assets | 2020-12-31 | 994,305,433 |
| Funding target for retired participants and beneficiaries receiving payment | 2020-12-31 | 654,829,264 |
| Number of terminated vested participants | 2020-12-31 | 544 |
| Fundng target for terminated vested participants | 2020-12-31 | 32,617,974 |
| Active participant vested funding target | 2020-12-31 | 195,814,415 |
| Number of active participants | 2020-12-31 | 1,952 |
| Total funding liabilities for active participants | 2020-12-31 | 211,598,742 |
| Total participant count | 2020-12-31 | 6,731 |
| Total funding target for all participants | 2020-12-31 | 899,045,980 |
| Balance at beginning of prior year after applicable adjustments | 2020-12-31 | 18,913,052 |
| Prefunding balance at beginning of prior year after applicable adjustments | 2020-12-31 | 98,966,430 |
| Carryover balanced portion elected for use to offset prior years funding requirement | 2020-12-31 | 13,534,000 |
| Prefunding balanced used to offset prior years funding requirement | 2020-12-31 | 0 |
| Amount remaining of carryover balance | 2020-12-31 | 5,379,052 |
| Amount remaining of prefunding balance | 2020-12-31 | 98,966,430 |
| Present value of excess contributions | 2020-12-31 | 51,992,752 |
| Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2020-12-31 | 56,990,725 |
| Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2020-12-31 | 56,966,772 |
| 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 | 6,524,790 |
| Balance of prefunding at beginning of current year | 2020-12-31 | 177,013,052 |
| Total employer contributions | 2020-12-31 | 0 |
| 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 | 0 |
| 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 | 15,726,408 |
| Net shortfall amortization installment of oustanding balance | 2020-12-31 | 88,278,389 |
| Waiver amortization installment | 2020-12-31 | 0 |
| Total funding amount beforereflecting carryover/prefunding balances | 2020-12-31 | 24,549,964 |
| Carryover balance elected to use to offset funding requirement | 2020-12-31 | 6,524,790 |
| Prefunding balance elected to use to offset funding requirement | 2020-12-31 | 18,030,052 |
| Additional cash requirement | 2020-12-31 | 0 |
| Contributions allocatedtoward minimum required contributions for current year | 2020-12-31 | 0 |
| 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 | 6,582 |
| Total number of active participants reported on line 7a of the Form 5500 | 2020-01-01 | 1,925 |
| Number of retired or separated participants receiving benefits | 2020-01-01 | 3,580 |
| Number of other retired or separated participants entitled to future benefits | 2020-01-01 | 528 |
| Total of all active and inactive participants | 2020-01-01 | 6,033 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2020-01-01 | 491 |
| Total participants | 2020-01-01 | 6,524 |
| Number of participants with account balances | 2020-01-01 | 0 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2020-01-01 | 9 |
| 2019: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2019 401k membership |
|---|
| Market value of plan assets | 2019-12-31 | 865,946,276 |
| Acturial value of plan assets | 2019-12-31 | 907,568,279 |
| Funding target for retired participants and beneficiaries receiving payment | 2019-12-31 | 659,547,676 |
| Number of terminated vested participants | 2019-12-31 | 531 |
| Fundng target for terminated vested participants | 2019-12-31 | 32,565,255 |
| Active participant vested funding target | 2019-12-31 | 210,211,843 |
| Number of active participants | 2019-12-31 | 1,895 |
| Total funding liabilities for active participants | 2019-12-31 | 228,090,346 |
| Total participant count | 2019-12-31 | 6,672 |
| Total funding target for all participants | 2019-12-31 | 920,203,277 |
| Balance at beginning of prior year after applicable adjustments | 2019-12-31 | 31,946,253 |
| Prefunding balance at beginning of prior year after applicable adjustments | 2019-12-31 | 70,005,450 |
| Carryover balanced portion elected for use to offset prior years funding requirement | 2019-12-31 | 12,171,000 |
| Prefunding balanced used to offset prior years funding requirement | 2019-12-31 | 0 |
| Amount remaining of carryover balance | 2019-12-31 | 19,775,253 |
| Amount remaining of prefunding balance | 2019-12-31 | 70,005,450 |
| Present value of excess contributions | 2019-12-31 | 31,454,364 |
| Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2019-12-31 | 32,013,218 |
| Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2019-12-31 | 32,013,218 |
| 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 | 18,913,052 |
| Balance of prefunding at beginning of current year | 2019-12-31 | 98,966,430 |
| Total employer contributions | 2019-12-31 | 40,023,854 |
| 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 | 37,931,749 |
| 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 | 19,738,563 |
| Net shortfall amortization installment of oustanding balance | 2019-12-31 | 130,514,480 |
| Waiver amortization installment | 2019-12-31 | 0 |
| Total funding amount beforereflecting carryover/prefunding balances | 2019-12-31 | 40,945,568 |
| Carryover balance elected to use to offset funding requirement | 2019-12-31 | 13,534,000 |
| Prefunding balance elected to use to offset funding requirement | 2019-12-31 | 0 |
| Additional cash requirement | 2019-12-31 | 27,411,568 |
| Contributions allocatedtoward minimum required contributions for current year | 2019-12-31 | 37,931,749 |
| 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 | 6,529 |
| Total number of active participants reported on line 7a of the Form 5500 | 2019-01-01 | 1,946 |
| Number of retired or separated participants receiving benefits | 2019-01-01 | 3,600 |
| Number of other retired or separated participants entitled to future benefits | 2019-01-01 | 544 |
| Total of all active and inactive participants | 2019-01-01 | 6,090 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2019-01-01 | 492 |
| Total participants | 2019-01-01 | 6,582 |
| Number of participants with account balances | 2019-01-01 | 0 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2019-01-01 | 9 |
| 2018: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2018 401k membership |
|---|
| Market value of plan assets | 2018-12-31 | 935,143,735 |
| Acturial value of plan assets | 2018-12-31 | 891,871,100 |
| Funding target for retired participants and beneficiaries receiving payment | 2018-12-31 | 628,457,386 |
| Number of terminated vested participants | 2018-12-31 | 527 |
| Fundng target for terminated vested participants | 2018-12-31 | 30,985,078 |
| Active participant vested funding target | 2018-12-31 | 209,704,507 |
| Number of active participants | 2018-12-31 | 1,969 |
| Total funding liabilities for active participants | 2018-12-31 | 228,251,818 |
| Total participant count | 2018-12-31 | 6,729 |
| Total funding target for all participants | 2018-12-31 | 887,694,282 |
| Balance at beginning of prior year after applicable adjustments | 2018-12-31 | 39,923,133 |
| Prefunding balance at beginning of prior year after applicable adjustments | 2018-12-31 | 53,308,492 |
| Carryover balanced portion elected for use to offset prior years funding requirement | 2018-12-31 | 12,024,912 |
| Prefunding balanced used to offset prior years funding requirement | 2018-12-31 | 0 |
| Amount remaining of carryover balance | 2018-12-31 | 27,898,221 |
| Amount remaining of prefunding balance | 2018-12-31 | 53,308,492 |
| Present value of excess contributions | 2018-12-31 | 7,847,110 |
| Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2018-12-31 | 8,985,726 |
| Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2018-12-31 | 8,961,896 |
| 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 | 31,946,253 |
| Balance of prefunding at beginning of current year | 2018-12-31 | 70,005,450 |
| Total employer contributions | 2018-12-31 | 40,000,000 |
| Total employee contributions | 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 | 37,855,082 |
| 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 |
| Remaining amount of unpaid minimum required contributions | 2018-12-31 | 0 |
| Minimum required contributions for current year target normal cost | 2018-12-31 | 18,571,718 |
| Net shortfall amortization installment of oustanding balance | 2018-12-31 | 0 |
| Waiver amortization installment | 2018-12-31 | 0 |
| Total funding amount beforereflecting carryover/prefunding balances | 2018-12-31 | 18,571,718 |
| Carryover balance elected to use to offset funding requirement | 2018-12-31 | 12,171,000 |
| Prefunding balance elected to use to offset funding requirement | 2018-12-31 | 0 |
| Additional cash requirement | 2018-12-31 | 6,400,718 |
| Contributions allocatedtoward minimum required contributions for current year | 2018-12-31 | 37,855,082 |
| 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 | 6,598 |
| Total number of active participants reported on line 7a of the Form 5500 | 2018-01-01 | 1,892 |
| Number of retired or separated participants receiving benefits | 2018-01-01 | 3,632 |
| Number of other retired or separated participants entitled to future benefits | 2018-01-01 | 531 |
| Total of all active and inactive participants | 2018-01-01 | 6,055 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2018-01-01 | 474 |
| Total participants | 2018-01-01 | 6,529 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2018-01-01 | 9 |
| 2017: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2017 401k membership |
|---|
| Market value of plan assets | 2017-12-31 | 867,571,774 |
| Acturial value of plan assets | 2017-12-31 | 893,403,343 |
| Funding target for retired participants and beneficiaries receiving payment | 2017-12-31 | 582,526,142 |
| Number of terminated vested participants | 2017-12-31 | 560 |
| Fundng target for terminated vested participants | 2017-12-31 | 32,875,748 |
| Active participant vested funding target | 2017-12-31 | 231,854,818 |
| Number of active participants | 2017-12-31 | 2,039 |
| Total funding liabilities for active participants | 2017-12-31 | 250,796,565 |
| Total participant count | 2017-12-31 | 6,739 |
| Total funding target for all participants | 2017-12-31 | 866,198,455 |
| Balance at beginning of prior year after applicable adjustments | 2017-12-31 | 45,791,168 |
| Prefunding balance at beginning of prior year after applicable adjustments | 2017-12-31 | 50,276,801 |
| Carryover balanced portion elected for use to offset prior years funding requirement | 2017-12-31 | 8,138,491 |
| Prefunding balanced used to offset prior years funding requirement | 2017-12-31 | 0 |
| Amount remaining of carryover balance | 2017-12-31 | 37,652,677 |
| Amount remaining of prefunding balance | 2017-12-31 | 50,276,801 |
| Present value of excess contributions | 2017-12-31 | 36,717 |
| Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2017-12-31 | 38,931 |
| Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2017-12-31 | 0 |
| Reductions in caryover balances due to elections or deemed elections | 2017-12-31 | 0 |
| Reductions in prefunding balances due to elections or deemed elections | 2017-12-31 | 0 |
| Balance of carryovers at beginning of current year | 2017-12-31 | 39,923,133 |
| Balance of prefunding at beginning of current year | 2017-12-31 | 53,308,492 |
| Total employer contributions | 2017-12-31 | 15,021,934 |
| Total employee contributions | 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 | 14,189,569 |
| 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 |
| Remaining amount of unpaid minimum required contributions | 2017-12-31 | 0 |
| Minimum required contributions for current year target normal cost | 2017-12-31 | 18,367,371 |
| Net shortfall amortization installment of oustanding balance | 2017-12-31 | 0 |
| Waiver amortization installment | 2017-12-31 | 0 |
| Total funding amount beforereflecting carryover/prefunding balances | 2017-12-31 | 18,367,371 |
| Carryover balance elected to use to offset funding requirement | 2017-12-31 | 12,024,912 |
| Prefunding balance elected to use to offset funding requirement | 2017-12-31 | 0 |
| Additional cash requirement | 2017-12-31 | 6,342,459 |
| Contributions allocatedtoward minimum required contributions for current year | 2017-12-31 | 14,189,569 |
| Unpaid minimum required contributions for current year | 2017-12-31 | 0 |
| Unpaid minimum required contributions for all years | 2017-12-31 | 0 |
| Total participants, beginning-of-year | 2017-01-01 | 6,619 |
| Total number of active participants reported on line 7a of the Form 5500 | 2017-01-01 | 1,967 |
| Number of retired or separated participants receiving benefits | 2017-01-01 | 3,644 |
| Number of other retired or separated participants entitled to future benefits | 2017-01-01 | 527 |
| Total of all active and inactive participants | 2017-01-01 | 6,138 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2017-01-01 | 460 |
| Total participants | 2017-01-01 | 6,598 |
| Number of participants with account balances | 2017-01-01 | 0 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2017-01-01 | 6 |
| 2016: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2016 401k membership |
|---|
| Market value of plan assets | 2016-12-31 | 892,626,974 |
| Acturial value of plan assets | 2016-12-31 | 933,740,627 |
| Funding target for retired participants and beneficiaries receiving payment | 2016-12-31 | 545,210,343 |
| Number of terminated vested participants | 2016-12-31 | 1,139 |
| Fundng target for terminated vested participants | 2016-12-31 | 59,940,122 |
| Active participant vested funding target | 2016-12-31 | 239,247,078 |
| Number of active participants | 2016-12-31 | 2,105 |
| Total funding liabilities for active participants | 2016-12-31 | 257,840,794 |
| Total participant count | 2016-12-31 | 7,231 |
| Total funding target for all participants | 2016-12-31 | 862,991,259 |
| Balance at beginning of prior year after applicable adjustments | 2016-12-31 | 46,160,452 |
| Prefunding balance at beginning of prior year after applicable adjustments | 2016-12-31 | 40,606,690 |
| Carryover balanced portion elected for use to offset prior years funding requirement | 2016-12-31 | 0 |
| Prefunding balanced used to offset prior years funding requirement | 2016-12-31 | 0 |
| Amount remaining of carryover balance | 2016-12-31 | 46,160,452 |
| Amount remaining of prefunding balance | 2016-12-31 | 40,606,690 |
| Present value of excess contributions | 2016-12-31 | 9,420,206 |
| Total available prior years excess cotributions available at beginning of current plan year to add to prefunding balance | 2016-12-31 | 10,007,085 |
| Total available prior years excess cotributions added at beginning of current plan year to add to prefunding balance | 2016-12-31 | 9,994,965 |
| 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 | 45,791,168 |
| Balance of prefunding at beginning of current year | 2016-12-31 | 50,276,801 |
| Total employer contributions | 2016-12-31 | 10,038,776 |
| Total employee contributions | 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 | 9,464,049 |
| Remaining amount of unpaid minimum required contributions | 2016-12-31 | 0 |
| Minimum required contributions for current year target normal cost | 2016-12-31 | 17,565,823 |
| Net shortfall amortization installment of oustanding balance | 2016-12-31 | 0 |
| Waiver amortization installment | 2016-12-31 | 0 |
| Total funding amount beforereflecting carryover/prefunding balances | 2016-12-31 | 17,565,823 |
| Carryover balance elected to use to offset funding requirement | 2016-12-31 | 8,138,491 |
| Prefunding balance elected to use to offset funding requirement | 2016-12-31 | 0 |
| Additional cash requirement | 2016-12-31 | 9,427,332 |
| Contributions allocatedtoward minimum required contributions for current year | 2016-12-31 | 9,464,049 |
| Unpaid minimum required contributions for current year | 2016-12-31 | 0 |
| Unpaid minimum required contributions for all years | 2016-12-31 | 0 |
| Total participants, beginning-of-year | 2016-01-01 | 7,123 |
| Total number of active participants reported on line 7a of the Form 5500 | 2016-01-01 | 2,037 |
| Number of retired or separated participants receiving benefits | 2016-01-01 | 3,568 |
| Number of other retired or separated participants entitled to future benefits | 2016-01-01 | 560 |
| Total of all active and inactive participants | 2016-01-01 | 6,165 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2016-01-01 | 454 |
| Total participants | 2016-01-01 | 6,619 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2016-01-01 | 7 |
| 2015: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2015 401k membership |
|---|
| Total participants, beginning-of-year | 2015-01-01 | 7,167 |
| Total number of active participants reported on line 7a of the Form 5500 | 2015-01-01 | 2,103 |
| Number of retired or separated participants receiving benefits | 2015-01-01 | 3,451 |
| Number of other retired or separated participants entitled to future benefits | 2015-01-01 | 1,139 |
| Total of all active and inactive participants | 2015-01-01 | 6,693 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2015-01-01 | 430 |
| Total participants | 2015-01-01 | 7,123 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2015-01-01 | 10 |
| 2014: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2014 401k membership |
|---|
| Total participants, beginning-of-year | 2014-01-01 | 7,092 |
| Total number of active participants reported on line 7a of the Form 5500 | 2014-01-01 | 2,131 |
| Number of retired or separated participants receiving benefits | 2014-01-01 | 3,431 |
| Number of other retired or separated participants entitled to future benefits | 2014-01-01 | 1,202 |
| Total of all active and inactive participants | 2014-01-01 | 6,764 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2014-01-01 | 403 |
| Total participants | 2014-01-01 | 7,167 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2014-01-01 | 6 |
| 2013: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2013 401k membership |
|---|
| Total participants, beginning-of-year | 2013-01-01 | 7,112 |
| Total number of active participants reported on line 7a of the Form 5500 | 2013-01-01 | 2,092 |
| Number of retired or separated participants receiving benefits | 2013-01-01 | 3,376 |
| Number of other retired or separated participants entitled to future benefits | 2013-01-01 | 1,232 |
| Total of all active and inactive participants | 2013-01-01 | 6,700 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2013-01-01 | 392 |
| Total participants | 2013-01-01 | 7,092 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2013-01-01 | 6 |
| 2012: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2012 401k membership |
|---|
| Total participants, beginning-of-year | 2012-01-01 | 7,044 |
| Total number of active participants reported on line 7a of the Form 5500 | 2012-01-01 | 2,068 |
| Number of retired or separated participants receiving benefits | 2012-01-01 | 3,344 |
| Number of other retired or separated participants entitled to future benefits | 2012-01-01 | 1,325 |
| Total of all active and inactive participants | 2012-01-01 | 6,737 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2012-01-01 | 375 |
| Total participants | 2012-01-01 | 7,112 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2012-01-01 | 9 |
| 2011: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2011 401k membership |
|---|
| Total participants, beginning-of-year | 2011-01-01 | 7,071 |
| Total number of active participants reported on line 7a of the Form 5500 | 2011-01-01 | 2,132 |
| Number of retired or separated participants receiving benefits | 2011-01-01 | 3,209 |
| Number of other retired or separated participants entitled to future benefits | 2011-01-01 | 1,386 |
| Total of all active and inactive participants | 2011-01-01 | 6,727 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2011-01-01 | 317 |
| Total participants | 2011-01-01 | 7,044 |
| Number of participants with account balances | 2011-01-01 | 0 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2011-01-01 | 2 |
| 2009: NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2009 401k membership |
|---|
| Total participants, beginning-of-year | 2009-01-01 | 7,186 |
| Total number of active participants reported on line 7a of the Form 5500 | 2009-01-01 | 2,120 |
| Number of retired or separated participants receiving benefits | 2009-01-01 | 3,163 |
| Number of other retired or separated participants entitled to future benefits | 2009-01-01 | 1,538 |
| Total of all active and inactive participants | 2009-01-01 | 6,821 |
| Number of deceased participants whose beneficiaries are receiving or are entitled to receive benefits | 2009-01-01 | 321 |
| Total participants | 2009-01-01 | 7,142 |
| Number of participants with account balances | 2009-01-01 | 0 |
| Participants that terminated employment during the plan year with accrued benefits that were less than 100% vested | 2009-01-01 | 6 |
| Measure | Date | Value |
|---|
| 2023 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2023 401k financial data |
|---|
| Total unrealized appreciation/depreciation of assets | 2023-12-31 | $0 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2023-12-31 | $1,140,434 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2023-12-31 | $646,141 |
| Total income from all sources (including contributions) | 2023-12-31 | $85,229,015 |
| Total loss/gain on sale of assets | 2023-12-31 | $0 |
| Total of all expenses incurred | 2023-12-31 | $75,974,462 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2023-12-31 | $67,387,731 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2023-12-31 | $0 |
| Value of total assets at end of year | 2023-12-31 | $918,869,880 |
| Value of total assets at beginning of year | 2023-12-31 | $909,121,034 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2023-12-31 | $8,586,731 |
| Total interest from all sources | 2023-12-31 | $0 |
| Total dividends received (eg from common stock, registered investment company shares) | 2023-12-31 | $0 |
| Has a resolution to terminate the plan been adopted during the plan year or any prior plan year | 2023-12-31 | No |
| Was this plan covered by a fidelity bond | 2023-12-31 | Yes |
| Value of fidelity bond cover | 2023-12-31 | $20,000,000 |
| Were there any nonexempt tranactions with any party-in-interest | 2023-12-31 | No |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2023-12-31 | $39,427 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2023-12-31 | $41,205 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2023-12-31 | $343,590 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2023-12-31 | $141,234 |
| Administrative expenses (other) incurred | 2023-12-31 | $5,254,525 |
| Liabilities. Value of operating payables at end of year | 2023-12-31 | $796,844 |
| Liabilities. Value of operating payables at beginning of year | 2023-12-31 | $504,907 |
| Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser | 2023-12-31 | No |
| Value of net income/loss | 2023-12-31 | $9,254,553 |
| Value of net assets at end of year (total assets less liabilities) | 2023-12-31 | $917,729,446 |
| Value of net assets at beginning of year (total assets less liabilities) | 2023-12-31 | $908,474,893 |
| Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond) | 2023-12-31 | No |
| Were any loans by the plan or fixed income obligations due to the plan in default | 2023-12-31 | No |
| Were any leases to which the plan was party in default or uncollectible | 2023-12-31 | No |
| Investment advisory and management fees | 2023-12-31 | $2,474,977 |
| Value of interest in master investment trust accounts at end of year | 2023-12-31 | $918,830,453 |
| Value of interest in master investment trust accounts at beginning of year | 2023-12-31 | $909,079,829 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2023-12-31 | No |
| Was there a failure to transmit to the plan any participant contributions | 2023-12-31 | No |
| Has the plan failed to provide any benefit when due under the plan | 2023-12-31 | No |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2023-12-31 | $67,387,731 |
| Did the plan have assets held for investment | 2023-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 | 2023-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 | 2023-12-31 | No |
| Opinion of an independent qualified public accountant for this plan | 2023-12-31 | Unqualified |
| Accountancy firm name | 2023-12-31 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2023-12-31 | 133891517 |
| 2022 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 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 | $646,141 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2022-12-31 | $834,496 |
| Total income from all sources (including contributions) | 2022-12-31 | $-238,333,640 |
| Total loss/gain on sale of assets | 2022-12-31 | $0 |
| Total of all expenses incurred | 2022-12-31 | $71,124,904 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2022-12-31 | $67,268,651 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2022-12-31 | $0 |
| Value of total assets at end of year | 2022-12-31 | $909,121,034 |
| Value of total assets at beginning of year | 2022-12-31 | $1,218,767,933 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2022-12-31 | $3,856,253 |
| 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 |
| Administrative expenses professional fees incurred | 2022-12-31 | $1,009,378 |
| Was this plan covered by a fidelity bond | 2022-12-31 | Yes |
| Value of fidelity bond cover | 2022-12-31 | $20,000,000 |
| Were there any nonexempt tranactions with any party-in-interest | 2022-12-31 | No |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2022-12-31 | $41,205 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2022-12-31 | $141,234 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2022-12-31 | $64,238 |
| Administrative expenses (other) incurred | 2022-12-31 | $677,434 |
| Liabilities. Value of operating payables at end of year | 2022-12-31 | $504,907 |
| Liabilities. Value of operating payables at beginning of year | 2022-12-31 | $770,258 |
| 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 | $-309,458,544 |
| Value of net assets at end of year (total assets less liabilities) | 2022-12-31 | $908,474,893 |
| Value of net assets at beginning of year (total assets less liabilities) | 2022-12-31 | $1,217,933,437 |
| 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 |
| Investment advisory and management fees | 2022-12-31 | $2,169,441 |
| Value of interest in master investment trust accounts at end of year | 2022-12-31 | $909,079,829 |
| Value of interest in master investment trust accounts at beginning of year | 2022-12-31 | $1,178,767,933 |
| 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 |
| Employer contributions (assets) at end of year | 2022-12-31 | $0 |
| Employer contributions (assets) at beginning of year | 2022-12-31 | $40,000,000 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2022-12-31 | $67,268,651 |
| 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 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2022-12-31 | 133891517 |
| 2021 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 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 | $834,496 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2021-12-31 | $740,122 |
| Total income from all sources (including contributions) | 2021-12-31 | $133,724,434 |
| Total loss/gain on sale of assets | 2021-12-31 | $0 |
| Total of all expenses incurred | 2021-12-31 | $69,706,311 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2021-12-31 | $66,972,905 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2021-12-31 | $40,000,000 |
| Value of total assets at end of year | 2021-12-31 | $1,218,767,933 |
| Value of total assets at beginning of year | 2021-12-31 | $1,154,655,436 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2021-12-31 | $2,733,406 |
| 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 |
| Administrative expenses professional fees incurred | 2021-12-31 | $1,064,266 |
| Was this plan covered by a fidelity bond | 2021-12-31 | Yes |
| Value of fidelity bond cover | 2021-12-31 | $20,000,000 |
| 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 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2021-12-31 | $64,238 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2021-12-31 | $0 |
| Liabilities. Value of operating payables at end of year | 2021-12-31 | $770,258 |
| Liabilities. Value of operating payables at beginning of year | 2021-12-31 | $740,122 |
| 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 | $64,018,123 |
| Value of net assets at end of year (total assets less liabilities) | 2021-12-31 | $1,217,933,437 |
| Value of net assets at beginning of year (total assets less liabilities) | 2021-12-31 | $1,153,915,314 |
| 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 |
| Investment advisory and management fees | 2021-12-31 | $1,669,140 |
| Value of interest in master investment trust accounts at end of year | 2021-12-31 | $1,178,767,933 |
| Value of interest in master investment trust accounts at beginning of year | 2021-12-31 | $1,118,655,436 |
| 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 | $40,000,000 |
| Employer contributions (assets) at end of year | 2021-12-31 | $40,000,000 |
| Employer contributions (assets) at beginning of year | 2021-12-31 | $36,000,000 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2021-12-31 | $66,972,905 |
| 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 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2021-12-31 | 133891517 |
| 2020 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 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 | $740,122 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2020-12-31 | $716,243 |
| Total income from all sources (including contributions) | 2020-12-31 | $178,437,451 |
| Total loss/gain on sale of assets | 2020-12-31 | $0 |
| Total of all expenses incurred | 2020-12-31 | $72,175,159 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2020-12-31 | $66,918,793 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2020-12-31 | $0 |
| Value of total assets at end of year | 2020-12-31 | $1,154,655,436 |
| Value of total assets at beginning of year | 2020-12-31 | $1,048,369,265 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2020-12-31 | $5,256,366 |
| 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 |
| Administrative expenses professional fees incurred | 2020-12-31 | $882,401 |
| Was this plan covered by a fidelity bond | 2020-12-31 | Yes |
| Value of fidelity bond cover | 2020-12-31 | $20,000,000 |
| 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 | $2,134,195 |
| Liabilities. Value of operating payables at end of year | 2020-12-31 | $740,122 |
| Liabilities. Value of operating payables at beginning of year | 2020-12-31 | $716,243 |
| 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 | $106,262,292 |
| Value of net assets at end of year (total assets less liabilities) | 2020-12-31 | $1,153,915,314 |
| Value of net assets at beginning of year (total assets less liabilities) | 2020-12-31 | $1,047,653,022 |
| 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 |
| Investment advisory and management fees | 2020-12-31 | $2,239,770 |
| Value of interest in master investment trust accounts at end of year | 2020-12-31 | $1,118,655,436 |
| Value of interest in master investment trust accounts at beginning of year | 2020-12-31 | $972,369,265 |
| 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 |
| Employer contributions (assets) at end of year | 2020-12-31 | $36,000,000 |
| Employer contributions (assets) at beginning of year | 2020-12-31 | $76,000,000 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2020-12-31 | $66,918,793 |
| 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 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2020-12-31 | 133891517 |
| 2019 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 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 | $716,243 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2019-12-31 | $663,642 |
| Total income from all sources (including contributions) | 2019-12-31 | $219,553,466 |
| Total loss/gain on sale of assets | 2019-12-31 | $0 |
| Total of all expenses incurred | 2019-12-31 | $73,189,184 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2019-12-31 | $65,683,000 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2019-12-31 | $40,023,854 |
| Value of total assets at end of year | 2019-12-31 | $1,012,369,265 |
| Value of total assets at beginning of year | 2019-12-31 | $865,952,382 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2019-12-31 | $7,506,184 |
| 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 |
| Administrative expenses professional fees incurred | 2019-12-31 | $1,059,239 |
| Was this plan covered by a fidelity bond | 2019-12-31 | Yes |
| Value of fidelity bond cover | 2019-12-31 | $20,000,000 |
| 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 | $4,056,959 |
| Liabilities. Value of operating payables at end of year | 2019-12-31 | $716,243 |
| Liabilities. Value of operating payables at beginning of year | 2019-12-31 | $663,642 |
| 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 | $146,364,282 |
| Value of net assets at end of year (total assets less liabilities) | 2019-12-31 | $1,011,653,022 |
| Value of net assets at beginning of year (total assets less liabilities) | 2019-12-31 | $865,288,740 |
| 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 |
| Investment advisory and management fees | 2019-12-31 | $2,389,986 |
| Value of interest in master investment trust accounts at end of year | 2019-12-31 | $972,369,265 |
| Value of interest in master investment trust accounts at beginning of year | 2019-12-31 | $825,952,382 |
| 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 | $40,023,854 |
| Employer contributions (assets) at end of year | 2019-12-31 | $40,000,000 |
| Employer contributions (assets) at beginning of year | 2019-12-31 | $40,000,000 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2019-12-31 | $65,683,000 |
| 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 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2019-12-31 | 133891517 |
| 2018 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 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 | $663,642 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2018-12-31 | $800,815 |
| Total income from all sources (including contributions) | 2018-12-31 | $3,454,863 |
| Total loss/gain on sale of assets | 2018-12-31 | $0 |
| Total of all expenses incurred | 2018-12-31 | $72,510,932 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2018-12-31 | $65,082,299 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2018-12-31 | $40,000,000 |
| Value of total assets at end of year | 2018-12-31 | $865,952,382 |
| Value of total assets at beginning of year | 2018-12-31 | $935,145,624 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2018-12-31 | $7,428,633 |
| 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 |
| Administrative expenses professional fees incurred | 2018-12-31 | $1,104,162 |
| Was this plan covered by a fidelity bond | 2018-12-31 | Yes |
| Value of fidelity bond cover | 2018-12-31 | $20,000,000 |
| 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 | $3,920,757 |
| Liabilities. Value of operating payables at end of year | 2018-12-31 | $663,642 |
| Liabilities. Value of operating payables at beginning of year | 2018-12-31 | $800,815 |
| 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 | $-69,056,069 |
| Value of net assets at end of year (total assets less liabilities) | 2018-12-31 | $865,288,740 |
| Value of net assets at beginning of year (total assets less liabilities) | 2018-12-31 | $934,344,809 |
| 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 |
| Investment advisory and management fees | 2018-12-31 | $2,403,714 |
| Value of interest in master investment trust accounts at end of year | 2018-12-31 | $825,952,382 |
| Value of interest in master investment trust accounts at beginning of year | 2018-12-31 | $920,145,624 |
| 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 | $40,000,000 |
| Employer contributions (assets) at end of year | 2018-12-31 | $40,000,000 |
| Employer contributions (assets) at beginning of year | 2018-12-31 | $15,000,000 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2018-12-31 | $65,082,299 |
| 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 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2018-12-31 | 133891517 |
| 2017 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2017 401k financial data |
|---|
| Total unrealized appreciation/depreciation of assets | 2017-12-31 | $0 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2017-12-31 | $800,815 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2017-12-31 | $1,126,059 |
| Total income from all sources (including contributions) | 2017-12-31 | $138,355,633 |
| Total loss/gain on sale of assets | 2017-12-31 | $0 |
| Total of all expenses incurred | 2017-12-31 | $70,459,797 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2017-12-31 | $63,413,239 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2017-12-31 | $15,021,934 |
| Value of total assets at end of year | 2017-12-31 | $935,145,624 |
| Value of total assets at beginning of year | 2017-12-31 | $867,575,032 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2017-12-31 | $7,046,558 |
| Total interest from all sources | 2017-12-31 | $0 |
| Total dividends received (eg from common stock, registered investment company shares) | 2017-12-31 | $0 |
| Has a resolution to terminate the plan been adopted during the plan year or any prior plan year | 2017-12-31 | No |
| Administrative expenses professional fees incurred | 2017-12-31 | $888,468 |
| Was this plan covered by a fidelity bond | 2017-12-31 | Yes |
| Value of fidelity bond cover | 2017-12-31 | $20,000,000 |
| Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities | 2017-12-31 | $0 |
| Were there any nonexempt tranactions with any party-in-interest | 2017-12-31 | No |
| Administrative expenses (other) incurred | 2017-12-31 | $3,896,485 |
| Liabilities. Value of operating payables at end of year | 2017-12-31 | $800,815 |
| Liabilities. Value of operating payables at beginning of year | 2017-12-31 | $1,126,059 |
| Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser | 2017-12-31 | No |
| Value of net income/loss | 2017-12-31 | $67,895,836 |
| Value of net assets at end of year (total assets less liabilities) | 2017-12-31 | $934,344,809 |
| Value of net assets at beginning of year (total assets less liabilities) | 2017-12-31 | $866,448,973 |
| Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond) | 2017-12-31 | No |
| Were any loans by the plan or fixed income obligations due to the plan in default | 2017-12-31 | No |
| Were any leases to which the plan was party in default or uncollectible | 2017-12-31 | No |
| Investment advisory and management fees | 2017-12-31 | $2,261,605 |
| Value of interest in master investment trust accounts at end of year | 2017-12-31 | $920,145,624 |
| Value of interest in master investment trust accounts at beginning of year | 2017-12-31 | $857,575,032 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2017-12-31 | No |
| Was there a failure to transmit to the plan any participant contributions | 2017-12-31 | No |
| Has the plan failed to provide any benefit when due under the plan | 2017-12-31 | No |
| Contributions received in cash from employer | 2017-12-31 | $15,021,934 |
| Employer contributions (assets) at end of year | 2017-12-31 | $15,000,000 |
| Employer contributions (assets) at beginning of year | 2017-12-31 | $10,000,000 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2017-12-31 | $63,413,239 |
| Did the plan have assets held for investment | 2017-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 | 2017-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 | 2017-12-31 | No |
| Accountant perfomed limited scope audit pursuant to 29 CFR 2520.103-8 and/or 103-12(d) | 2017-12-31 | Yes |
| Opinion of an independent qualified public accountant for this plan | 2017-12-31 | Disclaimer |
| Accountancy firm name | 2017-12-31 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2017-12-31 | 133891517 |
| 2016 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2016 401k financial data |
|---|
| Total unrealized appreciation/depreciation of assets | 2016-12-31 | $0 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2016-12-31 | $1,126,059 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2016-12-31 | $995,835 |
| Total income from all sources (including contributions) | 2016-12-31 | $64,054,790 |
| Total loss/gain on sale of assets | 2016-12-31 | $0 |
| Total of all expenses incurred | 2016-12-31 | $89,241,991 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2016-12-31 | $81,467,418 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2016-12-31 | $10,038,776 |
| Value of total assets at end of year | 2016-12-31 | $867,575,032 |
| Value of total assets at beginning of year | 2016-12-31 | $892,632,009 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2016-12-31 | $7,774,573 |
| Total interest from all sources | 2016-12-31 | $0 |
| Total dividends received (eg from common stock, registered investment company shares) | 2016-12-31 | $0 |
| Has a resolution to terminate the plan been adopted during the plan year or any prior plan year | 2016-12-31 | No |
| Administrative expenses professional fees incurred | 2016-12-31 | $1,336,291 |
| Was this plan covered by a fidelity bond | 2016-12-31 | Yes |
| Value of fidelity bond cover | 2016-12-31 | $20,000,000 |
| Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities | 2016-12-31 | $0 |
| Were there any nonexempt tranactions with any party-in-interest | 2016-12-31 | No |
| Administrative expenses (other) incurred | 2016-12-31 | $3,886,509 |
| Liabilities. Value of operating payables at end of year | 2016-12-31 | $1,126,059 |
| Liabilities. Value of operating payables at beginning of year | 2016-12-31 | $995,835 |
| Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser | 2016-12-31 | No |
| Value of net income/loss | 2016-12-31 | $-25,187,201 |
| Value of net assets at end of year (total assets less liabilities) | 2016-12-31 | $866,448,973 |
| Value of net assets at beginning of year (total assets less liabilities) | 2016-12-31 | $891,636,174 |
| Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond) | 2016-12-31 | No |
| Were any loans by the plan or fixed income obligations due to the plan in default | 2016-12-31 | No |
| Were any leases to which the plan was party in default or uncollectible | 2016-12-31 | No |
| Investment advisory and management fees | 2016-12-31 | $2,551,773 |
| Value of interest in master investment trust accounts at end of year | 2016-12-31 | $857,575,032 |
| Value of interest in master investment trust accounts at beginning of year | 2016-12-31 | $882,632,009 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2016-12-31 | No |
| Was there a failure to transmit to the plan any participant contributions | 2016-12-31 | No |
| Has the plan failed to provide any benefit when due under the plan | 2016-12-31 | No |
| Contributions received in cash from employer | 2016-12-31 | $10,038,776 |
| Employer contributions (assets) at end of year | 2016-12-31 | $10,000,000 |
| Employer contributions (assets) at beginning of year | 2016-12-31 | $10,000,000 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2016-12-31 | $81,467,418 |
| Did the plan have assets held for investment | 2016-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 | 2016-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 | 2016-12-31 | No |
| Accountant perfomed limited scope audit pursuant to 29 CFR 2520.103-8 and/or 103-12(d) | 2016-12-31 | Yes |
| Opinion of an independent qualified public accountant for this plan | 2016-12-31 | Disclaimer |
| Accountancy firm name | 2016-12-31 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2016-12-31 | 133891517 |
| 2015 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2015 401k financial data |
|---|
| Total unrealized appreciation/depreciation of assets | 2015-12-31 | $0 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2015-12-31 | $995,835 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2015-12-31 | $663,412 |
| Total income from all sources (including contributions) | 2015-12-31 | $6,690,688 |
| Total loss/gain on sale of assets | 2015-12-31 | $0 |
| Total of all expenses incurred | 2015-12-31 | $65,118,824 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2015-12-31 | $58,447,418 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2015-12-31 | $10,011,968 |
| Value of total assets at end of year | 2015-12-31 | $892,632,009 |
| Value of total assets at beginning of year | 2015-12-31 | $950,727,722 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2015-12-31 | $6,671,406 |
| Total interest from all sources | 2015-12-31 | $0 |
| Total dividends received (eg from common stock, registered investment company shares) | 2015-12-31 | $0 |
| Has a resolution to terminate the plan been adopted during the plan year or any prior plan year | 2015-12-31 | No |
| Administrative expenses professional fees incurred | 2015-12-31 | $1,091,798 |
| Was this plan covered by a fidelity bond | 2015-12-31 | Yes |
| Value of fidelity bond cover | 2015-12-31 | $20,000,000 |
| Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities | 2015-12-31 | $0 |
| Were there any nonexempt tranactions with any party-in-interest | 2015-12-31 | No |
| Administrative expenses (other) incurred | 2015-12-31 | $2,425,885 |
| Liabilities. Value of operating payables at end of year | 2015-12-31 | $995,835 |
| Liabilities. Value of operating payables at beginning of year | 2015-12-31 | $663,412 |
| Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser | 2015-12-31 | No |
| Value of net income/loss | 2015-12-31 | $-58,428,136 |
| Value of net assets at end of year (total assets less liabilities) | 2015-12-31 | $891,636,174 |
| Value of net assets at beginning of year (total assets less liabilities) | 2015-12-31 | $950,064,310 |
| Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond) | 2015-12-31 | No |
| Were any loans by the plan or fixed income obligations due to the plan in default | 2015-12-31 | No |
| Were any leases to which the plan was party in default or uncollectible | 2015-12-31 | No |
| Investment advisory and management fees | 2015-12-31 | $3,153,723 |
| Value of interest in master investment trust accounts at end of year | 2015-12-31 | $882,632,009 |
| Value of interest in master investment trust accounts at beginning of year | 2015-12-31 | $940,727,722 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2015-12-31 | No |
| Was there a failure to transmit to the plan any participant contributions | 2015-12-31 | No |
| Has the plan failed to provide any benefit when due under the plan | 2015-12-31 | No |
| Contributions received in cash from employer | 2015-12-31 | $10,011,968 |
| Employer contributions (assets) at end of year | 2015-12-31 | $10,000,000 |
| Employer contributions (assets) at beginning of year | 2015-12-31 | $10,000,000 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2015-12-31 | $58,447,418 |
| Did the plan have assets held for investment | 2015-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 | 2015-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 | 2015-12-31 | No |
| Accountant perfomed limited scope audit pursuant to 29 CFR 2520.103-8 and/or 103-12(d) | 2015-12-31 | Yes |
| Opinion of an independent qualified public accountant for this plan | 2015-12-31 | Disclaimer |
| Accountancy firm name | 2015-12-31 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2015-12-31 | 133891517 |
| 2014 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2014 401k financial data |
|---|
| Total unrealized appreciation/depreciation of assets | 2014-12-31 | $0 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2014-12-31 | $663,412 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2014-12-31 | $594,475 |
| Total income from all sources (including contributions) | 2014-12-31 | $89,379,757 |
| Total loss/gain on sale of assets | 2014-12-31 | $0 |
| Total of all expenses incurred | 2014-12-31 | $62,860,435 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2014-12-31 | $56,778,540 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2014-12-31 | $10,086,076 |
| Value of total assets at end of year | 2014-12-31 | $950,727,722 |
| Value of total assets at beginning of year | 2014-12-31 | $924,139,463 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2014-12-31 | $6,081,895 |
| Total interest from all sources | 2014-12-31 | $0 |
| Total dividends received (eg from common stock, registered investment company shares) | 2014-12-31 | $0 |
| Has a resolution to terminate the plan been adopted during the plan year or any prior plan year | 2014-12-31 | No |
| Administrative expenses professional fees incurred | 2014-12-31 | $952,830 |
| Was this plan covered by a fidelity bond | 2014-12-31 | Yes |
| Value of fidelity bond cover | 2014-12-31 | $20,000,000 |
| Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities | 2014-12-31 | $0 |
| Were there any nonexempt tranactions with any party-in-interest | 2014-12-31 | No |
| Administrative expenses (other) incurred | 2014-12-31 | $800,391 |
| Liabilities. Value of operating payables at end of year | 2014-12-31 | $663,412 |
| Liabilities. Value of operating payables at beginning of year | 2014-12-31 | $594,475 |
| Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser | 2014-12-31 | No |
| Value of net income/loss | 2014-12-31 | $26,519,322 |
| Value of net assets at end of year (total assets less liabilities) | 2014-12-31 | $950,064,310 |
| Value of net assets at beginning of year (total assets less liabilities) | 2014-12-31 | $923,544,988 |
| Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond) | 2014-12-31 | No |
| Were any loans by the plan or fixed income obligations due to the plan in default | 2014-12-31 | No |
| Were any leases to which the plan was party in default or uncollectible | 2014-12-31 | No |
| Investment advisory and management fees | 2014-12-31 | $4,328,674 |
| Value of interest in master investment trust accounts at end of year | 2014-12-31 | $940,727,722 |
| Value of interest in master investment trust accounts at beginning of year | 2014-12-31 | $899,139,463 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2014-12-31 | No |
| Was there a failure to transmit to the plan any participant contributions | 2014-12-31 | No |
| Has the plan failed to provide any benefit when due under the plan | 2014-12-31 | No |
| Contributions received in cash from employer | 2014-12-31 | $10,086,076 |
| Employer contributions (assets) at end of year | 2014-12-31 | $10,000,000 |
| Employer contributions (assets) at beginning of year | 2014-12-31 | $25,000,000 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2014-12-31 | $56,778,540 |
| Did the plan have assets held for investment | 2014-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 | 2014-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 | 2014-12-31 | No |
| Accountant perfomed limited scope audit pursuant to 29 CFR 2520.103-8 and/or 103-12(d) | 2014-12-31 | Yes |
| Opinion of an independent qualified public accountant for this plan | 2014-12-31 | Disclaimer |
| Accountancy firm name | 2014-12-31 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2014-12-31 | 133891517 |
| 2013 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2013 401k financial data |
|---|
| Total unrealized appreciation/depreciation of assets | 2013-12-31 | $0 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2013-12-31 | $594,475 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2013-12-31 | $673,148 |
| Total income from all sources (including contributions) | 2013-12-31 | $51,207,818 |
| Total loss/gain on sale of assets | 2013-12-31 | $0 |
| Total of all expenses incurred | 2013-12-31 | $60,984,353 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2013-12-31 | $55,749,506 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2013-12-31 | $25,162,894 |
| Value of total assets at end of year | 2013-12-31 | $924,139,463 |
| Value of total assets at beginning of year | 2013-12-31 | $933,994,671 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2013-12-31 | $5,234,847 |
| Total interest from all sources | 2013-12-31 | $0 |
| Total dividends received (eg from common stock, registered investment company shares) | 2013-12-31 | $0 |
| Has a resolution to terminate the plan been adopted during the plan year or any prior plan year | 2013-12-31 | No |
| Administrative expenses professional fees incurred | 2013-12-31 | $907,530 |
| Was this plan covered by a fidelity bond | 2013-12-31 | Yes |
| Value of fidelity bond cover | 2013-12-31 | $20,000,000 |
| Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities | 2013-12-31 | $0 |
| Were there any nonexempt tranactions with any party-in-interest | 2013-12-31 | No |
| Administrative expenses (other) incurred | 2013-12-31 | $382,184 |
| Liabilities. Value of operating payables at end of year | 2013-12-31 | $594,475 |
| Liabilities. Value of operating payables at beginning of year | 2013-12-31 | $673,148 |
| Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser | 2013-12-31 | No |
| Value of net income/loss | 2013-12-31 | $-9,776,535 |
| Value of net assets at end of year (total assets less liabilities) | 2013-12-31 | $923,544,988 |
| Value of net assets at beginning of year (total assets less liabilities) | 2013-12-31 | $933,321,523 |
| Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond) | 2013-12-31 | No |
| Were any loans by the plan or fixed income obligations due to the plan in default | 2013-12-31 | No |
| Were any leases to which the plan was party in default or uncollectible | 2013-12-31 | No |
| Investment advisory and management fees | 2013-12-31 | $3,945,133 |
| Value of interest in master investment trust accounts at end of year | 2013-12-31 | $899,139,463 |
| Value of interest in master investment trust accounts at beginning of year | 2013-12-31 | $903,887,090 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2013-12-31 | No |
| Was there a failure to transmit to the plan any participant contributions | 2013-12-31 | No |
| Has the plan failed to provide any benefit when due under the plan | 2013-12-31 | No |
| Contributions received in cash from employer | 2013-12-31 | $25,162,894 |
| Employer contributions (assets) at end of year | 2013-12-31 | $25,000,000 |
| Employer contributions (assets) at beginning of year | 2013-12-31 | $30,107,581 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2013-12-31 | $55,749,506 |
| Did the plan have assets held for investment | 2013-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 | 2013-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 | 2013-12-31 | No |
| Accountant perfomed limited scope audit pursuant to 29 CFR 2520.103-8 and/or 103-12(d) | 2013-12-31 | Yes |
| Opinion of an independent qualified public accountant for this plan | 2013-12-31 | Disclaimer |
| Accountancy firm name | 2013-12-31 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2013-12-31 | 133891517 |
| 2012 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2012 401k financial data |
|---|
| Total unrealized appreciation/depreciation of assets | 2012-12-31 | $0 |
| Total transfer of assets to this plan | 2012-12-31 | $2,171,201 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2012-12-31 | $673,148 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2012-12-31 | $920,975 |
| Total income from all sources (including contributions) | 2012-12-31 | $128,038,196 |
| Total loss/gain on sale of assets | 2012-12-31 | $0 |
| Total of all expenses incurred | 2012-12-31 | $57,433,367 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2012-12-31 | $52,514,471 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2012-12-31 | $30,346,062 |
| Value of total assets at end of year | 2012-12-31 | $933,994,671 |
| Value of total assets at beginning of year | 2012-12-31 | $861,466,468 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2012-12-31 | $4,918,896 |
| Total interest from all sources | 2012-12-31 | $0 |
| Total dividends received (eg from common stock, registered investment company shares) | 2012-12-31 | $0 |
| Has a resolution to terminate the plan been adopted during the plan year or any prior plan year | 2012-12-31 | No |
| Administrative expenses professional fees incurred | 2012-12-31 | $720,637 |
| Was this plan covered by a fidelity bond | 2012-12-31 | Yes |
| Value of fidelity bond cover | 2012-12-31 | $20,000,000 |
| Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities | 2012-12-31 | $0 |
| Were there any nonexempt tranactions with any party-in-interest | 2012-12-31 | No |
| Administrative expenses (other) incurred | 2012-12-31 | $282,666 |
| Liabilities. Value of operating payables at end of year | 2012-12-31 | $673,148 |
| Liabilities. Value of operating payables at beginning of year | 2012-12-31 | $920,975 |
| Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser | 2012-12-31 | No |
| Value of net income/loss | 2012-12-31 | $70,604,829 |
| Value of net assets at end of year (total assets less liabilities) | 2012-12-31 | $933,321,523 |
| Value of net assets at beginning of year (total assets less liabilities) | 2012-12-31 | $860,545,493 |
| Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond) | 2012-12-31 | No |
| Were any loans by the plan or fixed income obligations due to the plan in default | 2012-12-31 | No |
| Were any leases to which the plan was party in default or uncollectible | 2012-12-31 | No |
| Investment advisory and management fees | 2012-12-31 | $3,915,593 |
| Value of interest in master investment trust accounts at end of year | 2012-12-31 | $903,887,090 |
| Value of interest in master investment trust accounts at beginning of year | 2012-12-31 | $836,466,468 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2012-12-31 | No |
| Was there a failure to transmit to the plan any participant contributions | 2012-12-31 | No |
| Has the plan failed to provide any benefit when due under the plan | 2012-12-31 | No |
| Contributions received in cash from employer | 2012-12-31 | $30,346,062 |
| Employer contributions (assets) at end of year | 2012-12-31 | $30,107,581 |
| Employer contributions (assets) at beginning of year | 2012-12-31 | $25,000,000 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2012-12-31 | $52,514,471 |
| Did the plan have assets held for investment | 2012-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 | 2012-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 | 2012-12-31 | No |
| Accountant perfomed limited scope audit pursuant to 29 CFR 2520.103-8 and/or 103-12(d) | 2012-12-31 | Yes |
| Opinion of an independent qualified public accountant for this plan | 2012-12-31 | Disclaimer |
| Accountancy firm name | 2012-12-31 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2012-12-31 | 133891517 |
| 2011 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2011 401k financial data |
|---|
| Total unrealized appreciation/depreciation of assets | 2011-12-31 | $0 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2011-12-31 | $920,975 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2011-12-31 | $814,385 |
| Total income from all sources (including contributions) | 2011-12-31 | $142,893,670 |
| Total loss/gain on sale of assets | 2011-12-31 | $0 |
| Total of all expenses incurred | 2011-12-31 | $54,259,276 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2011-12-31 | $49,703,000 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2011-12-31 | $25,000,000 |
| Value of total assets at end of year | 2011-12-31 | $861,466,468 |
| Value of total assets at beginning of year | 2011-12-31 | $772,725,484 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2011-12-31 | $4,556,276 |
| Total interest from all sources | 2011-12-31 | $0 |
| Total dividends received (eg from common stock, registered investment company shares) | 2011-12-31 | $0 |
| Has a resolution to terminate the plan been adopted during the plan year or any prior plan year | 2011-12-31 | No |
| Administrative expenses professional fees incurred | 2011-12-31 | $1,392,783 |
| Was this plan covered by a fidelity bond | 2011-12-31 | Yes |
| Value of fidelity bond cover | 2011-12-31 | $20,000,000 |
| Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities | 2011-12-31 | $0 |
| Were there any nonexempt tranactions with any party-in-interest | 2011-12-31 | No |
| Administrative expenses (other) incurred | 2011-12-31 | $303,015 |
| Liabilities. Value of operating payables at end of year | 2011-12-31 | $920,975 |
| Liabilities. Value of operating payables at beginning of year | 2011-12-31 | $814,385 |
| Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser | 2011-12-31 | No |
| Value of net income/loss | 2011-12-31 | $88,634,394 |
| Value of net assets at end of year (total assets less liabilities) | 2011-12-31 | $860,545,493 |
| Value of net assets at beginning of year (total assets less liabilities) | 2011-12-31 | $771,911,099 |
| Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond) | 2011-12-31 | No |
| Were any loans by the plan or fixed income obligations due to the plan in default | 2011-12-31 | No |
| Were any leases to which the plan was party in default or uncollectible | 2011-12-31 | No |
| Investment advisory and management fees | 2011-12-31 | $2,860,478 |
| Value of interest in master investment trust accounts at end of year | 2011-12-31 | $836,466,468 |
| Value of interest in master investment trust accounts at beginning of year | 2011-12-31 | $722,725,484 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2011-12-31 | No |
| Was there a failure to transmit to the plan any participant contributions | 2011-12-31 | No |
| Has the plan failed to provide any benefit when due under the plan | 2011-12-31 | No |
| Contributions received in cash from employer | 2011-12-31 | $25,000,000 |
| Employer contributions (assets) at end of year | 2011-12-31 | $25,000,000 |
| Employer contributions (assets) at beginning of year | 2011-12-31 | $50,000,000 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2011-12-31 | $49,703,000 |
| Did the plan have assets held for investment | 2011-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 | 2011-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 | 2011-12-31 | No |
| Accountant perfomed limited scope audit pursuant to 29 CFR 2520.103-8 and/or 103-12(d) | 2011-12-31 | Yes |
| Opinion of an independent qualified public accountant for this plan | 2011-12-31 | Disclaimer |
| Accountancy firm name | 2011-12-31 | DELOITTE & TOUCHE LLP |
| Accountancy firm EIN | 2011-12-31 | 133891517 |
| 2010 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2010 401k financial data |
|---|
| Total unrealized appreciation/depreciation of assets | 2010-12-31 | $0 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2010-12-31 | $814,385 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2010-12-31 | $839,110 |
| Total income from all sources (including contributions) | 2010-12-31 | $134,887,766 |
| Total loss/gain on sale of assets | 2010-12-31 | $0 |
| Total of all expenses incurred | 2010-12-31 | $54,050,795 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2010-12-31 | $48,759,093 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2010-12-31 | $50,000,000 |
| Value of total assets at end of year | 2010-12-31 | $772,725,484 |
| Value of total assets at beginning of year | 2010-12-31 | $691,913,238 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2010-12-31 | $5,291,702 |
| Total interest from all sources | 2010-12-31 | $0 |
| Total dividends received (eg from common stock, registered investment company shares) | 2010-12-31 | $0 |
| Has a resolution to terminate the plan been adopted during the plan year or any prior plan year | 2010-12-31 | No |
| Administrative expenses professional fees incurred | 2010-12-31 | $2,998,978 |
| Was this plan covered by a fidelity bond | 2010-12-31 | Yes |
| Value of fidelity bond cover | 2010-12-31 | $20,000,000 |
| Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities | 2010-12-31 | $0 |
| Were there any nonexempt tranactions with any party-in-interest | 2010-12-31 | No |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2010-12-31 | $0 |
| Administrative expenses (other) incurred | 2010-12-31 | $542,641 |
| Liabilities. Value of operating payables at end of year | 2010-12-31 | $814,385 |
| Liabilities. Value of operating payables at beginning of year | 2010-12-31 | $839,110 |
| Total non interest bearing cash at end of year | 2010-12-31 | $0 |
| Total non interest bearing cash at beginning of year | 2010-12-31 | $511 |
| Did the receive any noncash contributions whose value was neither redily determinable on an established market nor set by an independent third party appraiser | 2010-12-31 | No |
| Value of net income/loss | 2010-12-31 | $80,836,971 |
| Value of net assets at end of year (total assets less liabilities) | 2010-12-31 | $771,911,099 |
| Value of net assets at beginning of year (total assets less liabilities) | 2010-12-31 | $691,074,128 |
| Did the plan have a loss casued by fraud or dishonesty (regardless whether reimbursed by fidelity bond) | 2010-12-31 | No |
| Were any loans by the plan or fixed income obligations due to the plan in default | 2010-12-31 | No |
| Were any leases to which the plan was party in default or uncollectible | 2010-12-31 | No |
| Investment advisory and management fees | 2010-12-31 | $1,750,083 |
| Value of interest in master investment trust accounts at end of year | 2010-12-31 | $722,725,484 |
| Value of interest in master investment trust accounts at beginning of year | 2010-12-31 | $691,912,727 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2010-12-31 | $0 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2010-12-31 | $0 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2010-12-31 | No |
| Was there a failure to transmit to the plan any participant contributions | 2010-12-31 | No |
| Has the plan failed to provide any benefit when due under the plan | 2010-12-31 | No |
| Contributions received in cash from employer | 2010-12-31 | $50,000,000 |
| Employer contributions (assets) at end of year | 2010-12-31 | $50,000,000 |
| Employer contributions (assets) at beginning of year | 2010-12-31 | $0 |
| Benefit payments and payments to provide benefits directly to participlants or beneficiaries including direct rollovers | 2010-12-31 | $48,759,093 |
| Did the plan have assets held for investment | 2010-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 | 2010-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 | 2010-12-31 | No |
| Accountant perfomed limited scope audit pursuant to 29 CFR 2520.103-8 and/or 103-12(d) | 2010-12-31 | Yes |
| Opinion of an independent qualified public accountant for this plan | 2010-12-31 | Disclaimer |
| Accountancy firm name | 2010-12-31 | DELOITTE AND TOUCHE LLP |
| Accountancy firm EIN | 2010-12-31 | 133891517 |
| 2009 : NEW CENTURY ENERGIES INC RETIREMENT PLAN FOR PUBLIC SERVICE COMPANY OF COLORADO BARGAINING UNIT EES AND FORMER NON-BARGAINING UNIT EES 2009 401k financial data |
|---|
| Total value of distributions paid in property other than in cash, annuity contracts, or publicly traded employer securities | 2009-12-31 | $0 |
