ML19088A049

From kanterella
Revision as of 09:41, 12 June 2019 by StriderTol (talk | contribs) (Created page by program invented by StriderTol)
Jump to navigation Jump to search
Decommissioning Funding Status Reports
ML19088A049
Person / Time
Site: Monticello, Prairie Island, San Onofre  Southern California Edison icon.png
Issue date: 03/29/2019
From: Murphy M
Northern States Power Company, Minnesota, Xcel Energy
To:
Document Control Desk, Office of Nuclear Reactor Regulation
References
L-XE-19-003
Download: ML19088A049 (29)


Text

OperationalPost-ShutdownMarketUnrealizedTax-Adjusted2019-2021RemainingEarningsEarningsValue BalanceBook ValueGain/LossTax-EffectFund BalanceDecommissioningLife (yrs)RateRate1/1/20191/1/20191/1/2019Adjustment1/1/2019Accrual Monticello11.755.01%4.43%$496,452,338$406,139,614$90,312,724$25,143,062$471,309,27518,350,224 Prairie Island Unit 114.674.99%4.15%492,616,045388,699,389103,916,65528,930,397463,685,648486,424 Prairie Island Unit 215.835.04%4.09%461,002,122365,060,13995,941,98326,710,248434,291,8741,535,100 TOTAL DECOMMISSIONING ACCRUAL$1,450,070,504$1,159,899,142$290,171,362$80,783,707$1,369,286,797$20,371,748INPUT DATA Escalation Rate (Labor)4.05%Escalation Rate (Non-Labor)2.85%Escalation Rate (PIIC)0.00%Jurisdictional Factor100.0000%Tax Rate for tax-effect adjustment27.84%

AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sMonticelloFactors2017100.0000%4.05%2.85%0.00%2030$20,737,206$20,737,2061.6755 $34,745,189$6,885,496$6,885,4961.4410 $9,921,999

$0$01.0000 $0$27,622,702$27,622,702$44,667,188203171,598,50171,598,5011.7434 124,824,82737,812,81737,812,8171.4820 56,038,595 0 01.0000 0109,411,318109,411,318180,863,421203278,099,04078,099,0401.8140 141,671,65997,618,44797,618,4471.5243 148,799,799 0 01.0000 0175,717,487175,717,487290,471,458203372,885,41972,885,4191.8874 137,563,93978,973,19078,973,1901.5677 123,806,271 0 01.0000 0151,858,609151,858,609261,370,210203466,358,91366,358,9131.9639 130,322,27034,978,32634,978,3261.6124 56,399,053 0 01.0000 0101,337,239101,337,239186,721,322203560,434,43060,434,4302.0434 123,491,71535,562,20135,562,2011.6584 58,976,354 0 01.0000 095,996,63195,996,631182,468,069203644,648,60144,648,6012.1262 94,931,85519,196,34919,196,3491.7056 32,741,293 0 01.0000 063,844,95063,844,950127,673,14820378,071,1588,071,1582.2123 17,855,8231,021,9491,021,9491.7542 1,792,703 0 01.0000 09,093,1079,093,10719,648,526203 8112,108112,1082.3019 258,062 0 01.8042 0 0 01.0000 0112,108112,108258,0622039 0 02.3951 0 0 01.8556 0 0 01.0000 0 0 0 02040 0 02.4921 0 0 01.9085 0 0 01.0000 0 0 0 02041 0 02.5930 0 0 01.9629 0 0 01.0000 0 0 0 02042 0 02.6981 0 0 02.0189 0 0 01.0000 0 0 0 02043 0 02.8073 0 0 02.0764 0 0 01.0000 0 0 0 02044 0 02.9210 0 0 02.1356 0 0 01.0000 0 0 0 02045 0 03.0393 0 0 02.1964 0 0 01.0000 0 0 0 02046 0 03.1624 0 0 02.2590 0 0 01.0000 0 0 0 02047 0 03.2905 0 0 02.3234 0 0 01.0000 0 0 0 02048 0 03.4238 0 0 02.3896 0 0 01.0000 0 0 0 02049 0 03.5624 0 0 02.4577 0 0 01.0000 0 0 0 02050 0 03.7067 0 0 02.5278 0 0 01.0000 0 0 0 02051 0 03.8568 0 0 02.5998 0 0 01.0000 0 0 0 020 5 2 0 04.0130 0 0 02.6739 0 0 01.0000 0 0 0 02053 0 04.1756 0 0 02.7501 0 0 01.0000 0 0 0 02054 0 04.3447 0 0 02.8285 0 0 01.0000 0 0 0 0205 5 0 04.5206 0 0 02.9091 0 0 01.0000 0 0 0 02056 0 04.7037 0 0 02.9920 0 0 01.0000 0 0 0 02057 0 04.8942 0 0 03.0773 0 0 01.0000 0 0 0 02058 0 05.0924 0 0 03.1650 0 0 01.0000 0 0 0 02059 0 05.2987 0 0 03.2552 0 0 0 1.0000 0 0 0 02060 0 05.5133 0 0 03.3480 0 0 01.0000 0 0 0 02061 0 05.7366 0 0 03.4434 0 0 01.0000 0 0 0 02062 0 05.9689 0 0 03.5415 0 0 01.0000 0 0 0 02063 0 06.2106 0 0 03.6425 0 0 01.0000 0 0 0 02064 0 06.4622 0 0 03.7463 0 0 01.0000 0 0 0 02065 0 06.7239 0 0 03.8531 0 0 01.0000 0 0 0 02066 0 06.9962 0 0 03.9629 0 0 01.0000 0 0 0 020 6 7 0 07.2795 0 0 04.0758 0 0 01.0000 0 0 0 02068 0 07.5744 0 0 04.1920 0 0 01.0000 0 0 0 02069 0 07.8811 0 0 04.3115 0 0 01.0000 0 0 0 02070 0 08.2003 0 0 04.4343 0 0 01.0000 0 0 0 02071 0 08.5324 0 0 04.5607 0 0 01.0000 0 0 0 02072 0 08.8780 0 0 04.6907 0 0 01.0000 0 0 0 02073 0 09.2375 0 0 04.8244 0 0 01.0000 0 0 0 02074 0 09.6117 0 0 04.9619 0 0 01.0000 0 0 0 02075 0 010.0009 0 0 05.1033 0 0 01.0000 0 0 0 02076 0 010.4060 0 0 05.2487 0 0 01.0000 0 0 0 02077 0 010.8274 0 0 05.3983 0 0 01.0000 0 0 0 02078 0 011.2659 0 0 05.5522 0 0 01.0000 0 0 0 02079 0 011.7222 0 0 05.7104 0 0 01.0000 0 0 0 0208 0 0 012.1970 0 0 05.8731 0 0 01.0000 0 0 0 02081 0 012.6909 0 0 06.0405 0 0 01.0000 0 0 0 0 2 082 0 013.2049 0 0 06.2127 0 0 01.0000 0 0 0 02083 0 013.7397 0 0 06.3897 0 0 01.0000 0 0 0 0LABORNON-LABORPIIC Payment AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sLABORNON-LABORPIIC Payment2084 0 014.2962 0 0 06.5719 0 0 01.0000 0 0 0 02085 0 014.8752 0 0 06.7592 0 0 01.0000 0 0 0 02086 0 015.4776 0 0 06.9518 0 0 01.0000 0 0 0 02087 0 016.1045 0 0 07.1499 0 0 01.0000 0 0 0 02088 0 016.7567 0 0 07.3537 0 0 01.0000 0 0 0 02089 0 017.4353 0 0 07.5633 0 0 01.0000 0 0 0 02090 0 018.1415 0 0 07.7788 0 0 01.0000 0 0 0 02091 0 018.8762 09,198,9069,198,9068.0005 73,595,844 0 01.0000 09,198,9069,198,90673,595,844$422,945,377$422,945,377$805,665,339$321,247,680$321,247,680$562,071,909

$0$0$0$74 4,193,057$744,193,057$1,367,737,248 AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sLABORNON-LABORPIIC PaymentPrairie Island Unit 1Factors2017100.0000%4.05%2.85%0.00%2033$22,082,038$22,082,0381.8874 $41,677,639$9,275,080$9,275,0801.5677 $14,540,543

$0$01.0000 $0$31,357,118$31,357,118$56,218,1822034$62,549,55962,549,5591.9639 122,841,080$30,657,85030,657,8501.6124 49,432,717

$0 01.0000 093,207,40993,207,409172,273,7972035$63,867,85263,867,8522.0434 130,507,569$77,940,20777,940,2071.6584 129,256,040

$0 01.0000 0141,808,060141,808,060259,763,6092036$55,757,27155,757,2712.1262 118,551,109$63,315,74663,315,7461.7056 107,991,336

$0 01.0000 0119,073,016119,073,016226,542,4452037$36,580,83036,580,8302.2123 80,927,770$34,792,39334,792,3931.7542 61,032,816

$0 01.0000 071,373,22371,373,223141,960,5862038$10,332,91410,332,9142.3019 23,785,335$8,897,9398,897,9391.8042 16,053,662

$0 01.0000 019,230,85319,230,85339,838,9972039$14,386,00814,386,0082.3951 34,455,927$10,352,90610,352,9061.8556 19,210,852

