ML21088A180

From kanterella
Jump to navigation Jump to search
Decommissioning Funding Status Reports
ML21088A180
Person / Time
Site: Monticello, Prairie Island  Xcel Energy icon.png
Issue date: 03/29/2021
From: Murphy M
Northern States Power Co, Xcel Energy
To:
Document Control Desk, Office of Nuclear Reactor Regulation
References
L-XE-21-004
Download: ML21088A180 (29)
v • d • e


Text

414 Nicollet Mall Minneapolis, MN 55401 March 29, 2021 L-XE-21-004 10 CFR 50.75(f)(1)

ATTN: Document Control Desk U.S. Nuclear Regulatory Commission Washington, DC 20555-0001 Prairie Island Nuclear Generating Plant, Units 1 and 2 Docket Nos. 50-282 and 50-306 Renewed Facility Operating License Nos. DPR-42 and DPR-60 Monticello Nuclear Generating Plant Docket No. 50-263 Renewed Facility Operating License No. DPR-22 Decommissioning Funding Status Reports Northern States Power Company, a Minnesota corporation, doing business as Xcel Energy (hereafter NSPM), hereby submits the enclosed decommissioning funding status reports in accordance with 10 CFR 50.75, Reporting and Recordkeeping for Decommissioning Planning, Paragraph (f)(1) for the above listed plants. As holder of the plant operating licenses, NSPM is submitting these reports. The financial information presented herein, is current as of December 31, 2020.

Summary of Commitments This letter makes no new commitments and no revisions to existing commitments.

Martin C. Murphy Digitally signed by Martin C. Murphy Date: 2021.03.29 08:02:18 -05'00' Martin C. Murphy Director, Nuclear Licensing and Regulatory Services Northern States Power Company - Minnesota Enclosures (8) cc: Administrator, Region III, USNRC Project Manager, Monticello and Prairie Island, USNRC Resident Inspector, Monticello, USNRC Resident Inspector, Prairie Island, USNRC

L-XE-21-004 NSPM ENCLOSURE 1 Prairie Island Nuclear Generating Plant, Unit 1 Docket No. 50-282 License No. DPR-42 Decommissioning Funding Status Report As provided in 10 CFR 50.75(f)(1), each power reactor licensee is required to report to the NRC on a calendar year basis beginning March 31, 1999, and every two years thereafter on the status of its decommissioning funding for each reactor or share of reactor it owns.

1. The minimum decommissioning fund estimate, pursuant to 10 CFR 50.75(b) and (c), in 2020 dollars. $447,668,263
2. The amount accumulated at the end of the calendar year External preceding the date of the report. Qualified $603,267,045
3. A schedule of the annual amounts remaining to be collected Annual Years to for radiological costs through rates from customers. Annuity Collect

$486,424 12.67 yrs

4. Assumptions used regarding escalation in decommissioning costs, rate of earnings on decommissioning funds and rates of other factors used in funding projections.

Plant Owner (% Ownership) Rate of Earnings Escalation Real Rate of (Nominal Rate Of Factor Return Return) (Inflation) (Projected)

Xcel Energy (100%) - PINGP Unit 1 4.01% 3.78% 0.23%

- During Operations (Radiological)

Xcel Energy (100%) - PINGP Unit 1 2.80% 3.78% -0.98%

- Post-Shutdown (Radiological)

Basis for Allowance:

Xcel Energy files a triennial decommissioning study with the Minnesota Public Utilities Commission (MPUC) for approval. A portion of the study is dedicated to an analysis of inflation factors surrounding the various components necessary to perform the decommissioning function. Note: These rates apply to external funds only for radiological decommissioning. The rate of earnings and escalation factors were submitted in the most recent triennial decommissioning study completed by the company, MPUC Docket No. E002/M-20-0855. The projected real rate of return of 0.23% during operations and -0.98% post-shutdown would accumulate sufficient decommissioning funds by the current 2033 end of license date.

5. Any contracts upon which the licensee is relying pursuant to 10 CFR 50.75(e) (1) (v). None
6. Any modifications to a licensee's method of providing financial assurance occurring since the last submitted report. None
7. Any material changes to trust agreements. None Page 1 of 1

L-XE-21-004 NSPM ENCLOSURE 2 Prairie Island Nuclear Generating Plant, Unit 2 Docket 50-306 License DPR-60 Decommissioning Funding Status Report As provided in 10 CFR 50.75(f)(1), each power reactor licensee is required to report to the NRC on a calendar year basis beginning March 31, 1999, and every two years thereafter on the status of its decommissioning funding for each reactor or share of reactor it owns.

1. The minimum decommissioning fund estimate, pursuant to 10 CFR 50.75(b) and (c), in 2020 dollars. $447,668,263
2. The amount accumulated at the end of the calendar year External preceding the date of the report. Qualified $585,378,397
3. A schedule of the annual amounts remaining to be collected for Annual Years to radiological costs through rates on customers. Annuity Collect

$1,535,100 13.83 yrs

4. Assumptions used regarding escalation in decommissioning costs, rate of earnings on decommissioning funds and rates of other factors used in funding projections.

Plant Owner (% Ownership) Rate of Earnings Escalation Real Rate of (Nominal Rate Of Factor Return Return) (Inflation) (Projected)

Xcel Energy (100%)- PINGP Unit 2 3.98% 3.78% 0.20%

- During Operations (Radiological)

Xcel Energy (100%)- PINGP Unit 2 2.72% 3.78% -1.06%

- Post-Shutdown (Radiological)

Basis for Allowance:

Xcel Energy files a triennial decommissioning study with the Minnesota Public Utilities Commission (MPUC) for approval. A portion of the study is dedicated to an analysis of inflation factors surrounding the various components necessary to perform the decommissioning function. Note: These rates apply to external funds only for radiological decommissioning. The rate of earnings and escalation factors were submitted in the most recent triennial decommissioning study completed by the company, MPUC Docket No. E002/M-20-0855. The projected real rate of return of 0.20% during operations and -1.06% post-shutdown would accumulate sufficient decommissioning funds by the current 2034 end of license date.

5. Any contracts upon which the licensee is relying pursuant to 10 CFR 50.75(e) (1) (v). None
6. Any modifications to a licensee's method of providing financial assurance occurring since the last submitted report. None
7. Any material changes to trust agreements. None Page 1 of 1

L-XE-21-004 NSPM ENCLOSURE 3 Monticello Nuclear Generating Plant Docket No. 50-263 License No. DPR-22 Decommissioning Funding Status Report As provided in 10 CFR 50.75(f)(1), each power reactor licensee is required to report to the NRC on a calendar year basis beginning March 31, 1999, and every two years thereafter on the status of its decommissioning funding for each reactor or share of reactor it owns.

1. The minimum decommissioning fund estimate, pursuant to 10 CFR 50.75(b) and (c), in 2020 dollars. $610,169,441
2. The amount accumulated for Radiological Decommissioning at External the end of the calendar year preceding the date of the report. Qualified $761,345,175
3. A schedule of the annual amounts remaining to be collected Annual Years to for radiological costs through rates from customers. Annuity Collect

$18,350,224 9.75 yrs

4. Assumptions used regarding escalation in decommissioning costs, rate of earnings on decommissioning funds and rates of other factors used in funding projections.

Plant Owner (% Ownership) Rate of Earnings Escalation Real Rate of (Nominal Rate Of Factor Return Return) (Inflation) (Projected)

Xcel Energy (100%)- Monticello - 3.80% 3.78% 0.02%

During Operations (Radiological)

Xcel Energy (100%)- Monticello - 3.10% 3.78% -0.68%

Post-Shutdown (Radiological)

Basis for Allowance:

Xcel Energy files a triennial decommissioning study with the Minnesota Public Utilities Commission (MPUC) for approval. A portion of the study is dedicated to an analysis of inflation factors surrounding the various components necessary to perform the decommissioning function. Note: These rates apply to external funds only for radiological decommissioning. The rate of earnings and escalation factors were submitted in the most recent triennial decommissioning study completed by the company, MPUC Docket No. E002/M-20-0855. The projected real rate of return of 0.02% during operations and -0.68% post-shutdown would accumulate sufficient decommissioning funds by the current 2030 end of license date.

5. Any contracts upon which the licensee is relying pursuant to 10 CFR 50.75(e) (1) (v). None
6. Any modifications to a licensee's method of providing financial assurance occurring since the last submitted report. None
7. Any material changes to trust agreements. None Page 1 of 1

L-XE-21-004 NSPM ENCLOSURE 4 Prairie Island Nuclear Generating Plant (PINGP) Units 1 and 2 Dockets 50-282 and 50-306 Licenses Nos. DPR-42 and DPR-60 Monticello Nuclear Generating Plant (MNGP)

Docket 50-263 License No. DPR-22 Xcel Energy Breakdown of Annual Contributions and Trust Fund Balance The following table is the radiological decommissioning, spent fuel management, and site restoration segmentation of the trust fund balances for PINGP Units 1 and 2 and MNGP.

Please note that since our last biennial funding status report, Xcel Energy has rebalanced the amount of funds allocated between the three cost components of decommissioning. This was done to properly balance funds against our new decommissioning cost study and to ensure proper funding for all three components. To see the split of the total fund balance in the cost components, please see Enclosure 8.

Trust Fund Beginning Balances Prairie Island Unit 1 2020 2021 Radiological Decommissioning 568,285,872 603,267,045 Spent Fuel Management 52,741,816 89,398,301 Site Restoration 14,918,371 25,286,899 Total 635,946,059 717,952,246 Prairie Island Unit 2 2020 2021 Radiological Decommissioning 550,554,789 585,378,397 Spent Fuel Management 114,540,883 155,416,356 Site Restoration 44,915,031 60,943,571 Total 710,010,702 801,738,324 Monticello 2020 2021 Radiological Decommissioning 662,515,321 761,345,175 Spent Fuel Management 364,967,826 419,411,422 Site Restoration 66,136,317 76,002,116 Total 1,093,619,464 1,256,758,713 Page 1 of 2

L-XE-21-004 NSPM The following annual contributions table shows the approximate accrual segmentation for radiological decommissioning, spent fuel management, and site restoration for MNGP and PINGP Units 1 and 2.

See Enclosure 5 for the calculation of annual contributions for radiological decommissioning. See for the calculation of annual contributions for spent fuel management. See Enclosure 7 for the calculation of annual contributions for site restoration.

Annual Contributions Prairie Island Unit 1 2020 2021 Radiological Decommissioning 486,424 486,424 Spent Fuel Management 0 0 Site Restoration 0 0 Total 486,424 486,424 Prairie Island Unit 2 2020 2021 Radiological Decommissioning 1,535,100 1,535,100 Spent Fuel Management 0 0 Site Restoration 0 0 Total 1,535,100 1,535,100 Monticello 2020 2021 Radiological Decommissioning 10,110,528 4,781,483 Spent Fuel Management 6,975,632 11,487,141 Site Restoration 1,264,064 2,081,600 Total 18,350,224 18,350,224 Page 2 of 2

