ML112370014: Difference between revisions

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


=Text=
=Text=
{{#Wiki_filter:Datasheet 1 Plant name:                             Harris (Shearon) Nuclear Power Plant                                                        Docket Number:                                   50-400 1      The minimum financial assurance (MFA) estimate pursuant to 10 CFR 50.75(b) & (c):                                                                           $447.1million Did the licensee identify the amount of estimated radiological funds? (Y/N)                                                                          Y 2                         The total amount of dollars accumulated at the end of the appropriate year: (see below)
{{#Wiki_filter:Datasheet 1 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 1
Licensee:                % Owned:       Category:                  Amount in Trust Fund:
2
Progress Energy Carolinas, Inc.        83.83%           1                           $234,562,613 North Carolina Municipal Power 16.17%           1                             $41,023,543 Agency Total Trust Fund Balance        $275,586,156 3       Schedule of the annual amounts remaining to be collected: (provided/none)                                                                                      provided 4       Assumptions used in determining rates of escalation in decommissioning costs, rates of earnings on decommissioning funds, and rates of other factors used in funding projections: (see below)
% Owned:
Post-RAI Rate of                                Rate(s) of                    PUC                                      RAI        PUC        Allowed          Rates Real Rate of                Allowed through Decom Return on        Escalation Rate          Other                      Verified                                  Needed    Verified    through      Determined Return                              (Y/N)
Category:
Earnings                                Factors                      (Y/N)                                    (Y/N)      (Y/N)    Decom (Y/N)      (Y/N) variable1           3.00%                           variable1         Y                     N                 N           Y           N               Y 5       Any contracts upon which the licensee is relying? (Y/N)                                                                                                            N 6       Any modifications to a licensee's method of providing decommissioning funding assurance? (Y/N)                                                                     N 7       Any material changes to trust agreements? (Y/N)                                                                                                                  Y2 If a change has occurred, the reviewer will document on this sheet that a change has occurred and identify the reviewer who will evaluate the change: (see below) 1 Rates provided are variable because the rates are not consistent throughout the funds of the licensee 2
83.83%
Effective 2/16/2010, Progress Energy Service Company, LLC engaged Watson Wyatt Investment Consulting, Inc., a Tower Watson company as its new investment advisor.
1 16.17%
1 3
4 variable1 3.00%
variable1 Y
N N
Y N
Y 5
6 Any modifications to a licensee's method of providing decommissioning funding assurance? (Y/N) 7 1 Rates provided are variable because the rates are not consistent throughout the funds of the licensee 2 Effective 2/16/2010, Progress Energy Service Company, LLC engaged Watson Wyatt Investment Consulting, Inc., a Tower Watson company as its new investment advisor.
Towers Watson Advises Progress Energy on its trust investments including its nuclear decommissioning trusts.
Towers Watson Advises Progress Energy on its trust investments including its nuclear decommissioning trusts.
Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson                                                                                                                                  Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/10/2011                                                                                                                                                          Formulas verified by: Clayton Pittiglio
Allowed through Decom (Y/N)
Total Trust Fund Balance Post-RAI Rates Determined (Y/N)
Any material changes to trust agreements? (Y/N)
If a change has occurred, the reviewer will document on this sheet that a change has occurred and identify the reviewer who will evaluate the change: (see below)
N Y2 Plant name:
Harris (Shearon) Nuclear Power Plant 50-400 RAI Needed (Y/N)
PUC Verified (Y/N)
$41,023,543 provided Docket Number:
Did the licensee identify the amount of estimated radiological funds? (Y/N)
The minimum financial assurance (MFA) estimate pursuant to 10 CFR 50.75(b) & (c):
Escalation Rate Y
$447.1million The total amount of dollars accumulated at the end of the appropriate year: (see below)
N Assumptions used in determining rates of escalation in decommissioning costs, rates of earnings on decommissioning funds, and rates of other factors used in funding projections: (see below)
Any contracts upon which the licensee is relying? (Y/N)
Schedule of the annual amounts remaining to be collected: (provided/none)
Rate of Return on Earnings Allowed through Decom (Y/N)
Rate(s) of Other Factors
$275,586,156 Real Rate of Return PUC Verified (Y/N)
North Carolina Municipal Power Agency Progress Energy Carolinas, Inc.
Licensee:
$234,562,613 Amount in Trust Fund:


Datasheet 2 Plant name:                       Harris (Shearon) Nuclear Power Plant                                        Docket Number:               50-400 Month:                 Day                      Year:
Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:
Date of Operation:                                     12                  31                      2010 Termination of Operations:                                    10                 24                      2046 Latest                  Latest BWR/PWR                MWth              1986$            ECI      Base Lx                      Lx          Px                Base Px    Fx            Base Fx      Ex                      Bx Month Px                Month Fx PWR                 2900         $100,520,000       112.8         1.98       0.65         2.23       1.676       191.4   114.2   3.049 250.0     82.0   0.13 2.253       0.22         12.28 NRC Minimum:                                $446,929,043                                Site Specific:
12 10 PWR 2900
Amount of NRC Minimum/Site Licensee:              % Owned:       Category                   Specific:                Amount in Trust Fund:
$100,520,000 112.8 1.98 0.65 2.23 1.676 191.4 114.2 3.049 250.0 82.0 0.13 2.253 0.22 12.28
Progress Energy Carolinas, Inc.      83.83%             1                   $374,660,617                    $234,562,613 North Carolina Municipal Power 16.17%             1                   $72,268,426                      $41,023,543 Agency Total Fund Balance:           $275,586,156 Step 1:
% Owned:
Category 83.83%
1 16.17%
1 2%
35.81 See Annuity Sheet See Annuity Sheet 2%
7
$1,472,125,193 NO Shortfall:
YES Does Licensee Pass:
Does Licensee Pass:
YES Total of Steps 1 thru 3:
see annuity sheet Number of Annual Payments:
Accumulation:
Step 2:
Earnings Credit:
Earnings Credit:
Real Rate of Return Years Left Trust Fund Balance:            per year       in License      Total Earnings:          Does Licensee Pass:
$275,586,156 Decom Period:
              $275,586,156                 2%            35.81          $560,099,627                  YES Step 2:
See Total Step 2 Total Annuity Real Rate of Return per year Total Fund Balance:
Accumulation:
$275,586,156 Total Step 1 + Step 2
Value of Annuity per year    Real Rate of Return   Number of Annual (amount/See Annuity Sheet)        per year              Payments:               Total Annuity:
$1,370,256,445 Total Annuity:
see annuity sheet        See Annuity Sheet                                See Total Step 2 Real Rate of Return Years remaining after Total Annuity              per year               annuity                Total Step 2:
Step 3:
See Total Step 2         See Annuity Sheet           N/A                  $810,156,818 Total Step 1 + Step 2      Does Licensee Pass:
$41,023,543
                                                                                      $1,370,256,445                  YES Step 3:
$234,562,613 Amount in Trust Fund:
$810,156,818 Total Earnings:
$560,099,627 Real Rate of Return per year Latest Month Px Amount of NRC Minimum/Site Specific:
BWR/PWR MWth Progress Energy Carolinas, Inc.
North Carolina Municipal Power Agency
$72,268,426 Fx Site Specific:
Total Step 2:
Years Left in License N/A Real Rate of Return per year Does Licensee Pass:
YES See Total Step 2 2010 Year:
Harris (Shearon) Nuclear Power Plant Docket Number:
Date of Operation:
Latest Month Fx
$1,370,256,445 Years remaining after annuity Px 50-400 24 31 Termination of Operations:
2046 1986$
Day Base Fx Plant name:
Value of Annuity per year (amount/See Annuity Sheet)
Licensee:
$374,660,617 Bx Ex Lx ECI Base Lx Base Px NRC Minimum:
$446,929,043 Trust Fund Balance:
Step 1:
$101,868,747 Total Earnings for Decom:
Decom Period:
Decom Period:
Real Rate of Return   Decom        Total Earnings for Total Earnings:            per year         Period:          Decom:
Total Earnings:
            $1,370,256,445                  2%              7            $101,868,747 Total of Steps 1 thru 3:    Does Licensee Pass:    Shortfall:
Real Rate of Return per year
                                                                                      $1,472,125,193                  YES                NO Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson                                                                                                                                                    Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/10/2011                                                                                                                                                                            Formulas verified by: Clayton Pittiglio


Datasheet 2 Plant name:                               Harris (Shearon) Nuclear Power Plant                                     Docket Number:            50-400 Month:                Day                    Year:
Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:
Date of Operation:                                           12                31                     2010 Termination of Operations:                                           10                24                      2046 If licensee is granted greater than 2% RRR Step 4:
12 10 2010 Year:
Earnings Credit:
Harris (Shearon) Nuclear Power Plant Docket Number:
Real Rate    Years Type of Fund                      Trust Fund Balance:        of Return    Left in        Total Earnings:      Does Licensee Pass:
Date of Operation:
North Carolina Qualified Fund                    $142,471,204            3.00%       35.81           $681,201,121                YES All Others                            $133,114,952            2.00%
50-400 24 31 Termination of Operations:
2046 Day Plant name:
3.00%
35.81 2.00%
See Annuity Sheet See Annuity Sheet 2.00%
7 Accumulation:
Value of Annuity per year North Carolina Qualified Fund Total Annuity:
Number of Annual Payments:
Step 5:
Step 5:
Accumulation:
$681,201,121 If licensee is granted greater than 2% RRR Real Rate of Return Years Left in Trust Fund Balance:
Real Rate of Return     Number of Annual Value of Annuity per year                per year            Payments:              Total Annuity:
YES
see annuity sheet              See Annuity Sheet              0                See Total Step 4 Real Rate of Return  Years remaining after Total Annuity                      per year              annuity                Total Step 5 See Total Step 4               See Annuity Sheet            N/A                 $832,926,074 Total Step 4 + Step 5      Does Licensee Pass:
$112,564,506 Total Step 5 Total of Steps 4 thru 6:
                                                                                            $1,514,127,194                 YES Step 6:
$1,626,691,701 Does Licensee Pass:
Total Earnings:
N/A 0
$1,514,127,194 see annuity sheet See Total Step 4 Decom Period:
Step 6:
$1,514,127,194 See Total Step 4 Does Licensee Pass:
Real Rate of Return per year YES Total Step 4 + Step 5 Total Earnings for Decom:
Decom Period:
Decom Period:
Real Rate of Return   Decom      Total Earnings for Total Earnings:                     per year       Period:          Decom:
Total Annuity Total Earnings:
            $1,514,127,194                        2.00%            7          $112,564,506 Total of Steps 4 thru 6:   Does Licensee Pass:      Shortfall:
Type of Fund Real Rate of Return per year Shortfall:
                                                                                            $1,626,691,701                YES                  NO Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson                                                                                                                                      Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/10/2011                                                                                                                                                              Formulas verified by: Clayton Pittiglio
NO Real Rate of Return per year Years remaining after annuity
$832,926,074 Earnings Credit:
Step 4:
Does Licensee Pass:
$142,471,204 YES All Others
$133,114,952


Datasheet 2 ANNUITY Termination of Operations:             10     24 2046 Real Rate      Total Year         Annuity:   of Return: Accumulation 2011         $17,538,171     2%     $35,645,600 2012         $16,706,579     2%     $33,289,632 2013         $16,706,579     2%     $32,636,894 2014         $16,706,579     2%     $31,996,955 2015         $16,706,579     2%     $31,369,563 2016         $16,706,579     2%     $30,754,474 2017         $16,706,579     2%     $30,151,445 2018         $14,885,194     2%     $26,337,523 2019         $14,885,194     2%     $25,821,101 2020         $14,885,194     2%     $25,314,805 2021         $14,885,194     2%     $24,818,436 2022         $14,885,194     2%     $24,331,800 2023         $14,885,194     2%     $23,854,706 2024         $14,885,194     2%     $23,386,967 2025         $14,885,194     2%     $22,928,399 2026         $14,885,194     2%     $22,478,822 2027         $14,885,194     2%     $22,038,061 2028         $14,885,194     2%     $21,605,942 2029         $14,885,194     2%     $21,182,296 2030         $14,885,194     2%     $20,766,957 2031         $14,885,194     2%     $20,359,762 2032         $14,885,194     2%     $19,960,551 2033         $14,885,194     2%     $19,569,168 2034         $14,885,194     2%     $19,185,458 2035         $14,885,194     2%     $18,809,273 2036         $14,885,194     2%     $18,440,464 2037         $14,885,194     2%     $18,078,886 2038         $14,885,194     2%     $17,724,398 2039         $14,885,194     2%     $17,376,861 2040         $14,885,194     2%     $17,036,138 2041         $14,885,194     2%     $16,702,096 2042         $14,885,194     2%     $16,374,604 2043         $14,885,194     2%     $16,053,533 2044         $14,885,194     2%     $15,738,758 2045         $14,885,194     2%     $15,430,155 2046         $12,404,328     2%     $12,606,335 Total: $810,156,818 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson                                                        Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/10/2011                                                                                Formulas verified by: Clayton Pittiglio
Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 10 24 2046 Year Annuity:
2011
$17,538,171 2%
$35,645,600 2012
$16,706,579 2%
$33,289,632 2013
$16,706,579 2%
$32,636,894 2014
$16,706,579 2%
$31,996,955 2015
$16,706,579 2%
$31,369,563 2016
$16,706,579 2%
$30,754,474 2017
$16,706,579 2%
$30,151,445 2018
$14,885,194 2%
$26,337,523 2019
$14,885,194 2%
$25,821,101 2020
$14,885,194 2%
$25,314,805 2021
$14,885,194 2%
$24,818,436 2022
$14,885,194 2%
$24,331,800 2023
$14,885,194 2%
$23,854,706 2024
$14,885,194 2%
$23,386,967 2025
$14,885,194 2%
$22,928,399 2026
$14,885,194 2%
$22,478,822 2027
$14,885,194 2%
$22,038,061 2028
$14,885,194 2%
$21,605,942 2029
$14,885,194 2%
$21,182,296 2030
$14,885,194 2%
$20,766,957 2031
$14,885,194 2%
$20,359,762 2032
$14,885,194 2%
$19,960,551 2033
$14,885,194 2%
$19,569,168 2034
$14,885,194 2%
$19,185,458 2035
$14,885,194 2%
$18,809,273 2036
$14,885,194 2%
$18,440,464 2037
$14,885,194 2%
$18,078,886 2038
$14,885,194 2%
$17,724,398 2039
$14,885,194 2%
$17,376,861 2040
$14,885,194 2%
$17,036,138 2041
$14,885,194 2%
$16,702,096 2042
$14,885,194 2%
$16,374,604 2043
$14,885,194 2%
$16,053,533 2044
$14,885,194 2%
$15,738,758 2045
$14,885,194 2%
$15,430,155 2046
$12,404,328 2%
$12,606,335 Total:
$810,156,818 ANNUITY Total Accumulation Termination of Operations:
Real Rate of Return:


Datasheet 2 ANNUITY Termination of Operations:                     10     24 2046 If licensee is granted greater than 2% RRR Real Rate      Total                                Real Rate      Total                            Real Rate        Total Year           Annuity:       of Return: Accumulation      Year       Annuity:     of Return: Accumulatio  Year     Annuity:     of Return: Accumulatio North Carolina Qualified                            North Carolina NonQualified                      South Carolina and Wholesale 2011          $8,433,298       3.00%       $24,309,293     2011     $4,370,492       2.00%     $8,882,842 2011     $2,902,789       2.00%       $5,899,797 2012         $8,433,298       3.00%       $23,601,255     2012     $4,370,492       2.00%       $8,708,669 2012     $2,902,789       2.00%       $5,784,115 2013         $8,433,298       3.00%       $22,913,840     2013     $4,370,492       2.00%       $8,537,911 2013     $2,902,789       2.00%       $5,670,701 2014         $8,433,298       3.00%       $22,246,446     2014     $4,370,492       2.00%       $8,370,501 2014     $2,902,789       2.00%       $5,559,511 2015         $8,433,298       3.00%       $21,598,492     2015     $4,370,492       2.00%       $8,206,373 2015     $2,902,789       2.00%       $5,450,501 2016         $8,433,298       3.00%       $20,969,409     2016     $4,370,492       2.00%       $8,045,464 2016     $2,902,789       2.00%       $5,343,628 2017         $8,433,298       3.00%       $20,358,650     2017     $4,370,492       2.00%       $7,887,710 2017     $2,902,789       2.00%       $5,238,851 2018         $8,433,298       3.00%       $19,765,679     2018     $3,063,777       2.00%       $5,420,977 2018     $2,388,119       2.00%       $4,225,483 2019         $8,433,298       3.00%       $19,189,980     2019     $3,063,777       2.00%       $5,314,684 2019     $2,388,119       2.00%       $4,142,631 2020         $8,433,298       3.00%       $18,631,049     2020     $3,063,777       2.00%       $5,210,474 2020     $2,388,119       2.00%       $4,061,403 2021         $8,433,298         3.00%     $18,088,397     2021     $3,063,777       2.00%       $5,108,308 2021     $2,388,119       2.00%       $3,981,767 2022         $8,433,298       3.00%       $17,561,550     2022     $3,063,777       2.00%       $5,008,145 2022     $2,388,119       2.00%       $3,903,693 2023         $8,433,298       3.00%       $17,050,049     2023     $3,063,777       2.00%       $4,909,946 2023     $2,388,119       2.00%       $3,827,150 2024         $8,433,298       3.00%       $16,553,445     2024     $3,063,777       2.00%       $4,813,673 2024     $2,388,119       2.00%       $3,752,108 2025         $8,433,298       3.00%       $16,071,306     2025     $3,063,777       2.00%       $4,719,287 2025     $2,388,119       2.00%       $3,678,538 2026         $8,433,298       3.00%       $15,603,210     2026     $3,063,777       2.00%       $4,626,752 2026     $2,388,119       2.00%       $3,606,409 2027                           3.00%           $0         2027     $11,497,075       2.00%     $17,021,830 2027     $2,388,119       2.00%       $3,535,695 2028                           3.00%           $0         2028     $11,497,075       2.00%     $16,688,069 2028     $2,388,119       2.00%       $3,466,368 2029                             3.00%           $0         2029     $11,497,075       2.00%     $16,360,852 2029     $2,388,119       2.00%       $3,398,400 2030                             3.00%           $0         2030     $11,497,075       2.00%     $16,040,051 2030     $2,388,119       2.00%       $3,331,765 2031                             3.00%           $0         2031     $11,497,075       2.00%     $15,725,540 2031     $2,388,119       2.00%       $3,266,436 2032                             3.00%           $0         2032     $11,497,075       2.00%     $15,417,196 2032     $2,388,119       2.00%       $3,202,388 2033                             3.00%           $0         2033     $11,497,075       2.00%     $15,114,898 2033     $2,388,119       2.00%       $3,139,596 2034                           3.00%           $0         2034     $11,497,075       2.00%     $14,818,527 2034     $2,388,119       2.00%       $3,078,036 2035                           3.00%           $0         2035     $11,497,075       2.00%     $14,527,968 2035     $2,388,119       2.00%       $3,017,682 2036                           3.00%           $0         2036     $11,497,075       2.00%     $14,243,106 2036     $2,388,119       2.00%       $2,958,512 2037                           3.00%           $0         2037     $11,497,075       2.00%     $13,963,829 2037     $2,388,119       2.00%       $2,900,502 2038                             3.00%           $0         2038     $11,497,075       2.00%     $13,690,029 2038     $2,388,119       2.00%       $2,843,629 2039                             3.00%           $0         2039     $11,497,075       2.00%     $13,421,597 2039     $2,388,119       2.00%       $2,787,872 2040                             3.00%           $0         2040     $11,497,075       2.00%     $13,158,428 2040     $2,388,119       2.00%       $2,733,208 2041                             3.00%           $0         2041     $11,497,075       2.00%     $12,900,420 2041     $2,388,119       2.00%       $2,679,615 2042                             3.00%           $0         2042     $11,497,075       2.00%     $12,647,470 2042     $2,388,119       2.00%       $2,627,074 2043                             3.00%           $0         2043     $11,497,075       2.00%     $12,399,481 2043     $2,388,119       2.00%       $2,575,563 2044                             3.00%           $0         2044     $11,497,075       2.00%     $12,156,354 2044     $2,388,119       2.00%       $2,525,061 2045                             3.00%           $0         2045     $11,497,075       2.00%     $11,917,994 2045     $2,388,119       2.00%       $2,475,550 2046                           3.00%           $0         2046     $9,580,896       2.00%       $9,736,923 2046     $1,990,099       2.00%       $2,022,508 Total:               $314,512,050               Total:                    $385,722,276             Total:                  $132,691,748 Total: $832,926,074 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson                                                                                              Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/10/2011                                                                                                                      Formulas verified by: Clayton Pittiglio}}
Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 10 24 2046 ANNUITY Termination of Operations:
Year Annuity:
Year Annuity:
Year Annuity:
2011
$8,433,298 3.00%
$24,309,293 2011
$4,370,492 2.00%
$8,882,842 2011
$2,902,789 2.00%
$5,899,797 2012
$8,433,298 3.00%
$23,601,255 2012
$4,370,492 2.00%
$8,708,669 2012
$2,902,789 2.00%
$5,784,115 2013
$8,433,298 3.00%
$22,913,840 2013
$4,370,492 2.00%
$8,537,911 2013
$2,902,789 2.00%
$5,670,701 2014
$8,433,298 3.00%
$22,246,446 2014
$4,370,492 2.00%
$8,370,501 2014
$2,902,789 2.00%
$5,559,511 2015
$8,433,298 3.00%
$21,598,492 2015
$4,370,492 2.00%
$8,206,373 2015
$2,902,789 2.00%
$5,450,501 2016
$8,433,298 3.00%
$20,969,409 2016
$4,370,492 2.00%
$8,045,464 2016
$2,902,789 2.00%
$5,343,628 2017
$8,433,298 3.00%
$20,358,650 2017
$4,370,492 2.00%
$7,887,710 2017
$2,902,789 2.00%
$5,238,851 2018
$8,433,298 3.00%
$19,765,679 2018
$3,063,777 2.00%
$5,420,977 2018
$2,388,119 2.00%
$4,225,483 2019
$8,433,298 3.00%
$19,189,980 2019
$3,063,777 2.00%
$5,314,684 2019
$2,388,119 2.00%
$4,142,631 2020
$8,433,298 3.00%
$18,631,049 2020
$3,063,777 2.00%
$5,210,474 2020
$2,388,119 2.00%
$4,061,403 2021
$8,433,298 3.00%
$18,088,397 2021
$3,063,777 2.00%
$5,108,308 2021
$2,388,119 2.00%
$3,981,767 2022
$8,433,298 3.00%
$17,561,550 2022
$3,063,777 2.00%
$5,008,145 2022
$2,388,119 2.00%
$3,903,693 2023
$8,433,298 3.00%
$17,050,049 2023
$3,063,777 2.00%
$4,909,946 2023
$2,388,119 2.00%
$3,827,150 2024
$8,433,298 3.00%
$16,553,445 2024
$3,063,777 2.00%
$4,813,673 2024
$2,388,119 2.00%
$3,752,108 2025
$8,433,298 3.00%
$16,071,306 2025
$3,063,777 2.00%
$4,719,287 2025
$2,388,119 2.00%
$3,678,538 2026
$8,433,298 3.00%
$15,603,210 2026
$3,063,777 2.00%
$4,626,752 2026
$2,388,119 2.00%
$3,606,409 2027 3.00%
$0 2027
$11,497,075 2.00%
$17,021,830 2027
$2,388,119 2.00%
$3,535,695 2028 3.00%
$0 2028
$11,497,075 2.00%
$16,688,069 2028
$2,388,119 2.00%
$3,466,368 2029 3.00%
$0 2029
$11,497,075 2.00%
$16,360,852 2029
$2,388,119 2.00%
$3,398,400 2030 3.00%
$0 2030
$11,497,075 2.00%
$16,040,051 2030
$2,388,119 2.00%
$3,331,765 2031 3.00%
$0 2031
$11,497,075 2.00%
$15,725,540 2031
$2,388,119 2.00%
$3,266,436 2032 3.00%
$0 2032
$11,497,075 2.00%
$15,417,196 2032
$2,388,119 2.00%
$3,202,388 2033 3.00%
$0 2033
$11,497,075 2.00%
$15,114,898 2033
$2,388,119 2.00%
$3,139,596 2034 3.00%
$0 2034
$11,497,075 2.00%
$14,818,527 2034
$2,388,119 2.00%
$3,078,036 2035 3.00%
$0 2035
$11,497,075 2.00%
$14,527,968 2035
$2,388,119 2.00%
$3,017,682 2036 3.00%
$0 2036
$11,497,075 2.00%
$14,243,106 2036
$2,388,119 2.00%
$2,958,512 2037 3.00%
$0 2037
$11,497,075 2.00%
$13,963,829 2037
$2,388,119 2.00%
$2,900,502 2038 3.00%
$0 2038
$11,497,075 2.00%
$13,690,029 2038
$2,388,119 2.00%
$2,843,629 2039 3.00%
$0 2039
$11,497,075 2.00%
$13,421,597 2039
$2,388,119 2.00%
$2,787,872 2040 3.00%
$0 2040
$11,497,075 2.00%
$13,158,428 2040
$2,388,119 2.00%
$2,733,208 2041 3.00%
$0 2041
$11,497,075 2.00%
$12,900,420 2041
$2,388,119 2.00%
$2,679,615 2042 3.00%
$0 2042
$11,497,075 2.00%
$12,647,470 2042
$2,388,119 2.00%
$2,627,074 2043 3.00%
$0 2043
$11,497,075 2.00%
$12,399,481 2043
$2,388,119 2.00%
$2,575,563 2044 3.00%
$0 2044
$11,497,075 2.00%
$12,156,354 2044
$2,388,119 2.00%
$2,525,061 2045 3.00%
$0 2045
$11,497,075 2.00%
$11,917,994 2045
$2,388,119 2.00%
$2,475,550 2046 3.00%
$0 2046
$9,580,896 2.00%
$9,736,923 2046
$1,990,099 2.00%
$2,022,508 Total:
Total:
Total:
Total:
$832,926,074
$314,512,050
$385,722,276
$132,691,748 Real Rate of Return:
Total Accumulatio Real Rate of Return:
Total Accumulatio North Carolina Qualified North Carolina NonQualified South Carolina and Wholesale If licensee is granted greater than 2% RRR Real Rate of Return:
Total Accumulation}}