$0 01.0000 024,738,91424,738,91453,666,7792040$31,351,66031,351,6602.4921 78,131,472$12,423,59112,423,5911.9085 23,710,423

$0 01.0000 043,775,25143,775,251101,841,896204 1$9,799,4709,799,4702.5930 25,410,026$1,791,0501,791,0501.9629 3,515,653$0 01.0000 011,590,52011,590,52028,925,6782042$99,30599,3052.6981 267,936$1 12.0189 1$0 01.0000 099,30699,306267,9372043$46,52446,5242.8073 130,607$0 02.0764 1$0 01.0000 046,52446,524130,6072044$0 02.9210 0$0 02.1356 0$0 01.0000 0 0 0 02045$0 03.0393 0$0 02.1964 0$0 01.0000 0 0 0 02046$0 03.1624 0$0 02.2590 0$0 01.0000 0 0 0 02047$0 03.2905 0$0 02.3234 0$0 01.0000 0 0 0 02048$0 03.4238 0$0 02.3896 0$0 01.0000 0 0 0 02049$0 03.5624 0$0 02.4577 0$0 01.0000 0 0 0 02050$0 03.7067 0$0 02.5278 0$0 01.0000 0 0 0 02051$0 03.8568 0$0 02.5998 0$0 01.0000 0 0 0 02052$0 04.0130 0$0 02.6739 0$0 01.0000 0 0 0 02053$0 04.1756 0$0 02.7501 0$0 01.0000 0 0 0 02054$0 04.3447 0$0 02.8285 0$0 01.0000 0 0 0 020 5 5$0 04.5206 0$0 02.9091 0$0 01.0000 0 0 0 02056$0 04.7037 0$0 02.9920 0$0 01.0000 0 0 0 02057$0 04.8942 0$0 03.0773 0$0 01.0000 0 0 0 0205 8$0 05.0924 0$0 03.1650 0$0 01.0000 0 0 0 02059$0 05.2987 0$0 03.2552 0$0 01.0000 0 0 0 02060$0 05.5133 0$0 03.3480 0$0 01.0000 0 0 0 02061$0 05.7366 0$0 03.4434 0$0 01.0000 0 0 0 02062$0 05.9689 0$0 03.5415 0$0 0 1.0000 0 0 0 02063$0 06.2106 0$0 03.6425 0$0 01.0000 0 0 0 02064$0 06.4622 0$0 03.7463 0$0 01.0000 0 0 0 02065$0 06.7239 0$0 03.8531 0$0 01.0000 0 0 0 02066$0 06.9962 0$0 03.9629 0$0 01.0000 0 0 0 02067$0 07.2795 0$0 04.0758 0$0 01.0000 0 0 0 02068$0 07.5744 0$0 04.1920 0$0 01.0000 0 0 0 02069$0 07.8811 0$0 04.3115 0$0 01.0000 0 0 0 020 7 0$0 08.2003 0$0 04.4343 0$0 01.0000 0 0 0 02071$0 08.5324 0$0 04.5607 0$0 01.0000 0 0 0 02072$0 08.8780 0$0 04.6907 0$0 01.0000 0 0 0 02073$0 09.2375 0$0 04.8244 0$0 01.0000 0 0 0 02074$0 09.6117 0$0 04.9619 0$0 01.0000 0 0 0 02075$0 010.0009 0$0 05.1033 0$0 01.0000 0 0 0 02076$0 010.4060 0$0 05.2487 0$0 01.0000 0 0 0 02077$117,000117,00010.8274 1,266,806$11 ,710,00011,710,0005.3983 63,214,093

$0 01.0000 011,827,00011,827,00064,480,8992078$0 011.2659 0$0 05.5522 0$0 01.0000 0 0 0 0$306,970,432$306,970,432$657,953,276$261,156,764$261,156,764$487,958,137

$0$0$0$568,127,196$568,127,196$1,145,911,413 AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sLABORNON-LABORPIIC PaymentPrairie Island Unit 2Factors2017100.0000%4.05%2.85%0.00%2034$7,714,532$7,714,5321.9639 $15,150,569$4,479,535$4,479,5351.6124 $7,222,802$449,304$449,3041.0000 $449,304$12,643,370$12,643,370$22,822,675203546,143,17746,143,177

2.0434 94,288,967 31,183,03431,183,034 1.6584 51,713,944 0-1.0000 -

77,326,21177,326,211146,002,911

203665,461,70065,461,700

2.1262 139,184,666 83,898,48183,898,481 1.7056 143,097,249 0-1.0000 -

149,360,181149,360,181282,281,916

203768,336,30668,336,306

2.2123 151,180,411 68,273,48168,273,481 1.7542 119,765,341 0-1.0000 -

136,609,788136,609,788270,945,752

203842,466,65642,466,656

2.3019 97,753,995 32,416,21732,416,217 1.8042 58,485,339 0-1.0000 -

74,882,87374,882,873156,239,334

203919,013,77819,013,778

2.3951 45,539,899 11,328,79711,328,797 1.8556 21,021,716 0-1.0000 -

30,342,57430 ,342,57466,561,614

204036,849,28136,849,281

2.4921 91,832,094 13,251,48713,251,487 1.9085 25,290,462 0-1.0000 -

50,100,76850,100,768117,122,556

204112,296,08812,296,088

2.5930 31,883,755 1,822,5241,822,524 1.9629 3,577,433 0-1.0000 -

14,118,61214,118,61235,461,188

204 242,46242,462 2.6981 114,567 0 0 2.0189 1 0-1.0000 -

42,46242,462114,568 204319,89319,893 2.8073 55,846 0 0 2.0764 0 0-1.0000 -

19,89319,89355,847 2044 0-2.9210 -

0-2.1356 -

0-1.0000 -

0 0-2045 0-3.0393 -

0-2.1964 -

0-1.0000 -

0 0-2046 0-3.1624 -

0-2.2590 -

0-1.0000 -

0 0-2047 0-3.2905 -

0-2.3234 -

0-1.0000 -

0 0-2048 0-3.4238 -

0-2.3896 -

0-1.0000 -

0 0-2049 0-3.5624 -

0-2.4577 -

0-1.0000 -

0 0-2050 0-3.7067 -

0-2.5278 -

0-1.0000 -

0 0-2051 0-3.8568 -

0-2.5998 -

0-1.0000 -

0 0-2052 0-4.0130 -

0-2.6739 -

0-1.0000 -

0 0-2053 0-4.1756 -

0-2.7501 -

0-1.0000 -

0 0-2054 0-4.3447 -

0-2.8285 -

0-1.0000 -

0 0-2055 0-4.5206 -

0-2.9091 -

0-1.0000 -

0 0-2056 0-4.7037 -

0-2.9920 -

0-1.0000 -

0 0-2057 0-4.8942 -

0-3.0773 -

0-1.0000 -

0 0-2058 0-5.0924 -

0-3.1650 -

0-1.0000 -

0 0-2059 0-5.2987 -

0-3.2552 -

0-1.0000 -

0 0-2060 0-5.5133 -

0-3.3480 -

0-1.0000 -

0 0-2061 0-5.7366 -

0-3.4434 -

0-1.0000 -

0 0-2062 0-5.9689 -

0-3.5415 -

0-1.0000 -

0 0-2063 0-6.2106 -

0-3.6425 -

0-1.0000 -

0 0-2064 0-6.4622 -

0-3.7463 -

0-1.0000 -

0 0-2065 0-6.7239 -

0-3.8531 -

0-1.0000 -

0 0-2066 0-6.9962 -

0-3.9629 -

0-1.0000 -

0 0-2067 0-7.2795 -

0-4.0758 -

0-1.0000 -

0 0-2068 0-7.5744 -

0-4.1920 -

0-1.0000 -

0 0-2069 0-7.8811 -

0-4.3115 -

0-1.0000 -

0 0-2070 0-8.2003 -

0-4.4343 -

0-1.0000 -

0 0-2071 0-8.5324 -

0-4.5607 -

0-1.0000 -

0 0-2072 0-8.8780 -

0-4.6907 -

0-1.0000 -

0 0-2073 0-9.2375 -

0-4.8244 -

0-1.0000 -

0 0-2074 0-9.6117 -

0-4.9619 -

0-1.0000 -

0 0-2075 0-10.0009 -

0-5.1033 -

0-1.0000 -

0 0-2076 0-10.4060 -

0-5.2487 -

0-1.0000 -

0 0-2077116,850116,850 10.8274 1,265,184 11,709,90011,709,900 5.3983 63,213,553 0-1.0000 -

11,826,75011,826,75064,478,737

2078 0-11.2659 -

0-5.5522 -

0-1.0000 -

0 0-

$298,460,723$298,460,723$668,249,954$258,363,457$258,363,457$493,387,841$449,304$449,304$449,304$557,273,484$557,273,484$1,162,087,099$1,028,376,532$1,028,376,532$2,131,868,569$840,767,901$840,767,901$1,543,417,887$449,304$449,304$449,304$1,869,593,737$1,869,593,737$3,675,735,760