L-XE-21-004 NSPM ENCLOSURE 5 ANNUAL ACCRUAL

SUMMARY

- RADIOLOGICAL 4 Pages Follow

Operational Post-Shutdown Market Unrealized Tax-Adjusted Remaining Earnings Earnings Value Balance Book Value Gain/Loss Tax-Effect Fund Balance Life (yrs) Rate Rate 1/1/2021 1/1/2021 1/1/2021 Adjustment 1/1/2021 Accrual Monticello 9.75 3.80% 3.10% $761,345,175 $499,771,778 $261,573,397 $72,822,034 $688,523,141 $4,781,483 Prairie Island Unit 1 12.67 4.01% 2.80% 603,267,045 386,972,418 216,294,627 60,216,424 543,050,621 486,424 Prairie Island Unit 2 13.83 3.98% 2.72% 585,378,397 376,075,799 209,302,598 58,269,843 527,108,554 1,535,100 TOTAL DECOMMISSIONING ACCRUAL $1,949,990,617 $1,262,819,995 $687,170,622 $191,308,301 $1,758,682,316 $6,803,007 INPUT DATA Escalation Rate (Labor) 3.78%

Escalation Rate (Non-Labor) 2.58%

Escalation Rate (PIIC) 0.00%

Jurisdictional Factor 100.0000%

Tax Rate for tax-effect adjustment 27.84%

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s Monticello Factors 2020 100.0000% 3.78% 2.58% 0.00%

2030 $22,382,860 $22,382,860 1.4492 $32,437,241 $7,480,120 $7,480,120 1.2901 $9,650,103 $0 $0 1.0000 $0 $29,862,980 $29,862,980 $42,087,344 2031 76,445,948 76,445,948 1.5040 114,974,706 41,135,178 41,135,178 1.3234 54,438,295 0 0 1.0000 0 117,581,126 117,581,126 169,413,000 2032 82,712,307 82,712,307 1.5609 129,105,640 119,934,223 119,934,223 1.3575 162,810,708 0 0 1.0000 0 202,646,530 202,646,530 291,916,348 2033 82,299,953 82,299,953 1.6199 133,317,694 107,391,533 107,391,533 1.3926 149,553,449 0 0 1.0000 0 189,691,486 189,691,486 282,871,143 2034 73,671,107 73,671,107 1.6811 123,848,498 62,307,114 62,307,114 1.4285 89,005,712 0 0 1.0000 0 135,978,221 135,978,221 212,854,210 2035 46,850,405 46,850,405 1.7446 81,735,217 22,286,307 22,286,307 1.4653 32,656,126 0 0 1.0000 0 69,136,712 69,136,712 114,391,342 2036 8,692,755 8,692,755 1.8106 15,739,102 1,875,309 1,875,309 1.5032 2,818,964 0 0 1.0000 0 10,568,064 10,568,064 18,558,067 2037 351,406 351,406 1.8790 660,292 846,924 846,924 1.5419 1,305,872 0 0 1.0000 0 1,198,330 1,198,330 1,966,164 2038 0 0 1.9501 0 0 0 1.5817 0 0 0 1.0000 0 0 0 0 2039 0 0 2.0238 0 0 0 1.6225 0 0 0 1.0000 0 0 0 0 2040 0 0 2.1003 0 0 0 1.6644 0 0 0 1.0000 0 0 0 0 2041 0 0 2.1797 0 0 0 1.7073 0 0 0 1.0000 0 0 0 0 2042 0 0 2.2620 0 0 0 1.7514 0 0 0 1.0000 0 0 0 0 2043 0 0 2.3475 0 0 0 1.7966 0 0 0 1.0000 0 0 0 0 2044 0 0 2.4363 0 0 0 1.8429 0 0 0 1.0000 0 0 0 0 2045 0 0 2.5284 0 0 0 1.8905 0 0 0 1.0000 0 0 0 0 2046 0 0 2.6239 0 0 0 1.9392 0 0 0 1.0000 0 0 0 0 2047 0 0 2.7231 0 0 0 1.9893 0 0 0 1.0000 0 0 0 0 2048 0 0 2.8261 0 0 0 2.0406 0 0 0 1.0000 0 0 0 0 2049 0 0 2.9329 0 0 0 2.0932 0 0 0 1.0000 0 0 0 0 2050 0 0 3.0438 0 0 0 2.1472 0 0 0 1.0000 0 0 0 0 2051 0 0 3.1588 0 0 0 2.2026 0 0 0 1.0000 0 0 0 0 2052 0 0 3.2782 0 0 0 2.2595 0 0 0 1.0000 0 0 0 0 2053 0 0 3.4021 0 0 0 2.3178 0 0 0 1.0000 0 0 0 0 2054 0 0 3.5307 0 0 0 2.3776 0 0 0 1.0000 0 0 0 0 2055 0 0 3.6642 0 0 0 2.4389 0 0 0 1.0000 0 0 0 0 2056 0 0 3.8027 0 0 0 2.5018 0 0 0 1.0000 0 0 0 0 2057 0 0 3.9464 0 0 0 2.5664 0 0 0 1.0000 0 0 0 0 2058 0 0 4.0956 0 0 0 2.6326 0 0 0 1.0000 0 0 0 0 2059 0 0 4.2504 0 0 0 2.7005 0 0 0 1.0000 0 0 0 0 2060 0 0 4.4111 0 0 0 2.7702 0 0 0 1.0000 0 0 0 0 2061 0 0 4.5778 0 0 0 2.8416 0 0 0 1.0000 0 0 0 0 2062 0 0 4.7509 0 0 0 2.9150 0 0 0 1.0000 0 0 0 0 2063 0 0 4.9305 0 0 0 2.9902 0 0 0 1.0000 0 0 0 0 2064 0 0 5.1168 0 0 0 3.0673 0 0 0 1.0000 0 0 0 0 2065 0 0 5.3103 0 0 0 3.1465 0 0 0 1.0000 0 0 0 0 2066 0 0 5.5110 0 0 0 3.2276 0 0 0 1.0000 0 0 0 0 2067 0 0 5.7193 0 0 0 3.3109 0 0 0 1.0000 0 0 0 0 2068 0 0 5.9355 0 0 0 3.3963 0 0 0 1.0000 0 0 0 0 2069 0 0 6.1598 0 0 0 3.4840 0 0 0 1.0000 0 0 0 0 2070 0 0 6.3927 0 0 0 3.5738 0 0 0 1.0000 0 0 0 0 2071 0 0 6.6343 0 0 0 3.6660 0 0 0 1.0000 0 0 0 0 2072 0 0 6.8851 0 0 0 3.7606 0 0 0 1.0000 0 0 0 0 2073 0 0 7.1454 0 0 0 3.8576 0 0 0 1.0000 0 0 0 0 2074 0 0 7.4155 0 0 0 3.9572 0 0 0 1.0000 0 0 0 0 2075 0 0 7.6958 0 0 0 4.0593 0 0 0 1.0000 0 0 0 0 2076 0 0 7.9867 0 0 0 4.1640 0 0 0 1.0000 0 0 0 0 2077 0 0 8.2886 0 0 0 4.2714 0 0 0 1.0000 0 0 0 0 2078 0 0 8.6019 0 0 0 4.3816 0 0 0 1.0000 0 0 0 0 2079 0 0 8.9270 0 0 0 4.4947 0 0 0 1.0000 0 0 0 0 2080 0 0 9.2645 0 0 0 4.6106 0 0 0 1.0000 0 0 0 0 2081 0 0 9.6147 0 0 0 4.7296 0 0 0 1.0000 0 0 0 0 2082 0 0 9.9781 0 0 0 4.8516 0 0 0 1.0000 0 0 0 0 2083 0 0 10.3553 0 0 0 4.9768 0 0 0 1.0000 0 0 0 0 2084 0 0 10.7467 0 0 0 5.1052 0 0 0 1.0000 0 0 0 0

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s 2085 0 0 11.1529 0 0 0 5.2369 0 0 0 1.0000 0 0 0 0 2086 0 0 11.5745 0 0 0 5.3720 0 0 0 1.0000 0 0 0 0 2087 0 0 12.0120 0 0 0 5.5106 0 0 0 1.0000 0 0 0 0 2088 0 0 12.4661 0 0 0 5.6528 0 0 0 1.0000 0 0 0 0 2089 0 0 12.9373 0 0 0 5.7986 0 0 0 1.0000 0 0 0 0 2090 244,524 244,524 13.4263 3,283,053 6,387,194 6,387,194 5.9482 37,992,307 0 0 1.0000 0 6,631,718 6,631,718 41,275,360 2091 0 0 13.9338 0 0 0 6.1017 0 0 0 1.0000 0 0 0 0

$393,651,265 $393,651,265 $635,101,442 $369,643,902 $369,643,902 $540,231,536 $0 $0 $0 $763,295,167 $763,295,167 $1,175,332,977

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s Prairie Island Unit 1 Factors 2020 100.0000% 3.78% 2.58% 0.00%

