ML112380023: 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: Shawn W. Harwell          Date: 6/29/11 Signature:  Aaron L. Szabo Date: 7/7/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton Pittiglio 1 2% Owned:Category:100.00%1 3 49.00%4.00%5.00%N Y Y Y Y Y 5 6Any modifications to a licensee's method of providing decommissioning funding assurance? (Y/N) 7Allowed through Decom (Y/N)Total Trust Fund BalancePost-RAIRates Determined (Y/N)Any material changes to trust agreements? (Y/N)Plant name:Watts Bar Nuclear Plant, Unit 150-390RAI 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):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)Escalation Rate N N Y$467,000,000The total amount of dollars accumulated at the end of the appropriate year: (see below)
{{#Wiki_filter:Datasheet 1 Plant name:                           Watts Bar Nuclear Plant, Unit 1                                                Docket Number:                               50-390 1    The minimum financial assurance (MFA) estimate pursuant to 10 CFR 50.75(b) & (c):                                                         $467,000,000 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$105,790,000Real Rate of ReturnPUC Verified (Y/N)TVALicensee:$105,790,000Amount in Trust Fund:
Licensee:          % Owned: Category:                       Amount in Trust Fund:
Datasheet 2Signature:  Shawn W. Harwell          Date: 6/29/11Signature: Aaron L. Szabo Date: 7/7/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton PittiglioMonth:1211PWR 3459$105,000,000112.81.980.652.231.676191.4114.23.049250.082.00.132.2530.2212.28% Owned:Category100.00%1 2%24.86See Annuity SheetSee Annuity Sheet 2%7$276,936,203($189,911,683)Shortfall:
TVA              100.00%           1                           $105,790,000 Total Trust Fund Balance      $105,790,000 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)
NODoes Licensee Pass:Does Licensee Pass:
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)
NOTotal of Steps 1 thru 3:See Annuity SheetNumber of Annual Payments:Accumulation:Step 2:Earnings Credit:$105,790,000Decom Period:See Total Step 2Total AnnuityReal Rate of Return per yearTotal Fund Balance:$105,790,000Total Step 1 + Step 2$257,772,654$19,163,550Total Earnings for Decom:Decom Period:Total Earnings:Real Rate of Return per yearLatest Month PxAmount of NRC Minimum/Site Specific:BWR/PWRMWthTVATotal Annuity:Step 3:$105,790,000Amount in Trust Fund:$84,705,814Total Earnings:$173,066,840Real Rate of Return per year FxSite Specific:Total Step 2:Years Left in LicenseN/AReal Rate of Return per yearDoes Licensee Pass:
Earnings                  Factors                  (Y/N)                                       (Y/N)     (Y/N)     Decom (Y/N)    (Y/N) 9.00%        4.00%                      5.00%          N                    Y                    Y          Y            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)
NOSee Total Step 2$257,772,654Years remaining after annuity Px50-390 931Termination of Operations:2035 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: Bx Ex LxECIBase LxBase Px2010Year:Watts Bar Nuclear Plant, Unit 1Docket Number:Date of Operation:Latest Month Fx Datasheet 2Signature:  Shawn W. Harwell          Date:  6/29/11Signature: Aaron L. Szabo Date: 7/7/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton PittiglioMonth:121150-390 931Termination of Operations:2035DayPlant name:2010Year:Watts Bar Nuclear Plant, Unit 1Docket Number:Date of Operation:5.00%24.86See Annuity SheetSee Annuity Sheet5.00%7Real Rate of Return per yearAccumulation:Value of Annuity per year$105,790,000Total Annuity:Number of Annual Payments:Step 5:Real Rate of Return per yearTotal Earnings:$355,741,192 NOIf licensee is granted greater than 2% RRRYES$98,749,642Total Step 5Total of Steps 4 thru 6:$583,886,166Does Licensee Pass:Total Earnings:N/A 0$485,136,524See Annuity SheetSee Total Step 4Decom Period:Step 6:$485,136,524See 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:
Signature: Shawn W. Harwell Date: 6/29/11 Signature: Aaron L. Szabo                                                                                                                              Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/7/2011                                                                                                                                                        Formulas verified by: Clayton Pittiglio
NOReal Rate of Return per yearYears remaining after annuity$129,395,332Earnings Credit:Step 4:
 