OperationalPost-ShutdownMarketUnrealizedTax-Adjusted2019-2021RemainingEarningsEarningsValue BalanceBook ValueGain/LossTax-EffectFund BalanceDecommissioningLife (yrs)RateRate1/1/20191/1/20191/1/2019Adjustment1/1/2019Accrual Monticello11.755.01%4.43%$371,357,890$303,801,873$67,556,017$18,807,595$352,550,295- Prairie Island Unit 114.674.99%4.15%38,812,67630,625,1978,187,4792,279,39436,533,281- Prairie Island Unit 215.835.04%4.09%119,237,75494,422,45224,815,3016,908,580112,329,174- TOTAL DECOMMISSIONING ACCRUAL$529,408,319$428,849,522$100,558,797$27,995,569$501,412,750- INPUT DATA Escalation Rate (Labor)4.05%Escalation Rate (Non-Labor)2.85%Escalation Rate (PIIC)0.00%Jurisdictional Factor100.0000%Tax Rate for tax-effect adjustment27.84%

AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sMonticelloFactors 2017 100.0000%4.05%2.85%0.00%2030$208,258$208,258 1.6755 $348,936$2,050,066$2,050,066 1.4410 $2,954,145$0$0 1.0000 $0$2,258,324$2,258,324$3,303,081 2031 208,260 208,260 1.7434 363,080 5,148,536 5,148,536 1.4820 7,630,130 0 0 1.0000 0 5,356,796 5,356,796 7,993,211 2032 208,258 208,258 1.8140 377,780 4,624,285 4,624,285 1.5243 7,048,798 0 0 1.0000 0 4,832,543 4,832,543 7,426,578 2033 5,766,590 5,766,590 1.8874 10,883,862 21,166,235 21,166,235 1.5677 33,182,307 0 0 1.0000 0 26,932,825 26,932,825 44,066,169 2034 16,591 16,591 1.9639 32,583 3,916,236 3,916,236 1.6124 6,314,538 0 0 1.0000 0 3,932,827 3,932,827 6,347,121 2035 26,442,004 26,442,004 2.0434 54,031,591 77,584,815 77,584,815 1.6584 128,666,657 0 0 1.0000 0 104,026,819 104,026,819 182,698,248 2036 5,658,903 5,658,903 2.1262 12,031,960 1,491,988 1,491,988 1.7056 2,544,734 0 0 1.0000 0 7,150,891 7,150,891 14,576,694 2037 5,643,660 5,643,660 2.2123 12,485,469 2,568,826 2,568,826 1.7542 4,506,234 0 0 1.0000 0 8,212,486 8,212,486 16,991,703 2038 5,664,978 5,664,978 2.3019 13,040,213 3,023,782 3,023,782 1.8042 5,455,507 0 0 1.0000 0 8,688,760 8,688,760 18,495,720 2039 5,925,016 5,925,016 2.3951 14,191,006 2,187,162 2,187,162 1.8556 4,058,499 0 0 1.0000 0 8,112,178 8,112,178 18,249,504 2040 5,941,203 5,941,203 2.4921 14,806,072 2,193,018 2,193,018 1.9085 4,185,375 0 0 1.0000 0 8,134,221 8,134,221 18,991,447 2041 5,925,016 5,925,016 2.5930 15,363,566 2,187,162 2,187,162 1.9629 4,293,181 0 0 1.0000 0 8,112,178 8,112,178 19,656,748 2042 5,925,016 5,925,016 2.6981 15,986,286 2,187,162 2,187,162 2.0189 4,415,662 0 0 1.0000 0 8,112,178 8,112,178 20,401,948 2043 5,925,016 5,925,016 2.8073 16,633,297 2,187,162 2,187,162 2.0764 4,541,424 0 0 1.0000 0 8,112,178 8,112,178 21,174,721 2044 5,941,203 5,941,203 2.9210 17,354,254 2,193,018 2,193,018 2.1356 4,683,410 0 0 1.0000 0 8,134,221 8,134,221 22,037,664 2045 5,925,016 5,925,016 3.0393 18,007,901 2,187,162 2,187,162 2.1964 4,803,884 0 0 1.0000 0 8,112,178 8,112,178 22,811,785 2046 5,925,016 5,925,016 3.1624 18,737,271 2,187,162 2,187,162 2.2590 4,940,800 0 0 1.0000 0 8,112,178 8,112,178 23,678,070 2047 5,925,016 5,925,016 3.2905 19,496,265 2,187,162 2,187,162 2.3234 5,081,653 0 0 1.0000 0 8,112,178 8,112,178 24,577,918 2048 6,604,848 6,604,848 3.4238 22,613,679 4,183,953 4,183,953 2.3896 9,997,975 0 0 1.0000 0 10,788,801 10,788,801 32,611,653 2049 5,925,016 5,925,016 3.5624 21,107,277 2,187,162 2,187,162 2.4577 5,375,389 0 0 1.0000 0 8,112,178 8,112,178 26,482,666 2050 7,418,217 7,418,217 3.7067 27,497,105 6,666,766 6,666,766 2.5278 16,852,252 0 0 1.0000 0 14,084,983 14,084,983 44,349,357 2051 7,418,217 7,418,217 3.8568 28,610,579 6,666,766 6,666,766 2.5998 17,332,259 0 0 1.0000 0 14,084,983 14,084,983 45,942,839 2052 8,296,904 8,296,904 4.0130 33,295,476 9,260,122 9,260,122 2.6739 24,760,641 0 0 1.0000 0 17,557,026 17,557,026 58,056,117 2053 8,927,592 8,927,592 4.1756 37,278,053 11,194,891 11,194,891 2.7501 30,787,071 0 0 1.0000 0 20,122,483 20,122,483 68,065,124 2054 7,633,842 7,633,842 4.3447 33,166,753 7,313,641 7,313,641 2.8285 20,686,635 0 0 1.0000 0 14,947,483 14,947,483 53,853,388 2055 8,711,967 8,711,967 4.5206 39,383,318 10,548,016 10,548,016 2.9091 30,685,235 0 0 1.0000 0 19,259,983 19,259,983 70,068,553 2056 9,159,404 9,159,404 4.7037 43,083,089 11,847,622 11,847,622 2.9920 35,448,086 0 0 1.0000 0 21,007,026 21,007,026 78,531,174 2057 5,908,425 5,908,425 4.8942 28,917,014 2,137,389 2,137,389 3.0773 6,577,388 0 0 1.0000 0 8,045,814 8,045,814 35,494,402 2058 5,908,425 5,908,425 5.0924 30,088,063 2,137,389 2,137,389 3.1650 6,764,838 0 0 1.0000 0 8,045,814 8,045,814 36,852,901 2059 5,908,425 5,908,425 5.2987 31,306,972 2,137,389 2,137,389 3.2552 6,957,630 0 0 1.0000 0 8,045,814 8,045,814 38,264,602 2060 5,924,612 5,924,612 5.5133 32,664,163 2,143,245 2,143,245 3.3480 7,175,585 0 0 1.0000 0 8,067,857 8,067,857 39,839,749 2061 5,908,425 5,908,425 5.7366 33,894,271 2,137,389 2,137,389 3.4434 7,359,887 0 0 1.0000 0 8,045,814 8,045,814 41,254,158 2062 5,908,425 5,908,425 5.9689 35,266,798 2,137,389 2,137,389 3.5415 7,569,565 0 0 1.0000 0 8,045,814 8,045,814 42,836,363 2063 5,908,425 5,908,425 6.2106 36,694,864 2,137,389 2,137,389 3.6425 7,785,441 0 0 1.0000 0 8,045,814 8,045,814 44,480,305 2064 5,924,612 5,924,612 6.4622 38,286,028 2,143,245 2,143,245 3.7463 8,029,240 0 0 1.0000 0 8,067,857 8,067,857 46,315,267 2065 5,908,425 5,908,425 6.7239 39,727,659 2,137,389 2,137,389 3.8531 8,235,575 0 0 1.0000 0 8,045,814 8,045,814 47,963,234 2066 5,908,425 5,908,425 6.9962 41,336,523 2,137,389 2,137,389 3.9629 8,470,261 0 0 1.0000 0 8,045,814 8,045,814 49,806,784 2067 5,908,425 5,908,425 7.2795 43,010,380 2,137,389 2,137,389 4.0758 8,711,572 0 0 1.0000 0 8,045,814 8,045,814 51,721,952 2068 5,924,612 5,924,612 7.5744 44,875,381 2,143,245 2,143,245 4.1920 8,984,484 0 0 1.0000 0 8,067,857 8,067,857 53,859,865 2069 5,908,425 5,908,425 7.8811 46,564,888 2,137,389 2,137,389 4.3115 9,215,354 0 0 1.0000 0 8,045,814 8,045,814 55,780,243 2070 5,908,425 5,908,425 8.2003 48,450,858 2,137,389 2,137,389 4.4343 9,477,826 0 0 1.0000 0 8,045,814 8,045,814 57,928,683 2071 5,908,425 5,908,425 8.5324 50,413,045 2,137,389 2,137,389 4.5607 9,747,992 0 0 1.0000 0 8,045,814 8,045,814 60,161,037 2072 5,924,612 5,924,612 8.8780 52,598,705 2,143,245 2,143,245 4.6907 10,053,321 0 0 1.0000 0 8,067,857 8,067,857 62,652,026 2073 5,908,425 5,908,425 9.2375 54,579,076 2,137,389 2,137,389 4.8244 10,311,622 0 0 1.0000 0 8,045,814 8,045,814 64,890,697 2074 5,908,425 5,908,425 9.6117 56,790,009 2,137,389 2,137,389 4.9619 10,605,513 0 0 1.0000 0 8,045,814 8,045,814 67,395,521 2075 5,908,425 5,908,425 10.0009 59,089,568 2,137,389 2,137,389 5.1033 10,907,739 0 0 1.0000 0 8,045,814 8,045,814 69,997,307 2076 5,924,612 5,924,612 10.4060 61,651,512 2,143,245 2,143,245 5.2487 11,249,251 0 0 1.0000 0 8,067,857 8,067,857 72,900,764 2077 5,908,425 5,908,425 10.8274 63,972,881 2,137,389 2,137,389 5.3983 11,538,269 0 0 1.0000 0 8,045,814 8,045,814 75,511,150 2078 6,386,857 6,386,857 11.2659 71,953,692 3,557,353 3,557,353 5.5522 19,751,134 0 0 1.0000 0 9,944,210 9,944,210 91,704,827 2079 6,482,543 6,482,543 11.7222 75,989,666 3,844,412 3,844,412 5.7104 21,953,129 0 0 1.0000 0 10,326,955 10,326,955 97,942,795 2080 6,403,045 6,403,045 12.1970 78,097,940 3,563,167 3,563,167 5.8731 20,926,834 0 0 1.0000 0 9,966,212 9,966,212 99,024,774 2081 6,386,857 6,386,857 12.6909 81,054,964 3,557,353 3,557,353 6.0405 21,488,190 0 0 1.0000 0 9,944,210 9,944,210 102,543,153 2082 6,386,857 6,386,857 13.2049 84,337,808 3,557,353 3,557,353 6.2127 22,100,766 0 0 1.0000 0 9,944,210 9,944,210 106,438,574 2083 6,482,543 6,482,543 13.7397 89,068,196 3,844,412 3,844,412 6.3897 24,564,638 0 0 1.0000 0 10,326,955 10,326,955 113,632,834 2084 6,403,045 6,403,045 14.2962 91,539,212 3,563,167 3,563,167 6.5719 23,416,775 0 0 1.0000 0 9,966,212 9,966,212 114,955,987LABORNON-LABORPIIC Payment AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sLABORNON-LABORPIIC Payment 2085 6,386,857 6,386,857 14.8752 95,005,775 3,557,353 3,557,353 6.7592 24,044,859 0 0 1.0000 0 9,944,210 9,944,210 119,050,634 2086 6,386,857 6,386,857 15.4776 98,853,218 3,557,353 3,557,353 6.9518 24,730,005 0 0 1.0000 0 9,944,210 9,944,210 123,583,223 2087 6,482,543 6,482,543 16.1045 104,398,114 3,844,412 3,844,412 7.1499 27,487,160 0 0 1.0000 0 10,326,955 10,326,955 131,885,274 2088 7,066,689 7,066,689 16.7567 118,414,388 5,554,101 5,554,101 7.3537 40,843,190 0 0 1.0000 0 12,620,790 12,620,790 159,257,578 2089 6,386,857 6,386,857 17.4353 111,356,768 3,557,353 3,557,353 7.5633 26,905,326 0 0 1.0000 0 9,944,210 9,944,210 138,262,094 2090 6,099,798 6,099,798 18.1415 110,659,485 2,696,175 2,696,175 7.7788 20,973,005 0 0 1.0000 0 8,795,973 8,795,973 131,632,490 2091 906,373 906,373 18.8762 17,108,874 13,947,776 13,947,776 8.0005 111,589,180 0 0 1.0000 0 14,854,149 14,854,149 128,698,054$382,076,608$382,076,608$2,698,223,478$318,256,078$318,256,078$1,047,735,024$0$0$0$700,332,685$700,332,685$3,745,958,502 AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sLABORNON-LABORPIIC PaymentPrairie Island Unit 1Factors 2017 100.0000%4.05%2.85%0.00%2033$0$0 1.8874 $0$453,879$453,879 1.5677 $711,546$1,250,000$1,250,000 1.0000 $1,250,000$1,703,879$1,703,879$1,961,546 2034 0 0 1.9639 0 2,739,769 2,739,769 1.6124 4,417,604 1,250,000 1,250,000 1.0000 1,250,000 3,989,769 3,989,769 5,667,604 2035 427,656 427,656 2.0434 873,872 3,252,840 3,252,840 1.6584 5,394,511 1,250,000 1,250,000 1.0000 1,250,000 4,930,496 4,930,496 7,518,383 2036 95,830 95,830 2.1262 203,754 2,228,076 2,228,076 1.7056 3,800,207 1,250,000 1,250,000 1.0000 1,250,000 3,573,906 3,573,906 5,253,960 2037 95,836 95,836 2.2123 212,018 2,064,184 2,064,184 1.7542 3,620,992 1,250,000 1,250,000 1.0000 1,250,000 3,410,020 3,410,020 5,083,010 2038 2,875,000 2,875,000 2.3019 6,617,963 10,096,752 10,096,752 1.8042 18,216,560 1,250,000 1,250,000 1.0000 1,250,000 14,221,752 14,221,752 26,084,522 2039 21,649,847 21,649,847 2.3951 51,853,549 66,123,822 66,123,822 1.8556 122,699,364 1,250,000 1,250,000 1.0000 1,250,000 89,023,669 89,023,669 175,802,912 2040 567,896 567,896 2.4921 1,415,254 942,015 942,015 1.9085 1,797,835 1,250,000 1,250,000 1.0000 1,250,000 2,759,911 2,759,911 4,463,089 2041 2,070,248 2,070,248 2.5930 5,368,153 1,862,875 1,862,875 1.9629 3,656,636 1,250,000 1,250,000 1.0000 1,250,000 5,183,123 5,183,123 10,274,790 2042 2,871,369 2,871,369 2.6981 7,747,241 2,786,090 2,786,090 2.0189 5,624,838 1,250,000 1,250,000 1.0000 1,250,000 6,907,459 6,907,459 14,622,078 2043 2,964,426 2,964,426 2.8073 8,322,033 2,331,231 2,331,231 2.0764 4,840,567 1,250,000 1,250,000 1.0000 1,250,000 6,545,657 6,545,657 14,412,600 2044 3,054,798 3,054,798 2.9210 8,923,065 1,939,011 1,939,011 2.1356 4,140,951 1,250,000 1,250,000 1.0000 1,250,000 6,243,809 6,243,809 14,314,016 2045 3,046,451 3,046,451 3.0393 9,259,079 1,930,298 1,930,298 2.1964 4,239,705 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 14,748,784 2046 3,046,451 3,046,451 3.1624 9,634,097 1,930,298 1,930,298 2.2590 4,360,542 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 15,244,639 2047 3,046,451 3,046,451 3.2905 10,024,347 1,930,298 1,930,298 2.3234 4,484,853 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 15,759,200 2048 3,054,798 3,054,798 3.4238 10,459,017 1,939,011 1,939,011 2.3896 4,633,460 1,250,000 1,250,000 1.0000 1,250,000 6,243,809 6,243,809 16,342,477 2049 3,046,451 3,046,451 3.5624 10,852,677 1,930,298 1,930,298 2.4577 4,744,092 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 16,846,769 2050 3,046,451 3,046,451 3.7067 11,292,280 1,930,298 1,930,298 2.5278 4,879,406 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 17,421,686 2051 3,046,451 3,046,451 3.8568 11,749,552 1,930,298 1,930,298 2.5998 5,018,388 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 18,017,940 2052 3,054,798 3,054,798 4.0130 12,258,904 1,939,011 1,939,011 2.6739 5,184,721 1,250,000 1,250,000 1.0000 1,250,000 6,243,809 6,243,809 18,693,625 2053 3,142,138 3,142,138 4.1756 13,120,311 2,217,357 2,217,357 2.7501 6,097,952 1,250,000 1,250,000 1.0000 1,250,000 6,609,495 6,609,495 20,468,264 2054 3,237,824 3,237,824 4.3447 14,067,374 2,504,416 2,504,416 2.8285 7,083,739 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 22,401,113 2055 3,237,824 3,237,824 4.5206 14,636,907 2,504,416 2,504,416 2.9091 7,285,595 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 23,172,502 2056 3,294,014 3,294,014 4.7037 15,494,054 2,656,659 2,656,659 2.9920 7,948,723 1,250,000 1,250,000 1.0000 1,250,000 7,200,673 7,200,673 24,692,776 2057 3,189,981 3,189,981 4.8942 15,612,405 2,360,887 2,360,887 3.0773 7,265,156 1,250,000 1,250,000 1.0000 1,250,000 6,800,868 6,800,868 24,127,561 2058 3,333,510 3,333,510 5.0924 16,975,566 2,791,475 2,791,475 3.1650 8,835,017 1,250,000 1,250,000 1.0000 1,250,000 7,374,985 7,374,985 27,060,583 2059 3,189,981 3,189,981 5.2987 16,902,752 2,360,887 2,360,887 3.2552 7,685,158 1,250,000 1,250,000 1.0000 1,250,000 6,800,868 6,800,868 25,837,910 2060 3,150,484 3,150,484 5.5133 17,369,563 2,226,070 2,226,070 3.3480 7,452,881 1,250,000 1,250,000 1.0000 1,250,000 6,626,554 6,626,554 26,072,445 2061 3,237,824 3,237,824 5.7366 18,574,101 2,504,416 2,504,416 3.4434 8,623,704 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 28,447,806 2062 3,237,824 3,237,824 5.9689 19,326,248 2,504,416 2,504,416 3.5415 8,869,388 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 29,445,635 2063 3,189,981 3,189,981 6.2106 19,811,696 2,360,887 2,360,887 3.6425 8,599,529 1,250,000 1,250,000 1.0000 1,250,000 6,800,868 6,800,868 29,661,225 2064 3,246,170 3,246,170 6.4622 20,977,400 2,513,129 2,513,129 3.7463 9,414,934 1,250,000 1,250,000 1.0000 1,250,000 7,009,299 7,009,299 31,642,334 2065 3,237,824 3,237,824 6.7239 21,770,805 2,504,416 2,504,416 3.8531 9,649,763 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 32,670,568 2066 3,189,981 3,189,981 6.9962 22,317,745 2,360,887 2,360,887 3.9629 9,355,957 1,250,000 1,250,000 1.0000 1,250,000 6,800,868 6,800,868 32,923,702 2067 3,237,824 3,237,824 7.2795 23,569,740 2,504,416 2,504,416 4.0758 10,207,497 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 35,027,237 2068 3,246,170 3,246,170 7.5744 24,587,790 2,513,129 2,513,129 4.1920 10,535,035 1,250,000 1,250,000 1.0000 1,250,000 7,009,299 7,009,299 36,372,825 2069 3,189,981 3,189,981 7.8811 25,140,559 2,360,887 2,360,887 4.3115 10,178,962 1,250,000 1,250,000 1.0000 1,250,000 6,800,868 6,800,868 36,569,522 2070 3,237,824 3,237,824 8.2003 26,551,128 2,504,416 2,504,416 4.4343 11,105,330 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 38,906,458 2071 3,237,824 3,237,824 8.5324 27,626,409 2,504,416 2,504,416 4.5607 11,421,888 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 40,298,297 2072 3,246,170 3,246,170 8.8780 28,819,497 2,513,129 2,513,129 4.6907 11,788,333 1,250,000 1,250,000 1.0000 1,250,000 7,009,299 7,009,299 41,857,830 2073 3,237,824 3,237,824 9.2375 29,909,399 2,504,416 2,504,416 4.8244 12,082,302 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 43,241,701 2074 3,237,824 3,237,824 9.6117 31,120,993 2,504,416 2,504,416 4.9619 12,426,659 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 44,797,652 2075 3,569,646 3,569,646 10.0009 35,699,673 3,499,884 3,499,884 5.1033 17,860,956 1,250,000 1,250,000 1.0000 1,250,000 8,319,530 8,319,530 54,810,628 2076 3,246,170 3,246,170 10.4060 33,779,645 2,513,129 2,513,129 5.2487 13,190,658 1,250,000 1,250,000 1.0000 1,250,000 7,009,299 7,009,299 48,220,303 2077 3,120,974 3,120,974 10.8274 33,792,034 2,442,775 2,442,775 5.3983 13,186,830 1,250,000 1,250,000 1.0000 1,250,000 6,813,749 6,813,749 48,228,864 2078 443,864 443,864 11.2659 5,000,531 4,046,900 4,046,900 5.5522 22,469,198 0 0 1.0000 0 4,490,764 4,490,764 27,469,730$142,428,663