2033 $23,516,311 $23,516,311 1.6199 $38,094,072 $10,315,579 $10,315,579 1.3926 $14,365,475 $0 $0 1.0000 $0 $33,831,890 $33,831,890 $52,459,548 2034 $66,238,024 66,238,024 1.6811 111,352,742 $34,741,285 34,741,285 1.4285 49,627,926 $0 0 1.0000 0 100,979,309 100,979,309 160,980,668 2035 $66,574,460 66,574,460 1.7446 116,145,803 $74,242,091 74,242,091 1.4653 108,786,936 $0 0 1.0000 0 140,816,551 140,816,551 224,932,739 2036 $60,844,971 60,844,971 1.8106 110,165,904 $73,988,372 73,988,372 1.5032 111,219,321 $0 0 1.0000 0 134,833,343 134,833,343 221,385,225 2037 $37,914,521 37,914,521 1.8790 71,241,385 $46,039,945 46,039,945 1.5419 70,988,991 $0 0 1.0000 0 83,954,466 83,954,466 142,230,376 2038 $15,119,025 15,119,025 1.9501 29,483,611 $11,398,201 11,398,201 1.5817 18,028,535 $0 0 1.0000 0 26,517,226 26,517,226 47,512,145 2039 $30,645,927 30,645,927 2.0238 62,021,227 $14,053,539 14,053,539 1.6225 22,801,867 $0 0 1.0000 0 44,699,466 44,699,466 84,823,094 2040 $9,682,551 9,682,551 2.1003 20,336,262 $2,170,001 2,170,001 1.6644 3,611,750 $0 0 1.0000 0 11,852,552 11,852,552 23,948,012 2041 $295,881 295,881 2.1797 644,932 $338,271 338,271 1.7073 577,530 $0 0 1.0000 0 634,152 634,152 1,222,462 2042 $139,429 139,429 2.2620 315,388 $159,404 159,404 1.7514 279,180 $0 0 1.0000 0 298,833 298,833 594,569 2043 $0 0 2.3475 0 $0 0 1.7966 0 $0 0 1.0000 0 0 0 0 2044 $0 0 2.4363 0 $0 0 1.8429 0 $0 0 1.0000 0 0 0 0 2045 $0 0 2.5284 0 $0 0 1.8905 0 $0 0 1.0000 0 0 0 0 2046 $0 0 2.6239 0 $0 0 1.9392 0 $0 0 1.0000 0 0 0 0 2047 $0 0 2.7231 0 $0 0 1.9893 0 $0 0 1.0000 0 0 0 0 2048 $0 0 2.8261 0 $0 0 2.0406 0 $0 0 1.0000 0 0 0 0 2049 $0 0 2.9329 0 $0 0 2.0932 0 $0 0 1.0000 0 0 0 0 2050 $0 0 3.0438 0 $0 0 2.1472 0 $0 0 1.0000 0 0 0 0 2051 $0 0 3.1588 0 $0 0 2.2026 0 $0 0 1.0000 0 0 0 0 2052 $0 0 3.2782 0 $0 0 2.2595 0 $0 0 1.0000 0 0 0 0 2053 $0 0 3.4021 0 $0 0 2.3178 0 $0 0 1.0000 0 0 0 0 2054 $0 0 3.5307 0 $0 0 2.3776 0 $0 0 1.0000 0 0 0 0 2055 $0 0 3.6642 0 $0 0 2.4389 0 $0 0 1.0000 0 0 0 0 2056 $0 0 3.8027 0 $0 0 2.5018 0 $0 0 1.0000 0 0 0 0 2057 $0 0 3.9464 0 $0 0 2.5664 0 $0 0 1.0000 0 0 0 0 2058 $0 0 4.0956 0 $0 0 2.6326 0 $0 0 1.0000 0 0 0 0 2059 $0 0 4.2504 0 $0 0 2.7005 0 $0 0 1.0000 0 0 0 0 2060 $0 0 4.4111 0 $0 0 2.7702 0 $0 0 1.0000 0 0 0 0 2061 $0 0 4.5778 0 $0 0 2.8416 0 $0 0 1.0000 0 0 0 0 2062 $0 0 4.7509 0 $0 0 2.9150 0 $0 0 1.0000 0 0 0 0 2063 $0 0 4.9305 0 $0 0 2.9902 0 $0 0 1.0000 0 0 0 0 2064 $0 0 5.1168 0 $0 0 3.0673 0 $0 0 1.0000 0 0 0 0 2065 $0 0 5.3103 0 $0 0 3.1465 0 $0 0 1.0000 0 0 0 0 2066 $0 0 5.5110 0 $0 0 3.2276 0 $0 0 1.0000 0 0 0 0 2067 $0 0 5.7193 0 $0 0 3.3109 0 $0 0 1.0000 0 0 0 0 2068 $0 0 5.9355 0 $0 0 3.3963 0 $0 0 1.0000 0 0 0 0 2069 $0 0 6.1598 0 $0 0 3.4840 0 $0 0 1.0000 0 0 0 0 2070 $0 0 6.3927 0 $0 0 3.5738 0 $0 0 1.0000 0 0 0 0 2071 $0 0 6.6343 0 $0 0 3.6660 0 $0 0 1.0000 0 0 0 0 2072 $0 0 6.8851 0 $0 0 3.7606 0 $0 0 1.0000 0 0 0 0 2073 $0 0 7.1454 0 $0 0 3.8576 0 $0 0 1.0000 0 0 0 0 2074 $0 0 7.4155 0 $0 0 3.9572 0 $0 0 1.0000 0 0 0 0 2075 $0 0 7.6958 0 $0 0 4.0593 0 $0 0 1.0000 0 0 0 0 2076 $0 0 7.9867 0 $0 0 4.1640 0 $0 0 1.0000 0 0 0 0 2077 $125,600 125,600 8.2886 1,041,048 $11,858,240 11,858,240 4.2714 50,651,286 $0 0 1.0000 0 11,983,840 11,983,840 51,692,334 2078 $0 0 8.6019 0 $0 0 4.3816 0 $0 0 1.0000 0 0 0 0

$311,096,700 $311,096,700 $560,842,375 $279,304,928 $279,304,928 $450,938,797 $0 $0 $0 $590,401,628 $590,401,628 $1,011,781,171

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s Prairie Island Unit 2 Factors 2020 100.0000% 3.78% 2.58% 0.00%

2034 $8,228,434 $8,228,434 1.6811 $13,832,820 $5,041,487 $5,041,487 1.4285 $7,201,764 $247,032 $247,032 1.0000 $247,032 $13,516,953 $13,516,953 $21,281,617 2035 49,164,358 49,164,358 1.7446 85,772,139 33,944,105 33,944,105 1.4653 49,738,297 0 - 1.0000 - 83,108,463 83,108,463 135,510,436 2036 64,138,723 64,138,723 1.8106 116,129,572 67,117,295 67,117,295 1.5032 100,890,718 0 - 1.0000 - 131,256,018 131,256,018 217,020,290 2037 68,279,630 68,279,630 1.8790 128,297,425 74,917,580 74,917,580 1.5419 115,515,417 0 - 1.0000 - 143,197,210 143,197,210 243,812,841 2038 68,395,297 68,395,297 1.9501 133,377,669 67,433,064 67,433,064 1.5817 106,658,877 0 - 1.0000 - 135,828,361 135,828,361 240,036,546 2039 35,984,393 35,984,393 2.0238 72,825,215 15,472,061 15,472,061 1.6225 25,103,419 0 - 1.0000 - 51,456,454 51,456,454 97,928,634 2040 12,002,423 12,002,423 2.1003 25,208,689 2,211,038 2,211,038 1.6644 3,680,052 0 - 1.0000 - 14,213,461 14,213,461 28,888,741 2041 233,644 233,644 2.1797 509,274 338,271 338,271 1.7073 577,530 0 - 1.0000 - 571,915 571,915 1,086,804 2042 110,101 110,101 2.2620 249,048 159,404 159,404 1.7514 279,180 0 - 1.0000 - 269,505 269,505 528,229 2043 0 - 2.3475 - 0 - 1.7966 - 0 - 1.0000 - 0 0 -

2044 0 - 2.4363 - 0 - 1.8429 - 0 - 1.0000 - 0 0 -

2045 0 - 2.5284 - 0 - 1.8905 - 0 - 1.0000 - 0 0 -

2046 0 - 2.6239 - 0 - 1.9392 - 0 - 1.0000 - 0 0 -

2047 0 - 2.7231 - 0 - 1.9893 - 0 - 1.0000 - 0 0 -

2048 0 - 2.8261 - 0 - 2.0406 - 0 - 1.0000 - 0 0 -

2049 0 - 2.9329 - 0 - 2.0932 - 0 - 1.0000 - 0 0 -

2050 0 - 3.0438 - 0 - 2.1472 - 0 - 1.0000 - 0 0 -

2051 0 - 3.1588 - 0 - 2.2026 - 0 - 1.0000 - 0 0 -

2052 0 - 3.2782 - 0 - 2.2595 - 0 - 1.0000 - 0 0 -

2053 0 - 3.4021 - 0 - 2.3178 - 0 - 1.0000 - 0 0 -

2054 0 - 3.5307 - 0 - 2.3776 - 0 - 1.0000 - 0 0 -

2055 0 - 3.6642 - 0 - 2.4389 - 0 - 1.0000 - 0 0 -

2056 0 - 3.8027 - 0 - 2.5018 - 0 - 1.0000 - 0 0 -

2057 0 - 3.9464 - 0 - 2.5664 - 0 - 1.0000 - 0 0 -

2058 0 - 4.0956 - 0 - 2.6326 - 0 - 1.0000 - 0 0 -

2059 0 - 4.2504 - 0 - 2.7005 - 0 - 1.0000 - 0 0 -

2060 0 - 4.4111 - 0 - 2.7702 - 0 - 1.0000 - 0 0 -

2061 0 - 4.5778 - 0 - 2.8416 - 0 - 1.0000 - 0 0 -

2062 0 - 4.7509 - 0 - 2.9150 - 0 - 1.0000 - 0 0 -

2063 0 - 4.9305 - 0 - 2.9902 - 0 - 1.0000 - 0 0 -

2064 0 - 5.1168 - 0 - 3.0673 - 0 - 1.0000 - 0 0 -

2065 0 - 5.3103 - 0 - 3.1465 - 0 - 1.0000 - 0 0 -

2066 0 - 5.5110 - 0 - 3.2276 - 0 - 1.0000 - 0 0 -

2067 0 - 5.7193 - 0 - 3.3109 - 0 - 1.0000 - 0 0 -

2068 0 - 5.9355 - 0 - 3.3963 - 0 - 1.0000 - 0 0 -

2069 0 - 6.1598 - 0 - 3.4840 - 0 - 1.0000 - 0 0 -

2070 0 - 6.3927 - 0 - 3.5738 - 0 - 1.0000 - 0 0 -

2071 0 - 6.6343 - 0 - 3.6660 - 0 - 1.0000 - 0 0 -

2072 0 - 6.8851 - 0 - 3.7606 - 0 - 1.0000 - 0 0 -

2073 0 - 7.1454 - 0 - 3.8576 - 0 - 1.0000 - 0 0 -

2074 0 - 7.4155 - 0 - 3.9572 - 0 - 1.0000 - 0 0 -

2075 0 - 7.6958 - 0 - 4.0593 - 0 - 1.0000 - 0 0 -

2076 0 - 7.9867 - 0 - 4.1640 - 0 - 1.0000 - 0 0 -

2077 125,600 125,600 8.2886 1,041,048 11,858,240 11,858,240 4.2714 50,651,286 0 - 1.0000 - 11,983,840 11,983,840 51,692,334 2078 0 - 8.6019 - 0 - 4.3816 - 0 - 1.0000 - 0 0 -

$306,662,603 $306,662,603 $577,242,899 $278,492,545 $278,492,545 $460,296,540 $247,032 $247,032 $247,032 $585,402,180 $585,402,180 $1,037,786,471

$1,011,410,568 $1,011,410,568 $1,773,186,715 $927,441,375 $927,441,375 $1,451,466,873 $247,032 $247,032 $247,032 $1,939,098,975 $1,939,098,975 $3,224,900,620

L-XE-21-004 NSPM ENCLOSURE 6 ANNUAL ACCRUAL

SUMMARY

- SPENT FUEL MANAGEMENT 4 Pages Follow

