ML112370138: 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 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: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)
{{#Wiki_filter:Datasheet 1 Plant name:                   McGuire (William B.) Nuclear Station, Unit 1                                                  Docket Number:                                 50-369 1       The minimum financial assurance (MFA) estimate pursuant to 10 CFR 50.75(b) & (c):                                                                $466,987,774 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)
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)
Licensee:                % Owned: Category:                  Amount in Trust Fund:
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:
Duke Energy Carolinas, LLC          100.00%        1                      $275,388,309 Total Trust Fund Balance      $275,388,309 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)
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:
Post-RAI Rate of                              Rate(s) of                 PUC                                RAI          PUC        Allowed        Rates Real Rate                  Allowed through Return on      Escalation Rate          Other                 Verified                             Needed      Verified    through    Determined of Return                    Decom (Y/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 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}}
Earnings                                Factors                  (Y/N)                               (Y/N)       (Y/N)     Decom (Y/N)     (Y/N) variable1          4.00%                        variable1        N                N                  Y          N            Y            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)                                                                                                         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) 1 Rates provided are variable because the rates are not consistent throughout the licensee(s) and/or years of operation/decommission Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo                                                                                                                             Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/18/2011                                                                                                                                                      Formulas verified by: Clayton Pittiglio
 
Datasheet 2 Plant name:                     McGuire (William B.) Nuclear Station, Unit 1                                      Docket Number:                 50-369 Month:                 Day                    Year:
Date of Operation:                                         12                  31                      2010 Termination of Operations:                                         6                  12                      2041 Latest                    Latest BWR/PWR              MWth                1986$             ECI      Base Lx                      Lx          Px                Base Px    Fx            Base Fx      Ex                      Bx Month Px                  Month Fx 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 NRC Minimum:                                   $466,847,886                                Site Specific:
Amount of NRC Minimum/Site Licensee:                  % Owned:        Category                  Specific:               Amount in Trust Fund:
Duke Energy Carolinas, LLC            100.00%            1                  $466,847,886                    $275,388,309 Total Fund Balance:         $275,388,309 Step 1:
Earnings Credit:
Real Rate of Return Years Left Trust Fund Balance:              per year      in License      Total Earnings:         Does Licensee Pass:
            $275,388,309                      2%            30.45          $503,272,335                  YES Step 2:
Accumulation:
Value of Annuity per year      Real Rate of Return   Number of Annual (amount/See Annuity Sheet)            per year              Payments:               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:
See Total Step 2            See Annuity Sheet            N/A                  $286,921,498 Total Step 1 + Step 2    Does Licensee Pass:
                                                                                          $790,193,833                  YES Step 3:
Decom Period:
Real Rate of Return  Decom        Total Earnings for Total Earnings:               per year        Period:           Decom:
            $790,193,833                      2%              7            $58,745,249 Total of Steps 1 thru 3:   Does Licensee Pass:     Shortfall:
                                                                                          $848,939,081                  YES                NO Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo                                                                                                                                                        Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/18/2011                                                                                                                                                                                Formulas verified by: Clayton Pittiglio
 
Datasheet 2 Plant name:                       McGuire (William B.) Nuclear Station, Unit 1                                    Docket Number:      50-369 Month:                Day                    Year:
Date of Operation:                                          12                  31                      2010 Termination of Operations:                                          6                  12                      2041 If licensee is granted greater than 2% RRR Step 4:
Earnings Credit:
Real Rate of Return Years Left Trust Fund Balance:                   per year     in License      Total Earnings:        Does Licensee Pass:
            $275,388,309                        2.00%          30.45          $503,272,335                  YES Step 5:
Accumulation:
Real Rate of Return   Number of Annual Value of Annuity per year                per year            Payments:              Total Annuity:
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                  $286,921,498 Total Step 4 + Step 5    Does Licensee Pass:
                                                                                          $790,193,833                  YES Step 6:
Decom Period:
Real Rate of Return  Decom        Total Earnings for Total Earnings:                   per year      Period:            Decom:
            $790,193,833                        2.00%           7            $58,745,249 Total of Steps 4 thru 6:  Does Licensee Pass:  Shortfall:
                                                                                          $848,939,081                  YES            NO Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo                                                                                                                                Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/18/2011                                                                                                                                                        Formulas verified by: Clayton Pittiglio
 
Datasheet 2 ANNUITY Termination of Operations:                    6            12      2041 Real Rate of    Total Year          Annuity:        Return:    Accumulation 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,348 Total:    $286,921,498 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo                                          Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/18/2011                                                                  Formulas verified by: Clayton Pittiglio
 