$142,428,663$749,621,181$179,062,570$179,062,570$487,087,923$56,250,000$56,250,000$56,250,000$377,741,233$377,741,233$1,292,959,104 AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sLABORNON-LABORPIIC PaymentPrairie Island Unit 2Factors 2017 100.0000%4.05%2.85%0.00%2034$0$0 1.9639 $0$0$0 1.6124 $0$800,696$800,696 1.0000 $800,696$800,696$800,696$800,696 2035 427,650 427,650 2.0434 873,860 4,418,304 4,418,304 1.6584 7,327,316 1,250,000 1,250,000 1.0000 1,250,000 6,095,954 6,095,954 9,451,176 2036 95,831 95,831 2.1262 203,756 2,343,000 2,343,000 1.7056 3,996,221 1,250,000 1,250,000 1.0000 1,250,000 3,688,831 3,688,831 5,449,976 2037 95,830 95,830 2.2123 212,005 2,220,008 2,220,008 1.7542 3,894,338 1,250,000 1,250,000 1.0000 1,250,000 3,565,838 3,565,838 5,356,342 2038 2,875,001 2,875,001 2.3019 6,617,965 10,336,971 10,336,971

1.8042 18,649,963

1,250,000 1,250,000 1.0000 1,250,000 14,461,972 14,461,972 26,517,928