Latest revision as of 02:23, 13 January 2025

2010 DFS Report Analysis for Harris (Shearon) Nuclear Power Plant
ML112370014
Person / Time
Site: Harris Duke Energy icon.png
Issue date: 11/14/2011
From: Szabo A
Division of Inspection and Regional Support
To:
Szabo, A L, NRR/DPR, 415-1985
References
Download: ML112370014 (5)


Text

Datasheet 1 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 1

2

% Owned:

Category:

83.83%

1 16.17%

1 3

4 variable1 3.00%

variable1 Y

N N

Y N

Y 5

6 Any modifications to a licensee's method of providing decommissioning funding assurance? (Y/N) 7 1 Rates provided are variable because the rates are not consistent throughout the funds of the licensee 2 Effective 2/16/2010, Progress Energy Service Company, LLC engaged Watson Wyatt Investment Consulting, Inc., a Tower Watson company as its new investment advisor.

Towers Watson Advises Progress Energy on its trust investments including its nuclear decommissioning trusts.

Allowed through Decom (Y/N)

Total Trust Fund Balance Post-RAI Rates Determined (Y/N)

Any material changes to trust agreements? (Y/N)

If a change has occurred, the reviewer will document on this sheet that a change has occurred and identify the reviewer who will evaluate the change: (see below)

