Fair Value of Financial Assets and Liabilities (Tables)

6 Months Ended

Jun. 30, 2018

Cost and Fair Value of Nuclear Decommissioning Fund Investments

The following tables present the cost and fair value of Xcel Energy’s non-derivative instruments with recurring fair value measurements in the nuclear decommissioning fund as of June 30, 2018 and Dec. 31, 2017:



	June 30, 2018
			Fair Value
(Millions of Dollars)	Cost		Level 1		Level 2		Level 3		Investments Measured at NAV ^(b)		Total
Nuclear decommissioning fund ^(a)
Cash equivalents	$	31	$	31	$	—	$	—	$	—	$	31
Commingled funds:
Non U.S. equities	262		199		—		—		90		289
Emerging market debt funds	158		—		—		—		158		158
Private equity investments	151		—		—		—		220		220
Real estate	128		—		—		—		197		197
Debt securities:
Government securities	76		—		75		—		—		75
U.S. corporate bonds	330		—		323		—		—		323
Non U.S. corporate bonds	58		—		56		—		—		56
Equity securities:
U.S. equities	269		568		—		—		—		568
Non U.S. equities	157		227		—		—		—		227
Total	$	1,620	$	1,025	$	454	$	—	$	665	$	2,144


^(a)	Reported in nuclear decommissioning fund and other investments on the consolidated balance sheet, which also includes $138 million of equity investments in unconsolidated subsidiaries and $115 million of rabbi trust assets and miscellaneous investments.


^(b)	Due to limited availability of published pricing and a lack of immediate redeemability, certain fund investments measured at NAV are not required to be categorized within the fair value hierarchy.



	Dec. 31, 2017
			Fair Value
(Millions of Dollars)	Cost		Level 1		Level 2		Level 3		Investments Measured at NAV ^(b)		Total
Nuclear decommissioning fund ^(a)
Cash equivalents	$	29	$	29	$	—	$	—	$	—	$	29
Commingled funds:
Non U.S. equities	264		217		—		—		90		307
Emerging market debt funds	156		—		—		—		166		166
Private equity investments	141		—		—		—		198		198
Real estate	131		—		—		—		202		202
Other commingled funds	9		6		—		—		3		9
Debt securities:
Government securities	68		—		69		—		—		69
U.S. corporate bonds	320		—		322		—		—		322
Non U.S. corporate bonds	50		—		50		—		—		50
Equity securities:
U.S. equities	271		557		—		—		—		557
Non U.S. equities	152		234		—		—		—		234
Total	$	1,591	$	1,043	$	441	$	—	$	659	$	2,143


^(a)	Reported in nuclear decommissioning fund and other investments on the consolidated balance sheet, which also includes $140 million of equity investments in unconsolidated subsidiaries and $114 million of rabbi trust assets and miscellaneous investments.


^(b)	Due to limited availability of published pricing and a lack of immediate redeemability, certain fund investments measured at NAV are not required to be categorized within the fair value hierarchy.

Final Contractual Maturity Dates of Debt Securities in the Nuclear Decommissioning Fund by Asset Class

The following table summarizes the final contractual maturity dates of the debt securities in the nuclear decommissioning fund, by asset class, as of June 30, 2018:



	Final Contractual Maturity
(Millions of Dollars)	Due in 1 Year or Less		Due in 1 to 5 Years		Due in 5 to 10 Years		Due after 10 Years		Total
Government securities	$	—	$	4	$	2	$	69	$	75
U.S. corporate bonds	5		90		172		56		323
Non U.S. corporate bonds	2		20		30		4		56
Debt securities	$	7	$	114	$	204	$	129	$	454

Rabbi Trust Securities Amortized Cost and Fair Value Measured on Recurrring Basis [Table Text Block]

In 2016, Xcel Energy established rabbi trusts to provide partial funding for future distributions of its supplemental executive retirement plan and deferred compensation plan. The following tables present the cost and fair value of the assets held in rabbi trusts as of June 30, 2018 and Dec. 31, 2017:



	June 30, 2018
			Fair Value
(Millions of Dollars)	Cost		Level 1		Level 2		Level 3		Total
Rabbi Trusts ^(a)
Cash equivalents	$	11	$	11	$	—	$	—	$	11
Mutual funds	37		51		—		—		51
Total	$	48	$	62	$	—	$	—	$	62



	Dec. 31, 2017
			Fair Value
