ML13084A050: Difference between revisions

From kanterella
Jump to navigation Jump to search
(Created page by program invented by StriderTol)
(Created page by program invented by StriderTol)
Line 157: Line 157:


ENCLOSURE 8 Balances as of December 31, 2011 Excluded from NRC calculation External Qualifie dMontiPI1PI2MontiPI1PI2MontiPI1PI2All UnitsRadiological353,978,48 6 237,710,95 4 282,803,11 0(5,762,727)  (2,722,654)  (1,931,539) 348,215,75 9 234,988,30 0280,871,571864,075,63 0      Spent Fuel97,526,72 4  102,126,63 9 95,403,91 2 (1,587,723)
ENCLOSURE 8 Balances as of December 31, 2011 Excluded from NRC calculation External Qualifie dMontiPI1PI2MontiPI1PI2MontiPI1PI2All UnitsRadiological353,978,48 6 237,710,95 4 282,803,11 0(5,762,727)  (2,722,654)  (1,931,539) 348,215,75 9 234,988,30 0280,871,571864,075,63 0      Spent Fuel97,526,72 4  102,126,63 9 95,403,91 2 (1,587,723)
  (1,169,721)  (651,607)    95,939,001  100,956,91 8 94,752,305 291,648,22 4      Site Restoratio n 14,602,94 2  33,651,309 18,124,20 8 (237,734)
(1,169,721)  (651,607)    95,939,001  100,956,91 8 94,752,305 291,648,22 4      Site Restoratio n 14,602,94 2  33,651,309 18,124,20 8 (237,734)
    (385,430)    (123,788) 14,365,20 8  33,265,879 18,000,42 0 65,631,50 7            Total466,108,15 3 373,488,90 2 396,331,23 0(7,588,185)  (4,277,805)  (2,706,934) 458,519,96 8 369,211,09 7 393,624,29 6 1,221,355,361 External EscrowMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological609,135        31,807,89 7  45,565,13 3 551            123,038      175,609      609,686      31,930,93 6 45,740,74 2 78,281,36 4        Spent Fuel167,826        13,665,47 7  15,371,44 3 152            52,860        59,242        167,978      13,718,33 8 15,430,685 29,317,001 Site Restoratio n25,129        4,502,853    2,920,166  23              17,418 11,25 4        25,152        4,520,27 0  2,931,42 0  7,476,84 2 Total802,091        49,976,22 7  63,856,74 2 726            193,316      246,105      802,817      50,169,54 4 64,102,84 6 115,075,20 7      InternalMontiPI1PI2 Radiological-              291,059      566,265 857,32 4 Spent Fuel-              125,046      191,030 316,076 Site Restoratio n-              41,203      36,291 77,49 4 Total-              457,309      793,585 1,250,89 4 Grand TotalMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological354,587,62 2 269,518,85 2 328,368,24 3(5,762,176)  (2,599,616)  (1,755,931) 348,825,44 6 267,210,295327,178,57 7 943,214,31 7      Spent Fuel97,694,551  115,792,11 6 110,775,355(1,587,571)
(385,430)    (123,788) 14,365,20 8  33,265,879 18,000,42 0 65,631,50 7            Total466,108,15 3 373,488,90 2 396,331,23 0(7,588,185)  (4,277,805)  (2,706,934) 458,519,96 8 369,211,09 7 393,624,29 6 1,221,355,361 External EscrowMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological609,135        31,807,89 7  45,565,13 3 551            123,038      175,609      609,686      31,930,93 6 45,740,74 2 78,281,36 4        Spent Fuel167,826        13,665,47 7  15,371,44 3 152            52,860        59,242        167,978      13,718,33 8 15,430,685 29,317,001 Site Restoratio n25,129        4,502,853    2,920,166  23              17,418 11,25 4        25,152        4,520,27 0  2,931,42 0  7,476,84 2 Total802,091        49,976,22 7  63,856,74 2 726            193,316      246,105      802,817      50,169,54 4 64,102,84 6 115,075,20 7      InternalMontiPI1PI2 Radiological-              291,059      566,265 857,32 4 Spent Fuel-              125,046      191,030 316,076 Site Restoratio n-              41,203      36,291 77,49 4 Total-              457,309      793,585 1,250,89 4 Grand TotalMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological354,587,62 2 269,518,85 2 328,368,24 3(5,762,176)  (2,599,616)  (1,755,931) 348,825,44 6 267,210,295327,178,57 7 943,214,31 7      Spent Fuel97,694,551  115,792,11 6 110,775,355(1,587,571)
  (1,116,861)  (592,365)    96,106,979  114,800,30 2 110,374,02 0 321,281,301 Site Restoratio n14,628,071  38,154,161 21,044,37 4 (237,711)
(1,116,861)  (592,365)    96,106,979  114,800,30 2 110,374,02 0 321,281,301 Site Restoratio n14,628,071  38,154,161 21,044,37 4 (237,711)
    (368,012)    (112,534) 14,390,36 0  37,827,35 3 20,968,131 73,185,84 4            Total466,910,24 4 423,465,12 9 460,187,97 2(7,587,459)  (4,084,489)  (2,460,829) 459,322,785 419,837,94 9 458,520,72 7 1,337,681,46 2    Book Value Market Adjustment Market Value ENCLOSURE 8 Balances as of December 31, 2011 External Qualified Mont i PI1 PI2 Mont i PI1 PI2 Mont i PI1 PI2MN Retail344,502,150.0 4 276,548,862.99 294,576,915.28(6,159,600.62)
(368,012)    (112,534) 14,390,36 0  37,827,35 3 20,968,131 73,185,84 4            Total466,910,24 4 423,465,12 9 460,187,97 2(7,587,459)  (4,084,489)  (2,460,829) 459,322,785 419,837,94 9 458,520,72 7 1,337,681,46 2    Book Value Market Adjustment Market Value ENCLOSURE 8 Balances as of December 31, 2011 External Qualified Mont i PI1 PI2 Mont i PI1 PI2 Mont i PI1 PI2MN Retail344,502,150.0 4 276,548,862.99 294,576,915.28(6,159,600.62)
  (3,605,330.19)
(3,605,330.19)
  (2,250,699.57)    338,342,549.42272,943,532.80292,326,215.71ND Retail26,111,083.45  20,754,551.00  21,560,120.76 (71,859.03)
(2,250,699.57)    338,342,549.42272,943,532.80292,326,215.71ND Retail26,111,083.45  20,754,551.00  21,560,120.76 (71,859.03)
      (137,632.77)
(137,632.77)
      (123,035.28)        26,039,224.42 20,616,918.23 21,437,085.48 SD Retail16,956,364.11  14,845,957.45  15,957,964.4 4 (162,627.66)
(123,035.28)        26,039,224.42 20,616,918.23 21,437,085.48 SD Retail16,956,364.11  14,845,957.45  15,957,964.4 4 (162,627.66)
      (20,779.11) 39,545.68 16,793,736.45 14,825,178.3 4 15,997,510.12 MN FERC8,798,085.58    6,752,100.02    6,308,838.23 (85,506.44) 141,254.15 (1.60)                8,712,579.1 4  6,893,354.17 6,308,836.63 WI FERC6,808,993.49    5,484,614.0 4    4,721,734.2 4  29,354.91        (1,170,067.11) 21,441.45 6,838,348.40 4,314,546.93 4,743,175.69 WI Retai l 62,931,476.36  49,102,816.9 4  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 Total466,108,153.03 373,488,902.4 4 396,331,229.46(7,588,184.60)
