ML112351256: Difference between revisions

From kanterella
Jump to navigation Jump to search
(Created page by program invented by StriderTol)
(StriderTol Bot change)
 
(One intermediate revision by the same user not shown)
Line 15: Line 15:


=Text=
=Text=
{{#Wiki_filter: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:37.50%130.754%119.246%112.50%1 3 4variable 1variable 1variable 1 N N Y N Y Y 5 6Any modifications to a licensee's method of providing decommissioning funding assurance? (Y/N) 7 Plant name:Catawba Nuclear Station, Unit 150-413RAI Needed (Y/N)PUC Verified (Y/N)$67,484,121ProvidedDocket 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 RateAllowed through Decom (Y/N)Duke Energy Carolinas, LLCPiedmont Municipal Power Agency Y$466,987,774The total amount of dollars accumulated at the end of the appropriate year: (see below)
{{#Wiki_filter:Datasheet 1 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 1
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$282,156,578Real Rate of ReturnPUC Verified (Y/N)$57,872,625Total Trust Fund Balance 1 Rates provided are variable because the rates are not consistent throughout the licensee(s) and/or years of operation/decommission.North Carolina Electric Membership CorporationNorth Carolina Municipal Power Agency 1Licensee:$129,035,874Amount in Trust Fund:
2
NAny 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)
% Owned:
N$27,763,958Post-RAIRates Determined (Y/N)
Category:
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:1212PWR 3411$105,000,000112.81.980.652.231.676191.4114.23.049250.082.00.132.2530.2212.28% Owned:Category37.50%130.75%119.25%112.50%1 2%32.93See Annuity SheetSee Annuity Sheet 2%7$794,679,014 NOShortfall:YESDoes Licensee Pass:Does Licensee Pass:YESTotal of Steps 1 thru 3:See Annuity SheetNumber of Annual Payments:Accumulation:Step 2:Earnings Credit:$282,156,578Decom Period:See Total Step 2Total AnnuityReal Rate of Return per yearTotal Fund Balance:$282,156,578Total Step 1 + Step 2$739,688,476$54,990,537Total Earnings for Decom:Decom Period:Total Earnings:Real Rate of Return per yearLatest Month PxAmount of NRC Minimum/Site Specific:BWR/PWRMWthNorth Carolina Municipal Power Agency 1North Carolina Electric Membership CorporationDuke Energy Carolinas, LLC$89,849,544$143,574,399Total Annuity:Step 3:$67,484,121$129,035,874Amount in Trust Fund:$198,082,768Total Earnings:$541,605,708Real Rate of Return per year FxSite Specific:Total Step 2:$58,355,986Years Left in LicenseN/A$27,763,958Real Rate of Return per yearDoes Licensee Pass:YES$57,872,625See Total Step 2$739,688,476Years remaining after annuity Px50-413 531Termination of Operations:2043 1986$DayBase FxPlant name:Value of Annuity per year (amount/See Annuity Sheet)Licensee:$175,067,957NRC Minimum:$466,847,886Piedmont Municipal Power AgencyTrust Fund Balance:Step 1: Bx Ex LxECIBase LxBase Px2010Year:Catawba Nuclear Station, Unit 1Docket Number:Date of Operation:Latest Month Fx 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:121250-413 531Termination of Operations:2043DayPlant name:2010Year:Catawba Nuclear Station, Unit 1Docket Number:Date of Operation:2.00%32.93 See Annuity SheetSee Annuity Sheet2.00%7Real Rate of Return per yearAccumulation:Value of Annuity per year$282,156,578Total Annuity:Number of Annual Payments:Step 5:Real Rate of Return per yearTotal Earnings:$541,605,708YESIf licensee is granted greater than 2% RRRYES$54,990,537Total Step 5Total of Steps 4 thru 6:$794,679,013Does Licensee Pass:Total Earnings:N/A 0$739,688,476See Annuity SheetSee Total Step 4Decom Period:Step 6:$739,688,476See Total Step 4Does Licensee Pass:Real Rate of Return per yearYESTotal Step 4 + Step 5Total Earnings for Decom:Decom Period:Total AnnuityDoes Licensee Pass:Trust Fund Balance:Years Left in LicenseShortfall:
37.50%
NOReal Rate of Return per yearYears remaining after annuity$198,082,768Earnings Credit:Step 4:
1 30.754%
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 12 5 2043YearAnnuity: 2011$3,984,023 2%$7,647,661 2012$3,984,023 2%$7,497,707 2013$3,984,023 2%$7,350,693 2014$3,984,023 2%$7,206,562 2015$3,984,023 2%$7,065,257 2016$3,984,023 2%$6,926,722 2017$3,984,023 2%$6,790,904 2018$3,984,023 2%$6,657,749 2019$3,984,023 2%$6,527,205 2020$3,984,023 2%$6,399,221 2021$3,984,023 2%$6,273,746 2022$3,984,023 2%$6,150,731 2023$3,984,023 2%$6,030,129 2024$3,984,023 2%$5,911,891 2025$3,984,023 2%$5,795,971 2026$3,984,023 2%$5,682,325 2027$3,984,023 2%$5,570,907 2028$3,984,023 2%$5,461,673 2029$3,984,023 2%$5,354,582 2030$3,984,023 2%$5,249,590 2031$3,984,023 2%$5,146,657 2032$3,984,023 2%$5,045,742 2033$3,546,523 2%$4,403,579 2034$21,347,947 2%$25,987,169 2035$3,546,523 2%$4,232,583 2036$3,546,523 2%$4,149,591 2037$3,546,523 2%$4,068,226 2038$3,546,523 2%$3,988,457 2039$2,548,582 2%$2,809,963 2040$2,548,582 2%$2,754,866 2041$2,548,582 2%$2,700,849 2042$2,548,582 2%$2,647,891 2043$2,548,582 2%$2,595,971 Total:$198,082,768ANNUITYTotal AccumulationTermination of Operations:Real Rate of Return:
1 19.246%
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 12 5 2043ANNUITYTermination of Operations:YearAnnuity: 2011$3,984,0232.00%$7,647,661 2012$3,984,0232.00%$7,497,707 2013$3,984,0232.00%$7,350,693 2014$3,984,0232.00%$7,206,562 2015$3,984,0232.00%$7,065,257 2016$3,984,0232.00%$6,926,722 2017$3,984,0232.00%$6,790,904 2018$3,984,0232.00%$6,657,749 2019$3,984,0232.00%$6,527,205 2020$3,984,0232.00%$6,399,221 2021$3,984,0232.00%$6,273,746 2022$3,984,0232.00%$6,150,731 2023$3,984,0232.00%$6,030,129 2024$3,984,0232.00%$5,911,891 2025$3,984,0232.00%$5,795,971 2026$3,984,0232.00%$5,682,325 2027$3,984,0232.00%$5,570,907 2028$3,984,0232.00%$5,461,673 2029$3,984,0232.00%$5,354,582 2030$3,984,0232.00%$5,249,590 2031$3,984,0232.00%$5,146,657 2032$3,984,0232.00%$5,045,742 2033$3,546,5232.00%$4,403,579 2034$21,347,9472.00%$25,987,169 2035$3,546,5232.00%$4,232,583 2036$3,546,5232.00%$4,149,591 2037$3,546,5232.00%$4,068,226 2038$3,546,5232.00%$3,988,457 2039$2,548,5822.00%$2,809,963 2040$2,548,5822.00%$2,754,866 2041$2,548,5822.00%$2,700,849 2042$2,548,5822.00%$2,647,891 2043$2,548,5822.00%$2,595,971Total:$198,082,768 If licensee is granted greater than 2% RRRReal Rate of Return:Total Accumulation}}
1 12.50%
1 3
4 variable1 variable1 variable1 N
N Y
N Y
Y 5
6 Any modifications to a licensee's method of providing decommissioning funding assurance? (Y/N) 7 Plant name:
Catawba Nuclear Station, Unit 1 50-413 RAI Needed (Y/N)
PUC Verified (Y/N)
$67,484,121 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 Allowed through Decom (Y/N)
Duke Energy Carolinas, LLC Piedmont Municipal Power Agency Y
$466,987,774 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
$282,156,578 Real Rate of Return PUC Verified (Y/N)
$57,872,625 Total Trust Fund Balance 1 Rates provided are variable because the rates are not consistent throughout the licensee(s) and/or years of operation/decommission.
North Carolina Electric Membership Corporation North Carolina Municipal Power Agency 1 Licensee:
$129,035,874 Amount in Trust Fund:
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
$27,763,958 Post-RAI Rates Determined (Y/N)
 
Datasheet 2 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:
12 12 PWR 3411
$105,000,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 37.50%
1 30.75%
1 19.25%
1 12.50%
1 2%
32.93 See Annuity Sheet See Annuity Sheet 2%
7
$794,679,014 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:
$282,156,578 Decom Period:
See Total Step 2 Total Annuity Real Rate of Return per year Total Fund Balance:
$282,156,578 Total Step 1 + Step 2
$739,688,476
$54,990,537 Total Earnings for Decom:
Decom Period:
Total Earnings:
Real Rate of Return per year Latest Month Px Amount of NRC Minimum/Site Specific:
BWR/PWR MWth North Carolina Municipal Power Agency 1 North Carolina Electric Membership Corporation Duke Energy Carolinas, LLC
$89,849,544
$143,574,399 Total Annuity:
Step 3:
$67,484,121
$129,035,874 Amount in Trust Fund:
$198,082,768 Total Earnings:
$541,605,708 Real Rate of Return per year Fx Site Specific:
Total Step 2:
$58,355,986 Years Left in License N/A
$27,763,958 Real Rate of Return per year Does Licensee Pass:
YES
$57,872,625 See Total Step 2
$739,688,476 Years remaining after annuity Px 50-413 5
31 Termination of Operations:
2043 1986$
Day Base Fx Plant name:
Value of Annuity per year (amount/See Annuity Sheet)
Licensee:
$175,067,957 NRC Minimum:
$466,847,886 Piedmont Municipal Power Agency Trust Fund Balance:
Step 1:
Bx Ex Lx ECI Base Lx Base Px 2010 Year:
Catawba Nuclear Station, Unit 1 Docket Number:
Date of Operation:
Latest Month Fx
 
Datasheet 2 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:
12 12 50-413 5
31 Termination of Operations:
2043 Day Plant name:
2010 Year:
Catawba Nuclear Station, Unit 1 Docket Number:
Date of Operation:
2.00%
32.93 See Annuity Sheet See Annuity Sheet 2.00%
7 Real Rate of Return per year Accumulation:
Value of Annuity per year
$282,156,578 Total Annuity:
Number of Annual Payments:
Step 5:
Real Rate of Return per year Total Earnings:
$541,605,708 YES If licensee is granted greater than 2% RRR YES
$54,990,537 Total Step 5 Total of Steps 4 thru 6:
$794,679,013 Does Licensee Pass:
Total Earnings:
N/A 0
$739,688,476 See Annuity Sheet See Total Step 4 Decom Period:
Step 6:
$739,688,476 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 Does Licensee Pass:
Trust Fund Balance:
Years Left in License Shortfall:
NO Real Rate of Return per year Years remaining after annuity
$198,082,768 Earnings Credit:
Step 4:
 
Datasheet 2 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 12 5
2043 Year Annuity:
2011
$3,984,023 2%
$7,647,661 2012
$3,984,023 2%
$7,497,707 2013
$3,984,023 2%
$7,350,693 2014
$3,984,023 2%
$7,206,562 2015
$3,984,023 2%
$7,065,257 2016
$3,984,023 2%
$6,926,722 2017
$3,984,023 2%
$6,790,904 2018
$3,984,023 2%
$6,657,749 2019
$3,984,023 2%
$6,527,205 2020
$3,984,023 2%
$6,399,221 2021
$3,984,023 2%
$6,273,746 2022
$3,984,023 2%
$6,150,731 2023
$3,984,023 2%
$6,030,129 2024
$3,984,023 2%
$5,911,891 2025
$3,984,023 2%
$5,795,971 2026
$3,984,023 2%
$5,682,325 2027
$3,984,023 2%
$5,570,907 2028
$3,984,023 2%
$5,461,673 2029
$3,984,023 2%
$5,354,582 2030
$3,984,023 2%
$5,249,590 2031
$3,984,023 2%
$5,146,657 2032
$3,984,023 2%
$5,045,742 2033
$3,546,523 2%
$4,403,579 2034
$21,347,947 2%
$25,987,169 2035
$3,546,523 2%
$4,232,583 2036
$3,546,523 2%
$4,149,591 2037
$3,546,523 2%
$4,068,226 2038
$3,546,523 2%
$3,988,457 2039
$2,548,582 2%
$2,809,963 2040
$2,548,582 2%
$2,754,866 2041
$2,548,582 2%
$2,700,849 2042
$2,548,582 2%
$2,647,891 2043
$2,548,582 2%
$2,595,971 Total:
$198,082,768 ANNUITY Total Accumulation Termination of Operations:
Real Rate of Return:
 
Datasheet 2 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 12 5
2043 ANNUITY Termination of Operations:
Year Annuity:
2011
$3,984,023 2.00%
$7,647,661 2012
$3,984,023 2.00%
$7,497,707 2013
$3,984,023 2.00%
$7,350,693 2014
$3,984,023 2.00%
$7,206,562 2015
$3,984,023 2.00%
$7,065,257 2016
$3,984,023 2.00%
$6,926,722 2017
$3,984,023 2.00%
$6,790,904 2018
$3,984,023 2.00%
$6,657,749 2019
$3,984,023 2.00%
$6,527,205 2020
$3,984,023 2.00%
$6,399,221 2021
$3,984,023 2.00%
$6,273,746 2022
$3,984,023 2.00%
$6,150,731 2023
$3,984,023 2.00%
$6,030,129 2024
$3,984,023 2.00%
$5,911,891 2025
$3,984,023 2.00%
$5,795,971 2026
$3,984,023 2.00%
$5,682,325 2027
$3,984,023 2.00%
$5,570,907 2028
$3,984,023 2.00%
$5,461,673 2029
$3,984,023 2.00%
$5,354,582 2030
$3,984,023 2.00%
$5,249,590 2031
$3,984,023 2.00%
$5,146,657 2032
$3,984,023 2.00%
$5,045,742 2033
$3,546,523 2.00%
$4,403,579 2034
$21,347,947 2.00%
$25,987,169 2035
$3,546,523 2.00%
$4,232,583 2036
$3,546,523 2.00%
$4,149,591 2037
$3,546,523 2.00%
$4,068,226 2038
$3,546,523 2.00%
$3,988,457 2039
$2,548,582 2.00%
$2,809,963 2040
$2,548,582 2.00%
$2,754,866 2041
$2,548,582 2.00%
$2,700,849 2042
$2,548,582 2.00%
$2,647,891 2043
$2,548,582 2.00%
$2,595,971 Total:
$198,082,768 If licensee is granted greater than 2% RRR Real Rate of Return:
Total Accumulation}}

