Delivery Schedules
Day 1
Analysing the Annual Report
Review of financial statements using International Financial Reporting Standards (IFRS) and US
Generally Accepted Accounting Principles.
The information presented by the financial statements relates to past operations.
Financial Ratio Analysis: the core of financial analysis.
Utilise the Notes to the Accounts: essential supplementary information.
Use and develop Excel templates to calculate and interpret liquidity, leverage, and profitability ratios,
among others.
Utilise specially prepared Excel databases and investment surveys to benchmark financial analysis
results across a broad range of organisation types and draw conclusions from this analysis.

Day 2
Financial Planning and Forecasting
The Objectives of Financial Analysis
The Role of Assumptions in Financial Forecasting
Determination of Model and Forecast Horizons
The recognition of risk in forecasts
Development of Time Series Models using histograms, moving averages, exponential smoothing and
regression analysis
Using Regression to predict and estimate
Mastering the use of Exponential Smoothing
Developing What … if? Scenarios in Your Financial or Operational Models including the use of
excel’s Scenario Manager
Using the Excel tools Goal Seek and SOLVER
 
Day 3
The Time Value of Money
The impact time has on the value of money.
Understand interest rate calculations: simple v compound; annually, half yearly, quarterly, monthly,
daily, continuously
Using WACC and ROIC as benchmarks
Use Excel financial functions to determine Present Value, Future Value, Net Present Value, Internal
Rate of Return, Modified Internal Rate of Return among others
Day 4
Evaluating Capital Project Proposals
What constitutes “Shareholder Value?”
Finding the cost of equity
Determine the Cost of Debt, Preferred (Preference Share) Equity and Common (Ordinary share)
Equity
Calculate the Weighted Average Cost of Capital (WACC)
Identify the various types of capital projects
Discuss the capital project evaluation process
Determining the initial and subsequent capital project cash flows
Development of the “Hurdle Rate” for capital projects
Discuss the use of “Terminal Value” in evaluating capital projects

Day 5
Effective Management of Historical Data Using Excel
Determining Reliability in Model Projections
Identifying the Sensitivity of a Model
Principles of risk measurement in individual shares
Graphing expected return and risk using variance analysis
Use Excel to determine the Beta of listed share on a securities market

Course Description

This five-day, intensive, interactive course employs principles of financial analysis and Excel
capabilities to identify key variables that can significantly enhance an organisation's value in the
oil and gas sector. Through the integration of Excel tools with industry-specific cases and
exercises, participants will gain proficiency in applying advanced financial analysis techniques,
interpreting numerical data, and improving their strategic and tactical decision-making skills. The
training begins with fundamental financial analysis concepts and progresses to more sophisticated
methodologies for calculating the cost of capital and projecting the benefits of capital investment
projects. Moreover, participants will learn how to evaluate prospective partner organisations to
assess their potential to contribute strategic strength to their enterprise.

By the conclusion of this course, participants will be able to:
• Analyse a corporate annual report by identifying key performance indicators, thereby gaining
insights into what the numerical data genuinely signifies and enabling projections of future
performance.
• Benchmark corporate performance relative to peer groups and industry statistics.
• Utilise advanced functions in Excel, including the Financial and Statistical functions, aspects of
the data Analysis ToolPak and array formulas.
• Operate Excel tools, including SOLVER, Goal Seek, and Scenario Manager, effectively.
• Analyse time-series data and establish relationships using techniques such as exponential
smoothing, simple and multiple regression, and other methods.
• Comprehend the concept of the time value of money and its practical application.
• Utilise Excel with increased confidence and versatility, thereby saving considerable time and
enhancing productivity.

Anyone seeking a more advanced understanding of financial analysis, modelling, and forecasting in the oil and gas industry. Financial professionals aiming to improve their analytical,
modelling, and forecasting skills. Financial professionals need to enhance their spreadsheeting
expertise. Professionals looking to strengthen their financial and other communication skills.
Personnel from departments outside finance who need to grasp financial analysis, modelling, and
forecasting. Professionals who would benefit from consultancy opportunities to address their
analysis, modelling, and forecasting challenges through spreadsheet work or case studies.