(20,779.11) 39,545.68 16,793,736.45 14,825,178.3 4 15,997,510.12 MN FERC8,798,085.58    6,752,100.02    6,308,838.23 (85,506.44) 141,254.15 (1.60)                8,712,579.1 4  6,893,354.17 6,308,836.63 WI FERC6,808,993.49    5,484,614.0 4    4,721,734.2 4  29,354.91        (1,170,067.11) 21,441.45 6,838,348.40 4,314,546.93 4,743,175.69 WI Retai l 62,931,476.36  49,102,816.9 4  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 Total466,108,153.03 373,488,902.4 4 396,331,229.46(7,588,184.60)
  (4,277,805.12)
(4,277,805.12)
  (2,706,934.10)    458,519,968.43369,211,097.32393,624,295.36 External Escro w MN Retail-                  37,884,536.45  48,390,281.7 4 -                  148,324.30 189,449.50        -                38,032,860.75 48,579,731.2 4 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 Retai l-                  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.2 4  63,856,741.62 725.76 193,316.37 246,104.75        802,816.59 50,169,543.61 64,102,846.37 Interna l-                457,309.00 793,585.00 Grand Total466,910,243.86 423,465,129.68 460,187,971.08(7,587,458.84)
(2,706,934.10)    458,519,968.43369,211,097.32393,624,295.36 External Escro w MN Retail-                  37,884,536.45  48,390,281.7 4 -                  148,324.30 189,449.50        -                38,032,860.75 48,579,731.2 4 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 Retai l-                  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.2 4  63,856,741.62 725.76 193,316.37 246,104.75        802,816.59 50,169,543.61 64,102,846.37 Interna l-                457,309.00 793,585.00 Grand Total466,910,243.86 423,465,129.68 460,187,971.08(7,587,458.84)
  (4,084,488.75)
(4,084,488.75)
  (2,460,829.35)    459,322,785.02419,837,949.93458,520,726.73 Book Value Market Adjust Market Value ENCLOSURE 8 Balances as of December 31, 2012 Excluded from NRC calculation External QualifiedMontiPI1PI2MontiPI1PI2MontiPI1PI2All UnitsRadiological363,508,519 244,454,46 0 290,786,33 2 24,391,80 0 17,035,991 21,777,00 7 387,900,32 0 261,490,451312,563,339961,954,11 0            Spent Fuel100,152,401 105,023,819 98,097,06 0  6,720,33 0  7,319,093  7,346,495 106,872,731 112,342,91 2105,443,555324,659,19 8            Site Restoration14,996,09 2  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,44 8                Total478,657,01 2 384,084,22 6 407,519,22 6 32,118,38 4 26,766,766 30,519,141 510,775,39 6 410,850,99 2 438,038,36 7 1,359,664,75 5        External EscrowMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological19,289,851 24,333,72 4  47,268,579  (5,573)        3,265        1,505        19,284,27 8  24,336,989 47,270,08 4 90,891,351 Spent Fuel5,314,66 2    10,454,38 4  15,946,10 2  (1,535)        1,403        508            5,313,126    10,455,786 15,946,61 0 31,715,52 2            Site Restoration795,779      3,444,779    3,029,336    (230)          462            96            795,549      3,445,241 3,029,43 2  7,270,22 2 Total25,400,291 38,232,88 7  66,244,01 7  (7,338)        5,129        2,109        25,392,953 38,238,016 66,246,126 129,877,095
(2,460,829.35)    459,322,785.02419,837,949.93458,520,726.73 Book Value Market Adjust Market Value ENCLOSURE 8 Balances as of December 31, 2012 Excluded from NRC calculation External QualifiedMontiPI1PI2MontiPI1PI2MontiPI1PI2All UnitsRadiological363,508,519 244,454,46 0 290,786,33 2 24,391,80 0 17,035,991 21,777,00 7 387,900,32 0 261,490,451312,563,339961,954,11 0            Spent Fuel100,152,401 105,023,819 98,097,06 0  6,720,33 0  7,319,093  7,346,495 106,872,731 112,342,91 2105,443,555324,659,19 8            Site Restoration14,996,09 2  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,44 8                Total478,657,01 2 384,084,22 6 407,519,22 6 32,118,38 4 26,766,766 30,519,141 510,775,39 6 410,850,99 2 438,038,36 7 1,359,664,75 5        External EscrowMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological19,289,851 24,333,72 4  47,268,579  (5,573)        3,265        1,505        19,284,27 8  24,336,989 47,270,08 4 90,891,351 Spent Fuel5,314,66 2    10,454,38 4  15,946,10 2  (1,535)        1,403        508            5,313,126    10,455,786 15,946,61 0 31,715,52 2            Site Restoration795,779      3,444,779    3,029,336    (230)          462            96            795,549      3,445,241 3,029,43 2  7,270,22 2 Total25,400,291 38,232,88 7  66,244,01 7  (7,338)        5,129        2,109        25,392,953 38,238,016 66,246,126 129,877,095


Grand Tota lMontiPI1PI2MontiPI1PI2PI1PI2Radiological382,798,37 0 268,788,185 338,054,911 24,386,22 8 17,039,256 21,778,51 2 407,184,59 8 285,827,44 0 359,833,42 3 1,052,845,46 0        Spent Fuel105,467,06 3 115,478,20 3 114,043,16 2 6,718,795 7,320,495  7,347,003 112,185,85 8 122,798,69 8121,390,165356,374,72 0            Site Restoration15,791,871  38,050,725 21,665,17 0  1,006,023  2,412,145  1,395,735 16,797,89 4  40,462,87 0 23,060,906 80,321,67 0                Total504,057,30 3 422,317,11 3 473,763,24 3 32,111,046 26,771,895 30,521,25 0 536,168,35 0 449,089,00 8 504,284,49 3 1,489,541,851 Book Value Market Adjustment Market Value ENCLOSURE 8 Balances as of December 31, 2012 External Qualified Mont i PI1 PI2 Mont i PI1 PI2 Mont i PI1 PI2MN Retail353,321,554.06 284,178,023.43 302,879,754.4023,916,799.88 19,710,266.6 4  22,434,385.5 4    377,238,353.9 4303,888,290.07325,314,139.9 4ND Retail27,089,209.7 4  21,456,891.8 4  22,106,093.51 1,714,772.75 1,397,148.5 4    1,806,683.08      28,803,982.49 22,854,040.38 23,912,776.59 SD Retail17,485,379.03  15,284,639.90  16,335,690.37 1,169,235.47 1,201,955.45 1,535,356.8 4      18,654,614.50 16,486,595.35 17,871,047.21 MN FERC9,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 FERC7,160,600.91    5,706,383.42    4,938,068.1 4  331,482.19 (983,144.15) 268,939.89        7,492,083.10 4,723,239.27 5,207,008.03 WI Retai l 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 Total478,657,011.92 384,084,226.53 407,519,225.6132,118,384.25 26,766,766.12 30,519,140.88    510,775,396.17410,850,992.65438,038,366.49 External Escro wMN Retail24,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.7 4 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)
Grand Tota lMontiPI1PI2MontiPI1PI2PI1PI2Radiological382,798,37 0 268,788,185 338,054,911 24,386,22 8 17,039,256 21,778,51 2 407,184,59 8 285,827,44 0 359,833,42 3 1,052,845,46 0        Spent Fuel105,467,06 3 115,478,20 3 114,043,16 2 6,718,795 7,320,495  7,347,003 112,185,85 8 122,798,69 8121,390,165356,374,72 0            Site Restoration15,791,871  38,050,725 21,665,17 0  1,006,023  2,412,145  1,395,735 16,797,89 4  40,462,87 0 23,060,906 80,321,67 0                Total504,057,30 3 422,317,11 3 473,763,24 3 32,111,046 26,771,895 30,521,25 0 536,168,35 0 449,089,00 8 504,284,49 3 1,489,541,851 Book Value Market Adjustment Market Value ENCLOSURE 8 Balances as of December 31, 2012 External Qualified Mont i PI1 PI2 Mont i PI1 PI2 Mont i PI1 PI2MN Retail353,321,554.06 284,178,023.43 302,879,754.4023,916,799.88 19,710,266.6 4  22,434,385.5 4    377,238,353.9 4303,888,290.07325,314,139.9 4ND Retail27,089,209.7 4  21,456,891.8 4  22,106,093.51 1,714,772.75 1,397,148.5 4    1,806,683.08      28,803,982.49 22,854,040.38 23,912,776.59 SD Retail17,485,379.03  15,284,639.90  16,335,690.37 1,169,235.47 1,201,955.45 1,535,356.8 4      18,654,614.50 16,486,595.35 17,871,047.21 MN FERC9,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 FERC7,160,600.91    5,706,383.42    4,938,068.1 4  331,482.19 (983,144.15) 268,939.89        7,492,083.10 4,723,239.27 5,207,008.03 WI Retai l 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 Total478,657,011.92 384,084,226.53 407,519,225.6132,118,384.25 26,766,766.12 30,519,140.88    510,775,396.17410,850,992.65438,038,366.49 External Escro wMN Retail24,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.7 4 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)
(2,527.51)
        (4,119.51) 36,787.07      1,958,471.25 3,192,113.36 WI Retai l-                  9,067,761.03    11,089,479.46 -