(Millions of Dollars)	Cost		Level 1		Level 2		Level 3		Total
Rabbi Trusts ^(a)
Cash equivalents	$	12	$	12	$	—	$	—	$	12
Mutual funds	47		50		—		—		50
Total	$	59	$	62	$	—	$	—	$	62


^(a)	Reported in nuclear decommissioning fund and other investments on the consolidated balance sheet.

Gross Notional Amounts of Commodity Forwards, Options, and FTRs

The following table details the gross notional amounts of commodity forwards, options and FTRs as of June 30, 2018 and Dec. 31, 2017:


^(a)	Amounts are not reflective of net positions in the underlying commodities.


^(b)	Notional amounts for options are included on a gross basis, but are weighted for the probability of exercise.

Impact of Derivative Activity on Accumulated Other Comprehensive Loss, Regulatory Assets and Liabilities, and Income

The following tables detail the impact of derivative activity during the three and six months ended June 30, 2018 and 2017 on accumulated other comprehensive loss, regulatory assets and liabilities, and income:



	Three Months Ended June 30, 2018
	Pre-Tax Fair Value Gains Recognized During the Period in:				Pre-Tax (Gains) Losses Reclassified into Income During the Period from:							Pre-Tax Gains Recognized During the Period in Income
(Millions of Dollars)	Accumulated Other Comprehensive Loss		Regulatory (Assets) and Liabilities		Accumulated Other Comprehensive Loss			Regulatory Assets and (Liabilities)				Pre-Tax Gains Recognized During the Period in Income
Derivatives designated as cash flow hedges
Interest rate	$	—	$	—	$	1	^(a)	$	—			$	—
Total	$	—	$	—	$	1		$	—			$	—
Other derivative instruments
Commodity trading	$	—	$	—	$	—		$	—			$	2	^(b)
Electric commodity	—		37		—			(3		)	^(c)	—
Total	$	—	$	37	$	—		$	(3	)		$	2



	Six Months Ended June 30, 2018
	Pre-Tax Fair Value Gains Recognized During the Period in:				Pre-Tax Losses Reclassified into Income During the Period from:						Pre-Tax Gains (Losses) Recognized During the Period in Income
(Millions of Dollars)	Accumulated Other Comprehensive Loss		Regulatory (Assets) and Liabilities		Accumulated Other Comprehensive Loss			Regulatory Assets and (Liabilities)
Derivatives designated as cash flow hedges
Interest rate	$	—	$	—	$	1	^(a)	$	—		$	—
Total	$	—	$	—	$	1		$	—		$	—
Other derivative instruments
Commodity trading	$	—	$	—	$	—		$	—		$	10		^(b)
Electric commodity	—		8		—			—			—
Natural gas commodity	—		—		—			2		^(d)	(2		)	^(d)
Total	$	—	$	8	$	—		$	2		$	8



	Three Months Ended June 30, 2017
	Pre-Tax Fair Value Losses Recognized During the Period in:					Pre-Tax (Gains) Losses Reclassified into Income During the Period from:							Pre-Tax Gains Recognized During the Period in Income
(Millions of Dollars)	Accumulated Other Comprehensive Loss		Regulatory (Assets) and Liabilities			Accumulated Other Comprehensive Loss			Regulatory Assets and (Liabilities)				Pre-Tax Gains Recognized During the Period in Income
Derivatives designated as cash flow hedges
Interest rate	$	—	$	—		$	2	^(a)	$	—			$	—
Total	$	—	$	—		$	2		$	—			$	—
Other derivative instruments
Commodity trading	$	—	$	—		$	—		$	—			$	6	^(b)
Electric commodity	—		(1		)	—			(2		)	^(c)	—
Natural gas commodity	—		(2		)	—			—				—
Total	$	—	$	(3	)	$	—		$	(2	)		$	6



	Six Months Ended June 30, 2017
	Pre-Tax Fair Value Losses Recognized During the Period in:					Pre-Tax (Gains) Losses Reclassified into Income During the Period from:							Pre-Tax Gains (Losses) Recognized During the Period in Income
