Spreadsheet: rick_buy__32928__TAB2_EES_Power
Sheet: Replacement Cost

 | Sum of Nominal Volume |  |  | Forward Date
 | Region_NM | Commodity NM | LoadDefinition NM | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00 | 2003-07-01 00:00:00 | 2003-08-01 00:00:00 | 2003-09-01 00:00:00 | 2003-10-01 00:00:00 | 2003-11-01 00:00:00 | 2003-12-01 00:00:00 | Grand Total
 | CIN | Electricity | Central Peak |  | -17600 | -16000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -33600
 |  | Electricity          Total |  |  | -17600 | -16000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -33600
 | CIN Total |  |  |  | -17600 | -16000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -33600
 | EC | Electricity | Central Flat | 3720 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3720
 |  | Electricity          Total |  | 3720 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3720
 | EC Total |  |  | 3720 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3720
 | ERC | Electricity | Central OffPeak |  | 39200 | 35200 | 40800 | 36800 | 39200 | 40000 | 39200 | 39200 | 40000 | 37600 | 40000 | 40800 | 39200 | 35200 | 40800 | 36800 | 40800 | 38400 | 39200 | 40800 | 38400 | 37600 | 41600 | 39200 | 936000
 |  |  | Central Peak | 16000 | 17600 | 16000 | 16800 | 17600 | 17600 | 16000 | 35200 | 35200 | 16000 | 18400 | 16000 | 16800 | 17600 | 16000 | 16800 | 17600 | 16800 | 16800 | 17600 | 16800 | 16800 | 18400 | 15200 | 17600 | 459200
 |  | Electricity          Total |  | 16000 | 56800 | 51200 | 57600 | 54400 | 56800 | 56000 | 74400 | 74400 | 56000 | 56000 | 56000 | 57600 | 56800 | 51200 | 57600 | 54400 | 57600 | 55200 | 56800 | 57600 | 55200 | 56000 | 56800 | 56800 | 1395200
 | ERC Total |  |  | 16000 | 56800 | 51200 | 57600 | 54400 | 56800 | 56000 | 74400 | 74400 | 56000 | 56000 | 56000 | 57600 | 56800 | 51200 | 57600 | 54400 | 57600 | 55200 | 56800 | 57600 | 55200 | 56000 | 56800 | 56800 | 1395200
 | NE | Electricity | East Peak | -32000 |  |  |  |  |  |  | -17600 | -17600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -67200
 |  | Electricity          Total |  | -32000 |  |  |  |  |  |  | -17600 | -17600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -67200
 | NE Total |  |  | -32000 |  |  |  |  |  |  | -17600 | -17600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -67200
 | NP | Electricity | West OffPeak | -8600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -8600
 |  | Electricity          Total |  | -8600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -8600
 | NP Total |  |  | -8600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -8600
 | SP | Electricity | West OffPeak | 8600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8600
 |  | Electricity          Total |  | 8600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8600
 | SP Total |  |  | 8600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8600
 | WH | Electricity | East OffPeak | 169600 | 9800 | 8800 | 10200 | 9200 | 9800 | 10000 | 9800 | 9800 | 10000 | 9400 | 10000 | 10200 |  |  |  |  |  |  |  |  |  |  |  |  | 286600
 |  |  | East Peak | 120000 | 79200 | 72000 | 75600 | 79200 | 79200 | 72000 | 96800 | 96800 | 72000 | 82800 | 72000 | 75600 | 52800 | 48000 | 50400 | 52800 | 50400 | 50400 | 52800 | 50400 | 50400 | 55200 | 45600 | 52800 | 1685200
 |  | Electricity          Total |  | 289600 | 89000 | 80800 | 85800 | 88400 | 89000 | 82000 | 106600 | 106600 | 82000 | 92200 | 82000 | 85800 | 52800 | 48000 | 50400 | 52800 | 50400 | 50400 | 52800 | 50400 | 50400 | 55200 | 45600 | 52800 | 1971800
 |  | ICap | N/A | 2325 | 1550 | 1400 | 1550 | 1500 | 1550 | 3750 | 3875 | 3875 | 3750 | 3875 | 3750 | 3875 | 1550 | 1400 | 1550 | 1500 | 1550 | 1500 | 1550 | 1550 | 1500 | 1550 | 1500 | 1550 | 54875
 |  | ICap                 Total |  | 2325 | 1550 | 1400 | 1550 | 1500 | 1550 | 3750 | 3875 | 3875 | 3750 | 3875 | 3750 | 3875 | 1550 | 1400 | 1550 | 1500 | 1550 | 1500 | 1550 | 1550 | 1500 | 1550 | 1500 | 1550 | 54875
 | WH Total |  |  | 291925 | 90550 | 82200 | 87350 | 89900 | 90550 | 85750 | 110475 | 110475 | 85750 | 96075 | 85750 | 89675 | 54350 | 49400 | 51950 | 54300 | 51950 | 51900 | 54350 | 51950 | 51900 | 56750 | 47100 | 54350 | 2026675
 | Grand Total |  |  | 279645 | 129750 | 117400 | 144950 | 144300 | 147350 | 141750 | 167275 | 167275 | 141750 | 152075 | 141750 | 147275 | 111150 | 100600 | 109550 | 108700 | 109550 | 107100 | 111150 | 109550 | 107100 | 112750 | 103900 | 111150 | 3324795
