Expert Breakeven Analysis for Upstream Petroleum Modeling (Excel XLSX)

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

The model includes calculations of 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 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
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 losses), Discounts, Oil and Ga 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
• Reservices 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.
• Breakeven Analysis
This section addresses the Breakeven analysis of Price, Production and revenue for both Oil and Gas Assets.
• 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

Committed to high quality and customer satisfaction, all our templates follow best practice financial modeling principles and are thoughtfully and carefully designed, keeping the user's needs and comfort 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.