Spreadsheet: rick_buy__32927__TAB1_EPMI_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 | -16000 | 17600 | 16000 |  |  |  |  | -17600 | -17600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -17600
 |  | Electricity          Total |  | -16000 | 17600 | 16000 |  |  |  |  | -17600 | -17600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -17600
 | CIN Total |  |  | -16000 | 17600 | 16000 |  |  |  |  | -17600 | -17600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -17600
 | EC | Electricity | Central Flat | -3720 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3720
 |  | Electricity          Total |  | -3720 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3720
 | EC Total |  |  | -3720 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3720
 | ERC | Electricity | Central OffPeak |  | -19600 | -17600 | -20400 | -18400 | -19600 | -20000 | -19600 | -19600 | -20000 | -18800 | -20000 | -20400 | -39200 | -35200 | -40800 | -36800 | -40800 | -38400 | -39200 | -40800 | -38400 | -37600 | -41600 | -39200 | -702000
 |  |  | Central OffPeak-North | 21200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21200
 |  |  | Central Peak |  | -8800 | -8000 | -25200 | -26400 | -26400 | -24000 | -26400 | -26400 | -24000 | -27600 | -24000 | -25200 | -26400 | -24000 | -25200 | -26400 | -25200 | -25200 | -26400 | -25200 | -25200 | -27600 | -22800 | -26400 | -578400
 |  |  | Central Peak-North | 16000 | 8800 | 8000 | 8400 | 8800 | 8800 | 8000 | 8800 | 8800 | 8000 | 9200 | 8000 | 8400 | 8800 | 8000 | 8400 | 8800 | 8400 | 8400 | 8800 | 8400 | 8400 | 9200 | 7600 | 8800 | 220000
 |  | Electricity          Total |  | 37200 | -19600 | -17600 | -37200 | -36000 | -37200 | -36000 | -37200 | -37200 | -36000 | -37200 | -36000 | -37200 | -56800 | -51200 | -57600 | -54400 | -57600 | -55200 | -56800 | -57600 | -55200 | -56000 | -56800 | -56800 | -1039200
 | ERC Total |  |  | 37200 | -19600 | -17600 | -37200 | -36000 | -37200 | -36000 | -37200 | -37200 | -36000 | -37200 | -36000 | -37200 | -56800 | -51200 | -57600 | -54400 | -57600 | -55200 | -56800 | -57600 | -55200 | -56000 | -56800 | -56800 | -1039200
 | NE | Electricity | East Peak | 16000 | 0 | 0 |  |  |  | 0 | 17600 | 17600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51200
 |  | Electricity          Total |  | 16000 | 0 | 0 |  |  |  | 0 | 17600 | 17600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51200
 | NE Total |  |  | 16000 | 0 | 0 |  |  |  | 0 | 17600 | 17600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51200
 | SP | Electricity | West OffPeak | -8600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -8600
 |  | Electricity          Total |  | -8600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -8600
 | SP Total |  |  | -8600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -8600
 | WH | Electricity | East OffPeak | -63600 | -19600 | -17600 | -20400 | -18400 | -19600 | -20000 | -19600 | -19600 | -20000 | -18800 | -20000 | -20400 |  |  |  |  |  |  |  |  |  |  |  |  | -297600
 |  |  | East Peak | -48000 | -17600 | -16000 | -16800 | -17600 | -17600 | 16000 | -17600 | -17600 | -16000 | -18400 | -16000 | -16800 |  |  |  |  |  |  |  |  |  |  |  |  | -220000
 |  | Electricity          Total |  | -111600 | -37200 | -33600 | -37200 | -36000 | -37200 | -4000 | -37200 | -37200 | -36000 | -37200 | -36000 | -37200 |  |  |  |  |  |  |  |  |  |  |  |  | -517600
 |  | ICap | N/A | 6200 | 775 | 700 | 775 | 750 | 775 | 750 | 775 | 775 | 750 | 1147 | 1110 | 1147 |  |  |  |  |  |  |  |  |  |  |  |  | 16429
 |  | ICap                 Total |  | 6200 | 775 | 700 | 775 | 750 | 775 | 750 | 775 | 775 | 750 | 1147 | 1110 | 1147 |  |  |  |  |  |  |  |  |  |  |  |  | 16429
 | WH Total |  |  | -105400 | -36425 | -32900 | -36425 | -35250 | -36425 | -3250 | -36425 | -36425 | -35250 | -36053 | -34890 | -36053 |  |  |  |  |  |  |  |  |  |  |  |  | -501171
 | Grand Total |  |  | -80520 | -38425 | -34500 | -73625 | -71250 | -73625 | -39250 | -73625 | -73625 | -71250 | -73253 | -70890 | -73253 | -56800 | -51200 | -57600 | -54400 | -57600 | -55200 | -56800 | -57600 | -55200 | -56000 | -56800 | -56800 | -1519091
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 | Buy |  | 26.25 | 26.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26.25
 |  |  | Sell | 22.75 |  |  |  |  |  |  | 45.5 | 45.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37.91666666666666
 |  | Central Peak Total |  | 22.75 | 26.25 | 26.25 |  |  |  |  | 45.5 | 45.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.25
 | Electricity          Total |  |  | 22.75 | 26.25 | 26.25 |  |  |  |  | 45.5 | 45.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.25
