ML17087A246

From kanterella
Revision as of 20:57, 29 June 2018 by StriderTol (talk | contribs) (Created page by program invented by StriderTol)
Jump to navigation Jump to search
Prairie Island and Monticello - Decommissioning Funding Status Reports
ML17087A246
Person / Time
Site: Monticello, Prairie Island  Xcel Energy icon.png
Issue date: 03/28/2017
From: Murphy M C
Northern States Power Co, Xcel Energy
To:
Document Control Desk, Office of Nuclear Reactor Regulation
References
L-XE-17-004
Download: ML17087A246 (26)
v • d • e


Text

414 Nicollet Mall Minneapolis, MN 55401 800.895.4999 xcelenergy.com March 28, 2017 ATTN: Document Control Desk U.S. Nuclear Regulatory Commission Washington, DC 20555-0001 Prairie Island Nuclear Generating Plant, Units 1 and 2 Docket 50-282 and 50-306 Renewed Facility Operating License Nos. DPR-42 and DPR-60 Decommissioning Funding Status Reports (l Xce/ Energy* RESPONSIBLE BY NATURE L-XE-17-004 10 CFR 50. 75(f)(1)

Monticello Nuclear Generating Plant Docket 50-263 Renewed Facility Operating License No. DPR-22 Northern States Power Company, a Minnesota corporation (NSPM) d/b/a Xcel Energy, hereby submits the enclosed decommissioning funding status reports in accordance with 10 CFR 50.75(f)(1) for the above listed plants. The financial information presented is current as of December 31, 2016. Summary of Commitments This letter makes no new commitments and no revisions to existing commitments.

Director, Nuclear Licensing and Regulatory Services Northern States Power Company-Minnesota Enclosures (8) cc: Administrator, Region Ill, USNRC Project Manager, Monticello, USNRC Project Manager, Prairie Island, USNRC Resident Inspector, Monticello, USNRC Resident Inspector, Prairie Island, USNRC

Levelized (beginning of year payment, mid year interest)ANNUAL ACCRUAL SUMMARY2014-2015 2016+OperationalOperationalPost-ShutdownPresentRecovered2016-2018RemainingEarningsEarningsEarningsValue toThroughDecommissioningLife (yrs)RateRateRateDecommission12/31/2016Accrual(7)(8)(9)(9)(6)(12)(13) Monticello13.755.35%6.20%5.51%$1,213,177,556$498,602,413 6,030,008

Prairie Island Unit 116.805.50%6.24%5.35%958,156,562358,639,700 486,428 Prairie Island Unit 217.805.53%6.30%5.23%1,164,842,945395,626,6401,535,107 TOTAL DECOMMISSIONING ACCRUAL$3,336,177,063$1,252,868,754$8,051,544INPUT DATA Escalation Rate (Operation/Radiological)4.36% (a)Escalation Rate (ISFSI/Site Restoration)3.36% (a)Jurisdictional Factor100.0000% (b)IRS Tax Qualified Percent100.00% (c)External Percent100.00% (d)NOTES Input Data(a) = Inflation rate from current filing documentation(b) = 2014 Minnesota jurisdictional percent from 2013 electric rate case(c) = IRS qualifying percent based upon 2005 Energy Policy Act(d) = Recommended external funding Amount to Recover(1) = Current cost estimate by year from TLG Cost Study, 2014.(2) = Jurisdictional Nominal Cost = (1) x (b)(3) = Escalation factor based upon the applicable escalation rate for future value calculation(4) = Future Value of jurisdictional nominal cost(5) = Discount factor based upon the applicable earnings rate for present value calculation(6) = Present value to decommission at the start of 2015Decommissioning Accrual(7) = Remaining life as of 1/1/15 based on E,G002/D-14-181(8) = Fund earnings rate approved in 2011 Triennial Decommissioning Filing(9) = Fund earnings rates proposed in 2014 Triennial Decommissioning Filing(10) = Total Market Value Fund Balance as of June 30, 2014(11) = Tax Effect Adjustment from Schedule G(12) = (10) - (11)

Levelized (beginning of year payment, mid year interest)AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6) Monticello4.36%Factors2014100.0000%3.36%5.51%20302030$19,421,458$19,421,4581.9795 $38,444,7760.94778$36,437,190 203181,247,30481,247,3042.0658 167,840,6820.89828150,767,927 2032150,680,711150,680,7112.1558 324,837,4780.85137276,556,883 2033114,879,541114,879,5412.2498 258,455,9900.80691208,550,723 203472,315,16872,315,1682.3479 169,788,7840.76477129,849,368 203555,823,10955,823,1092.4503 136,783,3640.7248399,144,686 203610,920,49910,920,4992.5571 27,924,8080.6869819,183,784 203710,890,66110,890,6612.6686 29,062,8190.6511018,922,801 203810,890,66110,890,6612.7850 30,330,4920.6171018,716,947 203910,890,66110,890,6612.9064 31,652,6180.5848818,512,983 204010,920,49910,920,4993.0331 33,122,9650.5543318,361,053 204110,890,66110,890,6613.1653 34,472,2100.5253818,111,010 204210,890,66110,890,6613.3033 35,975,1220.4979517,913,812 204310,890,66110,890,6613.4474 37,544,4660.4719417,718,735 204410,920,49910,920,4993.5977 39,288,679 0.4473017,573,826 204529,586,13729,586,1373.7545 111,081,1530.4239447,091,744 204651,267,60451,267,6043.9182 200,876,7260.4018080,712,268 20477,088,9497,088,9494.0891 28,987,4210.3808211,038,990 2048108,754108,7544.2674 464,0960.36093167,5062049004.4534 00.3420802050004.6476 00.3242202051004.8502 00.3072802052005.0617 00.2912402053005.2824 00.2760302054005.5127 00.2616102055003.8766 00.2479502056004.0069 00.2350002057004.1415 00.2227302058004.2807 00.2111002059004.4245 00.2000702060004.5731 00.1896302061004.7268 00.1797202062004.8856 00.1703402063005.0498 00.1614402064005.2195 00.1530102065005.3948 00.1450202066005.5761 00.1374502067005.7635 00.1302702068005.9571 00.1234702069006.1573 00.1170202070006.3641 00.1109102071006.5780 00.1051202072006.7990 00.0996302073007.0274 00.0944202074007.2636 00.0894902075007.5076 00.0848202076007.7599 00.0803902077008.0206 20.0761902078008.2901 20.0722102079008.5687 20.0684402080008.8566 30.0648702081009.1541 30.0614802082009.4617 30.0582702083009.7796 30.05523020840010.1082 30.05234020850010.4479 30.04961020860010.7989 30.04702020870011.1618 30.04456020880011.5368 30.04224020890011.9244 30.04003020909,602,1199,602,11912.3251 118,347,0800.037944,490,088 20917,324,2007,324,20012.7392 93,304,4450.035963,355,228$697,450,523$697,450,523$1,948,586,209$1,213,177,556 Levelized (beginning of year payment, mid year interest)AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6) Prairie Island Unit 14.36%Factors2014100.0000%3.36%5.35%20332033$25,245,893$25,245,8932.2498 $56,798,2100.94922$53,913,997 203477,617,36177,617,3612.3479 182,237,8010.90101164,198,081 2035115,513,707115,513,7072.4503 283,043,2370.85526242,075,559 203691,518,68791,518,6872.5571 234,022,4350.81182189,984,093 203747,443,75647,443,7562.6686 126,608,4090.7706097,564,440 20384,921,6724,921,6722.7850 13,706,8580.7314610,026,018 20394,921,6724,921,6722.9064 14,304,3490.694329,931,796 20404,935,1574,935,1573.0331 14,968,8230.659069,865,353 20414,921,6724,921,6723.1653 15,578,5700.625599,745,798 20424,921,6724,921,6723.3033 16,257,7610.593829,654,183 20434,921,6724,921,6723.4474 16,966,9740.563669,563,604 20444,935,1574,935,1573.5977 17,755,2130.535049,499,749 20454,921,6724,921,6723.7545 18,478,4190.507879,384,635 20464,921,6724,921,6723.9182 19,284,0970.482089,296,478 20474,921,6724,921,6724.0891 20,125,2110.457609,209,297 20484,935,1574,935,1574.2674 21,060,2870.434369,147,746 204910,851,62410,851,6244.4534 48,326,6230.4123019,925,067205032,935,33032,935,3304.6476 153,070,2400.3913659,905,569 20518,553,2528,553,252 4.8502 41,484,9850.3714915,411,257 205296,31096,3105.0617 487,4920.35262171,899205345,26045,2605.2824 239,0840.3347180,0242054003.7506 00.3177202055003.8766 00.3015802056004.0069 00.2862702057004.1415 00.2717302058004.2807 00.2579302059004.4245 00.2448302060004.5731 00.2324002061004.7268 00.2206002062004.8856 00.2093902063005.0498 00.1987602064005.2195 00.1886702065005.3948 00.1790902066005.5761 00.1699902067005.7635 00.1613602068005.9571 00.1531602069006.1573 00.1453902070006.3641 00.1380002071006.5780 00.1309902072006.7990 00.1243402073007.0274 00.1180302074007.2636 00.1120302075007.5076 00.1063402076007.7599 00.100940207711,050,24611,050,2468.0206 88,629,6030.095828,492,489 20781,471,4251,471,4258.2901 12,198,2570.090951,109,432$476,521,702$476,521,702$1,415,632,938$958,156,562 Levelized (beginning of year payment, mid year interest)AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6) Prairie Island Unit 24.36%Factors2014100.0000%3.36%5.23%20342034$9,569,898$9,569,8982.3479 $22,469,1620.95030$21,352,445 203560,329,25860,329,258