Operational Post-Shutdown Market Unrealized Tax-Adjusted Remaining Earnings Earnings Value Balance Book Value Gain/Loss Tax-Effect Fund Balance Life (yrs) Rate Rate 1/1/2021 1/1/2021 1/1/2021 Adjustment 1/1/2021 Accrual Monticello 9.75 3.80% 3.10% $419,411,422 $275,315,322 $144,096,100 $40,116,354 $379,295,068 $11,487,141 Prairie Island Unit 1 12.67 4.01% 2.80% 89,398,301 57,345,544 32,052,757 8,923,488 80,474,814 0 Prairie Island Unit 2 13.83 3.98% 2.72% 155,416,356 99,847,092 55,569,265 15,470,483 139,945,873 0 TOTAL DECOMMISSIONING ACCRUAL $664,226,080 $432,507,958 $231,718,122 $64,510,325 $599,715,755 $11,487,141 INPUT DATA Escalation Rate (Labor) 3.78%

Escalation Rate (Non-Labor) 2.58%

Escalation Rate (PIIC) 0.00%

Jurisdictional Factor 100.0000%

Tax Rate for tax-effect adjustment 27.84%

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s Monticello Factors 2020 100.0000% 3.78% 2.58% 0.00%

2030 $119,860 $119,860 1.4492 $173,701 $1,894,014 $1,894,014 1.2901 $2,443,468 $0 $0 1.0000 $0 $2,013,875 $2,013,875 $2,617,169 2031 331,631 331,631 1.5040 498,773 5,661,219 5,661,219 1.3234 7,492,058 0 0 1.0000 0 5,992,850 5,992,850 7,990,830 2032 2,261,316 2,261,316 1.5609 3,529,688 11,018,730 11,018,730 1.3575 14,957,926 0 0 1.0000 0 13,280,046 13,280,046 18,487,614 2033 13,528,239 13,528,239 1.6199 21,914,395 44,807,923 44,807,923 1.3926 62,399,514 0 0 1.0000 0 58,336,163 58,336,163 84,313,909 2034 23,826,028 23,826,028 1.6811 40,053,936 68,664,509 68,664,509 1.4285 98,087,251 0 0 1.0000 0 92,490,537 92,490,537 138,141,187 2035 6,147,263 6,147,263 1.7446 10,724,516 335,856 335,856 1.4653 492,131 0 0 1.0000 0 6,483,120 6,483,120 11,216,646 2036 6,569,948 6,569,948 1.8106 11,895,547 2,180,946 2,180,946 1.5032 3,278,398 0 0 1.0000 0 8,750,894 8,750,894 15,173,945 2037 6,627,740 6,627,740 1.8790 12,453,524 2,600,773 2,600,773 1.5419 4,010,132 0 0 1.0000 0 9,228,513 9,228,513 16,463,656 2038 1,611,757 1,611,757 1.9501 3,143,087 670,180 670,180 1.5817 1,060,023 0 0 1.0000 0 2,281,936 2,281,936 4,203,110 2039 1,611,757 1,611,757 2.0238 3,261,873 670,180 670,180 1.6225 1,087,367 0 0 1.0000 0 2,281,936 2,281,936 4,349,240 2040 1,629,223 1,629,223 2.1003 3,421,856 676,933 676,933 1.6644 1,126,687 0 0 1.0000 0 2,306,155 2,306,155 4,548,543 2041 1,611,757 1,611,757 2.1797 3,513,146 670,180 670,180 1.7073 1,144,198 0 0 1.0000 0 2,281,936 2,281,936 4,657,344 2042 1,611,757 1,611,757 2.2620 3,645,793 670,180 670,180 1.7514 1,173,753 0 0 1.0000 0 2,281,936 2,281,936 4,819,546 2043 1,611,757 1,611,757 2.3475 3,783,599 670,180 670,180 1.7966 1,204,045 0 0 1.0000 0 2,281,936 2,281,936 4,987,643 2044 1,629,223 1,629,223 2.4363 3,969,275 676,933 676,933 1.8429 1,247,519 0 0 1.0000 0 2,306,155 2,306,155 5,216,794 2045 1,611,757 1,611,757 2.5284 4,075,165 670,180 670,180 1.8905 1,266,975 0 0 1.0000 0 2,281,936 2,281,936 5,342,140 2046 1,611,757 1,611,757 2.6239 4,229,088 670,180 670,180 1.9392 1,299,612 0 0 1.0000 0 2,281,936 2,281,936 5,528,701 2047 1,611,757 1,611,757 2.7231 4,388,974 670,180 670,180 1.9893 1,333,188 0 0 1.0000 0 2,281,936 2,281,936 5,722,163 2048 2,348,709 2,348,709 2.8261 6,637,685 2,835,391 2,835,391 2.0406 5,785,898 0 0 1.0000 0 5,184,099 5,184,099 12,423,583 2049 1,611,757 1,611,757 2.9329 4,727,121 670,180 670,180 2.0932 1,402,820 0 0 1.0000 0 2,281,936 2,281,936 6,129,941 2050 3,230,600 3,230,600 3.0438 9,833,300 5,526,710 5,526,710 2.1472 11,866,952 0 0 1.0000 0 8,757,310 8,757,310 21,700,252 2051 3,230,600 3,230,600 3.1588 10,204,819 5,526,710 5,526,710 2.2026 12,173,131 0 0 1.0000 0 8,757,310 8,757,310 22,377,951 2052 3,967,966 3,967,966 3.2782 13,007,786 7,693,163 7,693,163 2.2595 17,382,702 0 0 1.0000 0 11,661,129 11,661,129 30,390,488 2053 4,490,425 4,490,425 3.4021 15,276,875 9,306,185 9,306,185 2.3178 21,569,875 0 0 1.0000 0 13,796,610 13,796,610 36,846,750 2054 3,410,575 3,410,575 3.5307 12,041,717 6,066,635 6,066,635 2.3776 14,424,031 0 0 1.0000 0 9,477,210 9,477,210 26,465,749 2055 4,310,450 4,310,450 3.6642 15,794,351 8,766,260 8,766,260 2.4389 21,380,031 0 0 1.0000 0 13,076,710 13,076,710 37,174,382 2056 4,687,866 4,687,866 3.8027 17,826,548 9,852,863 9,852,863 2.5018 24,649,893 0 0 1.0000 0 14,540,729 14,540,729 42,476,441 2057 1,593,769 1,593,769 3.9464 6,289,652 616,218 616,218 2.5664 1,581,462 0 0 1.0000 0 2,209,988 2,209,988 7,871,114 2058 1,593,769 1,593,769 4.0956 6,527,442 616,218 616,218 2.6326 1,622,256 0 0 1.0000 0 2,209,988 2,209,988 8,149,698 2059 1,593,769 1,593,769 4.2504 6,774,158 616,218 616,218 2.7005 1,664,097 0 0 1.0000 0 2,209,988 2,209,988 8,438,255 2060 1,611,235 1,611,235 4.4111 7,107,321 622,971 622,971 2.7702 1,725,755 0 0 1.0000 0 2,234,207 2,234,207 8,833,076 2061 1,593,769 1,593,769 4.5778 7,295,958 616,218 616,218 2.8416 1,751,046 0 0 1.0000 0 2,209,988 2,209,988 9,047,004 2062 1,593,769 1,593,769 4.7509 7,571,839 616,218 616,218 2.9150 1,796,276 0 0 1.0000 0 2,209,988 2,209,988 9,368,116 2063 1,593,769 1,593,769 4.9305 7,858,080 616,218 616,218 2.9902 1,842,616 0 0 1.0000 0 2,209,988 2,209,988 9,700,696 2064 1,611,235 1,611,235 5.1168 8,244,370 622,971 622,971 3.0673 1,910,840 0 0 1.0000 0 2,234,207 2,234,207 10,155,209 2065 1,593,769 1,593,769 5.3103 8,463,394 616,218 616,218 3.1465 1,938,931 0 0 1.0000 0 2,209,988 2,209,988 10,402,325 2066 1,593,769 1,593,769 5.5110 8,783,264 616,218 616,218 3.2276 1,988,906 0 0 1.0000 0 2,209,988 2,209,988 10,772,170 2067 1,593,769 1,593,769 5.7193 9,115,246 616,218 616,218 3.3109 2,040,237 0 0 1.0000 0 2,209,988 2,209,988 11,155,483 2068 1,611,235 1,611,235 5.9355 9,563,488 622,971 622,971 3.3963 2,115,797 0 0 1.0000 0 2,234,207 2,234,207 11,679,285 2069 1,593,769 1,593,769 6.1598 9,817,301 616,218 616,218 3.4840 2,146,904 0 0 1.0000 0 2,209,988 2,209,988 11,964,206 2070 1,593,769 1,593,769 6.3927 10,188,490 616,218 616,218 3.5738 2,202,241 0 0 1.0000 0 2,209,988 2,209,988 12,390,731 2071 1,593,769 1,593,769 6.6343 10,573,545 616,218 616,218 3.6660 2,259,056 0 0 1.0000 0 2,209,988 2,209,988 12,832,601 2072 1,611,235 1,611,235 6.8851 11,093,517 622,971 622,971 3.7606 2,342,746 0 0 1.0000 0 2,234,207 2,234,207 13,436,263 2073 1,593,769 1,593,769 7.1454 11,388,120 616,218 616,218 3.8576 2,377,123 0 0 1.0000 0 2,209,988 2,209,988 13,765,244 2074 1,593,769 1,593,769 7.4155 11,818,598 616,218 616,218 3.9572 2,438,499 0 0 1.0000 0 2,209,988 2,209,988 14,257,096 2075 1,593,769 1,593,769 7.6958 12,265,331 616,218 616,218 4.0593 2,501,415 0 0 1.0000 0 2,209,988 2,209,988 14,766,746 2076 1,611,235 1,611,235 7.9867 12,868,454 622,971 622,971 4.1640 2,594,052 0 0 1.0000 0 2,234,207 2,234,207 15,462,507 2077 1,593,769 1,593,769 8.2886 13,210,118 616,218 616,218 4.2714 2,632,115 0 0 1.0000 0 2,209,988 2,209,988 15,842,232 2078 2,112,707 2,112,707 8.6019 18,173,294 2,173,031 2,173,031 4.3816 9,521,351 0 0 1.0000 0 4,285,738 4,285,738 27,694,646 2079 2,216,494 2,216,494 8.9270 19,786,646 2,484,393 2,484,393 4.4947 11,166,602 0 0 1.0000 0 4,700,888 4,700,888 30,953,248 2080 2,130,173 2,130,173 9.2645 19,734,987 2,179,784 2,179,784 4.6106 10,050,111 0 0 1.0000 0 4,309,957 4,309,957 29,785,099 2081 2,112,707 2,112,707 9.6147 20,313,044 2,173,031 2,173,031 4.7296 10,277,566 0 0 1.0000 0 4,285,738 4,285,738 30,590,610 2082 2,112,707 2,112,707 9.9781 21,080,802 2,173,031 2,173,031 4.8516 10,542,676 0 0 1.0000 0 4,285,738 4,285,738 31,623,477 2083 2,216,494 2,216,494 10.3553 22,952,465 2,484,393 2,484,393 4.9768 12,364,328 0 0 1.0000 0 4,700,888 4,700,888 35,316,793 2084 2,130,173 2,130,173 10.7467 22,892,330 2,179,784 2,179,784 5.1052 11,128,232 0 0 1.0000 0 4,309,957 4,309,957 34,020,562

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s 2085 2,112,707 2,112,707 11.1529 23,562,810 2,173,031 2,173,031 5.2369 11,379,945 0 0 1.0000 0 4,285,738 4,285,738 34,942,754 2086 2,112,707 2,112,707 11.5745 24,453,527 2,173,031 2,173,031 5.3720 11,673,521 0 0 1.0000 0 4,285,738 4,285,738 36,127,048 2087 2,216,494 2,216,494 12.0120 26,624,532 2,484,393 2,484,393 5.5106 13,690,497 0 0 1.0000 0 4,700,888 4,700,888 40,315,029 2088 2,849,659 2,849,659 12.4661 35,524,133 4,338,242 4,338,242 5.6528 24,523,213 0 0 1.0000 0 7,187,901 7,187,901 60,047,346 2089 2,112,707 2,112,707 12.9373 27,332,724 2,173,031 2,173,031 5.7986 12,600,536 0 0 1.0000 0 4,285,738 4,285,738 39,933,260 2090 1,556,821 1,556,821 13.4263 20,902,343 1,159,312 1,159,312 5.9482 6,895,818 0 0 1.0000 0 2,716,132 2,716,132 27,798,161 2091 (3,865,406) (3,865,406) 13.9338 (53,859,790) 10,079,217 10,079,217 6.1017 61,500,360 0 0 1.0000 0 6,213,812 6,213,812 7,640,570

