Blog
Note: the Tolling Project background information pdf is written for an in-person
Note: the Tolling Project background information pdf is written for an in-person group project. For this project, you are going to value a tolling contract on an existing power plant on the PJM interconnection.
You are only required to do a discounted cash flow analysis. Start with the ‘General Background Information Link’ under the Tolling Project Assignment. Under ‘General Notes’ please make sure to read number 3. This is important. Under the ‘Data’ heading, there are links for LMP by hour and PNODE. You are to follow the links, you want the ‘‘Total LMP Real Time’ data and you need to sort by PNODEID (Found on the other pdf titled ‘Tolling Assisnment’). You also need the link for Henry Hub (these are historical natural gas spot prices i.e. your basis).
TEXTBOOK USED IN THIS COURSE
Ross, S. A., Westerfield, R. W., & Jaffe, J. (2009). Corporate finance (9th ed.). McGraw-Hill/Irwin.
6/23/24
Question
1.On the Henry hub website, we can download the “Natural Gas Spot Price” for a specific date, is that SG?
2. about SE, is that “total LMP Real time” for PnodeID 21601864 ?
3. Since we only have historical data, can I use the data from 06/01/2023 to 08/30/2023? should I consider the discount rate?
Reply from professor
Yes, the Henry Hub data from the EIA website will serve as our base price. You have the option to utilize either Henry Hub spot prices or futures prices. For example, you could calculate the average spot price for the month of June 2023 to establish a representative spot price for June 2024 (considering the highly seasonal nature of these prices). Alternatively, you may review the futures prices provided on the EIA website. There is no definitive ‘right’ answer in choosing between these methods; your approach should include a brief explanation of your methodology and the rationale behind your selection of the spot price. The spot price determined through your chosen method will be used as your 𝑆𝐺. **NOTE: Electricity prices are highly seasonal and also vary according to a common pattern throughout the day. They also can differ markedly by location. So do not use your PnodeID’s average price at 2pm in July 2013 to predict the average 2pm price for November 2013. Use the average 2pm price for November 2012.
Yes, the “total LMP Real Time” should be sorted for PnodeID 21601864 (Steel City).
Yes. The discount rate is also something that you choose along with a brief explanation of how you came up with it.
As an aside, you are given the heat rate (7.8) so you do not need to calculate the heat rate.
7/4/24
Recent question from a student
I am drafting my Excel, but I am not sure if my steps are correct.
download the LMP data for PnodeID 21601864 and sort the date and time (06/01/2023-08/30/2023 8:00-23:00) to calculate the average hourly electricity price of June 2023 is around$22.84.
download the data from Henry Hub, and figure out the average daily spot price of June 2023 is around $2.18/ Mbtu
calculate Daily Revenue: hourly electricity price X 300MV X 16 HRs
calculate Daily Cost, Daily operating cost =$0.65/MVh X 300MV X16HRs. Daily Natural Gas Cost =$2.18/ Mbtu X 7.8 X 300MV X 16HRS+ $0.25/day? (here I am confused, $0.25 is henry hub fee for the whole day or I should ($2.18/Mbtu+$0.25)X7.8X300X16?)
Daily Cash flow = Daily Revenue-Daily Cost
Calculate the Cash Flow for the Whole Project.
Professor response
“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.25.”
Natural gas prices utilities pay are often Henry Hub + a basis. In this
case the basis is $0.25. So if Henry Hub is $2.00 per mmBtu, your power
plant will pay $2.25 per mmBtu.
The idea is that there is not one natural gas price in the US,
there is a price for every location. The price in Boston may be
substantially higher than the price in Central Pennsylvania for
example. At the same time, Henry Hub is the most liquid trading point;
it is where “price discovery” happens. So it is natural to price
as Henry Hub + basis.

