LIQUIDATED DAMAGES AMOUNT FOR HOURLY FIRM PROJECTS
SAMPLE CALCULATION (for illustrative information purposes only)
Cells shaded in yellow require user input.
Worksheets are protected using 'calculator' as password.
EFEP (escalated Firm Energy Price for year N) 122.86 $/MWh
BC CPI Jan 1, 2009 100
Jan 1, year N 115.66
Transmission Losses (L) 5.50%
Month M
Time of Delivery Factors (from EPA Term Sheet) Hourly Firm Credits ($/MWh) (to be provided in Specimen EPA)
Off-Peak 105% Off-Peak 0
Peak 122% Peak 20
Super-Peak 141% Super-Peak 20
On-Peak 127%
Hourly Firm Energy Delivery Profile (MWh/h)
Off-Peak 8
Peak 10
Super-Peak 10
Calculate LD Amounts for Month M: (see Notes)
Day Mid-C Prices (C$/MWh) Delivery Shortfalls (MWh) LD Factor (C$/MWh) LD
Off-Peak Peak Super-Peak Off-Peak Peak Super-Peak Off-Peak Peak Super-Peak Amount
1 81.02 79.74 92.16 2.1 13.2 0.8 5.78 5.78 5.78 $87.99
2 81.27 83.32 96.29 2.1 13.2 0.8 5.78 5.78 5.78 $87.99
3 70.59 71.34 82.46 2.1 13.2 0.8 5.78 5.78 5.78 $87.99
4 71.22 71.98 83.19 2.1 13.2 0.8 5.78 5.78 5.78 $87.99
5 71.00 70.14 81.07 2.1 13.2 0.8 5.78 5.78 5.78 $87.99
6 67.63 70.00 80.90 2.1 13.2 0.8 5.78 5.78 5.78 $87.99
7 62.98 67.28 77.75 2.1 10.0 0.8 5.78 5.78 5.78 $70.50
8 64.67 65.84 76.10 2.1 10.0 0.8 5.78 5.78 5.78 $70.50
9 119.21 162.23 187.50 2.1 10.0 0.8 5.78 26.75 27.32 $284.94
10 72.82 179.19 207.10 1.1 10.0 0.8 5.78 43.71 46.92 $454.56
11 72.45 171.90 198.67 1.1 10.0 0.0 5.78 36.42 38.49 $350.17
12 75.22 74.62 86.24 1.1 10.0 0.0 5.78 5.78 5.78 $60.66
13 74.04 73.45 84.89 1.1 10.0 0.0 5.78 5.78 5.78 $60.66
14 69.51 70.26 81.20 1.1 10.0 0.0 5.78 5.78 5.78 $60.66
15 75.53 74.19 85.75 1.1 10.0 0.0 5.78 5.78 5.78 $60.66
16 75.10 74.19 85.74 1.1 10.0 0.0 5.78 5.78 5.78 $60.66
17 65.12 70.64 81.64 1.1 13.2 0.0 5.78 5.78 5.78 $78.15
18 65.00 70.51 81.49 1.1 13.2 0.0 5.78 5.78 5.78 $78.15
19 66.43 72.21 83.45 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
20 69.89 76.82 88.78 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
21 75.08 77.63 89.71 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
22 78.27 77.12 89.13 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
23 79.31 76.90 88.87 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
24 71.70 72.30 83.56 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
25 71.83 72.44 83.72 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
26 68.81 70.76 81.78 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
27 67.93 70.10 81.02 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
28 64.62 67.37 77.87 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
29 67.95 68.21 78.83 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
30 63.02 68.17 78.79 1.1 14.2 0.8 5.78 5.78 5.78 $87.99
31 64.50 66.58 76.95 1.1 13.2 0.8 5.78 5.78 5.78 $82.52
LD Amount $3,296.42
Clean Power Call 07-Aug-08 Page 1
LIQUIDATED DAMAGES AMOUNT FOR SEASONALLY FIRM PROJECTS
SAMPLE CALCULATION (for illustrative information purposes only)
Cells shaded in yellow require user input.
Worksheets are protected using 'calculator' as password.
EFEP (escalated Firm Energy Price for year N) 122.86 $/MWh Values in blue can be modified by User.
BC CPI Jan 1, 2009 100.00
Jan 1, year N 115.66
Transmission Losses (L) 5.5%
Month 1 Month 2 Month 3
Seasonal Firm Energy (from Firm Energy Profile) 90 GWh Exch Rate 1.0010 1.0200 1.0115
Delivered Eligible Energy for the Season 88 GWh Total Hours 672 744 720
Delivery Shortfall 2 GWh Weighted Average Exchange Rate 1.0112
Number of Hours in Period Time of Delivery Factors Avg of daily Mid-C Prices for the
Month 1 Month 2 Month 3 Month 1 Month 2 Month 3 Season (US$/MWh)
Off-Peak 288 319 308 101% 99% 85% 80.00
Peak 288 319 309 113% 112% 95%
Super-Peak 96 106 103 124% 124% 104%
On-Peak 384 425 412 116% 115% 97% 95.00
Sum of (hours in period * Time of Delivery Factor) 2202
Total hours in season 2136
Seasonal TDF = time weighted average of the TDFs in the season = 103%
Seasonal Mid-C Price (C$/MWh) = [(off-peak hours in season * avg of daily off-peak Mid-C price indices) + (on-peak
hours in season * avg of daily on-peak Mid-C price indices)] / total hours in season = 89.56 C$/MWh
LD Factor:
greater of: (i) 5.00 * CPIN / CPI2009 = 5.78 $/MWh
(ii) Seasonal Mid-C Price - (EFEP * Seasonal TDF)/(1-L) = -134.05 $/MWh
LD Amount = LD Factor * Delivery Shortfall * 1000 * (1-L) = $10,924.20
Clean Power Call 07-Aug-08 Page 2