(4,119.51) 36,787.07      1,958,471.25 3,192,113.36 WI Retai l-                  9,067,761.03    11,089,479.46 -
911.06 1,114.08            -                9,068,672.09 11,090,593.5 4    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 Interna l-                -                -                Grand Total504,057,303.31 422,317,113.36 473,763,242.4732,111,046.25 26,771,895.5 4  30,521,249.49    536,168,349.56449,089,008.90504,284,491.96 Book Value Market Adjust Market Value}}
911.06 1,114.08            -                9,068,672.09 11,090,593.5 4    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 Interna l-                -                -                Grand Total504,057,303.31 422,317,113.36 473,763,242.4732,111,046.25 26,771,895.5 4  30,521,249.49    536,168,349.56449,089,008.90504,284,491.96 Book Value Market Adjust Market Value}}

Revision as of 22:09, 28 April 2019

Enclosures - Decommissioning Funding Status Reports
ML13084A050
Person / Time
Site: Monticello, Prairie Island  Xcel Energy icon.png
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)
v • d • e


Text

ENCLOSURES Enclosure Plant Title 1 Prairie Island Nuclear Generating Plant, Unit 1 (PI1)

Decommissioning Funding Status

Report 2 Prairie Island Nuclear Generating

Plant, Unit 2 (PI2)

Decommissioning Funding Status

Report 3 Monticello Nuclear Generating Plant (MNGP) Decommissioning Funding Status

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

- RADIOLOGICALOperationalPost-ShutdownPresentRecoveredRadiologicalRemainingEarningsEarningsValue toThroughDecommissioningLife (yrs)RateRateDecommission 12/31/2012 Accrual(9) (10) (10)(5) (11) (12)

EXTERNAL FUND Monticello17.755.35%4.82%

$1,204,831,884

$407,184,598 5,555,927 Prairie Island Unit 120.805.50%4.66%

879,842,710 285,827,440 0 Prairie Island Unit 221.805.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 Percent100.00% (c)

External Percent100.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)

A MOUNT TO RECOVER - RADIOLOGICAL Cost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6)

Monticello 3.63%Factors 2011100.0000%2.63%4.82%20302030$18,322,903$18,322,9031.9689 $36,075,9641.00000$36,075,964 2031 75,519,265 75,519,2652.0404 154,089,5080.95402147,004,473 2032 137,152,490 137,152,4902.1144 289,995,2250.91015263,939,154 2033 98,485,327 98,485,3272.1912 215,801,0480.86830187,380,050 2034 64,788,675 64,788,6752.2707 147,115,6430.82837121,866,185 2035 47,657,043 47,657,0432.3532 112,146,5530.7902888,627,178 2036 14,400,233 14,400,2332.4386 35,116,4070.7539426,475,664 2037 14,360,888 14,360,8882.5271 36,291,3990.7192726,103,315 2038 14,360,888 14,360,8882.6188 37,608,2930.6861925,806,434 2039 14,360,888 14,360,8882.7139 38,974,0130.6546425,513,948 2040 14,400,233 14,400,2332.8124 40,499,2140.6245425,293,379 2041 14,360,888 14,360,8882.9145 41,854,8070.5958224,937,931 2042 14,360,888 14,360,8883.0203 43,374,1890.5684224,654,756 2043 14,360,888 14,360,8883.1299 44,948,1420.5422824,374,479 2044 14,400,233 14,400,2333.2436 46,708,5940.5173524,164,691 2045 26,521,966 26,521,9663.3613 89,148,2850.4935644,000,028 2046 42,748,794 42,748,7943.4833 148,906,8760.4708670,114,291 2047 7,279,588 7,279,5883.6098 26,277,8560.4492111,804,276 2048 672,833 672,8333.7408 2,516,9330.428551,078,632 2049- 03.8766 00.408850 2050- 04.0173 00.390050 2051- 04.1631 00.372110 2052- 04.3143 00.355000 2053- 04.4709 00.338680 2054- 04.6332 00.323100 2055- 03.1338 00.308250 2056- 03.2162 00.294070 2057- 03.3008 00.280550 2058- 03.3876 00.267650 2059- 03.4767 00.255340 2060- 03.5681 00.243600 2061- 03.6620 00.232400 2062- 03.7583 00.221710 2063- 03.8571 00.211520 2064- 03.9586 00.201790 2065- 04.0627 00.192510 2066- 04.1695 00.183660 2067- 04.2792 00.175210 2068- 04.3917 00.167160 2069- 04.5072 00.159470 2070- 04.6258 00.152140 2071- 04.7474 00.145140 2072- 04.8723 00.138470 2073- 05.0004 00.132100 2074- 05.1320 00.126030 2075- 05.2669 00.120230 2076 2,068 2,0685.4054 11,1800.114701,282 2077 754,915 754,9155.5476 4,187,9690.10943458,289 2078 754,915 754,9155.6935 4,298,1110.10440448,723 2079 754,915 754,9155.8432 4,411,1220.09959439,304 2080 756,984 756,9845.9969 4,539,5550.09502431,349 2081 754,915 754,9156.1546 4,646,2020.09065421,178 2082 754,915 754,9156.3165 4,768,4230.08648412,373 2083 754,915 754,9156.4826 4,893,8140.08250403,740 2084 756,984 756,9846.6531 5,036,2880.07871396,406 2085 754,915 754,9156.8281 5,154,6380.07509387,062 2086 754,915 754,9157.0077 5,290,2200.07164378,991 2087 754,915 754,9157.1920 5,429,3510.06834371,042 2088 756,984 756,9847.3811 5,587,3720.06520364,297 2089 754,915 754,9157.5753 5,718,7100.06220355,704 2090 752,847 752,8477.7745 5,853,0100.05934347,318 2091- 07.9790 00.056610$659,089,927$659,089,927$1,657,274,914$1,204,831,884 ENCLOSURE 5 Levelized (beginning of year payment, mid year interest)

