Foundations of Finance

• Financial & Management Accounting
• Developing Financial Statements – Income Statement, Balance Sheet (Statement of Financial Position) & Cashflow Statements
• Financial Performance using Ratio Analysis
• Management Accounting – developing Budgets
• OPEX & CAPEX
• Financial Terminology Explained

Foundations of Modelling

• Basic Excel functions
• Steps to develop a Financial Model
• Flowcharting Techniques to improve Modelling Input Tables
• Pivot Tables
• Foundation Analysis Tools in Excel

Financial Modelling

• Forecasting the Income Statement, Balance Sheet (Statement of Financial Position) & Cashflow Statements
• Budgeting Models
• Purchase Decisions
• Modelling Finance Decisions – Equity or Debt and the Cost of Capital
• Capital Investment Decisions – Payback, ARR, NPV& IRR using Excel
• Graphs & Charts to support financial models

Modelling Risk Management Scenarios

• Identifying the major Risks in the Oil & Gas sectorModelling Risk & Uncertainty
• Sensitivity Analysis
• Scenario Analysis
• Break Even Analysis
• Modelling & Managing changes in Interest Rates & Exchange Rates

Modelling the Financial Performance of Oil & Gas Projects

• Variance Analysis
• Critical Path Analysis – Financial & Manpower implications
• GANTT Charts
• Earned Value Analysis
• Managing Variances
• Simulating changes in the project

Advanced Modelling Skills with Excel 

• From Basic Modelling to Advanced Modelling
• Identifying Financial Applications for Modelling in the Oil & Gas sector
• Advanced Financial Applications of Excel
• Advanced Financial Analysis Tools in Excel
• Graphs & Charts to aid Financial Analysis

Estimation Models - Income, Costs, Risks & Economic Variables (Oil Prices, Exchange Rates & Interest Rates)

• Cost Estimation – Incremental; Inflation, PERT, Supply & Demand factors
• Forecasting using Statistical Methods in Excel – Time Series Analysis, Exponential Smoothing, Correlation & Regression Analysis
• Risk Measurement using – Probability Analysis, Correlation & Beta
• Forecasting Oil Prices using statistical models Measuring & Managing Investment Risk

Developing an Advanced Financial Optimisation Model

• Developing the Financial Model using Costs and Economic Variables
• Simulating changes to Costs & Accounts Payable Simulating changes to Sales Volume, Oil Price & Accounts Receivables
• Financial Derivatives – Forwards, Options Futures & Swaps
• Using Derivatives to Managing Oil Price Volatility, Interest Rates & Exchange Rates

Models to Assess Growth Strategies Evaluating growth strategies

• Models to simulate growth strategies
• The dangers of Overtrading
• Examining the impact on Working Capital
• Examining the impact on Leverage

Modelling Best Practices

• Developing an Advanced Financial Optimisation Model to meet the needs of the delegates and their organisation
• Presentation of the Model
• Testing the Model
• Improving the Model