2.4503 147,824,780 0.90307133,496,124 2036109,834,268109,834,268 2.5571 280,857,207 0.85819241,028,846 2037107,666,243107,666,243 2.6686 287,318,136 0.81553234,316,559 203891,781,50391,781,503

2.7850 255,611,487 0.77500198,098,902 203915,058,91715,058,917

2.9064 43,767,237

0.7364832,233,695 20409,199,7259,199,725

3.0331 27,903,686

0.6998819,529,232 20419,174,5899,174,589

3.1653 29,040,327

0.6650919,314,431 20429,174,5899,174,589

3.3033 30,306,420

0.6320419,154,870 20439,174,5899,174,589

3.4474 31,628,479

0.6006318,997,013 20449,199,7259,199,725

3.5977 33,097,851

0.5707718,891,260 20459,174,5899,174,589

3.7545 34,445,995

0.5424118,683,852 20469,174,5899,174,589

3.9182 35,947,875

0.5154518,529,332 20479,174,5899,174,589

4.0891 37,515,812

0.4898318,376,370 20489,199,7259,199,725

4.2674 39,258,906 0.4654918,274,628 204915,195,16315,195,163

4.4534 67,670,140

0.4423529,933,886 205038,137,30538,137,305

4.6476 177,246,938 0.4203774,509,296 205110,590,65610,590,656

