This course will feature: • Practical application of advanced financial modelling skills to real life case studies in the Oil & Gas sector and your company • Development of advanced financial knowledge and its application to business problems and decision making • The development of Advanced Financial Models which will be of practical use to you and your organization • Training using Excel and the latest financial analysis tools and techniques • Supporting material in both hard and soft copy explaining key Financial and Modelling techniques and applications Course content: The Course Content Day One: 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 • Best Practice in Modelling with Excel Day Two: 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 • Forecasting Interest Rates & Exchange Rates using historical data, Interest Rate Parity Theory and Purchasing Power Parity Theory Day Three: Developing an Advanced Financial Optimization Model • Developing the Financial Model using Costs and Economic Variables estimated on Day 2 • 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 • Implementing Policies to manage change Day Four: 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 • Mergers & Acquisitions – Modelling the impact on Share Price, Market Value, Earnings & EPS Day Five: Modelling Best Practices • Case Study incorporating the skills from Day 1 – 4 • Developing an Advanced Financial Optimization Model to meet the needs of the delegates and their organisation • Presentation of the Model • Testing the Model • Improving the Model • Decision Making & Reporting Location: Abuja Date: Open Price: 5,000 USD
