Foundations of Finance

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

Foundation of Modeling

• Basic Excel functions
• Steps to develop a Financial Model
• Flow charting Techniques to improve Modeling
• Input Tables
• Pivot Tables
• Foundation Analysis Tools in Excel

Financial Modeling

• Forecasting the Income Statement, Balance Sheet (Statement of Financial Position) & Cash flow Statements
• Budgeting Models
• Purchase Decisions
• Modeling 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

Modeling Risk Management Scenarios

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

Modeling 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