Latest revision as of 04:28, 13 January 2025

2010 DFS Report Analysis for Catawba Nuclear Station, Unit 1
ML112351256
Person / Time
Site: Catawba 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: ML112351256 (5)


Text

Datasheet 1 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 1

2

% Owned:

Category:

37.50%

1 30.754%

1 19.246%

1 12.50%

1 3

4 variable1 variable1 variable1 N

N Y

N Y

Y 5

6 Any modifications to a licensee's method of providing decommissioning funding assurance? (Y/N) 7 Plant name:

Catawba Nuclear Station, Unit 1 50-413 RAI Needed (Y/N)

PUC Verified (Y/N)

$67,484,121 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 Allowed through Decom (Y/N)

Duke Energy Carolinas, LLC Piedmont Municipal Power Agency Y

$466,987,774 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

$282,156,578 Real Rate of Return PUC Verified (Y/N)

$57,872,625 Total Trust Fund Balance 1 Rates provided are variable because the rates are not consistent throughout the licensee(s) and/or years of operation/decommission.

North Carolina Electric Membership Corporation North Carolina Municipal Power Agency 1 Licensee:

$129,035,874 Amount in Trust Fund:

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

$27,763,958 Post-RAI Rates Determined (Y/N)

Datasheet 2 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:

12 12 PWR 3411