4.8502 51,366,801

0.3994720,519,496 205241,18341,183 5.0617 208,456 0.3796279,134205319,35419,354 5.2824 102,234 0.3607536,88120540-3.7506 -

0.34282020550-3.8766 -

0.32578020560-4.0069 -

0.30959020570-4.1415 -

0.29421020580-4.2807 -

0.27958020590-4.4245 -

0.26569020600-4.5731 -

0.25248020610-4.7268 -

0.23993020620-4.8856 -

0.22801020630-5.0498 -

0.21668020640-5.2195 -

0.20591020650-5.3948 -

0.19567020660-5.5761 -

0.18595020670-5.7635 -

0.17671020680-5.9571 -

0.16792020690-6.1573 -

0.15958020700-6.3641 -

0.15165020710-6.5780 -

0.14411020720-6.7990 -

0.13695020730-7.0274 -

0.13014020740-7.2636 -

0.12367020750-7.5076 -

0.11753020760-7.7599 -

0.11169020779,698,4769,698,476

8.0206 77,787,597

0.106148,256,376 20781,471,4251,471,425 8.2901 12,198,257

0.100861,230,316$552,040,358$552,040,358$1,723,573,783$1,164,842,945$1,726,012,583$1,726,012,583$5,087,792,930$3,336,177,063

Levelized (beginning of year payment, mid year interest)ANNUAL ACCRUAL SUMMARY2014-2015 2016+OperationalOperationalPost-ShutdownPresentRecovered2016-2018RemainingEarningsEarningsEarningsValue toThroughDecommissioningLife (yrs)RateRateRateDecommission12/31/2016Accrual(7)(8)(9)(9)(6)(12)(13) Monticello13.755.35%6.20%5.51%$699,618,123$287,535,22812,011,286

Prairie Island Unit 116.805.50%6.24%5.35%418,287,633112,861,720 0 Prairie Island Unit 217.805.53%6.30%5.23%536,519,944132,277,319 0 TOTAL DECOMMISSIONING ACCRUAL$1,654,425,700

$532,674,267$12,011,286INPUT DATA Escalation Rate (Operation/Radiological)4.36% (a)Escalation Rate (ISFSI/Site Restoration)3.36% (a)Jurisdictional Factor100.0000% (b)IRS Tax Qualified Percent100.00% (c)External Percent100.00% (d)NOTES Input Data(a) = Inflation rate from current filing documentation(b) = 2014 Minnesota jurisdictional percent from 2013 electric rate case(c) = IRS qualifying percent based upon 2005 Energy Policy Act(d) = Recommended external funding Amount to Recover(1) = Current cost estimate by year from TLG Cost Study, 2014.(2) = Jurisdictional Nominal Cost = (1) x (b)(3) = Escalation factor based upon the applicable escalation rate for future value calculation(4) = Future Value of jurisdictional nominal cost(5) = Discount factor based upon the applicable earnings rate for present value calculation(6) = Present value to decommission at the start of 2015Decommissioning Accrual(7) = Remaining life as of 1/1/15 based on E,G002/D-14-181(8) = Fund earnings rate approved in 2011 Triennial Decommissioning Filing(9) = Fund earnings rates proposed in 2014 Triennial Decommissioning Filing(10) = Total Market Value Fund Balance as of June 30, 2014(11) = Tax Effect Adjustment from Schedule G(12) = (10) - (11)

