T&E calcs_032111.xls

Author: Abt Associates Inc.

Created: 03/21/11

Updated: 03/22/11

Worksheet Description

Inputs and Summary

Summary of I&E inputs for T&E species and WTP

results

baseline

Calculations for the elimination of baseline T&E

losses

option 1 Calculations for T&E benefits under option 1

option 2 Calculations for T&E benefits under option 2

option 3 Calculations for T&E benefits under option 3

option 4 Calculations for T&E benefits under option 4

File Info 1 of 14
T&E Valuation Inputs and Summary

Species

Benefits

Region baseline option 1 option 2 option 3 option 4

paddlefish inland 17627.71811 8630.605452 15945.667 16317.38896 8419.90307

pallid.sturgeon inland 87.83186854 73.47892973 84.89591593 85.72126057 71.68505957

total inland (a1e) 17715.55 8704.08 16030.56 16403.11 8491.59

paddlefish inland $1,231,825 $603,107 $1,114,283 $1,140,259 $588,383

pallid.sturgeon inland $6,138 $5,135 $5,933 $5,990 $5,009

total inland WTP 69.88 $1,237,963 $608,241 $1,120,216 $1,146,249 $593,392

Inputs and Summary 2 of 14
weighted AIF inputs (updated 9/19/10)

Region 2012 Total

Inland 136,561 136,561

Annualized Results (2009$)

Region 3% discount rate 7% discount rate

Inland $1,144,262 $1,139,963

National total $1,144,262 $1,139,963

year period df (3%) df (7%)

baseline bio

schedule

AIF in

compliance

% of total

AIF

discounted

benefits (3%)

discounted

benefits (7%)

2012 0 1 1 0.1 13,656 0.1 123796.2632 123796.2632

2013 1 0.970873786 0.934579439 0.2 27,312 0.2 240381.0937 231394.8845

2014 2 0.942595909 0.873438728 0.8 109,249 0.8 933518.8103 865027.6058

2015 3 0.915141659 0.816297877 0.9 122,905 0.9 1019620.06 909491.6416

2016 4 0.888487048 0.762895212 0.95 129,733 0.95 1044918.076 897213.9766

2017 5 0.862608784 0.712986179 1 136,561 1 1067877.441 882650.2475

2018 6 0.837484257 0.666342224 1 136,561 1 1036774.215 824906.7734

2019 7 0.813091511 0.622749742 1 136,561 1 1006576.908 770940.9097

2020 8 0.789409234 0.582009105 1 136,561 1 977259.1337 720505.5231

2021 9 0.766416732 0.543933743 1 136,561 1 948795.2754 673369.6478

2022 10 0.744093915 0.508349292 1 136,561 1 921160.4616 629317.4278

2023 11 0.722421277 0.475092796 1 136,561 1 894330.5452 588147.1288

2024 12 0.70137988 0.444011959 1 136,561 1 868282.0827 549670.2138

2025 13 0.68095134 0.414964448 1 136,561 1 842992.3133 513710.4802

2026 14 0.661117806 0.387817241 1 136,561 1 818439.1392 480103.2525

2027 15 0.641861947 0.36244602 1 136,561 1 794601.106 448694.6285

2028 16 0.623166939 0.338734598 1 136,561 1 771457.3844 419340.7743

2029 17 0.605016446 0.31657439 1 136,561 1 748987.7519 391907.2657

2030 18 0.587394608 0.295863916 1 136,561 1 727172.5746 366268.4727

2031 19 0.570286027 0.276508333 1 136,561 1 705992.7909 342306.9838

2032 20 0.553675754 0.258419003 1 136,561 1 685429.8941 319913.069

2033 21 0.537549276 0.241513087 1 136,561 1 665465.9166 298984.1766

2034 22 0.521892501 0.225713165 1 136,561 1 646083.4142 279424.4641

2035 23 0.506691748 0.210946883 1 136,561 1 627265.4507 261144.359

Discounting Calcs Inland Region

baseline 3 of 14
year period df (3%) df (7%)

baseline bio

schedule

AIF in

compliance

