FINANCIAL ANALYSIS, MODELING & FORECASTING IN THE OIL & GAS INDUSTRY

This course is essential for databases of companies and situations in the oil and gas industry. The financial analysis, modeling & forecasting in the oil & gas industry course uses Excel and oil and gas based cases and exercises and studies how to master numerous tools and functions it provides to apply the recent financial analysis techniques. The principles of financial analysis and the power of Excel to identify the important variables that can enhance the value of an organisation in the oil and gas industry will be a focal point.

Here participants will be exposed to understand what the numbers are revealing and be better able to make tactical and strategic decisions. The course will analyze companies from around the globe: both IFRS based companies and US GAAP companies. The course will understudy advanced techniques for determining the cost of capital and methods of projecting the benefit of capital projects.

Course Objective

At the end of this course, participants will be able to:

• Efficiently use Excel tools such as Solver, Scenario Manager, Goal Seek
• Analyze time series data
• Understand the time value of money and its application
• Evaluate a company’s annual report identifying key performance indicators in order to understand the numbers and make projections of future performance
• Benchmark corporate performance against industry statistics.
• Develop relationships using such techniques as exponential smoothing, multiple and simple regression analysis.

COURSE OUTLINE

MODULE 1: THE COMPETITIVE CHALLENGE IN THE 21ST CENTURY

• Identifying and Managing Stakeholder Needs
• Business Models
• Risk Management Approach
• Business Performance Management
• Financial Modelling Fundamentals
• Basics of Financial Statements

MODULE 2: MASTERING FINANCIAL ANALYSIS

• Developing a Financial Ratio Database in Excel
• Practical Modelling
  • The Cost-Volume-Profit Relationship
  • The Effect of Gearing on Shareholders’ Earnings
• Improving and Measuring Return On Investment
• Improving and Measuring Asset Management Efficiency
• Measuring Capital Structure
• Managing Risk

MODULE 3: REFINING FINANCIAL FORECASTING

• Preventing Common Forecasting Problems
• Forecasting using:
  • Moving Averages to Analyse Time Series Data
  • Regression and Correlation to Forecast Costs
  • Linear Regression for Sales Trend Analysis
  • Excel Solver to Minimise Forecasting Error
• Practical Modelling:
  • Using Excel Statistical Analysis Tools
  • Cash Flow Forecasting

MODULE 4: INVESTMENT DECISION-MAKING & FINANCIAL MODELS

• Capital Investment Decision-making Principles
• Cost and Sources of Business Finance
• Essentials of Business Valuation
• Practical Modelling:
  • Capital Investment Analysis
  • Using Excel Discounted Cash Flow Tools
  • Business Valuation Based on Shareholder Value Added

MODULE 5: RISK MANAGEMENT

• Recognize and examine Business Risk
• Decision-making Approach
• Monte Carlo Simulation
• Sensitivity Analysis and “what-if” Forecasting
• Determining the Key Drivers of Financial Performance

Who Should Attend?

• Financial professional
• Planning Managers
• Cost and Management Accounting Staff
• Finance Managers
• Commercial Managers

Delivery Method: This will include combine lectures, discussions, group exercises, case studies and illustrations. Participants will also understand the theoretical and practical knowledge of the topic.

Venue: ABUJA 

Fee:5,000 USD 

Duration: 1 week

Course Date: 11th-16th, 2022