Levelized (beginning of year payment, mid year interest)AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6) Monticello4.36%Factors2014100.0000%3.36%5.51%20302030$10,567,348$10,567,3481.9795 $20,918,0660.94778$19,825,725 203124,394,72424,394,7242.0658 50,394,6210.8982845,268,480 20324,030,0614,030,0612.1558 8,688,0050.851377,396,707 203311,272,00211,272,0022.2498 25,359,7510.8069120,463,037 203418,842,51118,842,5112.3479 44,240,3320.7647733,833,678 203526,231,30726,231,3072.4503 64,274,5720.7248346,588,138 20368,706,7968,706,7962.5571 22,264,1470.6869815,295,024 20378,683,1748,683,1742.6686 23,171,9190.6511015,087,236 20388,683,1748,683,1742.7850 24,182,6400.6171014,923,107 20398,683,1748,683,1742.9064 25,236,7770.5848814,760,486 20408,706,7968,706,7963.0331 26,408,5820.5543314,639,069 20418,683,1748,683,1743.1653 27,484,8510.5253814,439,991 20428,683,1748,683,1743.3033 28,683,1290.4979514,282,764 20438,683,1748,683,1743.4474 29,934,3750.4719414,127,229 20448,706,7968,706,7963.5977 31,324,438 0.4473014,011,421 204540,014,15840,014,1583.7545 150,233,1580.4239463,689,845 20469,061,8529,061,8523.9182 35,506,1480.4018014,266,370 20475,513,2945,513,2944.0891 22,544,4120.380828,585,363 20486,850,9356,850,9354.2674 29,235,6780.3609310,552,033 20495,989,2125,989,2124.4534 26,672,3570.342089,124,080 205014,680,01814,680,0184.6476 68,226,8500.3242222,120,509 205119,430,50019,430,5004.8502 94,241,8130.3072828,958,624 205211,529,27011,529,2705.0617 58,357,7050.2912416,996,098 205317,847,00617,847,0065.2824 94,275,0250.2760326,022,735 205422,597,48922,597,4895.5127 124,573,1770.2616132,589,589 20555,927,8365,927,8363.8766 22,979,8500.247955,697,854 20565,944,0775,944,0774.0069 23,817,3220.235005,597,071 20575,927,8365,927,8364.1415 24,550,1340.222735,468,051 20585,927,8365,927,8364.2807 25,375,2890.211105,356,723 20595,927,8365,927,8364.4245 26,227,7120.200075,247,378 20605,944,0775,944,0774.5731 27,182,8580.189635,154,68520615,927,8365,927,8364.7268 28,019,6970.179725,035,700 20625,927,8365,927,8364.8856 28,961,0370.170344,933,223 20635,927,8365,927,8365.0498 29,934,3880.161444,832,60820645,944,0775,944,0775.2195 31,025,1100.153014,747,152 20655,927,8365,927,8365.3948 31,979,4910.145024,637,666 20665,927,8365,927,8365.5761 33,054,2080.137454,543,301 20675,927,8365,927,8365.7635 34,165,0850.130274,450,686 20685,944,0775,944,0775.9571 35,409,4610.123474,372,006 20695,927,8365,927,8366.1573 36,499,4670.117024,271,168 20705,927,8365,927,8366.3641 37,725,3430.110914,184,118 20715,927,8365,927,8366.5780 38,993,3070.105124,098,976 20725,944,0775,944,0776.7990 40,413,7790.099634,026,425 20735,927,8365,927,8367.0274 41,657,2770.094423,933,280 20745,927,8365,927,8367.2636 43,057,4320.089493,853,210 20755,927,8365,927,8367.5076 44,503,8240.084823,774,814 20765,944,0775,944,0777.7599 46,125,4430.080393,708,024 20776,866,2806,866,2808.0206 55,071,6850.076194,195,912 20788,212,3668,212,3668.2901 68,081,3390.072214,916,153 20797,876,0277,876,0278.5687 67,487,3160.068444,618,832 20807,892,9987,892,9988.8566 69,905,1270.064874,534,746 20817,876,0277,876,0279.1541 72,097,9420.061484,432,581 20828,212,3668,212,3669.4617 77,702,9470.058274,527,751 20837,876,0277,876,0279.7796 77,024,3970.055234,254,057 20847,892,9987,892,99810.1082 79,784,0040.052344,175,895 20857,876,0277,876,02710.4479 82,287,9460.049614,082,305 20868,212,3668,212,36610.7989 88,684,5240.047024,169,946 20877,876,0277,876,02711.1618 87,910,6420.044563,917,298 208810,348,02810,348,02811.5368 119,383,1290.042245,042,743 20897,876,0277,876,02711.9244 93,916,9000.040033,759,494 20906,867,0106,867,01012.3251 84,636,5860.037943,211,112 209117,11217,11212.7392 217,9900.035967,839$569,358,652$569,358,652$3,012,282,516$699,618,123 Levelized (beginning of year payment, mid year interest)AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6) Prairie Island Unit 14.36%Factors2014100.0000%3.36%5.35%20332033$850,895$850,8952.2498 $1,914,3430.94922$1,817,132 20343,925,7603,925,7602.3479 9,217,2920.901018,304,873 203516,628,75916,628,7592.4503 40,745,4490.8552634,847,953 203613,332,02613,332,0262.5571 34,091,3230.8118227,676,018 203712,450,12212,450,1222.6686 33,224,3950.7706025,602,719 20382,238,4602,238,4602.7850 6,234,1120.731464,560,003 20398,891,0968,891,0962.9064 25,841,0810.6943217,941,980 20402,244,5932,244,5933.0331 6,808,0750.659064,486,930 204115,543,73215,543,7323.1653 49,200,5740.6255930,779,387 20422,238,4602,238,4603.3033 7,394,3060.593824,390,887 204315,543,73215,543,7323.4474 53,585,4610.5636630,203,981 20442,244,5932,244,5933.5977 8,075,3720.535044,320,647 204515,543,73215,543,7323.7545 58,358,9410.5078729,638,755 20462,238,4602,238,4603.9182 8,770,7350.482084,228,196 204715,543,73215,543,7324.0891 63,559,8730.4576029,084,998 20482,244,5932,244,5934.2674 9,578,5760.434364,160,550 204922,042,53222,042,5324.4534 98,164,2140.4123040,473,1052050935,936935,9364.6476 4,349,8550.391361,702,359 20512,304,7132,304,713 4.8502 11,178,3180.371494,152,633 20523,418,9263,418,9265.0617 17,305,5790.352626,102,293 20533,825,8773,825,8775.2824 20,209,8130.334716,764,427 20544,365,0434,365,0433.7506 16,371,5300.317725,201,562 20554,028,7044,028,7043.8766 15,617,6730.301584,709,978 20564,542,8684,542,8684.0069 18,202,8170.286275,210,920 20574,028,7044,028,7044.1415 16,684,8770.271734,533,782 20583,860,5343,860,5344.2807 16,525,7890.257934,262,497 20594,196,8734,196,8734.4245 18,569,0660.244834,546,264 20604,038,3594,038,3594.5731 18,467,8200.232404,291,921 20614,196,8734,196,8734.7268 19,837,7810.220604,376,214 20624,196,8734,196,8734.8856 20,504,2440.209394,293,384 20634,196,8734,196,8735.0498 21,193,3710.198764,212,394 20644,038,3594,038,3595.2195 21,078,2150.188673,976,827 20654,196,8734,196,8735.3948 22,641,2920.179094,054,829 20664,196,8734,196,8735.5761 23,402,1850.169993,978,137 20674,028,7044,028,7045.7635 23,219,4340.161363,746,688 20684,206,5294,206,5295.9571 25,058,7120.153163,837,992 20694,196,8734,196,8736.1573 25,841,4080.145393,757,082 20704,028,7044,028,7046.3641 25,639,0740.138003,538,192 20714,196,8734,196,8736.5780 27,607,0330.130993,616,245 20724,206,5294,206,5296.7990 28,600,1880.124343,556,147 20734,028,7044,028,7047.0274 28,311,3130.118033,341,584 20744,196,8734,196,8737.2636 30,484,4090.112033,415,168 20755,424,3885,424,3887.5076 40,724,1370.106344,330,605 20764,038,3594,038,3597.7599 31,337,2630.100943,163,183 20774,028,7204,028,7208.0206 32,312,7490.095823,096,208 2078008.2901 00.090950$264,895,795$264,895,795$1,136,040,066$418,287,633 Levelized (beginning of year payment, mid year interest)AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6) Prairie Island Unit 24.36%Factors2014100.0000%3.36%5.23%20342034$3,438,926$3,438,9262.3479 $8,074,2550.95030$7,672,965 203518,303,29718,303,297