% of total

AIF

discounted

benefits (3%)

discounted

benefits (7%)

Discounting Calcs Inland Region

2036 24 0.491933736 0.19714662 1 136,561 1 608995.5832 244060.1486

2037 25 0.477605569 0.184249178 1 136,561 1 591257.8477 228093.5968

2038 26 0.463694727 0.172195493 1 136,561 1 574036.7454 213171.5858

2039 27 0.450189056 0.160930367 1 136,561 1 557317.2285 199225.7811

2040 28 0.437076753 0.150402212 1 136,561 1 541084.6879 186192.3188

2041 29 0.424346362 0.140562815 1 136,561 1 525324.9397 174011.5129

2042 30 0.41198676 0.131367117 1 136,561 1 510024.2133 162627.5822

2043 31 0.399987145 0.122773007 1 136,561 1 495169.1391 151988.3945

2044 32 0.388337034 0.114741128 1 136,561 1 480746.737 142045.2285

2045 33 0.377026247 0.107234699 1 136,561 1 466744.4049 132752.55

2046 34 0.3660449 0.100219345 1 136,561 1 453149.9076 124067.8038

2047 35 0.355383398 0.093662939 1 136,561 1 439951.3666 115951.2185

2048 36 0.345032425 0.087535457 1 136,561 1 427137.2492 108365.6247

2049 37 0.334982937 0.081808838 1 136,561 1 414696.3584 101276.2848

2050 38 0.325226152 0.076456858 1 136,561 1 402617.8237 94650.73346

2051 39 0.315753546 0.071455008 1 136,561 1 390891.091 88458.62941

2052 40 0.306556841 0.066780381 1 136,561 1 379505.9136 82671.61627

2053 41 0.297628001 0.062411571 1 136,561 1 368452.3433 77263.19277

2054 42 0.288959224 0.058328571 1 136,561 1 357720.7216 72208.59138

2055 43 0.280542936 0.054512683 1 136,561 1 347301.6715 67484.66484

2056 44 0.272371782 0.050946433 1 136,561 1 337186.0888 63069.78022

2057 45 0.264438624 0.047613489 0.9 122,905 0.9 294628.6213 53049.34785

2058 46 0.256736528 0.044498588 0.8 109,249 0.8 254264.1823 44070.0709

2059 47 0.249258765 0.041587465 0.2 27,312 0.2 61714.60736 10296.74554

2060 48 0.241998801 0.03886679 0.1 13,656 0.1 29958.54726 4811.563336

2061 49 0.234950292 0.036324103 0.05 6,828 0.05 14542.98411 2248.394082

2062 50 0.22810708 0.033947759 0 0 0 0 0

2063 51 0.221463184 0.031726878 0 0 0 0 0

2064 52 0.2150128 0.029651288 0 0 0 0 0

2065 53 0.208750292 0.027711484 0 0 0 0 0

baseline 4 of 14
weighted AIF inputs (updated 9/19/10)

Region 2013 Total

Inland 136,561 136,561

Annualized Results (2009$)

Region 3% discount rate 7% discount rate

Inland $497,957 $454,258

National total $497,957 $454,258

year period df (3%) df (7%)

Option 1 sched

(all 2013)

AIF in

compliance

% of total

AIF

discounted

benefits (3%)

discounted

benefits (7%)

2012 0 1.00 1.00 0.00 0 0 0 0

2013 1 0.97 0.93 0.02 2731.221414 0.02 11810.51294 11368.99844

2014 2 0.94 0.87 0.06 8193.664241 0.06 34399.55226 31875.69657

2015 3 0.92 0.82 0.22 30043.43555 0.22 122457.953 109231.3589

2016 4 0.89 0.76 0.40 54624.42827 0.4 216165.8483 185609.7858

2017 5 0.86 0.71 0.59 80571.0317 0.59 309557.8895 255863.9571

2018 6 0.84 0.67 0.77 105152.0244 0.77 392232.3102 312078.6424

2019 7 0.81 0.62 0.93 127001.7957 0.93 459937.0174 352267.4322