N Y2 Plant name:

Harris (Shearon) Nuclear Power Plant 50-400 RAI Needed (Y/N)

PUC Verified (Y/N)

$41,023,543 provided Docket Number:

Did the licensee identify the amount of estimated radiological funds? (Y/N)

The minimum financial assurance (MFA) estimate pursuant to 10 CFR 50.75(b) & (c):

Escalation Rate Y

$447.1million The total amount of dollars accumulated at the end of the appropriate year: (see below)

N Assumptions used in determining rates of escalation in decommissioning costs, rates of earnings on decommissioning funds, and rates of other factors used in funding projections: (see below)

Any contracts upon which the licensee is relying? (Y/N)

Schedule of the annual amounts remaining to be collected: (provided/none)

Rate of Return on Earnings Allowed through Decom (Y/N)

Rate(s) of Other Factors

$275,586,156 Real Rate of Return PUC Verified (Y/N)

North Carolina Municipal Power Agency Progress Energy Carolinas, Inc.

Licensee:

$234,562,613 Amount in Trust Fund:

Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:

12 10 PWR 2900

$100,520,000 112.8 1.98 0.65 2.23 1.676 191.4 114.2 3.049 250.0 82.0 0.13 2.253 0.22 12.28

% Owned:

Category 83.83%

1 16.17%

