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 14T&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 14weighted 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 14year 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 14weighted 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 14year 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 14weighted 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 14year 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 14discounted

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 14discounted

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 14weighted AIF inputs (updated 9/19/10)

Region 2013 2018 2023Total 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 14year 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 14weighted 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 14year 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