ML23089A076

From kanterella
Jump to navigation Jump to search
Decommissioning Funding Status Reports
ML23089A076
Person / Time
Site: Monticello Xcel Energy icon.png
Issue date: 03/29/2023
From: Scott S
Northern States Power Company, Minnesota, Xcel Energy
To:
Office of Nuclear Reactor Regulation, Document Control Desk
References
L-XE-23-005
Download: ML23089A076 (1)
v • d • e


Text

414 Nicollet Mall Minneapolis, MN 55401 March 29, 2023 L-XE-23-005 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, 2022.

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

Digitally signed by Sara L.

Sara L. Scott Scott Date: 2023.03.29 19:11:22

-05'00' Sara L. Scott 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-23-005 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 2022 dollars. $496,262,803
2. The amount accumulated at the end of the calendar year External preceding the date of the report. Qualified $532,907,303
3. A schedule of the annual amounts remaining to be collected Annual Years to for radiological costs through rates from customers. Annuity Collect

$17,106,209 10.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 3.94% 4.22% -0.28%

- During Operations (Radiological)

Xcel Energy (100%) - PINGP Unit 1 2.98% 4.22% -1.24%

- 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.28% during operations and -1.24% 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-23-005 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 2022 dollars. $496,262,803
2. The amount accumulated at the end of the calendar year External preceding the date of the report. Qualified $573,276,420
3. A schedule of the annual amounts remaining to be collected for Annual Years to radiological costs through rates on customers. Annuity Collect

$10,997,348 11.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 4.02% 4.22% -0.20%

- During Operations (Radiological)

Xcel Energy (100%)- PINGP Unit 2 2.90% 4.22% -1.32%

- 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.32% 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-23-005 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 2022 dollars. $638,236,757
2. The amount accumulated for Radiological Decommissioning at External the end of the calendar year preceding the date of the report. Qualified $800,341,944
3. A schedule of the annual amounts remaining to be collected Annual Years to for radiological costs through rates from customers. Annuity Collect

$4,555,674 17.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.98% 4.22% -0.%

During Operations (Radiological)

Xcel Energy (100%)- Monticello - 3.31% 4.22% -0.91%

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.% during operations and -0.91% post-shutdown would accumulate sufficient decommissioning funds by the projected 2040 end of operations date as reported on the MPUC docket.

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-23-005 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 2022 2023 Radiological Decommissioning 675,717,230 532,907,303 Spent Fuel Management 127,697,837 173,509,260 Site Restoration 35,878,945 48,750,467 Total 839,294,013 755,167,030 Prairie Island Unit 2 2022 2023 Radiological Decommissioning 655,004,061 573,276,420 Spent Fuel Management 202,671,945 184,760,809 Site Restoration 78,944,398 71,967,686 Total 936,620,405 830,004,916 Monticello 2022 2023 Radiological Decommissioning 883,961,067 800,341,944 Spent Fuel Management 504,951,141 420,675,780 Site Restoration 91,487,309 76,218,255 Total 1,480,399,516 1,297,235,979 Page 1 of 2

L-XE-23-005 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 2022 2023 Radiological Decommissioning 1,218,546 17,106,209 Spent Fuel Management 0 1,324,561 Site Restoration 0 372,159 Total 1,218,546 18,802,929 Prairie Island Unit 2 2022 2023 Radiological Decommissioning 1,978,411 10,997,348 Spent Fuel Management 0 0 Site Restoration 0 0 Total 1,978,411 10,997,348 Monticello 2022 2023 Radiological Decommissioning 0 4,555,674 Spent Fuel Management 16,211,134 0 Site Restoration 2,937,142 0 Total 19,148,276 4,555,674 Page 2 of 2

L-XE-23-005 NSPM ENCLOSURE 5 ANNUAL ACCRUAL

SUMMARY

- RADIOLOGICAL 5 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/2023 1/1/2023 1/1/2023 Adjustment 1/1/2023 Accrual Monticello 17.75 3.98% 3.31% $800,341,944 $555,171,706 $245,170,238 $68,255,394 $732,086,550 4,555,674 Prairie Island Unit 1 10.67 3.94% 2.98% 532,907,303 362,941,435 169,965,868 47,318,498 485,588,805 17,106,209 Prairie Island Unit 2 11.83 4.02% 2.90% 573,276,420 387,939,305 185,337,115 51,597,853 521,678,567 10,997,348 TOTAL DECOMMISSIONING ACCRUAL $1,906,525,667 $1,306,052,446 $600,473,221 $167,171,745 $1,739,353,923 $32,659,231 INPUT DATA Escalation Rate (Labor) 4.22%

Escalation Rate (Non-Labor) 3.02%

Escalation Rate (PIIC) 0.00%

Jurisdictional Factor 100.0000%

Tax Rate for tax-effect adjustment 27.84%

AMOUNT TO RECOVER Radiological 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% 4.22% 3.02% 0.00%

2040 $22,382,860 $22,382,860 2.2857 $51,160,503 $7,480,120 $7,480,120 1.8131 $13,562,206 $0 $0 1.0000 $0 $29,862,980 $29,862,980 $64,722,709 2041 76,445,948 76,445,948 2.3822 182,109,537 41,139,848 41,139,848 1.8679 76,845,122 0 0 1.0000 0 117,585,796 117,585,796 258,954,659 2042 82,489,822 82,489,822 2.4827 204,797,481 119,599,441 119,599,441 1.9243 230,145,204 0 0 1.0000 0 202,089,263 202,089,263 434,942,685 2043 82,291,857 82,291,857 2.5875 212,930,180 107,550,113 107,550,113 1.9824 213,207,344 0 0 1.0000 0 189,841,970 189,841,970 426,137,524 2044 73,901,687 73,901,687 2.6967 199,290,679 62,479,985 62,479,985 2.0423 127,602,873 0 0 1.0000 0 136,381,672 136,381,672 326,893,553 2045 46,850,412 46,850,412 2.8105 131,673,083 22,285,686 22,285,686 2.1040 46,889,083 0 0 1.0000 0 69,136,098 69,136,098 178,562,166 2046 8,691,716 8,691,716 2.9291 25,458,905 1,873,041 1,873,041 2.1675 4,059,816 0 0 1.0000 0 10,564,757 10,564,757 29,518,722 2047 352,450 352,450 3.0527 1,075,924 849,437 849,437 2.2330 1,896,793 0 0 1.0000 0 1,201,887 1,201,887 2,972,717 2048 0 0 3.1815 0 0 0 2.3004 0 0 0 1.0000 0 0 0 0 2049 0 0 3.3157 0 0 0 2.3699 0 0 0 1.0000 0 0 0 0 2050 0 0 3.4557 0 0 0 2.4414 0 0 0 1.0000 0 0 0 0 2051 0 0 3.6015 0 0 0 2.5152 0 0 0 1.0000 0 0 0 0 2052 0 0 3.7535 0 0 0 2.5911 0 0 0 1.0000 0 0 0 0 2053 0 0 3.9119 0 0 0 2.6694 0 0 0 1.0000 0 0 0 0 2054 0 0 4.0770 0 0 0 2.7500 0 0 0 1.0000 0 0 0 0 2055 0 0 4.2490 0 0 0 2.8330 0 0 0 1.0000 0 0 0 0 2056 0 0 4.4283 0 0 0 2.9186 0 0 0 1.0000 0 0 0 0 2057 0 0 4.6152 0 0 0 3.0067 0 0 0 1.0000 0 0 0 0 2058 0 0 4.8100 0 0 0 3.0976 0 0 0 1.0000 0 0 0 0 2059 0 0 5.0129 0 0 0 3.1911 0 0 0 1.0000 0 0 0 0 2060 0 0 5.2245 0 0 0 3.2875 0 0 0 1.0000 0 0 0 0 2061 0 0 5.4449 0 0 0 3.3868 0 0 0 1.0000 0 0 0 0 2062 0 0 5.6747 0 0 0 3.4890 0 0 0 1.0000 0 0 0 0 2063 0 0 5.9142 0 0 0 3.5944 0 0 0 1.0000 0 0 0 0 2064 0 0 6.1638 0 0 0 3.7030 0 0 0 1.0000 0 0 0 0 2065 0 0 6.4239 0 0 0 3.8148 0 0 0 1.0000 0 0 0 0 2066 0 0 6.6950 0 0 0 3.9300 0 0 0 1.0000 0 0 0 0 2067 0 0 6.9775 0 0 0 4.0487 0 0 0 1.0000 0 0 0 0 2068 0 0 7.2720 0 0 0 4.1709 0 0 0 1.0000 0 0 0 0 2069 0 0 7.5788 0 0 0 4.2969 0 0 0 1.0000 0 0 0 0 2070 0 0 7.8987 0 0 0 4.4267 0 0 0 1.0000 0 0 0 0 2071 0 0 8.2320 0 0 0 4.5604 0 0 0 1.0000 0 0 0 0 2072 0 0 8.5794 0 0 0 4.6981 0 0 0 1.0000 0 0 0 0 2073 0 0 8.9414 0 0 0 4.8400 0 0 0 1.0000 0 0 0 0 2074 0 0 9.3188 0 0 0 4.9861 0 0 0 1.0000 0 0 0 0 2075 0 0 9.7120 0 0 0 5.1367 0 0 0 1.0000 0 0 0 0 2076 0 0 10.1218 0 0 0 5.2918 0 0 0 1.0000 0 0 0 0 2077 0 0 10.5490 0 0 0 5.4517 0 0 0 1.0000 0 0 0 0 2078 0 0 10.9942 0 0 0 5.6163 0 0 0 1.0000 0 0 0 0 2079 0 0 11.4581 0 0 0 5.7859 0 0 0 1.0000 0 0 0 0 2080 0 0 11.9416 0 0 0 5.9606 0 0 0 1.0000 0 0 0 0 2081 0 0 12.4456 0 0 0 6.1406 0 0 0 1.0000 0 0 0 0 2082 0 0 12.9708 0 0 0 6.3261 0 0 0 1.0000 0 0 0 0 2083 0 0 13.5182 0 0 0 6.5171 0 0 0 1.0000 0 0 0 0 2084 0 0 14.0886 0 0 0 6.7140 0 0 0 1.0000 0 0 0 0 2085 0 0 14.6832 0 0 0 6.9167 0 0 0 1.0000 0 0 0 0 2086 0 0 15.3028 0 0 0 7.1256 0 0 0 1.0000 0 0 0 0 2087 0 0 15.9486 0 0 0 7.3408 0 0 0 1.0000 0 0 0 0 2088 0 0 16.6216 0 0 0 7.5625 0 0 0 1.0000 0 0 0 0 2089 0 0 17.3230 0 0 0 7.7909 0 0 0 1.0000 0 0 0 0 2090 0 0 18.0541 0 0 0 8.0262 0 0 0 1.0000 0 0 0 0 2091 0 0 18.8159 0 0 0 8.2686 0 0 0 1.0000 0 0 0 0 2092 0 0 19.6100 0 0 0 8.5183 0 0 0 1.0000 0 0 0 0