2020 8 0.79 0.58 0.97 132464.2386 0.97 465746.8492 343381.981

2021 9 0.77 0.54 0.99 135195.46 0.99 461504.735 327534.5998

2022 10 0.74 0.51 1.00 136561.0707 1 452588.7369 309199.0936

2023 11 0.72 0.48 1.00 136561.0707 1 439406.5407 288971.1155

2024 12 0.70 0.44 1.00 136561.0707 1 426608.2919 270066.4631

2025 13 0.68 0.41 1.00 136561.0707 1 414182.8077 252398.5636

2026 14 0.66 0.39 1.00 136561.0707 1 402119.2308 235886.5081

2027 15 0.64 0.36 1.00 136561.0707 1 390407.0202 220454.6804

2028 16 0.62 0.34 1.00 136561.0707 1 379035.9419 206032.4116

2029 17 0.61 0.32 1.00 136561.0707 1 367996.0601 192553.6557

2030 18 0.59 0.30 1.00 136561.0707 1 357277.7283 179956.6876

2031 19 0.57 0.28 1.00 136561.0707 1 346871.5808 168183.8202

2032 20 0.55 0.26 1.00 136561.0707 1 336768.5251 157181.1404

2033 21 0.54 0.24 1.00 136561.0707 1 326959.7331 146898.262

2034 22 0.52 0.23 1.00 136561.0707 1 317436.6341 137288.0953

Discounting Calcs Inland

option 1 5 of 14
year period df (3%) df (7%)

Option 1 sched

(all 2013)

AIF in

compliance

% of total

AIF

discounted

benefits (3%)

discounted

benefits (7%)

Discounting Calcs Inland

2035 23 0.51 0.21 1.00 136561.0707 1 308190.9069 128306.6312

2036 24 0.49 0.20 1.00 136561.0707 1 299214.4727 119912.7394

2037 25 0.48 0.18 1.00 136561.0707 1 290499.488 112067.9807

2038 26 0.46 0.17 1.00 136561.0707 1 282038.3379 104736.4306

2039 27 0.45 0.16 1.00 136561.0707 1 273823.629 97884.51459

2040 28 0.44 0.15 1.00 136561.0707 1 265848.1835 91480.85475

2041 29 0.42 0.14 1.00 136561.0707 1 258105.0325 85496.12594

2042 30 0.41 0.13 1.00 136561.0707 1 250587.4102 79902.92144

2043 31 0.40 0.12 1.00 136561.0707 1 243288.7478 74675.62751

2044 32 0.39 0.11 1.00 136561.0707 1 236202.6678 69790.30608

2045 33 0.38 0.11 1.00 136561.0707 1 229322.9784 65224.58513

2046 34 0.37 0.10 1.00 136561.0707 1 222643.6684 60957.55619

2047 35 0.36 0.09 1.00 136561.0707 1 216158.9013 56969.67868

2048 36 0.35 0.09 1.00 136561.0707 1 209863.011 53242.69036

2049 37 0.33 0.08 1.00 136561.0707 1 203750.4961 49759.5237

2050 38 0.33 0.08 1.00 136561.0707 1 197816.0156 46504.22776

2051 39 0.32 0.07 1.00 136561.0707 1 192054.3841 43461.8951

2052 40 0.31 0.07 1.00 136561.0707 1 186460.5671 40618.59355

2053 41 0.30 0.06 1.00 136561.0707 1 181029.6768 37961.30238

2054 42 0.29 0.06 1.00 136561.0707 1 175756.9678 35477.8527

2055 43 0.28 0.05 1.00 136561.0707 1 170637.8328 33156.87168

2056 44 0.27 0.05 1.00 136561.0707 1 165667.7988 30987.73054

2057 45 0.26 0.05 0.90 122904.9636 0.9 144758.2708 26064.44625

2058 46 0.26 0.04 0.80 109248.8565 0.8 124926.2316 21652.70716

2059 47 0.25 0.04 0.20 27312.21414 0.2 30321.90086 5059.04373

2060 48 0.24 0.04 0.10 13656.10707 0.1 14719.36935 2364.039126