(Millions of Dollars)	Accumulated Other Comprehensive Loss		Regulatory (Assets) and Liabilities			Accumulated Other Comprehensive Loss			Regulatory Assets and (Liabilities)
Derivatives designated as cash flow hedges
Interest rate	$	—	$	—		$	2	^(a)	$	—			$	—
Total	$	—	$	—		$	2		$	—			$	—
Other derivative instruments
Commodity trading	$	—	$	—		$	—		$	—			$	7		^(b)
Electric commodity	—		—			—			(6		)	^(c)	—
Natural gas commodity	—		(8		)	—			1			^(d)	(4		)	^(d)
Total	$	—	$	(8	)	$	—		$	(5	)		$	3


^(a)	Amounts are recorded to interest charges.


^(b)	Amounts are recorded to electric operating revenues. Portions of these gains and losses are subject to sharing with electric customers through margin-sharing mechanisms and deducted from gross revenue, as appropriate.


^(c)	Amounts are recorded to electric fuel and purchased power. These derivative settlement gains and losses are shared with electric customers through fuel and purchased energy cost-recovery mechanisms, and reclassified out of income as regulatory assets or liabilities, as appropriate.

^(d)

Certain derivatives are utilized to mitigate natural gas price risk for electric generation and are recorded to electric fuel and purchased power, subject to cost-recovery mechanisms and reclassified to a regulatory asset, as appropriate. Amounts for the three and six months ended June 30, 2018 included no settlement gains or losses and $1 million of settlement losses, respectively. Amounts for the three and six months ended June 30, 2017 included no settlement gains or losses and $1 million of settlement gains, respectively. The remaining derivative settlement gains and losses for the three and six months ended June 30, 2018 and 2017 relate to natural gas operations and are recorded to cost of natural gas sold and transported. These gains and losses are subject to cost-recovery and reclassified out of income to a regulatory asset or liability, as appropriate.

Derivative Assets and Liabilities Measured at Fair Value on a Recurring Basis by Hierarchy Level

2017.

Recurring Fair Value Measurements — The following table presents for each of the fair value hierarchy levels, Xcel Energy’s derivative assets and liabilities measured at fair value on a recurring basis as of June 30, 2018:



	June 30, 2018
	Fair Value						Fair Value Total		Counterparty Netting ^(b)			Total
(Millions of Dollars)	Level 1		Level 2		Level 3		Fair Value Total		Counterparty Netting ^(b)			Total
Current derivative assets
Other derivative instruments:
Commodity trading	$	1	$	27	$	2	$	30	$	(18	)	$	12
Electric commodity	—		—		59		59		(1		)	58
Natural gas commodity	—		1		—		1		—			1
Total current derivative assets	$	1	$	28	$	61	$	90	$	(19	)	71
PPAs ^(a)												4
Current derivative instruments												$	75
Noncurrent derivative assets
Other derivative instruments:
Commodity trading	$	—	$	35	$	6	$	41	$	(12	)	$	29
Total noncurrent derivative assets	$	—	$	35	$	6	$	41	$	(12	)	29
PPAs ^(a)												18
Noncurrent derivative instruments												$	47



	June 30, 2018
	Fair Value						Fair Value Total		Counterparty Netting ^(b)			Total
(Millions of Dollars)	Level 1		Level 2		Level 3		Fair Value Total		Counterparty Netting ^(b)			Total
Current derivative liabilities
Other derivative instruments:
Commodity trading	$	1	$	24	$	2	$	27	$	(22	)	$	5
Electric commodity	—		—		1		1		(1		)	—
Total current derivative liabilities	$	1	$	24	$	3	$	28	$	(23	)	5
PPAs ^(a)												22
Current derivative instruments												$	27
Noncurrent derivative liabilities
Other derivative instruments:
Commodity trading	$	—	$	27	$	—	$	27	$	(15	)	$	12
Total noncurrent derivative liabilities	$	—	$	27	$	—	$	27	$	(15	)	12
PPAs ^(a)												101
Noncurrent derivative instruments												$	113


^(a)	During 2006, Xcel Energy qualified these contracts under the normal purchase exception. Based on this qualification, the contracts are no longer adjusted to fair value and the previous carrying value of these contracts is being amortized over the remaining contract lives along with the offsetting regulatory assets and liabilities.

^(b)

Xcel Energy nets derivative instruments and related collateral in its consolidated balance sheet when supported by a legally enforceable master netting agreement, and all derivative instruments and related collateral amounts were subject to master netting agreements at June 30, 2018. At June 30, 2018, derivative assets and liabilities include no obligations to return cash collateral and the rights to reclaim cash collateral of $8 million. The counterparty netting amounts presented exclude settlement receivables and payables and non-derivative amounts that may be subject to the same master netting agreements.