AMOUNT TO RECOVER Radiological 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 2093 0 0 20.4375 0 0 0 8.7755 0 0 0 1.0000 0 0 0 0 2094 0 0 21.3000 0 0 0 9.0405 0 0 0 1.0000 0 0 0 0 2095 0 0 22.1988 0 0 0 9.3136 0 0 0 1.0000 0 0 0 0 2096 0 0 23.1356 0 0 0 9.5948 0 0 0 1.0000 0 0 0 0 2097 0 0 24.1119 0 0 0 9.8846 0 0 0 1.0000 0 0 0 0 2098 0 0 25.1295 0 0 0 10.1831 0 0 0 1.0000 0 0 0 0 2099 0 0 26.1899 0 0 0 10.4906 0 0 0 1.0000 0 0 0 0 2100 244,524 244,524 27.2952 6,674,331 6,387,194 6,387,194 10.8075 69,029,599 0 0 1.0000 0 6,631,718 6,631,718 75,703,931 2101 0 0 28.4470 0 0 0 11.1338 0 0 0 1.0000 0 0 0 0

$393,651,276 $393,651,276 $1,015,170,625 $369,644,865 $369,644,865 $783,238,041 $0 $0 $0 $763,296,141 $763,296,141 $1,798,408,666

AMOUNT TO RECOVER Radiological 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% 4.22% 3.02% 0.00%

2033 $23,516,311 $23,516,311 1.7114 $40,245,815 $10,315,579 $10,315,579 1.4722 $15,186,595 $0 $0 1.0000 $0 $33,831,890 $33,831,890 $55,432,410 2034 $66,238,024 66,238,024 1.7837 118,148,763 $34,741,285 34,741,285 1.5167 52,692,107 $0 0 1.0000 0 100,979,309 100,979,309 170,840,870 2035 $66,574,460 66,574,460 1.8589 123,755,264 $74,242,091 74,242,091 1.5625 116,003,267 $0 0 1.0000 0 140,816,551 140,816,551 239,758,531 2036 $60,844,971 60,844,971 1.9374 117,881,047 $73,988,372 73,988,372 1.6097 119,099,082 $0 0 1.0000 0 134,833,343 134,833,343 236,980,129 2037 $37,914,521 37,914,521 2.0191 76,553,209 $46,039,945 46,039,945 1.6583 76,348,041 $0 0 1.0000 0 83,954,466 83,954,466 152,901,250 2038 $15,119,025 15,119,025 2.1044 31,816,476 $11,398,201 11,398,201 1.7084 19,472,687 $0 0 1.0000 0 26,517,226 26,517,226 51,289,163 2039 $30,645,927 30,645,927 2.1932 67,212,647 $14,053,539 14,053,539 1.7600 24,734,229 $0 0 1.0000 0 44,699,466 44,699,466 91,946,876 2040 $9,682,551 9,682,551 2.2857 22,131,407 $2,170,001 2,170,001 1.8131 3,934,429 $0 0 1.0000 0 11,852,552 11,852,552 26,065,836 2041 $295,881 295,881 2.3822 704,848 $338,271 338,271 1.8679 631,856 $0 0 1.0000 0 634,152 634,152 1,336,704 2042 $139,429 139,429 2.4827 346,160 $159,404 159,404 1.9243 306,741 $0 0 1.0000 0 298,833 298,833 652,901 2043 $0 0 2.5875 0 $0 0 1.9824 0 $0 0 1.0000 0 0 0 0 2044 $0 0 2.6967 0 $0 0 2.0423 0 $0 0 1.0000 0 0 0 0 2045 $0 0 2.8105 0 $0 0 2.1040 0 $0 0 1.0000 0 0 0 0 2046 $0 0 2.9291 0 $0 0 2.1675 0 $0 0 1.0000 0 0 0 0 2047 $0 0 3.0527 0 $0 0 2.2330 0 $0 0 1.0000 0 0 0 0 2048 $0 0 3.1815 0 $0 0 2.3004 0 $0 0 1.0000 0 0 0 0 2049 $0 0 3.3157 0 $0 0 2.3699 0 $0 0 1.0000 0 0 0 0 2050 $0 0 3.4557 0 $0 0 2.4414 0 $0 0 1.0000 0 0 0 0 2051 $0 0 3.6015 0 $0 0 2.5152 0 $0 0 1.0000 0 0 0 0 2052 $0 0 3.7535 0 $0 0 2.5911 0 $0 0 1.0000 0 0 0 0 2053 $0 0 3.9119 0 $0 0 2.6694 0 $0 0 1.0000 0 0 0 0 2054 $0 0 4.0770 0 $0 0 2.7500 0 $0 0 1.0000 0 0 0 0 2055 $0 0 4.2490 0 $0 0 2.8330 0 $0 0 1.0000 0 0 0 0 2056 $0 0 4.4283 0 $0 0 2.9186 0 $0 0 1.0000 0 0 0 0 2057 $0 0 4.6152 0 $0 0 3.0067 0 $0 0 1.0000 0 0 0 0 2058 $0 0 4.8100 0 $0 0 3.0976 0 $0 0 1.0000 0 0 0 0 2059 $0 0 5.0129 0 $0 0 3.1911 0 $0 0 1.0000 0 0 0 0 2060 $0 0 5.2245 0 $0 0 3.2875 0 $0 0 1.0000 0 0 0 0 2061 $0 0 5.4449 0 $0 0 3.3868 0 $0 0 1.0000 0 0 0 0 2062 $0 0 5.6747 0 $0 0 3.4890 0 $0 0 1.0000 0 0 0 0 2063 $0 0 5.9142 0 $0 0 3.5944 0 $0 0 1.0000 0 0 0 0 2064 $0 0 6.1638 0 $0 0 3.7030 0 $0 0 1.0000 0 0 0 0 2065 $0 0 6.4239 0 $0 0 3.8148 0 $0 0 1.0000 0 0 0 0 2066 $0 0 6.6950 0 $0 0 3.9300 0 $0 0 1.0000 0 0 0 0 2067 $0 0 6.9775 0 $0 0 4.0487 0 $0 0 1.0000 0 0 0 0 2068 $0 0 7.2720 0 $0 0 4.1709 0 $0 0 1.0000 0 0 0 0 2069 $0 0 7.5788 0 $0 0 4.2969 0 $0 0 1.0000 0 0 0 0 2070 $0 0 7.8987 0 $0 0 4.4267 0 $0 0 1.0000 0 0 0 0 2071 $0 0 8.2320 0 $0 0 4.5604 0 $0 0 1.0000 0 0 0 0 2072 $0 0 8.5794 0 $0 0 4.6981 0 $0 0 1.0000 0 0 0 0 2073 $0 0 8.9414 0 $0 0 4.8400 0 $0 0 1.0000 0 0 0 0 2074 $0 0 9.3188 0 $0 0 4.9861 0 $0 0 1.0000 0 0 0 0 2075 $0 0 9.7120 0 $0 0 5.1367 0 $0 0 1.0000 0 0 0 0 2076 $0 0 10.1218 0 $0 0 5.2918 0 $0 0 1.0000 0 0 0 0 2077 $125,600 125,600 10.5490 1,324,954 $11,858,240 11,858,240 5.4517 64,647,567 $0 0 1.0000 0 11,983,840 11,983,840 65,972,521 2078 $0 0 10.9942 0 $0 0 5.6163 0 $0 0 1.0000 0 0 0 0

$311,096,700 $311,096,700 $600,120,591 $279,304,928 $279,304,928 $493,056,601 $0 $0 $0 $590,401,628 $590,401,628 $1,093,177,192

AMOUNT TO RECOVER Radiological 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% 4.22% 3.02% 0.00%

2034 $8,228,434 $8,228,434 1.7837 $14,677,058 $5,041,487 $5,041,487 1.5167 $7,646,423 $247,032 $247,032 1.0000 $247,032 $13,516,953 $13,516,953 $22,570,513 2035 49,164,358 49,164,358 1.8589 91,391,625 33,944,105 33,944,105 1.5625 53,037,664 0 - 1.0000 - 83,108,463 83,108,463 144,429,289 2036 64,138,723 64,138,723 1.9374 124,262,362 67,117,295 67,117,295 1.6097 108,038,710 0 - 1.0000 - 131,256,018 131,256,018 232,301,072 2037 68,279,630 68,279,630 2.0191 137,863,401 74,917,580 74,917,580 1.6583 124,235,823 0 - 1.0000 - 143,197,210 143,197,210 262,099,224 2038 68,395,297 68,395,297 2.1044 143,931,063 67,433,064 67,433,064 1.7084 115,202,647 0 - 1.0000 - 135,828,361 135,828,361 259,133,710 2039 35,984,393 35,984,393 2.1932 78,920,971 15,472,061 15,472,061 1.7600 27,230,827 0 - 1.0000 - 51,456,454 51,456,454 106,151,798 2040 12,002,423 12,002,423 2.2857 27,433,938 2,211,038 2,211,038 1.8131 4,008,833 0 - 1.0000 - 14,213,461 14,213,461 31,442,771 2041 233,644 233,644 2.3822 556,587 338,271 338,271 1.8679 631,856 0 - 1.0000 - 571,915 571,915 1,188,443 2042 110,101 110,101 2.4827 273,348 159,404 159,404 1.9243 306,741 0 - 1.0000 - 269,505 269,505 580,089 2043 0 - 2.5875 - 0 - 1.9824 - 0 - 1.0000 - 0 0 -