2061 49 0.23 0.04 0.05 6828.053534 0.05 7145.324928 1104.69118

2062 50 0.23 0.03 0.00 0 0 0 0

2063 51 0.22 0.03 0.00 0 0 0 0

2064 52 0.22 0.03 0.00 0 0 0 0

2065 53 0.21 0.03 0.00 0 0 0 0

option 1 6 of 14
weighted AIF inputs (updated 9/19/10)

Region 2013 2018 2023 Total

Inland 12,244 91,382 32,935 136,561

Annualized Results (2009$)

Region 3% discount rate 7% discount rate

Inland $718,987 $560,720

National total $718,987 $560,720

0.72 0.56

year period df (3%) df (7%)

2013

schd

2018

schd

2023

schd

AIF in

compliance

% of total

AIF

discounted

benefits (3%)

2012 0 1.000 1.000 0.00 0 0 0 0.0000 0

2013 1 0.971 0.935 0.02 0 0 244.8848581 0.0018 1950.291212

2014 2 0.943 0.873 0.06 0 0 734.6545744 0.0054 5680.459842

2015 3 0.915 0.816 0.22 0 0 2693.733439 0.0197 20221.7017

2016 4 0.888 0.763 0.40 0 0 4897.697162 0.0359 35695.85473

2017 5 0.863 0.713 0.59 0 0 7224.103315 0.0529 51117.85021

2018 6 0.837 0.666 0.77 0.02 0 11255.70827 0.0824 77325.76699

2019 7 0.813 0.623 0.93 0.06 0 16870.06961 0.1235 112520.3457

2020 8 0.789 0.582 0.97 0.22 0 31980.9692 0.2342 207094.507

2021 9 0.766 0.544 0.99 0.40 0 48674.62517 0.3564 306014.7427

2022 10 0.744 0.508 1.00 0.59 0 66159.65933 0.4845 403827.3876

2023 11 0.722 0.475 1.00 0.77 0.02 83267.12577 0.6097 493445.12

2024 12 0.701 0.444 1.00 0.93 0.06 99205.64629 0.7265 570774.3531

2025 13 0.681 0.415 1.00 0.97 0.22 108130.4913 0.7918 604002.8828

2026 14 0.661 0.388 1.00 0.99 0.40 115886.3904 0.8486 628472.1632

2027 15 0.642 0.362 1.00 1.00 0.59 123057.8166 0.9011 647926.2733

2028 16 0.623 0.339 1.00 1.00 0.77 128986.0745 0.9445 659359.0733

2029 17 0.605 0.317 1.00 1.00 0.93 134255.6371 0.9831 666307.1382

2030 18 0.587 0.296 1.00 1.00 0.97 135573.0277 0.9928 653247.8765

2031 19 0.570 0.277 1.00 1.00 0.99 136231.723 0.9976 637302.6676

2032 20 0.554 0.258 1.00 1.00 1.00 136561.0707 1.0000 620236.2929

2033 21 0.538 0.242 1.00 1.00 1.00 136561.0707 1.0000 602171.1582

2034 22 0.522 0.226 1.00 1.00 1.00 136561.0707 1.0000 584632.1924

Discounting Calcs Inland

option 2 7 of 14
year period df (3%) df (7%)

2013

schd

2018

schd

2023

schd

AIF in

compliance

% of total

AIF

discounted

benefits (3%)

Discounting Calcs Inland

2035 23 0.507 0.211 1.00 1.00 1.00 136561.0707 1.0000 567604.0703

2036 24 0.492 0.197 1.00 1.00 1.00 136561.0707 1.0000 551071.9129

2037 25 0.478 0.184 1.00 1.00 1.00 136561.0707 1.0000 535021.2747

2038 26 0.464 0.172 1.00 1.00 1.00 136561.0707 1.0000 519438.1308

2039 27 0.450 0.161 1.00 1.00 1.00 136561.0707 1.0000 504308.8648

2040 28 0.437 0.150 1.00 1.00 1.00 136561.0707 1.0000 489620.2571

