ML112371908: 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:                                 South Texas Project, Unit 1                                                    Docket Number:                                 50-498 1       The minimum financial assurance (MFA) estimate pursuant to 10 CFR 50.75(b) & (c):                                                                $466,924,483 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: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson Date: 7/26/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 1
Licensee:          % Owned: Category:                        Amount in Trust Fund:
2
NRG South Texas          44.00%           1                             $132,346,137 CPSB of SA            40.00%           1                             $128,312,218 City of Austin          16.00%           1                             $49,778,721 Total Trust Fund Balance        $310,437,076 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 Escalation                  Real Rate                  Allowed through Decom Return on                    Other                    Verified                                    Needed      Verified        through  Determined Rate                      of Return                            (Y/N)
Category:
Earnings                    Factors                    (Y/N)                                      (Y/N)        (Y/N)      Decom (Y/N)      (Y/N) 1                                                                                              2 Variable1    Variable 1
44.00%
Variable        N                      N                    Y           Y             Y            N 3
1 40.00%
5       Any contracts upon which the licensee is relying? (Y/N)                                                                                                  Y 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)                                                                                                          Y4 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 considered variable because the rates are not consistent throughout the licensee(s) and/or years of operation/decommission.
1 16.00%
2 Year-to-year rates cannot be determined from the submitted information.
1 3
4 Variable1 Variable1 Variable1 N
N Y
Y Y
N2 5
6 Any modifications to a licensee's method of providing decommissioning funding assurance? (Y/N) 7 N
1 Rates provided are considered variable because the rates are not consistent throughout the licensee(s) and/or years of operation/decommission.
Y 2 Year-to-year rates cannot be determined from the submitted information.
3 For NRG South Texas LP - The PUCT approved the Decommissioning Funds Collections Agreement by and between AEP Texas Central Company (TCC) and NRG South Texas LP in which TCC collects the non-bypassable charges and deposits them directly into trust. No additional review required.
3 For NRG South Texas LP - The PUCT approved the Decommissioning Funds Collections Agreement by and between AEP Texas Central Company (TCC) and NRG South Texas LP in which TCC collects the non-bypassable charges and deposits them directly into trust. No additional review required.
4 For CPSB of SA - The Master Trust Agreement was revised effective Jan 1, 2011, in accordance with a PUCT order authorizing transfer of funds from Unit 1 to a spent fuel subaccount to be used only for fuel-related costs incurred after shutdown commences. Additionally, the Mater Trust Agreement was revised to allow for creation of a pre-shutdown decommissioing cost subaccount to fund large component replacement and disposal costs. No additional review required.
$132,346,137 The total amount of dollars accumulated at the end of the appropriate year: (see below)
Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson                                                                                                                        Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/26/2011                                                                                                                                                            Formulas verified by: Clayton Pittiglio
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
$310,437,076 Real Rate of Return PUC Verified (Y/N)
CPSB of SA 4 For CPSB of SA - The Master Trust Agreement was revised effective Jan 1, 2011, in accordance with a PUCT order authorizing transfer of funds from Unit 1 to a spent fuel subaccount to be used only for fuel-related costs incurred after shutdown commences. Additionally, the Mater Trust Agreement was revised to allow for creation of a pre-shutdown decommissioing cost subaccount to fund large component replacement and disposal costs. No additional review required.
Allowed through Decom (Y/N)
City of Austin
$49,778,721 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)
Y4 Y3 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)
RAI Needed (Y/N)
PUC Verified (Y/N)
$128,312,218 provided Did the licensee identify the amount of estimated radiological funds? (Y/N)
Escalation Rate Amount in Trust Fund:
NRG South Texas Licensee:
Plant name:
South Texas Project, Unit 1 50-498 Docket Number:
The minimum financial assurance (MFA) estimate pursuant to 10 CFR 50.75(b) & (c):
$466,924,483