Datasheet 2Signature: Shawn W. Harwell   Date: 6/29/11 Signature: Aaron L. SzaboDate: 7/7/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton Pittiglio 11 9 2035YearAnnuity: 2011$2,600,000 2%$4,253,597 2012$2,600,000 2%$4,170,193 2013$2,600,000 2%$4,088,425 2014$2,600,000 2%$4,008,259 2015$2,600,000 2%$3,929,666 2016$2,600,000 2%$3,852,614 2017$2,600,000 2%$3,777,072 2018$2,600,000 2%$3,703,012 2019$2,600,000 2%$3,630,404 2020$2,600,000 2%$3,559,220 2021$2,600,000 2%$3,489,431 2022$2,600,000 2%$3,421,011 2023$2,600,000 2%$3,353,932 2024$2,600,000 2%$3,288,169 2025$2,600,000 2%$3,223,695 2026$2,600,000 2%$3,160,485 2027$2,600,000 2%$3,098,515 2028$2,600,000 2%$3,037,760 2029$2,600,000 2%$2,978,196 2030$2,600,000 2%$2,919,800 2031$2,600,000 2%$2,862,549 2032$2,600,000 2%$2,806,420 2033$2,600,000 2%$2,751,393 2034$2,600,000 2%$2,697,444 2035$2,600,000 2%$2,644,553Total:$84,705,814ANNUITYTotal AccumulationTermination of Operations:Real Rate of Return:
Datasheet 2 Plant name:                           Watts Bar Nuclear Plant, Unit 1                                        Docket Number:                50-390 Month:                 Day                    Year:
Datasheet 2Signature:  Shawn W. Harwell   Date: 6/29/11 Signature: Aaron L. SzaboDate: 7/7/2011Spreadsheet created by: Aaron Szabo, Shawn HarwellFormulas verified by: Clayton Pittiglio 11 9 2035ANNUITYTermination of Operations:YearAnnuity: 2011$2,600,0005.00%$8,743,730 2012$2,600,0005.00%$8,327,362 2013$2,600,0005.00%$7,930,821 2014$2,600,0005.00%$7,553,163 2015$2,600,0005.00%$7,193,489 2016$2,600,0005.00%$6,850,941 2017$2,600,0005.00%$6,524,706 2018$2,600,0005.00%$6,214,006 2019$2,600,0005.00%$5,918,101 2020$2,600,0005.00%$5,636,286 2021$2,600,0005.00%$5,367,892 2022$2,600,0005.00%$5,112,278 2023$2,600,0005.00%$4,868,836 2024$2,600,0005.00%$4,636,987 2025$2,600,0005.00%$4,416,178 2026$2,600,0005.00%$4,205,884 2027$2,600,0005.00%$4,005,604 2028$2,600,0005.00%$3,814,861 2029$2,600,0005.00%$3,633,201 2030$2,600,0005.00%$3,460,191 2031$2,600,0005.00%$3,295,420 2032$2,600,0005.00%$3,138,495 2033$2,600,0005.00%$2,989,043 2034$2,600,0005.00%$2,846,708 2035$2,600,0005.00%$2,711,150Total:$129,395,332If licensee is granted greater than 2% RRRReal Rate of Return:Total Accumulation}}
Date of Operation:                                   12                  31                      2010 Termination of Operations:                                 11                  9                      2035 Latest                    Latest BWR/PWR          MWth          1986$            ECI      Base Lx                      Lx          Px                Base Px    Fx            Base Fx      Ex                Bx Month Px                  Month Fx PWR          3459       $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:
TVA                  100.00%            1                   $466,847,886                    $105,790,000 Total Fund Balance:         $105,790,000 Step 1:
Earnings Credit:
Real Rate of Return Years Left Trust Fund Balance:         per year      in License      Total Earnings:        Does Licensee Pass:
      $105,790,000                2%            24.86          $173,066,840                  NO Step 2:
Accumulation:
Value of Annuity per year (amount/See Annuity    Real Rate of Return   Number of Annual 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                    $84,705,814 Total Step 1 + Step 2    Does Licensee Pass:
                                                                              $257,772,654                  NO Step 3:
Decom Period:
Real Rate of Return  Decom        Total Earnings for Total Earnings:          per year         Period:          Decom:
      $257,772,654                2%              7            $19,163,550 Total of Steps 1 thru 3:   Does Licensee Pass:     Shortfall:
                                                                              $276,936,203                  NO            ($189,911,683)
Signature: Shawn W. Harwell Date: 6/29/11 Signature: Aaron L. Szabo                                                                                                                                               Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/7/2011                                                                                                                                                                        Formulas verified by: Clayton Pittiglio
 
Datasheet 2 Plant name:                               Watts Bar Nuclear Plant, Unit 1                                      Docket Number:           50-390 Month:                Day                    Year:
Date of Operation:                                       12                  31                      2010 Termination of Operations:                                      11                  9                      2035 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:
      $105,790,000                  5.00%            24.86          $355,741,192                  NO 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                  $129,395,332 Total Step 4 + Step 5    Does Licensee Pass:
                                                                                  $485,136,524                  YES Step 6:
Decom Period:
Real Rate of Return   Decom        Total Earnings for Total Earnings:              per year        Period:            Decom:
      $485,136,524                  5.00%              7            $98,749,642 Total of Steps 4 thru 6:   Does Licensee Pass:      Shortfall:
                                                                                  $583,886,166                  YES                NO Signature: Shawn W. Harwell Date: 6/29/11 Signature: Aaron L. Szabo                                                                                                                          Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/7/2011                                                                                                                                                    Formulas verified by: Clayton Pittiglio
 
Datasheet 2 ANNUITY Termination of Operations:              11             9 2035 Real Rate    Total Year        Annuity:    of Return: Accumulation 2011       $2,600,000       2%     $4,253,597 2012       $2,600,000       2%     $4,170,193 2013       $2,600,000       2%     $4,088,425 2014       $2,600,000       2%     $4,008,259 2015       $2,600,000       2%     $3,929,666 2016       $2,600,000       2%     $3,852,614 2017       $2,600,000       2%     $3,777,072 2018       $2,600,000       2%     $3,703,012 2019       $2,600,000       2%     $3,630,404 2020       $2,600,000       2%     $3,559,220 2021       $2,600,000       2%     $3,489,431 2022       $2,600,000       2%     $3,421,011 2023       $2,600,000       2%     $3,353,932 2024       $2,600,000       2%     $3,288,169 2025       $2,600,000       2%     $3,223,695 2026       $2,600,000       2%     $3,160,485 2027       $2,600,000       2%     $3,098,515 2028       $2,600,000       2%     $3,037,760 2029       $2,600,000       2%     $2,978,196 2030       $2,600,000       2%     $2,919,800 2031       $2,600,000       2%     $2,862,549 2032       $2,600,000       2%     $2,806,420 2033       $2,600,000       2%     $2,751,393 2034       $2,600,000       2%     $2,697,444 2035       $2,600,000       2%     $2,644,553 Total:       $84,705,814 Signature: Shawn W. Harwell Date: 6/29/11 Signature: Aaron L. Szabo                                    Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/7/2011                                                            Formulas verified by: Clayton Pittiglio
 
Datasheet 2 ANNUITY Termination of Operations:                     11            9 2035 If licensee is granted greater than 2% RRR Real Rate      Total Year            Annuity:      of Return: Accumulation 2011         $2,600,000        5.00%       $8,743,730 2012         $2,600,000        5.00%       $8,327,362 2013         $2,600,000        5.00%       $7,930,821 2014         $2,600,000        5.00%       $7,553,163 2015         $2,600,000        5.00%       $7,193,489 2016         $2,600,000        5.00%       $6,850,941 2017         $2,600,000        5.00%       $6,524,706 2018         $2,600,000        5.00%       $6,214,006 2019         $2,600,000        5.00%       $5,918,101 2020         $2,600,000        5.00%       $5,636,286 2021         $2,600,000        5.00%       $5,367,892 2022         $2,600,000        5.00%       $5,112,278 2023         $2,600,000        5.00%       $4,868,836 2024         $2,600,000        5.00%       $4,636,987 2025         $2,600,000        5.00%       $4,416,178 2026         $2,600,000        5.00%       $4,205,884 2027         $2,600,000        5.00%       $4,005,604 2028         $2,600,000        5.00%       $3,814,861 2029         $2,600,000        5.00%       $3,633,201 2030         $2,600,000        5.00%       $3,460,191 2031         $2,600,000        5.00%       $3,295,420 2032         $2,600,000        5.00%       $3,138,495 2033         $2,600,000        5.00%       $2,989,043 2034         $2,600,000        5.00%       $2,846,708 2035         $2,600,000        5.00%       $2,711,150 Total:     $129,395,332 Signature: Shawn W. Harwell Date: 6/29/11 Signature: Aaron L. Szabo                                            Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/7/2011                                                                      Formulas verified by: Clayton Pittiglio}}