2041 29 0.424 0.141 1.00 1.00 1.00 136561.0707 1.0000 475359.4729

2042 30 0.412 0.131 1.00 1.00 1.00 136561.0707 1.0000 461514.0514

2043 31 0.400 0.123 1.00 1.00 1.00 136561.0707 1.0000 448071.8945

2044 32 0.388 0.115 1.00 1.00 1.00 136561.0707 1.0000 435021.2568

2045 33 0.377 0.107 1.00 1.00 1.00 136561.0707 1.0000 422350.7348

2046 34 0.366 0.100 1.00 1.00 1.00 136561.0707 1.0000 410049.2571

2047 35 0.355 0.094 1.00 1.00 1.00 136561.0707 1.0000 398106.0748

2048 36 0.345 0.088 1.00 1.00 1.00 136561.0707 1.0000 386510.7523

2049 37 0.335 0.082 1.00 1.00 1.00 136561.0707 1.0000 375253.1575

2050 38 0.325 0.076 1.00 1.00 1.00 136561.0707 1.0000 364323.4539

2051 39 0.316 0.071 1.00 1.00 1.00 136561.0707 1.0000 353712.0912

2052 40 0.307 0.067 1.00 1.00 1.00 136561.0707 1.0000 343409.7973

2053 41 0.298 0.062 1.00 1.00 1.00 136561.0707 1.0000 333407.5702

2054 42 0.289 0.058 1.00 1.00 1.00 136561.0707 1.0000 323696.6701

2055 43 0.281 0.055 1.00 1.00 1.00 136561.0707 1.0000 314268.6117

2056 44 0.272 0.051 1.00 1.00 1.00 136561.0707 1.0000 305115.157

2057 45 0.264 0.048 0.90 0.90 0.90 122904.9636 0.9000 266605.477

2058 46 0.257 0.044 0.80 0.80 0.80 109248.8565 0.8000 230080.239

2059 47 0.249 0.042 0.20 0.20 0.20 27312.21414 0.2000 55844.71821

2060 48 0.242 0.039 0.10 0.10 0.10 13656.10707 0.1000 27109.08651

2061 49 0.235 0.036 0.05 0.05 0.05 6828.053534 0.0500 13159.75073

2062 50 0.228 0.034 0.00 0.00 0.00 0 0.0000 0

2063 51 0.221 0.032 0.00 0.00 0.00 0 0.0000 0

2064 52 0.215 0.030 0.00 0.00 0.00 0 0.0000 0

2065 53 0.209 0.028 0.00 0.00 0.00 0 0.0000 0

option 2 8 of 14
discounted

benefits (7%)

0

1877.38313

5263.691018

18037.57047

30650.07726

42251.27472

61524.0503

86179.74148

152684.9235

217181.7723

275886.3666

324509.022

361331.4923

368072.8828

368667.0337

365870.4177

358407.5413

348644.6982

329033.4514

309001.9568

289485.0336

270546.7604

252847.4396

option 2 9 of 14
discounted

benefits (7%)

236306.0184

220846.7461

206398.8282

192896.1011

180276.73

168482.9252

157460.6778

147159.5119

137532.2541

128534.817

120125.9972

112267.2871

104922.6982

98058.59644

91643.54808

85648.17577

80045.02409

74808.43372

69914.42404

65340.58322

61065.96562

57070.99591

48003.64142

39878.41447

9317.386559

4353.918953

2034.541567

0

0

0

0

option 2 10 of 14
weighted AIF inputs (updated 9/19/10)

Region 2013 2018 2023 Total

Inland 4114 93282 39165 136561

Annualized Results (2009$)

Region 3% discount rate 7% discount rate

Inland $717,770 $549,735

National total $717,770 $549,735

0.72 0.55

year period df (3%) df (7%)

2013

schd

2018

schd

2023

schd

AIF in

compliance

% of total

AIF

discounted

benefits (3%)

discounted

benefits (7%)

2012 0 1.0000 1.0000 0.00 0 0 0 0 0 0

2013 1 0.9709 0.9346 0.02 0 0 82.27163604 0.000602453 670.4479933 645.3845169