2.4503 44,848,570

0.9030740,501,398 203610,762,92010,762,920

2.5571 27,521,863

0.8581923,618,988 20378,261,3458,261,345

2.6686 22,046,225

0.8155317,979,358 20386,026,5106,026,510

2.7850 16,783,831

0.7750013,007,469 203912,670,32612,670,326

2.9064 36,825,035

0.7364827,120,902 20406,545,1286,545,128

3.0331 19,852,028

0.6998813,894,038 204119,832,51719,832,517

3.1653 62,775,866

0.6650941,751,600 20426,527,2456,527,245

3.3033 21,561,450

0.6320413,627,699 204319,832,51719,832,517

3.4474 68,370,619

0.6006341,065,445 20446,545,1286,545,128

3.5977 23,547,408

0.5707713,440,154 204519,832,51719,832,517

3.7545 74,461,185

0.5424140,388,491 20466,527,2456,527,245

3.9182 25,575,053

0.5154513,182,661 204719,832,51719,832,517

4.0891 81,097,145

0.4898339,723,814 20486,545,1286,545,128

4.2674 27,930,680 0.4654913,001,452 204925,579,31125,579,311

4.4534 113,914,905 0.4423550,390,258 2050935,936935,936 4.6476 4,349,855

0.420371,828,549 20512,304,7132,304,713

4.8502 11,178,318

0.399474,465,403 20523,418,9263,418,926

5.0617 17,305,579

0.379626,569,544 20533,825,8773,825,877

5.2824 20,209,813

0.360757,290,690 20544,365,0434,365,043

3.7506 16,371,530

0.342825,612,488 20554,028,7044,028,704

3.8766 15,617,673

0.325785,087,926 20564,542,8684,542,868

4.0069 18,202,817

0.309595,635,410 20574,028,7044,028,704

4.1415 16,684,877

0.294214,908,858 20583,860,5343,860,534

4.2807 16,525,789

0.279584,620,280 20594,196,8734,196,873

4.4245 18,569,066

0.265694,933,615 20604,038,3594,038,359

4.5731 18,467,820

0.252484,662,755 20614,196,8734,196,873

4.7268 19,837,781

0.239934,759,679 20624,196,8734,196,873

4.8856 20,504,244

0.228014,675,173 20634,196,8734,196,873

5.0498 21,193,371

0.216684,592,180 20644,038,3594,038,359

5.2195 21,078,215

0.205914,340,215 20654,196,8734,196,873

5.3948 22,641,292

0.195674,430,222 20664,196,8734,196,873

5.5761 23,402,185

0.185954,351,636 20674,028,7044,028,704

5.7635 23,219,434

0.176714,103,106 20684,206,5294,206,529

5.9571 25,058,712

0.167924,207,859 20694,196,8734,196,873

6.1573 25,841,408

0.159584,123,772 20704,028,7044,028,704

6.3641 25,639,074

0.151653,888,166 20714,196,8734,196,873

6.5780 27,607,033 0.144113,978,449 20724,206,5294,206,529

6.7990 28,600,188

0.136953,916,796 20734,028,7044,028,704

7.0274 28,311,313

0.130143,684,434 20744,196,8734,196,873

7.2636 30,484,409

0.123673,770,007 20755,424,3885,424,388

7.5076 40,724,137

0.117534,786,308 20764,038,3594,038,359

7.7599 31,337,263

0.111693,500,059 20774,028,7204,028,720

8.0206 32,312,749

0.106143,429,675 20780-8.2901 -

0.100860$308,213,097$308,213,097$1,296,462,060$536,519,944$1,142,467,544$1,142,467,544$5,444,784,641$1,654,425,700

Levelized (beginning of year payment, mid year interest)ANNUAL ACCRUAL SUMMARY2014-2015 2016+OperationalOperationalPost-ShutdownPresentRecovered2016-2018RemainingEarningsEarningsEarningsValue toThroughDecommissioningLife (yrs)RateRateRateDecommission12/31/2016Accrual(7)(8)(9)(9)(6)(12)(13) Monticello13.755.35%6.20%5.51%$62,155,871$25,545,368308,915 Prairie Island Unit 116.805.50%6.24%5.35%83,785,02422,606,745 0 Prairie Island Unit 217.805.53%6.30%5.23%109,781,88027,066,380 0 TOTAL DECOMMISSIONING ACCRUAL