Datasheet 2 ANNUITY Termination of Operations:                        6            12      2041 If licensee is granted greater than 2% RRR Real Rate of        Total Year          Annuity:          Return:      Accumulation 2011          $7,649,645          2.00%         $13,980,174 2012          $7,649,645          2.00%         $13,706,053 2013          $7,649,645          2.00%         $13,437,307 2014          $7,649,645          2.00%         $13,173,830 2015          $7,649,645          2.00%         $12,915,520 2016          $7,649,645          2.00%         $12,662,275 2017          $7,649,645          2.00%         $12,413,995 2018          $7,649,645          2.00%         $12,170,583 2019          $7,649,645          2.00%         $11,931,944 2020          $7,649,645          2.00%         $11,697,984 2021          $7,649,645          2.00%         $11,468,612 2022          $7,649,645          2.00%         $11,243,737 2023          $7,649,645          2.00%         $11,023,272 2024          $7,649,645          2.00%         $10,807,129 2025          $7,649,645          2.00%         $10,595,225 2026          $7,649,645          2.00%         $10,387,475 2027          $7,649,645          2.00%         $10,183,799 2028          $7,649,645          2.00%         $9,984,117 2029          $7,649,645          2.00%         $9,788,350 2030          $7,649,645          2.00%         $9,596,422 2031          $7,649,645          2.00%         $9,408,256 2032          $7,649,645          2.00%         $9,223,781 2033          $7,649,645          2.00%          $9,042,922 2034          $7,649,645          2.00%         $8,865,610 2035          $7,649,645          2.00%          $8,691,775 2036          $7,649,645          2.00%          $8,521,348 Total:        $286,921,498 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo                                                Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/18/2011                                                                        Formulas verified by: Clayton Pittiglio}}

Latest revision as of 16:38, 12 November 2019

2010 DFS Report Analysis for McGuire (William B.) Nuclear Station, Unit 1
ML112370138
Person / Time
Site: McGuire 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: ML112370138 (5)


Text

Datasheet 1 Plant name: McGuire (William B.) Nuclear Station, Unit 1 Docket Number: 50-369 1 The minimum financial assurance (MFA) estimate pursuant to 10 CFR 50.75(b) & (c): $466,987,774 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)

Licensee:  % Owned: Category: Amount in Trust Fund:

Duke Energy Carolinas, LLC 100.00% 1 $275,388,309 Total Trust Fund Balance $275,388,309 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)

Post-RAI Rate of Rate(s) of PUC RAI PUC Allowed Rates Real Rate Allowed through Return on Escalation Rate Other Verified Needed Verified through Determined of Return Decom (Y/N)

Earnings Factors (Y/N) (Y/N) (Y/N) Decom (Y/N) (Y/N) variable1 4.00% variable1 N N Y N Y 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) 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) 1 Rates provided are variable because the rates are not consistent throughout the licensee(s) and/or years of operation/decommission Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/18/2011 Formulas verified by: Clayton Pittiglio

Datasheet 2 Plant name: McGuire (William B.) Nuclear Station, Unit 1 Docket Number: 50-369 Month: Day Year:

Date of Operation: 12 31 2010 Termination of Operations: 6 12 2041 Latest Latest BWR/PWR MWth 1986$ ECI Base Lx Lx Px Base Px Fx Base Fx Ex Bx Month Px Month Fx 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 NRC Minimum: $466,847,886 Site Specific:

Amount of NRC Minimum/Site Licensee:  % Owned: Category Specific: Amount in Trust Fund:

Duke Energy Carolinas, LLC 100.00% 1 $466,847,886 $275,388,309 Total Fund Balance: $275,388,309 Step 1:

Earnings Credit:

Real Rate of Return Years Left Trust Fund Balance: per year in License Total Earnings: Does Licensee Pass:

$275,388,309 2% 30.45 $503,272,335 YES Step 2:

Accumulation:

Value of Annuity per year Real Rate of Return Number of Annual (amount/See Annuity Sheet) per year Payments: 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:

See Total Step 2 See Annuity Sheet N/A $286,921,498 Total Step 1 + Step 2 Does Licensee Pass:

$790,193,833 YES Step 3:

Decom Period:

Real Rate of Return Decom Total Earnings for Total Earnings: per year Period: Decom:

$790,193,833 2% 7 $58,745,249 Total of Steps 1 thru 3: Does Licensee Pass: Shortfall:

$848,939,081 YES NO Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/18/2011 Formulas verified by: Clayton Pittiglio

Datasheet 2 Plant name: McGuire (William B.) Nuclear Station, Unit 1 Docket Number: 50-369 Month: Day Year:

Date of Operation: 12 31 2010 Termination of Operations: 6 12 2041 If licensee is granted greater than 2% RRR Step 4:

Earnings Credit:

Real Rate of Return Years Left Trust Fund Balance: per year in License Total Earnings: Does Licensee Pass:

$275,388,309 2.00% 30.45 $503,272,335 YES Step 5:

Accumulation:

Real Rate of Return Number of Annual Value of Annuity per year per year Payments: Total Annuity:

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 $286,921,498 Total Step 4 + Step 5 Does Licensee Pass:

$790,193,833 YES Step 6:

Decom Period:

Real Rate of Return Decom Total Earnings for Total Earnings: per year Period: Decom:

$790,193,833 2.00% 7 $58,745,249 Total of Steps 4 thru 6: Does Licensee Pass: Shortfall:

$848,939,081 YES NO Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/18/2011 Formulas verified by: Clayton Pittiglio

Datasheet 2 ANNUITY Termination of Operations: 6 12 2041 Real Rate of Total Year Annuity: Return: Accumulation 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,348 Total: $286,921,498 Signature: Michael Purdie/JoAnn Simpson Date: 07/20/2011 Signature: Aaron L. Szabo Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 8/18/2011 Formulas verified by: Clayton Pittiglio

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