Datasheet 2 Plant name:                               South Texas Project, Unit 1                                        Docket Number:                 50-498 Month:                Day                    Year:
Datasheet 2 Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson Date: 7/26/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:
Date of Operation:                                    12                 31                      2010 Termination of Operations:                                    8                 20                      2027 Latest                  Latest BWR/PWR          MWth            1986$            ECI      Base Lx                      Lx          Px                Base Px    Fx            Base Fx      Ex                Bx Month Px                  Month Fx PWR           3853         $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:
12 8
Amount of NRC Minimum/Site Licensee:              % Owned:       Category                   Specific:                Amount in Trust Fund:
PWR 3853
NRG South Texas              44.00%             1                   $205,413,070                    $132,346,137 CPSB of SA                40.00%             1                   $186,739,154                    $128,312,218 City of Austin              16.00%             1                   $74,695,662                    $49,778,721 Total Fund Balance:         $310,437,076 Step 1:
$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 44.00%
1 40.00%
1 16.00%
1 2%
16.64 See Annuity Sheet See Annuity Sheet 2%
7
$565,599,946 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:
$310,437,076 Decom Period:
      $310,437,076                 2%            16.64          $431,569,353                  NO Step 2:
See Total Step 2 Total Annuity Real Rate of Return per year Total Fund Balance:
Accumulation:
$310,437,076 Total Step 1 + Step 2
Value of Annuity per year (amount/See Annuity      Real Rate of Return    Number of Annual Sheet)                per year              Payments:              Total Annuity:
$526,461,320
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:
$39,138,626 Total Earnings for Decom:
See Total Step 2        See Annuity Sheet            N/A                    $94,891,967 Total Step 1 + Step 2     Does Licensee Pass:
                                                                                $526,461,320                 YES Step 3:
Decom Period:
Decom Period:
Real Rate of Return   Decom        Total Earnings for Total Earnings:           per year         Period:           Decom:
Total Earnings:
      $526,461,320                  2%              7            $39,138,626 Total of Steps 1 thru 3:   Does Licensee Pass:     Shortfall:
Real Rate of Return per year Latest Month Px Amount of NRC Minimum/Site Specific:
                                                                                $565,599,946                  YES                NO Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson                                                                                                                                        Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/26/2011                                                                                                                                                                          Formulas verified by: Clayton Pittiglio
BWR/PWR MWth NRG South Texas CPSB of SA City of Austin
$74,695,662
$186,739,154 Total Annuity:
Step 3:
$128,312,218
$132,346,137 Amount in Trust Fund:
$94,891,967 Total Earnings:
$431,569,353 Real Rate of Return per year Fx Site Specific:
Total Step 2:
Years Left in License N/A Real Rate of Return per year Does Licensee Pass:
NO
$49,778,721 See Total Step 2
$526,461,320 Years remaining after annuity Px 50-498 20 31 Termination of Operations:
2027 1986$
Day Base Fx Plant name:
Value of Annuity per year (amount/See Annuity Sheet)
Licensee:
$205,413,070 NRC Minimum:
$466,847,886 Trust Fund Balance:
Step 1:
Bx Ex Lx ECI Base Lx Base Px 2010 Year:
South Texas Project, Unit 1 Docket Number:
Date of Operation:
Latest Month Fx


Datasheet 2 Plant name:                                   South Texas Project, Unit 1                                       Docket Number:          50-498 Month:                Day                    Year:
Datasheet 2 Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson Date: 7/26/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:
Date of Operation:                                       12                  31                      2010 Termination of Operations:                                        8                  20                      2027 If licensee is granted greater than 2% RRR Step 4:
12 8
Earnings Credit:
50-498 20 31 Termination of Operations:
Real Rate of Return Years Left Trust Fund Balance:             per year       in License      Total Earnings:        Does Licensee Pass:
2027 Day Plant name:
      $310,437,076                   2.00%            16.64          $431,569,353                  NO Step 5:
2010 Year:
Accumulation:
South Texas Project, Unit 1 Docket Number:
Real Rate of Return    Number of Annual Value of Annuity per year          per year              Payments:               Total Annuity:
Date of Operation:
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                   $94,891,967 Total Step 4 + Step 5    Does Licensee Pass:
2.00%
                                                                                  $526,461,320                   YES Step 6:
16.64 See Annuity Sheet See Annuity Sheet 2.00%
7 Real Rate of Return per year Accumulation:
Value of Annuity per year
$310,437,076 Total Annuity:
Number of Annual Payments:
Step 5:
Real Rate of Return per year Total Earnings:
$431,569,353 NO If licensee is granted greater than 2% RRR YES
$39,138,626 Total Step 5 Total of Steps 4 thru 6:
$565,599,946 Does Licensee Pass:
Total Earnings:
N/A 0
$526,461,320 See Annuity Sheet See Total Step 4 Decom Period:
Step 6:
$526,461,320 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 Does Licensee Pass:
      $526,461,320                  2.00%              7            $39,138,626 Total of Steps 4 thru 6:  Does Licensee Pass:      Shortfall:
Trust Fund Balance:
                                                                                  $565,599,946                  YES                NO Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson                                                                                                                  Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/26/2011                                                                                                                                                    Formulas verified by: Clayton Pittiglio
Years Left in License Shortfall:
NO Real Rate of Return per year Years remaining after annuity
$94,891,967 Earnings Credit:
Step 4:


Datasheet 2 ANNUITY Termination of Operations:                 8             20 2027 Real Rate    Total Year         Annuity:     of Return: Accumulation 2011         $4,682,194         2%     $6,509,388 2012         $4,682,194         2%     $6,381,753 2013         $4,682,194         2%     $6,256,621 2014         $4,682,194         2%     $6,133,942 2015         $4,682,194         2%     $6,013,668 2016         $4,682,194         2%     $5,895,753 2017         $4,682,194         2%     $5,780,150 2018         $4,682,194         2%     $5,666,814 2019         $4,682,194         2%     $5,555,700 2020         $4,682,194         2%     $5,446,765 2021         $4,682,194         2%     $5,339,965 2022         $4,682,194         2%     $5,235,260 2023         $4,682,194         2%     $5,132,608 2024         $4,682,194         2%     $5,031,969 2025         $4,682,194         2%     $4,933,303 2026         $4,682,194         2%     $4,836,571 2027         $4,682,194         2%     $4,741,736 Total:       $94,891,967 Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson                              Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/26/2011                                                                Formulas verified by: Clayton Pittiglio
Datasheet 2 Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson Date: 7/26/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 8
20 2027 Year Annuity:
2011
$4,682,194 2%
$6,509,388 2012
$4,682,194 2%
$6,381,753 2013
$4,682,194 2%
$6,256,621 2014
$4,682,194 2%
$6,133,942 2015
$4,682,194 2%
$6,013,668 2016
$4,682,194 2%
$5,895,753 2017
$4,682,194 2%
$5,780,150 2018
$4,682,194 2%
$5,666,814 2019
$4,682,194 2%
$5,555,700 2020
$4,682,194 2%
$5,446,765 2021
$4,682,194 2%
$5,339,965 2022
$4,682,194 2%
$5,235,260 2023
$4,682,194 2%
$5,132,608 2024
$4,682,194 2%
$5,031,969 2025
$4,682,194 2%
$4,933,303 2026
$4,682,194 2%
$4,836,571 2027
$4,682,194 2%
$4,741,736 Total:
$94,891,967 ANNUITY Total Accumulation Termination of Operations:
Real Rate of Return:


Datasheet 2 ANNUITY Termination of Operations:                       8            20 2027 If licensee is granted greater than 2% RRR Real Rate      Total Year           Annuity:       of Return: Accumulation 2011           $4,682,194         2.00%       $6,509,388 2012           $4,682,194         2.00%       $6,381,753 2013           $4,682,194         2.00%       $6,256,621 2014           $4,682,194         2.00%       $6,133,942 2015           $4,682,194         2.00%       $6,013,668 2016           $4,682,194         2.00%       $5,895,753 2017           $4,682,194         2.00%       $5,780,150 2018           $4,682,194         2.00%       $5,666,814 2019           $4,682,194         2.00%       $5,555,700 2020           $4,682,194         2.00%       $5,446,765 2021           $4,682,194         2.00%       $5,339,965 2022           $4,682,194         2.00%       $5,235,260 2023           $4,682,194         2.00%       $5,132,608 2024           $4,682,194         2.00%       $5,031,969 2025           $4,682,194         2.00%       $4,933,303 2026           $4,682,194         2.00%       $4,836,571 2027           $4,682,194         2.00%       $4,741,736 Total:       $94,891,967 Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson                                    Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/26/2011                                                                      Formulas verified by: Clayton Pittiglio}}
Datasheet 2 Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson Date: 7/26/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 8
20 2027 ANNUITY Termination of Operations:
Year Annuity:
2011
$4,682,194 2.00%
$6,509,388 2012
$4,682,194 2.00%
$6,381,753 2013
$4,682,194 2.00%
$6,256,621 2014
$4,682,194 2.00%
$6,133,942 2015
$4,682,194 2.00%
$6,013,668 2016
$4,682,194 2.00%
$5,895,753 2017
$4,682,194 2.00%
$5,780,150 2018
$4,682,194 2.00%
$5,666,814 2019
$4,682,194 2.00%
$5,555,700 2020
$4,682,194 2.00%
$5,446,765 2021
$4,682,194 2.00%
$5,339,965 2022
$4,682,194 2.00%
$5,235,260 2023
$4,682,194 2.00%
$5,132,608 2024
$4,682,194 2.00%
$5,031,969 2025
$4,682,194 2.00%
$4,933,303 2026
$4,682,194 2.00%
$4,836,571 2027
$4,682,194 2.00%
$4,741,736 Total:
$94,891,967 If licensee is granted greater than 2% RRR Real Rate of Return:
Total Accumulation}}

Latest revision as of 02:22, 13 January 2025

2010 DFS Report Analysis for South Texas Project, Unit 1
ML112371908
Person / Time
Site: South Texas STP Nuclear Operating Company 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: ML112371908 (5)


Text

Datasheet 1 Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson Date: 7/26/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 1

2

% Owned:

Category:

44.00%

1 40.00%

1 16.00%

1 3

4 Variable1 Variable1 Variable1 N

N Y

Y Y

N2 5

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

1 Rates provided are considered variable because the rates are not consistent throughout the licensee(s) and/or years of operation/decommission.

Y 2 Year-to-year rates cannot be determined from the submitted information.

3 For NRG South Texas LP - The PUCT approved the Decommissioning Funds Collections Agreement by and between AEP Texas Central Company (TCC) and NRG South Texas LP in which TCC collects the non-bypassable charges and deposits them directly into trust. No additional review required.

$132,346,137 The total amount of dollars accumulated at the end of the appropriate year: (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

$310,437,076 Real Rate of Return PUC Verified (Y/N)

CPSB of SA 4 For CPSB of SA - The Master Trust Agreement was revised effective Jan 1, 2011, in accordance with a PUCT order authorizing transfer of funds from Unit 1 to a spent fuel subaccount to be used only for fuel-related costs incurred after shutdown commences. Additionally, the Mater Trust Agreement was revised to allow for creation of a pre-shutdown decommissioing cost subaccount to fund large component replacement and disposal costs. No additional review required.

Allowed through Decom (Y/N)

City of Austin

$49,778,721 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)

Y4 Y3 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)

RAI Needed (Y/N)

PUC Verified (Y/N)

$128,312,218 provided Did the licensee identify the amount of estimated radiological funds? (Y/N)

Escalation Rate Amount in Trust Fund:

NRG South Texas Licensee:

Plant name:

South Texas Project, Unit 1 50-498 Docket Number:

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

$466,924,483

Datasheet 2 Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson Date: 7/26/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:

12 8

PWR 3853

$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 44.00%

1 40.00%

1 16.00%

1 2%

16.64 See Annuity Sheet See Annuity Sheet 2%

7

$565,599,946 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:

$310,437,076 Decom Period:

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

$310,437,076 Total Step 1 + Step 2

$526,461,320

