XCEL ENERGY INC has sponsored the creation of one or more 401k plans.
Submission information for form 5500 for 401k plan XCEL ENERGY MASTER PENSION TRUST
| Measure | Date | Value |
|---|
| 2014 : XCEL ENERGY MASTER PENSION TRUST 2014 401k financial data |
|---|
| Unrealized appreciation/depreciation of real estate assets | 2014-12-31 | $3,309,826 |
| Unrealized appreciation/depreciation of other (non real estate) assets | 2014-12-31 | $18,191,490 |
| Total unrealized appreciation/depreciation of assets | 2014-12-31 | $21,501,316 |
| Total transfer of assets to this plan | 2014-12-31 | $130,562,629 |
| Total transfer of assets from this plan | 2014-12-31 | $302,775,268 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2014-12-31 | $25,143,233 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2014-12-31 | $28,209,647 |
| Total income from all sources (including contributions) | 2014-12-31 | $245,843,639 |
| Total loss/gain on sale of assets | 2014-12-31 | $124,918,443 |
| Total of all expenses incurred | 2014-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2014-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2014-12-31 | $0 |
| Value of total assets at end of year | 2014-12-31 | $3,108,914,233 |
| Value of total assets at beginning of year | 2014-12-31 | $3,038,349,647 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2014-12-31 | $0 |
| Total income from rents | 2014-12-31 | $1,428,322 |
| Total interest from all sources | 2014-12-31 | $38,648,459 |
| Total dividends received (eg from common stock, registered investment company shares) | 2014-12-31 | $1,822,089 |
| Assets. Real estate other than employer real property at end of year | 2014-12-31 | $43,597,741 |
| Assets. Real estate other than employer real property at beginning of year | 2014-12-31 | $43,806,238 |
| Were there any nonexempt tranactions with any party-in-interest | 2014-12-31 | No |
| Assets. Other investments not covered elsewhere at end of year | 2014-12-31 | $44,032,645 |
| Assets. Other investments not covered elsewhere at beginning of year | 2014-12-31 | $79,644,596 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2014-12-31 | $6,415,899 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2014-12-31 | $30,360,831 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2014-12-31 | $19,746,546 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2014-12-31 | $25,197,047 |
| Other income not declared elsewhere | 2014-12-31 | $1,062,929 |
| Liabilities. Value of operating payables at end of year | 2014-12-31 | $5,396,687 |
| Liabilities. Value of operating payables at beginning of year | 2014-12-31 | $3,012,600 |
| Total non interest bearing cash at end of year | 2014-12-31 | $2,366,580 |
| Total non interest bearing cash at beginning of year | 2014-12-31 | $11,613,303 |
| Value of net income/loss | 2014-12-31 | $245,843,639 |
| Value of net assets at end of year (total assets less liabilities) | 2014-12-31 | $3,083,771,000 |
| Value of net assets at beginning of year (total assets less liabilities) | 2014-12-31 | $3,010,140,000 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2014-12-31 | $320,694,118 |
| Assets. partnership/joint venture interests at beginning of year | 2014-12-31 | $277,480,627 |
| Value of interest in pooled separate accounts at end of year | 2014-12-31 | $45,599,542 |
| Value of interest in pooled separate accounts at beginning of year | 2014-12-31 | $56,625,742 |
| Interest earned on other investments | 2014-12-31 | $2,155,454 |
| Income. Interest from US Government securities | 2014-12-31 | $10,701,007 |
| Income. Interest from corporate debt instruments | 2014-12-31 | $25,700,552 |
| Value of interest in common/collective trusts at end of year | 2014-12-31 | $1,112,487,359 |
| Value of interest in common/collective trusts at beginning of year | 2014-12-31 | $1,083,923,493 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2014-12-31 | $190,774,892 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2014-12-31 | $98,086,441 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2014-12-31 | $98,086,441 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2014-12-31 | $91,446 |
| Assets. Value of investments in 103.12 investment entities at end of year | 2014-12-31 | $482,931,353 |
| Assets. Value of investments in 103.12 investment entities at beginning of year | 2014-12-31 | $479,535,515 |
| Asset value of US Government securities at end of year | 2014-12-31 | $439,185,977 |
| Asset value of US Government securities at beginning of year | 2014-12-31 | $230,212,066 |
| Net investment gain/loss from pooled separate accounts | 2014-12-31 | $6,079,736 |
| Net investment gain or loss from common/collective trusts | 2014-12-31 | $87,244,189 |
| Net gain/loss from 103.12 investment entities | 2014-12-31 | $-36,861,844 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2014-12-31 | Yes |
| Income. Dividends from common stock | 2014-12-31 | $1,822,089 |
| Asset. Corporate debt instrument debt (other) at end of year | 2014-12-31 | $318,161,051 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2014-12-31 | $547,714,902 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2014-12-31 | $102,667,076 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2014-12-31 | $99,345,893 |
| Did the plan have assets held for investment | 2014-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2014-12-31 | $124,918,443 |
| 2013 : XCEL ENERGY MASTER PENSION TRUST 2013 401k financial data |
|---|
| Unrealized appreciation/depreciation of real estate assets | 2013-12-31 | $3,492,783 |
| Unrealized appreciation/depreciation of other (non real estate) assets | 2013-12-31 | $-138,336,941 |
| Total unrealized appreciation/depreciation of assets | 2013-12-31 | $-134,844,158 |
| Total transfer of assets to this plan | 2013-12-31 | $205,944,098 |
| Total transfer of assets from this plan | 2013-12-31 | $311,347,717 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2013-12-31 | $28,209,647 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2013-12-31 | $57,196,160 |
| Total income from all sources (including contributions) | 2013-12-31 | $171,760,619 |
| Total loss/gain on sale of assets | 2013-12-31 | $151,512,470 |
| Total of all expenses incurred | 2013-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2013-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2013-12-31 | $0 |
| Value of total assets at end of year | 2013-12-31 | $3,038,349,647 |
| Value of total assets at beginning of year | 2013-12-31 | $3,000,979,160 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2013-12-31 | $0 |
| Total income from rents | 2013-12-31 | $514,462 |
| Total interest from all sources | 2013-12-31 | $38,199,731 |
| Total dividends received (eg from common stock, registered investment company shares) | 2013-12-31 | $1,093,956 |
| Assets. Real estate other than employer real property at end of year | 2013-12-31 | $43,806,238 |
| Assets. Real estate other than employer real property at beginning of year | 2013-12-31 | $32,205,124 |
| Were there any nonexempt tranactions with any party-in-interest | 2013-12-31 | No |
| Assets. Other investments not covered elsewhere at end of year | 2013-12-31 | $79,644,596 |
| Assets. Other investments not covered elsewhere at beginning of year | 2013-12-31 | $242,067,454 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2013-12-31 | $30,360,831 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2013-12-31 | $27,742,257 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2013-12-31 | $25,197,047 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2013-12-31 | $25,071,129 |
| Other income not declared elsewhere | 2013-12-31 | $1,033,723 |
| Liabilities. Value of operating payables at end of year | 2013-12-31 | $3,012,600 |
| Liabilities. Value of operating payables at beginning of year | 2013-12-31 | $32,125,031 |
| Total non interest bearing cash at end of year | 2013-12-31 | $11,613,303 |
| Total non interest bearing cash at beginning of year | 2013-12-31 | $20,985,494 |
| Value of net income/loss | 2013-12-31 | $171,760,619 |
| Value of net assets at end of year (total assets less liabilities) | 2013-12-31 | $3,010,140,000 |
| Value of net assets at beginning of year (total assets less liabilities) | 2013-12-31 | $2,943,783,000 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2013-12-31 | $277,480,627 |
| Assets. partnership/joint venture interests at beginning of year | 2013-12-31 | $158,499,364 |
| Value of interest in pooled separate accounts at end of year | 2013-12-31 | $56,625,742 |
| Value of interest in pooled separate accounts at beginning of year | 2013-12-31 | $68,533,595 |
| Interest earned on other investments | 2013-12-31 | $-1,183,179 |
| Income. Interest from US Government securities | 2013-12-31 | $8,539,486 |
| Income. Interest from corporate debt instruments | 2013-12-31 | $30,666,460 |
| Value of interest in common/collective trusts at end of year | 2013-12-31 | $1,083,923,493 |
| Value of interest in common/collective trusts at beginning of year | 2013-12-31 | $890,566,843 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2013-12-31 | $98,086,441 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2013-12-31 | $143,110,550 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2013-12-31 | $143,110,550 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2013-12-31 | $176,964 |
| Assets. Value of investments in 103.12 investment entities at end of year | 2013-12-31 | $479,535,515 |
| Assets. Value of investments in 103.12 investment entities at beginning of year | 2013-12-31 | $423,284,768 |
| Asset value of US Government securities at end of year | 2013-12-31 | $230,212,066 |
| Asset value of US Government securities at beginning of year | 2013-12-31 | $298,140,693 |
| Net investment gain/loss from pooled separate accounts | 2013-12-31 | $9,368,246 |
| Net investment gain or loss from common/collective trusts | 2013-12-31 | $86,538,025 |
| Net gain/loss from 103.12 investment entities | 2013-12-31 | $18,344,164 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2013-12-31 | Yes |
| Income. Dividends from common stock | 2013-12-31 | $1,093,956 |
| Asset. Corporate debt instrument debt (other) at end of year | 2013-12-31 | $547,714,902 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2013-12-31 | $622,596,509 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2013-12-31 | $99,345,893 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2013-12-31 | $73,246,509 |
| Did the plan have assets held for investment | 2013-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2013-12-31 | $151,512,470 |
| 2012 : XCEL ENERGY MASTER PENSION TRUST 2012 401k financial data |
|---|
| Unrealized appreciation/depreciation of real estate assets | 2012-12-31 | $1,542,581 |
| Unrealized appreciation/depreciation of other (non real estate) assets | 2012-12-31 | $24,795,959 |
| Total unrealized appreciation/depreciation of assets | 2012-12-31 | $26,338,540 |
| Total transfer of assets to this plan | 2012-12-31 | $198,913,436 |
| Total transfer of assets from this plan | 2012-12-31 | $260,448,657 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2012-12-31 | $57,196,160 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2012-12-31 | $82,112,726 |
| Total income from all sources (including contributions) | 2012-12-31 | $330,059,843 |
| Total loss/gain on sale of assets | 2012-12-31 | $74,289,987 |
| Total of all expenses incurred | 2012-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2012-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2012-12-31 | $0 |
| Value of total assets at end of year | 2012-12-31 | $3,000,979,160 |
| Value of total assets at beginning of year | 2012-12-31 | $2,757,371,104 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2012-12-31 | $0 |
| Total interest from all sources | 2012-12-31 | $48,385,020 |
| Total dividends received (eg from common stock, registered investment company shares) | 2012-12-31 | $1,249,654 |
| Assets. Real estate other than employer real property at end of year | 2012-12-31 | $32,205,124 |
| Assets. Real estate other than employer real property at beginning of year | 2012-12-31 | $8,085,910 |
| Assets. Corporate prefeered stocks other than exployer securities at end of year | 2012-12-31 | $0 |
| Assets. Corporate prefeered stocks other than exployer securities at beginning of year | 2012-12-31 | $399,100 |
| Were there any nonexempt tranactions with any party-in-interest | 2012-12-31 | No |
| Assets. Other investments not covered elsewhere at end of year | 2012-12-31 | $242,067,454 |
| Assets. Other investments not covered elsewhere at beginning of year | 2012-12-31 | $563,395,210 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2012-12-31 | $27,742,257 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2012-12-31 | $25,859,329 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2012-12-31 | $25,071,129 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2012-12-31 | $61,483,029 |
| Other income not declared elsewhere | 2012-12-31 | $1,409,178 |
| Liabilities. Value of operating payables at end of year | 2012-12-31 | $32,125,031 |
| Liabilities. Value of operating payables at beginning of year | 2012-12-31 | $20,629,697 |
| Total non interest bearing cash at end of year | 2012-12-31 | $20,985,494 |
| Total non interest bearing cash at beginning of year | 2012-12-31 | $976,828 |
| Value of net income/loss | 2012-12-31 | $330,059,843 |
| Value of net assets at end of year (total assets less liabilities) | 2012-12-31 | $2,943,783,000 |
| Value of net assets at beginning of year (total assets less liabilities) | 2012-12-31 | $2,675,258,378 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2012-12-31 | $158,499,364 |
| Assets. partnership/joint venture interests at beginning of year | 2012-12-31 | $159,842,520 |
| Value of interest in pooled separate accounts at end of year | 2012-12-31 | $68,533,595 |
| Value of interest in pooled separate accounts at beginning of year | 2012-12-31 | $83,307,215 |
| Interest earned on other investments | 2012-12-31 | $2,465,119 |
| Income. Interest from US Government securities | 2012-12-31 | $11,485,157 |
| Income. Interest from corporate debt instruments | 2012-12-31 | $34,307,833 |
| Value of interest in common/collective trusts at end of year | 2012-12-31 | $890,566,843 |
| Value of interest in common/collective trusts at beginning of year | 2012-12-31 | $791,029,792 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2012-12-31 | $143,110,550 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2012-12-31 | $147,273,902 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2012-12-31 | $147,273,902 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2012-12-31 | $126,911 |
| Assets. Value of investments in 103.12 investment entities at end of year | 2012-12-31 | $423,284,768 |
| Asset value of US Government securities at end of year | 2012-12-31 | $298,140,693 |
| Asset value of US Government securities at beginning of year | 2012-12-31 | $302,194,388 |
| Net investment gain/loss from pooled separate accounts | 2012-12-31 | $9,312,105 |
| Net investment gain or loss from common/collective trusts | 2012-12-31 | $128,069,039 |
| Net gain/loss from 103.12 investment entities | 2012-12-31 | $41,006,320 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2012-12-31 | Yes |
| Income. Dividends from preferred stock | 2012-12-31 | $14,531 |
| Income. Dividends from common stock | 2012-12-31 | $1,235,123 |
| Asset. Corporate debt instrument debt (other) at end of year | 2012-12-31 | $622,596,509 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2012-12-31 | $606,102,563 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2012-12-31 | $73,246,509 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2012-12-31 | $68,904,347 |
| Did the plan have assets held for investment | 2012-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2012-12-31 | $74,289,987 |
| 2011 : XCEL ENERGY MASTER PENSION TRUST 2011 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2011-12-31 | $43,535,513 |
| Total unrealized appreciation/depreciation of assets | 2011-12-31 | $43,535,513 |
| Total transfer of assets to this plan | 2011-12-31 | $137,344,757 |
| Total transfer of assets from this plan | 2011-12-31 | $261,699,777 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2011-12-31 | $82,112,726 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2011-12-31 | $126,914,651 |
| Total income from all sources (including contributions) | 2011-12-31 | $248,448,092 |
| Total loss/gain on sale of assets | 2011-12-31 | $73,531,636 |
| Total of all expenses incurred | 2011-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2011-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2011-12-31 | $0 |
| Value of total assets at end of year | 2011-12-31 | $2,757,371,104 |
| Value of total assets at beginning of year | 2011-12-31 | $2,678,079,957 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2011-12-31 | $0 |
| Total interest from all sources | 2011-12-31 | $75,130,040 |
| Total dividends received (eg from common stock, registered investment company shares) | 2011-12-31 | $814,076 |
| Assets. Real estate other than employer real property at end of year | 2011-12-31 | $8,085,910 |
| Assets. Real estate other than employer real property at beginning of year | 2011-12-31 | $534,912 |
| Assets. Corporate prefeered stocks other than exployer securities at end of year | 2011-12-31 | $399,100 |
| Were there any nonexempt tranactions with any party-in-interest | 2011-12-31 | No |
| Assets. Other investments not covered elsewhere at end of year | 2011-12-31 | $563,395,210 |
| Assets. Other investments not covered elsewhere at beginning of year | 2011-12-31 | $512,321,055 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2011-12-31 | $25,859,329 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2011-12-31 | $45,674,010 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2011-12-31 | $61,483,029 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2011-12-31 | $62,766,039 |
| Other income not declared elsewhere | 2011-12-31 | $3,395,264 |
| Liabilities. Value of operating payables at end of year | 2011-12-31 | $20,629,697 |
| Liabilities. Value of operating payables at beginning of year | 2011-12-31 | $64,148,612 |
| Total non interest bearing cash at end of year | 2011-12-31 | $976,828 |
| Total non interest bearing cash at beginning of year | 2011-12-31 | $1,054,500 |
| Value of net income/loss | 2011-12-31 | $248,448,092 |
| Value of net assets at end of year (total assets less liabilities) | 2011-12-31 | $2,675,258,378 |
| Value of net assets at beginning of year (total assets less liabilities) | 2011-12-31 | $2,551,165,306 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2011-12-31 | $159,842,520 |
| Assets. partnership/joint venture interests at beginning of year | 2011-12-31 | $122,222,689 |
| Value of interest in registered invesment companies (eg mutual funds) at beginning of year | 2011-12-31 | $0 |
| Value of interest in pooled separate accounts at end of year | 2011-12-31 | $83,307,215 |
| Value of interest in pooled separate accounts at beginning of year | 2011-12-31 | $73,165,652 |
| Interest earned on other investments | 2011-12-31 | $15,593,509 |
| Income. Interest from US Government securities | 2011-12-31 | $23,515,329 |
| Income. Interest from corporate debt instruments | 2011-12-31 | $35,867,514 |
| Value of interest in common/collective trusts at end of year | 2011-12-31 | $791,029,792 |
| Value of interest in common/collective trusts at beginning of year | 2011-12-31 | $788,493,216 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2011-12-31 | $147,273,902 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2011-12-31 | $257,399,348 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2011-12-31 | $257,399,348 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2011-12-31 | $153,688 |
| Asset value of US Government securities at end of year | 2011-12-31 | $302,194,388 |
| Asset value of US Government securities at beginning of year | 2011-12-31 | $117,522,197 |
| Net investment gain/loss from pooled separate accounts | 2011-12-31 | $12,630,956 |
| Net investment gain or loss from common/collective trusts | 2011-12-31 | $39,410,607 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2011-12-31 | Yes |
| Income. Dividends from preferred stock | 2011-12-31 | $37,781 |
| Income. Dividends from common stock | 2011-12-31 | $776,295 |
| Asset. Corporate debt instrument debt (other) at end of year | 2011-12-31 | $606,102,563 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2011-12-31 | $641,793,529 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2011-12-31 | $68,904,347 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2011-12-31 | $117,898,849 |
| Did the plan have assets held for investment | 2011-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2011-12-31 | $73,531,636 |
| 2010 : XCEL ENERGY MASTER PENSION TRUST 2010 401k financial data |
|---|
| Unrealized appreciation/depreciation of other (non real estate) assets | 2010-12-31 | $99,286,011 |
| Total unrealized appreciation/depreciation of assets | 2010-12-31 | $99,286,011 |
| Total transfer of assets to this plan | 2010-12-31 | $34,132,000 |
| Total transfer of assets from this plan | 2010-12-31 | $249,329,606 |
| Total liabilities at end of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2010-12-31 | $126,914,651 |
| Total liabilities at beginning of year (benefit claims payable, operating payabales, acquisition indebtedness and other liabilities) | 2010-12-31 | $161,127,226 |
| Total income from all sources (including contributions) | 2010-12-31 | $300,071,540 |
| Total loss/gain on sale of assets | 2010-12-31 | $71,915,124 |
| Total of all expenses incurred | 2010-12-31 | $0 |
| Benefit payments and payments to participlants,beneficiaries,insurance carriers and others | 2010-12-31 | $0 |
| Total contributions o plan (from employers,participants, others, non cash contrinutions) | 2010-12-31 | $0 |
| Value of total assets at end of year | 2010-12-31 | $2,678,079,957 |
| Value of total assets at beginning of year | 2010-12-31 | $2,627,418,598 |
| Total of administrative expenses incurred including professional, contract, advisory and management fees | 2010-12-31 | $0 |
| Total interest from all sources | 2010-12-31 | $43,174,873 |
| Total dividends received (eg from common stock, registered investment company shares) | 2010-12-31 | $1,048,470 |
| Assets. Real estate other than employer real property at end of year | 2010-12-31 | $534,912 |
| Assets. Real estate other than employer real property at beginning of year | 2010-12-31 | $0 |
| Assets. Corporate prefeered stocks other than exployer securities at beginning of year | 2010-12-31 | $0 |
| Were there any nonexempt tranactions with any party-in-interest | 2010-12-31 | No |
| Assets. Other investments not covered elsewhere at end of year | 2010-12-31 | $512,321,055 |
| Assets. Other investments not covered elsewhere at beginning of year | 2010-12-31 | $83,907,078 |
| Value of other receiveables (less allowance for doubtful accounts) at end of year | 2010-12-31 | $45,674,010 |
| Value of other receiveables (less allowance for doubtful accounts) at beginning of year | 2010-12-31 | $34,518,306 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at end of year | 2010-12-31 | $62,766,039 |
| Other liabilities (not benefit claims, operating payabales oe acquisition indebtedness) at beginning of year | 2010-12-31 | $110,985,594 |
| Other income not declared elsewhere | 2010-12-31 | $2,434,804 |
| Liabilities. Value of operating payables at end of year | 2010-12-31 | $64,148,612 |
| Liabilities. Value of operating payables at beginning of year | 2010-12-31 | $50,141,632 |
| Total non interest bearing cash at end of year | 2010-12-31 | $1,054,500 |
| Total non interest bearing cash at beginning of year | 2010-12-31 | $-6,927,852 |
| Value of net income/loss | 2010-12-31 | $300,071,540 |
| Value of net assets at end of year (total assets less liabilities) | 2010-12-31 | $2,551,165,306 |
| Value of net assets at beginning of year (total assets less liabilities) | 2010-12-31 | $2,466,291,372 |
| 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 |
| Assets. partnership/joint venture interests at end of year | 2010-12-31 | $122,222,689 |
| Assets. partnership/joint venture interests at beginning of year | 2010-12-31 | $133,738,792 |
| Value of interest in registered invesment companies (eg mutual funds) at end of year | 2010-12-31 | $0 |
| Value of interest in registered invesment companies (eg mutual funds) at beginning of year | 2010-12-31 | $228,472,821 |
| Value of interest in pooled separate accounts at end of year | 2010-12-31 | $73,165,652 |
| Value of interest in pooled separate accounts at beginning of year | 2010-12-31 | $63,607,171 |
| Interest earned on other investments | 2010-12-31 | $2,028,962 |
| Income. Interest from US Government securities | 2010-12-31 | $4,591,854 |
| Income. Interest from corporate debt instruments | 2010-12-31 | $36,275,374 |
| Value of interest in common/collective trusts at end of year | 2010-12-31 | $788,493,216 |
| Value of interest in common/collective trusts at beginning of year | 2010-12-31 | $696,437,617 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at end of year | 2010-12-31 | $257,399,348 |
| Interest-bearing cash (include money market accounts & certificates of deposit) at beginning of the Year | 2010-12-31 | $434,017,534 |
| Value of interest bearing cash (including money market accounts and certificates of deposits) at beginning of year | 2010-12-31 | $434,017,534 |
| Interest earned from interest bearing cash (including money market accounts and certificates of deposit) | 2010-12-31 | $278,683 |
| Value of funds held in insurance company general accounts (unallocated contracts) at beginning of year | 2010-12-31 | $0 |
| Asset value of US Government securities at end of year | 2010-12-31 | $117,522,197 |
| Asset value of US Government securities at beginning of year | 2010-12-31 | $213,191,052 |
| Net investment gain/loss from pooled separate accounts | 2010-12-31 | $11,483,291 |
| Net investment gain or loss from common/collective trusts | 2010-12-31 | $70,728,967 |
| Were any plan transactions or series of transactions in excess of 5% of the current value of the plan assets | 2010-12-31 | Yes |
| Income. Dividends from common stock | 2010-12-31 | $1,048,470 |
| Asset. Corporate debt instrument debt (other) at end of year | 2010-12-31 | $641,793,529 |
| Asset. Corporate debt instrument debt (other) at beginning of year | 2010-12-31 | $650,893,322 |
| Assets. Corporate common stocks other than exployer securities at end of year | 2010-12-31 | $117,898,849 |
| Assets. Corporate common stocks other than exployer securities at beginning of year | 2010-12-31 | $95,562,757 |
| Did the plan have assets held for investment | 2010-12-31 | Yes |
| Aggregate proceeds on sale of assets | 2010-12-31 | $71,915,124 |