2039 21,649,847 21,649,847

2.3951 51,853,549

66,123,821 66,123,821

1.8556 122,699,362

1,250,000 1,250,000 1.0000 1,250,000 89,023,668 89,023,668 175,802,911

2040 567,896 567,896 2.4921 1,415,254 942,015 942,015 1.9085 1,797,835 1,250,000 1,250,000 1.0000 1,250,000 2,759,911 2,759,911 4,463,089 2041 2,070,248 2,070,248 2.5930 5,368,153 1,862,875 1,862,875 1.9629 3,656,636 1,250,000 1,250,000 1.0000 1,250,000 5,183,123 5,183,123 10,274,790

2042 2,871,369 2,871,369 2.6981 7,747,241 2,786,090 2,786,090 2.0189 5,624,838 1,250,000 1,250,000 1.0000 1,250,000 6,907,459 6,907,459 14,622,078

2043 2,964,426 2,964,426 2.8073 8,322,033 2,331,231 2,331,231 2.0764 4,840,567 1,250,000 1,250,000 1.0000 1,250,000 6,545,657 6,545,657 14,412,600

2044 3,054,798 3,054,798 2.9210 8,923,065 1,939,011 1,939,011 2.1356 4,140,951 1,250,000 1,250,000 1.0000 1,250,000 6,243,809 6,243,809 14,314,016

2045 3,046,451 3,046,451 3.0393 9,259,079 1,930,298 1,930,298 2.1964 4,239,705 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 14,748,784

2046 3,046,451 3,046,451 3.1624 9,634,097 1,930,298 1,930,298 2.2590 4,360,542 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 15,244,639

2047 3,046,451 3,046,451 3.2905 10,024,347

1,930,298 1,930,298 2.3234 4,484,853 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 15,759,200

2048 3,054,798 3,054,798 3.4238 10,459,017

1,939,011 1,939,011 2.3896 4,633,460 1,250,000 1,250,000 1.0000 1,250,000 6,243,809 6,243,809 16,342,477

2049 3,046,451 3,046,451 3.5624 10,852,677

1,930,298 1,930,298 2.4577 4,744,092 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 16,846,769

2050 3,046,451 3,046,451 3.7067 11,292,280

1,930,298 1,930,298 2.5278 4,879,406 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 17,421,686

2051 3,046,451 3,046,451 3.8568 11,749,552

1,930,298 1,930,298 2.5998 5,018,388 1,250,000 1,250,000 1.0000 1,250,000 6,226,749 6,226,749 18,017,940

2052 3,054,798 3,054,798 4.0130 12,258,904

1,939,011 1,939,011 2.6739 5,184,721 1,250,000 1,250,000 1.0000 1,250,000 6,243,809 6,243,809 18,693,625

2053 3,142,138 3,142,138 4.1756 13,120,311

2,217,358 2,217,358 2.7501 6,097,955 1,250,000 1,250,000 1.0000 1,250,000 6,609,496 6,609,496 20,468,266

2054 3,237,824 3,237,824 4.3447 14,067,374

2,504,416 2,504,416 2.8285 7,083,739 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 22,401,113

2055 3,237,824 3,237,824 4.5206 14,636,907

2,504,416 2,504,416 2.9091 7,285,595 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 23,172,502

2056 3,294,014 3,294,014 4.7037 15,494,054

2,656,659 2,656,659 2.9920 7,948,723 1,250,000 1,250,000 1.0000 1,250,000 7,200,673 7,200,673 24,692,776

2057 3,189,981 3,189,981 4.8942 15,612,405

2,360,887 2,360,887 3.0773 7,265,156 1,250,000 1,250,000 1.0000 1,250,000 6,800,868 6,800,868 24,127,561

2058 3,333,510 3,333,510 5.0924 16,975,566

2,791,475 2,791,475 3.1650 8,835,017 1,250,000 1,250,000 1.0000 1,250,000 7,374,985 7,374,985 27,060,583

2059 3,189,981 3,189,981 5.2987 16,902,752

2,360,887 2,360,887 3.2552 7,685,158 1,250,000 1,250,000 1.0000 1,250,000 6,800,868 6,800,868 25,837,910