Average of Bid/Offer |  |  |  | Forward Date
Region_NM | Commodity NM | LoadDefinition NM | Buy/Sell | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00 | 2003-07-01 00:00:00 | 2003-08-01 00:00:00 | 2003-09-01 00:00:00 | 2003-10-01 00:00:00 | 2003-11-01 00:00:00 | 2003-12-01 00:00:00 | Grand Total
CIN | Electricity | Central Peak | Sell |  | 25.75 | 25.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.75
 |  | Central Peak Total |  |  | 25.75 | 25.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.75
 | Electricity          Total |  |  |  | 25.75 | 25.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.75
CIN Total |  |  |  |  | 25.75 | 25.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25.75
EC | Electricity | Central Flat | Buy | 33.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.95
 |  | Central Flat Total |  | 33.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.95
 | Electricity          Total |  |  | 33.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.95
EC Total |  |  |  | 33.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.95
ERC | Electricity | Central OffPeak | Buy |  | 18.64 | 17.98 | 16.02 | 16.21 | 17.6 | 19.44 | 22.91 | 22.74 | 17.82 | 16.07 | 16.11 | 17.45 | 21.19 | 20.44 | 18.22 | 18.43 | 20.02 | 22.11 | 26.04 | 25.86 | 20.27 | 18.28 | 18.31 | 19.84 | 19.5
 |  | Central OffPeak Total |  |  | 18.64 | 17.98 | 16.02 | 16.21 | 17.6 | 19.44 | 22.91 | 22.74 | 17.82 | 16.07 | 16.11 | 17.45 | 21.19 | 20.44 | 18.22 | 18.43 | 20.02 | 22.11 | 26.04 | 25.86 | 20.27 | 18.28 | 18.31 | 19.84 | 19.5
 |  | Central Peak | Buy | 19.5 | 28.26 | 27.63 | 26.14 | 25.19 | 26.4 | 29.25 | 36.02 | 36.02 | 23.37 | 21.88 | 21.99 | 21.85 | 32.44 | 31.73 | 30.02 | 28.92 | 30.32 | 33.58 | 41.35 | 41.35 | 26.83 | 25.12 | 25.25 | 25.09 | 27.94629629629631
 |  | Central Peak Total |  | 19.5 | 28.26 | 27.63 | 26.14 | 25.19 | 26.4 | 29.25 | 36.02 | 36.02 | 23.37 | 21.88 | 21.99 | 21.85 | 32.44 | 31.73 | 30.02 | 28.92 | 30.32 | 33.58 | 41.35 | 41.35 | 26.83 | 25.12 | 25.25 | 25.09 | 27.94629629629631
 | Electricity          Total |  |  | 19.5 | 21.06 | 20.43 | 18.67 | 18.50333333333333 | 19.8 | 21.89666666666666 | 27.965 | 27.88 | 19.02 | 17.4 | 17.46 | 18.31 | 24.94 | 24.20333333333333 | 22.15333333333333 | 21.92666666666667 | 23.45333333333333 | 25.93333333333333 | 31.14333333333333 | 31.02333333333333 | 22.45666666666667 | 20.56 | 20.62333333333333 | 21.59 | 22.54066666666667
