ML112370014

From kanterella
Revision as of 09:57, 29 June 2019 by StriderTol (talk | contribs) (Created page by program invented by StriderTol)
Jump to navigation Jump to search
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 1Signature: Aaron L. SzaboDate: 7/26/2011 Signature: Jo Ann SimpsonDate: 8/10/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton Pittiglio 1 2% Owned:Category:83.83%116.17%1 3 4variable 13.00%variable 1 Y N N Y N Y 5 6Any 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 BalancePost-RAIRates 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 Y 2Plant name:Harris (Shearon) Nuclear Power Plant50-400RAI Needed (Y/N)PUC Verified (Y/N)$41,023,543providedDocket 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.1millionThe total amount of dollars accumulated at the end of the appropriate year: (see below)

NAssumptions 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 EarningsAllowed through Decom (Y/N)Rate(s) of Other Factors$275,586,156Real Rate of ReturnPUC Verified (Y/N)North Carolina Municipal Power AgencyProgress Energy Carolinas, Inc.Licensee:$234,562,613Amount in Trust Fund:

Datasheet 2Signature: Aaron L. SzaboDate: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton PittiglioMonth:1210PWR 2900$100,520,000112.81.980.652.231.676191.4114.23.049250.082.00.132.2530.2212.28% Owned:Category83.83%116.17%1 2%35.81See Annuity SheetSee Annuity Sheet 2%7$1,472,125,193 NOShortfall:YESDoes Licensee Pass:Does Licensee Pass:YESTotal of Steps 1 thru 3:see annuity sheetNumber of Annual Payments:Accumulation:Step 2:Earnings Credit:$275,586,156Decom Period:See Total Step 2Total AnnuityReal Rate of Return per yearTotal Fund Balance:$275,586,156Total Step 1 + Step 2$1,370,256,445Total Annuity:Step 3:$41,023,543$234,562,613Amount in Trust Fund:$810,156,818Total Earnings:$560,099,627Real Rate of Return per yearLatest Month PxAmount of NRC Minimum/Site Specific:BWR/PWRMWthProgress Energy Carolinas, Inc.North Carolina Municipal Power Agency$72,268,426 FxSite Specific:Total Step 2:Years Left in LicenseN/AReal Rate of Return per yearDoes Licensee Pass:YESSee Total Step 22010Year:Harris (Shearon) Nuclear Power PlantDocket Number:Date of Operation:Latest Month Fx$1,370,256,445Years remaining after annuity Px50-4002431Termination of Operations:2046 1986$DayBase FxPlant name:Value of Annuity per year (amount/See Annuity Sheet)Licensee:$374,660,617 Bx Ex LxECIBase LxBase PxNRC Minimum:$446,929,043Trust Fund Balance:Step 1:$101,868,747Total Earnings for Decom:Decom Period:Total Earnings:Real Rate of Return per year Datasheet 2Signature: Aaron L. SzaboDate: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton PittiglioMonth:12102010Year:Harris (Shearon) Nuclear Power PlantDocket Number:Date of Operation:50-4002431Termination of Operations:2046DayPlant name:3.00%35.812.00%See Annuity SheetSee Annuity Sheet2.00%7Accumulation:Value of Annuity per yearNorth Carolina Qualified FundTotal Annuity:Number of Annual Payments:Step 5:$681,201,121If licensee is granted greater than 2% RRRReal Rate of Return Years Left in Trust Fund Balance:YES$112,564,506Total Step 5Total of Steps 4 thru 6:$1,626,691,701Does Licensee Pass:Total Earnings:N/A 0$1,514,127,194see annuity sheetSee Total Step 4Decom Period:Step 6:$1,514,127,194See Total Step 4Does Licensee Pass:Real Rate of Return per yearYESTotal Step 4 + Step 5Total Earnings for Decom:Decom Period:Total AnnuityTotal Earnings:Type of FundReal Rate of Return per yearShortfall:

NOReal Rate of Return per yearYears remaining after annuity$832,926,074Earnings Credit:Step 4:Does Licensee Pass:$142,471,204YESAll Others$133,114,952 Datasheet 2Signature: Aaron L. SzaboDate: 7/26/2011 Signature: Jo Ann SimpsonDate: 8/10/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton Pittiglio 10 24 2046YearAnnuity: 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,335Total:$810,156,818ANNUITYTotal AccumulationTermination of Operations:Real Rate of Return:

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