ML112370014: Difference between revisions
StriderTol (talk | contribs) (Created page by program invented by StriderTol) |
StriderTol (talk | contribs) (StriderTol Bot change) |
||
| Line 15: | Line 15: | ||
=Text= | =Text= | ||
{{#Wiki_filter:Datasheet 1 | {{#Wiki_filter:Datasheet 1 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 1 | ||
2 | |||
% Owned: | |||
Category: | |||
83.83% | |||
Effective 2/16/2010, Progress Energy Service Company, LLC engaged Watson Wyatt Investment Consulting, Inc., a Tower Watson company as its new investment advisor. | 1 16.17% | ||
1 3 | |||
4 variable1 3.00% | |||
variable1 Y | |||
N N | |||
Y N | |||
Y 5 | |||
6 Any 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 funds of the licensee 2 Effective 2/16/2010, Progress Energy Service Company, LLC engaged Watson Wyatt Investment Consulting, Inc., a Tower Watson company as its new investment advisor. | |||
Towers Watson Advises Progress Energy on its trust investments including its nuclear decommissioning trusts. | Towers Watson Advises Progress Energy on its trust investments including its nuclear decommissioning trusts. | ||
Allowed through Decom (Y/N) | |||
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) | |||
N Y2 Plant name: | |||
Harris (Shearon) Nuclear Power Plant 50-400 RAI Needed (Y/N) | |||
PUC Verified (Y/N) | |||
$41,023,543 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 Y | |||
$447.1million 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 | |||
$275,586,156 Real Rate of Return PUC Verified (Y/N) | |||
North Carolina Municipal Power Agency Progress Energy Carolinas, Inc. | |||
Licensee: | |||
$234,562,613 Amount in Trust Fund: | |||
Datasheet 2 | Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month: | ||
Date | 12 10 PWR 2900 | ||
$100,520,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 83.83% | |||
1 16.17% | |||
1 2% | |||
35.81 See Annuity Sheet See Annuity Sheet 2% | |||
7 | |||
$1,472,125,193 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 | $275,586,156 Decom Period: | ||
See Total Step 2 Total Annuity Real Rate of Return per year Total Fund Balance: | |||
$275,586,156 Total Step 1 + Step 2 | |||
$1,370,256,445 Total Annuity: | |||
Step 3: | |||
See Total Step 2 | $41,023,543 | ||
$234,562,613 Amount in Trust Fund: | |||
$810,156,818 Total Earnings: | |||
$560,099,627 Real Rate of Return per year Latest Month Px Amount of NRC Minimum/Site Specific: | |||
BWR/PWR MWth Progress Energy Carolinas, Inc. | |||
North Carolina Municipal Power Agency | |||
$72,268,426 Fx Site Specific: | |||
Total Step 2: | |||
Years Left in License N/A Real Rate of Return per year Does Licensee Pass: | |||
YES See Total Step 2 2010 Year: | |||
Harris (Shearon) Nuclear Power Plant Docket Number: | |||
Date of Operation: | |||
Latest Month Fx | |||
$1,370,256,445 Years remaining after annuity Px 50-400 24 31 Termination of Operations: | |||
2046 1986$ | |||
Day Base Fx Plant name: | |||
Value of Annuity per year (amount/See Annuity Sheet) | |||
Licensee: | |||
$374,660,617 Bx Ex Lx ECI Base Lx Base Px NRC Minimum: | |||
$446,929,043 Trust Fund Balance: | |||
Step 1: | |||
$101,868,747 Total Earnings for Decom: | |||
Decom Period: | Decom Period: | ||
Real Rate of Return | Total Earnings: | ||
Real Rate of Return per year | |||
Datasheet 2 | Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month: | ||
Date of Operation: | 12 10 2010 Year: | ||
Harris (Shearon) Nuclear Power Plant Docket Number: | |||
Date of Operation: | |||
50-400 24 31 Termination of Operations: | |||
2046 Day Plant name: | |||
3.00% | |||
35.81 2.00% | |||
See Annuity Sheet See Annuity Sheet 2.00% | |||
7 Accumulation: | |||
Value of Annuity per year North Carolina Qualified Fund Total Annuity: | |||
Number of Annual Payments: | |||
Step 5: | Step 5: | ||
$681,201,121 If licensee is granted greater than 2% RRR Real Rate of Return Years Left in Trust Fund Balance: | |||
Real Rate of Return | YES | ||
$112,564,506 Total Step 5 Total of Steps 4 thru 6: | |||
$1,626,691,701 Does Licensee Pass: | |||
Total Earnings: | |||
N/A 0 | |||
$1,514,127,194 see annuity sheet See Total Step 4 Decom Period: | |||
Step 6: | |||
$1,514,127,194 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 | Total Annuity Total Earnings: | ||
Type of Fund Real Rate of Return per year Shortfall: | |||
NO Real Rate of Return per year Years remaining after annuity | |||
$832,926,074 Earnings Credit: | |||
Step 4: | |||
Does Licensee Pass: | |||
$142,471,204 YES All Others | |||
$133,114,952 | |||
Datasheet 2 | Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 10 24 2046 Year Annuity: | ||
2011 | |||
$17,538,171 2% | |||
$35,645,600 2012 | |||
$16,706,579 2% | |||
$33,289,632 2013 | |||
$16,706,579 2% | |||
$32,636,894 2014 | |||
$16,706,579 2% | |||
$31,996,955 2015 | |||
$16,706,579 2% | |||
$31,369,563 2016 | |||
$16,706,579 2% | |||
$30,754,474 2017 | |||
$16,706,579 2% | |||
$30,151,445 2018 | |||
$14,885,194 2% | |||
$26,337,523 2019 | |||
$14,885,194 2% | |||
$25,821,101 2020 | |||
$14,885,194 2% | |||
$25,314,805 2021 | |||
$14,885,194 2% | |||
$24,818,436 2022 | |||
$14,885,194 2% | |||
$24,331,800 2023 | |||
$14,885,194 2% | |||
$23,854,706 2024 | |||
$14,885,194 2% | |||
$23,386,967 2025 | |||
$14,885,194 2% | |||
$22,928,399 2026 | |||
$14,885,194 2% | |||
$22,478,822 2027 | |||
$14,885,194 2% | |||
$22,038,061 2028 | |||
$14,885,194 2% | |||
$21,605,942 2029 | |||
$14,885,194 2% | |||
$21,182,296 2030 | |||
$14,885,194 2% | |||
$20,766,957 2031 | |||
$14,885,194 2% | |||
$20,359,762 2032 | |||
$14,885,194 2% | |||
$19,960,551 2033 | |||
$14,885,194 2% | |||
$19,569,168 2034 | |||
$14,885,194 2% | |||
$19,185,458 2035 | |||
$14,885,194 2% | |||
$18,809,273 2036 | |||
$14,885,194 2% | |||
$18,440,464 2037 | |||
$14,885,194 2% | |||
$18,078,886 2038 | |||
$14,885,194 2% | |||
$17,724,398 2039 | |||
$14,885,194 2% | |||
$17,376,861 2040 | |||
$14,885,194 2% | |||
$17,036,138 2041 | |||
$14,885,194 2% | |||
$16,702,096 2042 | |||
$14,885,194 2% | |||
$16,374,604 2043 | |||
$14,885,194 2% | |||
$16,053,533 2044 | |||
$14,885,194 2% | |||
$15,738,758 2045 | |||
$14,885,194 2% | |||
$15,430,155 2046 | |||
$12,404,328 2% | |||
$12,606,335 Total: | |||
$810,156,818 ANNUITY Total Accumulation Termination of Operations: | |||
Real Rate of Return: | |||
Datasheet 2 | Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 10 24 2046 ANNUITY Termination of Operations: | ||
Year Annuity: | |||
Year Annuity: | |||
Year Annuity: | |||
2011 | |||
$8,433,298 3.00% | |||
$24,309,293 2011 | |||
$4,370,492 2.00% | |||
$8,882,842 2011 | |||
$2,902,789 2.00% | |||
$5,899,797 2012 | |||
$8,433,298 3.00% | |||
$23,601,255 2012 | |||
$4,370,492 2.00% | |||
$8,708,669 2012 | |||
$2,902,789 2.00% | |||
$5,784,115 2013 | |||
$8,433,298 3.00% | |||
$22,913,840 2013 | |||
$4,370,492 2.00% | |||
$8,537,911 2013 | |||
$2,902,789 2.00% | |||
$5,670,701 2014 | |||
$8,433,298 3.00% | |||
$22,246,446 2014 | |||
$4,370,492 2.00% | |||
$8,370,501 2014 | |||
$2,902,789 2.00% | |||
$5,559,511 2015 | |||
$8,433,298 3.00% | |||
$21,598,492 2015 | |||
$4,370,492 2.00% | |||
$8,206,373 2015 | |||
$2,902,789 2.00% | |||
$5,450,501 2016 | |||
$8,433,298 3.00% | |||
$20,969,409 2016 | |||
$4,370,492 2.00% | |||
$8,045,464 2016 | |||
$2,902,789 2.00% | |||
$5,343,628 2017 | |||
$8,433,298 3.00% | |||
$20,358,650 2017 | |||
$4,370,492 2.00% | |||
$7,887,710 2017 | |||
$2,902,789 2.00% | |||
$5,238,851 2018 | |||
$8,433,298 3.00% | |||
$19,765,679 2018 | |||
$3,063,777 2.00% | |||
$5,420,977 2018 | |||
$2,388,119 2.00% | |||
$4,225,483 2019 | |||
$8,433,298 3.00% | |||
$19,189,980 2019 | |||
$3,063,777 2.00% | |||
$5,314,684 2019 | |||
$2,388,119 2.00% | |||
$4,142,631 2020 | |||
$8,433,298 3.00% | |||
$18,631,049 2020 | |||
$3,063,777 2.00% | |||
$5,210,474 2020 | |||
$2,388,119 2.00% | |||
$4,061,403 2021 | |||
$8,433,298 3.00% | |||
$18,088,397 2021 | |||
$3,063,777 2.00% | |||
$5,108,308 2021 | |||
$2,388,119 2.00% | |||
$3,981,767 2022 | |||
$8,433,298 3.00% | |||
$17,561,550 2022 | |||
$3,063,777 2.00% | |||
$5,008,145 2022 | |||
$2,388,119 2.00% | |||
$3,903,693 2023 | |||
$8,433,298 3.00% | |||
$17,050,049 2023 | |||
$3,063,777 2.00% | |||
$4,909,946 2023 | |||
$2,388,119 2.00% | |||
$3,827,150 2024 | |||
$8,433,298 3.00% | |||
$16,553,445 2024 | |||
$3,063,777 2.00% | |||
$4,813,673 2024 | |||
$2,388,119 2.00% | |||
$3,752,108 2025 | |||
$8,433,298 3.00% | |||
$16,071,306 2025 | |||
$3,063,777 2.00% | |||
$4,719,287 2025 | |||
$2,388,119 2.00% | |||
$3,678,538 2026 | |||
$8,433,298 3.00% | |||
$15,603,210 2026 | |||
$3,063,777 2.00% | |||
$4,626,752 2026 | |||
$2,388,119 2.00% | |||
$3,606,409 2027 3.00% | |||
$0 2027 | |||
$11,497,075 2.00% | |||
$17,021,830 2027 | |||
$2,388,119 2.00% | |||
$3,535,695 2028 3.00% | |||
$0 2028 | |||
$11,497,075 2.00% | |||
$16,688,069 2028 | |||
$2,388,119 2.00% | |||
$3,466,368 2029 3.00% | |||
$0 2029 | |||
$11,497,075 2.00% | |||
$16,360,852 2029 | |||
$2,388,119 2.00% | |||
$3,398,400 2030 3.00% | |||
$0 2030 | |||
$11,497,075 2.00% | |||
$16,040,051 2030 | |||
$2,388,119 2.00% | |||
$3,331,765 2031 3.00% | |||
$0 2031 | |||
$11,497,075 2.00% | |||
$15,725,540 2031 | |||
$2,388,119 2.00% | |||
$3,266,436 2032 3.00% | |||
$0 2032 | |||
$11,497,075 2.00% | |||
$15,417,196 2032 | |||
$2,388,119 2.00% | |||
$3,202,388 2033 3.00% | |||
$0 2033 | |||
$11,497,075 2.00% | |||
$15,114,898 2033 | |||
$2,388,119 2.00% | |||
$3,139,596 2034 3.00% | |||
$0 2034 | |||
$11,497,075 2.00% | |||
$14,818,527 2034 | |||
$2,388,119 2.00% | |||
$3,078,036 2035 3.00% | |||
$0 2035 | |||
$11,497,075 2.00% | |||
$14,527,968 2035 | |||
$2,388,119 2.00% | |||
$3,017,682 2036 3.00% | |||
$0 2036 | |||
$11,497,075 2.00% | |||
$14,243,106 2036 | |||
$2,388,119 2.00% | |||
$2,958,512 2037 3.00% | |||
$0 2037 | |||
$11,497,075 2.00% | |||
$13,963,829 2037 | |||
$2,388,119 2.00% | |||
$2,900,502 2038 3.00% | |||
$0 2038 | |||
$11,497,075 2.00% | |||
$13,690,029 2038 | |||
$2,388,119 2.00% | |||
$2,843,629 2039 3.00% | |||
$0 2039 | |||
$11,497,075 2.00% | |||
$13,421,597 2039 | |||
$2,388,119 2.00% | |||
$2,787,872 2040 3.00% | |||
$0 2040 | |||
$11,497,075 2.00% | |||
$13,158,428 2040 | |||
$2,388,119 2.00% | |||
$2,733,208 2041 3.00% | |||
$0 2041 | |||
$11,497,075 2.00% | |||
$12,900,420 2041 | |||
$2,388,119 2.00% | |||
$2,679,615 2042 3.00% | |||
$0 2042 | |||
$11,497,075 2.00% | |||
$12,647,470 2042 | |||
$2,388,119 2.00% | |||
$2,627,074 2043 3.00% | |||
$0 2043 | |||
$11,497,075 2.00% | |||
$12,399,481 2043 | |||
$2,388,119 2.00% | |||
$2,575,563 2044 3.00% | |||
$0 2044 | |||
$11,497,075 2.00% | |||
$12,156,354 2044 | |||
$2,388,119 2.00% | |||
$2,525,061 2045 3.00% | |||
$0 2045 | |||
$11,497,075 2.00% | |||
$11,917,994 2045 | |||
$2,388,119 2.00% | |||
$2,475,550 2046 3.00% | |||
$0 2046 | |||
$9,580,896 2.00% | |||
$9,736,923 2046 | |||
$1,990,099 2.00% | |||
$2,022,508 Total: | |||
Total: | |||
Total: | |||
Total: | |||
$832,926,074 | |||
$314,512,050 | |||
$385,722,276 | |||
$132,691,748 Real Rate of Return: | |||
Total Accumulatio Real Rate of Return: | |||
Total Accumulatio North Carolina Qualified North Carolina NonQualified South Carolina and Wholesale If licensee is granted greater than 2% RRR Real Rate of Return: | |||
Total Accumulation}} | |||
Latest revision as of 02:23, 13 January 2025
| ML112370014 | |
| Person / Time | |
|---|---|
| Site: | Harris |
| Issue date: | 11/14/2011 |
| From: | Szabo A Division of Inspection and Regional Support |
| To: | |
| Szabo, A L, NRR/DPR, 415-1985 | |
| References | |
| Download: ML112370014 (5) | |
Text
Datasheet 1 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 1
2
% Owned:
Category:
83.83%
1 16.17%
1 3
4 variable1 3.00%
variable1 Y
N N
Y N
Y 5
6 Any 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 funds of the licensee 2 Effective 2/16/2010, Progress Energy Service Company, LLC engaged Watson Wyatt Investment Consulting, Inc., a Tower Watson company as its new investment advisor.
Towers Watson Advises Progress Energy on its trust investments including its nuclear decommissioning trusts.
Allowed through Decom (Y/N)
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)
N Y2 Plant name:
Harris (Shearon) Nuclear Power Plant 50-400 RAI Needed (Y/N)
PUC Verified (Y/N)
$41,023,543 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 Y
$447.1million 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
$275,586,156 Real Rate of Return PUC Verified (Y/N)
North Carolina Municipal Power Agency Progress Energy Carolinas, Inc.
Licensee:
$234,562,613 Amount in Trust Fund:
Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:
12 10 PWR 2900
$100,520,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 83.83%
1 16.17%
1 2%
35.81 See Annuity Sheet See Annuity Sheet 2%
7
$1,472,125,193 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:
$275,586,156 Decom Period:
See Total Step 2 Total Annuity Real Rate of Return per year Total Fund Balance:
$275,586,156 Total Step 1 + Step 2
$1,370,256,445 Total Annuity:
Step 3:
$41,023,543
$234,562,613 Amount in Trust Fund:
$810,156,818 Total Earnings:
$560,099,627 Real Rate of Return per year Latest Month Px Amount of NRC Minimum/Site Specific:
BWR/PWR MWth Progress Energy Carolinas, Inc.
North Carolina Municipal Power Agency
$72,268,426 Fx Site Specific:
Total Step 2:
Years Left in License N/A Real Rate of Return per year Does Licensee Pass:
YES See Total Step 2 2010 Year:
Harris (Shearon) Nuclear Power Plant Docket Number:
Date of Operation:
Latest Month Fx
$1,370,256,445 Years remaining after annuity Px 50-400 24 31 Termination of Operations:
2046 1986$
Day Base Fx Plant name:
Value of Annuity per year (amount/See Annuity Sheet)
Licensee:
$374,660,617 Bx Ex Lx ECI Base Lx Base Px NRC Minimum:
$446,929,043 Trust Fund Balance:
Step 1:
$101,868,747 Total Earnings for Decom:
Decom Period:
Total Earnings:
Real Rate of Return per year
Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio Month:
12 10 2010 Year:
Harris (Shearon) Nuclear Power Plant Docket Number:
Date of Operation:
50-400 24 31 Termination of Operations:
2046 Day Plant name:
3.00%
35.81 2.00%
See Annuity Sheet See Annuity Sheet 2.00%
7 Accumulation:
Value of Annuity per year North Carolina Qualified Fund Total Annuity:
Number of Annual Payments:
Step 5:
$681,201,121 If licensee is granted greater than 2% RRR Real Rate of Return Years Left in Trust Fund Balance:
YES
$112,564,506 Total Step 5 Total of Steps 4 thru 6:
$1,626,691,701 Does Licensee Pass:
Total Earnings:
N/A 0
$1,514,127,194 see annuity sheet See Total Step 4 Decom Period:
Step 6:
$1,514,127,194 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 Total Earnings:
Type of Fund Real Rate of Return per year Shortfall:
NO Real Rate of Return per year Years remaining after annuity
$832,926,074 Earnings Credit:
Step 4:
Does Licensee Pass:
$142,471,204 YES All Others
$133,114,952
Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 10 24 2046 Year Annuity:
2011
$17,538,171 2%
$35,645,600 2012
$16,706,579 2%
$33,289,632 2013
$16,706,579 2%
$32,636,894 2014
$16,706,579 2%
$31,996,955 2015
$16,706,579 2%
$31,369,563 2016
$16,706,579 2%
$30,754,474 2017
$16,706,579 2%
$30,151,445 2018
$14,885,194 2%
$26,337,523 2019
$14,885,194 2%
$25,821,101 2020
$14,885,194 2%
$25,314,805 2021
$14,885,194 2%
$24,818,436 2022
$14,885,194 2%
$24,331,800 2023
$14,885,194 2%
$23,854,706 2024
$14,885,194 2%
$23,386,967 2025
$14,885,194 2%
$22,928,399 2026
$14,885,194 2%
$22,478,822 2027
$14,885,194 2%
$22,038,061 2028
$14,885,194 2%
$21,605,942 2029
$14,885,194 2%
$21,182,296 2030
$14,885,194 2%
$20,766,957 2031
$14,885,194 2%
$20,359,762 2032
$14,885,194 2%
$19,960,551 2033
$14,885,194 2%
$19,569,168 2034
$14,885,194 2%
$19,185,458 2035
$14,885,194 2%
$18,809,273 2036
$14,885,194 2%
$18,440,464 2037
$14,885,194 2%
$18,078,886 2038
$14,885,194 2%
$17,724,398 2039
$14,885,194 2%
$17,376,861 2040
$14,885,194 2%
$17,036,138 2041
$14,885,194 2%
$16,702,096 2042
$14,885,194 2%
$16,374,604 2043
$14,885,194 2%
$16,053,533 2044
$14,885,194 2%
$15,738,758 2045
$14,885,194 2%
$15,430,155 2046
$12,404,328 2%
$12,606,335 Total:
$810,156,818 ANNUITY Total Accumulation Termination of Operations:
Real Rate of Return:
Datasheet 2 Signature: Aaron L. Szabo Date: 7/26/2011 Signature: Jo Ann Simpson Date: 8/10/2011 Spreadsheet created by: Aaron Szabo, Shawn Harwell Formulas verified by: Clayton Pittiglio 10 24 2046 ANNUITY Termination of Operations:
Year Annuity:
Year Annuity:
Year Annuity:
2011
$8,433,298 3.00%
$24,309,293 2011
$4,370,492 2.00%
$8,882,842 2011
$2,902,789 2.00%
$5,899,797 2012
$8,433,298 3.00%
$23,601,255 2012
$4,370,492 2.00%
$8,708,669 2012
$2,902,789 2.00%
$5,784,115 2013
$8,433,298 3.00%
$22,913,840 2013
$4,370,492 2.00%
$8,537,911 2013
$2,902,789 2.00%
$5,670,701 2014
$8,433,298 3.00%
$22,246,446 2014
$4,370,492 2.00%
$8,370,501 2014
$2,902,789 2.00%
$5,559,511 2015
$8,433,298 3.00%
$21,598,492 2015
$4,370,492 2.00%
$8,206,373 2015
$2,902,789 2.00%
$5,450,501 2016
$8,433,298 3.00%
$20,969,409 2016
$4,370,492 2.00%
$8,045,464 2016
$2,902,789 2.00%
$5,343,628 2017
$8,433,298 3.00%
$20,358,650 2017
$4,370,492 2.00%
$7,887,710 2017
$2,902,789 2.00%
$5,238,851 2018
$8,433,298 3.00%
$19,765,679 2018
$3,063,777 2.00%
$5,420,977 2018
$2,388,119 2.00%
$4,225,483 2019
$8,433,298 3.00%
$19,189,980 2019
$3,063,777 2.00%
$5,314,684 2019
$2,388,119 2.00%
$4,142,631 2020
$8,433,298 3.00%
$18,631,049 2020
$3,063,777 2.00%
$5,210,474 2020
$2,388,119 2.00%
$4,061,403 2021
$8,433,298 3.00%
$18,088,397 2021
$3,063,777 2.00%
$5,108,308 2021
$2,388,119 2.00%
$3,981,767 2022
$8,433,298 3.00%
$17,561,550 2022
$3,063,777 2.00%
$5,008,145 2022
$2,388,119 2.00%
$3,903,693 2023
$8,433,298 3.00%
$17,050,049 2023
$3,063,777 2.00%
$4,909,946 2023
$2,388,119 2.00%
$3,827,150 2024
$8,433,298 3.00%
$16,553,445 2024
$3,063,777 2.00%
$4,813,673 2024
$2,388,119 2.00%
$3,752,108 2025
$8,433,298 3.00%
$16,071,306 2025
$3,063,777 2.00%
$4,719,287 2025
$2,388,119 2.00%
$3,678,538 2026
$8,433,298 3.00%
$15,603,210 2026
$3,063,777 2.00%
$4,626,752 2026
$2,388,119 2.00%
$3,606,409 2027 3.00%
$0 2027
$11,497,075 2.00%
$17,021,830 2027
$2,388,119 2.00%
$3,535,695 2028 3.00%
$0 2028
$11,497,075 2.00%
$16,688,069 2028
$2,388,119 2.00%
$3,466,368 2029 3.00%
$0 2029
$11,497,075 2.00%
$16,360,852 2029
$2,388,119 2.00%
$3,398,400 2030 3.00%
$0 2030
$11,497,075 2.00%
$16,040,051 2030
$2,388,119 2.00%
$3,331,765 2031 3.00%
$0 2031
$11,497,075 2.00%
$15,725,540 2031
$2,388,119 2.00%
$3,266,436 2032 3.00%
$0 2032
$11,497,075 2.00%
$15,417,196 2032
$2,388,119 2.00%
$3,202,388 2033 3.00%
$0 2033
$11,497,075 2.00%
$15,114,898 2033
$2,388,119 2.00%
$3,139,596 2034 3.00%
$0 2034
$11,497,075 2.00%
$14,818,527 2034
$2,388,119 2.00%
$3,078,036 2035 3.00%
$0 2035
$11,497,075 2.00%
$14,527,968 2035
$2,388,119 2.00%
$3,017,682 2036 3.00%
$0 2036
$11,497,075 2.00%
$14,243,106 2036
$2,388,119 2.00%
$2,958,512 2037 3.00%
$0 2037
$11,497,075 2.00%
$13,963,829 2037
$2,388,119 2.00%
$2,900,502 2038 3.00%
$0 2038
$11,497,075 2.00%
$13,690,029 2038
$2,388,119 2.00%
$2,843,629 2039 3.00%
$0 2039
$11,497,075 2.00%
$13,421,597 2039
$2,388,119 2.00%
$2,787,872 2040 3.00%
$0 2040
$11,497,075 2.00%
$13,158,428 2040
$2,388,119 2.00%
$2,733,208 2041 3.00%
$0 2041
$11,497,075 2.00%
$12,900,420 2041
$2,388,119 2.00%
$2,679,615 2042 3.00%
$0 2042
$11,497,075 2.00%
$12,647,470 2042
$2,388,119 2.00%
$2,627,074 2043 3.00%
$0 2043
$11,497,075 2.00%
$12,399,481 2043
$2,388,119 2.00%
$2,575,563 2044 3.00%
$0 2044
$11,497,075 2.00%
$12,156,354 2044
$2,388,119 2.00%
$2,525,061 2045 3.00%
$0 2045
$11,497,075 2.00%
$11,917,994 2045
$2,388,119 2.00%
$2,475,550 2046 3.00%
$0 2046
$9,580,896 2.00%
$9,736,923 2046
$1,990,099 2.00%
$2,022,508 Total:
Total:
Total:
Total:
$832,926,074
$314,512,050
$385,722,276
$132,691,748 Real Rate of Return:
Total Accumulatio Real Rate of Return:
Total Accumulatio North Carolina Qualified North Carolina NonQualified South Carolina and Wholesale If licensee is granted greater than 2% RRR Real Rate of Return:
Total Accumulation