$255,722,774$75,218,493$308,915INPUT DATA Escalation Rate (Operation/Radiological)4.36% (a)Escalation Rate (ISFSI/Site Restoration)3.36% (a)Jurisdictional Factor100.0000% (b)IRS Tax Qualified Percent100.00% (c)External Percent100.00% (d)NOTES Input Data(a) = Inflation rate from current filing documentation(b) = 2014 Minnesota jurisdictional percent from 2013 electric rate case(c) = IRS qualifying percent based upon 2005 Energy Policy Act(d) = Recommended external funding Amount to Recover(1) = Current cost estimate by year from TLG Cost Study, 2014.(2) = Jurisdictional Nominal Cost = (1) x (b)(3) = Escalation factor based upon the applicable escalation rate for future value calculation(4) = Future Value of jurisdictional nominal cost(5) = Discount factor based upon the applicable earnings rate for present value calculation(6) = Present value to decommission at the start of 2015Decommissioning Accrual(7) = Remaining life as of 1/1/15 based on E,G002/D-14-181(8) = Fund earnings rate approved in 2011 Triennial Decommissioning Filing(9) = Fund earnings rates proposed in 2014 Triennial Decommissioning Filing(10) = Total Market Value Fund Balance as of June 30, 2014(11) = Tax Effect Adjustment from Schedule G(12) = (10) - (11)

Levelized (beginning of year payment, mid year interest)AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6) Monticello4.36%Factors2014100.0000%3.36%5.51%20302030$152,968$152,9681.9795 $302,8010.94778$286,9882031589,490589,4902.0658 1,217,7680.898281,093,897 2032411,835411,8352.1558 887,8340.85137755,8752033163,437163,4372.2498 367,7000.80691296,70120344,2384,2382.3479 9,9500.764777,60920353,1003,1002.4503 7,5960.724835,5062036002.5571 00.6869802037002.6686 00.6511002038002.7850 00.6171002039002.9064 00.5848802040003.0331 00.5543302041003.1653 00.5253802042003.3033 00.4979502043003.4474 00.4719402044003.5977 00.4473002045003.7545 00.4239402046003.9182 00.401800204717,736,59717,736,5974.0891 72,526,7200.3808227,619,625 204820,321,93220,321,9324.2674 86,721,8120.3609331,300,503 2049004.4534 00.3420802050004.6476 00.3242202051004.8502 00.3072802052005.0617 00.2912402053005.2824 00.2760302054005.5127 00.2616102055003.8766 00.2479502056004.0069 00.2350002057004.1415 00.2227302058004.2807 00.2111002059004.4245 00.2000702060004.5731 00.1896302061004.7268 00.1797202062004.8856 00.1703402063005.0498 00.1614402064005.2195 00.1530102065005.3948 00.1450202066005.5761 00.1374502067005.7635 00.1302702068005.9571 00.1234702069006.1573 00.1170202070006.3641 00.1109102071006.5780 00.1051202072006.7990 00.0996302073007.0274 00.0944202074007.2636 00.0894902075007.5076 00.0848202076007.7599 00.0803902077008.0206 00.0761902078008.2901 00.0722102079008.5687 00.0684402080008.8566 00.0648702081009.1541 00.0614802082009.4617 00.0582702083009.7796 00.05523020840010.1082 00.05234020850010.4479 00.04961020860010.7989 00.04702020870011.1618 00.04456020880011.5368 00.04224020890011.9244 00.04003020900012.3251 00.03794020911,722,6881,722,68812.7392 21,945,6720.03596789,166$41,106,285$41,106,285$183,987,851$62,155,871 Levelized (beginning of year payment, mid year interest)AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6) Prairie Island Unit 14.36%Factors2014100.0000%3.36%5.35%20332033$258,731$258,7312.2498 $582,0940.94922$552,53520341,060,1501,060,1502.3479 2,489,1250.901012,242,727 20351,944,0881,944,0882.4503 4,763,5990.855264,074,116 20362,058,6132,058,6132.5571 5,264,0800.811824,273,486 20371,302,1851,302,1852.6686 3,475,0100.770602,677,843 203861,33461,3342.7850 170,8150.73146124,944203961,33461,3342.9064 178,2610.69432123,770204061,50261,5023.0331 186,5410.65906122,942204161,33461,3343.1653 194,1400.62559121,452204261,33461,3343.3033 202,6040.59382120,310204361,33461,3343.4474 211,4420.56366119,182204461,50261,5023.5977 221,2650.53504118,386204561,33461,3343.7545 230,2780.50787116,951204661,33461,3343.9182 240,3180.48208115,853204761,33461,3344.0891 250,8000.45760114,766204861,50261,5024.2674 262,4530.43436113,999204961,33461,3344.4534 273,1440.41230112,617205061,33461,3344.6476 285,0550.39136111,559205111,589,29711,589,297 4.8502 56,210,4100.3714920,881,605 205217,939,61517,939,6155.0617 90,804,9480.3526232,019,641 20538,430,6398,430,6395.2824 44,534,0060.3347114,905,977 2054003.7506 00.3177202055003.8766 00.3015802056004.0069 00.2862702057004.1415 00.2717302058004.2807 00.2579302059004.4245 00.2448302060004.5731 00.2324002061004.7268 00.2206002062004.8856 00.2093902063005.0498 00.1987602064005.2195 00.1886702065005.3948 00.1790902066005.5761 00.1699902067005.7635 00.1613602068005.9571 00.1531602069006.1573 00.1453902070006.3641 00.1380002071006.5780 00.1309902072006.7990 00.1243402073007.0274 00.1180302074007.2636 00.1120302075007.5076 00.1063402076007.7599 00.1009402077008.0206 00.0958202078822,778822,7788.2901 6,820,9140.09095620,362$46,203,941$46,203,941$217,851,305$83,785,024 Levelized (beginning of year payment, mid year interest)AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6) Prairie Island Unit 24.36%Factors2014100.0000%3.36%5.23%20342034$54,987$54,9872.3479 $129,1040.95030$122,6882035390,765390,765 2.4503 957,490 0.90307864,68120361,832,5181,832,518