ERC Total |  |  |  | 19.5 | 21.06 | 20.43 | 18.67 | 18.50333333333333 | 19.8 | 21.89666666666666 | 27.965 | 27.88 | 19.02 | 17.4 | 17.46 | 18.31 | 24.94 | 24.20333333333333 | 22.15333333333333 | 21.92666666666667 | 23.45333333333333 | 25.93333333333333 | 31.14333333333333 | 31.02333333333333 | 22.45666666666667 | 20.56 | 20.62333333333333 | 21.59 | 22.54066666666667
NE | Electricity | East Peak | Buy | 34.7 |  |  |  |  |  |  | 53.25 | 53.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43.975
 |  |  | Sell | 34.2 |  |  |  |  |  |  | 52.75 | 52.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43.475
 |  | East Peak Total |  | 34.36666666666667 |  |  |  |  |  |  | 52.91666666666666 | 52.91666666666666 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43.64166666666667
 | Electricity          Total |  |  | 34.36666666666667 |  |  |  |  |  |  | 52.91666666666666 | 52.91666666666666 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43.64166666666667
NE Total |  |  |  | 34.36666666666667 |  |  |  |  |  |  | 52.91666666666666 | 52.91666666666666 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43.64166666666667
NP | Electricity | West OffPeak | Sell | 27.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27.08
 |  | West OffPeak Total |  | 27.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27.08
 | Electricity          Total |  |  | 27.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27.08
NP Total |  |  |  | 27.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27.08
SP | Electricity | West OffPeak | Buy | 88.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88.05
 |  | West OffPeak Total |  | 88.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88.05
 | Electricity          Total |  |  | 88.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88.05
SP Total |  |  |  | 88.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88.05
WH | Electricity | East OffPeak | Buy | 17.5 | 22.69 | 21.99 | 18.71 | 16.92 | 17.23 | 18.97 | 24.35 | 23.86 | 17.23 | 17.53 | 17.49 | 17.05 |  |  |  |  |  |  |  |  |  |  |  |  | 18.701
 |  | East OffPeak Total |  | 17.5 | 22.69 | 21.99 | 18.71 | 16.92 | 17.23 | 18.97 | 24.35 | 23.86 | 17.23 | 17.53 | 17.49 | 17.05 |  |  |  |  |  |  |  |  |  |  |  |  | 18.701
 |  | East Peak | Buy | 25.1 | 30.08 | 30.08 | 27.2 | 27.2 | 29.44 | 36.8 | 49.6 | 49.6 | 26.4 | 25.76 | 25.92 | 25.92 | 32.67 | 32.67 | 29.54 | 29.54 | 31.97 | 39.96 | 53.86 | 53.86 | 28.67 | 27.97 | 28.15 | 28.15 | 32.63495495495498
 |  |  | Sell | 24.9 | 29.61 | 29.61 | 26.78 | 26.78 | 28.98 | 36.23 | 48.83 | 48.83 | 25.99 | 25.36 | 25.52 | 25.52 |  |  |  |  |  |  |  |  |  |  |  |  | 32.48444444444444
 |  | East Peak Total |  | 25.06363636363636 | 29.97555555555555 | 29.97555555555555 | 27.14 | 27.14 | 29.37428571428572 | 36.71857142857143 | 49.44600000000001 | 49.44600000000001 | 26.34142857142857 | 25.70285714285714 | 25.86285714285715 | 25.86285714285715 | 32.67 | 32.67 | 29.54 | 29.54 | 31.97 | 39.96 | 53.86 | 53.86 | 28.67 | 27.97 | 28.15 | 28.15 | 32.61395348837211
 | Electricity          Total |  |  | 21.87894736842106 | 29.247 | 29.177 | 26.08625 | 25.8625 | 27.85625 | 34.5 | 47.16454545454546 | 47.12 | 25.2025 | 24.68125 | 24.81625 | 24.76125 | 32.67 | 32.67 | 29.54 | 29.54 | 31.97 | 39.96 | 53.86 | 53.86 | 28.67 | 27.97 | 28.15 | 28.15 | 30.74644295302015
 | ICap | N/A | Buy | 17.5 | 48.75 | 48.75 | 48.75 | 48.75 | 48.75 | 117 | 123.5 | 120.25 | 78 | 32.5 | 32.5 | 32.5 | 32.25 | 32.25 | 32.25 | 32.25 | 32.25 | 77.4 | 81.7 | 79.55 | 51.6 | 21.5 | 21.5 | 21.5 | 60.0875
 |  | N/A Total |  | 17.5 | 48.75 | 48.75 | 48.75 | 48.75 | 48.75 | 117 | 123.5 | 120.25 | 78 | 32.5 | 32.5 | 32.5 | 32.25 | 32.25 | 32.25 | 32.25 | 32.25 | 77.4 | 81.7 | 79.55 | 51.6 | 21.5 | 21.5 | 21.5 | 60.0875
 | ICap                 Total |  |  | 17.5 | 48.75 | 48.75 | 48.75 | 48.75 | 48.75 | 117 | 123.5 | 120.25 | 78 | 32.5 | 32.5 | 32.5 | 32.25 | 32.25 | 32.25 | 32.25 | 32.25 | 77.4 | 81.7 | 79.55 | 51.6 | 21.5 | 21.5 | 21.5 | 60.0875