$164,537,105 $164,537,105 $690,317,673 $253,525,421 $253,525,421 $596,526,705 $0 $0 $0 $418,062,526 $418,062,526 $1,286,844,378

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s Prairie Island Unit 1 Factors 2020 100.0000% 3.78% 2.58% 0.00%

2033 $0 $0 1.6199 $0 $414,788 $414,788 1.3926 $577,634 $1,250,000 $1,250,000 1.0000 $1,250,000 $1,664,788 $1,664,788 $1,827,634 2034 37,444 37,444 1.6811 62,948 3,053,007 3,053,007 1.4285 4,361,220 1,250,000 1,250,000 1.0000 1,250,000 4,340,451 4,340,451 5,674,168 2035 306,738 306,738 1.7446 535,135 3,548,660 3,548,660 1.4653 5,199,851 1,250,000 1,250,000 1.0000 1,250,000 5,105,398 5,105,398 6,984,986 2036 1,053,104 1,053,104 1.8106 1,906,750 5,763,066 5,763,066 1.5032 8,663,041 1,250,000 1,250,000 1.0000 1,250,000 8,066,170 8,066,170 11,819,791 2037 5,904,083 5,904,083 1.8790 11,093,772 20,305,477 20,305,477 1.5419 31,309,015 1,250,000 1,250,000 1.0000 1,250,000 27,459,560 27,459,560 43,652,788 2038 10,490,101 10,490,101 1.9501 20,456,745 32,009,812 32,009,812 1.5817 50,629,920 1,250,000 1,250,000 1.0000 1,250,000 43,749,913 43,749,913 72,336,666 2039 3,088,687 3,088,687 2.0238 6,250,884 145,048 145,048 1.6225 235,341 1,250,000 1,250,000 1.0000 1,250,000 4,483,735 4,483,735 7,736,225 2040 3,335,201 3,335,201 2.1003 7,004,922 1,827,178 1,827,178 1.6644 3,041,155 1,250,000 1,250,000 1.0000 1,250,000 6,412,379 6,412,379 11,296,077 2041 998,921 998,921 2.1797 2,177,349 1,103,354 1,103,354 1.7073 1,883,756 1,250,000 1,250,000 1.0000 1,250,000 3,352,275 3,352,275 5,311,104 2042 903,597 903,597 2.2620 2,043,937 806,152 806,152 1.7514 1,411,895 1,250,000 1,250,000 1.0000 1,250,000 2,959,750 2,959,750 4,705,832 2043 818,645 818,645 2.3475 1,921,770 541,289 541,289 1.7966 972,479 1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 4,144,249 2044 827,617 827,617 2.4363 2,016,323 550,652 550,652 1.8429 1,014,797 1,250,000 1,250,000 1.0000 1,250,000 2,628,269 2,628,269 4,281,120 2045 818,645 818,645 2.5284 2,069,863 541,289 541,289 1.8905 1,023,306 1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 4,343,169 2046 818,645 818,645 2.6239 2,148,044 541,289 541,289 1.9392 1,049,667 1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 4,447,711 2047 818,645 818,645 2.7231 2,229,253 541,289 541,289 1.9893 1,076,786 1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 4,556,039 2048 827,617 827,617 2.8261 2,338,928 550,652 550,652 2.0406 1,123,661 1,250,000 1,250,000 1.0000 1,250,000 2,628,269 2,628,269 4,712,589 2049 818,645 818,645 2.9329 2,401,005 541,289 541,289 2.0932 1,133,026 1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 4,784,031 2050 818,645 818,645 3.0438 2,491,793 541,289 541,289 2.1472 1,162,255 1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 4,904,048 2051 818,645 818,645 3.1588 2,585,937 541,289 541,289 2.2026 1,192,243 1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 5,028,180 2052 827,617 827,617 3.2782 2,713,093 550,652 550,652 2.2595 1,244,199 1,250,000 1,250,000 1.0000 1,250,000 2,628,269 2,628,269 5,207,292 2053 922,433 922,433 3.4021 3,138,209 852,651 852,651 2.3178 1,976,275 1,250,000 1,250,000 1.0000 1,250,000 3,025,084 3,025,084 6,364,484 2054 1,026,220 1,026,220 3.5307 3,623,276 1,164,014 1,164,014 2.3776 2,767,559 1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 7,640,835 2055 1,026,220 1,026,220 3.6642 3,760,277 1,164,014 1,164,014 2.4389 2,838,913 1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 7,849,190 2056 1,087,086 1,087,086 3.8027 4,133,860 1,329,059 1,329,059 2.5018 3,325,039 1,250,000 1,250,000 1.0000 1,250,000 3,666,144 3,666,144 8,708,899 2057 974,327 974,327 3.9464 3,845,083 1,008,332 1,008,332 2.5664 2,587,784 1,250,000 1,250,000 1.0000 1,250,000 3,232,659 3,232,659 7,682,867 2058 1,130,008 1,130,008 4.0956 4,628,060 1,475,376 1,475,376 2.6326 3,884,075 1,250,000 1,250,000 1.0000 1,250,000 3,855,384 3,855,384 9,762,136 2059 974,327 974,327 4.2504 4,141,278 1,008,332 1,008,332 2.7005 2,723,002 1,250,000 1,250,000 1.0000 1,250,000 3,232,659 3,232,659 8,114,280 2060 931,404 931,404 4.4111 4,108,518 862,015 862,015 2.7702 2,387,953 1,250,000 1,250,000 1.0000 1,250,000 3,043,419 3,043,419 7,746,471 2061 1,026,220 1,026,220 4.5778 4,697,832 1,164,014 1,164,014 2.8416 3,307,661 1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 9,255,493 2062 1,026,220 1,026,220 4.7509 4,875,470 1,164,014 1,164,014 2.9150 3,393,100 1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 9,518,570 2063 974,327 974,327 4.9305 4,803,917 1,008,332 1,008,332 2.9902 3,015,116 1,250,000 1,250,000 1.0000 1,250,000 3,232,659 3,232,659 9,069,033 2064 1,035,192 1,035,192 5.1168 5,296,869 1,173,377 1,173,377 3.0673 3,599,100 1,250,000 1,250,000 1.0000 1,250,000 3,458,569 3,458,569 10,145,970 2065 1,026,220 1,026,220 5.3103 5,449,538 1,164,014 1,164,014 3.1465 3,662,569 1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 10,362,107 2066 974,327 974,327 5.5110 5,369,514 1,008,332 1,008,332 3.2276 3,254,494 1,250,000 1,250,000 1.0000 1,250,000 3,232,659 3,232,659 9,874,008 2067 1,026,220 1,026,220 5.7193 5,869,262 1,164,014 1,164,014 3.3109 3,853,933 1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 10,973,195 2068 1,035,192 1,035,192 5.9355 6,144,381 1,173,377 1,173,377 3.3963 3,985,141 1,250,000 1,250,000 1.0000 1,250,000 3,458,569 3,458,569 11,379,522 2069 974,327 974,327 6.1598 6,001,657 1,008,332 1,008,332 3.4840 3,513,030 1,250,000 1,250,000 1.0000 1,250,000 3,232,659 3,232,659 10,764,687 2070 1,026,220 1,026,220 6.3927 6,560,319 1,164,014 1,164,014 3.5738 4,159,952 1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 11,970,271 2071 1,026,220 1,026,220 6.6343 6,808,254 1,164,014 1,164,014 3.6660 4,267,274 1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 12,325,528 2072 1,035,192 1,035,192 6.8851 7,127,399 1,173,377 1,173,377 3.7606 4,412,603 1,250,000 1,250,000 1.0000 1,250,000 3,458,569 3,458,569 12,790,002 2073 1,026,220 1,026,220 7.1454 7,332,755 1,164,014 1,164,014 3.8576 4,490,299 1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 13,073,054 2074 1,026,220 1,026,220 7.4155 7,609,937 1,164,014 1,164,014 3.9572 4,606,235 1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 13,466,172 2075 1,385,963 1,385,963 7.6958 10,666,097 2,243,243 2,243,243 4.0593 9,105,995 1,250,000 1,250,000 1.0000 1,250,000 4,879,206 4,879,206 21,022,092 2076 1,035,192 1,035,192 7.9867 8,267,766 1,173,377 1,173,377 4.1640 4,885,943 1,250,000 1,250,000 1.0000 1,250,000 3,458,569 3,458,569 14,403,710 2077 900,620 900,620 8.2886 7,464,878 1,088,291 1,088,291 4.2714 4,648,527 1,250,000 1,250,000 1.0000 1,250,000 3,238,911 3,238,911 13,363,406 2078 (1,983,587) (1,983,587) 8.6019 (17,062,614) 3,461,500 3,461,500 4.3816 15,166,909 0 0 1.0000 0 1,477,914 1,477,914 (1,895,705)

$57,979,775 $57,979,775 $199,110,243 $107,104,965 $107,104,965 $228,123,732 $56,250,000 $56,250,000 $56,250,000 $221,334,740 $221,334,740 $483,483,975

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s Prairie Island Unit 2 Factors 2020 100.0000% 3.78% 2.58% 0.00%

