10-PAGE PAPER WITH AN EXCEL CASHFLOW

profileDr Huntington
copy_of_project_data.xlsx

Project Data

Country Jordan
Well cost MM$ 7.5
Condensate flow rate (Initial) Bbl/d 3950
Gas flow rate (Initial) MMscf/d 23
Gas gravity Air = 1 0.82
Oil Gravity °API 53
H2S content % 17
Drilling rigs available No. 3
Time to drill well Days 98
Reservoir Pressure Psia 4140
Z-factor 0.97
Area Acre 4600
Phi % 22
h ft 82
Sw % 18
Decline rate (exponential) %/yr 16
Depreciation period (Minimum) Years 3
Oil severance tax oil % 13
Severance gas % 12
Gas price (Service contract) $/MSCF 26
Discount rate % 18
Some data are not provided. You will need to come up with reasonable estimates for these.
For plant capex and opex, use offsets or rules of thumb in the course text. Assume costs spread evenly over three years.
For your cash flow model, assume all revenues and costs occur at the end of each year.
Assume wells can produce at the start of the year after they were drilled.
Do not forget that sulpur can be a product!
Assume gas production will decline according to an exponential relation (also called "constant percentage decline").
Depreciation period starts when capex is put into service. It cannot exceed the economic life of the project
You do not have to use all the drilling rigs available.
Try to optimise the profitability in terms of NPV.
Make sure your recovery factor is reasonable compared with the OGIP.