$105,000,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 37.50%

1 30.75%

1 19.25%

1 12.50%

1 2%

32.93 See Annuity Sheet See Annuity Sheet 2%

7

$794,679,014 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:

$282,156,578 Decom Period:

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

$282,156,578 Total Step 1 + Step 2

$739,688,476

$54,990,537 Total Earnings for Decom:

Decom Period:

Total Earnings:

Real Rate of Return per year Latest Month Px Amount of NRC Minimum/Site Specific:

BWR/PWR MWth North Carolina Municipal Power Agency 1 North Carolina Electric Membership Corporation Duke Energy Carolinas, LLC

$89,849,544

$143,574,399 Total Annuity:

Step 3:

$67,484,121

$129,035,874 Amount in Trust Fund:

$198,082,768 Total Earnings:

$541,605,708 Real Rate of Return per year Fx Site Specific:

Total Step 2:

$58,355,986 Years Left in License N/A

$27,763,958 Real Rate of Return per year Does Licensee Pass:

YES

$57,872,625 See Total Step 2

$739,688,476 Years remaining after annuity Px 50-413 5

31 Termination of Operations:

2043 1986$

Day Base Fx Plant name:

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

Licensee:

$175,067,957 NRC Minimum:

$466,847,886 Piedmont Municipal Power Agency Trust Fund Balance:

Step 1:

Bx Ex Lx ECI Base Lx Base Px 2010 Year:

Catawba Nuclear Station, Unit 1 Docket Number:

Date of Operation:

Latest Month Fx

Datasheet 2 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:

12 12 50-413 5

31 Termination of Operations:

2043 Day Plant name:

2010 Year:

Catawba Nuclear Station, Unit 1 Docket Number:

Date of Operation:

2.00%

32.93 See Annuity Sheet See Annuity Sheet 2.00%

7 Real Rate of Return per year Accumulation:

Value of Annuity per year

$282,156,578 Total Annuity:

Number of Annual Payments:

Step 5:

Real Rate of Return per year Total Earnings:

$541,605,708 YES If licensee is granted greater than 2% RRR YES

$54,990,537 Total Step 5 Total of Steps 4 thru 6:

$794,679,013 Does Licensee Pass:

Total Earnings:

N/A 0

$739,688,476 See Annuity Sheet See Total Step 4 Decom Period:

Step 6:

$739,688,476 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 Does Licensee Pass:

Trust Fund Balance:

Years Left in License Shortfall:

NO Real Rate of Return per year Years remaining after annuity

$198,082,768 Earnings Credit:

Step 4:

Datasheet 2 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 12 5

2043 Year Annuity:

2011

