Fair Value of Financial Assets and Liabilities | Fair Value of Financial Assets and Liabilities Fair Value Measurements The accounting guidance for fair value measurements and disclosures provides a single definition of fair value and requires certain disclosures about assets and liabilities measured at fair value. A hierarchical framework for disclosing the observability of the inputs utilized in measuring assets and liabilities at fair value is established by this guidance. The three levels in the hierarchy are as follows: Level 1 — Quoted prices are available in active markets for identical assets or liabilities as of the reporting date. The types of assets and liabilities included in Level 1 are highly liquid and actively traded instruments with quoted prices. Level 2 — Pricing inputs are other than quoted prices in active markets, but are either directly or indirectly observable as of the reporting date. The types of assets and liabilities included in Level 2 are typically either comparable to actively traded securities or contracts, or priced with models using highly observable inputs. Level 3 — Significant inputs to pricing have little or no observability as of the reporting date. The types of assets and liabilities included in Level 3 are those valued with models requiring significant management judgment or estimation. Specific valuation methods include the following: Cash equivalents — The fair values of cash equivalents are generally based on cost plus accrued interest; money market funds are measured using quoted net asset value (NAV). Investments in equity securities and other funds — Equity securities are valued using quoted prices in active markets. The fair values for commingled funds are measured using NAVs, which take into consideration the value of underlying fund investments, as well as the other accrued assets and liabilities of a fund, in order to determine a per-share market value. The investments in commingled funds may be redeemed for NAV with proper notice. Proper notice varies by fund and can range from daily with one or two days notice to annually with 90 days notice. Private equity investments require approval of the fund for any unscheduled redemption, and such redemptions may be approved or denied by the fund at its sole discretion. Unscheduled distributions from real estate investments may be redeemed with proper notice, which is typically quarterly with 45 - 90 days notice; however, withdrawals from real estate investments may be delayed or discounted as a result of fund illiquidity. Investments in debt securities — Fair values for debt securities are determined by a third party pricing service using recent trades and observable spreads from benchmark interest rates for similar securities. Interest rate derivatives — The fair values of interest rate derivatives are based on broker quotes that utilize current market interest rate forecasts. Commodity derivatives — The methods used to measure the fair value of commodity derivative forwards and options utilize forward prices and volatilities, as well as pricing adjustments for specific delivery locations, and are generally assigned a Level 2 classification. When contractual settlements extend to periods beyond those readily observable on active exchanges or quoted by brokers, the significance of the use of less observable forecasts of long-term forward prices and volatilities on a valuation is evaluated, and may result in Level 3 classification. Electric commodity derivatives held by NSP-Minnesota include transmission congestion instruments, generally referred to as financial transmission rights (FTRs), purchased from MISO. FTRs purchased from a RTO are financial instruments that entitle or obligate the holder to monthly revenues or charges based on transmission congestion across a given transmission path. The value of an FTR is derived from, and designed to offset, the cost of transmission congestion. In addition to overall transmission load, congestion is also influenced by the operating schedules of power plants and the consumption of electricity pertinent to a given transmission path. Unplanned plant outages, scheduled plant maintenance, changes in the relative costs of fuels used in generation, weather and overall changes in demand for electricity can each impact the operating schedules of the power plants on the transmission grid and the value of an FTR. NSP-Minnesota’s valuation process for FTRs utilizes the cleared prices for each FTR for the most recent auction. If forecasted costs of electric transmission congestion increase or decrease for a given FTR path, the value of that particular FTR instrument will likewise increase or decrease. Given the limited transparency in the auction process, fair value measurements for FTRs have been assigned a Level 3. Non-trading monthly FTR settlements are included in fuel and purchased energy cost recovery mechanisms, and therefore changes in the fair value of the yet to be settled portions of most FTRs are deferred as a regulatory asset or liability. Given this regulatory treatment and the limited magnitude of NSP-Minnesota’s FTRs, the limited transparency associated with the valuation of FTRs are insignificant to the consolidated financial statements of NSP-Minnesota. Non-Derivative Instruments Fair Value Measurements Nuclear Decommissioning Fund The Nuclear Regulatory Commission requires NSP-Minnesota to maintain a portfolio of investments to fund the costs of decommissioning its nuclear generating plants. Together with all accumulated earnings or losses, the assets of the nuclear decommissioning fund are legally restricted for the decommissioning the Monticello and Prairie Island (PI) nuclear generating plants. The fund contains cash equivalents, debt securities, equity securities and other investments. NSP-Minnesota plans to reinvest matured securities until decommissioning begins. NSP-Minnesota uses the asset class target allocations approved by the MPUC for the qualified trust. NSP-Minnesota recognizes the costs of funding the decommissioning of its nuclear generating plants over the lives of the plants, assuming rate recovery of all costs. Given the purpose and legal restrictions on the use of nuclear decommissioning fund assets, realized and unrealized gains on fund investments over the life of the fund are deferred as an offset of NSP-Minnesota’s regulatory asset for nuclear decommissioning costs. Consequently, any realized and unrealized gains and losses on securities in the nuclear decommissioning fund, including any impairments, are deferred as a component of the regulatory asset for nuclear decommissioning. Unrealized gains for the nuclear decommissioning fund were $547 million and $560 million as of June 30, 2018 and Dec. 31, 2017 , respectively, and unrealized losses and amounts recorded as other-than-temporary impairments were $23 million and $7 million as of June 30, 2018 and Dec. 31, 2017 , respectively. The following tables present the cost and fair value of NSP-Minnesota’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 (Thousands of Dollars) Cost Level 1 Level 2 Level 3 Investments Measured at NAV (b) Total Nuclear decommissioning fund (a) Cash equivalents $ 30,868 $ 30,868 $ — $ — $ — $ 30,868 Commingled funds: Non U.S. equities 262,468 197,545 — — 90,402 287,947 Emerging market debt funds 158,296 — — — 158,075 158,075 Private equity investments 150,565 — — — 220,460 220,460 Real estate 128,115 — — — 197,032 197,032 Debt securities: Government securities 75,806 — 75,477 — — 75,477 U.S. corporate bonds 330,170 — 322,689 — — 322,689 Non U.S. corporate bonds 57,902 — 56,422 — — 56,422 Equity securities: U.S. equities 269,483 568,134 — — — 568,134 Non U.S. equities 156,756 227,226 — — — 227,226 Total $ 1,620,429 $ 1,023,773 $ 454,588 $ — $ 665,969 $ 2,144,330 (a) Reported in nuclear decommissioning fund and other investments on the consolidated balance sheet, which also includes $51 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 (Thousands of Dollars) Cost Level 1 Level 2 Level 3 Investments Measured at NAV (b) Total Nuclear decommissioning fund (a) Cash equivalents $ 28,741 $ 28,741 $ — $ — $ — $ 28,741 Commingled funds: Non U.S. equities 263,694 216,551 — — 89,857 306,408 Emerging market debt funds 156,057 — — — 166,375 166,375 Private equity investments 141,413 — — — 198,037 198,037 Real estate 130,787 — — — 201,842 201,842 Other commingled funds 9,340 6,286 — — 2,975 9,261 Debt securities: Government securities 67,760 — 69,413 — — 69,413 U.S. corporate bonds 319,809 — 322,129 — — 322,129 Non U.S. corporate bonds 50,121 — 50,102 — — 50,102 Equity securities: U.S. equities 271,166 556,974 — — — 556,974 Non U.S. equities 151,961 233,999 — — — 233,999 Total $ 1,590,849 $ 1,042,551 $ 441,644 $ — $ 659,086 $ 2,143,281 (a) Reported in nuclear decommissioning fund and other investments on the consolidated balance sheet, which also includes $49 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. For the three and six months ended June 30, 2018 and 2017 there were no Level 3 nuclear decommissioning fund investments and no transfers of amounts between levels. 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 (Thousands 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 $ — $ 3,930 $ 2,300 $ 69,247 $ 75,477 U.S. corporate bonds 4,919 89,594 172,423 55,753 322,689 Non U.S. corporate bonds 2,007 19,925 30,316 4,174 56,422 Debt securities $ 6,926 $ 113,449 $ 205,039 $ 129,174 $ 454,588 Rabbi Trusts In 2016, NSP-Minnesota established a rabbi trust to provide partial funding for future deferred compensation plan distributions. The following tables present the cost and fair value of the assets held in rabbi trust at June 30, 2018 and Dec. 31, 2017 : June 30, 2018 Fair Value (Thousands of Dollars) Cost Level 1 Level 2 Level 3 Total Rabbi Trust (a) Cash equivalents $ 394 $ 394 $ — $ — $ 394 Mutual funds 10,423 11,374 — — 11,374 Total $ 10,817 $ 11,768 $ — $ — $ 11,768 Dec. 31, 2017 Fair Value (Thousands of Dollars) Cost Level 1 Level 2 Level 3 Total Rabbi Trusts (a) Cash equivalents $ 783 $ 783 $ — $ — $ 783 Mutual funds 10,332 11,283 — — 11,283 Total $ 11,115 $ 12,066 $ — $ — $ 12,066 (a) Reported in nuclear decommissioning fund and other investments on the consolidated balance sheet. Derivative Instruments Fair Value Measurements NSP-Minnesota enters into derivative instruments, including forward contracts, futures, swaps and options, for trading purposes and to manage risk in connection with changes in interest rates, utility commodity prices and vehicle fuel prices. Interest Rate Derivatives — NSP-Minnesota enters into various instruments that effectively fix the interest payments on certain floating rate debt obligations or effectively fix the yield or price on a specified benchmark interest rate for an anticipated debt issuance for a specific period. These derivative instruments are generally designated as cash flow hedges for accounting purposes. At June 30, 2018 , accumulated other comprehensive losses related to interest rate derivatives included $0.8 million of net losses expected to be reclassified into earnings during the next 12 months as the related hedged interest rate transactions impact earnings, including forecasted amounts for unsettled hedges, as applicable. Wholesale and Commodity Trading Risk — NSP-Minnesota conducts various wholesale and commodity trading activities, including the purchase and sale of electric capacity, energy, energy-related instruments and natural gas related instruments, including derivatives. NSP-Minnesota’s risk management policy allows management to conduct these activities within guidelines and limitations as approved by its risk management committee, which is made up of management personnel not directly involved in the activities governed by this policy. Commodity Derivatives — NSP-Minnesota enters into derivative instruments to manage variability of future cash flows from changes in commodity prices in its electric and natural gas operations, as well as for trading purposes. This could include the purchase or sale of energy or energy-related products, natural gas to generate electric energy, natural gas for resale, FTRs, vehicle fuel, and weather derivatives. At June 30, 2018 , NSP-Minnesota had various vehicle fuel contracts designated as cash flow hedges extending through December 2018. NSP-Minnesota enters into derivative instruments that mitigate commodity price risk on behalf of electric and natural gas customers, but may not be designated as qualifying hedging transactions. Changes in the fair value of non-trading commodity derivative instruments are recorded in other comprehensive income or deferred as a regulatory asset or liability. The classification as a regulatory asset or liability is based on commission approved regulatory recovery mechanisms. NSP-Minnesota recorded immaterial amounts to income related to the ineffectiveness of cash flow hedges for the three and six months ended June 30, 2018 and 2017. At June 30, 2018 , net gains related to commodity derivative cash flow hedges recorded as a component of accumulated other comprehensive losses included $0.1 million of net gains expected to be reclassified into earnings during the next 12 months as the hedged transactions occur. Additionally, NSP-Minnesota enters into commodity derivative instruments for trading purposes not directly related to commodity price risks associated with serving its electric and natural gas customers. Changes in the fair value of these commodity derivatives are recorded in electric operating revenues, net of amounts credited to customers under margin-sharing mechanisms. The following table details the gross notional amounts of commodity forwards, options and FTRs at June 30, 2018 and Dec. 31, 2017 : (Amounts in Thousands) (a)(b) June 30, 2018 Dec. 31, 2017 Megawatt hours of electricity 73,771 41,711 Million British thermal units of natural gas 7,403 23,829 Gallons of vehicle fuel 120 240 (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. 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 Pre-Tax (Gains) Losses Pre-Tax Gains Recognized (Thousands of Dollars) Accumulated Regulatory Accumulated Regulatory Derivatives designated as cash flow hedges Interest rate $ — $ — $ 264 (a) $ — $ — Vehicle fuel and other commodity 31 — (35 ) (b) — — Total $ 31 $ — $ 229 $ — $ — Other derivative instruments Commodity trading $ — $ — $ — $ — $ 2,263 (c) Electric commodity — 24,262 — 1,142 (d) — Natural gas commodity — (18 ) — — — Total $ — $ 24,244 $ — $ 1,142 $ 2,263 Six Months Ended June 30, 2018 Pre-Tax Fair Value Gains (Losses) Recognized Pre-Tax (Gains) Losses Pre-Tax Gains (Losses) (Thousands of Dollars) Accumulated Regulatory Accumulated Regulatory Derivatives designated as cash flow hedges Interest rate $ — $ — $ 525 (a) $ — $ — Vehicle fuel and other commodity 38 — (64 ) (b) — — Total $ 38 $ — $ 461 $ — $ — Other derivative instruments Commodity trading $ — $ — $ — $ — $ 8,981 (c) Electric commodity — (5,615 ) — 3,311 (d) — Natural gas commodity — 830 — (521 ) (e) (404 ) (e) Total $ — $ (4,785 ) $ — $ 2,790 $ 8,577 Three Months Ended June 30, 2017 Pre-Tax Fair Value Pre-Tax (Gains) Losses Pre-Tax Gains (Thousands of Dollars) Accumulated Regulatory Accumulated Regulatory Derivatives designated as cash flow hedges Interest rate $ — $ — $ 350 (a) $ — $ — Vehicle fuel and other commodity 43 — (5 ) (b) — — Total $ 43 $ — $ 345 $ — $ — Other derivative instruments Commodity trading $ — $ — $ — $ — $ 5,977 (c) Electric commodity — (1,526 ) — (1,149 ) (d) — Natural gas commodity — (51 ) — — — Total $ — $ (1,577 ) $ — $ (1,149 ) $ 5,977 Six Months Ended June 30, 2017 Pre-Tax Fair Value Pre-Tax (Gains) Losses Pre-Tax Gains (Losses) (Thousands of Dollars) Accumulated Regulatory Accumulated Regulatory Derivatives designated as cash flow hedges Interest rate $ — $ — $ 692 (a) $ — $ — Vehicle fuel and other commodity 43 — (5 ) (b) — — Total $ 43 $ — $ 687 $ — $ — Other derivative instruments Commodity trading $ — $ — $ — $ — $ 6,599 (c) Electric commodity — (2,772 ) — (3,937 ) (d) — Natural gas commodity — (717 ) — 698 (e) (945 ) (e) Total $ — $ (3,489 ) $ — $ (3,239 ) $ 5,654 (a) Amounts are recorded to interest charges. (b) Amounts are recorded to operating and maintenance (O&M) expenses. (c) 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. (d) 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. (e) Amounts are recorded to cost of natural gas sold and transported. These derivative settlement gains and losses are shared with natural gas customers through purchased natural gas cost-recovery mechanisms, and reclassified out of income as regulatory assets or liabilities, as appropriate. NSP-Minnesota had no derivative instruments designated as fair value hedges during the three and six months ended June 30, 2018 and 2017 . Therefore, no gains or losses from fair value hedges or related hedged transactions were recognized for these periods. Consideration of Credit Risk and Concentrations — NSP-Minnesota continuously monitors the creditworthiness of the counterparties to its interest rate derivatives and commodity derivative contracts prior to settlement, and assesses each counterparty’s ability to perform on the transactions set forth in the contracts. Given this assessment, as well as an assessment of the impact of NSP-Minnesota’s own credit risk when determining the fair value of derivative liabilities, the impact of credit risk was immaterial to the fair value of unsettled commodity derivatives presented in the consolidated balance sheets. NSP-Minnesota employs additional credit risk control mechanisms when appropriate, such as letters of credit, parental guarantees, standardized master netting agreements and termination provisions that allow for offsetting of positive and negative exposures. Credit exposure is monitored and, when necessary, the activity with a specific counterparty is limited until credit enhancement is provided. NSP-Minnesota’s most significant concentrations of credit risk with particular entities or industries are contracts with counterparties to its wholesale, trading and non-trading commodity activities. At June 30, 2018 , five of NSP-Minnesota’s 10 most significant counterparties for these activities, comprising $39.7 million or 48 percent of this credit exposure, had investment grade credit ratings from Standard & Poor’s, Moody’s or Fitch Ratings. Five of the 10 most significant counterparties, comprising $20.1 million or 24 percent of this credit exposure, were not rated by these external agencies, but based on NSP-Minnesota’s internal analysis, had credit quality consistent with investment grade. All ten of these significant counterparties are municipal or cooperative electric entities, or other utilities. Credit Related Contingent Features — Contract provisions for derivative instruments that NSP-Minnesota enters into, including those accounted for as normal purchase-normal sale contracts and therefore not reflected on the balance sheet, may require the posting of collateral or settlement of the contracts for various reasons, including if NSP-Minnesota’s credit ratings are downgraded below its investment grade credit rating by any of the major credit rating agencies or for cross-default contractual provisions that could result in the settlement of such contracts if there was a failure under other financing arrangements related to payment terms or other covenants. At June 30, 2018 and Dec. 31, 2017 , there were no derivative instruments in a material liability position with such underlying contract provisions. Certain derivative instruments are also subject to contract provisions that contain adequate assurance clauses. These provisions allow counterparties to seek performance assurance, including cash collateral, in the event that NSP-Minnesota’s ability to fulfill its contractual obligations is reasonably expected to be impaired. NSP-Minnesota had no collateral posted related to adequate assurance clauses in derivative contracts as of June 30, 2018 and Dec. 31, 2017 . Recurring Fair Value Measurements — The following table presents for each of the fair value hierarchy levels, NSP-Minnesota’s derivative assets and liabilities measured at fair value on a recurring basis at June 30, 2018 : June 30, 2018 Fair Value Fair Value Total Counterparty Netting (b) (Thousands of Dollars) Level 1 Level 2 Level 3 Total Current derivative assets Derivatives designated as cash flow hedges: Vehicle fuel and other commodity $ — $ 81 $ — $ 81 $ — $ 81 Other derivative instruments: Commodity trading 480 14,737 1,661 16,878 (8,601 ) 8,277 Electric commodity — — 22,896 22,896 (177 ) 22,719 Natural gas commodity — 167 — 167 — 167 Total current derivative assets $ 480 $ 14,985 $ 24,557 $ 40,022 $ (8,778 ) 31,244 PPAs (a) 24 Current derivative instruments $ 31,268 Noncurrent derivative assets Other derivative instruments: Commodity trading $ — $ 33,171 $ 5,596 $ 38,767 $ (12,085 ) $ 26,682 Total noncurrent derivative assets $ — $ 33,171 $ 5,596 $ 38,767 $ (12,085 ) 26,682 PPAs (a) 108 Noncurrent derivative instruments $ 26,790 June 30, 2018 Fair Value Fair Value Total Counterparty Netting (b) (Thousands of Dollars) Level 1 Level 2 Level 3 Total Current derivative liabilities Other derivative instruments: Commodity trading $ 286 $ 12,147 $ 1,550 $ 13,983 $ (9,805 ) $ 4,178 Electric commodity — — 177 177 (177 ) — Total current derivative liabilities $ 286 $ 12,147 $ 1,727 $ 14,160 $ (9,982 ) 4,178 PPAs (a) 13,851 Current derivative instruments $ 18,029 Noncurrent derivative liabilities Other derivative instruments: Commodity trading $ — $ 24,476 $ 397 $ 24,873 $ (15,738 ) $ 9,135 Total noncurrent derivative liabilities $ — $ 24,476 $ 397 $ 24,873 $ (15,738 ) 9,135 PPAs (a) 82,987 Noncurrent derivative instruments $ 92,122 (a) During 2006, NSP-Minnesota 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) NSP-Minnesota 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 rights to reclaim cash collateral of $4.9 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, NSP-Minnesota’s derivative assets and liabilities measured at fair value on a recurring basis at Dec. 31, 2017 : Dec. 31, 2017 Fair Value Fair Value Total Counterparty Netting (b) (Thousands of Dollars) Level 1 Level 2 Level 3 Total Current derivative assets Derivatives designated as cash flow hedges: Vehicle fuel and other commodity $ — $ 107 $ — $ 107 $ — $ 107 Other derivative instruments: Commodity trading 1,691 17,144 142 18,977 (11,744 ) 7,233 Electric commodity — — 17,581 17,581 (425 ) 17,156 Natural gas commodity — 77 — 77 — 77 Total current derivative assets $ 1,691 $ 17,328 $ 17,723 $ 36,742 $ (12,169 ) 24,573 PPAs (a) 657 Current derivative instruments $ 25,230 Noncurrent derivative assets Other derivative instruments: Commodity trading $ — $ 29,121 $ 5,363 $ 34,484 $ (6,502 ) $ 27,982 Total noncurrent derivative assets $ — $ 29,121 $ 5,363 $ 34,484 $ (6,502 ) 27,982 PPAs (a) 120 Noncurrent derivative instruments $ 28,102 Dec. 31, 2017 Fair Value Fair Value Total Counterparty Netting (b) (Thousands of Dollars) Level 1 Level 2 Level 3 Total Current derivative liabilities Other derivative instruments: Commodity trading $ 1,713 $ 13,853 $ — $ 15,566 $ (11,974 ) $ 3,592 Electric commodity — — 425 425 (425 ) — Total current derivative liabilities $ 1,713 $ 13,853 $ 425 $ 15,991 $ (12,399 ) 3,592 PPAs (a) 14,105 Current derivative instruments $ 17,697 Noncurrent derivative liabilities Other derivative instruments: Commodity trading $ — $ 22,163 $ — $ 22,163 $ (9,334 ) $ 12,829 Total noncurrent derivative liabilities $ — $ 22,163 $ — $ 22,163 $ (9,334 ) 12,829 PPAs (a) 89,913 Noncurrent derivative instruments $ 102,742 (a) During 2006, NSP-Minnesota 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) NSP-Minnesota 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.1 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 the changes in Level 3 commodity derivatives for the three and six months ended June 30, 2018 and 2017 : Three Months Ended June 30 (Thousands of Dollars) 2018 2017 Balance at April 1 $ 13,516 $ 4,643 Purchases 26,395 40,460 Settlements (5,170 ) (8,166 ) Net transactions recorded during the period: (Losses) gains recognized in earnings (a) (2,654 ) 6,007 Net losses recognized as regulatory assets and liabilities (4,058 ) (2,372 ) Balance at June 30 $ 28,029 $ 40,572 Six Months Ended June 30 (Thousands of Dollars) 2018 2017 Balance at Jan. 1 $ 22,662 $ 15,320 Purchases 26,397 40,740 Settlements (7,104 ) (11,592 ) Net transactions recorded during the period: (Losses) gains recognized in earnings (a) (374 ) 5,215 Net gains recognized as regulatory assets and liabilities (13,552 ) (9,111 ) Balance at June 30 $ 28,029 $ 40,572 (a) These amounts relate to commodity derivatives held at the end of the period. NSP-Minnesota recognizes transfers between levels as of the beginning of each period. There were no transfers of amounts between levels for derivative instruments for the three and six months ended June 30, 2018 and 2017 . 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 (Thousands of Dollars) Carrying Amount Fair Value Carrying Fair Value Long-term debt, including current portion $ 4,935,068 $ 5,192,385 $ 4,933,018 $ 5,601,919 The fair value of NSP-Minnesota’s long-term debt is estimated based on recent trades and observable spreads from benchmark interest rates for similar securities. The fair value estimates are based on information available to management as of June 30, 2018 and Dec. 31, 2017 , and given the observability of the inputs to these estimates, the fair values presented for long-term debt have been assigned a Level 2. |