A MOUNT TO RECOVER - RADIOLOGICAL Cost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6)

Prairie Island Unit 1 3.63%Factors2011100.0000%2.63%4.66%2033203320,820,60320,820,6032.1912 45,622,1051.0000045,622,105 2034 65,863,76765,863,7672.2707 149,556,8560.95547142,897,089 2035 105,472,896105,472,8962.3532 248,198,8190.91293226,588,148 2036 80,683,30680,683,3062.4386 196,754,3090.87228171,624,849 2037 40,634,80840,634,8082.5271 102,688,2240.8334585,585,500 2038 5,090,3015,090,3012.6188 13,330,4790.7963410,615,594 2039 5,090,3015,090,3012.7139 13,814,5670.7608810,511,228 2040 5,104,2475,104,2472.8124 14,355,1830.7270010,436,218 2041 5,090,3015,090,3012.9145 14,835,6810.6946310,305,309 2042 5,090,3015,090,3013.0203 15,374,2350.6637010,203,880 2043 5,090,3015,090,3013.1299 15,932,1320.6341510,103,362 2044 5,104,2475,104,2473.2436 16,556,1350.6059210,031,693 2045 5,090,3015,090,3013.3613 17,110,0280.578949,905,679 2046 5,090,3015,090,3013.4833 17,731,0440.553169,808,104 2047 5,090,3015,090,3013.6098 18,374,9670.528539,711,721 2048 5,104,2475,104,2473.7408 19,093,9660.505009,642,453 2049 10,045,14810,045,1483.8766 38,941,0230.4825118,789,433 2050 28,250,32028,250,3204.0173 113,490,0090.4610352,322,299 2051 7,680,9067,680,9064.1631 31,976,3790.4405014,085,595 2052 716,179716,1794.3143 3,089,8120.420891,300,471 2053 336,565336,5654.4709 1,504,7490.40215605,135 2054 003.0535 00.384240 2055 003.1338 00.367130 2056 003.2162 00.350790 2057 003.3008 00.335170 2058 003.3876 00.320240 2059 003.4767 00.305990 2060 003.5681 00.292360 2061 003.6620 00.279340 2062 003.7583 00.266910 2063 003.8571 00.255020 2064 003.9586 00.243670 2065 004.0627 00.232820 2066 004.1695 00.222450 2067 004.2792 00.212550 2068 004.3917 00.203080 2069 004.5072 00.194040 2070- 04.6258 00.185400 2071- 04.7474 00.177150 2072- 04.8723 00.169260 2073- 05.0004 00.161720 2074- 05.1320 00.154520 2075- 05.2669 00.147640 2076- 05.4054 00.141070 2077 12,232,310 12,232,3105.5476 67,859,9630.134799,146,844 2078- 05.6935 00.128790$428,771,954$428,771,954$1,176,190,665$879,842,710 ENCLOSURE 5 Levelized (beginning of year payment, mid year interest)

A MOUNT TO RECOVER - RADIOLOGICAL Cost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6)

Prairie Island Unit 2 3.63%Factors2011100.0000%2.63%4.57%203420348,494,948 8,494,948 2.2707 19,289,477 1.0000019,289,477 2035 53,283,284 53,283,284 2.3532 125,386,223 0.95630119,906,845 2036 100,960,954 100,960,954 2.4386 246,203,383 0.91450225,152,994 2037 98,591,560 98,591,560 2.5271 249,150,731 0.87454217,892,281 2038 74,811,488 74,811,488 2.6188 195,916,324 0.83632163,848,740 2039 21,913,437 21,913,437 2.7139 59,470,876 0.7997747,563,023 2040 13,161,222 13,161,222 2.8124 37,014,621 0.7648228,309,522 2041 13,125,262 13,125,262 2.9145 38,253,577 0.7313927,978,284 2042 13,125,262 13,125,262 3.0203 39,642,230 0.6994327,726,965 2043 13,125,262 13,125,262 3.1299 41,080,759 0.6688627,477,276 2044 13,161,222 13,161,222 3.2436 42,689,740 0.6396327,305,638 2045 13,125,262 13,125,262 3.3613 44,117,944 0.6116826,986,064 2046 13,125,262 13,125,262 3.4833 45,719,226 0.5849426,743,004 2047 13,125,262 13,125,262 3.6098 47,379,572 0.5593826,503,185 2048 13,161,222 13,161,222 3.7408 49,233,499 0.5349326,336,476 2049 17,938,969 17,938,969 3.8766 69,542,206 0.5115635,575,011 2050 35,760,092 35,760,092 4.0173 143,659,019 0.4892070,277,992 2051 10,457,490 10,457,490 4.1631 43,535,579 0.4678220,366,814 2052 670,743 670,743 4.3143 2,893,788 0.447381,294,623 2053 315,213 315,213 4.4709 1,409,284 0.42782602,920 2054 0- 3.0535 - 0.409130 2055 0- 3.1338 - 0.391250 2056 0- 3.2162 - 0.374150 2057 0- 3.3008 - 0.357800 2058 0- 3.3876 - 0.342160 2059 0- 3.4767 - 0.327210 2060 0- 3.5681 - 0.312910 2061 0- 3.6620 - 0.299230 2062 0- 3.7583 - 0.286150 2063 0- 3.8571 - 0.273650 2064 0- 3.9586 - 0.261690 2065 0- 4.0627 - 0.250250 2066 0- 4.1695 - 0.239320 2067 0- 4.2792 - 0.228860 2068 0- 4.3917 - 0.218860 2069 0- 4.5072 - 0.209290 2070-

- 4.6258 - 0.200140 2071-

- 4.7474 - 0.191400 2072-

- 4.8723 - 0.183030 2073-

- 5.0004 - 0.175030 2074-

- 5.1320 - 0.167380 2075-

- 5.2669 - 0.160070 2076-

- 5.4054 - 0.153070 2077 10,796,730 10,796,730 5.5476 59,895,939 0.146388,767,568 2078-

- 5.6935 - 0.139990$552,230,148552,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

Levelized (beginning of year payment, mid year interest)

ANNUAL ACCRUAL

SUMMARY

OperationalPost-ShutdownPresentRecovered2013-2014RemainingEarningsEarningsValue toThroughDecommissioningLife (yrs)RateRateDecommission 12/31/2012 Accrual(9) (10) (10)(5) (11) (12)

EXTERNAL FUND Monticello17.755.35%4.82%

$554,561,447

$112,185,858 10,755,339 Prairie Island Unit 120.805.50%4.66%

378,003,189 122,798,698 471,837 Prairie Island Unit 221.805.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 Percent100.00% (c)

External Percent100.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 Levelized (beginning of year payment, mid year interest)

AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6)