1 2%

35.81 See Annuity Sheet See Annuity Sheet 2%

7

$1,472,125,193 NO Shortfall:

YES Does Licensee Pass:

Does Licensee Pass:

YES Total of Steps 1 thru 3:

see annuity sheet Number of Annual Payments:

Accumulation:

Step 2:

Earnings Credit:

$275,586,156 Decom Period:

See Total Step 2 Total Annuity Real Rate of Return per year Total Fund Balance:

$275,586,156 Total Step 1 + Step 2

$1,370,256,445 Total Annuity:

Step 3:

$41,023,543

$234,562,613 Amount in Trust Fund:

$810,156,818 Total Earnings:

$560,099,627 Real Rate of Return per year Latest Month Px Amount of NRC Minimum/Site Specific:

BWR/PWR MWth Progress Energy Carolinas, Inc.

North Carolina Municipal Power Agency

$72,268,426 Fx Site Specific:

Total Step 2:

Years Left in License N/A Real Rate of Return per year Does Licensee Pass:

YES See Total Step 2 2010 Year:

Harris (Shearon) Nuclear Power Plant Docket Number:

Date of Operation:

Latest Month Fx

$1,370,256,445 Years remaining after annuity Px 50-400 24 31 Termination of Operations:

2046 1986$

Day Base Fx Plant name:

Value of Annuity per year (amount/See Annuity Sheet)

Licensee:

$374,660,617 Bx Ex Lx ECI Base Lx Base Px NRC Minimum:

$446,929,043 Trust Fund Balance:

Step 1:

$101,868,747 Total Earnings for Decom:

Decom Period:

Total Earnings:

Real Rate of Return per year

Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:

12 10 2010 Year:

Harris (Shearon) Nuclear Power Plant Docket Number:

Date of Operation:

50-400 24 31 Termination of Operations:

2046 Day Plant name:

3.00%

35.81 2.00%

See Annuity Sheet See Annuity Sheet 2.00%

7 Accumulation:

Value of Annuity per year North Carolina Qualified Fund Total Annuity:

Number of Annual Payments:

Step 5:

$681,201,121 If licensee is granted greater than 2% RRR Real Rate of Return Years Left in Trust Fund Balance:

YES

$112,564,506 Total Step 5 Total of Steps 4 thru 6:

$1,626,691,701 Does Licensee Pass:

Total Earnings:

N/A 0

$1,514,127,194 see annuity sheet See Total Step 4 Decom Period:

Step 6:

$1,514,127,194 See Total Step 4 Does Licensee Pass:

Real Rate of Return per year YES Total Step 4 + Step 5 Total Earnings for Decom:

Decom Period:

Total Annuity Total Earnings:

Type of Fund Real Rate of Return per year Shortfall:

NO Real Rate of Return per year Years remaining after annuity

$832,926,074 Earnings Credit:

Step 4:

Does Licensee Pass:

$142,471,204 YES All Others

$133,114,952

Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 10 24 2046 Year Annuity:

2011

$17,538,171 2%

$35,645,600 2012

$16,706,579 2%

$33,289,632 2013

$16,706,579 2%

$32,636,894 2014

$16,706,579 2%

$31,996,955 2015

$16,706,579 2%

$31,369,563 2016

$16,706,579 2%

$30,754,474 2017

$16,706,579 2%

$30,151,445 2018

$14,885,194 2%

$26,337,523 2019

$14,885,194 2%

$25,821,101 2020

$14,885,194 2%

$25,314,805 2021

$14,885,194 2%

$24,818,436 2022

$14,885,194 2%

$24,331,800 2023

$14,885,194 2%

$23,854,706 2024

$14,885,194 2%

$23,386,967 2025

$14,885,194 2%

$22,928,399 2026

$14,885,194 2%

$22,478,822 2027

$14,885,194 2%

$22,038,061 2028

$14,885,194 2%

$21,605,942 2029

$14,885,194 2%

$21,182,296 2030