2044 0 - 2.6967 - 0 - 2.0423 - 0 - 1.0000 - 0 0 -

2045 0 - 2.8105 - 0 - 2.1040 - 0 - 1.0000 - 0 0 -

2046 0 - 2.9291 - 0 - 2.1675 - 0 - 1.0000 - 0 0 -

2047 0 - 3.0527 - 0 - 2.2330 - 0 - 1.0000 - 0 0 -

2048 0 - 3.1815 - 0 - 2.3004 - 0 - 1.0000 - 0 0 -

2049 0 - 3.3157 - 0 - 2.3699 - 0 - 1.0000 - 0 0 -

2050 0 - 3.4557 - 0 - 2.4414 - 0 - 1.0000 - 0 0 -

2051 0 - 3.6015 - 0 - 2.5152 - 0 - 1.0000 - 0 0 -

2052 0 - 3.7535 - 0 - 2.5911 - 0 - 1.0000 - 0 0 -

2053 0 - 3.9119 - 0 - 2.6694 - 0 - 1.0000 - 0 0 -

2054 0 - 4.0770 - 0 - 2.7500 - 0 - 1.0000 - 0 0 -

2055 0 - 4.2490 - 0 - 2.8330 - 0 - 1.0000 - 0 0 -

2056 0 - 4.4283 - 0 - 2.9186 - 0 - 1.0000 - 0 0 -

2057 0 - 4.6152 - 0 - 3.0067 - 0 - 1.0000 - 0 0 -

2058 0 - 4.8100 - 0 - 3.0976 - 0 - 1.0000 - 0 0 -

2059 0 - 5.0129 - 0 - 3.1911 - 0 - 1.0000 - 0 0 -

2060 0 - 5.2245 - 0 - 3.2875 - 0 - 1.0000 - 0 0 -

2061 0 - 5.4449 - 0 - 3.3868 - 0 - 1.0000 - 0 0 -

2062 0 - 5.6747 - 0 - 3.4890 - 0 - 1.0000 - 0 0 -

2063 0 - 5.9142 - 0 - 3.5944 - 0 - 1.0000 - 0 0 -

2064 0 - 6.1638 - 0 - 3.7030 - 0 - 1.0000 - 0 0 -

2065 0 - 6.4239 - 0 - 3.8148 - 0 - 1.0000 - 0 0 -

2066 0 - 6.6950 - 0 - 3.9300 - 0 - 1.0000 - 0 0 -

2067 0 - 6.9775 - 0 - 4.0487 - 0 - 1.0000 - 0 0 -

2068 0 - 7.2720 - 0 - 4.1709 - 0 - 1.0000 - 0 0 -

2069 0 - 7.5788 - 0 - 4.2969 - 0 - 1.0000 - 0 0 -

2070 0 - 7.8987 - 0 - 4.4267 - 0 - 1.0000 - 0 0 -

2071 0 - 8.2320 - 0 - 4.5604 - 0 - 1.0000 - 0 0 -

2072 0 - 8.5794 - 0 - 4.6981 - 0 - 1.0000 - 0 0 -

2073 0 - 8.9414 - 0 - 4.8400 - 0 - 1.0000 - 0 0 -

2074 0 - 9.3188 - 0 - 4.9861 - 0 - 1.0000 - 0 0 -

2075 0 - 9.7120 - 0 - 5.1367 - 0 - 1.0000 - 0 0 -

2076 0 - 10.1218 - 0 - 5.2918 - 0 - 1.0000 - 0 0 -

2077 125,600 125,600 10.5490 1,324,954 11,858,240 11,858,240 5.4517 64,647,567 0 - 1.0000 - 11,983,840 11,983,840 65,972,521 2078 0 - 10.9942 - 0 - 5.6163 - 0 - 1.0000 - 0 0 -

$306,662,603 $306,662,603 $620,635,307 $278,492,545 $278,492,545 $504,987,091 $247,032 $247,032 $247,032 $585,402,180 $585,402,180 $1,125,869,430

$1,011,410,579 $1,011,410,579 $2,235,926,522 $927,442,338 $927,442,338 $1,781,281,734 $247,032 $247,032 $247,032 $1,939,099,949 $1,939,099,949 $4,017,455,288

L-XE-23-005 NSPM ENCLOSURE 6 ANNUAL ACCRUAL

SUMMARY

- SPENT FUEL MANAGEMENT 5 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/2023 1/1/2023 1/1/2023 Adjustment 1/1/2023 Accrual Monticello 17.75 3.98% 3.31% $420,675,780 $291,809,385 $128,866,395 $35,876,404 $384,799,376 0 Prairie Island Unit 1 10.67 3.94% 2.98% 173,509,260 118,170,082 55,339,178 15,406,427 158,102,833 1,324,561 Prairie Island Unit 2 11.83 4.02% 2.90% 184,760,809 125,028,655 59,732,154 16,629,432 168,131,378 0 TOTAL DECOMMISSIONING ACCRUAL $778,945,849 $535,008,123 $243,937,727 $67,912,263 $711,033,586 $1,324,561 INPUT DATA Escalation Rate (Labor) 4.22%

Escalation Rate (Non-Labor) 3.02%

Escalation Rate (PIIC) 0.00%

Jurisdictional Factor 100.0000%

Tax Rate for tax-effect adjustment 27.84%

AMOUNT TO RECOVER Spent Fuel 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% 4.22% 3.02% 0.00%