2014 2 0.9426 0.8734 0.06 0 0 246.8149081 0.001807359 1952.761146 1809.4893

2015 3 0.9151 0.8163 0.22 0 0 904.9879965 0.006626984 6951.576893 6200.742149

2016 4 0.8885 0.7629 0.40 0 0 1645.432721 0.012049061 12271.09778 10536.52022

2017 5 0.8626 0.7130 0.59 0 0 2427.013263 0.017772366 17572.68857 14524.64236

2018 6 0.8375 0.6663 0.77 0.02 0 5033.102477 0.036856056 35380.55254 28150.44685

2019 7 0.8131 0.6227 0.93 0.06 0 9422.564545 0.068998906 64307.36792 49253.24667

2020 8 0.7894 0.5820 0.97 0.22 0 24512.26374 0.179496716 162419.3654 119747.205

2021 9 0.7664 0.5439 0.99 0.40 0 41385.33578 0.303053686 266234.0796 188949.0315

2022 10 0.7441 0.5083 1.00 0.59 0 59150.09425 0.433140235 369432.7393 252388.6673

2023 11 0.7224 0.4751 1.00 0.77 0.02 76724.19995 0.561830685 465237.8959 305958.8361

2024 12 0.7014 0.4440 1.00 0.93 0.06 93215.96644 0.682595457 548776.8675 347405.8766

2025 13 0.6810 0.4150 1.00 0.97 0.22 103213.6977 0.755806155 589936.9552 359501.2573

2026 14 0.6611 0.3878 1.00 0.99 0.40 112129.0898 0.821091174 622227.6947 365003.9762

2027 15 0.6419 0.3624 1.00 1.00 0.59 120503.3123 0.882413353 649221.3602 366601.7261

2028 16 0.6232 0.3387 1.00 1.00 0.77 127553.0599 0.934036759 667186.8414 362662.478

2029 17 0.6050 0.3166 1.00 1.00 0.93 133819.5022 0.979924231 679577.1631 355588.2285

2030 18 0.5874 0.2959 1.00 1.00 0.97 135386.1127 0.991396099 667507.67 336215.9456

2031 19 0.5703 0.2765 1.00 1.00 0.99 136169.418 0.997132033 651815.2217 316038.4998

2032 20 0.5537 0.2584 1.00 1.00 1.00 136561.0707 1 634650.4689 296212.6119

2033 21 0.5375 0.2415 1.00 1.00 1.00 136561.0707 1 616165.5038 276834.2168

2034 22 0.5219 0.2257 1.00 1.00 1.00 136561.0707 1 598218.9357 258723.5671

Discounting Calcs Inland Region

option 3 11 of 14
year period df (3%) df (7%)

2013

schd

2018

schd

2023

schd

AIF in

compliance

% of total

AIF

discounted

benefits (3%)

discounted

benefits (7%)

Discounting Calcs Inland Region

2035 23 0.5067 0.2109 1.00 1.00 1.00 136561.0707 1 580795.0832 241797.7262

2036 24 0.4919 0.1971 1.00 1.00 1.00 136561.0707 1 563878.7216 225979.1834

2037 25 0.4776 0.1842 1.00 1.00 1.00 136561.0707 1 547455.0695 211195.4985

2038 26 0.4637 0.1722 1.00 1.00 1.00 136561.0707 1 531509.7762 197378.9706

2039 27 0.4502 0.1609 1.00 1.00 1.00 136561.0707 1 516028.9089 184466.3276

2040 28 0.4371 0.1504 1.00 1.00 1.00 136561.0707 1 500998.9407 172398.437

2041 29 0.4243 0.1406 1.00 1.00 1.00 136561.0707 1 486406.7385 161120.0346

2042 30 0.4120 0.1314 1.00 1.00 1.00 136561.0707 1 472239.552 150579.4716

2043 31 0.4000 0.1228 1.00 1.00 1.00 136561.0707 1 458485.0019 140728.4781

2044 32 0.3883 0.1147 1.00 1.00 1.00 136561.0707 1 445131.0698 131521.9422