The following table presents for each of the fair value hierarchy levels, Xcel Energy’s derivative assets and liabilities measured at fair value on a recurring basis as of Dec. 31, 2017:



	Dec. 31, 2017
	Fair Value						Fair Value Total		Counterparty Netting ^(b)			Total
(Millions of Dollars)	Level 1		Level 2		Level 3		Fair Value Total		Counterparty Netting ^(b)			Total
Current derivative assets
Other derivative instruments:
Commodity trading	$	2	$	22	$	—	$	24	$	(15	)	$	9
Electric commodity	—		—		32		32		(2		)	30
Total current derivative assets	$	2	$	22	$	32	$	56	$	(17	)	39
PPAs ^(a)												5
Current derivative instruments												$	44
Noncurrent derivative assets
Other derivative instruments:
Commodity trading	$	—	$	31	$	5	$	36	$	(7	)	$	29
Total noncurrent derivative assets	$	—	$	31	$	5	$	36	$	(7	)	29
PPAs ^(a)												19
Noncurrent derivative instruments												$	48



	Dec. 31, 2017
	Fair Value						Fair Value Total		Counterparty Netting ^(b)			Total
(Millions of Dollars)	Level 1		Level 2		Level 3		Fair Value Total		Counterparty Netting ^(b)			Total
Current derivative liabilities
Other derivative instruments:
Commodity trading	$	2	$	18	$	—	$	20	$	(15	)	$	5
Electric commodity	—		—		2		2		(2		)	—
Natural gas commodity	—		1		—		1		—			1
Total current derivative liabilities	$	2	$	19	$	2	$	23	$	(17	)	6
PPAs ^(a)												23
Current derivative instruments												$	29
Noncurrent derivative liabilities
Other derivative instruments:
Commodity trading	$	—	$	24	$	—	$	24	$	(10	)	$	14
Total noncurrent derivative liabilities	$	—	$	24	$	—	$	24	$	(10	)	14
PPAs ^(a)												112
Noncurrent derivative instruments												$	126


^(a)	During 2006, Xcel Energy qualified these contracts under the normal purchase exception. Based on this qualification, the contracts are no longer adjusted to fair value and the previous carrying value of these contracts is being amortized over the remaining contract lives along with the offsetting regulatory assets and liabilities.

^(b)

Xcel Energy nets derivative instruments and related collateral in its consolidated balance sheet when supported by a legally enforceable master netting agreement, and all derivative instruments and related collateral amounts were subject to master netting agreements at Dec. 31, 2017. At Dec. 31, 2017, derivative assets and liabilities include no obligations to return cash collateral and rights to reclaim cash collateral of $3 million. The counterparty netting amounts presented exclude settlement receivables and payables and non-derivative amounts that may be subject to the same master netting agreements.

Changes in Level 3 Commodity Derivatives

ments.

The following table presents the changes in Level 3 commodity derivatives for the three and six months ended June 30, 2018 and 2017:




	Three Months Ended June 30
(Millions of Dollars)	2018			2017
Balance at April 1	$	19		$	6
Purchases	45			76
Settlements	(20		)	(22		)
Net transactions recorded during the period:
(Losses) gains recognized in earnings ^(a)	(2		)	6
Net gains recognized as regulatory assets and liabilities	22			3
Balance at June 30	$	64		$	69

	Six Months Ended June 30
(Thousands of Dollars)	2018			2017
Balance at Jan. 1	$	35		$	17
Purchases	46			80
Settlements	(32		)	(42		)
Net transactions recorded during the period:
Gains recognized in earnings ^(a)	—			5
Net gains recognized as regulatory assets and liabilities	15			9
Balance at June 30	$	64		$	69


^(a)	These amounts relate to commodity derivatives held at the end of the period.

Carrying Amount and Fair Value of Long-term Debt

As of June 30, 2018 and Dec. 31, 2017, other financial instruments for which the carrying amount did not equal fair value were as follows:



	June 30, 2018				Dec. 31, 2017
(Millions of Dollars)	Carrying Amount		Fair Value		Carrying Amount		Fair Value
Long-term debt, including current portion	$	16,167	$	16,750	$	14,977	$	16,531

(Amounts in Millions) ^(a)(b)

June 30, 2018

Dec. 31, 2017

Megawatt hours of electricity

Million British thermal units of natural gas