CIN Total |  |  |  | 22.75 | 26.25 | 26.25 |  |  |  |  | 45.5 | 45.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.25
EC | Electricity | Central Flat | Sell | 19.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.5
 |  | Central Flat Total |  | 19.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.5
 | Electricity          Total |  |  | 19.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.5
EC Total |  |  |  | 19.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.5
ERC | Electricity | Central OffPeak | Sell |  | 18.38 | 17.73 | 15.8 | 15.99 | 17.36 | 19.18 | 22.59 | 22.43 | 17.58 | 15.85 | 15.89 | 17.21 | 20.42 | 19.7 | 17.56 | 17.77 | 19.29 | 21.31 | 25.1 | 24.92 | 19.53 | 17.62 | 17.65 | 19.12 | 18.99916666666667
 |  | Central OffPeak Total |  |  | 18.38 | 17.73 | 15.8 | 15.99 | 17.36 | 19.18 | 22.59 | 22.43 | 17.58 | 15.85 | 15.89 | 17.21 | 20.42 | 19.7 | 17.56 | 17.77 | 19.29 | 21.31 | 25.1 | 24.92 | 19.53 | 17.62 | 17.65 | 19.12 | 18.99916666666667
 |  | Central OffPeak-North | Buy | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.5
 |  | Central OffPeak-North Total |  | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.5
 |  | Central Peak | Buy |  | 25.9 | 25.33 | 23.97 | 23.09 | 24.2 | 26.81 | 33.02 | 33.02 | 21.42 | 20.06 | 20.16 | 20.03 | 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.70153846153847
 |  |  | Sell |  | 28.26 | 27.63 | 26.14 | 25.19 | 26.4 | 29.25 | 36.02 | 36.02 | 23.37 | 21.88 | 21.99 | 21.85 | 31.66 | 30.96 | 29.29 | 28.22 | 29.58 | 32.77 | 40.35 | 40.35 | 26.18 | 24.52 | 24.64 | 24.48 | 28.625
 |  | Central Peak Total |  |  | 27.316 | 26.71 | 25.5975 | 24.665 | 25.85 | 28.64 | 35.27 | 35.27 | 22.8825 | 21.425 | 21.5325 | 21.395 | 31.855 | 31.1525 | 29.4725 | 28.395 | 29.765 | 32.9725 | 40.6 | 40.6 | 26.3425 | 24.67 | 24.7925 | 24.6325 | 28.38
 |  | Central Peak-North | Buy | 22.5 | 32.7 | 31.98 | 30.26 | 29.15 | 30.56 | 33.85 | 41.69 | 41.69 | 27.05 | 25.33 | 25.45 | 25.29 | 39.24 | 38.38 | 36.31 | 34.98 | 36.67 | 40.62 | 50.02 | 50.02 | 32.46 | 30.39 | 30.54 | 30.35 | 33.89919999999999
 |  | Central Peak-North Total |  | 22.5 | 32.7 | 31.98 | 30.26 | 29.15 | 30.56 | 33.85 | 41.69 | 41.69 | 27.05 | 25.33 | 25.45 | 25.29 | 39.24 | 38.38 | 36.31 | 34.98 | 36.67 | 40.62 | 50.02 | 50.02 | 32.46 | 30.39 | 30.54 | 30.35 | 33.89919999999999
 | Electricity          Total |  |  | 19.5 | 26.80857142857143 | 26.18 | 24.74166666666666 | 23.96666666666667 | 25.22 | 27.93166666666667 | 34.22666666666667 | 34.2 | 22.69333333333334 | 21.14666666666666 | 21.245 | 21.34666666666666 | 31.18 | 30.44833333333333 | 28.62666666666667 | 27.72166666666666 | 29.17 | 32.30333333333333 | 39.58666666666667 | 39.55666666666666 | 26.22666666666667 | 24.44833333333333 | 24.56 | 24.66666666666667 | 27.71081081081081
