Energy Project Investment and Finance
Task 1: Estimation of Cost of Equity, WACC and Project Evaluation
You are working for a small oil & gas E&P company which is considering an oil field development project to extract crude oil. The company would like to assess the viability of the project using the DCF approach. The total investment of the project is $4.0bn, which is scheduled through $1.0bn initial investment, $1.5bn in the first year, $1.0bn in the second year, and $500m as working capital and cash reserves ($300m WC and $200m CR). The project is expected to be financed with 60% debt and 40% equity. The debt, which will be drawn over two years (0.4bn initially, 1.0bn in first year and 1.0bn in second year), is scheduled to be fully amortized over 10 years with equal repayments at 6.0% interest. The production will start from the end of the 1st year (i.e. 15m bbl from beginning to the end of year 2), increase to 25m bbl in the following year and 35m bbl the year after. The production is expected to decline from year 10 at a rate of 12% to the end of the project. The operating cost is estimated to be initially $20/bbl per year and increase with inflation (2%pa). The project which is a PSC is planned for 25 years and as an IOC you are required to pay royalty of 10% and share the profit 50-50. The oil revenue will be taxed at 25%; while there will be a 50% limit on cost recovery and depreciation rate is 15%pa.
1- Assuming current price of oil is $65/bbl, prepare a spreadsheet to calculate the projected CADS of the project.
2- Construct the debt repayment installments and calculate the equity cash flow.
3- Collect information on the beta of a sample of oil and gas exploration and production companies (e.g. 10 or 15 small to mid-size companies), market risk premium, risk free rate, as well as debt and equity of the sample companies. Estimate the asset and equity betas, and calculate the cost of equity and WACC of the project.
4- Use the WACC and Cost of equity to estimate the NPV of the project.
5- Use the book value of equity and debt to calculate the cost of equity every year and the new NPV of the project.
6- Optional with no marks: Estimate the NPV of the project using multiple discount rate and QMV method.
Task 2: Oil and Gas Project Evaluation under Uncertainty
In some E&P projects oil and gas are found together and in the same reservoir, which means for every barrel of oil produced, there will be some associated gas. The expected gas production from the field is expressed in Gas-to-Oil Ratio (GOR); i.e. the number of cubic feet of natural gas produced with a barrel of oil. A high gas-to-oil ratio is extremely undesirable because the pressure in a reservoir, the propulsive force to move the oil in the formation to the boreholes, can be depleted as gas is recovered. And with the reservoir pressure gone, a great percentage of the oil may not be recoverable, except by a costly secondary recovery program. Therefore, when evaluating an E&P project we should consider the production and sale of both oil and gas. In this exercise, you are asked to produce a spreadsheet for evaluation of an E&P project using simulation techniques.
The oil field under investigation is estimated to contain enough oil to yield a production rate of 5m barrels in the first production year (year 2), 10m bbl in the second production year, 20m bbl from 3rd production year for 7 years, and decline at a rate of 8% per year thereafter until year 20. It is also expected that the field will have a Gas-to-Oil Ratio of 80cf/bbl, which means that for every 1000 barrels of oil extracted, 80kcf of gas is produced. The total investment for this project is estimated to be $3500m which spreads over two year development period ($1500m initially, $1000m a year for year 1 and 2), and operating cost at $30/bbl which is expected to escalate at 3% per year (rate of inflation) during the production period. The production is planned to start from the beginning of the second year and a reinjection process is planned to be introduced from year 11 at a cost of $15m per year to boost production by 5%.
Task 3: Intrinsic Value of Gas Storage Contract
You are working for a small investment group which is considering renting a gas storage facility for the next year as there seem to be a good opportunity to make some profit due to shape of the Gas forward curve. The facility has a capacity of 50,000,000mmbtu with a maximum injection and withdrawal rates of 1,400,000mmbtu per day and 1,100,000mmbtu/d, respectively. The cost of injection is $0.07mmbtu and cost of withdrawal is $0.05mmbtu. Under the contract the storage will be taken over half full and should be given back at the end of the period half full.
Task 4: Real Option Valuation
The Green LNG plant is planned to construct and operate 3 LNG trains with a total production capacity of 10mt of LNG per year. The NPV of this 30 year project is estimated to be $500m. Given the volatility of the NG prices and the LNG market, it is estimated that NPV of the project to have a volatility of 35%. However, the company has the option to increase production by 25% for an additional cost of $400m if LNG demand and prices increase. In addition, the company has the operational flexibility to reduce production by 40% and make a cost saving of $150m, should LNG prices fall.
1- Given the above information, assuming an interest rate of 4%, construct a 60-step binomial tree to estimate the value of these options (expansion and contraction) and the expanded NPV of the project.
2- Comment on your results and discuss any other operational optionality that you may be able to use in this project.
This Question Hasn’t Been Answered Yet! Do You Want an Accurate, Detailed, and Original Model Answer for This Question?
She is a great writer, editor, very good with understanding the task at hand and taking directions of what is being asked of her. Also she's very time efficient, I received my paper ahead of time with tracked changes so that if I had anything I would like to change, she would be able to do that and I would still receive my paper on time. Definitely use her services again.
Great revision for my paper! Thank you so much!
I was surprised by how fast the writer accomplished this task in only a couple of hours with really high standards writing. Very satisfied
Great working with Terrence, very responsive and able to adjust on the fly if needed. Recommend highly.
Greats work and on time which is definitely a plus. She is underrated. Her attention and quality and not to mention price will allow her to get first pick when it comes to our professional article writing needs within our company. A+
He did exactly what I asked him and more! Delivered very quickly and communication was easy. Support team also swift. The work was very professionally done and delivered as expected I highly recommend this service with full appreciation and give it a positive stamp of approval. Thank you!
This is my 2nd time working with Isabella. Her knowledge and skills are exceptional. She understands the brief and able to produce exceptional content in a short turnaround time. Her attention and quality and not to mention price will allow her to get first pick when it comes to professional writing needs within our company. A+
First time using Pehdih. When I was writing my dissertation, I got stuck using SPSS to analyze the data. The writer was very kind and understood the task completely. He helped me analyze the data. Thank you for the great work. I recommend this vendor A LOT. Will definitely be back for more
Presented her with 2 very broad topics to research and summarize into points I could use for my book. Output was excellent, delivering a clear summary to the questions in a very short turn around. Will definitely use again!
Copyright © 2012 - 2023 Apaxresearchers - All Rights Reserved.