Financial Model, Mining Industry, Oil & Gas

Break-Even, DCF Model, Project Finance, Scenario Analysis, Sensitivity Analysis

 

Model Overview:

Breakeven Financial Model and Valuation Analysis of an Upstream Oil & Gas Project.

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 the event of market fluctuations.

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

The model is dynamic (and fully customizable) and allows users to select the desired forecasted Years. The Structure of the Output Reports  & Model Charts is dynamically updated based on the selected forecast scenario.

Model Structure

• Project Inputs
  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 & Gas Prices including losses), Discounts, and 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 operating cash flow of both oil and gas assets
• Abandonment Modelling
  This section will address oil and gas asset 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 modeling with BOE analysis of both assets.
•  Valuations Modelling
  This section will address all economic yardsticks, including the Free Cash  Flow approach of  NPV, IRR, Reserves,  NCF ratio, Payout period, Forward NPV, IRR, MCE, etc.
• Project Executive Summary
  Professional Executive Summary (can be used for investment decisions) containing core  high-level summary designed to be easy to read on a portable display format
• Breakeven Analysis
  This section addresses the Breakeven analysis of Price, Production, and revenue for both Oil and Gas Assets.
• Business Dashboards
  Presentation of Project results with professional charts & graphs with drop boxes for flexible scenarios and charts been updated to reflect the actual scenarios.

Help & Support

For Help & Support regarding bespoke modeling consulting & advisory, we are happy to provide support, including customization for bespoke project modeling. Please send an email to the support team with further details and specifications of your request.

File Types: .xlsx and .pdf