Monticello 3.63%Factors 2011100.0000%2.63%4.82%20302030$28,351,388$28,351,3881.9689 $55,821,0491.00000$55,821,049 2031 2,427,740 2,427,7402.0404 4,953,5620.954024,725,797 2032 1,966,707 1,966,7072.1144 4,158,4050.910153,784,773 2033 1,855,097 1,855,0972.1912 4,064,8890.868303,529,543 2034 7,163,151 7,163,1512.2707 16,265,3670.8283713,473,742 2035 37,666,327 37,666,3272.3532 88,636,4000.7902870,047,574 2036 1,860,023 1,860,0232.4386 4,535,8530.753943,419,761 2037 1,855,098 1,855,0982.5271 4,688,0190.719273,371,951 2038 1,855,098 1,855,0982.6188 4,858,1310.686193,333,601 2039 1,855,098 1,855,0982.7139 5,034,5510.654643,295,819 2040 1,860,023 1,860,0232.8124 5,231,1290.624543,267,050 2041 1,855,098 1,855,0982.9145 5,406,6840.595823,221,410 2042 1,855,098 1,855,0983.0203 5,602,9530.568423,184,831 2043 1,855,098 1,855,0983.1299 5,806,2720.542283,148,625 2044 1,860,023 1,860,0233.2436 6,033,1710.517353,121,261 2045 40,146,932 40,146,9323.3613 134,945,8830.4935666,603,890 2046 705,105 705,1053.4833 2,456,0930.470861,156,476 2047 4,352,674 4,352,6743.6098 15,712,2810.449217,058,114 2048 7,628,121 7,628,1213.7408 28,535,2750.4285512,228,792 2049 5,668,528 5,668,5283.8766 21,974,6180.408858,984,322 2050 13,810,528 13,810,5284.0173 55,481,0360.3900521,640,378 2051 18,261,028 18,261,0284.1631 76,022,4880.3721128,288,728 2052 10,858,901 10,858,9014.3143 46,848,5570.3550016,631,238 2053 16,777,528 16,777,5284.4709 75,010,6520.3386825,404,608 2054 21,228,028 21,228,0284.6332 98,353,7020.3231031,778,081 2055 5,611,028 5,611,0283.1338 17,583,8410.308255,420,219 2056 5,626,401 5,626,4013.2162 18,095,6310.294075,321,382 2057 5,611,028 5,611,0283.3008 18,520,8830.280555,196,034 2058 5,611,028 5,611,0283.3876 19,007,9200.267655,087,470 2059 5,611,028 5,611,0283.4767 19,507,8630.255344,981,138 2060 5,626,401 5,626,4013.5681 20,075,5620.243604,890,407 2061 5,611,028 5,611,0283.6620 20,547,5860.232404,775,259 2062 5,611,028 5,611,0283.7583 21,087,9280.221714,675,405 2063 5,611,028 5,611,0283.8571 21,642,2980.211524,577,779 2064 5,626,401 5,626,4013.9586 22,272,6720.201794,494,402 2065 5,611,028 5,611,0284.0627 22,795,9250.192514,388,444 2066 5,611,028 5,611,0284.1695 23,395,1830.183664,296,759 2067 5,611,028 5,611,0284.2792 24,010,7130.175214,206,917 2068 5,626,401 5,626,4014.3917 24,709,4660.167164,130,434 2069 5,611,028 5,611,0284.5072 25,290,0280.159474,033,001 2070 5,611,028 5,611,0284.6258 25,955,4960.152143,948,869 2071 5,611,028 5,611,0284.7474 26,637,7970.145143,866,210 2072 5,626,401 5,626,4014.8723 27,413,5140.138473,795,949 2073 5,611,028 5,611,0285.0004 28,057,3870.132103,706,381 2074 5,611,028 5,611,0285.1320 28,795,7980.126033,629,134 2075 5,611,028 5,611,0285.2669 29,552,7260.120233,553,124 2076 5,626,941 5,626,9415.4054 30,415,8650.114703,488,700 2077 6,438,157 6,438,1575.5476 35,716,3180.109433,908,437 2078 7,698,557 7,698,5575.6935 43,831,7320.104404,576,033 2079 7,383,457 7,383,4575.8432 43,143,0140.099594,296,613 2080 7,399,369 7,399,3695.9969 44,373,2750.095024,216,349 2081 7,383,457 7,383,4576.1546 45,442,2220.090654,119,337 2082 7,698,557 7,698,5576.3165 48,627,9330.086484,205,344 2083 7,383,457 7,383,4576.4826 47,863,9960.082503,948,780 2084 7,399,369 7,399,3696.6531 49,228,7410.078713,874,794 2085 7,383,457 7,383,4576.8281 50,414,9800.075093,785,661 2086 7,698,557 7,698,5577.0077 53,949,1760.071643,864,919 2087 7,383,457 7,383,4577.1920 53,101,8200.068343,628,978 2088 9,699,369 9,699,3697.3811 71,592,0120.065204,667,799 2089 7,383,457 7,383,4577.5753 55,931,8990.062203,478,964 2090 6,447,544 6,447,5447.7745 50,126,4330.059342,974,503 2091 4,494,458 4,494,4587.9790 35,861,2780.056612,030,107$468,388,523$468,388,523$2,021,013,933$554,561,447 Levelized (beginning of year payment, mid year interest)

AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6)

Prairie Island Unit 1 3.63%Factors2011100.0000%2.63%4.66%20332033620,158620,1582.1912 1,358,8911.000001,358,891 2034 1,561,0881,561,0882.2707 3,544,7630.955473,386,915 2035 21,691,55121,691,5512.3532 51,044,5570.9129346,600,108 2036 5,056,6345,056,6342.4386 12,331,1080.8722810,756,179 2037 14,092,18814,092,1882.5271 35,612,3680.8334529,681,128 2038 1,258,1881,258,1882.6188 3,294,9420.796342,623,894 2039 7,675,1887,675,1882.7139 20,829,6920.7608815,848,896 2040 1,261,6351,261,6352.8124 3,548,2220.727002,579,558 2041 14,092,18814,092,1882.9145 41,071,6820.6946328,529,622 2042 1,258,1881,258,1883.0203 3,800,1050.663702,522,130 2043 14,092,18814,092,1883.1299 44,107,1390.6341527,970,542 2044 1,261,6351,261,6353.2436 4,092,2390.605922,479,570 2045 14,092,18814,092,1883.3613 47,368,0710.5789427,423,271 2046 1,258,1881,258,1883.4833 4,382,6460.553162,424,304 2047 14,092,18814,092,1883.6098 50,869,9800.5285326,886,310 2048 1,261,6351,261,6353.7408 4,719,5240.505002,383,360 2049 20,432,24620,432,2463.8766 79,207,6440.4825138,218,480 2050 542,119542,1194.0173 2,177,8550.461031,004,056 2051 2,821,6372,821,6374.1631 11,746,7590.440505,174,447 2052 4,453,5464,453,5464.3143 19,213,9330.420898,086,952 2053 4,045,1504,045,1504.4709 18,085,4620.402157,273,068 2054 3,848,0513,848,0513.0535 11,750,0240.384244,514,829 2055 3,532,9513,532,9513.1338 11,071,5620.367134,064,702 2056 4,013,9854,013,9853.2162 12,909,7800.350794,528,622 2057 3,532,9513,532,9513.3008 11,661,5640.335173,908,607 2058 3,375,4013,375,4013.3876 11,434,5080.320243,661,787 2059 3,690,5013,690,5013.4767 12,830,7650.305993,926,086 2060 3,541,3353,541,3353.5681 12,635,8390.292363,694,214 2061 3,690,5013,690,5013.6620 13,514,6140.279343,775,172 2062 3,690,5013,690,5013.7583 13,870,0100.266913,702,044 2063 3,690,5013,690,5013.8571 14,234,6310.255023,630,116 2064 3,541,3353,541,3353.9586 14,018,7300.243673,415,944 2065 3,690,5013,690,5014.0627 14,993,3980.232823,490,763 2066 3,690,5013,690,5014.1695 15,387,5440.222453,422,959 2067 3,532,9513,532,9514.2792 15,118,2040.212553,213,374 2068 3,698,8853,698,8854.3917 16,244,3950.203083,298,912 2069 3,690,5013,690,5014.5072 16,633,8260.194043,227,628 2070 3,532,951 3,532,9514.6258 16,342,7240.185403,029,941 2071 3,690,501 3,690,5014.7474 17,520,2840.177153,103,718 2072 3,698,885 3,698,8854.8723 18,022,0790.169263,050,417 2073 3,532,951 3,532,9515.0004 17,666,1680.161722,856,973 2074 3,690,501 3,690,5015.1320 18,939,6510.154522,926,555 2075 4,840,501 4,840,5015.2669 25,494,4340.147643,763,998 2076 3,541,335 3,541,3355.4054 19,142,3340.141072,700,409 2077 3,533,595 3,533,5955.5476 19,602,9740.134792,642,285 2078 1,693,045 1,693,0455.6935 9,639,3520.128791,241,452$237,125,344$237,125,344$843,086,976$378,003,189 Levelized (beginning of year payment, mid year interest)

AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6)

Prairie Island Unit 2 3.63%Factors2011100.0000%2.63%4.57%20342034273,725 273,725 2.2707 621,548 1.00000621,548 2035 21,962,089 21,962,089 2.3532 51,681,187 0.9563049,422,719 2036 5,156,219 5,156,219 2.4386 12,573,955 0.9145011,498,882 2037 14,092,188 14,092,188 2.5271 35,612,369 0.8745431,144,441 2038 1,258,188 1,258,188 2.6188 3,294,944 0.836322,755,628 2039 7,675,188 7,675,188 2.7139 20,829,694 0.7997716,658,964 2040 1,261,635 1,261,635 2.8124 3,548,224 0.764822,713,752 2041 14,092,188 14,092,188 2.9145 41,071,683 0.7313930,039,418 2042 1,258,188 1,258,188 3.0203 3,800,106 0.699432,657,908 2043 14,092,188 14,092,188 3.1299 44,107,140 0.6688629,501,502 2044 1,261,635 1,261,635 3.2436 4,092,241 0.639632,617,520 2045 14,092,188 14,092,188 3.3613 47,368,073 0.6116828,974,103 2046 1,258,188 1,258,188 3.4833 4,382,647 0.584942,563,586 2047 14,092,188 14,092,188 3.6098 50,869,982 0.5593828,455,650 2048 1,261,635 1,261,635 3.7408 4,719,526 0.534932,524,616 2049 20,432,246 20,432,246 3.8766 79,207,646 0.5115640,519,463 2050 542,119 542,119 4.0173 2,177,855 0.489201,065,406 2051 2,821,637 2,821,637 4.1631 11,746,759 0.467825,495,369 2052 4,453,546 4,453,546 4.3143 19,213,933 0.447388,595,929 2053 4,045,150 4,045,150 4.4709 18,085,462 0.427827,737,322 2054 3,848,051 3,848,051 3.0535 11,750,024 0.409134,807,287 2055 3,532,951 3,532,951 3.1338 11,071,562 0.391254,331,749 2056 4,013,985 4,013,985 3.2162 12,909,780 0.374154,830,194 2057 3,532,951 3,532,951 3.3008 11,661,564 0.357804,172,508 2058 3,375,401 3,375,401 3.3876 11,434,508 0.342163,912,431 2059 3,690,501 3,690,501 3.4767 12,830,765 0.327214,198,354 2060 3,541,335 3,541,335 3.5681 12,635,839 0.312913,953,880 2061 3,690,501 3,690,501 3.6620 13,514,614 0.299234,043,978 2062 3,690,501 3,690,501 3.7583 13,870,010 0.286153,968,903 2063 3,690,501 3,690,501 3.8571 14,234,631 0.273653,895,307 2064 3,541,335 3,541,335 3.9586 14,018,730 0.261693,668,561 2065 3,690,501 3,690,501 4.0627 14,993,398 0.250253,752,098 2066 3,690,501 3,690,501 4.1695 15,387,544 0.239323,682,547 2067 3,532,951 3,532,951 4.2792 15,118,204 0.228863,459,952 2068 3,698,885 3,698,885 4.3917 16,244,395 0.218863,555,248 2069 3,690,501 3,690,501 4.5072 16,633,826 0.209293,481,293 2070 3,532,951 3,532,951 4.6258 16,342,724 0.200143,270,833 2071 3,690,501 3,690,501 4.7474 17,520,284 0.191403,353,382 2072 3,698,885 3,698,885 4.8723 18,022,079 0.183033,298,581 2073 3,532,951 3,532,951 5.0004 17,666,168 0.175033,092,109 2074 3,690,501 3,690,501 5.1320 18,939,651 0.167383,170,119 2075 4,840,501 4,840,501 5.2669 25,494,434 0.160074,080,894 2076 3,541,335 3,541,335 5.4054 19,142,334 0.153072,930,117 2077 3,533,595 3,533,595 5.5476 19,602,974 0.146382,869,483 2078 1,693,045 1,693,045 5.6935 9,639,352 0.139991,349,413$235,587,951235,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

Levelized (beginning of year payment, mid year interest)

ANNUAL ACCRUAL

SUMMARY

OperationalPost-ShutdownPresentRecovered2013-2014RemainingEarningsEarningsValue toThroughDecommissioningLife (yrs)RateRateDecommission 12/31/2012 Accrual(9) (10) (10)(5) (11) (12)

EXTERNAL FUND Monticello17.755.35%4.82%

$53,400,416

$16,797,894 2,055,528 Prairie Island Unit 120.805.50%4.66%

65,190,882 40,462,870 471,837 Prairie Island Unit 221.805.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 Percent100.00% (c)

External Percent100.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 Levelized (beginning of year payment, mid year interest)

AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6)