2060 3,150,484 3,150,484 5.5133 17,369,563

2,226,070 2,226,070 3.3480 7,452,881 1,250,000 1,250,000 1.0000 1,250,000 6,626,554 6,626,554 26,072,445

2061 3,237,824 3,237,824 5.7366 18,574,101

2,504,416 2,504,416 3.4434 8,623,704 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 28,447,806

2062 3,237,824 3,237,824 5.9689 19,326,248

2,504,416 2,504,416 3.5415 8,869,388 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 29,445,635

2063 3,189,981 3,189,981 6.2106 19,811,696

2,360,887 2,360,887 3.6425 8,599,529 1,250,000 1,250,000 1.0000 1,250,000 6,800,868 6,800,868 29,661,225

2064 3,246,170 3,246,170 6.4622 20,977,400

2,513,129 2,513,129 3.7463 9,414,934 1,250,000 1,250,000 1.0000 1,250,000 7,009,299 7,009,299 31,642,334

2065 3,237,824 3,237,824 6.7239 21,770,805

2,504,416 2,504,416 3.8531 9,649,763 1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 32,670,568

2066 3,189,981 3,189,981 6.9962 22,317,745

2,360,887 2,360,887 3.9629 9,355,957 1,250,000 1,250,000 1.0000 1,250,000 6,800,868 6,800,868 32,923,702

2067 3,237,824 3,237,824 7.2795 23,569,740

2,504,416 2,504,416 4.0758 10,207,497

1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 35,027,237

2068 3,246,170 3,246,170 7.5744 24,587,790

2,513,129 2,513,129 4.1920 10,535,035

1,250,000 1,250,000 1.0000 1,250,000 7,009,299 7,009,299 36,372,825

2069 3,189,981 3,189,981 7.8811 25,140,559

2,360,887 2,360,887 4.3115 10,178,962

1,250,000 1,250,000 1.0000 1,250,000 6,800,868 6,800,868 36,569,522

2070 3,237,824 3,237,824 8.2003 26,551,128

2,504,416 2,504,416 4.4343 11,105,330

1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 38,906,458

2071 3,237,824 3,237,824 8.5324 27,626,409

2,504,416 2,504,416 4.5607 11,421,888

1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 40,298,297

2072 3,246,170 3,246,170 8.8780 28,819,497

2,513,129 2,513,129 4.6907 11,788,333

1,250,000 1,250,000 1.0000 1,250,000 7,009,299 7,009,299 41,857,830

2073 3,237,824 3,237,824 9.2375 29,909,399

2,504,416 2,504,416 4.8244 12,082,302

1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 43,241,701

2074 3,237,824 3,237,824 9.6117 31,120,993

2,504,416 2,504,416 4.9619 12,426,659

1,250,000 1,250,000 1.0000 1,250,000 6,992,240 6,992,240 44,797,652

2075 3,569,646 3,569,646 10.0009 35,699,673

3,499,884 3,499,884 5.1033 17,860,956

1,250,000 1,250,000 1.0000 1,250,000 8,319,530 8,319,530 54,810,628

2076 3,246,170 3,246,170 10.4060 33,779,645

2,513,129 2,513,129 5.2487 13,190,658

1,250,000 1,250,000 1.0000 1,250,000 7,009,299 7,009,299 48,220,303

2077 3,120,974 3,120,974 10.8274 33,792,034

2,442,775 2,442,775 5.3983 13,186,830

1,250,000 1,250,000 1.0000 1,250,000 6,813,749 6,813,749 48,228,864

2078 443,864 443,864 11.2659 5,000,531 4,046,900 4,046,900 5.5522 22,469,198

0- 1.0000 - 4,490,764 4,490,764 27,469,730

$142,428,653$142,428,653$749,621,160$177,545,353$177,545,353$484,794,343$54,550,696$54,550,696$54,550,696$374,524,702$374,524,702$1,288,966,199$666,933,925$666,933,925$4,197,465,818$674,864,000$674,864,000$2,019,617,289$110,800,696$110,800,696$110,800,696$1,452,598,621$1,452,598,621$6,327,883,804

OperationalPost-ShutdownMarketUnrealizedTax-Adjusted2019-2021RemainingEarningsEarningsValue BalanceBook ValueGain/LossTax-EffectFund BalanceDecommissioningLife (yrs)RateRate1/1/20191/1/20191/1/2019Adjustment1/1/2019Accrual Monticello11.755.01%4.43%$43,467,856$35,560,349$7,907,507$2,201,450$41,266,406

- Prairie Island Unit 114.674.99%4.15%6,445,8655,086,1191,359,746378,5536,067,311- Prairie Island Unit 215.835.04%4.09%25,316,10520,047,4155,268,6901,466,80323,849,302

- TOTAL DECOMMISSIONING ACCRUAL$75,229,826$60,693,883$14,535,943$4,046,807$71,183,019

- INPUT DATA Escalation Rate (Labor)4.05%Escalation Rate (Non-Labor)2.85%Escalation Rate (PIIC)0.00%Jurisdictional Factor100.0000%Tax Rate for tax-effect adjustment27.84%

AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sMonticelloFactors 2017 100.0000%4.05%2.85%0.00%2030$158,156$158,156 1.6755 $264,990$0$0 1.4410 $0$0$0 1.0000 $0$158,156$158,156$264,990 2031 609,481 609,481 1.7434 1,062,568 0 0 1.4820 0 0 0 1.0000 0 609,481 609,481 1,062,568 2032 169,059 169,059 1.8140 306,673 20,457 20,457 1.5243 31,183 0 0 1.0000 0 189,516 189,516 337,856 2033 11,218 11,218 1.8874 21,173 16,240 16,240 1.5677 25,459 0 0 1.0000 0 27,458 27,458 46,633 2034 4,918 4,918 1.9639 9,659 110 110 1.6124 177 0 0 1.0000 0 5,028 5,028 9,836 2035 3,369 3,369 2.0434 6,883 75 75 1.6584 125 0 0 1.0000 0 3,444 3,444 7,008 2036 0 0 2.1262 0 0 0 1.7056 0 0 0 1.0000 0 0 0 0 2037 20,908,308 20,908,308 2.2123 46,255,451 10,606,108 10,606,108 1.7542 18,605,235 0 0 1.0000 0 31,514,417 31,514,417 64,860,686 2038 23,804,392 23,804,392 2.3019 54,795,329 12,075,197 12,075,197 1.8042 21,786,071 0 0 1.0000 0 35,879,589 35,879,589 76,581,400 2039 0 0 2.3951 0 0 0 1.8556 0 0 0 1.0000 0 0 0 0 2040 0 0 2.4921 0 0 0 1.9085 0 0 0 1.0000 0 0 0 0 2041 0 0 2.5930 0 0 0 1.9629 0 0 0 1.0000 0 0 0 0 2042 0 0 2.6981 0 0 0 2.0189 0 0 0 1.0000 0 0 0 0 2043 0 0 2.8073 0 0 0 2.0764 0 0 0 1.0000 0 0 0 0 2044 0 0 2.9210 0 0 0 2.1356 0 0 0 1.0000 0 0 0 0 2045 0 0 3.0393 0 0 0 2.1964 0 0 0 1.0000 0 0 0 0 2046 0 0 3.1624 0 0 0 2.2590 0 0 0 1.0000 0 0 0 0 2047 0 0 3.2905 0 0 0 2.3234 0 0 0 1.0000 0 0 0 0 2048 0 0 3.4238 0 0 0 2.3896 0 0 0 1.0000 0 0 0 0 2049 0 0 3.5624 0 0 0 2.4577 0 0 0 1.0000 0 0 0 0 2050 0 0 3.7067 0 0 0 2.5278 0 0 0 1.0000 0 0 0 0 2051 0 0 3.8568 0 0 0 2.5998 0 0 0 1.0000 0 0 0 0 2052 0 0 4.0130 0 0 0 2.6739 0 0 0 1.0000 0 0 0 0 2053 0 0 4.1756 0 0 0 2.7501 0 0 0 1.0000 0 0 0 0 2054 0 0 4.3447 0 0 0 2.8285 0 0 0 1.0000 0 0 0 0 2055 0 0 4.5206 0 0 0 2.9091 0 0 0 1.0000 0 0 0 0 2056 0 0 4.7037 0 0 0 2.9920 0 0 0 1.0000 0 0 0 0 2057 0 0 4.8942 0 0 0 3.0773 0 0 0 1.0000 0 0 0 0 2058 0 0 5.0924 0 0 0 3.1650 0 0 0 1.0000 0 0 0 0 2059 0 0 5.2987 0 0 0 3.2552 0 0 0 1.0000 0 0 0 0 2060 0 0 5.5133 0 0 0 3.3480 0 0 0 1.0000 0 0 0 0 2061 0 0 5.7366 0 0 0 3.4434 0 0 0 1.0000 0 0 0 0 2062 0 0 5.9689 0 0 0 3.5415 0 0 0 1.0000 0 0 0 0 2063 0 0 6.2106 0 0 0 3.6425 0 0 0 1.0000 0 0 0 0 2064 0 0 6.4622 0 0 0 3.7463 0 0 0 1.0000 0 0 0 0 2065 0 0 6.7239 0 0 0 3.8531 0 0 0 1.0000 0 0 0 0 2066 0 0 6.9962 0 0 0 3.9629 0 0 0 1.0000 0 0 0 0 2067 0 0 7.2795 0 0 0 4.0758 0 0 0 1.0000 0 0 0 0 2068 0 0 7.5744 0 0 0 4.1920 0 0 0 1.0000 0 0 0 0 2069 0 0 7.8811 0 0 0 4.3115 0 0 0 1.0000 0 0 0 0 2070 0 0 8.2003 0 0 0 4.4343 0 0 0 1.0000 0 0 0 0 2071 0 0 8.5324 0 0 0 4.5607 0 0 0 1.0000 0 0 0 0 2072 0 0 8.8780 0 0 0 4.6907 0 0 0 1.0000 0 0 0 0 2073 0 0 9.2375 0 0 0 4.8244 0 0 0 1.0000 0 0 0 0 2074 0 0 9.6117 0 0 0 4.9619 0 0 0 1.0000 0 0 0 0 2075 0 0 10.0009 0 0 0 5.1033 0 0 0 1.0000 0 0 0 0 2076 0 0 10.4060 0 0 0 5.2487 0 0 0 1.0000 0 0 0 0 2077 0 0 10.8274 0 0 0 5.3983 0 0 0 1.0000 0 0 0 0 2078 0 0 11.2659 0 0 0 5.5522 0 0 0 1.0000 0 0 0 0 2079 0 0 11.7222 0 0 0 5.7104 0 0 0 1.0000 0 0 0 0 2080 0 0 12.1970 0 0 0 5.8731 0 0 0 1.0000 0 0 0 0 2081 0 0 12.6909 0 0 0 6.0405 0 0 0 1.0000 0 0 0 0 2082 0 0 13.2049 0 0 0 6.2127 0 0 0 1.0000 0 0 0 0 2083 0 0 13.7397 0 0 0 6.3897 0 0 0 1.0000 0 0 0 0 2084 0 0 14.2962 0 0 0 6.5719 0 0 0 1.0000 0 0 0 0LABORNON-LABORPIIC Payment AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sLABORNON-LABORPIIC Payment 2085 0 0 14.8752 0 0 0 6.7592 0 0 0 1.0000 0 0 0 0 2086 0 0 15.4776 0 0 0 6.9518 0 0 0 1.0000 0 0 0 0 2087 0 0 16.1045 0 0 0 7.1499 0 0 0 1.0000 0 0 0 0 2088 0 0 16.7567 0 0 0 7.3537 0 0 0 1.0000 0 0 0 0 2089 0 0 17.4353 0 0 0 7.5633 0 0 0 1.0000 0 0 0 0 2090 0 0 18.1415 0 0 0 7.7788 0 0 0 1.0000 0 0 0 0 2091 1,128,517 1,128,517 18.8762 21,302,113 1,808,329 1,808,329 8.0005 14,467,533 0 0 1.0000 0 2,936,846 2,936,846 35,769,645$46,797,417$46,797,417$124,024,839$24,526,516$24,526,516$54,915,783$0$0$0$71,323,933$71,323,933$178,940,622 AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sLABORNON-LABORPIIC PaymentPrairie Island Unit 1Factors 2017 100.0000%4.05%2.85%0.00%2033$242,314$242,314 1.8874 $457,343$0$0 1.5677 $0$0$0 1.0000 $0$242,314$242,314$457,343 2034 1,032,687 1,032,687 1.9639 2,028,095 0 0 1.6124 0 0 0 1.0000 0 1,032,687 1,032,687 2,028,095 2035 1,581,782 1,581,782 2.0434 3,232,214 46,888 46,888 1.6584 77,759 0 0 1.0000 0 1,628,670 1,628,670 3,309,972 2036 1,906,215 1,906,215 2.1262 4,052,993 51,197 51,197 1.7056 87,322 0 0 1.0000 0 1,957,412 1,957,412 4,140,315 2037 1,434,281 1,434,281 2.2123 3,173,059 33,094 33,094 1.7542 58,053 0 0 1.0000 0 1,467,374 1,467,374 3,231,112 2038 0 0 2.3019 0 0 0 1.8042 0 0 0 1.0000 0 0 0 0 2039 0 0 2.3951 0 0 0 1.8556 0 0 0 1.0000 0 0 0 0 2040 0 0 2.4921 0 0 0 1.9085 0 0 0 1.0000 0 0 0 0 2041 7,701,600 7,701,600 2.5930 19,970,249 5,791,948 5,791,948 1.9629 11,369,014 0 0 1.0000 0 13,493,548 13,493,548 31,339,263 2042 11,811,277 11,811,277 2.6981 31,868,008 8,882,609 8,882,609 2.0189 17,933,099 0 0 1.0000 0 20,693,886 20,693,886 49,801,107 2043 5,533,503 5,533,503 2.8073 15,534,202 4,161,441 4,161,441 2.0764 8,640,817 0 0 1.0000 0 9,694,944 9,694,944 24,175,019 2044 0 0 2.9210 0 0 0 2.1356 0 0 0 1.0000 0 0 0 0 2045 0 0 3.0393 0 0 0 2.1964 0 0 0 1.0000 0 0 0 0 2046 0 0 3.1624 0 0 0 2.2590 0 0 0 1.0000 0 0 0 0 2047 0 0 3.2905 0 0 0 2.3234 0 0 0 1.0000 0 0 0 0 2048 0 0 3.4238 0 0 0 2.3896 0 0 0 1.0000 0 0 0 0 2049 0 0 3.5624 0 0 0 2.4577 0 0 0 1.0000 0 0 0 0 2050 0 0 3.7067 0 0 0 2.5278 0 0 0 1.0000 0 0 0 0 2051 0 0 3.8568 0 0 0 2.5998 0 0 0 1.0000 0 0 0 0 2052 0 0 4.0130 0 0 0 2.6739 0 0 0 1.0000 0 0 0 0 2053 0 0 4.1756 0 0 0 2.7501 0 0 0 1.0000 0 0 0 0 2054 0 0 4.3447 0 0 0 2.8285 0 0 0 1.0000 0 0 0 0 2055 0 0 4.5206 0 0 0 2.9091 0 0 0 1.0000 0 0 0 0 2056 0 0 4.7037 0 0 0 2.9920 0 0 0 1.0000 0 0 0 0 2057 0 0 4.8942 0 0 0 3.0773 0 0 0 1.0000 0 0 0 0 2058 0 0 5.0924 0 0 0 3.1650 0 0 0 1.0000 0 0 0 0 2059 0 0 5.2987 0 0 0 3.2552 0 0 0 1.0000 0 0 0 0 2060 0 0 5.5133 0 0 0 3.3480 0 0 0 1.0000 0 0 0 0 2061 0 0 5.7366 0 0 0 3.4434 0 0 0 1.0000 0 0 0 0 2062 0 0 5.9689 0 0 0 3.5415 0 0 0 1.0000 0 0 0 0 2063 0 0 6.2106 0 0 0 3.6425 0 0 0 1.0000 0 0 0 0 2064 0 0 6.4622 0 0 0 3.7463 0 0 0 1.0000 0 0 0 0 2065 0 0 6.7239 0 0 0 3.8531 0 0 0 1.0000 0 0 0 0 2066 0 0 6.9962 0 0 0 3.9629 0 0 0 1.0000 0 0 0 0 2067 0 0 7.2795 0 0 0 4.0758 0 0 0 1.0000 0 0 0 0 2068 0 0 7.5744 0 0 0 4.1920 0 0 0 1.0000 0 0 0 0 2069 0 0 7.8811 0 0 0 4.3115 0 0 0 1.0000 0 0 0 0 2070 0 0 8.2003 0 0 0 4.4343 0 0 0 1.0000 0 0 0 0 2071 0 0 8.5324 0 0 0 4.5607 0 0 0 1.0000 0 0 0 0 2072 0 0 8.8780 0 0 0 4.6907 0 0 0 1.0000 0 0 0 0 2073 0 0 9.2375 0 0 0 4.8244 0 0 0 1.0000 0 0 0 0 2074 0 0 9.6117 0 0 0 4.9619 0 0 0 1.0000 0 0 0 0 2075 0 0 10.0009 0 0 0 5.1033 0 0 0 1.0000 0 0 0 0 2076 0 0 10.4060 0 0 0 5.2487 0 0 0 1.0000 0 0 0 0 2077 0 0 10.8274 0 0 0 5.3983 0 0 0 1.0000 0 0 0 0 2078 388,879 388,879 11.2659 4,381,072 573,163 573,163 5.5522 3,182,313 0 0 1.0000 0 962,042 962,042 7,563,385$31,632,537

$31,632,537$84,697,234$19,540,339$19,540,339$41,348,376$0$0$0$51,172,876$51,172,876$126,045,610 AMOUNT TO RECOVERCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalCost JurisdictionalJurisdictionalTotal Cost Total JurisdictionalTotal JurisdictionalEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inEscalationCost inEstimate Cost inCost inNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFactorFuture $'sNominal $sNominal $sFuture $'sLABORNON-LABORPIIC PaymentPrairie Island Unit 2Factors 2017 100.0000%4.05%2.85%0.00%2034$45,733$45,733 1.9639 $89,815$0$0 1.6124 $0$0$0 1.0000 $0$45,733$45,733$89,815 2035 340,602 340,602 2.0434 695,987 0-1.6584 -