2.5571 4,685,932

0.858194,021,420 20372,148,5882,148,588

2.6686 5,733,721

0.815534,676,021 20381,894,5351,894,535

2.7850 5,276,280

0.775004,089,117 2039191,918191,918 2.9064 557,791 0.73648410,802204061,50261,502 3.0331 186,541 0.69988130,557204161,33461,334 3.1653 194,140 0.66509129,121204261,33461,334 3.3033 202,604 0.63204128,054204361,33461,334 3.4474 211,442 0.60063126,999204461,50261,502 3.5977 221,265 0.57077126,292204561,33461,334 3.7545 230,278 0.54241124,905204661,33461,334 3.9182 240,318 0.51545123,872204761,33461,334 4.0891 250,800 0.48983122,850204861,50261,502 4.2674 262,453 0.46549122,169204961,33461,334 4.4534 273,144 0.44235120,825205061,33461,334 4.6476 285,055 0.42037119,829205114,870,67214,870,672

4.8502 72,125,732

0.3994728,812,066 205223,028,52623,028,526

5.0617 116,563,490 0.3796244,249,832 205310,822,14910,822,149

5.2824 57,166,919

0.3607520,622,966 20540-3.7506 -

0.34282020550-3.8766 -

0.32578020560-4.0069 -

0.30959020570-4.1415 -

0.29421020580-4.2807 -

0.27958020590-4.4245 -

0.26569020600-4.5731 -

0.25248020610-4.7268 -

0.23993020620-4.8856 -

0.22801020630-5.0498 -

0.21668020640-5.2195 -

0.20591020650-5.3948 -

0.19567020660-5.5761 -

0.18595020670-5.7635 -

0.17671020680-5.9571 -

0.16792020690-6.1573 -

0.15958020700-6.3641 -

0.15165020710-6.5780 -

0.14411020720-6.7990 -

0.13695020730-7.0274 -

0.13014020740-7.2636 -

0.12367020750-7.5076 -

0.11753020760-7.7599 -

0.11169020770-8.0206 -

0.1061402078642,016642,016 8.2901 5,322,380

0.10086536,815$56,551,850$56,551,850$271,076,882$109,781,880$143,862,075$143,862,075$672,916,038$255,722,774

Balances as of January 01, 2016 Excluded from NRC calculation External QualifiedMontiPI1PI2MontiPI1PI2MontiPI1PI2All UnitsRadiological405,148,477 287,487,688 313,577,154 51,604,507 50,119,832 53,791,420 456,752,983 337,607,521 367,368,574 1,161,729,078

Spent Fuel233,641,989 90,470,617 104,844,166 29,759,410 15,772,405 17,985,100 263,401,399 106,243,021 122,829,267 492,473,687

Site Restoration20,757,354 18,121,699 21,453,051 2,643,902 3,159,288 3,680,083 23,401,257 21,280,988 25,133,134 69,815,379 Total659,547,820 396,080,005 439,874,371 84,007,819 69,051,525 75,456,604 743,555,639 465,131,530 515,330,976 1,724,018,144

External EscrowMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological8,781 29,837 54,615 16,799 (6,274)

(13,340) 25,580 23,563 41,275 90,418 Spent Fuel5,064 9,389 18,261 9,688 (1,974)

(4,460) 14,752 7,415 13,800 35,967 Site Restoration 450 1,881 3,736 861 (395)

(913) 1,311 1,485 2,824 5,620 Total14,295 41,107 76,612 27,348 (8,644)

(18,713) 41,643 32,463 57,899 132,005 Grand TotalMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological405,157,258 287,517,525 313,631,769 51,621,306 50,113,558 53,778,080 456,778,564 337,631,083 367,409,850 1,161,819,497

Spent Fuel233,647,053 90,480,006 104,862,427 29,769,098 15,770,430 17,980,640 263,416,150 106,250,437 122,843,067 492,509,654

Site Restoration20,757,804 18,123,580 21,456,787 2,644,763 3,158,893 3,679,171 23,402,567 21,282,473 25,135,958 69,820,999 Total659,562,115 396,121,112 439,950,984 84,035,167 69,042,881 75,437,891 743,597,281 465,163,993 515,388,875 1,724,150,149

Book ValueMarket AdjustmentMarket Value Balances as of January 01, 2016External QualifiedMontiPI1PI2MontiPI1PI2MontiPI1PI2MN Retail 486,466,245.47 292,642,194.12 326,089,262.08 62,236,661.95 50,979,934.66 55,802,670.01 548,702,907.42 343,622,128.78 381,891,932.09 ND Retail 33,482,174.88 22,093,438.17 23,410,497.91 4,705,637.15 3,748,795.98 4,266,330.11 38,187,812.03 25,842,234.15 27,676,828.02 SD Retail 20,471,827.10 16,180,110.25 17,565,867.01 3,185,343.13 2,906,182.08 3,393,103.91 23,657,170.23 19,086,292.33 20,958,970.92 MN FERC9,324,212.18 7,174,049.16 6,696,689.36 1,656,357.28 1,490,082.44 1,157,749.02 10,980,569.46 8,664,131.60 7,854,438.38 WI FERC9,911,815.61 5,837,935.23 5,401,951.27 1,085,896.58 (497,129.89) 801,557.33 10,997,712.19 5,340,805.34 6,203,508.60 WI Retail 99,891,544.42 52,152,277.69 60,710,103.86 11,137,922.86 10,423,660.00 10,035,193.72 111,029,467.28 62,575,937.69 70,745,297.58 Total 659,547,819.66 396,080,004.62 439,874,371.49 84,007,818.95 69,051,525.27 75,456,604.10 743,555,638.61 465,131,529.89 515,330,975.59 External EscrowMN Retail 7,417.14 27,991.87 49,035.44