2034 $67,041 $67,041 1.6811 $112,703 ($67,041) ($67,041) 1.4285 ($95,768) $1,002,968 $1,002,968 1.0000 $1,002,968 $1,002,968 $1,002,968 $1,019,902 2035 355,670 355,670 1.7446 620,501 4,007,683 4,007,683 1.4653 5,872,458 1,250,000 1,250,000 1.0000 1,250,000 5,613,353 5,613,353 7,742,959 2036 1,252,695 1,252,695 1.8106 2,268,129 6,474,164 6,474,164 1.5032 9,731,964 1,250,000 1,250,000 1.0000 1,250,000 8,976,859 8,976,859 13,250,093 2037 4,663,495 4,663,495 1.8790 8,762,708 16,583,709 16,583,709 1.5419 25,570,421 1,250,000 1,250,000 1.0000 1,250,000 22,497,204 22,497,204 35,583,129 2038 11,452,573 11,452,573 1.9501 22,333,663 34,897,219 34,897,219 1.5817 55,196,931 1,250,000 1,250,000 1.0000 1,250,000 47,599,792 47,599,792 78,780,594 2039 3,088,687 3,088,687 2.0238 6,250,884 145,048 145,048 1.6225 235,341 1,250,000 1,250,000 1.0000 1,250,000 4,483,735 4,483,735 7,736,225 2040 3,335,201 3,335,201 2.1003 7,004,922 1,827,178 1,827,178 1.6644 3,041,155 1,250,000 1,250,000 1.0000 1,250,000 6,412,379 6,412,379 11,296,077 2041 3,454,858 3,454,858 2.1797 7,530,554 2,729,783 2,729,783 1.7073 4,660,559 1,250,000 1,250,000 1.0000 1,250,000 7,434,641 7,434,641 13,441,113 2042 896,869 896,869 2.2620 2,028,717 801,696 801,696 1.7514 1,404,091 1,250,000 1,250,000 1.0000 1,250,000 2,948,565 2,948,565 4,682,808 2043 811,917 811,917 2.3475 1,905,975 536,833 536,833 1.7966 964,474 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 4,120,448 2044 820,888 820,888 2.4363 1,999,930 546,196 546,196 1.8429 1,006,585 1,250,000 1,250,000 1.0000 1,250,000 2,617,085 2,617,085 4,256,515 2045 811,917 811,917 2.5284 2,052,850 536,833 536,833 1.8905 1,014,882 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 4,317,733 2046 811,917 811,917 2.6239 2,130,388 536,833 536,833 1.9392 1,041,026 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 4,421,415 2047 811,917 811,917 2.7231 2,210,931 536,833 536,833 1.9893 1,067,921 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 4,528,852 2048 820,888 820,888 2.8261 2,319,912 546,196 546,196 2.0406 1,114,568 1,250,000 1,250,000 1.0000 1,250,000 2,617,085 2,617,085 4,684,481 2049 811,917 811,917 2.9329 2,381,271 536,833 536,833 2.0932 1,123,698 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 4,754,969 2050 811,917 811,917 3.0438 2,471,312 536,833 536,833 2.1472 1,152,687 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 4,874,000 2051 811,917 811,917 3.1588 2,564,683 536,833 536,833 2.2026 1,182,428 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 4,997,111 2052 820,888 820,888 3.2782 2,691,036 546,196 546,196 2.2595 1,234,131 1,250,000 1,250,000 1.0000 1,250,000 2,617,085 2,617,085 5,175,166 2053 915,704 915,704 3.4021 3,115,317 848,195 848,195 2.3178 1,965,947 1,250,000 1,250,000 1.0000 1,250,000 3,013,900 3,013,900 6,331,264 2054 1,019,492 1,019,492 3.5307 3,599,520 1,159,558 1,159,558 2.3776 2,756,964 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 7,606,484 2055 1,019,492 1,019,492 3.6642 3,735,622 1,159,558 1,159,558 2.4389 2,828,045 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 7,813,667 2056 1,080,357 1,080,357 3.8027 4,108,273 1,324,603 1,324,603 2.5018 3,313,891 1,250,000 1,250,000 1.0000 1,250,000 3,654,960 3,654,960 8,672,164 2057 967,598 967,598 3.9464 3,818,529 1,003,876 1,003,876 2.5664 2,576,349 1,250,000 1,250,000 1.0000 1,250,000 3,221,475 3,221,475 7,644,877 2058 1,123,279 1,123,279 4.0956 4,600,503 1,470,920 1,470,920 2.6326 3,872,345 1,250,000 1,250,000 1.0000 1,250,000 3,844,200 3,844,200 9,722,847 2059 967,598 967,598 4.2504 4,112,679 1,003,876 1,003,876 2.7005 2,710,968 1,250,000 1,250,000 1.0000 1,250,000 3,221,475 3,221,475 8,073,647 2060 924,676 924,676 4.4111 4,078,837 857,559 857,559 2.7702 2,375,610 1,250,000 1,250,000 1.0000 1,250,000 3,032,235 3,032,235 7,704,447 2061 1,019,492 1,019,492 4.5778 4,667,029 1,159,558 1,159,558 2.8416 3,294,999 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 9,212,029 2062 1,019,492 1,019,492 4.7509 4,843,503 1,159,558 1,159,558 2.9150 3,380,111 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 9,473,614 2063 967,598 967,598 4.9305 4,770,742 1,003,876 1,003,876 2.9902 3,001,791 1,250,000 1,250,000 1.0000 1,250,000 3,221,475 3,221,475 9,022,533 2064 1,028,463 1,028,463 5.1168 5,262,441 1,168,921 1,168,921 3.0673 3,585,432 1,250,000 1,250,000 1.0000 1,250,000 3,447,385 3,447,385 10,097,873 2065 1,019,492 1,019,492 5.3103 5,413,807 1,159,558 1,159,558 3.1465 3,648,548 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 10,312,356 2066 967,598 967,598 5.5110 5,332,433 1,003,876 1,003,876 3.2276 3,240,112 1,250,000 1,250,000 1.0000 1,250,000 3,221,475 3,221,475 9,822,544 2067 1,019,492 1,019,492 5.7193 5,830,779 1,159,558 1,159,558 3.3109 3,839,180 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 10,919,959 2068 1,028,463 1,028,463 5.9355 6,104,443 1,168,921 1,168,921 3.3963 3,970,008 1,250,000 1,250,000 1.0000 1,250,000 3,447,385 3,447,385 11,324,451 2069 967,598 967,598 6.1598 5,960,210 1,003,876 1,003,876 3.4840 3,497,506 1,250,000 1,250,000 1.0000 1,250,000 3,221,475 3,221,475 10,707,716 2070 1,019,492 1,019,492 6.3927 6,517,305 1,159,558 1,159,558 3.5738 4,144,027 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 11,911,332 2071 1,019,492 1,019,492 6.6343 6,763,614 1,159,558 1,159,558 3.6660 4,250,939 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 12,264,553 2072 1,028,463 1,028,463 6.8851 7,081,072 1,168,921 1,168,921 3.7606 4,395,846 1,250,000 1,250,000 1.0000 1,250,000 3,447,385 3,447,385 12,726,918 2073 1,019,492 1,019,492 7.1454 7,284,676 1,159,558 1,159,558 3.8576 4,473,110 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 13,007,786 2074 1,019,492 1,019,492 7.4155 7,560,041 1,159,558 1,159,558 3.9572 4,588,602 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 13,398,643 2075 1,379,235 1,379,235 7.6958 10,614,315 2,238,787 2,238,787 4.0593 9,087,907 1,250,000 1,250,000 1.0000 1,250,000 4,868,021 4,868,021 20,952,222 2076 1,028,463 1,028,463 7.9867 8,214,027 1,168,921 1,168,921 4.1640 4,867,389 1,250,000 1,250,000 1.0000 1,250,000 3,447,385 3,447,385 14,331,416 2077 893,891 893,891 8.2886 7,409,108 1,083,835 1,083,835 4.2714 4,629,494 1,250,000 1,250,000 1.0000 1,250,000 3,227,727 3,227,727 13,288,602 2078 (1,990,315) (1,990,315) 8.6019 (17,120,493) 3,457,044 3,457,044 4.3816 15,147,385 0 - 1.0000 - 1,466,729 1,466,729 (1,973,108)

$60,186,758 $60,186,758 $203,319,403 $105,367,447 $105,367,447 $225,962,057 $54,752,968 $54,752,968 $54,752,968 $220,307,173 $220,307,173 $484,034,427

$282,703,639 $282,703,639 $1,092,747,318 $465,997,833 $465,997,833 $1,050,612,494 $111,002,968 $111,002,968 $111,002,968 $859,704,439 $859,704,439 $2,254,362,780

L-XE-21-004 NSPM ENCLOSURE 7 ANNUAL ACCRUAL

SUMMARY

- SITE RESTORATION 4 Pages Follow

Operational Post-Shutdown Market Unrealized Tax-Adjusted Remaining Earnings Earnings Value Balance Book Value Gain/Loss Tax-Effect Fund Balance Life (yrs) Rate Rate 1/1/2021 1/1/2021 1/1/2021 Adjustment 1/1/2021 Accrual Monticello 9.75 3.80% 3.10% $76,002,116 $49,890,265 $26,111,851 $7,269,539 $68,732,576 $2,081,600 Prairie Island Unit 1 12.67 4.01% 2.80% 25,286,899 16,220,565 9,066,334 2,524,067 22,762,832 0 Prairie Island Unit 2 13.83 3.98% 2.72% 60,943,571 39,153,139 21,790,431 6,066,456 54,877,115 0 TOTAL DECOMMISSIONING ACCRUAL $162,232,586 $105,263,970 $56,968,616 $15,860,063 $146,372,523 $2,081,600 INPUT DATA Escalation Rate (Labor) 3.78%

Escalation Rate (Non-Labor) 2.58%

Escalation Rate (PIIC) 0.00%

Jurisdictional Factor 100.0000%

Tax Rate for tax-effect adjustment 27.84%

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s Monticello Factors 2020 100.0000% 3.78% 2.58% 0.00%