2040 $119,860 $119,860 2.2857 $273,964 $1,894,014 $1,894,014 1.8131 $3,434,038 $0 $0 1.0000 $0 $2,013,875 $2,013,875 $3,708,002 2041 331,702 331,702 2.3822 790,181 5,661,434 5,661,434 1.8679 10,574,993 0 0 1.0000 0 5,993,136 5,993,136 11,365,174 2042 2,263,037 2,263,037 2.4827 5,618,442 11,012,327 11,012,327 1.9243 21,191,021 0 0 1.0000 0 13,275,364 13,275,364 26,809,463 2043 13,449,498 13,449,498 2.5875 34,800,576 44,571,707 44,571,707 1.9824 88,358,953 0 0 1.0000 0 58,021,205 58,021,205 123,159,528 2044 23,902,981 23,902,981 2.6967 64,459,169 68,906,947 68,906,947 2.0423 140,728,659 0 0 1.0000 0 92,809,928 92,809,928 205,187,827 2045 6,147,271 6,147,271 2.8105 17,276,905 335,878 335,878 2.1040 706,686 0 0 1.0000 0 6,483,148 6,483,148 17,983,591 2046 6,551,757 6,551,757 2.9291 19,190,752 2,175,227 2,175,227 2.1675 4,714,804 0 0 1.0000 0 8,726,984 8,726,984 23,905,556 2047 6,628,458 6,628,458 3.0527 20,234,694 2,602,638 2,602,638 2.2330 5,811,691 0 0 1.0000 0 9,231,096 9,231,096 26,046,385 2048 2,335,611 2,335,611 3.1815 7,430,746 2,830,319 2,830,319 2.3004 6,510,865 0 0 1.0000 0 5,165,929 5,165,929 13,941,611 2049 1,598,659 1,598,659 3.3157 5,300,673 665,108 665,108 2.3699 1,576,239 0 0 1.0000 0 2,263,767 2,263,767 6,876,912 2050 3,217,502 3,217,502 3.4557 11,118,723 5,521,638 5,521,638 2.4414 13,480,527 0 0 1.0000 0 8,739,140 8,739,140 24,599,250 2051 3,217,502 3,217,502 3.6015 11,587,834 5,521,638 5,521,638 2.5152 13,888,024 0 0 1.0000 0 8,739,140 8,739,140 25,475,858 2052 3,954,868 3,954,868 3.7535 14,844,598 7,688,091 7,688,091 2.5911 19,920,613 0 0 1.0000 0 11,642,959 11,642,959 34,765,211 2053 4,477,327 4,477,327 3.9119 17,514,856 9,301,113 9,301,113 2.6694 24,828,391 0 0 1.0000 0 13,778,440 13,778,440 42,343,248 2054 3,397,477 3,397,477 4.0770 13,851,515 6,061,563 6,061,563 2.7500 16,669,298 0 0 1.0000 0 9,459,040 9,459,040 30,520,813 2055 4,297,352 4,297,352 4.2490 18,259,450 8,761,188 8,761,188 2.8330 24,820,446 0 0 1.0000 0 13,058,540 13,058,540 43,079,896 2056 4,674,768 4,674,768 4.4283 20,701,276 9,847,791 9,847,791 2.9186 28,741,763 0 0 1.0000 0 14,522,559 14,522,559 49,443,039 2057 1,580,672 1,580,672 4.6152 7,295,116 611,146 611,146 3.0067 1,837,534 0 0 1.0000 0 2,191,818 2,191,818 9,132,650 2058 1,580,672 1,580,672 4.8100 7,603,031 611,146 611,146 3.0976 1,893,087 0 0 1.0000 0 2,191,818 2,191,818 9,496,118 2059 1,580,672 1,580,672 5.0129 7,923,749 611,146 611,146 3.1911 1,950,229 0 0 1.0000 0 2,191,818 2,191,818 9,873,978 2060 1,598,138 1,598,138 5.2245 8,349,470 617,899 617,899 3.2875 2,031,344 0 0 1.0000 0 2,216,037 2,216,037 10,380,815 2061 1,580,672 1,580,672 5.4449 8,606,599 611,146 611,146 3.3868 2,069,831 0 0 1.0000 0 2,191,818 2,191,818 10,676,430 2062 1,580,672 1,580,672 5.6747 8,969,838 611,146 611,146 3.4890 2,132,290 0 0 1.0000 0 2,191,818 2,191,818 11,102,127 2063 1,580,672 1,580,672 5.9142 9,348,409 611,146 611,146 3.5944 2,196,705 0 0 1.0000 0 2,191,818 2,191,818 11,545,113 2064 1,598,138 1,598,138 6.1638 9,850,601 617,899 617,899 3.7030 2,288,082 0 0 1.0000 0 2,216,037 2,216,037 12,138,682 2065 1,580,672 1,580,672 6.4239 10,154,077 611,146 611,146 3.8148 2,331,401 0 0 1.0000 0 2,191,818 2,191,818 12,485,478 2066 1,580,672 1,580,672 6.6950 10,582,597 611,146 611,146 3.9300 2,401,805 0 0 1.0000 0 2,191,818 2,191,818 12,984,402 2067 1,580,672 1,580,672 6.9775 11,029,137 611,146 611,146 4.0487 2,474,349 0 0 1.0000 0 2,191,818 2,191,818 13,503,485 2068 1,598,138 1,598,138 7.2720 11,621,657 617,899 617,899 4.1709 2,577,197 0 0 1.0000 0 2,216,037 2,216,037 14,198,854 2069 1,580,672 1,580,672 7.5788 11,979,595 611,146 611,146 4.2969 2,626,035 0 0 1.0000 0 2,191,818 2,191,818 14,605,630 2070 1,580,672 1,580,672 7.8987 12,485,251 611,146 611,146 4.4267 2,705,362 0 0 1.0000 0 2,191,818 2,191,818 15,190,613 2071 1,580,672 1,580,672 8.2320 13,012,089 611,146 611,146 4.5604 2,787,072 0 0 1.0000 0 2,191,818 2,191,818 15,799,161 2072 1,598,138 1,598,138 8.5794 13,711,062 617,899 617,899 4.6981 2,902,953 0 0 1.0000 0 2,216,037 2,216,037 16,614,016 2073 1,580,672 1,580,672 8.9414 14,133,418 611,146 611,146 4.8400 2,957,949 0 0 1.0000 0 2,191,818 2,191,818 17,091,367 2074 1,580,672 1,580,672 9.3188 14,729,963 611,146 611,146 4.9861 3,047,237 0 0 1.0000 0 2,191,818 2,191,818 17,777,200 2075 1,580,672 1,580,672 9.7120 15,351,483 611,146 611,146 5.1367 3,139,276 0 0 1.0000 0 2,191,818 2,191,818 18,490,759 2076 1,598,138 1,598,138 10.1218 16,176,030 617,899 617,899 5.2918 3,269,800 0 0 1.0000 0 2,216,037 2,216,037 19,445,830 2077 1,580,672 1,580,672 10.5490 16,674,506 611,146 611,146 5.4517 3,331,787 0 0 1.0000 0 2,191,818 2,191,818 20,006,293 2078 2,099,609 2,099,609 10.9942 23,083,523 2,167,959 2,167,959 5.6163 12,175,907 0 0 1.0000 0 4,267,568 4,267,568 35,259,431 2079 2,203,397 2,203,397 11.4581 25,246,740 2,479,321 2,479,321 5.7859 14,345,106 0 0 1.0000 0 4,682,718 4,682,718 39,591,845 2080 2,117,075 2,117,075 11.9416 25,281,265 2,174,712 2,174,712 5.9606 12,962,588 0 0 1.0000 0 4,291,787 4,291,787 38,243,852 2081 2,099,609 2,099,609 12.4456 26,130,896 2,167,959 2,167,959 6.1406 13,312,568 0 0 1.0000 0 4,267,568 4,267,568 39,443,464 2082 2,099,609 2,099,609 12.9708 27,233,611 2,167,959 2,167,959 6.3261 13,714,725 0 0 1.0000 0 4,267,568 4,267,568 40,948,336 2083 2,203,397 2,203,397 13.5182 29,785,957 2,479,321 2,479,321 6.5171 16,157,985 0 0 1.0000 0 4,682,718 4,682,718 45,943,942 2084 2,117,075 2,117,075 14.0886 29,826,625 2,174,712 2,174,712 6.7140 14,601,016 0 0 1.0000 0 4,291,787 4,291,787 44,427,641 2085 2,099,609 2,099,609 14.6832 30,828,982 2,167,959 2,167,959 6.9167 14,995,121 0 0 1.0000 0 4,267,568 4,267,568 45,824,103 2086 2,099,609 2,099,609 15.3028 32,129,899 2,167,959 2,167,959 7.1256 15,448,008 0 0 1.0000 0 4,267,568 4,267,568 47,577,907 2087 2,203,397 2,203,397 15.9486 35,141,092 2,479,321 2,479,321 7.3408 18,200,202 0 0 1.0000 0 4,682,718 4,682,718 53,341,295 2088 2,836,561 2,836,561 16.6216 47,148,185 4,333,170 4,333,170 7.5625 32,769,596 0 0 1.0000 0 7,169,731 7,169,731 79,917,781 2089 2,099,609 2,099,609 17.3230 36,371,530 2,167,959 2,167,959 7.7909 16,890,351 0 0 1.0000 0 4,267,568 4,267,568 53,261,881 2090 1,684,459 1,684,459 18.0541 30,411,395 922,509 922,509 8.0262 7,404,241 0 0 1.0000 0 2,606,968 2,606,968 37,815,635 2091 1,684,459 1,684,459 18.8159 31,694,616 922,509 922,509 8.2686 7,627,857 0 0 1.0000 0 2,606,968 2,606,968 39,322,473 2092 1,701,925 1,701,925 19.6100 33,374,753 929,262 929,262 8.5183 7,915,731 0 0 1.0000 0 2,631,187 2,631,187 41,290,484

AMOUNT TO RECOVER Spent Fuel 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 2093 1,788,247 1,788,247 20.4375 36,547,292 1,233,871 1,233,871 8.7755 10,827,838 0 0 1.0000 0 3,022,118 3,022,118 47,375,130 2094 1,684,459 1,684,459 21.3000 35,878,981 922,509 922,509 9.0405 8,339,942 0 0 1.0000 0 2,606,968 2,606,968 44,218,922 2095 1,684,459 1,684,459 22.1988 37,392,973 922,509 922,509 9.3136 8,591,879 0 0 1.0000 0 2,606,968 2,606,968 45,984,851 2096 1,805,713 1,805,713 23.1356 41,776,246 1,240,624 1,240,624 9.5948 11,903,543 0 0 1.0000 0 3,046,337 3,046,337 53,679,789 2097 1,684,459 1,684,459 24.1119 40,615,512 922,509 922,509 9.8846 9,118,631 0 0 1.0000 0 2,606,968 2,606,968 49,734,143 2098 1,684,459 1,684,459 25.1295 42,329,617 922,509 922,509 10.1831 9,394,000 0 0 1.0000 0 2,606,968 2,606,968 51,723,617 2099 1,788,247 1,788,247 26.1899 46,834,002 1,233,871 1,233,871 10.4906 12,944,051 0 0 1.0000 0 3,022,118 3,022,118 59,778,053 2100 1,543,723 1,543,723 27.2952 42,136,227 1,154,241 1,154,241 10.8075 12,474,459 0 0 1.0000 0 2,697,964 2,697,964 54,610,686 2101 (3,878,504) (3,878,504) 28.4470 (110,331,816) 10,289,585 10,289,585 11.1338 114,562,181 0 0 1.0000 0 6,411,081 6,411,081 4,230,365

$164,981,728 $164,981,728 $1,199,710,132 $256,971,281 $256,971,281 $895,585,862 $0 $0 $0 $421,953,009 $421,953,009 $2,095,295,994

AMOUNT TO RECOVER Spent Fuel 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% 4.22% 3.02% 0.00%