24,566.94 (6,799.08)

(5,881.76)

31,984.08

21,192.79

43,153.68 WI FERC623.21 1,065.86 1,257.40 47.13 (355.04) (25.61) 670.34 710.82 1,231.79 ND Retail 4,233.24 2,926.43 15,255.36 (3,787.44)

(1,100.88)

(12,904.05)

445.80 1,825.55 2,351.31 WI Retail 2,021.29 9,122.95 11,064.12 6,521.27 (388.90) 98.36 8,542.56 8,734.05 11,162.48 Total 14,294.88

41,107.11 76,612.32

27,347.90 (8,643.90)

(18,713.06)

41,642.78

32,463.21

57,899.26 Internal- - - Grand Total 659,562,114.54 396,121,111.73 439,950,983.81 84,035,166.85 69,042,881.37 75,437,891.04 743,597,281.39 465,163,993.10 515,388,874.85 Book ValueMarket AdjustMarket Value Balances as of January 01, 2017 Excluded from NRC calculation External QualifiedMontiPI1PI2MontiPI1PI2MontiPI1PI2All UnitsRadiological420,228,430 287,702,094 319,772,014 78,373,983 70,937,606 75,854,626 498,602,413 358,639,700 395,626,640 1,252,868,754

Spent Fuel242,338,332 90,538,089 106,915,411 45,196,895 22,323,631 25,361,908 287,535,228 112,861,720 132,277,319 532,674,267

Site Restoration21,529,960 18,135,214 21,876,866 4,015,408 4,471,531 5,189,514 25,545,368 22,606,745 27,066,380 75,218,493 Total684,096,722 396,375,398 448,564,291 127,586,287 97,732,767 106,406,049 811,683,009 494,108,165 554,970,339 1,860,761,513

External EscrowMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological

-

-

-

-

-

-

-

-

-

-

Spent Fuel

-

-

-

-

-

-

-

-

-

-

Site Restoration

-

-

-

-

-

-

-

-

-

-

Total

-

-

-

-

-

-

-

-

-

-

Grand TotalMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological420,228,430 287,702,094 319,772,014 78,373,983 70,937,606 75,854,626 498,602,413 358,639,700 395,626,640 1,252,868,754

Spent Fuel242,338,332 90,538,089 106,915,411 45,196,895 22,323,631 25,361,908 287,535,228 112,861,720 132,277,319 532,674,267

Site Restoration21,529,960 18,135,214 21,876,866 4,015,408 4,471,531 5,189,514 25,545,368 22,606,745 27,066,380 75,218,493 Total684,096,722 396,375,398 448,564,291 127,586,287 97,732,767 106,406,049 811,683,009 494,108,165 554,970,339 1,860,761,513

Book ValueMarket AdjustmentMarket Value Balances as of January 01, 2017External QualifiedMontiPI1PI2MontiPI1PI2MontiPI1PI2MN Retail 504,432,968.35 292,599,638.67 331,992,382.37 94,401,656.34 72,152,559.93 78,707,504.84 598,834,624.69 364,752,198.60 410,699,887.21 ND Retail 34,078,510.91 22,065,452.54 23,788,041.47 6,910,237.26 5,339,777.23 5,923,430.23 40,988,748.17 27,405,229.77 29,711,471.70 SD Retail 21,484,314.21 16,318,105.47 18,128,356.84 4,565,124.65 4,090,619.70 4,663,553.09 26,049,438.86 20,408,725.17 22,791,909.93 MN FERC9,416,018.29 7,171,931.58 6,804,931.54 2,286,117.72 2,023,867.44 1,628,031.30 11,702,136.01 9,195,799.02 8,432,962.84 WI FERC10,004,575.11 5,836,629.84 5,489,199.02 1,716,721.03 (168,090.30) 1,173,164.24 11,721,296.14 5,668,539.54 6,662,363.26 WI Retail 104,680,335.11 52,383,639.50 62,361,379.54 17,706,430.04 14,294,033.43 14,310,365.41 122,386,765.15 66,677,672.93 76,671,744.95 Total 684,096,721.98 396,375,397.60 448,564,290.78 127,586,287.04 97,732,767.43 106,406,049.11 811,683,009.02 494,108,165.03 554,970,339.89 External EscrowMN Retail- - -

-

-

- - - - WI FERC- - -

-

-

- - - - ND Retail- - -

-

-

- - - - WI Retail- - -

-

-

- - - - Total- - -

-

-

- - - - Internal- - - Grand Total 684,096,721.98 396,375,397.60 448,564,290.78 127,586,287.04 97,732,767.43 106,406,049.11 811,683,009.02 494,108,165.03 554,970,339.89 Book ValueMarket AdjustMarket Value

Retrieved from "https://kanterella.com/w/index.php?title=ML17087A246&oldid=754204"