2030 $173,165 $173,165 1.4492 $250,951 $0 $0 1.2901 $0 $0 $0 1.0000 $0 $173,165 $173,165 $250,951 2031 668,922 668,922 1.5040 1,006,058 0 0 1.3234 0 0 0 1.0000 0 668,922 668,922 1,006,058 2032 183,897 183,897 1.5609 287,045 21,308 21,308 1.3575 28,925 0 0 1.0000 0 205,205 205,205 315,970 2033 14,301 14,301 1.6199 23,167 16,470 16,470 1.3926 22,936 0 0 1.0000 0 30,772 30,772 46,103 2034 7,256 7,256 1.6811 12,197 148 148 1.4285 211 0 0 1.0000 0 7,403 7,403 12,408 2035 0 0 1.7446 0 0 0 1.4653 0 0 0 1.0000 0 0 0 0 2036 22,030,415 22,030,415 1.8106 39,888,269 10,533,117 10,533,117 1.5032 15,833,382 0 0 1.0000 0 32,563,532 32,563,532 55,721,651 2037 25,081,925 25,081,925 1.8790 47,128,937 11,992,097 11,992,097 1.5419 18,490,614 0 0 1.0000 0 37,074,022 37,074,022 65,619,551 2038 0 0 1.9501 0 0 0 1.5817 0 0 0 1.0000 0 0 0 0 2039 0 0 2.0238 0 0 0 1.6225 0 0 0 1.0000 0 0 0 0 2040 0 0 2.1003 0 0 0 1.6644 0 0 0 1.0000 0 0 0 0 2041 0 0 2.1797 0 0 0 1.7073 0 0 0 1.0000 0 0 0 0 2042 0 0 2.2620 0 0 0 1.7514 0 0 0 1.0000 0 0 0 0 2043 0 0 2.3475 0 0 0 1.7966 0 0 0 1.0000 0 0 0 0 2044 0 0 2.4363 0 0 0 1.8429 0 0 0 1.0000 0 0 0 0 2045 0 0 2.5284 0 0 0 1.8905 0 0 0 1.0000 0 0 0 0 2046 0 0 2.6239 0 0 0 1.9392 0 0 0 1.0000 0 0 0 0 2047 0 0 2.7231 0 0 0 1.9893 0 0 0 1.0000 0 0 0 0 2048 0 0 2.8261 0 0 0 2.0406 0 0 0 1.0000 0 0 0 0 2049 0 0 2.9329 0 0 0 2.0932 0 0 0 1.0000 0 0 0 0 2050 0 0 3.0438 0 0 0 2.1472 0 0 0 1.0000 0 0 0 0 2051 0 0 3.1588 0 0 0 2.2026 0 0 0 1.0000 0 0 0 0 2052 0 0 3.2782 0 0 0 2.2595 0 0 0 1.0000 0 0 0 0 2053 0 0 3.4021 0 0 0 2.3178 0 0 0 1.0000 0 0 0 0 2054 0 0 3.5307 0 0 0 2.3776 0 0 0 1.0000 0 0 0 0 2055 0 0 3.6642 0 0 0 2.4389 0 0 0 1.0000 0 0 0 0 2056 0 0 3.8027 0 0 0 2.5018 0 0 0 1.0000 0 0 0 0 2057 0 0 3.9464 0 0 0 2.5664 0 0 0 1.0000 0 0 0 0 2058 0 0 4.0956 0 0 0 2.6326 0 0 0 1.0000 0 0 0 0 2059 0 0 4.2504 0 0 0 2.7005 0 0 0 1.0000 0 0 0 0 2060 0 0 4.4111 0 0 0 2.7702 0 0 0 1.0000 0 0 0 0 2061 0 0 4.5778 0 0 0 2.8416 0 0 0 1.0000 0 0 0 0 2062 0 0 4.7509 0 0 0 2.9150 0 0 0 1.0000 0 0 0 0 2063 0 0 4.9305 0 0 0 2.9902 0 0 0 1.0000 0 0 0 0 2064 0 0 5.1168 0 0 0 3.0673 0 0 0 1.0000 0 0 0 0 2065 0 0 5.3103 0 0 0 3.1465 0 0 0 1.0000 0 0 0 0 2066 0 0 5.5110 0 0 0 3.2276 0 0 0 1.0000 0 0 0 0 2067 0 0 5.7193 0 0 0 3.3109 0 0 0 1.0000 0 0 0 0 2068 0 0 5.9355 0 0 0 3.3963 0 0 0 1.0000 0 0 0 0 2069 0 0 6.1598 0 0 0 3.4840 0 0 0 1.0000 0 0 0 0 2070 0 0 6.3927 0 0 0 3.5738 0 0 0 1.0000 0 0 0 0 2071 0 0 6.6343 0 0 0 3.6660 0 0 0 1.0000 0 0 0 0 2072 0 0 6.8851 0 0 0 3.7606 0 0 0 1.0000 0 0 0 0 2073 0 0 7.1454 0 0 0 3.8576 0 0 0 1.0000 0 0 0 0 2074 0 0 7.4155 0 0 0 3.9572 0 0 0 1.0000 0 0 0 0 2075 0 0 7.6958 0 0 0 4.0593 0 0 0 1.0000 0 0 0 0 2076 0 0 7.9867 0 0 0 4.1640 0 0 0 1.0000 0 0 0 0 2077 0 0 8.2886 0 0 0 4.2714 0 0 0 1.0000 0 0 0 0 2078 0 0 8.6019 0 0 0 4.3816 0 0 0 1.0000 0 0 0 0 2079 0 0 8.9270 0 0 0 4.4947 0 0 0 1.0000 0 0 0 0 2080 0 0 9.2645 0 0 0 4.6106 0 0 0 1.0000 0 0 0 0 2081 0 0 9.6147 0 0 0 4.7296 0 0 0 1.0000 0 0 0 0 2082 0 0 9.9781 0 0 0 4.8516 0 0 0 1.0000 0 0 0 0 2083 0 0 10.3553 0 0 0 4.9768 0 0 0 1.0000 0 0 0 0 2084 0 0 10.7467 0 0 0 5.1052 0 0 0 1.0000 0 0 0 0

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s 2085 0 0 11.1529 0 0 0 5.2369 0 0 0 1.0000 0 0 0 0 2086 0 0 11.5745 0 0 0 5.3720 0 0 0 1.0000 0 0 0 0 2087 0 0 12.0120 0 0 0 5.5106 0 0 0 1.0000 0 0 0 0 2088 0 0 12.4661 0 0 0 5.6528 0 0 0 1.0000 0 0 0 0 2089 0 0 12.9373 0 0 0 5.7986 0 0 0 1.0000 0 0 0 0 2090 0 0 13.4263 0 0 0 5.9482 0 0 0 1.0000 0 0 0 0 2091 1,040,469 1,040,469 13.9338 14,497,687 1,622,689 1,622,689 6.1017 9,901,163 0 0 1.0000 0 2,663,158 2,663,158 24,398,850

$49,200,350 $49,200,350 $103,094,312 $24,185,829 $24,185,829 $44,277,231 $0 $0 $0 $73,386,179 $73,386,179 $147,371,544

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s Prairie Island Unit 1 Factors 2020 100.0000% 3.78% 2.58% 0.00%

2033 $265,310 $265,310 1.6199 $429,776 $0 $0 1.3926 $0 $0 $0 1.0000 $0 $265,310 $265,310 $429,776 2034 1,138,697 1,138,697 1.6811 1,914,263 0 0 1.4285 0 0 0 1.0000 0 1,138,697 1,138,697 1,914,263 2035 1,709,530 1,709,530 1.7446 2,982,446 45,895 45,895 1.4653 67,249 0 0 1.0000 0 1,755,424 1,755,424 3,049,695 2036 2,228,491 2,228,491 1.8106 4,034,906 53,968 53,968 1.5032 81,124 0 0 1.0000 0 2,282,459 2,282,459 4,116,031 2037 1,691,408 1,691,408 1.8790 3,178,156 34,268 34,268 1.5419 52,837 0 0 1.0000 0 1,725,676 1,725,676 3,230,993 2038 0 0 1.9501 0 0 0 1.5817 0 0 0 1.0000 0 0 0 0 2039 0 0 2.0238 0 0 0 1.6225 0 0 0 1.0000 0 0 0 0 2040 7,645,228 7,645,228 2.1003 16,057,272 5,473,121 5,473,121 1.6644 9,109,462 0 0 1.0000 0 13,118,349 13,118,349 25,166,735 2041 11,774,296 11,774,296 2.1797 25,664,434 8,429,068 8,429,068 1.7073 14,390,947 0 0 1.0000 0 20,203,364 20,203,364 40,055,381 2042 5,548,436 5,548,436 2.2620 12,550,561 3,972,054 3,972,054 1.7514 6,956,655 0 0 1.0000 0 9,520,489 9,520,489 19,507,216 2043 0 0 2.3475 0 0 0 1.7966 0 0 0 1.0000 0 0 0 0 2044 0 0 2.4363 0 0 0 1.8429 0 0 0 1.0000 0 0 0 0 2045 0 0 2.5284 0 0 0 1.8905 0 0 0 1.0000 0 0 0 0 2046 0 0 2.6239 0 0 0 1.9392 0 0 0 1.0000 0 0 0 0 2047 0 0 2.7231 0 0 0 1.9893 0 0 0 1.0000 0 0 0 0 2048 0 0 2.8261 0 0 0 2.0406 0 0 0 1.0000 0 0 0 0 2049 0 0 2.9329 0 0 0 2.0932 0 0 0 1.0000 0 0 0 0 2050 0 0 3.0438 0 0 0 2.1472 0 0 0 1.0000 0 0 0 0 2051 0 0 3.1588 0 0 0 2.2026 0 0 0 1.0000 0 0 0 0 2052 0 0 3.2782 0 0 0 2.2595 0 0 0 1.0000 0 0 0 0 2053 0 0 3.4021 0 0 0 2.3178 0 0 0 1.0000 0 0 0 0 2054 0 0 3.5307 0 0 0 2.3776 0 0 0 1.0000 0 0 0 0 2055 0 0 3.6642 0 0 0 2.4389 0 0 0 1.0000 0 0 0 0 2056 0 0 3.8027 0 0 0 2.5018 0 0 0 1.0000 0 0 0 0 2057 0 0 3.9464 0 0 0 2.5664 0 0 0 1.0000 0 0 0 0 2058 0 0 4.0956 0 0 0 2.6326 0 0 0 1.0000 0 0 0 0 2059 0 0 4.2504 0 0 0 2.7005 0 0 0 1.0000 0 0 0 0 2060 0 0 4.4111 0 0 0 2.7702 0 0 0 1.0000 0 0 0 0 2061 0 0 4.5778 0 0 0 2.8416 0 0 0 1.0000 0 0 0 0 2062 0 0 4.7509 0 0 0 2.9150 0 0 0 1.0000 0 0 0 0 2063 0 0 4.9305 0 0 0 2.9902 0 0 0 1.0000 0 0 0 0 2064 0 0 5.1168 0 0 0 3.0673 0 0 0 1.0000 0 0 0 0 2065 0 0 5.3103 0 0 0 3.1465 0 0 0 1.0000 0 0 0 0 2066 0 0 5.5110 0 0 0 3.2276 0 0 0 1.0000 0 0 0 0 2067 0 0 5.7193 0 0 0 3.3109 0 0 0 1.0000 0 0 0 0 2068 0 0 5.9355 0 0 0 3.3963 0 0 0 1.0000 0 0 0 0 2069 0 0 6.1598 0 0 0 3.4840 0 0 0 1.0000 0 0 0 0 2070 0 0 6.3927 0 0 0 3.5738 0 0 0 1.0000 0 0 0 0 2071 0 0 6.6343 0 0 0 3.6660 0 0 0 1.0000 0 0 0 0 2072 0 0 6.8851 0 0 0 3.7606 0 0 0 1.0000 0 0 0 0 2073 0 0 7.1454 0 0 0 3.8576 0 0 0 1.0000 0 0 0 0 2074 0 0 7.4155 0 0 0 3.9572 0 0 0 1.0000 0 0 0 0 2075 0 0 7.6958 0 0 0 4.0593 0 0 0 1.0000 0 0 0 0 2076 0 0 7.9867 0 0 0 4.1640 0 0 0 1.0000 0 0 0 0 2077 0 0 8.2886 0 0 0 4.2714 0 0 0 1.0000 0 0 0 0 2078 413,385 413,385 8.6019 3,555,899 575,255 575,255 4.3816 2,520,538 0 0 1.0000 0 988,640 988,640 6,076,437