2033 $0 $0 1.7114 $0 $414,788 $414,788 1.4722 $610,651 $1,250,000 $1,250,000 1.0000 $1,250,000 $1,664,788 $1,664,788 $1,860,651 2034 $37,444 37,444 1.7837 66,790 $3,053,007 3,053,007 1.5167 4,630,495 $1,250,000 1,250,000 1.0000 1,250,000 4,340,451 4,340,451 5,947,285 2035 $306,738 306,738 1.8589 570,195 $3,548,660 3,548,660 1.5625 5,544,781 $1,250,000 1,250,000 1.0000 1,250,000 5,105,398 5,105,398 7,364,976 2036 $1,053,104 1,053,104 1.9374 2,040,283 $5,763,066 5,763,066 1.6097 9,276,807 $1,250,000 1,250,000 1.0000 1,250,000 8,066,170 8,066,170 12,567,091 2037 $5,904,083 5,904,083 2.0191 11,920,934 $20,305,477 20,305,477 1.6583 33,672,573 $1,250,000 1,250,000 1.0000 1,250,000 27,459,560 27,459,560 46,843,507 2038 $10,490,101 10,490,101 2.1044 22,075,368 $32,009,812 32,009,812 1.7084 54,685,563 $1,250,000 1,250,000 1.0000 1,250,000 43,749,913 43,749,913 78,010,931 2039 $3,088,687 3,088,687 2.1932 6,774,108 $145,048 145,048 1.7600 255,285 $1,250,000 1,250,000 1.0000 1,250,000 4,483,735 4,483,735 8,279,393 2040 $3,335,201 3,335,201 2.2857 7,623,268 $1,827,178 1,827,178 1.8131 3,312,856 $1,250,000 1,250,000 1.0000 1,250,000 6,412,379 6,412,379 12,186,125 2041 $998,921 998,921 2.3822 2,379,630 $1,103,354 1,103,354 1.8679 2,060,954 $1,250,000 1,250,000 1.0000 1,250,000 3,352,275 3,352,275 5,690,585 2042 $903,597 903,597 2.4827 2,243,361 $806,152 806,152 1.9243 1,551,279 $1,250,000 1,250,000 1.0000 1,250,000 2,959,750 2,959,750 5,044,640 2043 $818,645 818,645 2.5875 2,118,245 $541,289 541,289 1.9824 1,073,051 $1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 4,441,296 2044 $827,617 827,617 2.6967 2,231,834 $550,652 550,652 2.0423 1,124,597 $1,250,000 1,250,000 1.0000 1,250,000 2,628,269 2,628,269 4,606,432 2045 $818,645 818,645 2.8105 2,300,803 $541,289 541,289 2.1040 1,138,872 $1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 4,689,674 2046 $818,645 818,645 2.9291 2,397,894 $541,289 541,289 2.1675 1,173,243 $1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 4,821,137 2047 $818,645 818,645 3.0527 2,499,079 $541,289 541,289 2.2330 1,208,698 $1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 4,957,776 2048 $827,617 827,617 3.1815 2,633,063 $550,652 550,652 2.3004 1,266,721 $1,250,000 1,250,000 1.0000 1,250,000 2,628,269 2,628,269 5,149,784 2049 $818,645 818,645 3.3157 2,714,382 $541,289 541,289 2.3699 1,282,800 $1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 5,247,183 2050 $818,645 818,645 3.4557 2,828,993 $541,289 541,289 2.4414 1,321,502 $1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 5,400,495 2051 $818,645 818,645 3.6015 2,948,351 $541,289 541,289 2.5152 1,361,449 $1,250,000 1,250,000 1.0000 1,250,000 2,609,934 2,609,934 5,559,801 2052 $827,617 827,617 3.7535 3,106,460 $550,652 550,652 2.5911 1,426,795 $1,250,000 1,250,000 1.0000 1,250,000 2,628,269 2,628,269 5,783,255 2053 $922,433 922,433 3.9119 3,608,465 $852,651 852,651 2.6694 2,276,067 $1,250,000 1,250,000 1.0000 1,250,000 3,025,084 3,025,084 7,134,532 2054 $1,026,220 1,026,220 4.0770 4,183,900 $1,164,014 1,164,014 2.7500 3,201,038 $1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 8,634,938 2055 $1,026,220 1,026,220 4.2490 4,360,410 $1,164,014 1,164,014 2.8330 3,297,651 $1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 8,908,061 2056 $1,087,086 1,087,086 4.4283 4,813,941 $1,329,059 1,329,059 2.9186 3,878,990 $1,250,000 1,250,000 1.0000 1,250,000 3,666,144 3,666,144 9,942,931 2057 $974,327 974,327 4.6152 4,496,712 $1,008,332 1,008,332 3.0067 3,031,753 $1,250,000 1,250,000 1.0000 1,250,000 3,232,659 3,232,659 8,778,465 2058 $1,130,008 1,130,008 4.8100 5,435,338 $1,475,376 1,475,376 3.0976 4,570,125 $1,250,000 1,250,000 1.0000 1,250,000 3,855,384 3,855,384 11,255,463 2059 $974,327 974,327 5.0129 4,884,202 $1,008,332 1,008,332 3.1911 3,217,690 $1,250,000 1,250,000 1.0000 1,250,000 3,232,659 3,232,659 9,351,892 2060 $931,404 931,404 5.2245 4,866,122 $862,015 862,015 3.2875 2,833,874 $1,250,000 1,250,000 1.0000 1,250,000 3,043,419 3,043,419 8,949,996 2061 $1,026,220 1,026,220 5.4449 5,587,667 $1,164,014 1,164,014 3.3868 3,942,282 $1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 10,779,949 2062 $1,026,220 1,026,220 5.6747 5,823,493 $1,164,014 1,164,014 3.4890 4,061,244 $1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 11,134,736 2063 $974,327 974,327 5.9142 5,762,362 $1,008,332 1,008,332 3.5944 3,624,350 $1,250,000 1,250,000 1.0000 1,250,000 3,232,659 3,232,659 10,636,713 2064 $1,035,192 1,035,192 6.1638 6,380,715 $1,173,377 1,173,377 3.7030 4,345,016 $1,250,000 1,250,000 1.0000 1,250,000 3,458,569 3,458,569 11,975,732 2065 $1,026,220 1,026,220 6.4239 6,592,337 $1,164,014 1,164,014 3.8148 4,440,480 $1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 12,282,816 2066 $974,327 974,327 6.6950 6,523,117 $1,008,332 1,008,332 3.9300 3,962,747 $1,250,000 1,250,000 1.0000 1,250,000 3,232,659 3,232,659 11,735,863 2067 $1,026,220 1,026,220 6.9775 7,160,453 $1,164,014 1,164,014 4.0487 4,712,742 $1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 13,123,195 2068 $1,035,192 1,035,192 7.2720 7,527,915 $1,173,377 1,173,377 4.1709 4,894,039 $1,250,000 1,250,000 1.0000 1,250,000 3,458,569 3,458,569 13,671,954 2069 $974,327 974,327 7.5788 7,384,226 $1,008,332 1,008,332 4.2969 4,332,704 $1,250,000 1,250,000 1.0000 1,250,000 3,232,659 3,232,659 12,966,930 2070 $1,026,220 1,026,220 7.8987 8,105,807 $1,164,014 1,164,014 4.4267 5,152,740 $1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 14,508,546 2071 $1,026,220 1,026,220 8.2320 8,447,846 $1,164,014 1,164,014 4.5604 5,308,368 $1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 15,006,214 2072 $1,035,192 1,035,192 8.5794 8,881,325 $1,173,377 1,173,377 4.6981 5,512,644 $1,250,000 1,250,000 1.0000 1,250,000 3,458,569 3,458,569 15,643,969 2073 $1,026,220 1,026,220 8.9414 9,175,847 $1,164,014 1,164,014 4.8400 5,633,826 $1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 16,059,673 2074 $1,026,220 1,026,220 9.3188 9,563,142 $1,164,014 1,164,014 4.9861 5,803,889 $1,250,000 1,250,000 1.0000 1,250,000 3,440,234 3,440,234 16,617,031 2075 $1,385,963 1,385,963 9.7120 13,460,476 $2,243,243 2,243,243 5.1367 11,522,865 $1,250,000 1,250,000 1.0000 1,250,000 4,879,206 4,879,206 26,233,340 2076 $1,035,192 1,035,192 10.1218 10,478,004 $1,173,377 1,173,377 5.2918 6,209,278 $1,250,000 1,250,000 1.0000 1,250,000 3,458,569 3,458,569 17,937,283 2077 $900,620 900,620 10.5490 9,500,640 $1,088,291 1,088,291 5.4517 5,933,038 $1,250,000 1,250,000 1.0000 1,250,000 3,238,911 3,238,911 16,683,677 2078 ($1,983,587) (1,983,587) 10.9942 (21,807,948) $3,461,500

$ 3,461,500 5.6163 19,440,824 $0 0 1.0000 0 1,477,914 1,477,914 (2,367,125)

$57,979,775 $57,979,775 $232,669,555 $107,104,965 $107,104,965 $263,119,237 $56,250,000 $56,250,000 $56,250,000 $221,334,740 $221,334,740 $552,038,792

AMOUNT TO RECOVER Spent Fuel 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% 4.22% 3.02% 0.00%