0-1.0000 -

340,602 340,602 695,987 2036 1,956,513 1,956,513 2.1262 4,159,937 57,351 57,351 1.7056 97,817 0-1.0000 -

2,013,863 2,013,863 4,257,755 2037 2,463,904 2,463,904 2.2123 5,450,895 64,674 64,674 1.7542 113,451 0-1.0000 -

2,528,578 2,528,578 5,564,346 2038 1,261,871 1,261,871 2.3019 2,904,702 28,960 28,960 1.8042 52,250 0-1.0000 -

1,290,832 1,290,832 2,956,952 2039 0-2.3951 -

0-1.8556 -

0-1.0000 -

0 0-2040 0-2.4921 -

0-1.9085 -

0-1.0000 -

0 0-2041 8,961,247 8,961,247 2.5930 23,236,514

9,384,731 9,384,731 1.9629 18,421,288

0-1.0000 -

18,345,978 18,345,978 41,657,803

2042 13,743,089 13,743,089

2.6981 37,080,230

14,392,550 14,392,550

2.0189 29,057,118

0-1.0000 -

28,135,639 28,135,639 66,137,348

2043 6,438,543 6,438,543 2.8073 18,074,922

6,742,811 6,742,811 2.0764 14,000,773

0-1.0000 -

13,181,354 13,181,354 32,075,695

2044 0-2.9210 -

0-2.1356 -

0-1.0000 -

0 0-2045 0-3.0393 -

0-2.1964 -

0-1.0000 -

0 0-2046 0-3.1624 -

0-2.2590 -

0-1.0000 -

0 0-2047 0-3.2905 -

0-2.3234 -

0-1.0000 -

0 0-2048 0-3.4238 -

0-2.3896 -

0-1.0000 -

0 0-2049 0-3.5624 -

0-2.4577 -

0-1.0000 -

0 0-2050 0-3.7067 -

0-2.5278 -

0-1.0000 -

0 0-2051 0-3.8568 -

0-2.5998 -

0-1.0000 -

0 0-2052 0-4.0130 -

0-2.6739 -

0-1.0000 -

0 0-2053 0-4.1756 -

0-2.7501 -

0-1.0000 -

0 0-2054 0-4.3447 -

0-2.8285 -

0-1.0000 -

0 0-2055 0-4.5206 -

0-2.9091 -

0-1.0000 -

0 0-2056 0-4.7037 -

0-2.9920 -

0-1.0000 -

0 0-2057 0-4.8942 -

0-3.0773 -

0-1.0000 -

0 0-2058 0-5.0924 -

0-3.1650 -

0-1.0000 -

0 0-2059 0-5.2987 -

0-3.2552 -

0-1.0000 -

0 0-2060 0-5.5133 -

0-3.3480 -

0-1.0000 -

0 0-2061 0-5.7366 -

0-3.4434 -

0-1.0000 -

0 0-2062 0-5.9689 -

0-3.5415 -

0-1.0000 -

0 0-2063 0-6.2106 -

0-3.6425 -

0-1.0000 -

0 0-2064 0-6.4622 -

0-3.7463 -

0-1.0000 -

0 0-2065 0-6.7239 -

0-3.8531 -

0-1.0000 -

0 0-2066 0-6.9962 -

0-3.9629 -

0-1.0000 -

0 0-2067 0-7.2795 -

0-4.0758 -

0-1.0000 -

0 0-2068 0-7.5744 -

0-4.1920 -

0-1.0000 -

0 0-2069 0-7.8811 -

0-4.3115 -

0-1.0000 -

0 0-2070 0-8.2003 -

0-4.4343 -

0-1.0000 -

0 0-2071 0-8.5324 -

0-4.5607 -

0-1.0000 -

0 0-2072 0-8.8780 -

0-4.6907 -

0-1.0000 -

0 0-2073 0-9.2375 -

0-4.8244 -

0-1.0000 -

0 0-2074 0-9.6117 -

0-4.9619 -

0-1.0000 -

0 0-2075 0-10.0009 -

0-5.1033 -

0-1.0000 -

0 0-2076 0-10.4060 -

0-5.2487 -

0-1.0000 -

0 0-2077 0-10.8274 -

0-5.3983 -

0-1.0000 -

0 0-2078 388,879 388,879 11.2659 4,381,072 573,163 573,163 5.5522 3,182,313 0-1.0000 -

962,042 962,042 7,563,385 $35,600,382

$35,600,382$96,074,074$31,244,239$31,244,239$64,925,010$0$0$0$66,844,621$66,844,621$160,999,084$114,030,337$114,030,337$304,796,147$75,311,094$75,311,094$161,189,169$0$0$0$189,341,431$189,341,431$465,985,316

NSP-MinnesotaNRC Biennial Trust Funding Status Report Trust Fund Balance - By Components December 31, 2017Balances as of January 01, 2018External QualifiedMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological378,669,503 347,141,319 325,712,935 120,587,213 130,309,391 119,515, 792 499,256, 716 477,450, 711 445,228, 727 Spent Fuel302,483,051 54,088,123 114,116,923 96,325,656 20,303,519 41,873, 604 398,808, 706 74,391, 642 155,990, 526 Site Restoration35,405,979 8,982,754 24,228,870 11,275,026 3,371,933 8,890, 444 46,681, 005 12,354, 687 33,119, 314 Total716,558,532 410,212,196 464,058,728 228,187,895 153,984,843 170,279, 839 944,746, 427 564,197, 039 634,338, 566 Book ValueMarket AdjustmentMarket Value NSP-MinnesotaNRC Biennial Trust Funding Status ReportTrust Fund Balances - By JurisdictionDecember 31, 2017Balances as of January 01, 2018External QualifiedMontiPI1PI2MontiPI1PI2MontiPI1PI2MN Retail 528,235,230 302,500,490 342,906,311 168,614,668 113,662,824 125,949,623 696,849,897 416,163,314 468,855,935 ND Retail 35,062,616 22,805,577 24,534,512 11,956,032 8,458,419 9,338,986 47,018,648 31,263,996 33,873,499 SD Retail 22,756,363 17,014,887 18,976,893 7,805,848 6,420,136 7,297,136 30,562,211 23,435,023 26,274,028 MN FERC 9,617,440 7,420,284 7,016,791 3,722,494 3,070,325 2,597,462 13,339,934 10,490,609 9,614,254 WI FERC 10,206,295 5,989,707 5,656,568 3,155,446 476,973 1,939,051 13,361,741 6,466,681 7,595,619 WI Retail 110,680,588 54,481,251 64,967,652 32,933,408 21,896,166 23,157,580 143,613,996 76,377,417 88,125,232 Total 716,558,532 410,212,196 464,058,728 228,187,895 153,984,843 170,279,839 944,746,427 564,197,040 634,338,567 Book ValueMarket AdjustMarket Value NSP-MinnesotaNRC Biennial Trust Funding Status Report Trust Fund Balance - By Components December 31, 2018Balances as of January 01, 2019External QualifiedMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological406,139,614 388,699,389 365,060,139 90,312,724 103,916,655 95,941, 983 496,452, 338 492,616, 045 461,002, 122 Spent Fuel303,801,873 30,625,197 94,422,452 67,556,017 8,187,479 24,815, 301 371,357, 890 38,812, 676 119,237, 754 Site Restoration35,560,349 5,086,119 20,047,415 7,907,507 1,359,746 5,268, 690 43,467, 856 6,445, 865 25,316, 105 Total745,501,835 424,410,705 479,530,006 165,776,248 113,463,880 126,025, 974 911,278, 084 537,874, 585 605,555, 981 Book ValueMarket AdjustmentMarket Value NSP-MinnesotaNRC Biennial Trust Funding Status Report Trust Fund Balances - By Jurisdiction December 31, 2018Balances as of January 01, 2019External QualifiedMontiPI1PI2MontiPI1PI2MontiPI1PI2MN Retail549,440,454 312,661,446 353,792,263 122,587,181 83,790,898 93,269,721 672,027,635 396,452,344 447,061,985 ND Retail35,864,045

23,565,180 25,278,102 8,884,048 6,214,515 6,980,242 44,748,093 29,779,696 32,258,345 SD Retail23,917,254

17,729,361 19,828,626 5,774,851 4,730,160 5,452,921 29,692,105 22,459,521 25,281,547 MN FERC9,766,084 7,675,168 7,227,843 2,855,131 2,317,385 1,927,984 12,621,216 9,992,553 9,155,827 WI FERC10,355,182

6,146,825 5,823,307 2,286,665 12,842 1,410,139 12,641,847 6,159,666 7,233,446 WI Retail116,158,816 56,632,725 67,579,864 23,388,373 16,398,080 16,984,966 139,547,189 73,030,805 84,564,831 Total745,501,835 424,410,705 479,530,006 165,776,248 113,463,880 126,025,974 911,278,084 537,874,585 605,555,981 Book ValueMarket AdjustMarket Value