2045 33 0.3770 0.1072 1.00 1.00 1.00 136561.0707 1 432166.0872 122917.703

2046 34 0.3660 0.1002 1.00 1.00 1.00 136561.0707 1 419578.7255 114876.3579

2047 35 0.3554 0.0937 1.00 1.00 1.00 136561.0707 1 407357.9859 107361.0822

2048 36 0.3450 0.0875 1.00 1.00 1.00 136561.0707 1 395493.1902 100337.46

2049 37 0.3350 0.0818 1.00 1.00 1.00 136561.0707 1 383973.971 93773.32707

2050 38 0.3252 0.0765 1.00 1.00 1.00 136561.0707 1 372790.2631 87638.62343

2051 39 0.3158 0.0715 1.00 1.00 1.00 136561.0707 1 361932.2943 81905.25554

2052 40 0.3066 0.0668 1.00 1.00 1.00 136561.0707 1 351390.577 76546.96779

2053 41 0.2976 0.0624 1.00 1.00 1.00 136561.0707 1 341155.9 71539.22224

2054 42 0.2890 0.0583 1.00 1.00 1.00 136561.0707 1 331219.3204 66859.0862

2055 43 0.2805 0.0545 1.00 1.00 1.00 136561.0707 1 321572.1557 62485.12729

2056 44 0.2724 0.0509 1.00 1.00 1.00 136561.0707 1 312205.9764 58397.31523

2057 45 0.2644 0.0476 0.90 0.90 0.90 122904.9636 0.9 272801.3386 49119.23711

2058 46 0.2567 0.0445 0.80 0.80 0.80 109248.8565 0.8 235427.261 40805.1814

2059 47 0.2493 0.0416 0.20 0.20 0.20 27312.21414 0.2 57142.53907 9533.920887

2060 48 0.2420 0.0389 0.10 0.10 0.10 13656.10707 0.1 27739.09663 4455.103218

2061 49 0.2350 0.0363 0.05 0.05 0.05 6828.053534 0.05 13465.58089 2081.823934

2062 50 0.2281 0.0339 0.00 0.00 0.00 0 0 0 0

2063 51 0.2215 0.0317 0.00 0.00 0.00 0 0 0 0

2064 52 0.2150 0.0297 0.00 0.00 0.00 0 0 0 0

2065 53 0.2088 0.0277 0.00 0.00 0.00 0 0 0 0

option 3 12 of 14
weighted AIF inputs (updated 9/19/10)

Region 2013 Total

Inland 136,561 136,561

Annualized Results (2009$)

Region 3% discount rate 7% discount rate

Inland $485,800 $443,168

National total $485,800 $443,168

0.49 0.44

year period df (3%) df (7%)

Option 4

sched (all

2013)

AIF in

compliance

% of total

AIF

discounted

benefits (3%)

discounted

benefits (7%)

2012 0 1.00 1.00 0.00 0 0 0 0

2013 1 0.97 0.93 0.02 2731.221414 0.02 11522.17822 11091.44259

2014 2 0.94 0.87 0.06 8193.664241 0.06 33559.7424 31097.50258

2015 3 0.92 0.82 0.22 30043.43555 0.22 119468.3386 106564.6506

2016 4 0.89 0.76 0.40 54624.42827 0.4 210888.506 181078.4207

2017 5 0.86 0.71 0.59 80571.0317 0.59 302000.5304 249617.4491

2018 6 0.84 0.67 0.77 105152.0244 0.77 382656.5878 304459.7431

2019 7 0.81 0.62 0.93 127001.7957 0.93 448708.3932 343667.3882

2020 8 0.79 0.58 0.97 132464.2386 0.97 454376.3873 334998.8609

2021 9 0.77 0.54 0.99 135195.46 0.99 450237.8375 319538.3682

2022 10 0.74 0.51 1.00 136561.0707 1 441539.5091 301650.4939

2023 11 0.72 0.48 1.00 136561.0707 1 428679.1351 281916.3494