2034 $67,041 $67,041 1.7837 $119,581 ($314,073) ($314,073) 1.5167 ($476,355) $1,250,000 $1,250,000 1.0000 $1,250,000 $1,002,968 $1,002,968 $893,226 2035 355,670 355,670 1.8589 661,154 4,007,683 4,007,683 1.5625 6,262,005 1,250,000 1,250,000 1.0000 1,250,000 5,613,353 5,613,353 8,173,159 2036 1,252,695 1,252,695 1.9374 2,426,971 6,474,164 6,474,164 1.6097 10,421,462 1,250,000 1,250,000 1.0000 1,250,000 8,976,859 8,976,859 14,098,434 2037 4,663,495 4,663,495 2.0191 9,416,064 16,583,709 16,583,709 1.6583 27,500,764 1,250,000 1,250,000 1.0000 1,250,000 22,497,204 22,497,204 38,166,828 2038 11,452,573 11,452,573 2.1044 24,100,795 34,897,219 34,897,219 1.7084 59,618,409 1,250,000 1,250,000 1.0000 1,250,000 47,599,792 47,599,792 84,969,204 2039 3,088,687 3,088,687 2.1932 6,774,108 145,048 145,048 1.7600 255,285 1,250,000 1,250,000 1.0000 1,250,000 4,483,735 4,483,735 8,279,393 2040 3,335,201 3,335,201 2.2857 7,623,268 1,827,178 1,827,178 1.8131 3,312,856 1,250,000 1,250,000 1.0000 1,250,000 6,412,379 6,412,379 12,186,125 2041 3,454,858 3,454,858 2.3822 8,230,163 2,729,783 2,729,783 1.8679 5,098,962 1,250,000 1,250,000 1.0000 1,250,000 7,434,641 7,434,641 14,579,125 2042 896,869 896,869 2.4827 2,226,656 801,696 801,696 1.9243 1,542,704 1,250,000 1,250,000 1.0000 1,250,000 2,948,565 2,948,565 5,019,360 2043 811,917 811,917 2.5875 2,100,835 536,833 536,833 1.9824 1,064,217 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 4,415,052 2044 820,888 820,888 2.6967 2,213,689 546,196 546,196 2.0423 1,115,497 1,250,000 1,250,000 1.0000 1,250,000 2,617,085 2,617,085 4,579,186 2045 811,917 811,917 2.8105 2,281,892 536,833 536,833 2.1040 1,129,496 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 4,661,388 2046 811,917 811,917 2.9291 2,378,185 536,833 536,833 2.1675 1,163,585 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 4,791,770 2047 811,917 811,917 3.0527 2,478,538 536,833 536,833 2.2330 1,198,748 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 4,927,286 2048 820,888 820,888 3.1815 2,611,656 546,196 546,196 2.3004 1,256,470 1,250,000 1,250,000 1.0000 1,250,000 2,617,085 2,617,085 5,118,126 2049 811,917 811,917 3.3157 2,692,072 536,833 536,833 2.3699 1,272,240 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 5,214,312 2050 811,917 811,917 3.4557 2,805,741 536,833 536,833 2.4414 1,310,624 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 5,366,364 2051 811,917 811,917 3.6015 2,924,118 536,833 536,833 2.5152 1,350,242 1,250,000 1,250,000 1.0000 1,250,000 2,598,750 2,598,750 5,524,360 2052 820,888 820,888 3.7535 3,081,204 546,196 546,196 2.5911 1,415,249 1,250,000 1,250,000 1.0000 1,250,000 2,617,085 2,617,085 5,746,453 2053 915,704 915,704 3.9119 3,582,143 848,195 848,195 2.6694 2,264,172 1,250,000 1,250,000 1.0000 1,250,000 3,013,900 3,013,900 7,096,316 2054 1,019,492 1,019,492 4.0770 4,156,468 1,159,558 1,159,558 2.7500 3,188,784 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 8,595,252 2055 1,019,492 1,019,492 4.2490 4,331,820 1,159,558 1,159,558 2.8330 3,285,027 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 8,866,848 2056 1,080,357 1,080,357 4.4283 4,784,145 1,324,603 1,324,603 2.9186 3,865,985 1,250,000 1,250,000 1.0000 1,250,000 3,654,960 3,654,960 9,900,130 2057 967,598 967,598 4.6152 4,465,658 1,003,876 1,003,876 3.0067 3,018,355 1,250,000 1,250,000 1.0000 1,250,000 3,221,475 3,221,475 8,734,014 2058 1,123,279 1,123,279 4.8100 5,402,973 1,470,920 1,470,920 3.0976 4,556,323 1,250,000 1,250,000 1.0000 1,250,000 3,844,200 3,844,200 11,209,296 2059 967,598 967,598 5.0129 4,850,472 1,003,876 1,003,876 3.1911 3,203,470 1,250,000 1,250,000 1.0000 1,250,000 3,221,475 3,221,475 9,303,942 2060 924,676 924,676 5.2245 4,830,968 857,559 857,559 3.2875 2,819,225 1,250,000 1,250,000 1.0000 1,250,000 3,032,235 3,032,235 8,900,193 2061 1,019,492 1,019,492 5.4449 5,551,031 1,159,558 1,159,558 3.3868 3,927,190 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 10,728,221 2062 1,019,492 1,019,492 5.6747 5,785,310 1,159,558 1,159,558 3.4890 4,045,697 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 11,081,007 2063 967,598 967,598 5.9142 5,722,568 1,003,876 1,003,876 3.5944 3,608,334 1,250,000 1,250,000 1.0000 1,250,000 3,221,475 3,221,475 10,580,902 2064 1,028,463 1,028,463 6.1638 6,339,242 1,168,921 1,168,921 3.7030 4,328,516 1,250,000 1,250,000 1.0000 1,250,000 3,447,385 3,447,385 11,917,757 2065 1,019,492 1,019,492 6.4239 6,549,113 1,159,558 1,159,558 3.8148 4,423,481 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 12,222,594 2066 967,598 967,598 6.6950 6,478,069 1,003,876 1,003,876 3.9300 3,945,235 1,250,000 1,250,000 1.0000 1,250,000 3,221,475 3,221,475 11,673,303 2067 1,019,492 1,019,492 6.9775 7,113,504 1,159,558 1,159,558 4.0487 4,694,701 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 13,058,205 2068 1,028,463 1,028,463 7.2720 7,478,985 1,168,921 1,168,921 4.1709 4,875,454 1,250,000 1,250,000 1.0000 1,250,000 3,447,385 3,447,385 13,604,439 2069 967,598 967,598 7.5788 7,333,232 1,003,876 1,003,876 4.2969 4,313,557 1,250,000 1,250,000 1.0000 1,250,000 3,221,475 3,221,475 12,896,789 2070 1,019,492 1,019,492 7.8987 8,052,660 1,159,558 1,159,558 4.4267 5,133,014 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 14,435,674 2071 1,019,492 1,019,492 8.2320 8,392,456 1,159,558 1,159,558 4.5604 5,288,047 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 14,930,503 2072 1,028,463 1,028,463 8.5794 8,823,597 1,168,921 1,168,921 4.6981 5,491,709 1,250,000 1,250,000 1.0000 1,250,000 3,447,385 3,447,385 15,565,307 2073 1,019,492 1,019,492 8.9414 9,115,684 1,159,558 1,159,558 4.8400 5,612,259 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 15,977,943 2074 1,019,492 1,019,492 9.3188 9,500,440 1,159,558 1,159,558 4.9861 5,781,671 1,250,000 1,250,000 1.0000 1,250,000 3,429,050 3,429,050 16,532,111 2075 1,379,235 1,379,235 9.7120 13,395,128 2,238,787 2,238,787 5.1367 11,499,976 1,250,000 1,250,000 1.0000 1,250,000 4,868,021 4,868,021 26,145,103 2076 1,028,463 1,028,463 10.1218 10,409,899 1,168,921 1,168,921 5.2918 6,185,698 1,250,000 1,250,000 1.0000 1,250,000 3,447,385 3,447,385 17,845,597 2077 893,891 893,891 10.5490 9,429,660 1,083,835 1,083,835 5.4517 5,908,745 1,250,000 1,250,000 1.0000 1,250,000 3,227,727 3,227,727 16,588,405 2078 (1,990,315) (1,990,315) 10.9942 (21,881,924) 3,457,044 3,457,044 5.6163 19,415,798 0 - 1.0000 - 1,466,729 1,466,729 (2,466,126)

$60,186,758 $60,186,758 $237,139,991 $105,120,415 $105,120,415 $260,492,884 $55,000,000 $55,000,000 $55,000,000 $220,307,173 $220,307,173 $552,632,876

$283,148,262 $283,148,262 $1,669,519,678 $469,196,660 $469,196,660 $1,419,197,983 $111,250,000 $111,250,000 $111,250,000 $863,594,922 $863,594,922 $3,199,967,661

L-XE-23-005 NSPM ENCLOSURE 7 ANNUAL ACCRUAL

SUMMARY

- SITE RESTORATION 5 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/2023 1/1/2023 1/1/2023 Adjustment 1/1/2023 Accrual Monticello 17.75 3.98% 3.31% $76,218,255 $52,870,175 $23,348,080 $6,500,105 $69,718,150 0 Prairie Island Unit 1 10.67 3.94% 2.98% 48,750,467 33,201,955 15,548,512 4,328,706 44,421,761 372,159 Prairie Island Unit 2 11.83 4.02% 2.90% 71,967,686 48,700,929 23,266,757 6,477,465 65,490,221 0 TOTAL DECOMMISSIONING ACCRUAL $196,936,408 $134,773,059 $62,163,349 $17,306,276 $179,630,132 $372,159 INPUT DATA Escalation Rate (Labor) 4.22%

Escalation Rate (Non-Labor) 3.02%

Escalation Rate (PIIC) 0.00%

Jurisdictional Factor 100.0000%

Tax Rate for tax-effect adjustment 27.84%

AMOUNT TO RECOVER Site Restoration 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% 4.22% 3.02% 0.00%

2040 $173,165 $173,165 2.2857 $395,804 $0 $0 1.8131 $0 $0 $0 1.0000 $0 $173,165 $173,165 $395,804 2041 668,922 668,922 2.3822 1,593,505 0 0 1.8679 0 0 0 1.0000 0 668,922 668,922 1,593,505 2042 183,852 183,852 2.4827 456,449 21,236 21,236 1.9243 40,865 0 0 1.0000 0 205,088 205,088 497,314 2043 14,318 14,318 2.5875 37,047 16,541 16,541 1.9824 32,791 0 0 1.0000 0 30,858 30,858 69,837 2044 7,285 7,285 2.6967 19,644 148 148 2.0423 302 0 0 1.0000 0 7,433 7,433 19,947 2045 0 0 2.8105 0 0 0 2.1040 0 0 0 1.0000 0 0 0 0 2046 21,955,988 21,955,988 2.9291 64,311,284 10,497,533 10,497,533 2.1675 22,753,402 0 0 1.0000 0 32,453,520 32,453,520 87,064,686 2047 25,156,352 25,156,352 3.0527 76,794,796 12,027,681 12,027,681 2.2330 26,857,813 0 0 1.0000 0 37,184,034 37,184,034 103,652,609 2048 0 0 3.1815 0 0 0 2.3004 0 0 0 1.0000 0 0 0 0 2049 0 0 3.3157 0 0 0 2.3699 0 0 0 1.0000 0 0 0 0 2050 0 0 3.4557 0 0 0 2.4414 0 0 0 1.0000 0 0 0 0 2051 0 0 3.6015 0 0 0 2.5152 0 0 0 1.0000 0 0 0 0 2052 0 0 3.7535 0 0 0 2.5911 0 0 0 1.0000 0 0 0 0 2053 0 0 3.9119 0 0 0 2.6694 0 0 0 1.0000 0 0 0 0 2054 0 0 4.0770 0 0 0 2.7500 0 0 0 1.0000 0 0 0 0 2055 0 0 4.2490 0 0 0 2.8330 0 0 0 1.0000 0 0 0 0 2056 0 0 4.4283 0 0 0 2.9186 0 0 0 1.0000 0 0 0 0 2057 0 0 4.6152 0 0 0 3.0067 0 0 0 1.0000 0 0 0 0 2058 0 0 4.8100 0 0 0 3.0976 0 0 0 1.0000 0 0 0 0 2059 0 0 5.0129 0 0 0 3.1911 0 0 0 1.0000 0 0 0 0 2060 0 0 5.2245 0 0 0 3.2875 0 0 0 1.0000 0 0 0 0 2061 0 0 5.4449 0 0 0 3.3868 0 0 0 1.0000 0 0 0 0 2062 0 0 5.6747 0 0 0 3.4890 0 0 0 1.0000 0 0 0 0 2063 0 0 5.9142 0 0 0 3.5944 0 0 0 1.0000 0 0 0 0 2064 0 0 6.1638 0 0 0 3.7030 0 0 0 1.0000 0 0 0 0 2065 0 0 6.4239 0 0 0 3.8148 0 0 0 1.0000 0 0 0 0 2066 0 0 6.6950 0 0 0 3.9300 0 0 0 1.0000 0 0 0 0 2067 0 0 6.9775 0 0 0 4.0487 0 0 0 1.0000 0 0 0 0 2068 0 0 7.2720 0 0 0 4.1709 0 0 0 1.0000 0 0 0 0 2069 0 0 7.5788 0 0 0 4.2969 0 0 0 1.0000 0 0 0 0 2070 0 0 7.8987 0 0 0 4.4267 0 0 0 1.0000 0 0 0 0 2071 0 0 8.2320 0 0 0 4.5604 0 0 0 1.0000 0 0 0 0 2072 0 0 8.5794 0 0 0 4.6981 0 0 0 1.0000 0 0 0 0 2073 0 0 8.9414 0 0 0 4.8400 0 0 0 1.0000 0 0 0 0 2074 0 0 9.3188 0 0 0 4.9861 0 0 0 1.0000 0 0 0 0 2075 0 0 9.7120 0 0 0 5.1367 0 0 0 1.0000 0 0 0 0 2076 0 0 10.1218 0 0 0 5.2918 0 0 0 1.0000 0 0 0 0 2077 0 0 10.5490 0 0 0 5.4517 0 0 0 1.0000 0 0 0 0 2078 0 0 10.9942 0 0 0 5.6163 0 0 0 1.0000 0 0 0 0 2079 0 0 11.4581 0 0 0 5.7859 0 0 0 1.0000 0 0 0 0 2080 0 0 11.9416 0 0 0 5.9606 0 0 0 1.0000 0 0 0 0 2081 0 0 12.4456 0 0 0 6.1406 0 0 0 1.0000 0 0 0 0 2082 0 0 12.9708 0 0 0 6.3261 0 0 0 1.0000 0 0 0 0 2083 0 0 13.5182 0 0 0 6.5171 0 0 0 1.0000 0 0 0 0 2084 0 0 14.0886 0 0 0 6.7140 0 0 0 1.0000 0 0 0 0 2085 0 0 14.6832 0 0 0 6.9167 0 0 0 1.0000 0 0 0 0 2086 0 0 15.3028 0 0 0 7.1256 0 0 0 1.0000 0 0 0 0 2087 0 0 15.9486 0 0 0 7.3408 0 0 0 1.0000 0 0 0 0 2088 0 0 16.6216 0 0 0 7.5625 0 0 0 1.0000 0 0 0 0 2089 0 0 17.3230 0 0 0 7.7909 0 0 0 1.0000 0 0 0 0 2090 0 0 18.0541 0 0 0 8.0262 0 0 0 1.0000 0 0 0 0 2091 0 0 18.8159 0 0 0 8.2686 0 0 0 1.0000 0 0 0 0 2092 0 0 19.6100 0 0 0 8.5183 0 0 0 1.0000 0 0 0 0

