Expert Sensitivity Analysis for Upstream Petroleum Models (Excel XLSX)

BENEFITS OF THIS EXCEL DOCUMENT

1. Provides a framework approach for evaluating Project Models using sensitivity (Tornado) Model
2. Support project decision models with insightful charts and analysis
3. Provides insights to what are core risks to provides to show mitigating strategies to address them

OIL & GAS EXCEL DESCRIPTION

This product (Expert Sensitivity Analysis for Upstream Petroleum Models) is an Excel template (XLSX), which you can download immediately upon purchase.

The main purpose of the model is to enable users to get a robust understanding of the business sensitivity analysis of the Oil and gas project and to evaluate the project outcomes in event of market fluctuations

The model includes calculations of 11 robust worksheets of 2 standalone projects (Oil, Gas) with prices economic and operating assumptions, capital & operating expenses models, GOCF Applications, Abandonment provisions & Project Valuation including sensitivity analysis

The model is dynamic and allows users to select the desired forecasted Years (up to 20 years). Output Reports summary & Model Charts are dynamically updated based on the selected forecast periods

The structure of the template follows standard Financial Modeling Best Practices in an oil and gas industry principles and is fully customizable to actual project scenario

Model Structure

•Project Inputs & Sensitivity
This section will address the core model drivers and input on sensitivity and the case scenarios
•        Assumptions
This section will address the model assumptions considering the Economic and developments costs
•        Economic Input
This section will address the Inflation, Escalation, Oil and Gas Prices including potential losses), Discounts, Oil and Gas production Scenarios.
•        Revenue Projections
This section will address the production and Price based scenario to produce reasonable projections.
•        Gross Operating Cash Flow (GOCF)
This section will address the operation cash flow of both oil and gas assets
•        Abandonment Modelling
This section will address oil and gas assets abandonment provisions using the Unit of production Approaches.
•        Post Economic Limit Analysis Modelling
This section will address oil and gas post Economic Limit test approaches considering the Economic limits automatic shutoff of uneconomic cash flows
•        Reserves Modelling
This section will address the Oil and Gas Reserves modelling with BOE analysis of both assets.
•        Financial Valuations Modelling
This section will address all economic yardsticks including the Free Cash Flow approach of NPV, IRR, Reserves, NCF ratio, Payouts, Forward NPV, IRR, MCE etc
•        Project Executive Summary
Professional Executive Summary (can be used for investment decisions) containing all of the high-level relevant information for review and is designed to be easy to read, print, and save to pdf.
•        Business Performance Dashboards
Presentation of Project results through sophisticated charts & graphs with drop boxes for flexible scenario and charts been updated to reflect the actual scenarios.
Help & Support
At Desyton, We are committed to world class standards and customer requirements, all our templates follow oil and gas financial modeling principles and are built carefully, keeping the user's needs in mind.

If you however experience any difficulty while using this template, please feel free to contact us for assistance.
If you need a template customized for your business requirements, please e-mail Desyton Energy() and provide a concise explanation of your business modelling specific needs.

Source: Best Practices in Oil & Gas Excel: Expert Sensitivity Analysis for Upstream Petroleum Models Excel (XLSX) Spreadsheet, Desyton Energy Advisors