ERC Total |  |  |  | 19.5 | 26.80857142857143 | 26.18 | 24.74166666666666 | 23.96666666666667 | 25.22 | 27.93166666666667 | 34.22666666666667 | 34.2 | 22.69333333333334 | 21.14666666666666 | 21.245 | 21.34666666666666 | 31.18 | 30.44833333333333 | 28.62666666666667 | 27.72166666666666 | 29.17 | 32.30333333333333 | 39.58666666666667 | 39.55666666666666 | 26.22666666666667 | 24.44833333333333 | 24.56 | 24.66666666666667 | 27.71081081081081
NE | Electricity | East Peak | Buy | 34.7 | 40.75 | 40.75 |  |  |  | 42.25 | 53.25 | 53.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41.79375
 |  |  | Sell | 34.2 | 40.25 | 40.25 |  |  |  | 41.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38.13
 |  | East Peak Total |  | 34.5 | 40.5 | 40.5 |  |  |  | 42 | 53.25 | 53.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40.38461538461539
 | Electricity          Total |  |  | 34.5 | 40.5 | 40.5 |  |  |  | 42 | 53.25 | 53.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40.38461538461539
NE Total |  |  |  | 34.5 | 40.5 | 40.5 |  |  |  | 42 | 53.25 | 53.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40.38461538461539
SP | Electricity | West OffPeak | Sell | 19.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.5
 |  | West OffPeak Total |  | 19.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.5
 | Electricity          Total |  |  | 19.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.5
SP Total |  |  |  | 19.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.5
WH | Electricity | East OffPeak | Buy | 17.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.5
 |  |  | Sell | 16.5 | 21.52 | 20.86 | 17.75 | 16.05 | 16.35 | 18 | 23.1 | 22.63 | 16.34 | 16.63 | 16.6 | 16.17 |  |  |  |  |  |  |  |  |  |  |  |  | 17.91176470588236
 |  | East OffPeak Total |  | 16.78571428571428 | 21.52 | 20.86 | 17.75 | 16.05 | 16.35 | 18 | 23.1 | 22.63 | 16.34 | 16.63 | 16.6 | 16.17 |  |  |  |  |  |  |  |  |  |  |  |  | 17.86842105263158
 |  | 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.71391304347826
 |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  | 31.155
 |  | East Peak Total |  | 24.96666666666667 | 29.81142857142857 | 29.81142857142857 | 26.92 | 26.92 | 29.13333333333334 | 36.572 | 49.138 | 49.138 | 26.12666666666667 | 25.49333333333334 | 25.65333333333333 | 25.65333333333333 |  |  |  |  |  |  |  |  |  |  |  |  | 31.76271186440679
 | Electricity          Total |  |  | 21.3875 | 28.775 | 28.6925 | 24.6275 | 24.2025 | 25.9375 | 33.47666666666666 | 44.79833333333332 | 44.72 | 23.68 | 23.2775 | 23.39 | 23.2825 |  |  |  |  |  |  |  |  |  |  |  |  | 28.37820512820513
 | 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 |  |  |  |  |  |  |  |  |  |  |  |  | 55.9375
 |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  | 55.9375
 | 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 |  |  |  |  |  |  |  |  |  |  |  |  | 55.9375
WH Total |  |  |  | 21.15882352941176 | 30.99444444444445 | 30.92111111111111 | 29.452 | 29.112 | 30.5 | 45.40857142857142 | 56.04142857142857 | 55.51 | 34.544 | 26.35166666666667 | 26.42666666666667 | 26.355 |  |  |  |  |  |  |  |  |  |  |  |  | 33.06914893617022
Grand Total |  |  |  | 23.44259259259259 | 30.20315789473684 | 29.93684210526316 | 26.88272727272727 | 26.30545454545455 | 27.62 | 37.96333333333334 | 46.42666666666667 | 46.16800000000001 | 28.08 | 23.74916666666667 | 23.83583333333334 | 23.85083333333334 | 31.18 | 30.44833333333333 | 28.62666666666667 | 27.72166666666666 | 29.17 | 32.30333333333333 | 39.58666666666667 | 39.55666666666666 | 26.22666666666667 | 24.44833333333333 | 24.56 | 24.66666666666667 | 30.30515267175573
Margin Calculation Detail:
 | CIN | Electricity | Central Peak
 | EC | Electricity | Central Flat
 | ERC | Electricity | Central OffPeak
 |  |  | Central OffPeak-North
 |  |  | Central Peak
 |  |  | Central Peak-North
 | NE | Electricity | East Peak
 | SP | Electricity | West OffPeak
 | WH | Electricity | East OffPeak
 |  |  | East Peak
 |  | ICap | N/A
 | Grand Total
 | Margin Requirement Per Month |  | 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
 | Note: * - Cumulative margin required assumes the PROMPT month is 100% collateralized (as NPW is being require to FULLY collateralized all physical purchases of power.