Monticello 3.63%Factors 2011100.0000%2.63%4.82%20302030$142,203$142,2031.9689 $279,9831.00000$279,983 2031 548,003 548,0032.0404 1,118,1450.954021,066,733 2032 319,299 319,2992.1144 675,1270.91015614,467 2033 97,261 97,2612.1912 213,1190.86830185,051 2034 4,000 4,0002.2707 9,0840.828377,525 2035 2,641 2,6412.3532 6,2160.790284,912 2036- 02.4386 00.753940 2037- 02.5271 00.719270 2038- 02.6188 00.686190 2039- 02.7139 00.654640 2040- 02.8124 00.624540 2041- 02.9145 00.595820 2042- 03.0203 00.568420 2043- 03.1299 00.542280 2044- 03.2436 00.517350 2045- 03.3613 00.493560 2046- 03.4833 00.470860 2047 14,766,846 14,766,8463.6098 53,305,3600.4492123,945,301 2048 17,027,077 17,027,0773.7408 63,694,8910.4285527,296,445 2049- 03.8766 00.408850 2050- 04.0173 00.390050 2051- 04.1631 00.372110 2052- 04.3143 00.355000 2053- 04.4709 00.338680 2054- 04.6332 00.323100 2055- 03.1338 00.308250 2056- 03.2162 00.294070 2057- 03.3008 00.280550 2058- 03.3876 00.267650 2059- 03.4767 00.255340 2060- 03.5681 00.243600 2061- 03.6620 00.232400 2062- 03.7583 00.221710 2063- 03.8571 00.211520 2064- 03.9586 00.201790 2065- 04.0627 00.192510 2066- 04.1695 00.183660 2067- 04.2792 00.175210 2068- 04.3917 00.167160 2069- 04.5072 00.159470 2070- 04.6258 00.152140 2071- 04.7474 00.145140 2072- 04.8723 00.138470 2073- 05.0004 00.132100 2074- 05.1320 00.126030 2075- 05.2669 00.120230 2076- 05.4054 00.114700 2077- 05.5476 00.109430 2078- 05.6935 00.104400 2079- 05.8432 00.099590 2080- 05.9969 00.095020 2081- 06.1546 00.090650 2082- 06.3165 00.086480 2083- 06.4826 00.082500 2084- 06.6531 00.078710 2085- 06.8281 00.075090 2086- 07.0077 00.071640 2087- 07.1920 00.068340 2088- 07.3811 00.065200 2089- 07.5753 00.062200 2090- 07.7745 00.059340 2091- 07.9790 00.056610$32,907,331$32,907,331$119,301,923$53,400,416 Levelized (beginning of year payment, mid year interest)

AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6)

Prairie Island Unit 1 3.63%Factors2011100.0000%2.63%4.66%20332033193,306193,3062.1912 423,5721.00000423,572 2034 823,827823,8272.2707 1,870,6640.955471,787,364 2035 1,542,8791,542,8792.3532 3,630,7030.912933,314,577 2036 1,789,9431,789,9432.4386 4,364,9540.872283,807,462 2037 1,357,1751,357,1752.5271 3,429,7160.833452,858,497 2038 002.6188 00.796340 2039 002.7139 00.760880 2040 002.8124 00.727000 2041 002.9145 00.694630 2042 003.0203 00.663700 2043 003.1299 00.634150 2044 003.2436 00.605920 2045 003.3613 00.578940 2046 003.4833 00.553160 2047 003.6098 00.528530 2048 003.7408 00.505000 2049 003.8766 00.482510 2050 004.0173 00.461030 2051 8,892,0238,892,0234.1631 37,018,3820.4405016,306,597 2052 13,790,17213,790,1724.3143 59,494,9370.4208925,040,824 2053 6,480,6276,480,6274.4709 28,974,2360.4021511,651,989 2054 003.0535 00.384240 2055 003.1338 00.367130 2056 003.2162 00.350790 2057 003.3008 00.335170 2058 003.3876 00.320240 2059 003.4767 00.305990 2060 003.5681 00.292360 2061 003.6620 00.279340 2062 003.7583 00.266910 2063 003.8571 00.255020 2064 003.9586 00.243670 2065 004.0627 00.232820 2066 004.1695 00.222450 2067 004.2792 00.212550 2068 004.3917 00.203080 2069 004.5072 00.194040 2070- 04.6258 00.185400 2071- 04.7474 00.177150 2072- 04.8723 00.169260 2073- 05.0004 00.161720 2074- 05.1320 00.154520 2075- 05.2669 00.147640 2076- 05.4054 00.141070 2077- 05.5476 00.134790 2078- 05.6935 00.128790$34,869,951$34,869,951$139,207,164$65,190,882 Levelized (beginning of year payment, mid year interest)

AMOUNT TO RECOVERCost JurisdictionalJurisdictionalPresentEstimate Cost inEscalationCost inDiscountValue toNominal $sNominal $sFactorFuture $'sFactorDecommission(1) (2) (3)(4) (5) (6)

Prairie Island Unit 2 3.63%Factors2011100.0000%2.63%4.57%2034203436,517 36,517 2.2707 82,920 1.0000082,920 2035 271,970 271,970 2.3532 640,000 0.95630612,032 2036 1,476,032 1,476,032 2.4386 3,599,453 0.914503,291,699 2037 1,860,849 1,860,849 2.5271 4,702,552 0.874544,112,570 2038 1,776,026 1,776,026 2.6188 4,651,057 0.836323,889,772 2039 253,023 253,023 2.7139 686,679 0.79977549,185 2040 0- 2.8124 - 0.764820 2041 0- 2.9145 - 0.731390 2042 0- 3.0203 - 0.699430 2043 0- 3.1299 - 0.668860 2044 0- 3.2436 - 0.639630 2045 0- 3.3613 - 0.611680 2046 0- 3.4833 - 0.584940 2047 0- 3.6098 - 0.559380 2048 0- 3.7408 - 0.534930 2049 0- 3.8766 - 0.511560 2050 0- 4.0173 - 0.489200 2051 12,023,581 12,023,581 4.1631 50,055,371 0.4678223,416,904 2052 18,646,740 18,646,740 4.3143 80,447,632 0.4473835,990,662 2053 8,762,949 8,762,949 4.4709 39,178,269 0.4278216,761,247 2054 0- 3.0535 - 0.409130 2055 0- 3.1338 - 0.391250 2056 0- 3.2162 - 0.374150 2057 0- 3.3008 - 0.357800 2058 0- 3.3876 - 0.342160 2059 0- 3.4767 - 0.327210 2060 0- 3.5681 - 0.312910 2061 0- 3.6620 - 0.299230 2062 0- 3.7583 - 0.286150 2063 0- 3.8571 - 0.273650 2064 0- 3.9586 - 0.261690 2065 0- 4.0627 - 0.250250 2066 0- 4.1695 - 0.239320 2067 0- 4.2792 - 0.228860 2068 0- 4.3917 - 0.218860 2069 0- 4.5072 - 0.209290 2070-

- 4.6258 - 0.200140 2071-

- 4.7474 - 0.191400 2072-

- 4.8723 - 0.183030 2073-

- 5.0004 - 0.175030 2074-

- 5.1320 - 0.167380 2075-

- 5.2669 - 0.160070 2076-

- 5.4054 - 0.153070 2077-

- 5.5476 - 0.146380 2078-

- 5.6935 - 0.139990$45,107,68945,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 Balances as of December 31, 2011 Excluded from NRC calculation External Qualifie dMontiPI1PI2MontiPI1PI2MontiPI1PI2All UnitsRadiological353,978,48 6 237,710,95 4 282,803,11 0(5,762,727) (2,722,654) (1,931,539) 348,215,75 9 234,988,30 0280,871,571864,075,63 0 Spent Fuel97,526,72 4 102,126,63 9 95,403,91 2 (1,587,723)

(1,169,721) (651,607) 95,939,001 100,956,91 8 94,752,305 291,648,22 4 Site Restoratio n 14,602,94 2 33,651,309 18,124,20 8 (237,734)