2024 12 0.70 0.44 1.00 136561.0707 1 416193.335 263473.2238

2025 13 0.68 0.41 1.00 136561.0707 1 404071.1991 246236.6577

2026 14 0.66 0.39 1.00 136561.0707 1 392302.135 230127.7175

2027 15 0.64 0.36 1.00 136561.0707 1 380875.8592 215072.6332

2028 16 0.62 0.34 1.00 136561.0707 1 369782.3876 201002.4609

2029 17 0.61 0.32 1.00 136561.0707 1 359012.0268 187852.7672

2030 18 0.59 0.30 1.00 136561.0707 1 348555.3658 175563.3338

2031 19 0.57 0.28 1.00 136561.0707 1 338403.2678 164077.8821

2032 20 0.55 0.26 1.00 136561.0707 1 328546.8619 153343.815

2033 21 0.54 0.24 1.00 136561.0707 1 318977.5359 143311.9767

2034 22 0.52 0.23 1.00 136561.0707 1 309686.928 133936.4268

Discounting Calcs Inland

option 4 13 of 14
year period df (3%) df (7%)

Option 4

sched (all

2013)

AIF in

compliance

% of total

AIF

discounted

benefits (3%)

discounted

benefits (7%)

Discounting Calcs Inland

2035 23 0.51 0.21 1.00 136561.0707 1 300666.9204 125174.2306

2036 24 0.49 0.20 1.00 136561.0707 1 291909.6315 116985.2623

2037 25 0.48 0.18 1.00 136561.0707 1 283407.4092 109332.0208

2038 26 0.46 0.17 1.00 136561.0707 1 275152.8245 102179.4587

2039 27 0.45 0.16 1.00 136561.0707 1 267138.6645 95494.82123

2040 28 0.44 0.15 1.00 136561.0707 1 259357.9267 89247.49648

2041 29 0.42 0.14 1.00 136561.0707 1 251803.8123 83408.87521

2042 30 0.41 0.13 1.00 136561.0707 1 244469.7207 77952.21983

2043 31 0.40 0.12 1.00 136561.0707 1 237349.2434 72852.54189

2044 32 0.39 0.11 1.00 136561.0707 1 230436.1587 68086.48775

2045 33 0.38 0.11 1.00 136561.0707 1 223724.4259 63632.23154

2046 34 0.37 0.10 1.00 136561.0707 1 217208.1805 59469.37527

2047 35 0.36 0.09 1.00 136561.0707 1 210881.7286 55578.8554

2048 36 0.35 0.09 1.00 136561.0707 1 204739.5423 51942.85551

2049 37 0.33 0.08 1.00 136561.0707 1 198776.2547 48544.72478

2050 38 0.33 0.08 1.00 136561.0707 1 192986.6551 45368.90166

2051 39 0.32 0.07 1.00 136561.0707 1 187365.6845 42400.84267

2052 40 0.31 0.07 1.00 136561.0707 1 181908.4316 39626.95577

2053 41 0.30 0.06 1.00 136561.0707 1 176610.1277 37034.5381

2054 42 0.29 0.06 1.00 136561.0707 1 171466.1434 34611.71785

2055 43 0.28 0.05 1.00 136561.0707 1 166471.9839 32347.39986

2056 44 0.27 0.05 1.00 136561.0707 1 161623.2854 30231.21482

2057 45 0.26 0.05 0.90 122904.9636 0.9 141224.2299 25428.12462

2058 46 0.26 0.04 0.80 109248.8565 0.8 121876.3581 21124.09106

2059 47 0.25 0.04 0.20 27312.21414 0.2 29581.64031 4935.535295

2060 48 0.24 0.04 0.10 13656.10707 0.1 14360.01957 2306.324904

2061 49 0.23 0.04 0.05 6828.053534 0.05 6970.883285 1077.721918

2062 50 0.23 0.03 0.00 0 0 0 0

2063 51 0.22 0.03 0.00 0 0 0 0

2064 52 0.22 0.03 0.00 0 0 0 0

2065 53 0.21 0.03 0.00 0 0 0 0

option 4 14 of 14