$3,984,023 2%

$7,647,661 2012

$3,984,023 2%

$7,497,707 2013

$3,984,023 2%

$7,350,693 2014

$3,984,023 2%

$7,206,562 2015

$3,984,023 2%

$7,065,257 2016

$3,984,023 2%

$6,926,722 2017

$3,984,023 2%

$6,790,904 2018

$3,984,023 2%

$6,657,749 2019

$3,984,023 2%

$6,527,205 2020

$3,984,023 2%

$6,399,221 2021

$3,984,023 2%

$6,273,746 2022

$3,984,023 2%

$6,150,731 2023

$3,984,023 2%

$6,030,129 2024

$3,984,023 2%

$5,911,891 2025

$3,984,023 2%

$5,795,971 2026

$3,984,023 2%

$5,682,325 2027

$3,984,023 2%

$5,570,907 2028

$3,984,023 2%

$5,461,673 2029

$3,984,023 2%

$5,354,582 2030

$3,984,023 2%

$5,249,590 2031

$3,984,023 2%

$5,146,657 2032

$3,984,023 2%

$5,045,742 2033

$3,546,523 2%

$4,403,579 2034

$21,347,947 2%

$25,987,169 2035

$3,546,523 2%

$4,232,583 2036

$3,546,523 2%

$4,149,591 2037

$3,546,523 2%

$4,068,226 2038

$3,546,523 2%

$3,988,457 2039

$2,548,582 2%

$2,809,963 2040

$2,548,582 2%

$2,754,866 2041

$2,548,582 2%

$2,700,849 2042

$2,548,582 2%

$2,647,891 2043

$2,548,582 2%

$2,595,971 Total:

$198,082,768 ANNUITY Total Accumulation Termination of Operations:

Real Rate of Return:

Datasheet 2 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Date: 8/18/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 12 5

2043 ANNUITY Termination of Operations:

Year Annuity:

2011

$3,984,023 2.00%

$7,647,661 2012

$3,984,023 2.00%

$7,497,707 2013

$3,984,023 2.00%

$7,350,693 2014

$3,984,023 2.00%

$7,206,562 2015

$3,984,023 2.00%

$7,065,257 2016

$3,984,023 2.00%

$6,926,722 2017

$3,984,023 2.00%

$6,790,904 2018

$3,984,023 2.00%

$6,657,749 2019

$3,984,023 2.00%

$6,527,205 2020

$3,984,023 2.00%

$6,399,221 2021

$3,984,023 2.00%

$6,273,746 2022

$3,984,023 2.00%

$6,150,731 2023

$3,984,023 2.00%

$6,030,129 2024

$3,984,023 2.00%

$5,911,891 2025

$3,984,023 2.00%

$5,795,971 2026

$3,984,023 2.00%

$5,682,325 2027

$3,984,023 2.00%

$5,570,907 2028

$3,984,023 2.00%

$5,461,673 2029

$3,984,023 2.00%

$5,354,582 2030

$3,984,023 2.00%

$5,249,590 2031

$3,984,023 2.00%

$5,146,657 2032

$3,984,023 2.00%

$5,045,742 2033

$3,546,523 2.00%

$4,403,579 2034

$21,347,947 2.00%

$25,987,169 2035

$3,546,523 2.00%

$4,232,583 2036

$3,546,523 2.00%

$4,149,591 2037

$3,546,523 2.00%

$4,068,226 2038

$3,546,523 2.00%

$3,988,457 2039

$2,548,582 2.00%

$2,809,963 2040

$2,548,582 2.00%

$2,754,866 2041

$2,548,582 2.00%

$2,700,849 2042

$2,548,582 2.00%

$2,647,891 2043

$2,548,582 2.00%

$2,595,971 Total:

$198,082,768 If licensee is granted greater than 2% RRR Real Rate of Return:

Total Accumulation