ML112370138

2010 DFS Report Analysis for McGuire (William B.) Nuclear Station, Unit 1

ML112370138
Person / Time
Site:	McGuire
Issue date:	11/14/2011
From:	Szabo A Division of Inspection and Regional Support
To:
Szabo, A L, NRR/DPR, 415-1985
References
Download: ML112370138 (5)

Text

Datasheet 1Signature: Michael Purdie/JoAnn SimpsonDate: 07/20/2011Signature: Aaron L. SzaboDate: 8/18/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton Pittiglio 1 2% Owned:Category:100.00%1 3 4variable 14.00%variable 1 N N Y N Y 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 licensee(s) and/or years of operation/decommissionThe 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,388,309Real Rate of ReturnPUC Verified (Y/N)Duke Energy Carolinas, LLCLicensee:$275,388,309Amount in Trust Fund:Plant name:McGuire (William B.) Nuclear Station, Unit 150-369RAI Needed (Y/N)PUC Verified (Y/N)providedDocket 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$466,987,774Allowed 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 N Datasheet 2Signature: Michael Purdie/JoAnn SimpsonDate: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton PittiglioMonth:12 6PWR 3411$105,000,000112.81.980.652.231.676191.4114.23.049250.082.00.132.2530.2212.28% Owned:Category100.00%1 2%30.45See Annuity SheetSee Annuity Sheet 2%7 Bx Ex LxECIBase LxBase Px2010Year:McGuire (William B.) Nuclear Station, Unit 1Docket Number:Date of Operation:Latest Month Fx$790,193,833Years remaining after annuity Px50-3691231Termination of Operations:2041 1986$DayBase FxPlant name:Value of Annuity per year (amount/See Annuity Sheet)Licensee:$466,847,886NRC Minimum:$466,847,886Trust Fund Balance:Step 1: FxSite Specific:Total Step 2:Years Left in LicenseN/AReal Rate of Return per yearDoes Licensee Pass:YESSee Total Step 2$58,745,249Total Earnings for Decom:Decom Period:Total Earnings:Real Rate of Return per yearLatest Month PxAmount of NRC Minimum/Site Specific:BWR/PWRMWthDuke Energy Carolinas, LLCTotal Annuity:Step 3:$275,388,309Amount in Trust Fund:$286,921,498Total Earnings:$503,272,335Real Rate of Return per yearTotal of Steps 1 thru 3:See Annuity SheetNumber of Annual Payments:Accumulation:Step 2:Earnings Credit:$275,388,309Decom Period:See Total Step 2Total AnnuityReal Rate of Return per yearTotal Fund Balance:$275,388,309Total Step 1 + Step 2$790,193,833 NOShortfall:YESDoes Licensee Pass:Does Licensee Pass:YES$848,939,081 Datasheet 2Signature: Michael Purdie/JoAnn SimpsonDate: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton PittiglioMonth:12 62010Year:McGuire (William B.) Nuclear Station, Unit 1Docket Number:Date of Operation:50-3691231Termination of Operations:2041DayPlant name:2.00%30.45See Annuity SheetSee Annuity Sheet2.00%7Earnings Credit:Step 4:Shortfall:

NOReal Rate of Return per yearYears remaining after annuity$286,921,498Total AnnuityDoes Licensee Pass:Trust Fund Balance:Years Left in LicenseYES$58,745,249Total Step 5Total of Steps 4 thru 6:$848,939,081Does Licensee Pass:Total Earnings:N/A 0$790,193,833See Annuity SheetSee Total Step 4Decom Period:Step 6:$790,193,833See Total Step 4Does Licensee Pass:Real Rate of Return per yearYESTotal Step 4 + Step 5Total Earnings for Decom:Decom Period:Real Rate of Return per yearAccumulation:Value of Annuity per year$275,388,309Total Annuity:Number of Annual Payments:Step 5:Real Rate of Return per yearTotal Earnings:$503,272,335YESIf licensee is granted greater than 2% RRR Datasheet 2Signature: Michael Purdie/JoAnn SimpsonDate: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton Pittiglio 6 12 2041YearAnnuity: 2011$7,649,645 2%$13,980,174 2012$7,649,645 2%$13,706,053 2013$7,649,645 2%$13,437,307 2014$7,649,645 2%$13,173,830 2015$7,649,645 2%$12,915,520 2016$7,649,645 2%$12,662,275 2017$7,649,645 2%$12,413,995 2018$7,649,645 2%$12,170,583 2019$7,649,645 2%$11,931,944 2020$7,649,645 2%$11,697,984 2021$7,649,645 2%$11,468,612 2022$7,649,645 2%$11,243,737 2023$7,649,645 2%$11,023,272 2024$7,649,645 2%$10,807,129 2025$7,649,645 2%$10,595,225 2026$7,649,645 2%$10,387,475 2027$7,649,645 2%$10,183,799 2028$7,649,645 2%$9,984,117 2029$7,649,645 2%$9,788,350 2030$7,649,645 2%$9,596,422 2031$7,649,645 2%$9,408,256 2032$7,649,645 2%$9,223,781 2033$7,649,645 2%$9,042,922 2034$7,649,645 2%$8,865,610 2035$7,649,645 2%$8,691,775 2036$7,649,645 2%$8,521,348Total:$286,921,498ANNUITYTotal AccumulationTermination of Operations:Real Rate of Return:

Datasheet 2Signature: Michael Purdie/JoAnn SimpsonDate: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton Pittiglio 6 12 2041ANNUITYTermination of Operations:YearAnnuity: 2011$7,649,6452.00%$13,980,174 2012$7,649,6452.00%$13,706,053 2013$7,649,6452.00%$13,437,307 2014$7,649,6452.00%$13,173,830 2015$7,649,6452.00%$12,915,520 2016$7,649,6452.00%$12,662,275 2017$7,649,6452.00%$12,413,995 2018$7,649,6452.00%$12,170,583 2019$7,649,6452.00%$11,931,944 2020$7,649,6452.00%$11,697,984 2021$7,649,6452.00%$11,468,612 2022$7,649,6452.00%$11,243,737 2023$7,649,6452.00%$11,023,272 2024$7,649,6452.00%$10,807,129 2025$7,649,6452.00%$10,595,225 2026$7,649,6452.00%$10,387,475 2027$7,649,6452.00%$10,183,799 2028$7,649,6452.00%$9,984,117 2029$7,649,6452.00%$9,788,350 2030$7,649,6452.00%$9,596,422 2031$7,649,6452.00%$9,408,256 2032$7,649,6452.00%$9,223,781 2033$7,649,6452.00%$9,042,922 2034$7,649,6452.00%$8,865,610 2035$7,649,6452.00%$8,691,775 2036$7,649,6452.00%$8,521,348Total:$286,921,498If licensee is granted greater than 2% RRRReal Rate of Return:Total Accumulation