Loader
logo
Course Image

Practical workshop: Excel analysis of oil, gas and power supply chains

Energy Institute

Send an Enquiry

Course Description

This course provides hands-on instruction for building, developing and applying spreadsheet economics, risk, finance and decision evaluation models to a range of projects from the oil, natural gas and power supply chains. The course is built around a series of workbook modules compatible with Excel 2010, 2007 and 2003 versions. Delegates are required to bring their own laptop computers loaded with a functioning version of Excel (i.e. 2003, 2007 or 2010 version) for use during the course. Delegates are provided with a number of spreadsheet workbooks to load and then evaluate with structured exercises. Some basic knowledge of operating Excel software is required, but detailed computer modelling expertise is not essential. The emphasis is on fit-for-purpose energy industry model applications rather than developing spreadsheet skills, but both should be part of the learning outcomes. The course is broken down into approximately one-quarter theoretical instruction and three-quarters practical , hands-on facilitated spreadsheet model evaluation. Brief PowerPoint presentations are delivered to review the industry topics covered and these will lead swiftly into the practical sessions. The economic analysis theory sections also aim to provide insight to the key economic issues impacting the supply chains covered. Many companies make extensive use of proprietary economic modelling software, often requiring macros to be built to evaluate case-specific problems. In such cases, even though spreadsheets may not be used routinely, it is of enormous benefit for analysts and decision-makers to understand how such models can be built, developed and manipulated on a spreadsheet platform. Spreadsheets in conjunction with built-in functions, add-ins and VBA macros provide an extremely powerful platform for such analysis. The course?s practical sessions will demonstrate how such features can be simply and effectively harnessed to build quite sophisticated, but highly functional, analytical models. Digital copies of all training materials will be provided to delegates. Detailed Content Covered by Course Day One ? Oil and Gas Project Analysis Overview of Cash Flow Analysis and Discounting Techniques Cash Flow Model For Oil and Gas Exploration, Development and Production Fiscal Models for Tax and Royalty and Production Sharing Terms Excel?s VLOOKUP Function Aids Models with Sliding Scales Rate Building Models (Tariff Calculations) for Midstream Infrastructure Levelized and Rolled-in Tariffs Day Two ? Pricing Issues and Sensitivity and Scenario Analysis Inflation, Money of the Day versus Real Terms Selecting Alternative Multi-year Pricing Profiles Excel?s Spinners and Choose Function Netback Pricing Models Establishing Break-even Prices Using Excel?s Solver and Goal Seek Functions Requirements for Sensitivity and Scenario Analysis VBA Macros: Powerful Dimension to Excel?s Sensitivity and Scenario Analysis Cost and Revenue Components For Constructing a Gas Liquefaction Plant LNG Shipping and Netback Price Model Risk Analysis, Probabilities and Expected Monetary Values Day Three ? Decision Trees and Simulation Building Oil and Gas Production Profiles Using Decline Equations Building Cost Escalation Using growth Equations Decision Trees and their Application Dynamic Graphics with Updating Labels Driven by Spinners Monte Carlo Simulation Method and input Distributions Demonstrations with Excel Add-in Crystal Ball Statistical Analysis and Optimisation of Simulation Outputs Refinery Economics: Gross Product Worth (GPW) and Margin Analysis Day Four ? Power Generation, Debt Finance and Hedging Cash flow Model for Combined Cycle Gas Turbines (CCGT) Cash flow Model for Coal-fired Power Plant Carbon Capture and Sequestration (CCS) Models Cash flow Model for Full-cycle Nuclear Power Plant Cash flow Model for Offshore Wind Farm Debt Financing Upstream Oil and Gas Projects Evaluating Hedging Alternatives Profit and Loss Model for Futures Swaps and Options Who Should

This course provides hands-on instruction for building, developing and applying spreadsheet economics, risk, finance and decision evaluation models to a range of projects from the oil, natural gas and power supply chains. The course is built around a series of workbook modules compatible with Excel 2010, 2007 and 2003 versions. Delegates are required to bring their own laptop computers loaded...

Read More

Related Courses