$14,885,194 2%

$20,766,957 2031

$14,885,194 2%

$20,359,762 2032

$14,885,194 2%

$19,960,551 2033

$14,885,194 2%

$19,569,168 2034

$14,885,194 2%

$19,185,458 2035

$14,885,194 2%

$18,809,273 2036

$14,885,194 2%

$18,440,464 2037

$14,885,194 2%

$18,078,886 2038

$14,885,194 2%

$17,724,398 2039

$14,885,194 2%

$17,376,861 2040

$14,885,194 2%

$17,036,138 2041

$14,885,194 2%

$16,702,096 2042

$14,885,194 2%

$16,374,604 2043

$14,885,194 2%

$16,053,533 2044

$14,885,194 2%

$15,738,758 2045

$14,885,194 2%

$15,430,155 2046

$12,404,328 2%

$12,606,335 Total:

$810,156,818 ANNUITY Total Accumulation Termination of Operations:

Real Rate of Return:

Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 10 24 2046 ANNUITY Termination of Operations:

Year Annuity:

Year Annuity:

Year Annuity:

2011

$8,433,298 3.00%

$24,309,293 2011

$4,370,492 2.00%

$8,882,842 2011

$2,902,789 2.00%

$5,899,797 2012

$8,433,298 3.00%

$23,601,255 2012

$4,370,492 2.00%

$8,708,669 2012

$2,902,789 2.00%

$5,784,115 2013

$8,433,298 3.00%

$22,913,840 2013

$4,370,492 2.00%

$8,537,911 2013

$2,902,789 2.00%

$5,670,701 2014

$8,433,298 3.00%

$22,246,446 2014

$4,370,492 2.00%

$8,370,501 2014

$2,902,789 2.00%

$5,559,511 2015

$8,433,298 3.00%