WH Total |  |  |  | 21.46190476190477 | 31.02 | 30.95636363636363 | 28.60444444444444 | 28.40555555555556 | 30.17777777777778 | 57 | 63.52214285714286 | 62.79071428571429 | 39.60181818181818 | 26.81363636363636 | 26.91181818181818 | 26.87181818181818 | 32.53 | 32.53 | 30.44333333333333 | 30.44333333333333 | 32.06333333333333 | 52.44 | 63.14 | 62.42333333333332 | 36.31333333333333 | 25.81333333333333 | 25.93333333333333 | 25.93333333333333 | 36.95619047619049
Grand Total |  |  |  | 26.6283870967742 | 28.67666666666666 | 28.504 | 26.12083333333333 | 25.93 | 27.58333333333333 | 49.47785714285715 | 55.23428571428573 | 54.7304761904762 | 35.19142857142857 | 24.79642857142857 | 24.88642857142858 | 25.03714285714286 | 28.735 | 28.36666666666666 | 26.29833333333333 | 26.185 | 27.75833333333334 | 39.18666666666667 | 47.14166666666667 | 46.72333333333334 | 29.385 | 23.18666666666667 | 23.27833333333333 | 23.76166666666667 | 33.45035587188613
 | Sum of Nominal Dollars
 | Region_NM | Commodity NM | LoadDefinition NM
 | CIN | Electricity | Central Peak
 | EC | Electricity | Central Flat
 | ERC | Electricity | Central OffPeak
 |  |  | Central Peak
 | NE | Electricity | East Peak
 | NP | Electricity | West OffPeak
 | SP | Electricity | West OffPeak
 | WH | Electricity | East OffPeak
 |  |  | East Peak
 |  | ICap | N/A
 | Grand Total
 | Margin Requirement - Fixed NYMEX |  | 0.5
 | Cumulative Margin Required
 | Monthly Cost of Capital - NPW |  | 0.25
 | PV of Monthly Cost of Credit at T-Bill Rate |  | 0.03
 | Total Cost of Credit to NPW
 |  |  |  | 0
 | Central Peak | Buy |  | 28.26 | 27.63 | 26.14 | 25.19 | 26.4 | 29.25 | 36.02 | 36.02 | 23.37 | 21.88 | 21.99 | 21.85 | 32.44 | 31.73 | 30.02 | 28.92 | 30.32 | 33.58 | 41.35 | 41.35 | 26.83 | 25.12 | 25.25 | 25.09 |  | 28.91884615384616