EssaysForStudent.com - Free Essays, Term Papers & Book Notes
Search

Enron Pnw Hdd

By:   •  Research Paper  •  1,851 Words  •  June 2, 2010  •  1,376 Views

Page 1 of 8

Enron Pnw Hdd

Going by the effect of change in temperature in the past four years on the revenues of PNW, we know that a hedge against weather risk is of paramount importance for Mary Watts, the chief financial officer of PNW. The net income of PNW for 1999 was only 8 million while the yearly capital expenditure from 1995-1999 was 1 billion. Under this red ink budget, it came as no surprise when the equity and debts holders increased their required compensation of risk. This high cost of capital further worsened the future EPS prospects of PNW. With the forecast for two warm winters, PNW would be better off reducing their exposure to weather risks by considering the weather derivatives.

Forecast of HDD

The correlation of the electricity demand to the change of HDD is about 91.7%. The demand of electricity also represents the profits PNW can earn. In order to hedge the loss that unstable weather may bring, PNW could buy weather derivative contracts. If we could accurately predict the HDD next year, then we would know which contract of weather derivatives Enron offers would be the best fit for PNW. In this part we apply the statistical method of 95% confidence level to find out the possible range that future HDD may fall within. We then compare the HDD confidence level with the strike amount that these contracts offer.

Before calculation of the 95% confidence level of HDD, one critical factor to be considered is adjustment for the cyclical effects caused by EI Nino, La Nina, or Heat Island. The goal here is to forecast the most accurate HDD for next year. We see that the last EI Nino effect happened in 1998, implying it won’t recur until 2005 which we base upon its frequency of occurring every seven years. We should get rid of this special cyclical effect while forecasting the HDD in 2001 which is supposed to be a normal year without any cyclical weather effect. The data in the appendix is the HDD computed after the temperature was adjusted for increased trends and the volume was adjusted for increased customers. Below are the forecast procedures we used to arrive at the HDD for the next year:

1. Adjust the cyclical effect: Omit the data in 1992 and 1998.

2. Compute the mean and standard deviation after adjustments: They are 3,137 and 127.57.

3. Build a 95% confidence level:

3,137 ± 127.57 / √9 === > (3,053.66, 3,220.34)

4. Compare the forecasted HDD with the weather derivatives contracts.

The relationship between Volume and HDD

Run the regression of change in volume and change of HDD. Analyze the profits PNW lose and the risk compensation per HDD. Margin profit per MWb is 40 dollars.

Volume Change in Volume HDD Change in HDD

8825019 2978

9077284 252265 3207 229

8490052 -587232 2665 -542

9190089 700037 3410 745

9018775 -171314 3156 -254

8970078 -48697 3037 -119

8994810 24732 3032 -5

9146973 152163 3212 180

8962612 -184361 2892 -320

8998800 36188 3105 213

8989312 -9488 3094 -11

Using E-Views we calculate the regression:

Dependent Variable: Change in Volume

Method: Least Squares

Sample (adjusted): 2 11

Included observations: 10 after adjustments

Variable Coefficient Std. Error t-Statistic Prob.

C 6028.701 26256.26 0.229610 0.8242

Change in HDD 896.6034 77.08367 11.63156 0.0000

R-squared 0.944170 Mean dependent var 16429.30

Adjusted R-squared 0.937192 S.D. dependent var 331110.1

S.E. of regression 82981.43 Akaike info criterion 25.66748

Sum

Download as (for upgraded members)  txt (6.8 Kb)   pdf (117.5 Kb)   docx (13.4 Kb)  
Continue for 7 more pages »