Advanced excel for finance function / Unit
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: 12th-16th December 2022
Price: 5,000 USD