(385,430) (123,788) 14,365,20 8 33,265,879 18,000,42 0 65,631,50 7 Total466,108,15 3 373,488,90 2 396,331,23 0(7,588,185) (4,277,805) (2,706,934) 458,519,96 8 369,211,09 7 393,624,29 6 1,221,355,361 External EscrowMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological609,135 31,807,89 7 45,565,13 3 551 123,038 175,609 609,686 31,930,93 6 45,740,74 2 78,281,36 4 Spent Fuel167,826 13,665,47 7 15,371,44 3 152 52,860 59,242 167,978 13,718,33 8 15,430,685 29,317,001 Site Restoratio n25,129 4,502,853 2,920,166 23 17,418 11,25 4 25,152 4,520,27 0 2,931,42 0 7,476,84 2 Total802,091 49,976,22 7 63,856,74 2 726 193,316 246,105 802,817 50,169,54 4 64,102,84 6 115,075,20 7 InternalMontiPI1PI2 Radiological- 291,059 566,265 857,32 4 Spent Fuel- 125,046 191,030 316,076 Site Restoratio n- 41,203 36,291 77,49 4 Total- 457,309 793,585 1,250,89 4 Grand TotalMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological354,587,62 2 269,518,85 2 328,368,24 3(5,762,176) (2,599,616) (1,755,931) 348,825,44 6 267,210,295327,178,57 7 943,214,31 7 Spent Fuel97,694,551 115,792,11 6 110,775,355(1,587,571)

(1,116,861) (592,365) 96,106,979 114,800,30 2 110,374,02 0 321,281,301 Site Restoratio n14,628,071 38,154,161 21,044,37 4 (237,711)

(368,012) (112,534) 14,390,36 0 37,827,35 3 20,968,131 73,185,84 4 Total466,910,24 4 423,465,12 9 460,187,97 2(7,587,459) (4,084,489) (2,460,829) 459,322,785 419,837,94 9 458,520,72 7 1,337,681,46 2 Book Value Market Adjustment Market Value ENCLOSURE 8 Balances as of December 31, 2011 External Qualified Mont i PI1 PI2 Mont i PI1 PI2 Mont i PI1 PI2MN Retail344,502,150.0 4 276,548,862.99 294,576,915.28(6,159,600.62)

(3,605,330.19)

(2,250,699.57) 338,342,549.42272,943,532.80292,326,215.71ND Retail26,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 Retail16,956,364.11 14,845,957.45 15,957,964.4 4 (162,627.66)

(20,779.11) 39,545.68 16,793,736.45 14,825,178.3 4 15,997,510.12 MN FERC8,798,085.58 6,752,100.02 6,308,838.23 (85,506.44) 141,254.15 (1.60) 8,712,579.1 4 6,893,354.17 6,308,836.63 WI FERC6,808,993.49 5,484,614.0 4 4,721,734.2 4 29,354.91 (1,170,067.11) 21,441.45 6,838,348.40 4,314,546.93 4,743,175.69 WI Retai l 62,931,476.36 49,102,816.9 4 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 Total466,108,153.03 373,488,902.4 4 396,331,229.46(7,588,184.60)

(4,277,805.12)

(2,706,934.10) 458,519,968.43369,211,097.32393,624,295.36 External Escro w MN Retail- 37,884,536.45 48,390,281.7 4 - 148,324.30 189,449.50 - 38,032,860.75 48,579,731.2 4 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 Retai l- 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.2 4 63,856,741.62 725.76 193,316.37 246,104.75 802,816.59 50,169,543.61 64,102,846.37 Interna l- 457,309.00 793,585.00 Grand Total466,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.02419,837,949.93458,520,726.73 Book Value Market Adjust Market Value ENCLOSURE 8 Balances as of December 31, 2012 Excluded from NRC calculation External QualifiedMontiPI1PI2MontiPI1PI2MontiPI1PI2All UnitsRadiological363,508,519 244,454,46 0 290,786,33 2 24,391,80 0 17,035,991 21,777,00 7 387,900,32 0 261,490,451312,563,339961,954,11 0 Spent Fuel100,152,401 105,023,819 98,097,06 0 6,720,33 0 7,319,093 7,346,495 106,872,731 112,342,91 2105,443,555324,659,19 8 Site Restoration14,996,09 2 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,44 8 Total478,657,01 2 384,084,22 6 407,519,22 6 32,118,38 4 26,766,766 30,519,141 510,775,39 6 410,850,99 2 438,038,36 7 1,359,664,75 5 External EscrowMontiPI1PI2MontiPI1PI2MontiPI1PI2Radiological19,289,851 24,333,72 4 47,268,579 (5,573) 3,265 1,505 19,284,27 8 24,336,989 47,270,08 4 90,891,351 Spent Fuel5,314,66 2 10,454,38 4 15,946,10 2 (1,535) 1,403 508 5,313,126 10,455,786 15,946,61 0 31,715,52 2 Site Restoration795,779 3,444,779 3,029,336 (230) 462 96 795,549 3,445,241 3,029,43 2 7,270,22 2 Total25,400,291 38,232,88 7 66,244,01 7 (7,338) 5,129 2,109 25,392,953 38,238,016 66,246,126 129,877,095

Grand Tota lMontiPI1PI2MontiPI1PI2PI1PI2Radiological382,798,37 0 268,788,185 338,054,911 24,386,22 8 17,039,256 21,778,51 2 407,184,59 8 285,827,44 0 359,833,42 3 1,052,845,46 0 Spent Fuel105,467,06 3 115,478,20 3 114,043,16 2 6,718,795 7,320,495 7,347,003 112,185,85 8 122,798,69 8121,390,165356,374,72 0 Site Restoration15,791,871 38,050,725 21,665,17 0 1,006,023 2,412,145 1,395,735 16,797,89 4 40,462,87 0 23,060,906 80,321,67 0 Total504,057,30 3 422,317,11 3 473,763,24 3 32,111,046 26,771,895 30,521,25 0 536,168,35 0 449,089,00 8 504,284,49 3 1,489,541,851 Book Value Market Adjustment Market Value ENCLOSURE 8 Balances as of December 31, 2012 External Qualified Mont i PI1 PI2 Mont i PI1 PI2 Mont i PI1 PI2MN Retail353,321,554.06 284,178,023.43 302,879,754.4023,916,799.88 19,710,266.6 4 22,434,385.5 4 377,238,353.9 4303,888,290.07325,314,139.9 4ND Retail27,089,209.7 4 21,456,891.8 4 22,106,093.51 1,714,772.75 1,397,148.5 4 1,806,683.08 28,803,982.49 22,854,040.38 23,912,776.59 SD Retail17,485,379.03 15,284,639.90 16,335,690.37 1,169,235.47 1,201,955.45 1,535,356.8 4 18,654,614.50 16,486,595.35 17,871,047.21 MN FERC9,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 FERC7,160,600.91 5,706,383.42 4,938,068.1 4 331,482.19 (983,144.15) 268,939.89 7,492,083.10 4,723,239.27 5,207,008.03 WI Retai l 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 Total478,657,011.92 384,084,226.53 407,519,225.6132,118,384.25 26,766,766.12 30,519,140.88 510,775,396.17410,850,992.65438,038,366.49 External Escro wMN Retail24,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.7 4 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 Retai l- 9,067,761.03 11,089,479.46 -

911.06 1,114.08 - 9,068,672.09 11,090,593.5 4 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 Interna l- - - Grand Total504,057,303.31 422,317,113.36 473,763,242.4732,111,046.25 26,771,895.5 4 30,521,249.49 536,168,349.56449,089,008.90504,284,491.96 Book Value Market Adjust Market Value

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