Revision as of 15:32, 12 November 2019

2010 DFS Report Analysis for Watts Bar Nuclear Plant, Unit 1
ML112380023
Person / Time
Site: Watts Bar Tennessee Valley Authority 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: ML112380023 (5)


Text

Datasheet 1 Plant name: Watts Bar Nuclear Plant, Unit 1 Docket Number: 50-390 1 The minimum financial assurance (MFA) estimate pursuant to 10 CFR 50.75(b) & (c): $467,000,000 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:

TVA 100.00% 1 $105,790,000 Total Trust Fund Balance $105,790,000 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 Escalation Real Rate Allowed through Decom Return on Other Verified Needed Verified through Determined Rate of Return (Y/N)

Earnings Factors (Y/N) (Y/N) (Y/N) Decom (Y/N) (Y/N) 9.00% 4.00% 5.00% N Y Y Y 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)

Signature: Shawn W. Harwell Date: 6/29/11 Signature: Aaron L. Szabo Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/7/2011 Formulas verified by: Clayton Pittiglio

Datasheet 2 Plant name: Watts Bar Nuclear Plant, Unit 1 Docket Number: 50-390 Month: Day Year:

Date of Operation: 12 31 2010 Termination of Operations: 11 9 2035 Latest Latest BWR/PWR MWth 1986$ ECI Base Lx Lx Px Base Px Fx Base Fx Ex Bx Month Px Month Fx PWR 3459 $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:

TVA 100.00% 1 $466,847,886 $105,790,000 Total Fund Balance: $105,790,000 Step 1:

Earnings Credit:

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

$105,790,000 2% 24.86 $173,066,840 NO Step 2:

Accumulation:

Value of Annuity per year (amount/See Annuity Real Rate of Return Number of Annual 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 $84,705,814 Total Step 1 + Step 2 Does Licensee Pass:

$257,772,654 NO Step 3:

Decom Period:

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

$257,772,654 2% 7 $19,163,550 Total of Steps 1 thru 3: Does Licensee Pass: Shortfall:

$276,936,203 NO ($189,911,683)

Signature: Shawn W. Harwell Date: 6/29/11 Signature: Aaron L. Szabo Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/7/2011 Formulas verified by: Clayton Pittiglio

Datasheet 2 Plant name: Watts Bar Nuclear Plant, Unit 1 Docket Number: 50-390 Month: Day Year:

Date of Operation: 12 31 2010 Termination of Operations: 11 9 2035 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:

$105,790,000 5.00% 24.86 $355,741,192 NO 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 $129,395,332 Total Step 4 + Step 5 Does Licensee Pass:

$485,136,524 YES Step 6:

Decom Period:

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

$485,136,524 5.00% 7 $98,749,642 Total of Steps 4 thru 6: Does Licensee Pass: Shortfall:

$583,886,166 YES NO Signature: Shawn W. Harwell Date: 6/29/11 Signature: Aaron L. Szabo Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/7/2011 Formulas verified by: Clayton Pittiglio

Datasheet 2 ANNUITY Termination of Operations: 11 9 2035 Real Rate Total Year Annuity: of Return: Accumulation 2011 $2,600,000 2% $4,253,597 2012 $2,600,000 2% $4,170,193 2013 $2,600,000 2% $4,088,425 2014 $2,600,000 2% $4,008,259 2015 $2,600,000 2% $3,929,666 2016 $2,600,000 2% $3,852,614 2017 $2,600,000 2% $3,777,072 2018 $2,600,000 2% $3,703,012 2019 $2,600,000 2% $3,630,404 2020 $2,600,000 2% $3,559,220 2021 $2,600,000 2% $3,489,431 2022 $2,600,000 2% $3,421,011 2023 $2,600,000 2% $3,353,932 2024 $2,600,000 2% $3,288,169 2025 $2,600,000 2% $3,223,695 2026 $2,600,000 2% $3,160,485 2027 $2,600,000 2% $3,098,515 2028 $2,600,000 2% $3,037,760 2029 $2,600,000 2% $2,978,196 2030 $2,600,000 2% $2,919,800 2031 $2,600,000 2% $2,862,549 2032 $2,600,000 2% $2,806,420 2033 $2,600,000 2% $2,751,393 2034 $2,600,000 2% $2,697,444 2035 $2,600,000 2% $2,644,553 Total: $84,705,814 Signature: Shawn W. Harwell Date: 6/29/11 Signature: Aaron L. Szabo Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/7/2011 Formulas verified by: Clayton Pittiglio

Datasheet 2 ANNUITY Termination of Operations: 11 9 2035 If licensee is granted greater than 2% RRR Real Rate Total Year Annuity: of Return: Accumulation 2011 $2,600,000 5.00% $8,743,730 2012 $2,600,000 5.00% $8,327,362 2013 $2,600,000 5.00% $7,930,821 2014 $2,600,000 5.00% $7,553,163 2015 $2,600,000 5.00% $7,193,489 2016 $2,600,000 5.00% $6,850,941 2017 $2,600,000 5.00% $6,524,706 2018 $2,600,000 5.00% $6,214,006 2019 $2,600,000 5.00% $5,918,101 2020 $2,600,000 5.00% $5,636,286 2021 $2,600,000 5.00% $5,367,892 2022 $2,600,000 5.00% $5,112,278 2023 $2,600,000 5.00% $4,868,836 2024 $2,600,000 5.00% $4,636,987 2025 $2,600,000 5.00% $4,416,178 2026 $2,600,000 5.00% $4,205,884 2027 $2,600,000 5.00% $4,005,604 2028 $2,600,000 5.00% $3,814,861 2029 $2,600,000 5.00% $3,633,201 2030 $2,600,000 5.00% $3,460,191 2031 $2,600,000 5.00% $3,295,420 2032 $2,600,000 5.00% $3,138,495 2033 $2,600,000 5.00% $2,989,043 2034 $2,600,000 5.00% $2,846,708 2035 $2,600,000 5.00% $2,711,150 Total: $129,395,332 Signature: Shawn W. Harwell Date: 6/29/11 Signature: Aaron L. Szabo Spreadsheet created by: Aaron Szabo, Shawn Harwell Date: 7/7/2011 Formulas verified by: Clayton Pittiglio