$39,138,626 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 NRG South Texas CPSB of SA City of Austin

$74,695,662

$186,739,154 Total Annuity:

Step 3:

$128,312,218

$132,346,137 Amount in Trust Fund:

$94,891,967 Total Earnings:

$431,569,353 Real Rate of Return per year Fx Site Specific:

Total Step 2:

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

NO

$49,778,721 See Total Step 2

$526,461,320 Years remaining after annuity Px 50-498 20 31 Termination of Operations:

2027 1986$

Day Base Fx Plant name:

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

Licensee:

$205,413,070 NRC Minimum:

$466,847,886 Trust Fund Balance:

Step 1:

Bx Ex Lx ECI Base Lx Base Px 2010 Year:

South Texas Project, Unit 1 Docket Number:

Date of Operation:

Latest Month Fx

Datasheet 2 Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson Date: 7/26/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:

12 8

50-498 20 31 Termination of Operations:

2027 Day Plant name:

2010 Year:

South Texas Project, Unit 1 Docket Number:

Date of Operation:

2.00%

16.64 See Annuity Sheet See Annuity Sheet 2.00%

7 Real Rate of Return per year Accumulation:

Value of Annuity per year

$310,437,076 Total Annuity:

Number of Annual Payments:

Step 5:

Real Rate of Return per year Total Earnings:

$431,569,353 NO If licensee is granted greater than 2% RRR YES

$39,138,626 Total Step 5 Total of Steps 4 thru 6:

$565,599,946 Does Licensee Pass:

Total Earnings:

N/A 0

$526,461,320 See Annuity Sheet See Total Step 4 Decom Period:

Step 6:

$526,461,320 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

$94,891,967 Earnings Credit:

Step 4:

Datasheet 2 Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson Date: 7/26/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 8

20 2027 Year Annuity:

2011

$4,682,194 2%

$6,509,388 2012

$4,682,194 2%

$6,381,753 2013

$4,682,194 2%

$6,256,621 2014

$4,682,194 2%

$6,133,942 2015

$4,682,194 2%

$6,013,668 2016

$4,682,194 2%

$5,895,753 2017

$4,682,194 2%

$5,780,150 2018

$4,682,194 2%

$5,666,814 2019

$4,682,194 2%

$5,555,700 2020

$4,682,194 2%

$5,446,765 2021

$4,682,194 2%

$5,339,965 2022

$4,682,194 2%

$5,235,260 2023

$4,682,194 2%

$5,132,608 2024

$4,682,194 2%

$5,031,969 2025

$4,682,194 2%

$4,933,303 2026

$4,682,194 2%

$4,836,571 2027

$4,682,194 2%

$4,741,736 Total:

$94,891,967 ANNUITY Total Accumulation Termination of Operations:

Real Rate of Return:

Datasheet 2 Signature: _Shawn Harwell Date: 7/13/2011 Secondary Signature: Jo Ann Simpson Date: 7/26/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 8

20 2027 ANNUITY Termination of Operations:

Year Annuity:

2011

$4,682,194 2.00%

$6,509,388 2012

$4,682,194 2.00%

$6,381,753 2013

$4,682,194 2.00%

$6,256,621 2014

$4,682,194 2.00%

$6,133,942 2015

$4,682,194 2.00%

$6,013,668 2016

$4,682,194 2.00%

$5,895,753 2017

$4,682,194 2.00%

$5,780,150 2018

$4,682,194 2.00%

$5,666,814 2019

$4,682,194 2.00%

$5,555,700 2020

$4,682,194 2.00%

$5,446,765 2021

$4,682,194 2.00%

$5,339,965 2022

$4,682,194 2.00%

$5,235,260 2023

$4,682,194 2.00%

$5,132,608 2024

$4,682,194 2.00%

$5,031,969 2025

$4,682,194 2.00%

$4,933,303 2026

$4,682,194 2.00%

$4,836,571 2027

$4,682,194 2.00%

$4,741,736 Total:

$94,891,967 If licensee is granted greater than 2% RRR Real Rate of Return:

Total Accumulation