AMOUNT TO RECOVER Site Restoration 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 2093 0 0 20.4375 0 0 0 8.7755 0 0 0 1.0000 0 0 0 0 2094 0 0 21.3000 0 0 0 9.0405 0 0 0 1.0000 0 0 0 0 2095 0 0 22.1988 0 0 0 9.3136 0 0 0 1.0000 0 0 0 0 2096 0 0 23.1356 0 0 0 9.5948 0 0 0 1.0000 0 0 0 0 2097 0 0 24.1119 0 0 0 9.8846 0 0 0 1.0000 0 0 0 0 2098 0 0 25.1295 0 0 0 10.1831 0 0 0 1.0000 0 0 0 0 2099 0 0 26.1899 0 0 0 10.4906 0 0 0 1.0000 0 0 0 0 2100 0 0 27.2952 0 0 0 10.8075 0 0 0 1.0000 0 0 0 0 2101 1,179,615 1,179,615 28.4470 33,556,508 1,873,500 1,873,500 11.1338 20,859,176 0 0 1.0000 0 3,053,115 3,053,115 54,415,684

$49,339,496 $49,339,496 $177,165,038 $24,436,639 $24,436,639 $70,544,348 $0 $0 $0 $73,776,136 $73,776,136 $247,709,387

AMOUNT TO RECOVER Site Restoration 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% 4.22% 3.02% 0.00%

2033 $265,310 $265,310 1.7114 $454,052 $0 $0 1.4722 $0 $0 $0 1.0000 $0 $265,310 $265,310 $454,052 2034 $1,138,697 1,138,697 1.7837 2,031,093 0 0 1.5167 0 $0 0 1.0000 0 1,138,697 1,138,697 2,031,093 2035 $1,709,530 1,709,530 1.8589 3,177,845 45,895 45,895 1.5625 71,710 $0 0 1.0000 0 1,755,424 1,755,424 3,249,555 2036 $2,228,491 2,228,491 1.9374 4,317,479 53,968 53,968 1.6097 86,872 $0 0 1.0000 0 2,282,459 2,282,459 4,404,351 2037 $1,691,408 1,691,408 2.0191 3,415,122 34,268 34,268 1.6583 56,826 $0 0 1.0000 0 1,725,676 1,725,676 3,471,948 2038 $0 0 2.1044 0 0 0 1.7084 0 $0 0 1.0000 0 0 0 0 2039 $0 0 2.1932 0 0 0 1.7600 0 $0 0 1.0000 0 0 0 0 2040 $7,645,228 7,645,228 2.2857 17,474,698 5,473,121 5,473,121 1.8131 9,923,315 $0 0 1.0000 0 13,118,349 13,118,349 27,398,013 2041 $11,774,296 11,774,296 2.3822 28,048,729 8,429,068 8,429,068 1.8679 15,744,656 $0 0 1.0000 0 20,203,364 20,203,364 43,793,384 2042 $5,548,436 5,548,436 2.4827 13,775,101 3,972,054 3,972,054 1.9243 7,643,423 $0 0 1.0000 0 9,520,489 9,520,489 21,418,524 2043 $0 0 2.5875 0 0 0 1.9824 0 $0 0 1.0000 0 0 0 0 2044 $0 0 2.6967 0 0 0 2.0423 0 $0 0 1.0000 0 0 0 0 2045 $0 0 2.8105 0 0 0 2.1040 0 $0 0 1.0000 0 0 0 0 2046 $0 0 2.9291 0 0 0 2.1675 0 $0 0 1.0000 0 0 0 0 2047 $0 0 3.0527 0 0 0 2.2330 0 $0 0 1.0000 0 0 0 0 2048 $0 0 3.1815 0 0 0 2.3004 0 $0 0 1.0000 0 0 0 0 2049 $0 0 3.3157 0 0 0 2.3699 0 $0 0 1.0000 0 0 0 0 2050 $0 0 3.4557 0 0 0 2.4414 0 $0 0 1.0000 0 0 0 0 2051 $0 0 3.6015 0 0 0 2.5152 0 $0 0 1.0000 0 0 0 0 2052 $0 0 3.7535 0 0 0 2.5911 0 $0 0 1.0000 0 0 0 0 2053 $0 0 3.9119 0 0 0 2.6694 0 $0 0 1.0000 0 0 0 0 2054 $0 0 4.0770 0 0 0 2.7500 0 $0 0 1.0000 0 0 0 0 2055 $0 0 4.2490 0 0 0 2.8330 0 $0 0 1.0000 0 0 0 0 2056 $0 0 4.4283 0 0 0 2.9186 0 $0 0 1.0000 0 0 0 0 2057 $0 0 4.6152 0 0 0 3.0067 0 $0 0 1.0000 0 0 0 0 2058 $0 0 4.8100 0 0 0 3.0976 0 $0 0 1.0000 0 0 0 0 2059 $0 0 5.0129 0 0 0 3.1911 0 $0 0 1.0000 0 0 0 0 2060 $0 0 5.2245 0 0 0 3.2875 0 $0 0 1.0000 0 0 0 0 2061 $0 0 5.4449 0 0 0 3.3868 0 $0 0 1.0000 0 0 0 0 2062 $0 0 5.6747 0 0 0 3.4890 0 $0 0 1.0000 0 0 0 0 2063 $0 0 5.9142 0 0 0 3.5944 0 $0 0 1.0000 0 0 0 0 2064 $0 0 6.1638 0 0 0 3.7030 0 $0 0 1.0000 0 0 0 0 2065 $0 0 6.4239 0 0 0 3.8148 0 $0 0 1.0000 0 0 0 0 2066 $0 0 6.6950 0 0 0 3.9300 0 $0 0 1.0000 0 0 0 0 2067 $0 0 6.9775 0 0 0 4.0487 0 $0 0 1.0000 0 0 0 0 2068 $0 0 7.2720 0 0 0 4.1709 0 $0 0 1.0000 0 0 0 0 2069 $0 0 7.5788 0 0 0 4.2969 0 $0 0 1.0000 0 0 0 0 2070 $0 0 7.8987 0 0 0 4.4267 0 $0 0 1.0000 0 0 0 0 2071 $0 0 8.2320 0 0 0 4.5604 0 $0 0 1.0000 0 0 0 0 2072 $0 0 8.5794 0 0 0 4.6981 0 $0 0 1.0000 0 0 0 0 2073 $0 0 8.9414 0 0 0 4.8400 0 $0 0 1.0000 0 0 0 0 2074 $0 0 9.3188 0 0 0 4.9861 0 $0 0 1.0000 0 0 0 0 2075 $0 0 9.7120 0 0 0 5.1367 0 $0 0 1.0000 0 0 0 0 2076 $0 0 10.1218 0 0 0 5.2918 0 $0 0 1.0000 0 0 0 0 2077 $0 0 10.5490 0 0 0 5.4517 0 $0 0 1.0000 0 0 0 0 2078 $413,385 413,385 10.9942 4,544,841 575,255 575,255 5.6163 3,230,805 $0 0 1.0000 0 988,640 988,640 7,775,646

$32,414,781 $32,414,781 $77,238,959 $18,583,627 $18,583,627 $36,757,607 $0 $0 $0 $50,998,409 $50,998,409 $113,996,567

AMOUNT TO RECOVER Site Restoration 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% 4.22% 3.02% 0.00%

