DOE OSTI2022
FECM/NETL Unconventional Shale Well Economic Model (UShWEM) is an Excel-based model that evaluates the economics of an unconventional shale well on a per-well and per-pad basis. The model calculates the net cash flow, internal rate of return (IRR), net present value (NPV), earnings before interest, taxes, depreciation, and amortization (EBITDA), payout month and year, and breakeven price (for either oil- or gas-wells). The model can be used to estimate the economics of a well or pad over its lifetime (development through site reclamation) based on (1) the capital and operating costs associated with well/pad development and operations, (2) the revenue associated with oil, gas, and condensate production streams, and (3) accounting for relevant tax policies and asset depreciation applicable for oil and gas operations. The main input for the model is the completion design and production data. Key financial considerations in the model include oil, gas, and condensate market prices, tax-related settings, royalty rates, the discount rate, minimum economic hurdle (IRR) [if performing break-even analysis], and project contingency. The financial consideration can be adjusted to reflect the level of granularity the user requires as input when calculating the economics for a well or pad development. In addition, the model affords users the option to provide their user inputs for all cost categories considered. As a result, the model can be used to generate a multitude of scenario cases for sensitivity analysis of the various financial considerations, as well as production and cost profiles. To make this seamless, the model has the capability for key economic outputs to be exported in large batches through macros-enabled functions on its “Model Output Summary” and “Multi-Well Cost Analysis. The spreadsheet model includes macros and user-defined functions, so the user must enable Excel’s macro capability for the model to function correctly.