Value the following tolling contract on a natural gas fired power plant. You will turn in an Excel file with your calculations. A well-organized spreadsheet should allow me to change some of your assumptions to see the effect on the contract value. Within the spreadsheet in a text box, you should supply a couple of paragraValue the following tolling contract on a natural gas fired power plant. You will turn in an Excel file with your calculations. A well-organized spreadsheet should allow me to change some of your assumptions to see the effect on the contract valuephs explaining your assumptions and methodology. You should also supply your level of confidence in your estimates (you can do this in Monte Carlo fashion by varying the inputs and observing your range of contract values). Contract Details:
1. Your contract is for 500 MW per hour, for every on-peak hour from 6/1/2016 to 11/30/2016 (inclusive of start and end dates).
2. Note on-peak means 5x16, or Monday through Friday from the hour ending 0800 to the hour ending 2300.
3. The plant delivers electricity to PnodeID 40243293 on the PJM Interconnection.
4. The plant's heat rate (HR) is: 8.1.
5. The contract states, for each day you choose to produce electricity, you'll pay the day's Henry Hub spot natural gas price plus $0.15.
6. You will receive the real-time wholesale electricity price at the plant's PnodeID.
7. For each MWh you choose to produce, you'll pay an operating fee of $0.80. You won't have to pay any other costs such as those for starting up theplant (if necessary).
8. For each day you can either produce 500 MW per hour or nothing. Therefore for each day you will produce 16*500 = 8000 MWh or 0 MWh.
9. You must notify the plant by 6pm if you plan to run the plant the following day.
10. For one day only in the interval 6/1/2016 to 11/30/2016, you have the right to produce an extra 300MW per hour during the on-peak hours. Once you exercise this right on a particular day, the right ceases to exist. To get you started, the plant's HR (a measure of efficiency) is defined as the number of British thermal units (Btu) of input fuel required to generate 1 megawatt hour (MWh) of electricity. Thus, for a particular plant, the heat rate can be written as HR = SE SG MMBtu/MW h where SE and SG denote the spot price of electricity and natural gas respectively. Given the HR, the cash flow from the opportunity to generate 1 MWh of electricity at some point in the future (denoted by T) may be written as CF = max(S T E - (HR)S T G, 0) where CF denotes cash flow. Remember, you are producing 500 MW per hour and not 1. Also note, I have not taken into account other factors such as your operating fee, and your basis from Henry Hub.