2034 $50,073 $50,073 1.7837 $89,315 $0 $0 1.5167 $0 $0 $0 1.0000 $0 $50,073 $50,073 $89,315 2035 374,437 374,437 1.8589 696,042 0 - 1.5625 - 0 - 1.0000 - 374,437 374,437 696,042 2036 1,628,631 1,628,631 1.9374 3,155,309 41,278 41,278 1.6097 66,446 0 - 1.0000 - 1,669,909 1,669,909 3,221,755 2037 2,302,182 2,302,182 2.0191 4,648,335 61,319 61,319 1.6583 101,686 0 - 1.0000 - 2,363,501 2,363,501 4,750,021 2038 2,579,208 2,579,208 2.1044 5,427,685 51,935 51,935 1.7084 88,726 0 - 1.0000 - 2,631,143 2,631,143 5,516,411 2039 0 - 2.1932 - 0 - 1.7600 - 0 - 1.0000 - 0 0 -

2040 9,483,681 9,483,681 2.2857 21,676,849 10,325,214 10,325,214 1.8131 18,720,646 0 - 1.0000 - 19,808,895 19,808,895 40,397,495 2041 14,605,668 14,605,668 2.3822 34,793,623 15,901,701 15,901,701 1.8679 29,702,788 0 - 1.0000 - 30,507,370 30,507,370 64,496,411 2042 6,882,671 6,882,671 2.4827 17,087,608 7,493,404 7,493,404 1.9243 14,419,558 0 - 1.0000 - 14,376,076 14,376,076 31,507,166 2043 0 - 2.5875 - 0 - 1.9824 - 0 - 1.0000 - 0 0 -

2044 0 - 2.6967 - 0 - 2.0423 - 0 - 1.0000 - 0 0 -

2045 0 - 2.8105 - 0 - 2.1040 - 0 - 1.0000 - 0 0 -

2046 0 - 2.9291 - 0 - 2.1675 - 0 - 1.0000 - 0 0 -

2047 0 - 3.0527 - 0 - 2.2330 - 0 - 1.0000 - 0 0 -

2048 0 - 3.1815 - 0 - 2.3004 - 0 - 1.0000 - 0 0 -

2049 0 - 3.3157 - 0 - 2.3699 - 0 - 1.0000 - 0 0 -

2050 0 - 3.4557 - 0 - 2.4414 - 0 - 1.0000 - 0 0 -

2051 0 - 3.6015 - 0 - 2.5152 - 0 - 1.0000 - 0 0 -

2052 0 - 3.7535 - 0 - 2.5911 - 0 - 1.0000 - 0 0 -

2053 0 - 3.9119 - 0 - 2.6694 - 0 - 1.0000 - 0 0 -

2054 0 - 4.0770 - 0 - 2.7500 - 0 - 1.0000 - 0 0 -

2055 0 - 4.2490 - 0 - 2.8330 - 0 - 1.0000 - 0 0 -

2056 0 - 4.4283 - 0 - 2.9186 - 0 - 1.0000 - 0 0 -

2057 0 - 4.6152 - 0 - 3.0067 - 0 - 1.0000 - 0 0 -

2058 0 - 4.8100 - 0 - 3.0976 - 0 - 1.0000 - 0 0 -

2059 0 - 5.0129 - 0 - 3.1911 - 0 - 1.0000 - 0 0 -

2060 0 - 5.2245 - 0 - 3.2875 - 0 - 1.0000 - 0 0 -

2061 0 - 5.4449 - 0 - 3.3868 - 0 - 1.0000 - 0 0 -

2062 0 - 5.6747 - 0 - 3.4890 - 0 - 1.0000 - 0 0 -

2063 0 - 5.9142 - 0 - 3.5944 - 0 - 1.0000 - 0 0 -

2064 0 - 6.1638 - 0 - 3.7030 - 0 - 1.0000 - 0 0 -

2065 0 - 6.4239 - 0 - 3.8148 - 0 - 1.0000 - 0 0 -

2066 0 - 6.6950 - 0 - 3.9300 - 0 - 1.0000 - 0 0 -

2067 0 - 6.9775 - 0 - 4.0487 - 0 - 1.0000 - 0 0 -

2068 0 - 7.2720 - 0 - 4.1709 - 0 - 1.0000 - 0 0 -

2069 0 - 7.5788 - 0 - 4.2969 - 0 - 1.0000 - 0 0 -

2070 0 - 7.8987 - 0 - 4.4267 - 0 - 1.0000 - 0 0 -

2071 0 - 8.2320 - 0 - 4.5604 - 0 - 1.0000 - 0 0 -

2072 0 - 8.5794 - 0 - 4.6981 - 0 - 1.0000 - 0 0 -

2073 0 - 8.9414 - 0 - 4.8400 - 0 - 1.0000 - 0 0 -

2074 0 - 9.3188 - 0 - 4.9861 - 0 - 1.0000 - 0 0 -

2075 0 - 9.7120 - 0 - 5.1367 - 0 - 1.0000 - 0 0 -

2076 0 - 10.1218 - 0 - 5.2918 - 0 - 1.0000 - 0 0 -

2077 0 - 10.5490 - 0 - 5.4517 - 0 - 1.0000 - 0 0 -

2078 413,385 413,385 10.9942 4,544,841 575,255 575,255 5.6163 3,230,805 0 - 1.0000 - 988,640 988,640 7,775,646

$38,319,936 $38,319,936 $92,119,606 $34,450,108 $34,450,108 $66,330,655 $0 $0 $0 $72,770,044 $72,770,044 $158,450,261

$120,074,214 $120,074,214 $346,523,604 $77,470,375 $77,470,375 $173,632,610 $0 $0 $0 $197,544,588 $197,544,588 $520,156,214

L-XE-23-005 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, 2021 Balances as of January 01, 2022 External Qualified Book Value Market Adjustment Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 Radiological 539,202,618 402,464,282 391,255,179 344,758,449 273,252,949 263,748,882 883,961,067 675,717,230 655,004,061 Spent Fuel 308,012,408 76,058,174 121,062,529 196,938,733 51,639,664 81,609,416 504,951,141 127,697,837 202,671,945 Site Restoration 55,805,847 21,369,877 47,156,051 35,681,461 14,509,068 31,788,348 91,487,309 35,878,945 78,944,398 Total 903,020,873 499,892,332 559,473,759 577,378,643 339,401,681 377,146,646 1,480,399,516 839,294,013 936,620,405

NSP-Minnesota NRC Biennial Trust Funding Status Report Trust Fund Balances - By Jurisdiction December 31, 2021 Balances as of January 01, 2022 External Qualified Book Value Market Adjust Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 MN Retail 664,555,789.87 366,754,325.61 410,741,325.62 426,023,564.41 250,119,609.61 278,324,871.96 1,090,579,354.28 616,873,935.22 689,066,197.58 ND Retail 42,399,251.34 28,368,242.69 29,706,867.43 28,718,751.95 18,724,433.82 20,318,390.69 71,118,003.29 47,092,676.51 50,025,258.12 SD Retail 29,718,255.84 21,244,704.60 23,813,371.28 19,324,141.17 14,239,661.24 16,063,581.89 49,042,397.01 35,484,365.84 39,876,953.17 MN FERC 11,131,379.30 9,034,606.02 8,355,669.02 8,394,992.63 6,508,924.58 5,710,574.38 19,526,371.93 15,543,530.60 14,066,243.40 WI FERC 11,722,708.65 6,984,817.33 6,714,331.74 7,835,582.45 2,596,614.37 4,398,525.87 19,558,291.10 9,581,431.70 11,112,857.61 WI Retail 143,493,487.96 67,505,635.70 80,142,193.86 87,081,610.42 47,212,437.21 52,330,701.04 230,575,098.38 114,718,072.91 132,472,894.90 Total 903,020,872.96 499,892,331.95 559,473,758.95 577,378,643.03 339,401,680.83 377,146,645.83 1,480,399,515.99 839,294,012.78 936,620,404.78

NSP-Minnesota NRC Biennial Trust Funding Status Report Trust Fund Balance - By Components December 31, 2022 Balances as of January 01, 2023 External Qualified Book Value Market Adjustment Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 Radiological 555,171,706 362,941,435 387,939,305 245,170,238 169,965,868 185,337,115 800,341,944 532,907,303 573,276,420 Spent Fuel 291,809,385 118,170,082 125,028,655 128,866,395 55,339,178 59,732,154 420,675,780 173,509,260 184,760,809 Site Restoration 52,870,175 33,201,955 48,700,929 23,348,080 15,548,512 23,266,757 76,218,255 48,750,467 71,967,686 Total 899,851,267 514,313,472 561,668,889 397,384,712 240,853,558 268,336,027 1,297,235,979 755,167,030 830,004,916

NSP-Minnesota NRC Biennial Trust Funding Status Report Trust Fund Balances - By Jurisdiction December 31, 2022 Balances as of January 01, 2023 External Qualified Book Value Market Adjust Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 MN Retail 660,531,222.31 376,570,815.97 411,156,772.16 293,497,260.38 177,649,093.21 198,277,608.24 954,028,482.69 554,219,909.18 609,434,380.40 ND Retail 42,929,756.83 28,986,797.57 29,743,977.63 20,052,127.99 13,198,548.16 14,507,581.30 62,981,884.82 42,185,345.73 44,251,558.93 SD Retail 30,160,103.23 21,304,656.44 23,763,113.41 13,344,789.08 10,090,898.17 11,434,523.59 43,504,892.31 31,395,554.61 35,197,637.00 MN FERC 10,983,384.19 8,998,100.93 8,242,307.00 6,026,733.64 4,693,922.75 4,081,247.66 17,010,117.83 13,692,023.68 12,323,554.66 WI FERC 11,574,471.64 6,962,314.74 6,624,771.56 5,463,452.11 1,477,800.52 3,111,296.86 17,037,923.75 8,440,115.26 9,736,068.42 WI Retail 143,672,328.49 71,490,786.61 82,137,947.38 59,000,349.25 33,743,294.89 36,923,769.01 202,672,677.74 105,234,081.50 119,061,716.39 Total 899,851,266.69 514,313,472.26 561,668,889.14 397,384,712.45 240,853,557.70 268,336,026.66 1,297,235,979.14 755,167,029.96 830,004,915.80

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