$32,414,781 $32,414,781 $70,367,713 $18,583,627 $18,583,627 $33,178,813 $0 $0 $0 $50,998,409 $50,998,409 $103,546,526

AMOUNT TO RECOVER LABOR NON-LABOR PIIC Payment Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Cost Jurisdictional Jurisdictional Total Cost Total Jurisdictional Total Jurisdictional Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Escalation Cost in Estimate Cost in Cost in Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Factor Future $'s Nominal $s Nominal $s Future $'s Prairie Island Unit 2 Factors 2020 100.0000% 3.78% 2.58% 0.00%

2034 $50,073 $50,073 1.6811 $84,178 $0 $0 1.4285 $0 $0 $0 1.0000 $0 $50,073 $50,073 $84,178 2035 374,437 374,437 1.7446 653,243 0 - 1.4653 - 0 - 1.0000 - 374,437 374,437 653,243 2036 1,628,631 1,628,631 1.8106 2,948,799 41,278 41,278 1.5032 62,050 0 - 1.0000 - 1,669,909 1,669,909 3,010,848 2037 2,302,182 2,302,182 1.8790 4,325,799 61,319 61,319 1.5419 94,548 0 - 1.0000 - 2,363,501 2,363,501 4,420,348 2038 2,579,208 2,579,208 1.9501 5,029,713 51,935 51,935 1.5817 82,146 0 - 1.0000 - 2,631,143 2,631,143 5,111,859 2039 0 - 2.0238 - 0 - 1.6225 - 0 - 1.0000 - 0 0 -

2040 9,483,681 9,483,681 2.1003 19,918,574 10,325,214 10,325,214 1.6644 17,185,287 0 - 1.0000 - 19,808,895 19,808,895 37,103,861 2041 14,605,668 14,605,668 2.1797 31,835,975 15,901,701 15,901,701 1.7073 27,148,975 0 - 1.0000 - 30,507,370 30,507,370 58,984,950 2042 6,882,671 6,882,671 2.2620 15,568,602 7,493,404 7,493,404 1.7514 13,123,949 0 - 1.0000 - 14,376,076 14,376,076 28,692,551 2043 0 - 2.3475 - 0 - 1.7966 - 0 - 1.0000 - 0 0 -

2044 0 - 2.4363 - 0 - 1.8429 - 0 - 1.0000 - 0 0 -

2045 0 - 2.5284 - 0 - 1.8905 - 0 - 1.0000 - 0 0 -

2046 0 - 2.6239 - 0 - 1.9392 - 0 - 1.0000 - 0 0 -

2047 0 - 2.7231 - 0 - 1.9893 - 0 - 1.0000 - 0 0 -

2048 0 - 2.8261 - 0 - 2.0406 - 0 - 1.0000 - 0 0 -

2049 0 - 2.9329 - 0 - 2.0932 - 0 - 1.0000 - 0 0 -

2050 0 - 3.0438 - 0 - 2.1472 - 0 - 1.0000 - 0 0 -

2051 0 - 3.1588 - 0 - 2.2026 - 0 - 1.0000 - 0 0 -

2052 0 - 3.2782 - 0 - 2.2595 - 0 - 1.0000 - 0 0 -

2053 0 - 3.4021 - 0 - 2.3178 - 0 - 1.0000 - 0 0 -

2054 0 - 3.5307 - 0 - 2.3776 - 0 - 1.0000 - 0 0 -

2055 0 - 3.6642 - 0 - 2.4389 - 0 - 1.0000 - 0 0 -

2056 0 - 3.8027 - 0 - 2.5018 - 0 - 1.0000 - 0 0 -

2057 0 - 3.9464 - 0 - 2.5664 - 0 - 1.0000 - 0 0 -

2058 0 - 4.0956 - 0 - 2.6326 - 0 - 1.0000 - 0 0 -

2059 0 - 4.2504 - 0 - 2.7005 - 0 - 1.0000 - 0 0 -

2060 0 - 4.4111 - 0 - 2.7702 - 0 - 1.0000 - 0 0 -

2061 0 - 4.5778 - 0 - 2.8416 - 0 - 1.0000 - 0 0 -

2062 0 - 4.7509 - 0 - 2.9150 - 0 - 1.0000 - 0 0 -

2063 0 - 4.9305 - 0 - 2.9902 - 0 - 1.0000 - 0 0 -

2064 0 - 5.1168 - 0 - 3.0673 - 0 - 1.0000 - 0 0 -

2065 0 - 5.3103 - 0 - 3.1465 - 0 - 1.0000 - 0 0 -

2066 0 - 5.5110 - 0 - 3.2276 - 0 - 1.0000 - 0 0 -

2067 0 - 5.7193 - 0 - 3.3109 - 0 - 1.0000 - 0 0 -

2068 0 - 5.9355 - 0 - 3.3963 - 0 - 1.0000 - 0 0 -

2069 0 - 6.1598 - 0 - 3.4840 - 0 - 1.0000 - 0 0 -

2070 0 - 6.3927 - 0 - 3.5738 - 0 - 1.0000 - 0 0 -

2071 0 - 6.6343 - 0 - 3.6660 - 0 - 1.0000 - 0 0 -

2072 0 - 6.8851 - 0 - 3.7606 - 0 - 1.0000 - 0 0 -

2073 0 - 7.1454 - 0 - 3.8576 - 0 - 1.0000 - 0 0 -

2074 0 - 7.4155 - 0 - 3.9572 - 0 - 1.0000 - 0 0 -

2075 0 - 7.6958 - 0 - 4.0593 - 0 - 1.0000 - 0 0 -

2076 0 - 7.9867 - 0 - 4.1640 - 0 - 1.0000 - 0 0 -

2077 0 - 8.2886 - 0 - 4.2714 - 0 - 1.0000 - 0 0 -

2078 413,385 413,385 8.6019 3,555,899 575,255 575,255 4.3816 2,520,538 0 - 1.0000 - 988,640 988,640 6,076,437

$38,319,936 $38,319,936 $83,920,783 $34,450,108 $34,450,108 $60,217,491 $0 $0 $0 $72,770,044 $72,770,044 $144,138,274

$119,935,068 $119,935,068 $257,382,809 $77,219,564 $77,219,564 $137,673,536 $0 $0 $0 $197,154,632 $197,154,632 $395,056,345

L-XE-21-004 NSPM ENCLOSURE 8 ANNUAL ACCRUAL

SUMMARY

- ITEMIZED TRUST FUND BALANCES 4 Pages Follow

NSP-Minnesota NRC Biennial Trust Funding Status Report Trust Fund Balance - By Components December 31, 2019 Balances as of January 01, 2020 External Qualified Book Value Market Adjustment Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 Radiological 479,003,270 400,724,579 388,457,537 183,512,051 167,561,294 162,097,252 662,515,321 568,285,872 550,554,789 Spent Fuel 263,874,323 37,190,687 80,817,150 101,093,502 15,551,129 33,723,732 364,967,826 52,741,816 114,540,883 Site Restoration 47,817,026 10,519,631 31,690,910 18,319,291 4,398,739 13,224,121 66,136,317 14,918,371 44,915,031 Total 790,694,620 448,434,897 500,965,597 302,924,844 187,511,162 209,045,105 1,093,619,464 635,946,058 710,010,701

NSP-Minnesota NRC Biennial Trust Funding Status Report Trust Fund Balances - By Jurisdiction December 31, 2019 Balances as of January 01, 2020 External Qualified Book Value Market Adjust Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 MN Retail 582,627,195 330,055,759 369,069,095 223,719,288 138,350,877 154,528,365 806,346,482 468,406,636 523,597,460 ND Retail 37,455,546 24,868,014 26,337,555 15,578,757 10,312,595 11,397,967 53,034,303 35,180,609 37,735,522 SD Retail 25,610,361 18,857,665 20,934,117 10,257,590 7,829,356 8,931,063 35,867,951 26,687,021 29,865,180 MN FERC 10,136,588 8,112,332 7,528,546 4,738,389 3,692,492 3,181,859 14,874,977 11,804,825 10,710,405 WI FERC 10,726,291 6,416,304 6,060,873 4,173,001 860,493 2,400,746 14,899,292 7,276,797 8,461,620 WI Retail 124,138,639 60,124,823 71,035,411 44,457,820 26,465,349 28,605,105 168,596,459 86,590,172 99,640,517 Total 790,694,620 448,434,897 500,965,597 302,924,844 187,511,162 209,045,105 1,093,619,464 635,946,059 710,010,702

NSP-Minnesota NRC Biennial Trust Funding Status Report Trust Fund Balance - By Components December 31, 2020 Balances as of January 01, 2021 External Qualified Book Value Market Adjustment Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 Radiological 499,771,778 386,972,418 376,075,799 261,573,397 216,294,627 209,302,598 761,345,175 603,267,045 585,378,397 Spent Fuel 275,315,322 57,345,544 99,847,092 144,096,100 32,052,757 55,569,265 419,411,422 89,398,301 155,416,356 Site Restoration 49,890,265 16,220,565 39,153,139 26,111,851 9,066,334 21,790,431 76,002,116 25,286,899 60,943,571 Total 824,977,365 460,538,528 515,076,030 431,781,348 257,413,718 286,662,294 1,256,758,713 717,952,246 801,738,324

NSP-Minnesota NRC Biennial Trust Funding Status Report Trust Fund Balances - By Jurisdiction December 31, 2020 Balances as of January 01, 2021 External Qualified Book Value Market Adjust Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 MN Retail 607,765,632 338,659,461 378,928,528 318,712,388 189,804,703 211,709,480 926,478,020 528,464,164 590,638,008 ND Retail 38,499,609 25,510,485 27,005,367 21,759,623 14,176,742 15,514,479 60,259,232 39,687,227 42,519,846 SD Retail 26,952,100 19,489,930 21,737,427 14,507,633 10,775,936 12,218,027 41,459,733 30,265,866 33,955,454 MN FERC 10,351,225 8,327,913 7,718,090 6,463,398 4,989,104 4,350,241 16,814,623 13,317,017 12,068,331 WI FERC 10,941,279 6,549,194 6,210,620 5,900,830 1,659,758 3,323,812 16,842,109 8,208,951 9,534,432 WI Retail 130,467,521 62,001,545 73,475,998 64,437,475 36,007,475 39,546,255 194,904,996 98,009,021 113,022,253 Total 824,977,365 460,538,528 515,076,030 431,781,348 257,413,718 286,662,294 1,256,758,713 717,952,246 801,738,324

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