Direct Program
Planned
FISH & WILDLIFE INVESTMENT, AMORTIZATION AND INTEREST
($ IN THOUSANDS)
S/L AMORTIZATION ANNUAL ACCUM CUM NET WTD AV
INVEST 1/2 YEAR FULL YR AMORT AMORT INVEST INVEST INT RATE
1985 4,318 144 288 144 144 4,318 4,174 8.95%
1986 5,590 187 373 475 619 9,908 9,289 8.95%
1987 4,710 157 314 818 1,437 14,618 13,181 8.95%
1988 7,726 258 515 1,233 2,670 22,344 19,674 8.95%
1989 8,267 276 551 1,766 4,436 30,611 26,175 8.75%
1990 16,193 540 1,080 2,581 7,017 46,804 39,787 8.45%
1991 17,680 590 1,179 3,711 10,728 64,484 53,756 8.30%
1992 11,178 373 745 4,673 15,401 75,662 60,261 8.23%
1993 17,338 578 1,156 5,623 21,024 93,000 71,976 7.95%
1994 20,487 683 1,366 6,884 27,908 113,487 85,579 7.87%
1995 32,486 1,083 2,166 8,650 36,558 145,973 109,415 7.82%
1996 26,000 867 1,733 10,600 47,158 171,973 124,815 7.83%
1997 28,106 937 1,874 12,403 59,561 200,079 140,518 7.85%
1998 27,000 900 1,800 14,240 73,801 227,079 153,278 7.75%
1999 27,000 900 1,800 16,040 89,841 254,079 164,238 7.68%
2000 27,000 900 1,800 17,696 107,537 281,079 173,542 7.62%
2001 18,681 623 1,245 18,888 122,107 295,442 173,335 7.56%
2002 $34,732 1,158 2,315 20,325 136,842 324,584 187,742 7.42%
2003 $38,317 1,277 2,554 22,344 154,476 358,192 203,716 7.26%
2004 $35,825 1,194 2,388 24,282 171,032 386,291 215,259 7.15%
2005 $33,988 1,133 2,266 25,794 188,559 412,012 223,453 7.06%
2006 $34,182 1,140 2,279 26,937 199,303 430,001 230,698 6.97%
2007 $11,000 367 733 27,481 209,104 423,321 214,217 6.94%
2008 $11,000 367 733 27,264 225,190 423,143 197,953 6.91%
2009 $11,000 367 733 26,736 234,588 416,805 182,217 6.88%
2010 $11,000 367 733 25,703 239,804 407,318 167,514 6.84%
2011 $11,000 367 733 24,486 231,804 385,832 154,028 6.80%
2012 $11,000 367 733 23,416 229,220 370,832 141,612 6.76%
Page 1
Direct Program
D INTEREST
Int on Int on New
Prev Amt New Amt INTEREST Int Rates
0 193 193 8.95%
348 250 598 8.95%
831 211 1,042 8.95%
1,180 346 1,525 8.95%
1,761 342 2,103 8.27%
2,291 644 2,935 7.95%
3,363 703 4,066 7.95%
4,463 441 4,904 7.89%
4,961 602 5,564 6.95%
5,725 776 6,501 7.58%
6,738 1,249 7,987 7.69%
8,561 1,019 9,580 7.84%
9,769 1,120 10,889 7.97%
11,034 968 12,002 7.17%
11,872 987 12,859 7.31%
12,617 977 13,594 7.24%
13,227 646 13,873 6.92%
13,096 1,162 14,258 6.69%
13,921 1,245 15,166 6.50%
14,798 1,161 15,959 6.48%
15,392 1,094 16,486 6.44%
15,767 1,090 16,858 6.38%
16,078 349 16,426 6.34%
14,870 346 15,216 6.29%
13,680 343 14,022 6.23%
12,529 340 12,869 6.18%
11,454 339 11,793 6.16%
10,469 338 10,808 6.15%
Page 2
Capital Investment
Spreadsheet for Hydro Project Capital Costs, Appropriations, and Estimated Interest & Depreciation for Three Soverign's Process In-River Migration (high + CWA)
Inflation = 3.0% 11/26/2011
Calculated Values Input yr-by-yr costs to determine CF percentage (next columns)
RefYr Cap Nominal Nom 50 Yr
In-River Migration (high + CWA) Project Compl Date Cost Power Shr Plant I/S Pmt YR 1 YR 2 YR 3 YR 4 YR 5 YR 6 YR 7 YR 8 YR 9 YR 10 Total Check
Extended screens LWG 1995 13607 0.98 12559 922 13607 13607
Extended screens LWG 1996 5853 0.98 5564 408 5853 5853
Extended screens LWG 1997 259 0.98 254 19 259 259
Extended screens LWG 1998 613 0.98 626 46 376 237 613
Extended screens-clean up LWG 1999 1455 0.98 1512 111 1455 1455
Surface bypass LWG 2001 44730 0.98 37846 2777 1550 1430 9430 17220 2500 0 0 44730
Surface bypass-spillway weirs/notched gates LWG 2004 8000 0.98 10033 736 2400 4000 1600 0 8000
Juvenile bypass system LWG 2001 1305 0.98 1515 111 200 800 155 0 150 1305
LWG
Juvenile bypass system II: new juvenile facilities 2002 12900 0.98 14820 1087 8000 4900 12900
LWG
Juvenile bypass system II: new juvenile facilities 2003 2310 0.98 2701 198 2310 2310
Surface bypass- permanent channel w/o dewateringLWG 2004 40000 0.98 49207 3611 12000 20000 8000 40000
Gas abatement- extended deflectors LWG 2004 15000 0.98 18453 1354 4500 7500 3000 15000
Gas abat.-raised/stepped basin/side channelsLWG 2008 200000 0.98 283429 20797 30000 70000 50000 30000 20000 200000
Fish ladder temperature control: study LWG 2002 730 0.98 846 62 219 365 146 730
AWS and emergency AWS LWG 2002 5000 0.98 5798 425 1500 2500 1000 5000
Fish ladder entrance mods. LWG 2005 3000 0.98 3801 279 900 1500 600 3000
Adult Pit-tag detectors LWG 2002 1000 0.98 1148 84 600 400 1000
Picketed lead fences LWG 1997 68 0.98 66 5 68 68
Adult fishway temperature control/add pumpsLWG 1998 1000 0.98 1009 74 1000 1000
Additional ladder LWG 2005 100000 0.98 129689 9516 15000 35000 25000 15000 10000 100000
New fishway design/ increase attraction flowsLWG 2006 12500 0.98 16489 1210 2500 5000 3125 1875 12500
Fishway temperature control structures LWG 2006 10000 0.98 13191 968 2000 4000 2500 1500 10000
LWG
Adjacent sluiceway/surface spill for adult fallback 2002 5000 0.98 5860 430 1000 2000 1250 750 5000
Extended screens LGS 1995 22952 0.93 20087 1474 22952 22952
Extended screens LGS 1996 4802 0.93 4329 318 4802 4802
Extended screens LGS 1997 451 0.93 419 31 451 451
Extended screens LGS 1998 564 0.93 542 40 148 416 564
Extended screens - cleanup LGS 1999 1512 0.93 1489 109 1512 1512
Outfall pipe LGS 1997 1216 0.93 1132 83 140 1076 1216
Outfall pipe LGS 1998 389 0.93 379 28 389 0 389
Surf. bypass-spillway weirs/notched gates LGS 2004 8000 0.93 9331 685 2400 4000 1600 8000
Surf. bypass-perm. channel w/o dewatering LGS 2006 40000 0.93 50662 3717 6000 14000 10000 6000 4000 40000
Gas abatement- extended deflectors LGS 2004 15000 0.93 17496 1284 4500 7500 3000 15000
Gas abat.-raised/stepped basin/ side channels LGS 2008 200000 0.93 268739 19719 30000 70000 50000 30000 20000 200000
Adult fishway temperature control/add pumps LGS 1999 1000 0.93 985 72 1000 1000
Picketed lead fences LGS 1997 69 0.93 64 5 69 69
AWS and emergency AWS LGS 2002 5000 0.93 5497 403 1500 2500 1000 5000
Fish ladder entrance mods. LGS 2005 3000 0.93 3604 264 900 1500 600 3000
Additional ladder LGS 2005 100000 0.93 122967 9023 15000 35000 25000 15000 10000 100000
New design/ temp. struct./add attraction flowsLGS 2006 25000 0.93 31274 2295 5000 10000 6500 3500 25000
LGS
Adjacent sluiceway/surface spill for adult fallback 2002 5000 0.93 5556 408 1000 2000 1250 750 5000
Juvenile bypass system LMN 1996 918 0.94 834 61 918 918
Barge facilities mods. LMN 1997 1004 0.94 939 69 1004 1004
Barge facilities mods. LMN 1998 283 0.94 277 20 211 72 283
Gate raise modifications LMN 2000 263 0.94 291 21 260 3 0 0 0 263
Gantry crane LMN 2000 464 0.94 476 35 64 400 464
Gas abat.-side channels;raised/stepped basinLMN 2008 200000 0.94 270755 19867 30000 70000 50000 30000 20000 200000
Gas abatement-extended deflectors LMN 2004 15000 0.94 17628 1293 4500 7500 3000 15000
Surface bypass-spillway weirs or notched gates LMN 2004 8000 0.94 9401 690 2400 4000 1600 8000
Adult fishway temperature control/add pumps LMN 1999 2000 0.94 2004 147 1000 1000 2000
AWS and emergency AWS LMN 2003 5000 0.94 5705 419 1500 2500 1000 5000
Fish ladder entrance mods. LMN 2006 3000 0.94 3740 274 900 1500 600 3000
LMN
New design/add attract.flows/ temp. control struct. 2006 25000 0.94 31502 2312 5000 10000 6250 3750 25000
Adjacent sluiceway/surf.spill for adult fallbackLMN 2002 10000 0.94 11196 822 2000 4000 2500 1500 10000
JBS IHR 1995 18237 0.79 13446 987 18237 18237
JBS IHR 1996 6093 0.79 4627 340 6093 6093
JBS IHR 1997 790 0.79 618 45 790 790
JBS IHR 1998 652 0.79 525 39 652 652
JBS - cleanup IHR 1999 35 0.79 29 2 35 35
4accf303-ea65-4c8d-97c5-5bdc2051f507.xls Page 3 11/26/2011
Capital Investment
Surface bypass IHR 2001 1581 0.79 1542 113 550 1030 0 0 0 0 0 1581
Surface bypass- spillway weirs or notched gates IHR 2004 8000 0.79 7861 577 2400 4000 1600 8000
Flow deflectors IHR 1997 1881 0.79 1490 109 1260 621 1881
Flow deflectors IHR 1999 8254 0.79 6958 511 2732 1233 4289 8254
Gas abatement-extended deflectors IHR 2004 15000 0.79 14740 1082 4500 7500 3000 15000
Gas aba.-raised or stepped basin/side channels IHR 2008 200000 0.79 226397 16612 30000 70000 50000 30000 20000 200000
Adult fishway temperature control/add pumpsIHR 1999 2000 0.79 1676 123 1000 1000 2000
Adult PIT-tag detectors IHR 2001 2000 0.79 1781 131 1200 800 2000
AWS and emergency AWS IHR 2003 3500 0.79 3339 245 1050 1750 700 3500
Fish ladder entrance mods. IHR 2006 10000 0.79 10425 765 3000 5000 2000 10000
IHR
New designs-add attract.flows/ temp. control struct. 2006 25000 0.79 26341 1933 5000 10000 6250 3750 25000
Adjacent sluiceway/surface spill for fallback IHR 2002 10000 0.79 9362 687 2000 4000 2500 1500 10000
Extended screens MCN 1995 12195 0.81 9300 682 12195 12195
Extended screens MCN 1996 15688 0.81 12323 904 15688 15688
Extended screens MCN 1997 3840 0.81 3107 228 3840 3840
Extended screens MCN 1998 2015 0.81 1688 124 590 1425 2015
Extended screens - cleanup MCN 1999 3157 0.81 2710 199 3157 3157
Maintenance facility MCN 1997 358 0.81 293 22 227 131 358
JBS MCN 1996 21170 0.81 16944 1243 20650 520 21170
JBS - cleanup MCN 1997 1716 0.81 1388 102 1716 1716
MCN
Surf. bypass-proto.channel/spill mods./notched gates 2004 12000 0.81 12197 895 3600 6000 2400 12000
Gate raise mods MCN 2000 241 0.81 226 17 241 0 0 0 241
Gas abatement/add endbay deflectors MCN 2000 3000 0.81 2652 195 3000 3000
Gas abatement-extended deflectors MCN 2004 30000 0.81 30492 2237 9000 15000 6000 30000
Gas abat.-raised or stepped basin/side channels MCN 2008 250000 0.81 292718 21479 37500 87500 62500 37500 25000 250000
Oregon shore fishway back-up screen MCN 2000 2000 0.81 1789 131 1200 800 2000
Adult fishway temperature control/add pumpsMCN 2000 2000 0.81 1785 131 1000 1000 2000
M
New fishway designs; increase attraction flows CN 2005 25000 0.81 26453 1941 5000 10000 6250 3750 25000
Fishway temp.control/structural modificationsMCN 2005 10000 0.81 10581 776 2000 4000 2500 1500 10000
Auxillary water supply MCN 2003 450 0.81 443 33 150 150 150 450
Washington shore adult ladder extension MCN 2003 5000 0.81 4934 362 1500 2500 1000 5000
Adult PIT-tag detectors MCN 2004 2000 0.81 2013 148 1200 800 2000
Oregon shore sluiceway for adult fallback MCN 2002 10000 0.81 9683 711 2000 4000 2500 1500 10000
Surface bypass- skeleton bay JDA 2001 35000 0.78 31366 2302 7000 14000 8750 5250 35000
Monitoring facility JDA 1999 27425 0.78 23503 1725 1900 11100 11995 930 1500 27425
Extended screen test JDA 2001 5438 0.78 5177 380 750 3450 603 635 0 0 0 5438
Extended screen implementation JDA 2001 21367 0.78 19309 1417 417 3500 15000 2450 0 21367
Surface bypass studies JDA 2001 10122 0.78 9396 689 1600 100 3267 1655 3500 0 0 10122
JDA
Surf.bypass-spillway/gate mods for juv/adult passage 2002 10000 0.78 9491 696 3000 5000 2000 0 0 10000
Surface bypass -prototype channel JDA 2004 12000 0.78 11627 853 3600 6000 2400 12000
Flow deflectors JDA 1999 13262 0.78 11167 819 600 5612 6720 330 13262
Gas abatement-extended deflectors JDA 2004 35000 0.78 33911 2488 10500 17500 7000 35000
Gas abat.- raised/stepped basin/side channels JDA 2008 400000 0.78 446458 32760 60000 140000 100000 60000 40000 400000
Count Station Mods JDA 1999 2000 0.78 1655 121 1200 800 2000
Reduce Jumping in Pool/Weir Adult Lad. JDA 2001 8700 0.78 7698 565 200 2000 4000 2500 8700
Fish ladder temp control/add pumps JDA 2001 2000 0.78 1773 130 600 1000 400 2000
Fishway exit modifications JDA 2002 5000 0.78 4566 335 1500 2500 1000 5000
Reconfigure conduit JDA 2002 15000 0.78 13699 1005 4500 7500 3000 15000
Restrain pollution JDA 2000 500 0.78 426 31 300 200 500
Emerg. aux. water supply JDA 2001 30000 0.78 26600 1952 9000 15000 6000 30000
Fishway temp. control/structural modifications JDA 2004 8000 0.78 7736 568 2000 4000 2000 8000
JDA
Adjacent sluiceway/surface spill for adult fallback 2002 15000 0.78 13699 1005 4500 7500 3000 15000
New fishway designs-increase attraction flows JDA 2005 25000 0.78 25216 1850 5000 10000 6250 3750 25000
Ringold JDA 2001 3313 0.78 3082 226 1000 1333 200 380 200 200 3313
Drawdown study JDA 2001 7000 0.78 6267 460 0 250 3730 3020 0 7000
ADP for MOP drawdown JDA 2001 5950 0.78 5791 425 5650 300 0 0 0 0 0 5950
Surface bypass (blocked trashracks/powerhouseTDA channel) 2001 10277 0.74 9237 678 3500 1900 1377 0 3500 0 0 10277
Sluiceway outfall relocation TDA 2000 5000 0.74 4110 302 1500 2500 1000 5000
Spillway mods./weirs/notched alternate gates TDA 2000 12000 0.74 9813 720 2000 6000 4000 12000
Spillway mods./weirs/notched remaining gates TDA 2004 6000 0.74 5522 405 1000 3000 2000 6000
Spillway/sluiceway survival study TDA 2001 6082 0.74 5288 388 50 0 1332 1650 1500 1500 50 6082
Juv. screen bypass system-studies/prototypes TDA 2004 21513 0.74 21853 1603 20909 460 144 0 0 0 0 21513
Juv. screened bypass system/implemented TDA 2005 140000 0.74 140121 10282 28000 56000 35000 21000 0 0 140000
Gas abatement (extended deflectors) TDA 2001 35000 0.74 29632 2174 10500 17500 7000 35000
Gas abatement-stepped basin/side channels TDA 2008 300000 0.74 319721 23460 45000 105000 75000 45000 30000 300000
Emerg. water supply study TDA 1999 1108 0.74 882 65 50 0 308 250 500 1108
Adult channel dewatering study TDA 1998 111 0.74 85 6 91 20 111
Emergency auxillary water supply TDA 2001 21400 0.74 18267 1340 400 2000 9000 7000 3000 21400
4accf303-ea65-4c8d-97c5-5bdc2051f507.xls Page 4 11/26/2011
Capital Investment
Adult channel dewatering TDA 2002 6000 0.74 5182 380 3600 2400 6000
Fish ladder temperature control/pumps TDA 2001 4000 0.74 3377 248 1000 1800 1200 4000
TDA
Install bulkheads, reduce collection channel leaks 2000 6000 0.74 4932 362 1800 3000 1200 6000
Automate S. Shore Exit Weir TDA 1999 2000 0.74 1581 116 1200 800 2000
New fishway designs-increase attraction flows TDA 2006 25000 0.74 24800 1820 5000 10000 6250 3750 25000
TDA
Fishway/east ladder sluiceway for adult fallback 2006 10000 0.74 9920 728 2000 4000 2500 1500 10000
Temperature control- structural modificationsTDA 2006 20000 0.74 19840 1456 4000 8000 5000 3000 20000
PH 2 screened bypass system mods and outfall BON2 2000 64648 1.00 72322 5307 500 1850 5428 21750 25000 10120 64648
Surface bypass prototype BON1 2001 54144 0.50 31459 2308 1350 3850 5224 7000 9700 13510 13510 54144
PH1 guidance device BON1 2002 30000 0.50 17506 1285 18000 12000 30000
PH2 guidance device BON2 2001 30000 1.00 33993 2494 18000 12000 30000
Surface bypass B 2 BON2 2008 81000 1.00 115196 8453 16200 32400 20250 12150 81000
PH1 DSM,outfall BON1 2001 43493 0.50 24798 1820 161 2600 6950 17870 15912 43493
PH1 DSM,outfall BON1 2002 1251 0.50 722 53 1251 1251
PH1 DSM, outfall clean-up BON1 2003 707 0.50 420 31 707 707
PH1 FGE BON1 2001 10552 0.50 6209 456 450 1328 3634 3400 1740 0 10552
BON
Power distribution-independent operation ph1and ph2 1998 916 0.75 721 53 300 526 90 916
PH2 FGE BON2 1999 1200 1.00 1267 93 1200 1200
Extended length screens BON1 2005 30000 0.50 19315 1417 9000 15000 6000 30000
Gas abatement/ extended deflectors BON 2001 21400 0.75 18561 1362 4300 8600 5300 3200 21400
Fast Track- endbay deflectors BON 1999 3000 0.75 2375 174 3000 3000
BON
Gas abat./raised or stepped basin/side channels 2008 350000 0.75 378049 27740 52500 122500 87500 52500 35000 350000
Adult fallback study BON 1999 800 0.75 634 47 50 750 800
Adult fallback-structural mods BON 2001 20000 0.75 17345 1273 4000 8000 5000 3000 20000
Auxillary water supply (powerhouse 2) BON2 2003 10000 1.00 12138 891 3000 5000 2000 10000
Modify B 2 trashracks/ Emerg. AWS BON2 2001 15000 1.00 17161 1259 4500 7500 3000 15000
Adult lamprey passage study BON 2003 500 0.75 455 33 150 250 100 500
PH2 Mod. Shad Removal BON2 2000 1000 1.00 1100 81 600 400 1000
PH1 Entrance Weir Mod. (Criteria) BON1 2000 4500 0.50 2452 180 500 4000 4500
Adult flat plate PIT-tag detector BON2 2001 293 1.00 358 26 200 43 50 0 0 0 293
Adult PIT-tag detectors BON 2002 2000 0.75 1768 130 600 1000 400 2000
Fishway Redesign; Increase Attraction Flow BON 2005 25000 0.75 24403 1791 5000 10000 6250 3750 25000
Fishway temperature control/pumps) BON 2002 3400 0.75 3020 222 200 1000 2000 200 3400
Temp Control-structural modifications BON 2005 20000 0.75 19522 1432 4000 8000 5000 3000 20000
Lamprey passage improvement mods. BON 2005 3500 0.75 3508 257 500 500 500 500 500 500 500 3500
Power distribution BON 1998 916 0.75 721 53 300 526 90 916
Barge exit mods LWG 1996 730 0.98 694 51 730 730
Barge exit mods LWG 1997 650 0.98 636 47 650 650
Completed mitigation analysis SYS 2001 28450 0.81 28932 2123 28450 0 0 0 0 0 0 28450
Drawdown test SYS 2001 3050 0.81 3102 228 3050 0 0 0 0 0 0 3050
Gas abatement program SYS 2001 24544 0.81 23902 1754 3200 3650 8694 3600 3050 2350 0 24544
Adult passage L. Columbia SYS 2001 2738 0.81 2592 190 38 700 2000 0 0 2738
L Snake feasibility study SYS 2001 19716 0.81 19029 1396 450 1600 5756 7430 4028 452 0 19716
Aux water supply Snake SYS 2001 466 0.81 455 33 150 10 26 230 50 0 0 466
Fish ladder entrance mods Snk SYS 1998 0 0.81 0 0 0 0
Fishway temp control evaluation SYS 2001 673 0.81 640 47 60 53 60 500 0 0 673
Additional barges SYS 1998 3478 0.81 2925 215 200 50 1877 1351 3478
NPD review SYS 2001 374 0.81 366 27 374 0 0 0 0 374
Turbine model study SYS 2001 1047 0.81 1021 75 100 657 290 0 0 0 1047
Turbine passage survival PH1 SYS 2001 11323 0.81 11128 817 4850 100 1873 1400 3100 0 0 11323
Completed acoustic technology SYS 2001 1942 0.81 1953 143 1350 50 542 0 0 0 0 1942
Separator evaluation SYS 2001 4654 0.81 4474 328 115 1169 2370 900 100 0 4654
Dispersed release SYS 2001 2420 0.81 2212 162 380 340 1700 2420
Dispersed release SYS 2002 1880 0.81 1755 129 1880 1880
Regional research facility SYS 2003 20000 0.81 19639 1441 6000 10000 4000 20000
CHJ
Chief Joseph temperature control/multiport outlet 2008 20000 1.00 28443 2087 4000 8000 5000 3000 20000
Chief Joseph gas abatement-extended deflectorsCHJ 2001 20000 1.00 23127 1697 4000 8000 5000 3000 20000
CHJ
Chief Joseph gas abat.-stepped basin/side channels 2008 300000 1.00 435874 31983 45000 45000 90000 60000 30000 30000 300000
DWK
Dworshak Gas-raised/stepped tailrace/outlet/deflect. 2008 50000 0.87 62149 4560 10000 20000 12500 7500 50000
Libby gas abatement: 3 turbines LIB 2006 16000 0.78 16552 1215 4800 8000 3200 16000
Willamette River temperature control COU 2007 70000 0.12 11256 826 10500 24500 17500 10500 7000 70000
Adult Passage Middle F. Willamette DEX,LOP,HCR 2007 15000 0.29 6006 441 3000 6000 3750 2250 15000
S. Santiam fishery restoration GPR 2007 9000 0.50 6027 442 5400 3600 9000
0 #N/A #N/A #N/A 0 0
0 #N/A #N/A #N/A 0 0
Reclamation Investments 0 #N/A #N/A #N/A 0 0
GCL
Grand Coulee temperature control- low level outlets 2008 100000 0.42 60158 4414 20000 40000 25000 15000 100000
Grand Coulee Gas (Deflectors/Mid Level Cov) GCL 2002 20000 0.42 10076 739 4000 8000 5000 3000 20000
4accf303-ea65-4c8d-97c5-5bdc2051f507.xls Page 5 11/26/2011
Capital Investment
GCL
G.Coul.Gas:stepped basin/side chan./widen river chan. 2008 1000000 0.42 614582 45096 150000 150000 300000 200000 100000 100000 1000000
Reclamation-Hungry Horse HGH 1997 5700 0.70 3971 291 5700 5700
Reclamation-Minidoka BUR 1998 300 1.00 313 23 300 0 300
0 #N/A #N/A #N/A 0 0
0 #N/A #N/A #N/A 0 0
0 #N/A #N/A #N/A 0 0
0 #N/A #N/A #N/A 0 0
Lower Snake Comp. Investments 0 #N/A #N/A #N/A 0 0
COE-Lower Snake Compens. LSRCP 1996 6258 1.00 6046 444 6258 6258
COE-Lower Snake Compens. LSRCP 1997 4163 1.00 4142 304 4163 4163
COE-Lower Snake Compens. LSRCP 1998 3800 1.00 3895 286 3800 3800
COE-Lower Snake Compens. LSRCP 1999 14700 1.00 15520 1139 14700 14700
COE-Lower Snake Compens. LSRCP 2000 14700 1.00 15985 1173 14700 14700
COE-Lower Snake Compens. LSRCP 2001 14700 1.00 16465 1208 14700 14700
COE-Lower Snake Compens. LSRCP 2002 14700 1.00 16959 1244 14700 14700
COE-Lower Snake Compens. LSRCP 2003 14700 1.00 17467 1282 14700 14700
COE-Lower Snake Compens. LSRCP 2004 14700 1.00 17991 1320 14700 14700
COE-Lower Snake Compens. LSRCP 2005 14700 1.00 18531 1360 14700 14700
COE-Lower Snake Compens. LSRCP 2006 14700 1.00 19087 1401 14700 14700
0 #N/A #N/A #N/A 0 0
Do Not Insert At or Below this Line
Total - All 5,957,812 $5,957,812
APPROPRIATIONS ($ millions) 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
CRJFM only $70.1 $86.0 $146.7 $222.7 $242.6 $273.4 $297.3 $408.7 $703.7 $1,206.5 $883.5 $516.2 $353.0
TTL 96-01 $1,041 TTL 02-06 $3,500 TTL 02-08 $4,369 G. TTL 96-12
Average $173.6 Average $700.0 Average $624.1 $5,410
PLANT IN SERVICE BY YEAR ($ millions) 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
CRJFM & BOR $45.1 ($42.7) $9.8 $60.4 $102.4 $497.8 $151.3 $49.8 $279.5 $529.2 $254.7 $23.3 $3,802.7
All $51.3 ($38.6) $13.7 $75.9 $118.4 $514.2 $168.2 $67.2 $297.5 $547.7 $273.8 $23.3 $3,802.7
Cumulative (starting from 1978) $854.9 $816.3 $830.0 $905.9 $1,024.3 $1,538.5 $1,706.7 $1,773.9 $2,071.4 $2,619.1 $2,893.0 $2,916.3 $6,718.9 $6,718.9 $6,718.9 $6,718.9 $6,718.9
TTL 96-01 $735 TTL 02-06 $1,354 TTL 02-08 $5,180 G. TTL 96-12
Average $122.5 Average $270.9 Average $740.1 $5,915
PROGRAM FIXED EXPENSES - CAPITAL
INVESTMENTS ($ millions) 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
INTEREST EXPENSE - BPA $9.6 $10.9 $12.0 $12.9 $13.6 $13.9 $14.3 $15.2 $16.0 $16.5 $16.9 $16.4 $15.2 $14.0 $12.9 $11.8 $10.8
INTEREST EXPENSE - NON-BPA $41.5 $41.3 $37.2 $39.6 $45.2 $64.6 $84.6 $90.2 $99.4 $122.8 $144.9 $150.9 $260.1 $366.7 $359.1 $351.6 $344.0
AMORTIZATION EXPENSE $10.6 $12.4 $14.2 $16.0 $17.7 $18.9 $20.3 $22.3 $24.3 $25.8 $26.9 $27.5 $27.3 $26.7 $25.7 $24.5 $23.4
DEPRECIATION EXPENSE $11.4 $11.4 $11.1 $11.9 $13.7 $19.9 $26.5 $28.7 $32.2 $40.5 $48.5 $51.4 $89.6 $127.7 $127.7 $127.7 $127.7
TOTAL FIXED EXPENSES $73.0 $76.0 $74.6 $80.4 $90.2 $117.2 $145.8 $156.5 $171.9 $205.6 $237.2 $246.1 $392.2 $535.1 $525.4 $515.5 $505.9
TTL 96-01 $512 TTL 02-06 $917 TTL 02-08 $1,555 G. TTL 96-12
Average $85.3 Average $183.4 Average $222.2 $4,149
4accf303-ea65-4c8d-97c5-5bdc2051f507.xls Page 6 11/26/2011