ML13084A050: Difference between revisions
StriderTol (talk | contribs) (Created page by program invented by StriderTol) |
StriderTol (talk | contribs) (Created page by program invented by StriderTol) |
||
| Line 17: | Line 17: | ||
=Text= | =Text= | ||
{{#Wiki_filter:ENCLOSURES Enclosure Plant Title 1 Prairie Island Nuclear Generating Plant, Unit 1 (PI1) | {{#Wiki_filter:ENCLOSURES Enclosure Plant Title 1 Prairie Island Nuclear Generating Decommissioning Funding Status Plant, Unit 1 (PI1) Report 2 Prairie Island Nuclear Generating Decommissioning Funding Status Plant, Unit 2 (PI2) Report 3 Monticello Nuclear Generating Plant Decommissioning Funding Status (MNGP) Report 4 All Xcel Energy Breakdown of Annual Contributions and Trust Fund Balance (RIS 2001-07) 5 All Nuclear Decommissioning Accrual Calculation - Radiological 6 All Nuclear Decommissioning Accrual Calculation - Spent Fuel 7 All Nuclear Decommissioning Accrual Calculation - Site Restoration 8 All Xcel Energy Trust Fund Balances - | ||
Decommissioning Funding Status | 2011 and 2012 | ||
ENCLOSURE 5 Nuclear Decommissioning Accrual Calculation - Radiological 4 pages follow | |||
ENCLOSURE 5 Nuclear Decommissioning Accrual Calculation - Radiological | |||
4 pages follow | |||
ENCLOSURE 5 Levelized (beginning of year payment, mid year interest) | ENCLOSURE 5 Levelized (beginning of year payment, mid year interest) | ||
| Line 38: | Line 26: | ||
==SUMMARY== | ==SUMMARY== | ||
- | - RADIOLOGICAL Operational Post-Shutdown Present Recovered Radiological Remaining Earnings Earnings Value to Through Decommissioning Life (yrs) Rate Rate Decommission 12/31/2012 Accrual (9) (10) (10) (5) (11) (12) | ||
EXTERNAL FUND | EXTERNAL FUND Monticello 17.75 5.35% 4.82% $1,204,831,884 $407,184,598 5,555,927 Prairie Island Unit 1 20.80 5.50% 4.66% 879,842,710 285,827,440 0 Prairie Island Unit 2 21.80 5.53% 4.57% 1,175,904,702 359,833,423 0 TOTAL DECOMMISSIONING ACCRUAL $3,260,579,296 $1,052,845,460 $5,555,927 INPUT DATA Escalation Rate (Operation/Radiological) 3.63% (a) | ||
$1,204,831,884 | Escalation Rate (ISFSI/Site Restoration) 2.63% (a) | ||
$407,184,598 5,555,927 Prairie Island Unit | Jurisdictional Factor 100.0000% (b) | ||
879,842,710 285,827,440 0 | IRS Tax Qualified Percent 100.00% (c) | ||
1,175,904,702 359,833,423 0 | External Percent 100.00% (d) | ||
External | NOTES Input Data (a) = Inflation rate from current filing documentation (b) = Minnesota jurisdictional percent from last electric rate case (c) = IRS qualifying percent based upon 2005 Energy Policy Act (d) = Recommended external funding Amount to Recover (1) = Current cost estimate by year from TLG Cost Study, 2011. | ||
NOTES Input Data (a) | (2) = Jurisdictional Nominal Cost = (1) x (c) | ||
(3) = Future Value of jurisdictional nominal cost (4) = Discount factor based upon the applicable earnings rate for present value calculation (5) = Present value to decommission at the start of 2012 Decommissioning Accrual (9) = Remaining life based on E,G002/D-11-144 (10) = Fund earnings rate (11) = Fund balances to date (12) = Annuity or decommissioning accrual | |||
( | ENCLOSURE 5 Levelized (beginning of year payment, mid year interest) | ||
AMOUNT TO RECOVER - RADIOLOGICAL Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6) | |||
Monticello 3.63% | |||
Factors 2011 100.0000% 2.63% 4.82% 2030 2030 $18,322,903 $18,322,903 1.9689 $36,075,964 1.00000 $36,075,964 2031 75,519,265 75,519,265 2.0404 154,089,508 0.95402 147,004,473 2032 137,152,490 137,152,490 2.1144 289,995,225 0.91015 263,939,154 2033 98,485,327 98,485,327 2.1912 215,801,048 0.86830 187,380,050 2034 64,788,675 64,788,675 2.2707 147,115,643 0.82837 121,866,185 2035 47,657,043 47,657,043 2.3532 112,146,553 0.79028 88,627,178 2036 14,400,233 14,400,233 2.4386 35,116,407 0.75394 26,475,664 2037 14,360,888 14,360,888 2.5271 36,291,399 0.71927 26,103,315 2038 14,360,888 14,360,888 2.6188 37,608,293 0.68619 25,806,434 2039 14,360,888 14,360,888 2.7139 38,974,013 0.65464 25,513,948 2040 14,400,233 14,400,233 2.8124 40,499,214 0.62454 25,293,379 2041 14,360,888 14,360,888 2.9145 41,854,807 0.59582 24,937,931 2042 14,360,888 14,360,888 3.0203 43,374,189 0.56842 24,654,756 2043 14,360,888 14,360,888 3.1299 44,948,142 0.54228 24,374,479 2044 14,400,233 14,400,233 3.2436 46,708,594 0.51735 24,164,691 2045 26,521,966 26,521,966 3.3613 89,148,285 0.49356 44,000,028 2046 42,748,794 42,748,794 3.4833 148,906,876 0.47086 70,114,291 2047 7,279,588 7,279,588 3.6098 26,277,856 0.44921 11,804,276 2048 672,833 672,833 3.7408 2,516,933 0.42855 1,078,632 2049 - 0 3.8766 0 0.40885 0 2050 - 0 4.0173 0 0.39005 0 2051 - 0 4.1631 0 0.37211 0 2052 - 0 4.3143 0 0.35500 0 2053 - 0 4.4709 0 0.33868 0 2054 - 0 4.6332 0 0.32310 0 2055 - 0 3.1338 0 0.30825 0 2056 - 0 3.2162 0 0.29407 0 2057 - 0 3.3008 0 0.28055 0 2058 - 0 3.3876 0 0.26765 0 2059 - 0 3.4767 0 0.25534 0 2060 - 0 3.5681 0 0.24360 0 2061 - 0 3.6620 0 0.23240 0 2062 - 0 3.7583 0 0.22171 0 2063 - 0 3.8571 0 0.21152 0 2064 - 0 3.9586 0 0.20179 0 2065 - 0 4.0627 0 0.19251 0 2066 - 0 4.1695 0 0.18366 0 2067 - 0 4.2792 0 0.17521 0 2068 - 0 4.3917 0 0.16716 0 2069 - 0 4.5072 0 0.15947 0 2070 - 0 4.6258 0 0.15214 0 2071 - 0 4.7474 0 0.14514 0 2072 - 0 4.8723 0 0.13847 0 2073 - 0 5.0004 0 0.13210 0 2074 - 0 5.1320 0 0.12603 0 2075 - 0 5.2669 0 0.12023 0 2076 2,068 2,068 5.4054 11,180 0.11470 1,282 2077 754,915 754,915 5.5476 4,187,969 0.10943 458,289 2078 754,915 754,915 5.6935 4,298,111 0.10440 448,723 2079 754,915 754,915 5.8432 4,411,122 0.09959 439,304 2080 756,984 756,984 5.9969 4,539,555 0.09502 431,349 2081 754,915 754,915 6.1546 4,646,202 0.09065 421,178 2082 754,915 754,915 6.3165 4,768,423 0.08648 412,373 2083 754,915 754,915 6.4826 4,893,814 0.08250 403,740 2084 756,984 756,984 6.6531 5,036,288 0.07871 396,406 2085 754,915 754,915 6.8281 5,154,638 0.07509 387,062 2086 754,915 754,915 7.0077 5,290,220 0.07164 378,991 2087 754,915 754,915 7.1920 5,429,351 0.06834 371,042 2088 756,984 756,984 7.3811 5,587,372 0.06520 364,297 2089 754,915 754,915 7.5753 5,718,710 0.06220 355,704 2090 752,847 752,847 7.7745 5,853,010 0.05934 347,318 2091 - 0 7.9790 0 0.05661 0 | |||
$659,089,927 $659,089,927 $1,657,274,914 $1,204,831,884 | |||
(3) | ENCLOSURE 5 Levelized (beginning of year payment, mid year interest) | ||
AMOUNT TO RECOVER - RADIOLOGICAL Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6) | |||
Prairie Island Unit 1 3.63% | |||
Factors 2011 100.0000% 2.63% 4.66% 2033 2033 20,820,603 20,820,603 2.1912 45,622,105 1.00000 45,622,105 2034 65,863,767 65,863,767 2.2707 149,556,856 0.95547 142,897,089 2035 105,472,896 105,472,896 2.3532 248,198,819 0.91293 226,588,148 2036 80,683,306 80,683,306 2.4386 196,754,309 0.87228 171,624,849 2037 40,634,808 40,634,808 2.5271 102,688,224 0.83345 85,585,500 2038 5,090,301 5,090,301 2.6188 13,330,479 0.79634 10,615,594 2039 5,090,301 5,090,301 2.7139 13,814,567 0.76088 10,511,228 2040 5,104,247 5,104,247 2.8124 14,355,183 0.72700 10,436,218 2041 5,090,301 5,090,301 2.9145 14,835,681 0.69463 10,305,309 2042 5,090,301 5,090,301 3.0203 15,374,235 0.66370 10,203,880 2043 5,090,301 5,090,301 3.1299 15,932,132 0.63415 10,103,362 2044 5,104,247 5,104,247 3.2436 16,556,135 0.60592 10,031,693 2045 5,090,301 5,090,301 3.3613 17,110,028 0.57894 9,905,679 2046 5,090,301 5,090,301 3.4833 17,731,044 0.55316 9,808,104 2047 5,090,301 5,090,301 3.6098 18,374,967 0.52853 9,711,721 2048 5,104,247 5,104,247 3.7408 19,093,966 0.50500 9,642,453 2049 10,045,148 10,045,148 3.8766 38,941,023 0.48251 18,789,433 2050 28,250,320 28,250,320 4.0173 113,490,009 0.46103 52,322,299 2051 7,680,906 7,680,906 4.1631 31,976,379 0.44050 14,085,595 2052 716,179 716,179 4.3143 3,089,812 0.42089 1,300,471 2053 336,565 336,565 4.4709 1,504,749 0.40215 605,135 2054 0 0 3.0535 0 0.38424 0 2055 0 0 3.1338 0 0.36713 0 2056 0 0 3.2162 0 0.35079 0 2057 0 0 3.3008 0 0.33517 0 2058 0 0 3.3876 0 0.32024 0 2059 0 0 3.4767 0 0.30599 0 2060 0 0 3.5681 0 0.29236 0 2061 0 0 3.6620 0 0.27934 0 2062 0 0 3.7583 0 0.26691 0 2063 0 0 3.8571 0 0.25502 0 2064 0 0 3.9586 0 0.24367 0 2065 0 0 4.0627 0 0.23282 0 2066 0 0 4.1695 0 0.22245 0 2067 0 0 4.2792 0 0.21255 0 2068 0 0 4.3917 0 0.20308 0 2069 0 0 4.5072 0 0.19404 0 2070 - 0 4.6258 0 0.18540 0 2071 - 0 4.7474 0 0.17715 0 2072 - 0 4.8723 0 0.16926 0 2073 - 0 5.0004 0 0.16172 0 2074 - 0 5.1320 0 0.15452 0 2075 - 0 5.2669 0 0.14764 0 2076 - 0 5.4054 0 0.14107 0 2077 12,232,310 12,232,310 5.5476 67,859,963 0.13479 9,146,844 2078 - 0 5.6935 0 0.12879 0 | |||
$428,771,954 $428,771,954 $1,176,190,665 $879,842,710 | |||
( | ENCLOSURE 5 Levelized (beginning of year payment, mid year interest) | ||
AMOUNT TO RECOVER - RADIOLOGICAL Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6) | |||
Prairie Island Unit 2 3.63% | |||
Factors 2011 100.0000% 2.63% 4.57% 2034 2034 8,494,948 8,494,948 2.2707 19,289,477 1.00000 19,289,477 2035 53,283,284 53,283,284 2.3532 125,386,223 0.95630 119,906,845 2036 100,960,954 100,960,954 2.4386 246,203,383 0.91450 225,152,994 2037 98,591,560 98,591,560 2.5271 249,150,731 0.87454 217,892,281 2038 74,811,488 74,811,488 2.6188 195,916,324 0.83632 163,848,740 2039 21,913,437 21,913,437 2.7139 59,470,876 0.79977 47,563,023 2040 13,161,222 13,161,222 2.8124 37,014,621 0.76482 28,309,522 2041 13,125,262 13,125,262 2.9145 38,253,577 0.73139 27,978,284 2042 13,125,262 13,125,262 3.0203 39,642,230 0.69943 27,726,965 2043 13,125,262 13,125,262 3.1299 41,080,759 0.66886 27,477,276 2044 13,161,222 13,161,222 3.2436 42,689,740 0.63963 27,305,638 2045 13,125,262 13,125,262 3.3613 44,117,944 0.61168 26,986,064 2046 13,125,262 13,125,262 3.4833 45,719,226 0.58494 26,743,004 2047 13,125,262 13,125,262 3.6098 47,379,572 0.55938 26,503,185 2048 13,161,222 13,161,222 3.7408 49,233,499 0.53493 26,336,476 2049 17,938,969 17,938,969 3.8766 69,542,206 0.51156 35,575,011 2050 35,760,092 35,760,092 4.0173 143,659,019 0.48920 70,277,992 2051 10,457,490 10,457,490 4.1631 43,535,579 0.46782 20,366,814 2052 670,743 670,743 4.3143 2,893,788 0.44738 1,294,623 2053 315,213 315,213 4.4709 1,409,284 0.42782 602,920 2054 0 - 3.0535 - 0.40913 0 2055 0 - 3.1338 - 0.39125 0 2056 0 - 3.2162 - 0.37415 0 2057 0 - 3.3008 - 0.35780 0 2058 0 - 3.3876 - 0.34216 0 2059 0 - 3.4767 - 0.32721 0 2060 0 - 3.5681 - 0.31291 0 2061 0 - 3.6620 - 0.29923 0 2062 0 - 3.7583 - 0.28615 0 2063 0 - 3.8571 - 0.27365 0 2064 0 - 3.9586 - 0.26169 0 2065 0 - 4.0627 - 0.25025 0 2066 0 - 4.1695 - 0.23932 0 2067 0 - 4.2792 - 0.22886 0 2068 0 - 4.3917 - 0.21886 0 2069 0 - 4.5072 - 0.20929 0 2070 - - 4.6258 - 0.20014 0 2071 - - 4.7474 - 0.19140 0 2072 - - 4.8723 - 0.18303 0 2073 - - 5.0004 - 0.17503 0 2074 - - 5.1320 - 0.16738 0 2075 - - 5.2669 - 0.16007 0 2076 - - 5.4054 - 0.15307 0 2077 10,796,730 10,796,730 5.5476 59,895,939 0.14638 8,767,568 2078 - - 5.6935 - 0.13999 0 | |||
( | $552,230,148 552,230,148 1,601,483,999 1,175,904,702 | ||
$1,640,092,028 $1,640,092,028 $4,434,949,578 $3,260,579,296 | |||
( | |||
( | |||
4 pages follow | ENCLOSURE 6 Nuclear Decommissioning Accrual Calculation - Spent Fuel 4 pages follow | ||
Levelized (beginning of year payment, mid year interest) | Enclosure 6 Levelized (beginning of year payment, mid year interest) | ||
ANNUAL ACCRUAL | ANNUAL ACCRUAL | ||
==SUMMARY== | ==SUMMARY== | ||
(5) = Present value to decommission at the start of 2012 Decommissioning Accrual (9) | Operational Post-Shutdown Present Recovered 2013-2014 Remaining Earnings Earnings Value to Through Decommissioning Life (yrs) Rate Rate Decommission 12/31/2012 Accrual (9) (10) (10) (5) (11) (12) | ||
EXTERNAL FUND Monticello 17.75 5.35% 4.82% $554,561,447 $112,185,858 10,755,339 Prairie Island Unit 1 20.80 5.50% 4.66% 378,003,189 122,798,698 471,837 Prairie Island Unit 2 21.80 5.53% 4.57% 396,692,950 121,390,165 1,094,077 TOTAL DECOMMISSIONING ACCRUAL $1,329,257,586 $356,374,720 $12,321,252 INPUT DATA Escalation Rate (Operation/Radiological) 3.63% (a) | |||
Escalation Rate (ISFSI/Site Restoration) 2.63% (a) | |||
Jurisdictional Factor 100.0000% (b) | |||
IRS Tax Qualified Percent 100.00% (c) | |||
External Percent 100.00% (d) | |||
NOTES Input Data (a) = Inflation rate from current filing documentation (b) = Minnesota jurisdictional percent from last electric rate case (c) = IRS qualifying percent based upon 2005 Energy Policy Act (d) = Recommended external funding Amount to Recover (1) = Current cost estimate by year from TLG Cost Study, 2011. | |||
(2) = Jurisdictional Nominal Cost = (1) x (c) | |||
(3) = Future Value of jurisdictional nominal cost (4) = Discount factor based upon the applicable earnings rate for present value calculation (5) = Present value to decommission at the start of 2012 Decommissioning Accrual (9) = Remaining life based on E,G002/D-11-144 (10) = Fund earnings rate (11) = Fund balances to date (12) = Annuity or decommissioning accrual | |||
(10 | Enclosure 6 Levelized (beginning of year payment, mid year interest) | ||
AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6) | |||
Monticello 3.63% | |||
Factors 2011 100.0000% 2.63% 4.82% 2030 2030 $28,351,388 $28,351,388 1.9689 $55,821,049 1.00000 $55,821,049 2031 2,427,740 2,427,740 2.0404 4,953,562 0.95402 4,725,797 2032 1,966,707 1,966,707 2.1144 4,158,405 0.91015 3,784,773 2033 1,855,097 1,855,097 2.1912 4,064,889 0.86830 3,529,543 2034 7,163,151 7,163,151 2.2707 16,265,367 0.82837 13,473,742 2035 37,666,327 37,666,327 2.3532 88,636,400 0.79028 70,047,574 2036 1,860,023 1,860,023 2.4386 4,535,853 0.75394 3,419,761 2037 1,855,098 1,855,098 2.5271 4,688,019 0.71927 3,371,951 2038 1,855,098 1,855,098 2.6188 4,858,131 0.68619 3,333,601 2039 1,855,098 1,855,098 2.7139 5,034,551 0.65464 3,295,819 2040 1,860,023 1,860,023 2.8124 5,231,129 0.62454 3,267,050 2041 1,855,098 1,855,098 2.9145 5,406,684 0.59582 3,221,410 2042 1,855,098 1,855,098 3.0203 5,602,953 0.56842 3,184,831 2043 1,855,098 1,855,098 3.1299 5,806,272 0.54228 3,148,625 2044 1,860,023 1,860,023 3.2436 6,033,171 0.51735 3,121,261 2045 40,146,932 40,146,932 3.3613 134,945,883 0.49356 66,603,890 2046 705,105 705,105 3.4833 2,456,093 0.47086 1,156,476 2047 4,352,674 4,352,674 3.6098 15,712,281 0.44921 7,058,114 2048 7,628,121 7,628,121 3.7408 28,535,275 0.42855 12,228,792 2049 5,668,528 5,668,528 3.8766 21,974,618 0.40885 8,984,322 2050 13,810,528 13,810,528 4.0173 55,481,036 0.39005 21,640,378 2051 18,261,028 18,261,028 4.1631 76,022,488 0.37211 28,288,728 2052 10,858,901 10,858,901 4.3143 46,848,557 0.35500 16,631,238 2053 16,777,528 16,777,528 4.4709 75,010,652 0.33868 25,404,608 2054 21,228,028 21,228,028 4.6332 98,353,702 0.32310 31,778,081 2055 5,611,028 5,611,028 3.1338 17,583,841 0.30825 5,420,219 2056 5,626,401 5,626,401 3.2162 18,095,631 0.29407 5,321,382 2057 5,611,028 5,611,028 3.3008 18,520,883 0.28055 5,196,034 2058 5,611,028 5,611,028 3.3876 19,007,920 0.26765 5,087,470 2059 5,611,028 5,611,028 3.4767 19,507,863 0.25534 4,981,138 2060 5,626,401 5,626,401 3.5681 20,075,562 0.24360 4,890,407 2061 5,611,028 5,611,028 3.6620 20,547,586 0.23240 4,775,259 2062 5,611,028 5,611,028 3.7583 21,087,928 0.22171 4,675,405 2063 5,611,028 5,611,028 3.8571 21,642,298 0.21152 4,577,779 2064 5,626,401 5,626,401 3.9586 22,272,672 0.20179 4,494,402 2065 5,611,028 5,611,028 4.0627 22,795,925 0.19251 4,388,444 2066 5,611,028 5,611,028 4.1695 23,395,183 0.18366 4,296,759 2067 5,611,028 5,611,028 4.2792 24,010,713 0.17521 4,206,917 2068 5,626,401 5,626,401 4.3917 24,709,466 0.16716 4,130,434 2069 5,611,028 5,611,028 4.5072 25,290,028 0.15947 4,033,001 2070 5,611,028 5,611,028 4.6258 25,955,496 0.15214 3,948,869 2071 5,611,028 5,611,028 4.7474 26,637,797 0.14514 3,866,210 2072 5,626,401 5,626,401 4.8723 27,413,514 0.13847 3,795,949 2073 5,611,028 5,611,028 5.0004 28,057,387 0.13210 3,706,381 2074 5,611,028 5,611,028 5.1320 28,795,798 0.12603 3,629,134 2075 5,611,028 5,611,028 5.2669 29,552,726 0.12023 3,553,124 2076 5,626,941 5,626,941 5.4054 30,415,865 0.11470 3,488,700 2077 6,438,157 6,438,157 5.5476 35,716,318 0.10943 3,908,437 2078 7,698,557 7,698,557 5.6935 43,831,732 0.10440 4,576,033 2079 7,383,457 7,383,457 5.8432 43,143,014 0.09959 4,296,613 2080 7,399,369 7,399,369 5.9969 44,373,275 0.09502 4,216,349 2081 7,383,457 7,383,457 6.1546 45,442,222 0.09065 4,119,337 2082 7,698,557 7,698,557 6.3165 48,627,933 0.08648 4,205,344 2083 7,383,457 7,383,457 6.4826 47,863,996 0.08250 3,948,780 2084 7,399,369 7,399,369 6.6531 49,228,741 0.07871 3,874,794 2085 7,383,457 7,383,457 6.8281 50,414,980 0.07509 3,785,661 2086 7,698,557 7,698,557 7.0077 53,949,176 0.07164 3,864,919 2087 7,383,457 7,383,457 7.1920 53,101,820 0.06834 3,628,978 2088 9,699,369 9,699,369 7.3811 71,592,012 0.06520 4,667,799 2089 7,383,457 7,383,457 7.5753 55,931,899 0.06220 3,478,964 2090 6,447,544 6,447,544 7.7745 50,126,433 0.05934 2,974,503 2091 4,494,458 4,494,458 7.9790 35,861,278 0.05661 2,030,107 | |||
$468,388,523 $468,388,523 $2,021,013,933 $554,561,447 | |||
( | Enclosure 6 Levelized (beginning of year payment, mid year interest) | ||
AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6) | |||
Prairie Island Unit 1 3.63% | |||
Factors 2011 100.0000% 2.63% 4.66% 2033 2033 620,158 620,158 2.1912 1,358,891 1.00000 1,358,891 2034 1,561,088 1,561,088 2.2707 3,544,763 0.95547 3,386,915 2035 21,691,551 21,691,551 2.3532 51,044,557 0.91293 46,600,108 2036 5,056,634 5,056,634 2.4386 12,331,108 0.87228 10,756,179 2037 14,092,188 14,092,188 2.5271 35,612,368 0.83345 29,681,128 2038 1,258,188 1,258,188 2.6188 3,294,942 0.79634 2,623,894 2039 7,675,188 7,675,188 2.7139 20,829,692 0.76088 15,848,896 2040 1,261,635 1,261,635 2.8124 3,548,222 0.72700 2,579,558 2041 14,092,188 14,092,188 2.9145 41,071,682 0.69463 28,529,622 2042 1,258,188 1,258,188 3.0203 3,800,105 0.66370 2,522,130 2043 14,092,188 14,092,188 3.1299 44,107,139 0.63415 27,970,542 2044 1,261,635 1,261,635 3.2436 4,092,239 0.60592 2,479,570 2045 14,092,188 14,092,188 3.3613 47,368,071 0.57894 27,423,271 2046 1,258,188 1,258,188 3.4833 4,382,646 0.55316 2,424,304 2047 14,092,188 14,092,188 3.6098 50,869,980 0.52853 26,886,310 2048 1,261,635 1,261,635 3.7408 4,719,524 0.50500 2,383,360 2049 20,432,246 20,432,246 3.8766 79,207,644 0.48251 38,218,480 2050 542,119 542,119 4.0173 2,177,855 0.46103 1,004,056 2051 2,821,637 2,821,637 4.1631 11,746,759 0.44050 5,174,447 2052 4,453,546 4,453,546 4.3143 19,213,933 0.42089 8,086,952 2053 4,045,150 4,045,150 4.4709 18,085,462 0.40215 7,273,068 2054 3,848,051 3,848,051 3.0535 11,750,024 0.38424 4,514,829 2055 3,532,951 3,532,951 3.1338 11,071,562 0.36713 4,064,702 2056 4,013,985 4,013,985 3.2162 12,909,780 0.35079 4,528,622 2057 3,532,951 3,532,951 3.3008 11,661,564 0.33517 3,908,607 2058 3,375,401 3,375,401 3.3876 11,434,508 0.32024 3,661,787 2059 3,690,501 3,690,501 3.4767 12,830,765 0.30599 3,926,086 2060 3,541,335 3,541,335 3.5681 12,635,839 0.29236 3,694,214 2061 3,690,501 3,690,501 3.6620 13,514,614 0.27934 3,775,172 2062 3,690,501 3,690,501 3.7583 13,870,010 0.26691 3,702,044 2063 3,690,501 3,690,501 3.8571 14,234,631 0.25502 3,630,116 2064 3,541,335 3,541,335 3.9586 14,018,730 0.24367 3,415,944 2065 3,690,501 3,690,501 4.0627 14,993,398 0.23282 3,490,763 2066 3,690,501 3,690,501 4.1695 15,387,544 0.22245 3,422,959 2067 3,532,951 3,532,951 4.2792 15,118,204 0.21255 3,213,374 2068 3,698,885 3,698,885 4.3917 16,244,395 0.20308 3,298,912 2069 3,690,501 3,690,501 4.5072 16,633,826 0.19404 3,227,628 2070 3,532,951 3,532,951 4.6258 16,342,724 0.18540 3,029,941 2071 3,690,501 3,690,501 4.7474 17,520,284 0.17715 3,103,718 2072 3,698,885 3,698,885 4.8723 18,022,079 0.16926 3,050,417 2073 3,532,951 3,532,951 5.0004 17,666,168 0.16172 2,856,973 2074 3,690,501 3,690,501 5.1320 18,939,651 0.15452 2,926,555 2075 4,840,501 4,840,501 5.2669 25,494,434 0.14764 3,763,998 2076 3,541,335 3,541,335 5.4054 19,142,334 0.14107 2,700,409 2077 3,533,595 3,533,595 5.5476 19,602,974 0.13479 2,642,285 2078 1,693,045 1,693,045 5.6935 9,639,352 0.12879 1,241,452 | |||
$237,125,344 $237,125,344 $843,086,976 $378,003,189 | |||
Enclosure 6 Levelized (beginning of year payment, mid year interest) | |||
AMOUNT TO | AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6) | ||
Prairie Island Unit 2 3.63% | |||
Factors 2011 100.0000% 2.63% 4.57% 2034 2034 273,725 273,725 2.2707 621,548 1.00000 621,548 2035 21,962,089 21,962,089 2.3532 51,681,187 0.95630 49,422,719 2036 5,156,219 5,156,219 2.4386 12,573,955 0.91450 11,498,882 2037 14,092,188 14,092,188 2.5271 35,612,369 0.87454 31,144,441 2038 1,258,188 1,258,188 2.6188 3,294,944 0.83632 2,755,628 2039 7,675,188 7,675,188 2.7139 20,829,694 0.79977 16,658,964 2040 1,261,635 1,261,635 2.8124 3,548,224 0.76482 2,713,752 2041 14,092,188 14,092,188 2.9145 41,071,683 0.73139 30,039,418 2042 1,258,188 1,258,188 3.0203 3,800,106 0.69943 2,657,908 2043 14,092,188 14,092,188 3.1299 44,107,140 0.66886 29,501,502 2044 1,261,635 1,261,635 3.2436 4,092,241 0.63963 2,617,520 2045 14,092,188 14,092,188 3.3613 47,368,073 0.61168 28,974,103 2046 1,258,188 1,258,188 3.4833 4,382,647 0.58494 2,563,586 2047 14,092,188 14,092,188 3.6098 50,869,982 0.55938 28,455,650 2048 1,261,635 1,261,635 3.7408 4,719,526 0.53493 2,524,616 2049 20,432,246 20,432,246 3.8766 79,207,646 0.51156 40,519,463 2050 542,119 542,119 4.0173 2,177,855 0.48920 1,065,406 2051 2,821,637 2,821,637 4.1631 11,746,759 0.46782 5,495,369 2052 4,453,546 4,453,546 4.3143 19,213,933 0.44738 8,595,929 2053 4,045,150 4,045,150 4.4709 18,085,462 0.42782 7,737,322 2054 3,848,051 3,848,051 3.0535 11,750,024 0.40913 4,807,287 2055 3,532,951 3,532,951 3.1338 11,071,562 0.39125 4,331,749 2056 4,013,985 4,013,985 3.2162 12,909,780 0.37415 4,830,194 2057 3,532,951 3,532,951 3.3008 11,661,564 0.35780 4,172,508 2058 3,375,401 3,375,401 3.3876 11,434,508 0.34216 3,912,431 2059 3,690,501 3,690,501 3.4767 12,830,765 0.32721 4,198,354 2060 3,541,335 3,541,335 3.5681 12,635,839 0.31291 3,953,880 2061 3,690,501 3,690,501 3.6620 13,514,614 0.29923 4,043,978 2062 3,690,501 3,690,501 3.7583 13,870,010 0.28615 3,968,903 2063 3,690,501 3,690,501 3.8571 14,234,631 0.27365 3,895,307 2064 3,541,335 3,541,335 3.9586 14,018,730 0.26169 3,668,561 2065 3,690,501 3,690,501 4.0627 14,993,398 0.25025 3,752,098 2066 3,690,501 3,690,501 4.1695 15,387,544 0.23932 3,682,547 2067 3,532,951 3,532,951 4.2792 15,118,204 0.22886 3,459,952 2068 3,698,885 3,698,885 4.3917 16,244,395 0.21886 3,555,248 2069 3,690,501 3,690,501 4.5072 16,633,826 0.20929 3,481,293 2070 3,532,951 3,532,951 4.6258 16,342,724 0.20014 3,270,833 2071 3,690,501 3,690,501 4.7474 17,520,284 0.19140 3,353,382 2072 3,698,885 3,698,885 4.8723 18,022,079 0.18303 3,298,581 2073 3,532,951 3,532,951 5.0004 17,666,168 0.17503 3,092,109 2074 3,690,501 3,690,501 5.1320 18,939,651 0.16738 3,170,119 2075 4,840,501 4,840,501 5.2669 25,494,434 0.16007 4,080,894 2076 3,541,335 3,541,335 5.4054 19,142,334 0.15307 2,930,117 2077 3,533,595 3,533,595 5.5476 19,602,974 0.14638 2,869,483 2078 1,693,045 1,693,045 5.6935 9,639,352 0.13999 1,349,413 | |||
$235,587,951 235,587,951 839,684,365 396,692,950 | |||
$941,101,819 $941,101,819 $3,703,785,274 $1,329,257,586 | |||
4 pages follow | ENCLOSURE 7 Nuclear Decommissioning Accrual Calculation - Site Restoration 4 pages follow | ||
Levelized (beginning of year payment, mid year interest) | Enclosure 7 Levelized (beginning of year payment, mid year interest) | ||
ANNUAL ACCRUAL | ANNUAL ACCRUAL | ||
==SUMMARY== | ==SUMMARY== | ||
(3) = Future Value of jurisdictional nominal cost | Operational Post-Shutdown Present Recovered 2013-2014 Remaining Earnings Earnings Value to Through Decommissioning Life (yrs) Rate Rate Decommission 12/31/2012 Accrual (9) (10) (10) (5) (11) (12) | ||
EXTERNAL FUND Monticello 17.75 5.35% 4.82% $53,400,416 $16,797,894 2,055,528 Prairie Island Unit 1 20.80 5.50% 4.66% 65,190,882 40,462,870 471,837 Prairie Island Unit 2 21.80 5.53% 4.57% 88,706,991 23,060,906 1,412,290 TOTAL DECOMMISSIONING ACCRUAL $207,298,289 $80,321,670 $3,939,655 INPUT DATA Escalation Rate (Operation/Radiological) 3.63% (a) | |||
Escalation Rate (ISFSI/Site Restoration) 2.63% (a) | |||
Jurisdictional Factor 100.0000% (b) | |||
IRS Tax Qualified Percent 100.00% (c) | |||
External Percent 100.00% (d) | |||
NOTES Input Data (a) = Inflation rate from current filing documentation (b) = Minnesota jurisdictional percent from last electric rate case (c) = IRS qualifying percent based upon 2005 Energy Policy Act (d) = Recommended external funding Amount to Recover (1) = Current cost estimate by year from TLG Cost Study, 2011. | |||
(2) = Jurisdictional Nominal Cost = (1) x (c) | |||
(3) = Future Value of jurisdictional nominal cost (4) = Discount factor based upon the applicable earnings rate for present value calculation (5) = Present value to decommission at the start of 2012 Decommissioning Accrual (9) = Remaining life based on E,G002/D-11-144 (10) = Fund earnings rate (11) = Fund balances to date (12) = Annuity or decommissioning accrual | |||
(4) | Enclosure 7 Levelized (beginning of year payment, mid year interest) | ||
AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6) | |||
Monticello 3.63% | |||
Factors 2011 100.0000% 2.63% 4.82% 2030 2030 $142,203 $142,203 1.9689 $279,983 1.00000 $279,983 2031 548,003 548,003 2.0404 1,118,145 0.95402 1,066,733 2032 319,299 319,299 2.1144 675,127 0.91015 614,467 2033 97,261 97,261 2.1912 213,119 0.86830 185,051 2034 4,000 4,000 2.2707 9,084 0.82837 7,525 2035 2,641 2,641 2.3532 6,216 0.79028 4,912 2036 - 0 2.4386 0 0.75394 0 2037 - 0 2.5271 0 0.71927 0 2038 - 0 2.6188 0 0.68619 0 2039 - 0 2.7139 0 0.65464 0 2040 - 0 2.8124 0 0.62454 0 2041 - 0 2.9145 0 0.59582 0 2042 - 0 3.0203 0 0.56842 0 2043 - 0 3.1299 0 0.54228 0 2044 - 0 3.2436 0 0.51735 0 2045 - 0 3.3613 0 0.49356 0 2046 - 0 3.4833 0 0.47086 0 2047 14,766,846 14,766,846 3.6098 53,305,360 0.44921 23,945,301 2048 17,027,077 17,027,077 3.7408 63,694,891 0.42855 27,296,445 2049 - 0 3.8766 0 0.40885 0 2050 - 0 4.0173 0 0.39005 0 2051 - 0 4.1631 0 0.37211 0 2052 - 0 4.3143 0 0.35500 0 2053 - 0 4.4709 0 0.33868 0 2054 - 0 4.6332 0 0.32310 0 2055 - 0 3.1338 0 0.30825 0 2056 - 0 3.2162 0 0.29407 0 2057 - 0 3.3008 0 0.28055 0 2058 - 0 3.3876 0 0.26765 0 2059 - 0 3.4767 0 0.25534 0 2060 - 0 3.5681 0 0.24360 0 2061 - 0 3.6620 0 0.23240 0 2062 - 0 3.7583 0 0.22171 0 2063 - 0 3.8571 0 0.21152 0 2064 - 0 3.9586 0 0.20179 0 2065 - 0 4.0627 0 0.19251 0 2066 - 0 4.1695 0 0.18366 0 2067 - 0 4.2792 0 0.17521 0 2068 - 0 4.3917 0 0.16716 0 2069 - 0 4.5072 0 0.15947 0 2070 - 0 4.6258 0 0.15214 0 2071 - 0 4.7474 0 0.14514 0 2072 - 0 4.8723 0 0.13847 0 2073 - 0 5.0004 0 0.13210 0 2074 - 0 5.1320 0 0.12603 0 2075 - 0 5.2669 0 0.12023 0 2076 - 0 5.4054 0 0.11470 0 2077 - 0 5.5476 0 0.10943 0 2078 - 0 5.6935 0 0.10440 0 2079 - 0 5.8432 0 0.09959 0 2080 - 0 5.9969 0 0.09502 0 2081 - 0 6.1546 0 0.09065 0 2082 - 0 6.3165 0 0.08648 0 2083 - 0 6.4826 0 0.08250 0 2084 - 0 6.6531 0 0.07871 0 2085 - 0 6.8281 0 0.07509 0 2086 - 0 7.0077 0 0.07164 0 2087 - 0 7.1920 0 0.06834 0 2088 - 0 7.3811 0 0.06520 0 2089 - 0 7.5753 0 0.06220 0 2090 - 0 7.7745 0 0.05934 0 2091 - 0 7.9790 0 0.05661 0 | |||
$32,907,331 $32,907,331 $119,301,923 $53,400,416 | |||
( | Enclosure 7 Levelized (beginning of year payment, mid year interest) | ||
AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6) | |||
Prairie Island Unit 1 3.63% | |||
Factors 2011 100.0000% 2.63% 4.66% 2033 2033 193,306 193,306 2.1912 423,572 1.00000 423,572 2034 823,827 823,827 2.2707 1,870,664 0.95547 1,787,364 2035 1,542,879 1,542,879 2.3532 3,630,703 0.91293 3,314,577 2036 1,789,943 1,789,943 2.4386 4,364,954 0.87228 3,807,462 2037 1,357,175 1,357,175 2.5271 3,429,716 0.83345 2,858,497 2038 0 0 2.6188 0 0.79634 0 2039 0 0 2.7139 0 0.76088 0 2040 0 0 2.8124 0 0.72700 0 2041 0 0 2.9145 0 0.69463 0 2042 0 0 3.0203 0 0.66370 0 2043 0 0 3.1299 0 0.63415 0 2044 0 0 3.2436 0 0.60592 0 2045 0 0 3.3613 0 0.57894 0 2046 0 0 3.4833 0 0.55316 0 2047 0 0 3.6098 0 0.52853 0 2048 0 0 3.7408 0 0.50500 0 2049 0 0 3.8766 0 0.48251 0 2050 0 0 4.0173 0 0.46103 0 2051 8,892,023 8,892,023 4.1631 37,018,382 0.44050 16,306,597 2052 13,790,172 13,790,172 4.3143 59,494,937 0.42089 25,040,824 2053 6,480,627 6,480,627 4.4709 28,974,236 0.40215 11,651,989 2054 0 0 3.0535 0 0.38424 0 2055 0 0 3.1338 0 0.36713 0 2056 0 0 3.2162 0 0.35079 0 2057 0 0 3.3008 0 0.33517 0 2058 0 0 3.3876 0 0.32024 0 2059 0 0 3.4767 0 0.30599 0 2060 0 0 3.5681 0 0.29236 0 2061 0 0 3.6620 0 0.27934 0 2062 0 0 3.7583 0 0.26691 0 2063 0 0 3.8571 0 0.25502 0 2064 0 0 3.9586 0 0.24367 0 2065 0 0 4.0627 0 0.23282 0 2066 0 0 4.1695 0 0.22245 0 2067 0 0 4.2792 0 0.21255 0 2068 0 0 4.3917 0 0.20308 0 2069 0 0 4.5072 0 0.19404 0 2070 - 0 4.6258 0 0.18540 0 2071 - 0 4.7474 0 0.17715 0 2072 - 0 4.8723 0 0.16926 0 2073 - 0 5.0004 0 0.16172 0 2074 - 0 5.1320 0 0.15452 0 2075 - 0 5.2669 0 0.14764 0 2076 - 0 5.4054 0 0.14107 0 2077 - 0 5.5476 0 0.13479 0 2078 - 0 5.6935 0 0.12879 0 | |||
$34,869,951 $34,869,951 $139,207,164 $65,190,882 | |||
( | Enclosure 7 Levelized (beginning of year payment, mid year interest) | ||
AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6) | |||
Prairie Island Unit 2 3.63% | |||
Factors 2011 100.0000% 2.63% 4.57% 2034 2034 36,517 36,517 2.2707 82,920 1.00000 82,920 2035 271,970 271,970 2.3532 640,000 0.95630 612,032 2036 1,476,032 1,476,032 2.4386 3,599,453 0.91450 3,291,699 2037 1,860,849 1,860,849 2.5271 4,702,552 0.87454 4,112,570 2038 1,776,026 1,776,026 2.6188 4,651,057 0.83632 3,889,772 2039 253,023 253,023 2.7139 686,679 0.79977 549,185 2040 0 - 2.8124 - 0.76482 0 2041 0 - 2.9145 - 0.73139 0 2042 0 - 3.0203 - 0.69943 0 2043 0 - 3.1299 - 0.66886 0 2044 0 - 3.2436 - 0.63963 0 2045 0 - 3.3613 - 0.61168 0 2046 0 - 3.4833 - 0.58494 0 2047 0 - 3.6098 - 0.55938 0 2048 0 - 3.7408 - 0.53493 0 2049 0 - 3.8766 - 0.51156 0 2050 0 - 4.0173 - 0.48920 0 2051 12,023,581 12,023,581 4.1631 50,055,371 0.46782 23,416,904 2052 18,646,740 18,646,740 4.3143 80,447,632 0.44738 35,990,662 2053 8,762,949 8,762,949 4.4709 39,178,269 0.42782 16,761,247 2054 0 - 3.0535 - 0.40913 0 2055 0 - 3.1338 - 0.39125 0 2056 0 - 3.2162 - 0.37415 0 2057 0 - 3.3008 - 0.35780 0 2058 0 - 3.3876 - 0.34216 0 2059 0 - 3.4767 - 0.32721 0 2060 0 - 3.5681 - 0.31291 0 2061 0 - 3.6620 - 0.29923 0 2062 0 - 3.7583 - 0.28615 0 2063 0 - 3.8571 - 0.27365 0 2064 0 - 3.9586 - 0.26169 0 2065 0 - 4.0627 - 0.25025 0 2066 0 - 4.1695 - 0.23932 0 2067 0 - 4.2792 - 0.22886 0 2068 0 - 4.3917 - 0.21886 0 2069 0 - 4.5072 - 0.20929 0 2070 - - 4.6258 - 0.20014 0 2071 - - 4.7474 - 0.19140 0 2072 - - 4.8723 - 0.18303 0 2073 - - 5.0004 - 0.17503 0 2074 - - 5.1320 - 0.16738 0 2075 - - 5.2669 - 0.16007 0 2076 - - 5.4054 - 0.15307 0 2077 - - 5.5476 - 0.14638 0 2078 - - 5.6935 - 0.13999 0 | |||
$45,107,689 45,107,689 184,043,933 88,706,991 | |||
$112,884,971 $112,884,971 $442,553,020 $207,298,289 | |||
ENCLOSURE 8 Xcel Energy Trust Fund Balances - 2011 and 2012 4 pages follow | |||
ENCLOSURE 8 Excluded from Balances as of December 31, 2011 NRC calculation External Qualified Book Value Market Adjustment Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 All Units Radiological 353,978,486 237,710,954 282,803,110 (5,762,727) (2,722,654) (1,931,539) 348,215,759 234,988,300 280,871,571 864,075,630 Spent Fuel 97,526,724 102,126,639 95,403,912 (1,587,723) (1,169,721) (651,607) 95,939,001 100,956,918 94,752,305 291,648,224 Site Restoration 14,602,942 33,651,309 18,124,208 (237,734) (385,430) (123,788) 14,365,208 33,265,879 18,000,420 65,631,507 Total 466,108,153 373,488,902 396,331,230 (7,588,185) (4,277,805) (2,706,934) 458,519,968 369,211,097 393,624,296 1,221,355,361 External Escrow Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 Radiological 609,135 31,807,897 45,565,133 551 123,038 175,609 609,686 31,930,936 45,740,742 78,281,364 Spent Fuel 167,826 13,665,477 15,371,443 152 52,860 59,242 167,978 13,718,338 15,430,685 29,317,001 Site Restoration 25,129 4,502,853 2,920,166 23 17,418 11,254 25,152 4,520,270 2,931,420 7,476,842 Total 802,091 49,976,227 63,856,742 726 193,316 246,105 802,817 50,169,544 64,102,846 115,075,207 Internal Monti PI1 PI2 Radiological - 291,059 566,265 857,324 Spent Fuel - 125,046 191,030 316,076 Site Restoration - 41,203 36,291 77,494 Total - 457,309 793,585 1,250,894 Grand Total Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 Radiological 354,587,622 269,518,852 328,368,243 (5,762,176) (2,599,616) (1,755,931) 348,825,446 267,210,295 327,178,577 943,214,317 Spent Fuel 97,694,551 115,792,116 110,775,355 (1,587,571) (1,116,861) (592,365) 96,106,979 114,800,302 110,374,020 321,281,301 Site Restoration 14,628,071 38,154,161 21,044,374 (237,711) (368,012) (112,534) 14,390,360 37,827,353 20,968,131 73,185,844 Total 466,910,244 423,465,129 460,187,972 (7,587,459) (4,084,489) (2,460,829) 459,322,785 419,837,949 458,520,727 1,337,681,462 | |||
4 | ENCLOSURE 8 Balances as of December 31, 2011 External Qualified Book Value Market Adjust Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 MN Retail 344,502,150.04 276,548,862.99 294,576,915.28 (6,159,600.62) (3,605,330.19) (2,250,699.57) 338,342,549.42 272,943,532.80 292,326,215.71 ND Retail 26,111,083.45 20,754,551.00 21,560,120.76 (71,859.03) (137,632.77) (123,035.28) 26,039,224.42 20,616,918.23 21,437,085.48 SD Retail 16,956,364.11 14,845,957.45 15,957,964.44 (162,627.66) (20,779.11) 39,545.68 16,793,736.45 14,825,178.34 15,997,510.12 MN FERC 8,798,085.58 6,752,100.02 6,308,838.23 (85,506.44) 141,254.15 (1.60) 8,712,579.14 6,893,354.17 6,308,836.63 WI FERC 6,808,993.49 5,484,614.04 4,721,734.24 29,354.91 (1,170,067.11) 21,441.45 6,838,348.40 4,314,546.93 4,743,175.69 WI Retail 62,931,476.36 49,102,816.94 53,205,656.51 (1,137,945.76) 514,749.91 (394,184.78) 61,793,530.60 49,617,566.85 52,811,471.73 Total 466,108,153.03 373,488,902.44 396,331,229.46 (7,588,184.60) (4,277,805.12) (2,706,934.10) 458,519,968.43 369,211,097.32 393,624,295.36 External Escrow MN Retail - 37,884,536.45 48,390,281.74 - 148,324.30 189,449.50 - 38,032,860.75 48,579,731.24 WI FERC 392,877.66 1,091,217.30 1,217,384.86 1,162.98 4,661.69 5,329.81 394,040.64 1,095,878.99 1,222,714.67 ND Retail 409,213.17 1,955,974.97 3,188,044.62 (437.22) 4,922.45 8,023.16 408,775.95 1,960,897.42 3,196,067.78 WI Retail - 9,044,498.52 11,061,030.40 - 35,407.93 43,302.28 - 9,079,906.45 11,104,332.68 Total 802,090.83 49,976,227.24 63,856,741.62 725.76 193,316.37 246,104.75 802,816.59 50,169,543.61 64,102,846.37 Internal - 457,309.00 793,585.00 Grand Total 466,910,243.86 423,465,129.68 460,187,971.08 (7,587,458.84) (4,084,488.75) (2,460,829.35) 459,322,785.02 419,837,949.93 458,520,726.73 | ||
ENCLOSURE 8 Balances as of December 31, | ENCLOSURE 8 Excluded from Balances as of December 31, 2012 NRC calculation External Qualified Book Value Market Adjustment Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 All Units Radiological 363,508,519 244,454,460 290,786,332 24,391,800 17,035,991 21,777,007 387,900,320 261,490,451 312,563,339 961,954,110 Spent Fuel 100,152,401 105,023,819 98,097,060 6,720,330 7,319,093 7,346,495 106,872,731 112,342,912 105,443,555 324,659,198 Site Restoration 14,996,092 34,605,946 18,635,835 1,006,253 2,411,683 1,395,639 16,002,345 37,017,629 20,031,473 73,051,448 Total 478,657,012 384,084,226 407,519,226 32,118,384 26,766,766 30,519,141 510,775,396 410,850,992 438,038,367 1,359,664,755 External Escrow Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 Radiological 19,289,851 24,333,724 47,268,579 (5,573) 3,265 1,505 19,284,278 24,336,989 47,270,084 90,891,351 Spent Fuel 5,314,662 10,454,384 15,946,102 (1,535) 1,403 508 5,313,126 10,455,786 15,946,610 31,715,522 Site Restoration 795,779 3,444,779 3,029,336 (230) 462 96 795,549 3,445,241 3,029,432 7,270,222 Total 25,400,291 38,232,887 66,244,017 (7,338) 5,129 2,109 25,392,953 38,238,016 66,246,126 129,877,095 Grand Total Monti PI1 PI2 Monti PI1 PI2 PI1 PI2 Radiological 382,798,370 268,788,185 338,054,911 24,386,228 17,039,256 21,778,512 407,184,598 285,827,440 359,833,423 1,052,845,460 Spent Fuel 105,467,063 115,478,203 114,043,162 6,718,795 7,320,495 7,347,003 112,185,858 122,798,698 121,390,165 356,374,720 Site Restoration 15,791,871 38,050,725 21,665,170 1,006,023 2,412,145 1,395,735 16,797,894 40,462,870 23,060,906 80,321,670 Total 504,057,303 422,317,113 473,763,243 32,111,046 26,771,895 30,521,250 536,168,350 449,089,008 504,284,493 1,489,541,851 | ||
ENCLOSURE 8 Balances as of December 31, 2012 External Qualified Book Value Market Adjust Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 MN Retail 353,321,554.06 284,178,023.43 302,879,754.40 23,916,799.88 19,710,266.64 22,434,385.54 377,238,353.94 303,888,290.07 325,314,139.94 ND Retail 27,089,209.74 21,456,891.84 22,106,093.51 1,714,772.75 1,397,148.54 1,806,683.08 28,803,982.49 22,854,040.38 23,912,776.59 SD Retail 17,485,379.03 15,284,639.90 16,335,690.37 1,169,235.47 1,201,955.45 1,535,356.84 18,654,614.50 16,486,595.35 17,871,047.21 MN FERC 9,058,633.75 6,960,633.09 6,538,360.28 630,015.87 701,645.12 437,919.17 9,688,649.62 7,662,278.21 6,976,279.45 WI FERC 7,160,600.91 5,706,383.42 4,938,068.14 331,482.19 (983,144.15) 268,939.89 7,492,083.10 4,723,239.27 5,207,008.03 WI Retail 64,541,634.43 50,497,654.85 54,721,258.91 4,356,078.09 4,738,894.52 4,035,856.36 68,897,712.52 55,236,549.37 58,757,115.27 Total 478,657,011.92 384,084,226.53 407,519,225.61 32,118,384.25 26,766,766.12 30,519,140.88 510,775,396.17 410,850,992.65 438,038,366.49 External Escrow MN Retail 24,967,702.62 26,110,102.09 50,737,787.13 (5,089.41) 6,247.74 4,429.61 24,962,613.21 26,116,349.83 50,742,216.74 WI FERC 393,887.17 1,094,024.95 1,220,517.40 (334.06) 498.13 684.43 393,553.11 1,094,523.08 1,221,201.83 ND Retail 38,701.60 1,960,998.76 3,196,232.87 (1,914.53) (2,527.51) (4,119.51) 36,787.07 1,958,471.25 3,192,113.36 WI Retail - 9,067,761.03 11,089,479.46 - 911.06 1,114.08 - 9,068,672.09 11,090,593.54 Total 25,400,291.39 38,232,886.83 66,244,016.86 (7,338.00) 5,129.42 2,108.61 25,392,953.39 38,238,016.25 66,246,125.47 Internal - - - | |||
(2,527.51) | Grand Total 504,057,303.31 422,317,113.36 473,763,242.47 32,111,046.25 26,771,895.54 30,521,249.49 536,168,349.56 449,089,008.90 504,284,491.96}} | ||
(4,119.51) 36,787.07 | |||
911.06 1,114.08 | |||
Latest revision as of 21:15, 4 November 2019
| ML13084A050 | |
| Person / Time | |
|---|---|
| Site: | Monticello, Prairie Island  |
| Issue date: | 03/22/2013 |
| From: | Northern States Power Co, Xcel Energy |
| To: | Office of Nuclear Reactor Regulation |
| Shared Package | |
| ML130840165 | List: |
| References | |
| L-XE-13-03 | |
| Download: ML13084A050 (21) | |
Text
ENCLOSURES Enclosure Plant Title 1 Prairie Island Nuclear Generating Decommissioning Funding Status Plant, Unit 1 (PI1) Report 2 Prairie Island Nuclear Generating Decommissioning Funding Status Plant, Unit 2 (PI2) Report 3 Monticello Nuclear Generating Plant Decommissioning Funding Status (MNGP) Report 4 All Xcel Energy Breakdown of Annual Contributions and Trust Fund Balance (RIS 2001-07) 5 All Nuclear Decommissioning Accrual Calculation - Radiological 6 All Nuclear Decommissioning Accrual Calculation - Spent Fuel 7 All Nuclear Decommissioning Accrual Calculation - Site Restoration 8 All Xcel Energy Trust Fund Balances -
2011 and 2012
ENCLOSURE 5 Nuclear Decommissioning Accrual Calculation - Radiological 4 pages follow
ENCLOSURE 5 Levelized (beginning of year payment, mid year interest)
ANNUAL ACCRUAL
SUMMARY
- RADIOLOGICAL Operational Post-Shutdown Present Recovered Radiological Remaining Earnings Earnings Value to Through Decommissioning Life (yrs) Rate Rate Decommission 12/31/2012 Accrual (9) (10) (10) (5) (11) (12)
EXTERNAL FUND Monticello 17.75 5.35% 4.82% $1,204,831,884 $407,184,598 5,555,927 Prairie Island Unit 1 20.80 5.50% 4.66% 879,842,710 285,827,440 0 Prairie Island Unit 2 21.80 5.53% 4.57% 1,175,904,702 359,833,423 0 TOTAL DECOMMISSIONING ACCRUAL $3,260,579,296 $1,052,845,460 $5,555,927 INPUT DATA Escalation Rate (Operation/Radiological) 3.63% (a)
Escalation Rate (ISFSI/Site Restoration) 2.63% (a)
Jurisdictional Factor 100.0000% (b)
IRS Tax Qualified Percent 100.00% (c)
External Percent 100.00% (d)
NOTES Input Data (a) = Inflation rate from current filing documentation (b) = Minnesota jurisdictional percent from last electric rate case (c) = IRS qualifying percent based upon 2005 Energy Policy Act (d) = Recommended external funding Amount to Recover (1) = Current cost estimate by year from TLG Cost Study, 2011.
(2) = Jurisdictional Nominal Cost = (1) x (c)
(3) = Future Value of jurisdictional nominal cost (4) = Discount factor based upon the applicable earnings rate for present value calculation (5) = Present value to decommission at the start of 2012 Decommissioning Accrual (9) = Remaining life based on E,G002/D-11-144 (10) = Fund earnings rate (11) = Fund balances to date (12) = Annuity or decommissioning accrual
ENCLOSURE 5 Levelized (beginning of year payment, mid year interest)
AMOUNT TO RECOVER - RADIOLOGICAL Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6)
Monticello 3.63%
Factors 2011 100.0000% 2.63% 4.82% 2030 2030 $18,322,903 $18,322,903 1.9689 $36,075,964 1.00000 $36,075,964 2031 75,519,265 75,519,265 2.0404 154,089,508 0.95402 147,004,473 2032 137,152,490 137,152,490 2.1144 289,995,225 0.91015 263,939,154 2033 98,485,327 98,485,327 2.1912 215,801,048 0.86830 187,380,050 2034 64,788,675 64,788,675 2.2707 147,115,643 0.82837 121,866,185 2035 47,657,043 47,657,043 2.3532 112,146,553 0.79028 88,627,178 2036 14,400,233 14,400,233 2.4386 35,116,407 0.75394 26,475,664 2037 14,360,888 14,360,888 2.5271 36,291,399 0.71927 26,103,315 2038 14,360,888 14,360,888 2.6188 37,608,293 0.68619 25,806,434 2039 14,360,888 14,360,888 2.7139 38,974,013 0.65464 25,513,948 2040 14,400,233 14,400,233 2.8124 40,499,214 0.62454 25,293,379 2041 14,360,888 14,360,888 2.9145 41,854,807 0.59582 24,937,931 2042 14,360,888 14,360,888 3.0203 43,374,189 0.56842 24,654,756 2043 14,360,888 14,360,888 3.1299 44,948,142 0.54228 24,374,479 2044 14,400,233 14,400,233 3.2436 46,708,594 0.51735 24,164,691 2045 26,521,966 26,521,966 3.3613 89,148,285 0.49356 44,000,028 2046 42,748,794 42,748,794 3.4833 148,906,876 0.47086 70,114,291 2047 7,279,588 7,279,588 3.6098 26,277,856 0.44921 11,804,276 2048 672,833 672,833 3.7408 2,516,933 0.42855 1,078,632 2049 - 0 3.8766 0 0.40885 0 2050 - 0 4.0173 0 0.39005 0 2051 - 0 4.1631 0 0.37211 0 2052 - 0 4.3143 0 0.35500 0 2053 - 0 4.4709 0 0.33868 0 2054 - 0 4.6332 0 0.32310 0 2055 - 0 3.1338 0 0.30825 0 2056 - 0 3.2162 0 0.29407 0 2057 - 0 3.3008 0 0.28055 0 2058 - 0 3.3876 0 0.26765 0 2059 - 0 3.4767 0 0.25534 0 2060 - 0 3.5681 0 0.24360 0 2061 - 0 3.6620 0 0.23240 0 2062 - 0 3.7583 0 0.22171 0 2063 - 0 3.8571 0 0.21152 0 2064 - 0 3.9586 0 0.20179 0 2065 - 0 4.0627 0 0.19251 0 2066 - 0 4.1695 0 0.18366 0 2067 - 0 4.2792 0 0.17521 0 2068 - 0 4.3917 0 0.16716 0 2069 - 0 4.5072 0 0.15947 0 2070 - 0 4.6258 0 0.15214 0 2071 - 0 4.7474 0 0.14514 0 2072 - 0 4.8723 0 0.13847 0 2073 - 0 5.0004 0 0.13210 0 2074 - 0 5.1320 0 0.12603 0 2075 - 0 5.2669 0 0.12023 0 2076 2,068 2,068 5.4054 11,180 0.11470 1,282 2077 754,915 754,915 5.5476 4,187,969 0.10943 458,289 2078 754,915 754,915 5.6935 4,298,111 0.10440 448,723 2079 754,915 754,915 5.8432 4,411,122 0.09959 439,304 2080 756,984 756,984 5.9969 4,539,555 0.09502 431,349 2081 754,915 754,915 6.1546 4,646,202 0.09065 421,178 2082 754,915 754,915 6.3165 4,768,423 0.08648 412,373 2083 754,915 754,915 6.4826 4,893,814 0.08250 403,740 2084 756,984 756,984 6.6531 5,036,288 0.07871 396,406 2085 754,915 754,915 6.8281 5,154,638 0.07509 387,062 2086 754,915 754,915 7.0077 5,290,220 0.07164 378,991 2087 754,915 754,915 7.1920 5,429,351 0.06834 371,042 2088 756,984 756,984 7.3811 5,587,372 0.06520 364,297 2089 754,915 754,915 7.5753 5,718,710 0.06220 355,704 2090 752,847 752,847 7.7745 5,853,010 0.05934 347,318 2091 - 0 7.9790 0 0.05661 0
$659,089,927 $659,089,927 $1,657,274,914 $1,204,831,884
ENCLOSURE 5 Levelized (beginning of year payment, mid year interest)
AMOUNT TO RECOVER - RADIOLOGICAL Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6)
Prairie Island Unit 1 3.63%
Factors 2011 100.0000% 2.63% 4.66% 2033 2033 20,820,603 20,820,603 2.1912 45,622,105 1.00000 45,622,105 2034 65,863,767 65,863,767 2.2707 149,556,856 0.95547 142,897,089 2035 105,472,896 105,472,896 2.3532 248,198,819 0.91293 226,588,148 2036 80,683,306 80,683,306 2.4386 196,754,309 0.87228 171,624,849 2037 40,634,808 40,634,808 2.5271 102,688,224 0.83345 85,585,500 2038 5,090,301 5,090,301 2.6188 13,330,479 0.79634 10,615,594 2039 5,090,301 5,090,301 2.7139 13,814,567 0.76088 10,511,228 2040 5,104,247 5,104,247 2.8124 14,355,183 0.72700 10,436,218 2041 5,090,301 5,090,301 2.9145 14,835,681 0.69463 10,305,309 2042 5,090,301 5,090,301 3.0203 15,374,235 0.66370 10,203,880 2043 5,090,301 5,090,301 3.1299 15,932,132 0.63415 10,103,362 2044 5,104,247 5,104,247 3.2436 16,556,135 0.60592 10,031,693 2045 5,090,301 5,090,301 3.3613 17,110,028 0.57894 9,905,679 2046 5,090,301 5,090,301 3.4833 17,731,044 0.55316 9,808,104 2047 5,090,301 5,090,301 3.6098 18,374,967 0.52853 9,711,721 2048 5,104,247 5,104,247 3.7408 19,093,966 0.50500 9,642,453 2049 10,045,148 10,045,148 3.8766 38,941,023 0.48251 18,789,433 2050 28,250,320 28,250,320 4.0173 113,490,009 0.46103 52,322,299 2051 7,680,906 7,680,906 4.1631 31,976,379 0.44050 14,085,595 2052 716,179 716,179 4.3143 3,089,812 0.42089 1,300,471 2053 336,565 336,565 4.4709 1,504,749 0.40215 605,135 2054 0 0 3.0535 0 0.38424 0 2055 0 0 3.1338 0 0.36713 0 2056 0 0 3.2162 0 0.35079 0 2057 0 0 3.3008 0 0.33517 0 2058 0 0 3.3876 0 0.32024 0 2059 0 0 3.4767 0 0.30599 0 2060 0 0 3.5681 0 0.29236 0 2061 0 0 3.6620 0 0.27934 0 2062 0 0 3.7583 0 0.26691 0 2063 0 0 3.8571 0 0.25502 0 2064 0 0 3.9586 0 0.24367 0 2065 0 0 4.0627 0 0.23282 0 2066 0 0 4.1695 0 0.22245 0 2067 0 0 4.2792 0 0.21255 0 2068 0 0 4.3917 0 0.20308 0 2069 0 0 4.5072 0 0.19404 0 2070 - 0 4.6258 0 0.18540 0 2071 - 0 4.7474 0 0.17715 0 2072 - 0 4.8723 0 0.16926 0 2073 - 0 5.0004 0 0.16172 0 2074 - 0 5.1320 0 0.15452 0 2075 - 0 5.2669 0 0.14764 0 2076 - 0 5.4054 0 0.14107 0 2077 12,232,310 12,232,310 5.5476 67,859,963 0.13479 9,146,844 2078 - 0 5.6935 0 0.12879 0
$428,771,954 $428,771,954 $1,176,190,665 $879,842,710
ENCLOSURE 5 Levelized (beginning of year payment, mid year interest)
AMOUNT TO RECOVER - RADIOLOGICAL Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6)
Prairie Island Unit 2 3.63%
Factors 2011 100.0000% 2.63% 4.57% 2034 2034 8,494,948 8,494,948 2.2707 19,289,477 1.00000 19,289,477 2035 53,283,284 53,283,284 2.3532 125,386,223 0.95630 119,906,845 2036 100,960,954 100,960,954 2.4386 246,203,383 0.91450 225,152,994 2037 98,591,560 98,591,560 2.5271 249,150,731 0.87454 217,892,281 2038 74,811,488 74,811,488 2.6188 195,916,324 0.83632 163,848,740 2039 21,913,437 21,913,437 2.7139 59,470,876 0.79977 47,563,023 2040 13,161,222 13,161,222 2.8124 37,014,621 0.76482 28,309,522 2041 13,125,262 13,125,262 2.9145 38,253,577 0.73139 27,978,284 2042 13,125,262 13,125,262 3.0203 39,642,230 0.69943 27,726,965 2043 13,125,262 13,125,262 3.1299 41,080,759 0.66886 27,477,276 2044 13,161,222 13,161,222 3.2436 42,689,740 0.63963 27,305,638 2045 13,125,262 13,125,262 3.3613 44,117,944 0.61168 26,986,064 2046 13,125,262 13,125,262 3.4833 45,719,226 0.58494 26,743,004 2047 13,125,262 13,125,262 3.6098 47,379,572 0.55938 26,503,185 2048 13,161,222 13,161,222 3.7408 49,233,499 0.53493 26,336,476 2049 17,938,969 17,938,969 3.8766 69,542,206 0.51156 35,575,011 2050 35,760,092 35,760,092 4.0173 143,659,019 0.48920 70,277,992 2051 10,457,490 10,457,490 4.1631 43,535,579 0.46782 20,366,814 2052 670,743 670,743 4.3143 2,893,788 0.44738 1,294,623 2053 315,213 315,213 4.4709 1,409,284 0.42782 602,920 2054 0 - 3.0535 - 0.40913 0 2055 0 - 3.1338 - 0.39125 0 2056 0 - 3.2162 - 0.37415 0 2057 0 - 3.3008 - 0.35780 0 2058 0 - 3.3876 - 0.34216 0 2059 0 - 3.4767 - 0.32721 0 2060 0 - 3.5681 - 0.31291 0 2061 0 - 3.6620 - 0.29923 0 2062 0 - 3.7583 - 0.28615 0 2063 0 - 3.8571 - 0.27365 0 2064 0 - 3.9586 - 0.26169 0 2065 0 - 4.0627 - 0.25025 0 2066 0 - 4.1695 - 0.23932 0 2067 0 - 4.2792 - 0.22886 0 2068 0 - 4.3917 - 0.21886 0 2069 0 - 4.5072 - 0.20929 0 2070 - - 4.6258 - 0.20014 0 2071 - - 4.7474 - 0.19140 0 2072 - - 4.8723 - 0.18303 0 2073 - - 5.0004 - 0.17503 0 2074 - - 5.1320 - 0.16738 0 2075 - - 5.2669 - 0.16007 0 2076 - - 5.4054 - 0.15307 0 2077 10,796,730 10,796,730 5.5476 59,895,939 0.14638 8,767,568 2078 - - 5.6935 - 0.13999 0
$552,230,148 552,230,148 1,601,483,999 1,175,904,702
$1,640,092,028 $1,640,092,028 $4,434,949,578 $3,260,579,296
ENCLOSURE 6 Nuclear Decommissioning Accrual Calculation - Spent Fuel 4 pages follow
Enclosure 6 Levelized (beginning of year payment, mid year interest)
ANNUAL ACCRUAL
SUMMARY
Operational Post-Shutdown Present Recovered 2013-2014 Remaining Earnings Earnings Value to Through Decommissioning Life (yrs) Rate Rate Decommission 12/31/2012 Accrual (9) (10) (10) (5) (11) (12)
EXTERNAL FUND Monticello 17.75 5.35% 4.82% $554,561,447 $112,185,858 10,755,339 Prairie Island Unit 1 20.80 5.50% 4.66% 378,003,189 122,798,698 471,837 Prairie Island Unit 2 21.80 5.53% 4.57% 396,692,950 121,390,165 1,094,077 TOTAL DECOMMISSIONING ACCRUAL $1,329,257,586 $356,374,720 $12,321,252 INPUT DATA Escalation Rate (Operation/Radiological) 3.63% (a)
Escalation Rate (ISFSI/Site Restoration) 2.63% (a)
Jurisdictional Factor 100.0000% (b)
IRS Tax Qualified Percent 100.00% (c)
External Percent 100.00% (d)
NOTES Input Data (a) = Inflation rate from current filing documentation (b) = Minnesota jurisdictional percent from last electric rate case (c) = IRS qualifying percent based upon 2005 Energy Policy Act (d) = Recommended external funding Amount to Recover (1) = Current cost estimate by year from TLG Cost Study, 2011.
(2) = Jurisdictional Nominal Cost = (1) x (c)
(3) = Future Value of jurisdictional nominal cost (4) = Discount factor based upon the applicable earnings rate for present value calculation (5) = Present value to decommission at the start of 2012 Decommissioning Accrual (9) = Remaining life based on E,G002/D-11-144 (10) = Fund earnings rate (11) = Fund balances to date (12) = Annuity or decommissioning accrual
Enclosure 6 Levelized (beginning of year payment, mid year interest)
AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6)
Monticello 3.63%
Factors 2011 100.0000% 2.63% 4.82% 2030 2030 $28,351,388 $28,351,388 1.9689 $55,821,049 1.00000 $55,821,049 2031 2,427,740 2,427,740 2.0404 4,953,562 0.95402 4,725,797 2032 1,966,707 1,966,707 2.1144 4,158,405 0.91015 3,784,773 2033 1,855,097 1,855,097 2.1912 4,064,889 0.86830 3,529,543 2034 7,163,151 7,163,151 2.2707 16,265,367 0.82837 13,473,742 2035 37,666,327 37,666,327 2.3532 88,636,400 0.79028 70,047,574 2036 1,860,023 1,860,023 2.4386 4,535,853 0.75394 3,419,761 2037 1,855,098 1,855,098 2.5271 4,688,019 0.71927 3,371,951 2038 1,855,098 1,855,098 2.6188 4,858,131 0.68619 3,333,601 2039 1,855,098 1,855,098 2.7139 5,034,551 0.65464 3,295,819 2040 1,860,023 1,860,023 2.8124 5,231,129 0.62454 3,267,050 2041 1,855,098 1,855,098 2.9145 5,406,684 0.59582 3,221,410 2042 1,855,098 1,855,098 3.0203 5,602,953 0.56842 3,184,831 2043 1,855,098 1,855,098 3.1299 5,806,272 0.54228 3,148,625 2044 1,860,023 1,860,023 3.2436 6,033,171 0.51735 3,121,261 2045 40,146,932 40,146,932 3.3613 134,945,883 0.49356 66,603,890 2046 705,105 705,105 3.4833 2,456,093 0.47086 1,156,476 2047 4,352,674 4,352,674 3.6098 15,712,281 0.44921 7,058,114 2048 7,628,121 7,628,121 3.7408 28,535,275 0.42855 12,228,792 2049 5,668,528 5,668,528 3.8766 21,974,618 0.40885 8,984,322 2050 13,810,528 13,810,528 4.0173 55,481,036 0.39005 21,640,378 2051 18,261,028 18,261,028 4.1631 76,022,488 0.37211 28,288,728 2052 10,858,901 10,858,901 4.3143 46,848,557 0.35500 16,631,238 2053 16,777,528 16,777,528 4.4709 75,010,652 0.33868 25,404,608 2054 21,228,028 21,228,028 4.6332 98,353,702 0.32310 31,778,081 2055 5,611,028 5,611,028 3.1338 17,583,841 0.30825 5,420,219 2056 5,626,401 5,626,401 3.2162 18,095,631 0.29407 5,321,382 2057 5,611,028 5,611,028 3.3008 18,520,883 0.28055 5,196,034 2058 5,611,028 5,611,028 3.3876 19,007,920 0.26765 5,087,470 2059 5,611,028 5,611,028 3.4767 19,507,863 0.25534 4,981,138 2060 5,626,401 5,626,401 3.5681 20,075,562 0.24360 4,890,407 2061 5,611,028 5,611,028 3.6620 20,547,586 0.23240 4,775,259 2062 5,611,028 5,611,028 3.7583 21,087,928 0.22171 4,675,405 2063 5,611,028 5,611,028 3.8571 21,642,298 0.21152 4,577,779 2064 5,626,401 5,626,401 3.9586 22,272,672 0.20179 4,494,402 2065 5,611,028 5,611,028 4.0627 22,795,925 0.19251 4,388,444 2066 5,611,028 5,611,028 4.1695 23,395,183 0.18366 4,296,759 2067 5,611,028 5,611,028 4.2792 24,010,713 0.17521 4,206,917 2068 5,626,401 5,626,401 4.3917 24,709,466 0.16716 4,130,434 2069 5,611,028 5,611,028 4.5072 25,290,028 0.15947 4,033,001 2070 5,611,028 5,611,028 4.6258 25,955,496 0.15214 3,948,869 2071 5,611,028 5,611,028 4.7474 26,637,797 0.14514 3,866,210 2072 5,626,401 5,626,401 4.8723 27,413,514 0.13847 3,795,949 2073 5,611,028 5,611,028 5.0004 28,057,387 0.13210 3,706,381 2074 5,611,028 5,611,028 5.1320 28,795,798 0.12603 3,629,134 2075 5,611,028 5,611,028 5.2669 29,552,726 0.12023 3,553,124 2076 5,626,941 5,626,941 5.4054 30,415,865 0.11470 3,488,700 2077 6,438,157 6,438,157 5.5476 35,716,318 0.10943 3,908,437 2078 7,698,557 7,698,557 5.6935 43,831,732 0.10440 4,576,033 2079 7,383,457 7,383,457 5.8432 43,143,014 0.09959 4,296,613 2080 7,399,369 7,399,369 5.9969 44,373,275 0.09502 4,216,349 2081 7,383,457 7,383,457 6.1546 45,442,222 0.09065 4,119,337 2082 7,698,557 7,698,557 6.3165 48,627,933 0.08648 4,205,344 2083 7,383,457 7,383,457 6.4826 47,863,996 0.08250 3,948,780 2084 7,399,369 7,399,369 6.6531 49,228,741 0.07871 3,874,794 2085 7,383,457 7,383,457 6.8281 50,414,980 0.07509 3,785,661 2086 7,698,557 7,698,557 7.0077 53,949,176 0.07164 3,864,919 2087 7,383,457 7,383,457 7.1920 53,101,820 0.06834 3,628,978 2088 9,699,369 9,699,369 7.3811 71,592,012 0.06520 4,667,799 2089 7,383,457 7,383,457 7.5753 55,931,899 0.06220 3,478,964 2090 6,447,544 6,447,544 7.7745 50,126,433 0.05934 2,974,503 2091 4,494,458 4,494,458 7.9790 35,861,278 0.05661 2,030,107
$468,388,523 $468,388,523 $2,021,013,933 $554,561,447
Enclosure 6 Levelized (beginning of year payment, mid year interest)
AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6)
Prairie Island Unit 1 3.63%
Factors 2011 100.0000% 2.63% 4.66% 2033 2033 620,158 620,158 2.1912 1,358,891 1.00000 1,358,891 2034 1,561,088 1,561,088 2.2707 3,544,763 0.95547 3,386,915 2035 21,691,551 21,691,551 2.3532 51,044,557 0.91293 46,600,108 2036 5,056,634 5,056,634 2.4386 12,331,108 0.87228 10,756,179 2037 14,092,188 14,092,188 2.5271 35,612,368 0.83345 29,681,128 2038 1,258,188 1,258,188 2.6188 3,294,942 0.79634 2,623,894 2039 7,675,188 7,675,188 2.7139 20,829,692 0.76088 15,848,896 2040 1,261,635 1,261,635 2.8124 3,548,222 0.72700 2,579,558 2041 14,092,188 14,092,188 2.9145 41,071,682 0.69463 28,529,622 2042 1,258,188 1,258,188 3.0203 3,800,105 0.66370 2,522,130 2043 14,092,188 14,092,188 3.1299 44,107,139 0.63415 27,970,542 2044 1,261,635 1,261,635 3.2436 4,092,239 0.60592 2,479,570 2045 14,092,188 14,092,188 3.3613 47,368,071 0.57894 27,423,271 2046 1,258,188 1,258,188 3.4833 4,382,646 0.55316 2,424,304 2047 14,092,188 14,092,188 3.6098 50,869,980 0.52853 26,886,310 2048 1,261,635 1,261,635 3.7408 4,719,524 0.50500 2,383,360 2049 20,432,246 20,432,246 3.8766 79,207,644 0.48251 38,218,480 2050 542,119 542,119 4.0173 2,177,855 0.46103 1,004,056 2051 2,821,637 2,821,637 4.1631 11,746,759 0.44050 5,174,447 2052 4,453,546 4,453,546 4.3143 19,213,933 0.42089 8,086,952 2053 4,045,150 4,045,150 4.4709 18,085,462 0.40215 7,273,068 2054 3,848,051 3,848,051 3.0535 11,750,024 0.38424 4,514,829 2055 3,532,951 3,532,951 3.1338 11,071,562 0.36713 4,064,702 2056 4,013,985 4,013,985 3.2162 12,909,780 0.35079 4,528,622 2057 3,532,951 3,532,951 3.3008 11,661,564 0.33517 3,908,607 2058 3,375,401 3,375,401 3.3876 11,434,508 0.32024 3,661,787 2059 3,690,501 3,690,501 3.4767 12,830,765 0.30599 3,926,086 2060 3,541,335 3,541,335 3.5681 12,635,839 0.29236 3,694,214 2061 3,690,501 3,690,501 3.6620 13,514,614 0.27934 3,775,172 2062 3,690,501 3,690,501 3.7583 13,870,010 0.26691 3,702,044 2063 3,690,501 3,690,501 3.8571 14,234,631 0.25502 3,630,116 2064 3,541,335 3,541,335 3.9586 14,018,730 0.24367 3,415,944 2065 3,690,501 3,690,501 4.0627 14,993,398 0.23282 3,490,763 2066 3,690,501 3,690,501 4.1695 15,387,544 0.22245 3,422,959 2067 3,532,951 3,532,951 4.2792 15,118,204 0.21255 3,213,374 2068 3,698,885 3,698,885 4.3917 16,244,395 0.20308 3,298,912 2069 3,690,501 3,690,501 4.5072 16,633,826 0.19404 3,227,628 2070 3,532,951 3,532,951 4.6258 16,342,724 0.18540 3,029,941 2071 3,690,501 3,690,501 4.7474 17,520,284 0.17715 3,103,718 2072 3,698,885 3,698,885 4.8723 18,022,079 0.16926 3,050,417 2073 3,532,951 3,532,951 5.0004 17,666,168 0.16172 2,856,973 2074 3,690,501 3,690,501 5.1320 18,939,651 0.15452 2,926,555 2075 4,840,501 4,840,501 5.2669 25,494,434 0.14764 3,763,998 2076 3,541,335 3,541,335 5.4054 19,142,334 0.14107 2,700,409 2077 3,533,595 3,533,595 5.5476 19,602,974 0.13479 2,642,285 2078 1,693,045 1,693,045 5.6935 9,639,352 0.12879 1,241,452
$237,125,344 $237,125,344 $843,086,976 $378,003,189
Enclosure 6 Levelized (beginning of year payment, mid year interest)
AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6)
Prairie Island Unit 2 3.63%
Factors 2011 100.0000% 2.63% 4.57% 2034 2034 273,725 273,725 2.2707 621,548 1.00000 621,548 2035 21,962,089 21,962,089 2.3532 51,681,187 0.95630 49,422,719 2036 5,156,219 5,156,219 2.4386 12,573,955 0.91450 11,498,882 2037 14,092,188 14,092,188 2.5271 35,612,369 0.87454 31,144,441 2038 1,258,188 1,258,188 2.6188 3,294,944 0.83632 2,755,628 2039 7,675,188 7,675,188 2.7139 20,829,694 0.79977 16,658,964 2040 1,261,635 1,261,635 2.8124 3,548,224 0.76482 2,713,752 2041 14,092,188 14,092,188 2.9145 41,071,683 0.73139 30,039,418 2042 1,258,188 1,258,188 3.0203 3,800,106 0.69943 2,657,908 2043 14,092,188 14,092,188 3.1299 44,107,140 0.66886 29,501,502 2044 1,261,635 1,261,635 3.2436 4,092,241 0.63963 2,617,520 2045 14,092,188 14,092,188 3.3613 47,368,073 0.61168 28,974,103 2046 1,258,188 1,258,188 3.4833 4,382,647 0.58494 2,563,586 2047 14,092,188 14,092,188 3.6098 50,869,982 0.55938 28,455,650 2048 1,261,635 1,261,635 3.7408 4,719,526 0.53493 2,524,616 2049 20,432,246 20,432,246 3.8766 79,207,646 0.51156 40,519,463 2050 542,119 542,119 4.0173 2,177,855 0.48920 1,065,406 2051 2,821,637 2,821,637 4.1631 11,746,759 0.46782 5,495,369 2052 4,453,546 4,453,546 4.3143 19,213,933 0.44738 8,595,929 2053 4,045,150 4,045,150 4.4709 18,085,462 0.42782 7,737,322 2054 3,848,051 3,848,051 3.0535 11,750,024 0.40913 4,807,287 2055 3,532,951 3,532,951 3.1338 11,071,562 0.39125 4,331,749 2056 4,013,985 4,013,985 3.2162 12,909,780 0.37415 4,830,194 2057 3,532,951 3,532,951 3.3008 11,661,564 0.35780 4,172,508 2058 3,375,401 3,375,401 3.3876 11,434,508 0.34216 3,912,431 2059 3,690,501 3,690,501 3.4767 12,830,765 0.32721 4,198,354 2060 3,541,335 3,541,335 3.5681 12,635,839 0.31291 3,953,880 2061 3,690,501 3,690,501 3.6620 13,514,614 0.29923 4,043,978 2062 3,690,501 3,690,501 3.7583 13,870,010 0.28615 3,968,903 2063 3,690,501 3,690,501 3.8571 14,234,631 0.27365 3,895,307 2064 3,541,335 3,541,335 3.9586 14,018,730 0.26169 3,668,561 2065 3,690,501 3,690,501 4.0627 14,993,398 0.25025 3,752,098 2066 3,690,501 3,690,501 4.1695 15,387,544 0.23932 3,682,547 2067 3,532,951 3,532,951 4.2792 15,118,204 0.22886 3,459,952 2068 3,698,885 3,698,885 4.3917 16,244,395 0.21886 3,555,248 2069 3,690,501 3,690,501 4.5072 16,633,826 0.20929 3,481,293 2070 3,532,951 3,532,951 4.6258 16,342,724 0.20014 3,270,833 2071 3,690,501 3,690,501 4.7474 17,520,284 0.19140 3,353,382 2072 3,698,885 3,698,885 4.8723 18,022,079 0.18303 3,298,581 2073 3,532,951 3,532,951 5.0004 17,666,168 0.17503 3,092,109 2074 3,690,501 3,690,501 5.1320 18,939,651 0.16738 3,170,119 2075 4,840,501 4,840,501 5.2669 25,494,434 0.16007 4,080,894 2076 3,541,335 3,541,335 5.4054 19,142,334 0.15307 2,930,117 2077 3,533,595 3,533,595 5.5476 19,602,974 0.14638 2,869,483 2078 1,693,045 1,693,045 5.6935 9,639,352 0.13999 1,349,413
$235,587,951 235,587,951 839,684,365 396,692,950
$941,101,819 $941,101,819 $3,703,785,274 $1,329,257,586
ENCLOSURE 7 Nuclear Decommissioning Accrual Calculation - Site Restoration 4 pages follow
Enclosure 7 Levelized (beginning of year payment, mid year interest)
ANNUAL ACCRUAL
SUMMARY
Operational Post-Shutdown Present Recovered 2013-2014 Remaining Earnings Earnings Value to Through Decommissioning Life (yrs) Rate Rate Decommission 12/31/2012 Accrual (9) (10) (10) (5) (11) (12)
EXTERNAL FUND Monticello 17.75 5.35% 4.82% $53,400,416 $16,797,894 2,055,528 Prairie Island Unit 1 20.80 5.50% 4.66% 65,190,882 40,462,870 471,837 Prairie Island Unit 2 21.80 5.53% 4.57% 88,706,991 23,060,906 1,412,290 TOTAL DECOMMISSIONING ACCRUAL $207,298,289 $80,321,670 $3,939,655 INPUT DATA Escalation Rate (Operation/Radiological) 3.63% (a)
Escalation Rate (ISFSI/Site Restoration) 2.63% (a)
Jurisdictional Factor 100.0000% (b)
IRS Tax Qualified Percent 100.00% (c)
External Percent 100.00% (d)
NOTES Input Data (a) = Inflation rate from current filing documentation (b) = Minnesota jurisdictional percent from last electric rate case (c) = IRS qualifying percent based upon 2005 Energy Policy Act (d) = Recommended external funding Amount to Recover (1) = Current cost estimate by year from TLG Cost Study, 2011.
(2) = Jurisdictional Nominal Cost = (1) x (c)
(3) = Future Value of jurisdictional nominal cost (4) = Discount factor based upon the applicable earnings rate for present value calculation (5) = Present value to decommission at the start of 2012 Decommissioning Accrual (9) = Remaining life based on E,G002/D-11-144 (10) = Fund earnings rate (11) = Fund balances to date (12) = Annuity or decommissioning accrual
Enclosure 7 Levelized (beginning of year payment, mid year interest)
AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6)
Monticello 3.63%
Factors 2011 100.0000% 2.63% 4.82% 2030 2030 $142,203 $142,203 1.9689 $279,983 1.00000 $279,983 2031 548,003 548,003 2.0404 1,118,145 0.95402 1,066,733 2032 319,299 319,299 2.1144 675,127 0.91015 614,467 2033 97,261 97,261 2.1912 213,119 0.86830 185,051 2034 4,000 4,000 2.2707 9,084 0.82837 7,525 2035 2,641 2,641 2.3532 6,216 0.79028 4,912 2036 - 0 2.4386 0 0.75394 0 2037 - 0 2.5271 0 0.71927 0 2038 - 0 2.6188 0 0.68619 0 2039 - 0 2.7139 0 0.65464 0 2040 - 0 2.8124 0 0.62454 0 2041 - 0 2.9145 0 0.59582 0 2042 - 0 3.0203 0 0.56842 0 2043 - 0 3.1299 0 0.54228 0 2044 - 0 3.2436 0 0.51735 0 2045 - 0 3.3613 0 0.49356 0 2046 - 0 3.4833 0 0.47086 0 2047 14,766,846 14,766,846 3.6098 53,305,360 0.44921 23,945,301 2048 17,027,077 17,027,077 3.7408 63,694,891 0.42855 27,296,445 2049 - 0 3.8766 0 0.40885 0 2050 - 0 4.0173 0 0.39005 0 2051 - 0 4.1631 0 0.37211 0 2052 - 0 4.3143 0 0.35500 0 2053 - 0 4.4709 0 0.33868 0 2054 - 0 4.6332 0 0.32310 0 2055 - 0 3.1338 0 0.30825 0 2056 - 0 3.2162 0 0.29407 0 2057 - 0 3.3008 0 0.28055 0 2058 - 0 3.3876 0 0.26765 0 2059 - 0 3.4767 0 0.25534 0 2060 - 0 3.5681 0 0.24360 0 2061 - 0 3.6620 0 0.23240 0 2062 - 0 3.7583 0 0.22171 0 2063 - 0 3.8571 0 0.21152 0 2064 - 0 3.9586 0 0.20179 0 2065 - 0 4.0627 0 0.19251 0 2066 - 0 4.1695 0 0.18366 0 2067 - 0 4.2792 0 0.17521 0 2068 - 0 4.3917 0 0.16716 0 2069 - 0 4.5072 0 0.15947 0 2070 - 0 4.6258 0 0.15214 0 2071 - 0 4.7474 0 0.14514 0 2072 - 0 4.8723 0 0.13847 0 2073 - 0 5.0004 0 0.13210 0 2074 - 0 5.1320 0 0.12603 0 2075 - 0 5.2669 0 0.12023 0 2076 - 0 5.4054 0 0.11470 0 2077 - 0 5.5476 0 0.10943 0 2078 - 0 5.6935 0 0.10440 0 2079 - 0 5.8432 0 0.09959 0 2080 - 0 5.9969 0 0.09502 0 2081 - 0 6.1546 0 0.09065 0 2082 - 0 6.3165 0 0.08648 0 2083 - 0 6.4826 0 0.08250 0 2084 - 0 6.6531 0 0.07871 0 2085 - 0 6.8281 0 0.07509 0 2086 - 0 7.0077 0 0.07164 0 2087 - 0 7.1920 0 0.06834 0 2088 - 0 7.3811 0 0.06520 0 2089 - 0 7.5753 0 0.06220 0 2090 - 0 7.7745 0 0.05934 0 2091 - 0 7.9790 0 0.05661 0
$32,907,331 $32,907,331 $119,301,923 $53,400,416
Enclosure 7 Levelized (beginning of year payment, mid year interest)
AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6)
Prairie Island Unit 1 3.63%
Factors 2011 100.0000% 2.63% 4.66% 2033 2033 193,306 193,306 2.1912 423,572 1.00000 423,572 2034 823,827 823,827 2.2707 1,870,664 0.95547 1,787,364 2035 1,542,879 1,542,879 2.3532 3,630,703 0.91293 3,314,577 2036 1,789,943 1,789,943 2.4386 4,364,954 0.87228 3,807,462 2037 1,357,175 1,357,175 2.5271 3,429,716 0.83345 2,858,497 2038 0 0 2.6188 0 0.79634 0 2039 0 0 2.7139 0 0.76088 0 2040 0 0 2.8124 0 0.72700 0 2041 0 0 2.9145 0 0.69463 0 2042 0 0 3.0203 0 0.66370 0 2043 0 0 3.1299 0 0.63415 0 2044 0 0 3.2436 0 0.60592 0 2045 0 0 3.3613 0 0.57894 0 2046 0 0 3.4833 0 0.55316 0 2047 0 0 3.6098 0 0.52853 0 2048 0 0 3.7408 0 0.50500 0 2049 0 0 3.8766 0 0.48251 0 2050 0 0 4.0173 0 0.46103 0 2051 8,892,023 8,892,023 4.1631 37,018,382 0.44050 16,306,597 2052 13,790,172 13,790,172 4.3143 59,494,937 0.42089 25,040,824 2053 6,480,627 6,480,627 4.4709 28,974,236 0.40215 11,651,989 2054 0 0 3.0535 0 0.38424 0 2055 0 0 3.1338 0 0.36713 0 2056 0 0 3.2162 0 0.35079 0 2057 0 0 3.3008 0 0.33517 0 2058 0 0 3.3876 0 0.32024 0 2059 0 0 3.4767 0 0.30599 0 2060 0 0 3.5681 0 0.29236 0 2061 0 0 3.6620 0 0.27934 0 2062 0 0 3.7583 0 0.26691 0 2063 0 0 3.8571 0 0.25502 0 2064 0 0 3.9586 0 0.24367 0 2065 0 0 4.0627 0 0.23282 0 2066 0 0 4.1695 0 0.22245 0 2067 0 0 4.2792 0 0.21255 0 2068 0 0 4.3917 0 0.20308 0 2069 0 0 4.5072 0 0.19404 0 2070 - 0 4.6258 0 0.18540 0 2071 - 0 4.7474 0 0.17715 0 2072 - 0 4.8723 0 0.16926 0 2073 - 0 5.0004 0 0.16172 0 2074 - 0 5.1320 0 0.15452 0 2075 - 0 5.2669 0 0.14764 0 2076 - 0 5.4054 0 0.14107 0 2077 - 0 5.5476 0 0.13479 0 2078 - 0 5.6935 0 0.12879 0
$34,869,951 $34,869,951 $139,207,164 $65,190,882
Enclosure 7 Levelized (beginning of year payment, mid year interest)
AMOUNT TO RECOVER Cost Jurisdictional Jurisdictional Present Estimate Cost in Escalation Cost in Discount Value to Nominal $s Nominal $s Factor Future $'s Factor Decommission (1) (2) (3) (4) (5) (6)
Prairie Island Unit 2 3.63%
Factors 2011 100.0000% 2.63% 4.57% 2034 2034 36,517 36,517 2.2707 82,920 1.00000 82,920 2035 271,970 271,970 2.3532 640,000 0.95630 612,032 2036 1,476,032 1,476,032 2.4386 3,599,453 0.91450 3,291,699 2037 1,860,849 1,860,849 2.5271 4,702,552 0.87454 4,112,570 2038 1,776,026 1,776,026 2.6188 4,651,057 0.83632 3,889,772 2039 253,023 253,023 2.7139 686,679 0.79977 549,185 2040 0 - 2.8124 - 0.76482 0 2041 0 - 2.9145 - 0.73139 0 2042 0 - 3.0203 - 0.69943 0 2043 0 - 3.1299 - 0.66886 0 2044 0 - 3.2436 - 0.63963 0 2045 0 - 3.3613 - 0.61168 0 2046 0 - 3.4833 - 0.58494 0 2047 0 - 3.6098 - 0.55938 0 2048 0 - 3.7408 - 0.53493 0 2049 0 - 3.8766 - 0.51156 0 2050 0 - 4.0173 - 0.48920 0 2051 12,023,581 12,023,581 4.1631 50,055,371 0.46782 23,416,904 2052 18,646,740 18,646,740 4.3143 80,447,632 0.44738 35,990,662 2053 8,762,949 8,762,949 4.4709 39,178,269 0.42782 16,761,247 2054 0 - 3.0535 - 0.40913 0 2055 0 - 3.1338 - 0.39125 0 2056 0 - 3.2162 - 0.37415 0 2057 0 - 3.3008 - 0.35780 0 2058 0 - 3.3876 - 0.34216 0 2059 0 - 3.4767 - 0.32721 0 2060 0 - 3.5681 - 0.31291 0 2061 0 - 3.6620 - 0.29923 0 2062 0 - 3.7583 - 0.28615 0 2063 0 - 3.8571 - 0.27365 0 2064 0 - 3.9586 - 0.26169 0 2065 0 - 4.0627 - 0.25025 0 2066 0 - 4.1695 - 0.23932 0 2067 0 - 4.2792 - 0.22886 0 2068 0 - 4.3917 - 0.21886 0 2069 0 - 4.5072 - 0.20929 0 2070 - - 4.6258 - 0.20014 0 2071 - - 4.7474 - 0.19140 0 2072 - - 4.8723 - 0.18303 0 2073 - - 5.0004 - 0.17503 0 2074 - - 5.1320 - 0.16738 0 2075 - - 5.2669 - 0.16007 0 2076 - - 5.4054 - 0.15307 0 2077 - - 5.5476 - 0.14638 0 2078 - - 5.6935 - 0.13999 0
$45,107,689 45,107,689 184,043,933 88,706,991
$112,884,971 $112,884,971 $442,553,020 $207,298,289
ENCLOSURE 8 Xcel Energy Trust Fund Balances - 2011 and 2012 4 pages follow
ENCLOSURE 8 Excluded from Balances as of December 31, 2011 NRC calculation External Qualified Book Value Market Adjustment Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 All Units Radiological 353,978,486 237,710,954 282,803,110 (5,762,727) (2,722,654) (1,931,539) 348,215,759 234,988,300 280,871,571 864,075,630 Spent Fuel 97,526,724 102,126,639 95,403,912 (1,587,723) (1,169,721) (651,607) 95,939,001 100,956,918 94,752,305 291,648,224 Site Restoration 14,602,942 33,651,309 18,124,208 (237,734) (385,430) (123,788) 14,365,208 33,265,879 18,000,420 65,631,507 Total 466,108,153 373,488,902 396,331,230 (7,588,185) (4,277,805) (2,706,934) 458,519,968 369,211,097 393,624,296 1,221,355,361 External Escrow Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 Radiological 609,135 31,807,897 45,565,133 551 123,038 175,609 609,686 31,930,936 45,740,742 78,281,364 Spent Fuel 167,826 13,665,477 15,371,443 152 52,860 59,242 167,978 13,718,338 15,430,685 29,317,001 Site Restoration 25,129 4,502,853 2,920,166 23 17,418 11,254 25,152 4,520,270 2,931,420 7,476,842 Total 802,091 49,976,227 63,856,742 726 193,316 246,105 802,817 50,169,544 64,102,846 115,075,207 Internal Monti PI1 PI2 Radiological - 291,059 566,265 857,324 Spent Fuel - 125,046 191,030 316,076 Site Restoration - 41,203 36,291 77,494 Total - 457,309 793,585 1,250,894 Grand Total Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 Radiological 354,587,622 269,518,852 328,368,243 (5,762,176) (2,599,616) (1,755,931) 348,825,446 267,210,295 327,178,577 943,214,317 Spent Fuel 97,694,551 115,792,116 110,775,355 (1,587,571) (1,116,861) (592,365) 96,106,979 114,800,302 110,374,020 321,281,301 Site Restoration 14,628,071 38,154,161 21,044,374 (237,711) (368,012) (112,534) 14,390,360 37,827,353 20,968,131 73,185,844 Total 466,910,244 423,465,129 460,187,972 (7,587,459) (4,084,489) (2,460,829) 459,322,785 419,837,949 458,520,727 1,337,681,462
ENCLOSURE 8 Balances as of December 31, 2011 External Qualified Book Value Market Adjust Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 MN Retail 344,502,150.04 276,548,862.99 294,576,915.28 (6,159,600.62) (3,605,330.19) (2,250,699.57) 338,342,549.42 272,943,532.80 292,326,215.71 ND Retail 26,111,083.45 20,754,551.00 21,560,120.76 (71,859.03) (137,632.77) (123,035.28) 26,039,224.42 20,616,918.23 21,437,085.48 SD Retail 16,956,364.11 14,845,957.45 15,957,964.44 (162,627.66) (20,779.11) 39,545.68 16,793,736.45 14,825,178.34 15,997,510.12 MN FERC 8,798,085.58 6,752,100.02 6,308,838.23 (85,506.44) 141,254.15 (1.60) 8,712,579.14 6,893,354.17 6,308,836.63 WI FERC 6,808,993.49 5,484,614.04 4,721,734.24 29,354.91 (1,170,067.11) 21,441.45 6,838,348.40 4,314,546.93 4,743,175.69 WI Retail 62,931,476.36 49,102,816.94 53,205,656.51 (1,137,945.76) 514,749.91 (394,184.78) 61,793,530.60 49,617,566.85 52,811,471.73 Total 466,108,153.03 373,488,902.44 396,331,229.46 (7,588,184.60) (4,277,805.12) (2,706,934.10) 458,519,968.43 369,211,097.32 393,624,295.36 External Escrow MN Retail - 37,884,536.45 48,390,281.74 - 148,324.30 189,449.50 - 38,032,860.75 48,579,731.24 WI FERC 392,877.66 1,091,217.30 1,217,384.86 1,162.98 4,661.69 5,329.81 394,040.64 1,095,878.99 1,222,714.67 ND Retail 409,213.17 1,955,974.97 3,188,044.62 (437.22) 4,922.45 8,023.16 408,775.95 1,960,897.42 3,196,067.78 WI Retail - 9,044,498.52 11,061,030.40 - 35,407.93 43,302.28 - 9,079,906.45 11,104,332.68 Total 802,090.83 49,976,227.24 63,856,741.62 725.76 193,316.37 246,104.75 802,816.59 50,169,543.61 64,102,846.37 Internal - 457,309.00 793,585.00 Grand Total 466,910,243.86 423,465,129.68 460,187,971.08 (7,587,458.84) (4,084,488.75) (2,460,829.35) 459,322,785.02 419,837,949.93 458,520,726.73
ENCLOSURE 8 Excluded from Balances as of December 31, 2012 NRC calculation External Qualified Book Value Market Adjustment Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 All Units Radiological 363,508,519 244,454,460 290,786,332 24,391,800 17,035,991 21,777,007 387,900,320 261,490,451 312,563,339 961,954,110 Spent Fuel 100,152,401 105,023,819 98,097,060 6,720,330 7,319,093 7,346,495 106,872,731 112,342,912 105,443,555 324,659,198 Site Restoration 14,996,092 34,605,946 18,635,835 1,006,253 2,411,683 1,395,639 16,002,345 37,017,629 20,031,473 73,051,448 Total 478,657,012 384,084,226 407,519,226 32,118,384 26,766,766 30,519,141 510,775,396 410,850,992 438,038,367 1,359,664,755 External Escrow Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 Radiological 19,289,851 24,333,724 47,268,579 (5,573) 3,265 1,505 19,284,278 24,336,989 47,270,084 90,891,351 Spent Fuel 5,314,662 10,454,384 15,946,102 (1,535) 1,403 508 5,313,126 10,455,786 15,946,610 31,715,522 Site Restoration 795,779 3,444,779 3,029,336 (230) 462 96 795,549 3,445,241 3,029,432 7,270,222 Total 25,400,291 38,232,887 66,244,017 (7,338) 5,129 2,109 25,392,953 38,238,016 66,246,126 129,877,095 Grand Total Monti PI1 PI2 Monti PI1 PI2 PI1 PI2 Radiological 382,798,370 268,788,185 338,054,911 24,386,228 17,039,256 21,778,512 407,184,598 285,827,440 359,833,423 1,052,845,460 Spent Fuel 105,467,063 115,478,203 114,043,162 6,718,795 7,320,495 7,347,003 112,185,858 122,798,698 121,390,165 356,374,720 Site Restoration 15,791,871 38,050,725 21,665,170 1,006,023 2,412,145 1,395,735 16,797,894 40,462,870 23,060,906 80,321,670 Total 504,057,303 422,317,113 473,763,243 32,111,046 26,771,895 30,521,250 536,168,350 449,089,008 504,284,493 1,489,541,851
ENCLOSURE 8 Balances as of December 31, 2012 External Qualified Book Value Market Adjust Market Value Monti PI1 PI2 Monti PI1 PI2 Monti PI1 PI2 MN Retail 353,321,554.06 284,178,023.43 302,879,754.40 23,916,799.88 19,710,266.64 22,434,385.54 377,238,353.94 303,888,290.07 325,314,139.94 ND Retail 27,089,209.74 21,456,891.84 22,106,093.51 1,714,772.75 1,397,148.54 1,806,683.08 28,803,982.49 22,854,040.38 23,912,776.59 SD Retail 17,485,379.03 15,284,639.90 16,335,690.37 1,169,235.47 1,201,955.45 1,535,356.84 18,654,614.50 16,486,595.35 17,871,047.21 MN FERC 9,058,633.75 6,960,633.09 6,538,360.28 630,015.87 701,645.12 437,919.17 9,688,649.62 7,662,278.21 6,976,279.45 WI FERC 7,160,600.91 5,706,383.42 4,938,068.14 331,482.19 (983,144.15) 268,939.89 7,492,083.10 4,723,239.27 5,207,008.03 WI Retail 64,541,634.43 50,497,654.85 54,721,258.91 4,356,078.09 4,738,894.52 4,035,856.36 68,897,712.52 55,236,549.37 58,757,115.27 Total 478,657,011.92 384,084,226.53 407,519,225.61 32,118,384.25 26,766,766.12 30,519,140.88 510,775,396.17 410,850,992.65 438,038,366.49 External Escrow MN Retail 24,967,702.62 26,110,102.09 50,737,787.13 (5,089.41) 6,247.74 4,429.61 24,962,613.21 26,116,349.83 50,742,216.74 WI FERC 393,887.17 1,094,024.95 1,220,517.40 (334.06) 498.13 684.43 393,553.11 1,094,523.08 1,221,201.83 ND Retail 38,701.60 1,960,998.76 3,196,232.87 (1,914.53) (2,527.51) (4,119.51) 36,787.07 1,958,471.25 3,192,113.36 WI Retail - 9,067,761.03 11,089,479.46 - 911.06 1,114.08 - 9,068,672.09 11,090,593.54 Total 25,400,291.39 38,232,886.83 66,244,016.86 (7,338.00) 5,129.42 2,108.61 25,392,953.39 38,238,016.25 66,246,125.47 Internal - - -
Grand Total 504,057,303.31 422,317,113.36 473,763,242.47 32,111,046.25 26,771,895.54 30,521,249.49 536,168,349.56 449,089,008.90 504,284,491.96