$21,598,492 2015

$4,370,492 2.00%

$8,206,373 2015

$2,902,789 2.00%

$5,450,501 2016

$8,433,298 3.00%

$20,969,409 2016

$4,370,492 2.00%

$8,045,464 2016

$2,902,789 2.00%

$5,343,628 2017

$8,433,298 3.00%

$20,358,650 2017

$4,370,492 2.00%

$7,887,710 2017

$2,902,789 2.00%

$5,238,851 2018

$8,433,298 3.00%

$19,765,679 2018

$3,063,777 2.00%

$5,420,977 2018

$2,388,119 2.00%

$4,225,483 2019

$8,433,298 3.00%

$19,189,980 2019

$3,063,777 2.00%

$5,314,684 2019

$2,388,119 2.00%

$4,142,631 2020

$8,433,298 3.00%

$18,631,049 2020

$3,063,777 2.00%

$5,210,474 2020

$2,388,119 2.00%

$4,061,403 2021

$8,433,298 3.00%

$18,088,397 2021

$3,063,777 2.00%

$5,108,308 2021

$2,388,119 2.00%

$3,981,767 2022

$8,433,298 3.00%

$17,561,550 2022

$3,063,777 2.00%

$5,008,145 2022

$2,388,119 2.00%

$3,903,693 2023

$8,433,298 3.00%

$17,050,049 2023

$3,063,777 2.00%

$4,909,946 2023

$2,388,119 2.00%

$3,827,150 2024

$8,433,298 3.00%

$16,553,445 2024

$3,063,777 2.00%

$4,813,673 2024

$2,388,119 2.00%

$3,752,108 2025

$8,433,298 3.00%

$16,071,306 2025

$3,063,777 2.00%

$4,719,287 2025

$2,388,119 2.00%

$3,678,538 2026

$8,433,298 3.00%

$15,603,210 2026

$3,063,777 2.00%

$4,626,752 2026

$2,388,119 2.00%

$3,606,409 2027 3.00%

$0 2027

$11,497,075 2.00%

$17,021,830 2027

$2,388,119 2.00%

$3,535,695 2028 3.00%

$0 2028

$11,497,075 2.00%

$16,688,069 2028

$2,388,119 2.00%

$3,466,368 2029 3.00%

$0 2029

$11,497,075 2.00%

$16,360,852 2029

$2,388,119 2.00%

$3,398,400 2030 3.00%

$0 2030

$11,497,075 2.00%

$16,040,051 2030

$2,388,119 2.00%

$3,331,765 2031 3.00%

$0 2031

$11,497,075 2.00%

$15,725,540 2031

$2,388,119 2.00%

$3,266,436 2032 3.00%

$0 2032

$11,497,075 2.00%

$15,417,196 2032

$2,388,119 2.00%

$3,202,388 2033 3.00%

$0 2033

$11,497,075 2.00%

$15,114,898 2033

$2,388,119 2.00%

$3,139,596 2034 3.00%

$0 2034

$11,497,075 2.00%

$14,818,527 2034

$2,388,119 2.00%

$3,078,036 2035 3.00%

$0 2035

$11,497,075 2.00%

$14,527,968 2035

$2,388,119 2.00%

$3,017,682 2036 3.00%

$0 2036

$11,497,075 2.00%

$14,243,106 2036

$2,388,119 2.00%

$2,958,512 2037 3.00%

$0 2037

$11,497,075 2.00%

$13,963,829 2037

$2,388,119 2.00%

$2,900,502 2038 3.00%

$0 2038

$11,497,075 2.00%

$13,690,029 2038

$2,388,119 2.00%

$2,843,629 2039 3.00%

$0 2039

$11,497,075 2.00%

$13,421,597 2039

$2,388,119 2.00%

$2,787,872 2040 3.00%

$0 2040

$11,497,075 2.00%

$13,158,428 2040

$2,388,119 2.00%

$2,733,208 2041 3.00%

$0 2041

$11,497,075 2.00%

$12,900,420 2041

$2,388,119 2.00%

$2,679,615 2042 3.00%

$0 2042

$11,497,075 2.00%

$12,647,470 2042

$2,388,119 2.00%

$2,627,074 2043 3.00%

$0 2043

$11,497,075 2.00%

$12,399,481 2043

$2,388,119 2.00%

$2,575,563 2044 3.00%

$0 2044

$11,497,075 2.00%

$12,156,354 2044

$2,388,119 2.00%

$2,525,061 2045 3.00%

$0 2045

$11,497,075 2.00%

$11,917,994 2045

$2,388,119 2.00%

$2,475,550 2046 3.00%

$0 2046

$9,580,896 2.00%

$9,736,923 2046

$1,990,099 2.00%

$2,022,508 Total:

Total:

Total:

Total:

$832,926,074

$314,512,050

$385,722,276

$132,691,748 Real Rate of Return:

Total Accumulatio Real Rate of Return:

Total Accumulatio North Carolina Qualified North Carolina NonQualified South Carolina and Wholesale If licensee is granted greater than 2% RRR Real Rate of Return:

Total Accumulation