XCEL ENERGY INC has sponsored the creation of one or more 401k plans.
Submission information for form 5500 for 401k plan XCEL ENERGY INC. MASTER PENSION TRUST
| Measure | Date | Value |
|---|
| 2022 : XCEL ENERGY INC. MASTER PENSION TRUST 2022 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2022-12-31 | $-271,869,717 |
| Total unrealized appreciation/depreciation of assets | 2022-12-31 | $-271,869,717 |
| Total transfer of assets to this plan | 2022-12-31 | $50,000,000 |
| Total transfer of assets from this plan | 2022-12-31 | $365,369,051 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2022-12-31 | $2,645,597 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2022-12-31 | $1,738,497 |
| Total income from all sources (including contributions) | 2022-12-31 | $-670,429,688 |
| Total loss/gain on sale of assets | 2022-12-31 | $-131,456,595 |
| Total of all expenses incurred | 2022-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2022-12-31 | $0 |
| 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 | $2,686,859,729 |
| Value of total assets at beginning of year | 2022-12-31 | $3,671,751,368 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2022-12-31 | $0 |
| Total interest from all sources | 2022-12-31 | $31,287,813 |
| Total dividends received (eg from common stock, registered investment company shares) | 2022-12-31 | $807,029 |
| Assets. Corporate prefeered stocks other than exployer securities at end of year | 2022-12-31 | $890 |
| Assets. Corporate prefeered stocks other than exployer securities at beginning of year | 2022-12-31 | $35,421 |
| 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 | $9,100,098 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2022-12-31 | $40,819,559 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2022-12-31 | $424,841 |
| Other income not declared elsewhere | 2022-12-31 | $24,430,560 |
| Total non interest bearing cash at end of year | 2022-12-31 | $14,247 |
| Total non interest bearing cash at beginning of year | 2022-12-31 | $18,061,761 |
| Value of net income/loss | 2022-12-31 | $-670,429,688 |
| Value of net assets at end of year (total assets less liabilities) | 2022-12-31 | $2,684,214,132 |
| Value of net assets at beginning of year (total assets less liabilities) | 2022-12-31 | $3,670,012,871 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2022-12-31 | $666,622,806 |
| Assets. partnership/joint venture interests at beginning of year | 2022-12-31 | $786,914,723 |
| Interest earned on other investments | 2022-12-31 | $-1,586,930 |
| Income. Interest from US Government securities | 2022-12-31 | $2,198,241 |
| Income. Interest from corporate debt instruments | 2022-12-31 | $29,040,492 |
| Value of interest in common/collective trusts at end of year | 2022-12-31 | $1,045,967,667 |
| Value of interest in common/collective trusts at beginning of year | 2022-12-31 | $1,545,648,900 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2022-12-31 | $128,488,919 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2022-12-31 | $114,992,600 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2022-12-31 | $114,992,600 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2022-12-31 | $1,636,010 |
| Assets. Value of investments in 103.12 investment entities at end of year | 2022-12-31 | $104,479,643 |
| Assets. Value of investments in 103.12 investment entities at beginning of year | 2022-12-31 | $134,176,233 |
| Asset value of US Government securities at end of year | 2022-12-31 | $133,318,444 |
| Asset value of US Government securities at beginning of year | 2022-12-31 | $156,292,571 |
| Net investment gain or loss from common/collective trusts | 2022-12-31 | $-304,708,217 |
| Net gain/loss from 103.12 investment entities | 2022-12-31 | $-18,920,561 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2022-12-31 | Yes |
| Income. Dividends from common stock | 2022-12-31 | $807,029 |
| Asset. Corporate debt instrument debt (other) at end of year | 2022-12-31 | $551,970,430 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2022-12-31 | $807,911,280 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2022-12-31 | $46,896,585 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2022-12-31 | $66,898,320 |
| Liabilities. Value of benefit claims payable at end of year | 2022-12-31 | $2,220,756 |
| Liabilities. Value of benefit claims payable at beginning of year | 2022-12-31 | $1,738,497 |
| Did the plan have assets held for investment | 2022-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2022-12-31 | $352,123,940 |
| Aggregate carrying amount (costs) on sale of assets | 2022-12-31 | $483,580,535 |
| 2021 : XCEL ENERGY INC. MASTER PENSION TRUST 2021 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2021-12-31 | $-105,923,781 |
| Total unrealized appreciation/depreciation of assets | 2021-12-31 | $-105,923,781 |
| Total transfer of assets to this plan | 2021-12-31 | $130,948,000 |
| Total transfer of assets from this plan | 2021-12-31 | $376,486,485 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2021-12-31 | $1,738,497 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2021-12-31 | $1,754,831 |
| Total income from all sources (including contributions) | 2021-12-31 | $316,176,907 |
| Total loss/gain on sale of assets | 2021-12-31 | $23,218,308 |
| Total of all expenses incurred | 2021-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2021-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2021-12-31 | $0 |
| Value of total assets at end of year | 2021-12-31 | $3,671,751,368 |
| Value of total assets at beginning of year | 2021-12-31 | $3,601,129,280 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2021-12-31 | $0 |
| Total interest from all sources | 2021-12-31 | $43,567,428 |
| Total dividends received (eg from common stock, registered investment company shares) | 2021-12-31 | $850,726 |
| Assets. Corporate prefeered stocks other than exployer securities at end of year | 2021-12-31 | $35,421 |
| Were there any nonexempt tranactions with any party-in-interest | 2021-12-31 | No |
| Assets. Other investments not covered elsewhere at beginning of year | 2021-12-31 | $0 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2021-12-31 | $40,819,559 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2021-12-31 | $20,261,972 |
| Other income not declared elsewhere | 2021-12-31 | $169,917,988 |
| Total non interest bearing cash at end of year | 2021-12-31 | $18,061,761 |
| Total non interest bearing cash at beginning of year | 2021-12-31 | $483,484 |
| Value of net income/loss | 2021-12-31 | $316,176,907 |
| Value of net assets at end of year (total assets less liabilities) | 2021-12-31 | $3,670,012,871 |
| Value of net assets at beginning of year (total assets less liabilities) | 2021-12-31 | $3,599,374,449 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2021-12-31 | $786,914,723 |
| Assets. partnership/joint venture interests at beginning of year | 2021-12-31 | $695,290,575 |
| Interest earned on other investments | 2021-12-31 | $10,662,155 |
| Income. Interest from US Government securities | 2021-12-31 | $11,100,708 |
| Income. Interest from corporate debt instruments | 2021-12-31 | $21,763,056 |
| Value of interest in common/collective trusts at end of year | 2021-12-31 | $1,545,648,900 |
| Value of interest in common/collective trusts at beginning of year | 2021-12-31 | $1,715,093,167 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2021-12-31 | $114,992,600 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2021-12-31 | $208,702,006 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2021-12-31 | $208,702,006 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2021-12-31 | $41,509 |
| Assets. Value of investments in 103.12 investment entities at end of year | 2021-12-31 | $134,176,233 |
| Assets. Value of investments in 103.12 investment entities at beginning of year | 2021-12-31 | $166,687,518 |
| Asset value of US Government securities at end of year | 2021-12-31 | $156,292,571 |
| Asset value of US Government securities at beginning of year | 2021-12-31 | $240,640,242 |
| Net investment gain or loss from common/collective trusts | 2021-12-31 | $171,114,033 |
| Net gain/loss from 103.12 investment entities | 2021-12-31 | $13,432,205 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2021-12-31 | Yes |
| Income. Dividends from common stock | 2021-12-31 | $850,726 |
| Asset. Corporate debt instrument debt (other) at end of year | 2021-12-31 | $807,911,280 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2021-12-31 | $477,256,253 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2021-12-31 | $66,898,320 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2021-12-31 | $76,714,063 |
| Liabilities. Value of benefit claims payable at end of year | 2021-12-31 | $1,738,497 |
| Liabilities. Value of benefit claims payable at beginning of year | 2021-12-31 | $1,754,831 |
| Did the plan have assets held for investment | 2021-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2021-12-31 | $778,648,210 |
| Aggregate carrying amount (costs) on sale of assets | 2021-12-31 | $755,429,902 |
| 2020 : XCEL ENERGY INC. MASTER PENSION TRUST 2020 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2020-12-31 | $-23,842,005 |
| Total unrealized appreciation/depreciation of assets | 2020-12-31 | $-23,842,005 |
| Total transfer of assets to this plan | 2020-12-31 | $150,000,000 |
| Total transfer of assets from this plan | 2020-12-31 | $298,553,824 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2020-12-31 | $1,754,831 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2020-12-31 | $1,561,251 |
| Total income from all sources (including contributions) | 2020-12-31 | $563,603,871 |
| Total loss/gain on sale of assets | 2020-12-31 | $216,219,328 |
| Total of all expenses incurred | 2020-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2020-12-31 | $0 |
| 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 | $3,601,129,280 |
| Value of total assets at beginning of year | 2020-12-31 | $3,185,885,653 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2020-12-31 | $0 |
| Total interest from all sources | 2020-12-31 | $31,762,558 |
| Total dividends received (eg from common stock, registered investment company shares) | 2020-12-31 | $862,511 |
| Were there any nonexempt tranactions with any party-in-interest | 2020-12-31 | No |
| Assets. Other investments not covered elsewhere at end of year | 2020-12-31 | $0 |
| Assets. Other investments not covered elsewhere at beginning of year | 2020-12-31 | $102,400,114 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2020-12-31 | $20,261,972 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2020-12-31 | $6,622,053 |
| Other income not declared elsewhere | 2020-12-31 | $39,412,965 |
| Total non interest bearing cash at end of year | 2020-12-31 | $483,484 |
| Total non interest bearing cash at beginning of year | 2020-12-31 | $-1,037 |
| Value of net income/loss | 2020-12-31 | $563,603,871 |
| Value of net assets at end of year (total assets less liabilities) | 2020-12-31 | $3,599,374,449 |
| Value of net assets at beginning of year (total assets less liabilities) | 2020-12-31 | $3,184,324,402 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2020-12-31 | $695,290,575 |
| Assets. partnership/joint venture interests at beginning of year | 2020-12-31 | $400,920,368 |
| Value of interest in pooled separate accounts at end of year | 2020-12-31 | $0 |
| Value of interest in pooled separate accounts at beginning of year | 2020-12-31 | $24,894,891 |
| Interest earned on other investments | 2020-12-31 | $2,875,919 |
| Income. Interest from US Government securities | 2020-12-31 | $9,156,161 |
| Income. Interest from corporate debt instruments | 2020-12-31 | $18,839,337 |
| Value of interest in common/collective trusts at end of year | 2020-12-31 | $1,715,093,167 |
| Value of interest in common/collective trusts at beginning of year | 2020-12-31 | $1,623,611,054 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2020-12-31 | $208,702,006 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2020-12-31 | $144,864,631 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2020-12-31 | $144,864,631 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2020-12-31 | $891,141 |
| Assets. Value of investments in 103.12 investment entities at end of year | 2020-12-31 | $166,687,518 |
| Assets. Value of investments in 103.12 investment entities at beginning of year | 2020-12-31 | $147,101,620 |
| Asset value of US Government securities at end of year | 2020-12-31 | $240,640,242 |
| Asset value of US Government securities at beginning of year | 2020-12-31 | $188,722,600 |
| Net investment gain or loss from common/collective trusts | 2020-12-31 | $276,493,331 |
| Net gain/loss from 103.12 investment entities | 2020-12-31 | $22,695,183 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2020-12-31 | Yes |
| Income. Dividends from common stock | 2020-12-31 | $862,511 |
| Asset. Corporate debt instrument debt (other) at end of year | 2020-12-31 | $477,256,253 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2020-12-31 | $460,681,432 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2020-12-31 | $76,714,063 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2020-12-31 | $86,067,927 |
| Liabilities. Value of benefit claims payable at end of year | 2020-12-31 | $1,754,831 |
| Liabilities. Value of benefit claims payable at beginning of year | 2020-12-31 | $1,561,251 |
| Did the plan have assets held for investment | 2020-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2020-12-31 | $216,219,328 |
| 2019 : XCEL ENERGY INC. MASTER PENSION TRUST 2019 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2019-12-31 | $68,175,840 |
| Total unrealized appreciation/depreciation of assets | 2019-12-31 | $68,175,840 |
| Total transfer of assets to this plan | 2019-12-31 | $154,418,990 |
| Total transfer of assets from this plan | 2019-12-31 | $305,264,094 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2019-12-31 | $1,561,251 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2019-12-31 | $34,100,451 |
| Total income from all sources (including contributions) | 2019-12-31 | $592,898,112 |
| Total loss/gain on sale of assets | 2019-12-31 | $72,565,893 |
| Total of all expenses incurred | 2019-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2019-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2019-12-31 | $0 |
| Value of total assets at end of year | 2019-12-31 | $3,185,885,653 |
| Value of total assets at beginning of year | 2019-12-31 | $2,776,371,845 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2019-12-31 | $0 |
| Total interest from all sources | 2019-12-31 | $52,797,592 |
| Total dividends received (eg from common stock, registered investment company shares) | 2019-12-31 | $1,657,076 |
| Were there any nonexempt tranactions with any party-in-interest | 2019-12-31 | No |
| Assets. Other investments not covered elsewhere at end of year | 2019-12-31 | $102,400,114 |
| Assets. Other investments not covered elsewhere at beginning of year | 2019-12-31 | $115,402,475 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2019-12-31 | $6,622,053 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2019-12-31 | $11,459,390 |
| Other income not declared elsewhere | 2019-12-31 | $39,309,425 |
| Liabilities. Value of operating payables at end of year | 2019-12-31 | $0 |
| Liabilities. Value of operating payables at beginning of year | 2019-12-31 | $34,100,451 |
| Total non interest bearing cash at end of year | 2019-12-31 | $-1,037 |
| Total non interest bearing cash at beginning of year | 2019-12-31 | $27,891 |
| Value of net income/loss | 2019-12-31 | $592,898,112 |
| Value of net assets at end of year (total assets less liabilities) | 2019-12-31 | $3,184,324,402 |
| Value of net assets at beginning of year (total assets less liabilities) | 2019-12-31 | $2,742,271,394 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2019-12-31 | $400,920,368 |
| Assets. partnership/joint venture interests at beginning of year | 2019-12-31 | $360,997,467 |
| Value of interest in pooled separate accounts at end of year | 2019-12-31 | $24,894,891 |
| Value of interest in pooled separate accounts at beginning of year | 2019-12-31 | $24,384,940 |
| Interest earned on other investments | 2019-12-31 | $3,370,088 |
| Income. Interest from US Government securities | 2019-12-31 | $27,916,195 |
| Income. Interest from corporate debt instruments | 2019-12-31 | $19,375,508 |
| Value of interest in common/collective trusts at end of year | 2019-12-31 | $1,623,611,054 |
| Value of interest in common/collective trusts at beginning of year | 2019-12-31 | $1,280,651,210 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2019-12-31 | $144,864,631 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2019-12-31 | $136,731,890 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2019-12-31 | $136,731,890 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2019-12-31 | $2,135,801 |
| Assets. Value of investments in 103.12 investment entities at end of year | 2019-12-31 | $147,101,620 |
| Assets. Value of investments in 103.12 investment entities at beginning of year | 2019-12-31 | $119,441,489 |
| Asset value of US Government securities at end of year | 2019-12-31 | $188,722,600 |
| Asset value of US Government securities at beginning of year | 2019-12-31 | $326,785,129 |
| Net investment gain/loss from pooled separate accounts | 2019-12-31 | $473,111 |
| Net investment gain or loss from common/collective trusts | 2019-12-31 | $329,405,879 |
| Net gain/loss from 103.12 investment entities | 2019-12-31 | $28,513,296 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2019-12-31 | Yes |
| Income. Dividends from common stock | 2019-12-31 | $1,657,076 |
| Asset. Corporate debt instrument debt (other) at end of year | 2019-12-31 | $460,681,432 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2019-12-31 | $293,850,264 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2019-12-31 | $86,067,927 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2019-12-31 | $106,639,700 |
| Liabilities. Value of benefit claims payable at end of year | 2019-12-31 | $1,561,251 |
| Did the plan have assets held for investment | 2019-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2019-12-31 | $72,565,893 |
| 2018 : XCEL ENERGY INC. MASTER PENSION TRUST 2018 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2018-12-31 | $-176,587,765 |
| Total unrealized appreciation/depreciation of assets | 2018-12-31 | $-176,587,765 |
| Total transfer of assets to this plan | 2018-12-31 | $150,000,000 |
| Total transfer of assets from this plan | 2018-12-31 | $373,421,064 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2018-12-31 | $34,100,451 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2018-12-31 | $32,855,465 |
| Total income from all sources (including contributions) | 2018-12-31 | $-122,266,671 |
| Total loss/gain on sale of assets | 2018-12-31 | $137,238,992 |
| Total of all expenses incurred | 2018-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2018-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2018-12-31 | $0 |
| Value of total assets at end of year | 2018-12-31 | $2,776,371,845 |
| Value of total assets at beginning of year | 2018-12-31 | $3,120,814,594 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2018-12-31 | $0 |
| Total interest from all sources | 2018-12-31 | $35,722,534 |
| Total dividends received (eg from common stock, registered investment company shares) | 2018-12-31 | $2,038,807 |
| Assets. Real estate other than employer real property at end of year | 2018-12-31 | $0 |
| Assets. Real estate other than employer real property at beginning of year | 2018-12-31 | $44,512,273 |
| Were there any nonexempt tranactions with any party-in-interest | 2018-12-31 | No |
| Assets. Other investments not covered elsewhere at end of year | 2018-12-31 | $115,402,475 |
| Assets. Other investments not covered elsewhere at beginning of year | 2018-12-31 | $155,472,747 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2018-12-31 | $11,459,390 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2018-12-31 | $8,695,857 |
| Other income not declared elsewhere | 2018-12-31 | $-11,891,124 |
| Liabilities. Value of operating payables at end of year | 2018-12-31 | $34,100,451 |
| Liabilities. Value of operating payables at beginning of year | 2018-12-31 | $32,855,465 |
| Total non interest bearing cash at end of year | 2018-12-31 | $27,891 |
| Total non interest bearing cash at beginning of year | 2018-12-31 | $447,712 |
| Value of net income/loss | 2018-12-31 | $-122,266,671 |
| Value of net assets at end of year (total assets less liabilities) | 2018-12-31 | $2,742,271,394 |
| Value of net assets at beginning of year (total assets less liabilities) | 2018-12-31 | $3,087,959,129 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2018-12-31 | $360,997,467 |
| Assets. partnership/joint venture interests at beginning of year | 2018-12-31 | $224,793,018 |
| Value of interest in pooled separate accounts at end of year | 2018-12-31 | $24,384,940 |
| Value of interest in pooled separate accounts at beginning of year | 2018-12-31 | $23,367,040 |
| Interest earned on other investments | 2018-12-31 | $5,600,828 |
| Income. Interest from US Government securities | 2018-12-31 | $9,086,222 |
| Income. Interest from corporate debt instruments | 2018-12-31 | $17,848,136 |
| Value of interest in common/collective trusts at end of year | 2018-12-31 | $1,280,651,210 |
| Value of interest in common/collective trusts at beginning of year | 2018-12-31 | $1,481,462,897 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2018-12-31 | $136,731,890 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2018-12-31 | $195,633,202 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2018-12-31 | $195,633,202 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2018-12-31 | $3,187,348 |
| Assets. Value of investments in 103.12 investment entities at end of year | 2018-12-31 | $119,441,489 |
| Assets. Value of investments in 103.12 investment entities at beginning of year | 2018-12-31 | $199,064,242 |
| Asset value of US Government securities at end of year | 2018-12-31 | $326,785,129 |
| Asset value of US Government securities at beginning of year | 2018-12-31 | $355,699,326 |
| Net investment gain/loss from pooled separate accounts | 2018-12-31 | $2,007,584 |
| Net investment gain or loss from common/collective trusts | 2018-12-31 | $-96,134,331 |
| Net gain/loss from 103.12 investment entities | 2018-12-31 | $-14,661,368 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2018-12-31 | Yes |
| Income. Dividends from common stock | 2018-12-31 | $2,038,807 |
| Asset. Corporate debt instrument debt (other) at end of year | 2018-12-31 | $293,850,264 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2018-12-31 | $317,492,484 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2018-12-31 | $106,639,700 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2018-12-31 | $114,173,796 |
| Did the plan have assets held for investment | 2018-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2018-12-31 | $137,238,992 |
| 2017 : XCEL ENERGY INC. MASTER PENSION TRUST 2017 401k financial data |
|---|
| Unrealized appreciation/depreciation of real estate assets | 2017-12-31 | $774,745 |
| Unrealized appreciation/depreciation of other (non real estate) assets | 2017-12-31 | $-9,335,112 |
| Total unrealized appreciation/depreciation of assets | 2017-12-31 | $-8,560,367 |
| Total transfer of assets to this plan | 2017-12-31 | $161,554,070 |
| Total transfer of assets from this plan | 2017-12-31 | $364,045,631 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2017-12-31 | $32,855,465 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2017-12-31 | $5,719,564 |
| Total income from all sources (including contributions) | 2017-12-31 | $434,637,690 |
| Total loss/gain on sale of assets | 2017-12-31 | $80,552,202 |
| Total of all expenses incurred | 2017-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2017-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2017-12-31 | $0 |
| Value of total assets at end of year | 2017-12-31 | $3,120,814,594 |
| Value of total assets at beginning of year | 2017-12-31 | $2,861,532,564 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2017-12-31 | $0 |
| Total interest from all sources | 2017-12-31 | $31,654,544 |
| Total dividends received (eg from common stock, registered investment company shares) | 2017-12-31 | $1,437,877 |
| Total dividends received from registered investment company shares (eg mutual funds) | 2017-12-31 | $202,967 |
| Assets. Real estate other than employer real property at end of year | 2017-12-31 | $44,512,273 |
| Assets. Real estate other than employer real property at beginning of year | 2017-12-31 | $24,282,100 |
| Were there any nonexempt tranactions with any party-in-interest | 2017-12-31 | No |
| Assets. Other investments not covered elsewhere at end of year | 2017-12-31 | $155,472,747 |
| Assets. Other investments not covered elsewhere at beginning of year | 2017-12-31 | $187,262,249 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2017-12-31 | $8,695,857 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2017-12-31 | $8,957,969 |
| Other income not declared elsewhere | 2017-12-31 | $17,593,376 |
| Liabilities. Value of operating payables at end of year | 2017-12-31 | $32,855,465 |
| Liabilities. Value of operating payables at beginning of year | 2017-12-31 | $5,719,564 |
| Total non interest bearing cash at end of year | 2017-12-31 | $447,712 |
| Total non interest bearing cash at beginning of year | 2017-12-31 | $1,606,796 |
| Value of net income/loss | 2017-12-31 | $434,637,690 |
| Value of net assets at end of year (total assets less liabilities) | 2017-12-31 | $3,087,959,129 |
| Value of net assets at beginning of year (total assets less liabilities) | 2017-12-31 | $2,855,813,000 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2017-12-31 | $224,793,018 |
| Assets. partnership/joint venture interests at beginning of year | 2017-12-31 | $328,273,702 |
| Value of interest in pooled separate accounts at end of year | 2017-12-31 | $23,367,040 |
| Value of interest in pooled separate accounts at beginning of year | 2017-12-31 | $30,717,565 |
| Interest earned on other investments | 2017-12-31 | $10,989,015 |
| Income. Interest from US Government securities | 2017-12-31 | $5,205,866 |
| Income. Interest from corporate debt instruments | 2017-12-31 | $14,139,891 |
| Value of interest in common/collective trusts at end of year | 2017-12-31 | $1,481,462,897 |
| Value of interest in common/collective trusts at beginning of year | 2017-12-31 | $1,238,619,183 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2017-12-31 | $195,633,202 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2017-12-31 | $110,908,403 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2017-12-31 | $110,908,403 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2017-12-31 | $1,319,772 |
| Assets. Value of investments in 103.12 investment entities at end of year | 2017-12-31 | $199,064,242 |
| Assets. Value of investments in 103.12 investment entities at beginning of year | 2017-12-31 | $201,757,645 |
| Asset value of US Government securities at end of year | 2017-12-31 | $355,699,326 |
| Asset value of US Government securities at beginning of year | 2017-12-31 | $363,385,470 |
| Net investment gain/loss from pooled separate accounts | 2017-12-31 | $2,298,938 |
| Net investment gain or loss from common/collective trusts | 2017-12-31 | $268,697,804 |
| Net gain/loss from 103.12 investment entities | 2017-12-31 | $40,963,316 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2017-12-31 | Yes |
| Income. Dividends from common stock | 2017-12-31 | $1,234,910 |
| Asset. Corporate debt instrument debt (other) at end of year | 2017-12-31 | $317,492,484 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2017-12-31 | $276,294,948 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2017-12-31 | $114,173,796 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2017-12-31 | $89,466,534 |
| Did the plan have assets held for investment | 2017-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2017-12-31 | $80,552,202 |
| 2016 : XCEL ENERGY INC. MASTER PENSION TRUST 2016 401k financial data |
|---|
| Unrealized appreciation/depreciation of real estate assets | 2016-12-31 | $2,462,474 |
| Unrealized appreciation/depreciation of other (non real estate) assets | 2016-12-31 | $-41,486,106 |
| Total unrealized appreciation/depreciation of assets | 2016-12-31 | $-39,023,632 |
| Total transfer of assets to this plan | 2016-12-31 | $125,215,613 |
| Total transfer of assets from this plan | 2016-12-31 | $348,294,700 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2016-12-31 | $5,719,564 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2016-12-31 | $2,864,662 |
| Total income from all sources (including contributions) | 2016-12-31 | $195,112,087 |
| Total loss/gain on sale of assets | 2016-12-31 | $48,895,056 |
| Total of all expenses incurred | 2016-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2016-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2016-12-31 | $0 |
| Value of total assets at end of year | 2016-12-31 | $2,861,532,564 |
| Value of total assets at beginning of year | 2016-12-31 | $2,886,644,662 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2016-12-31 | $0 |
| Total interest from all sources | 2016-12-31 | $51,673,120 |
| Total dividends received (eg from common stock, registered investment company shares) | 2016-12-31 | $2,682,862 |
| Assets. Real estate other than employer real property at end of year | 2016-12-31 | $24,282,100 |
| Assets. Real estate other than employer real property at beginning of year | 2016-12-31 | $22,962,337 |
| Were there any nonexempt tranactions with any party-in-interest | 2016-12-31 | No |
| Assets. Other investments not covered elsewhere at end of year | 2016-12-31 | $187,262,249 |
| Assets. Other investments not covered elsewhere at beginning of year | 2016-12-31 | $202,267,920 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2016-12-31 | $8,957,969 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2016-12-31 | $5,865,831 |
| Other income not declared elsewhere | 2016-12-31 | $16,292,938 |
| Liabilities. Value of operating payables at end of year | 2016-12-31 | $5,719,564 |
| Liabilities. Value of operating payables at beginning of year | 2016-12-31 | $2,864,662 |
| Total non interest bearing cash at end of year | 2016-12-31 | $1,606,796 |
| Total non interest bearing cash at beginning of year | 2016-12-31 | $358,087 |
| Value of net income/loss | 2016-12-31 | $195,112,087 |
| Value of net assets at end of year (total assets less liabilities) | 2016-12-31 | $2,855,813,000 |
| Value of net assets at beginning of year (total assets less liabilities) | 2016-12-31 | $2,883,780,000 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2016-12-31 | $328,273,702 |
| Assets. partnership/joint venture interests at beginning of year | 2016-12-31 | $357,537,243 |
| Value of interest in pooled separate accounts at end of year | 2016-12-31 | $30,717,565 |
| Value of interest in pooled separate accounts at beginning of year | 2016-12-31 | $45,606,207 |
| Interest earned on other investments | 2016-12-31 | $16,739,010 |
| Income. Interest from US Government securities | 2016-12-31 | $20,837,033 |
| Income. Interest from corporate debt instruments | 2016-12-31 | $13,805,951 |
| Value of interest in common/collective trusts at end of year | 2016-12-31 | $1,238,619,183 |
| Value of interest in common/collective trusts at beginning of year | 2016-12-31 | $1,127,257,674 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2016-12-31 | $110,908,403 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2016-12-31 | $178,525,419 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2016-12-31 | $178,525,419 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2016-12-31 | $291,126 |
| Assets. Value of investments in 103.12 investment entities at end of year | 2016-12-31 | $201,757,645 |
| Assets. Value of investments in 103.12 investment entities at beginning of year | 2016-12-31 | $191,061,427 |
| Asset value of US Government securities at end of year | 2016-12-31 | $363,385,470 |
| Asset value of US Government securities at beginning of year | 2016-12-31 | $412,932,442 |
| Net investment gain/loss from pooled separate accounts | 2016-12-31 | $3,075,978 |
| Net investment gain or loss from common/collective trusts | 2016-12-31 | $113,935,585 |
| Net gain/loss from 103.12 investment entities | 2016-12-31 | $-2,419,820 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2016-12-31 | Yes |
| Income. Dividends from common stock | 2016-12-31 | $2,682,862 |
| Asset. Corporate debt instrument debt (other) at end of year | 2016-12-31 | $276,294,948 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2016-12-31 | $248,438,746 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2016-12-31 | $89,466,534 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2016-12-31 | $93,831,329 |
| Did the plan have assets held for investment | 2016-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2016-12-31 | $48,895,056 |
| 2015 : XCEL ENERGY INC. MASTER PENSION TRUST 2015 401k financial data |
|---|
| Unrealized appreciation/depreciation of real estate assets | 2015-12-31 | $-90,927 |
| Unrealized appreciation/depreciation of other (non real estate) assets | 2015-12-31 | $-15,468,255 |
| Total unrealized appreciation/depreciation of assets | 2015-12-31 | $-15,559,182 |
| Total transfer of assets to this plan | 2015-12-31 | $90,092,065 |
| Total transfer of assets from this plan | 2015-12-31 | $276,210,827 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2015-12-31 | $2,864,662 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2015-12-31 | $25,143,233 |
| Total income from all sources (including contributions) | 2015-12-31 | $-13,872,238 |
| Total loss/gain on sale of assets | 2015-12-31 | $-1,607,800 |
| Total of all expenses incurred | 2015-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2015-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2015-12-31 | $0 |
| Value of total assets at end of year | 2015-12-31 | $2,886,644,662 |
| Value of total assets at beginning of year | 2015-12-31 | $3,108,914,233 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2015-12-31 | $0 |
| Total interest from all sources | 2015-12-31 | $29,418,110 |
| Total dividends received (eg from common stock, registered investment company shares) | 2015-12-31 | $1,812,675 |
| Assets. Real estate other than employer real property at end of year | 2015-12-31 | $22,962,337 |
| Assets. Real estate other than employer real property at beginning of year | 2015-12-31 | $43,597,741 |
| Were there any nonexempt tranactions with any party-in-interest | 2015-12-31 | No |
| Assets. Other investments not covered elsewhere at end of year | 2015-12-31 | $202,267,920 |
| Assets. Other investments not covered elsewhere at beginning of year | 2015-12-31 | $44,032,645 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2015-12-31 | $5,865,831 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2015-12-31 | $6,415,899 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2015-12-31 | $0 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2015-12-31 | $19,746,546 |
| Other income not declared elsewhere | 2015-12-31 | $-26,677,254 |
| Liabilities. Value of operating payables at end of year | 2015-12-31 | $2,864,662 |
| Liabilities. Value of operating payables at beginning of year | 2015-12-31 | $5,396,687 |
| Total non interest bearing cash at end of year | 2015-12-31 | $358,087 |
| Total non interest bearing cash at beginning of year | 2015-12-31 | $2,366,580 |
| Value of net income/loss | 2015-12-31 | $-13,872,238 |
| Value of net assets at end of year (total assets less liabilities) | 2015-12-31 | $2,883,780,000 |
| Value of net assets at beginning of year (total assets less liabilities) | 2015-12-31 | $3,083,771,000 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2015-12-31 | $357,537,243 |
| Assets. partnership/joint venture interests at beginning of year | 2015-12-31 | $320,694,118 |
| Value of interest in pooled separate accounts at end of year | 2015-12-31 | $45,606,207 |
| Value of interest in pooled separate accounts at beginning of year | 2015-12-31 | $45,599,542 |
| Interest earned on other investments | 2015-12-31 | $7,450,635 |
| Income. Interest from US Government securities | 2015-12-31 | $7,950,987 |
| Income. Interest from corporate debt instruments | 2015-12-31 | $13,988,962 |
| Value of interest in common/collective trusts at end of year | 2015-12-31 | $1,127,257,674 |
| Value of interest in common/collective trusts at beginning of year | 2015-12-31 | $1,112,487,359 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2015-12-31 | $178,525,419 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2015-12-31 | $190,774,892 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2015-12-31 | $190,774,892 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2015-12-31 | $27,526 |
| Assets. Value of investments in 103.12 investment entities at end of year | 2015-12-31 | $191,061,427 |
| Assets. Value of investments in 103.12 investment entities at beginning of year | 2015-12-31 | $482,931,353 |
| Asset value of US Government securities at end of year | 2015-12-31 | $412,932,442 |
| Asset value of US Government securities at beginning of year | 2015-12-31 | $439,185,977 |
| Net investment gain/loss from pooled separate accounts | 2015-12-31 | $7,269,728 |
| Net investment gain or loss from common/collective trusts | 2015-12-31 | $-21,887,816 |
| Net gain/loss from 103.12 investment entities | 2015-12-31 | $13,359,301 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2015-12-31 | Yes |
| Income. Dividends from common stock | 2015-12-31 | $1,812,675 |
| Asset. Corporate debt instrument debt (other) at end of year | 2015-12-31 | $248,438,746 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2015-12-31 | $318,161,051 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2015-12-31 | $93,831,329 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2015-12-31 | $102,667,076 |
| Did the plan have assets held for investment | 2015-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2015-12-31 | $-1,607,800 |
