• Mastering key formulas in financial models
  • Introduction to financial modelling by covering useful keyboard navigations, formatting, name ranges and data grouping
  • Going through the 10 most commonly found Excel formulas / functions in financial models via a hands-on and practical exercise.
• Skills for sophisticated analysis of oil gas projects (note: case study / industry to be refined depending on client’s requirements)
  • Financial modelling of oil and gas projects requires a robust and flexible approach to develop analytical functionality which addresses the needs of sponsors, investors, operators and project finance banks
  • This practical training course in financial modelling includes workshop topics aimed at equipping participants with stronger skills for sophisticated analysis of oil gas projects
  • Gain insights in the need for financial modelling best practice in the oil and gas sector:
    • Review the foundation principles of best practice financial modelling methodology and its application in the oil and gas industries
    • Discuss good vs. bad financial modelling techniques, highlighted by real life example
    • Learn to work with our powerful and easy to follow best practice modelling methodology
    • Implement initiatives in standardisation of modelling within your organisation
• Understand the lifecycle of a financial model
  • Workshop the lifecycle of a financial model, from project screening to debt analysis and operations
  • Review the timeline for a typical project and related milestones, including equity commitment, project finance and construction
  • Understand that requirements from a financial modelling perspective across this timeline
  • Assess the needs for financial model functionality for various stakeholders, from project finance banks to equity sponsors and operators

• Develop a model layout and structure that is robust, flexible and consistent
• Develop a structure for your financial modelling
• Develop building blocks of a professional industry specific / O&G model including:
• Build in a flexible construction phase for greenfields O&G projects

Introduction to macros and VBA in financial modelling

■    Understand the different types of circular references and how to avoid them

■    Understand the pros and cons of using macros in models, when to use and when to avoid

■    Introduction to the VBA environment by building in a commonly found macros in financial models

Practical application of macros in transaction and deals modelling

■    Building in a debt sizing macro to solve for a target maximum gearing or minimum DSCR

■    Building in a macro to solve for forward-looking circularities and a combined macro that solves for all macros in the model

Understand modelling auditing and validation techniques

■    Understand how to incorporate self-checks into all of your calculations

■    Learn the tricks of the trade to rapidly identify a wide range of errors and decrease model risk

■    Avoid big picture errors with analytical review methodologies

■    Understand the different model auditing processes

■    Discussion of where to focus your efforts in reviewing a model on a live deal while facing limited time constraint

Modelling for other sectors

■    Discussion of differences and similarities between an O&G vs modelling for other industries of client’s preference such as renewable energy, etc.

■    Learn to use goal-seek in conjunction with macros to solve for a tariff/price calculation mechanism commonly found in PPP or infrastructure models

Continuous coverage on advanced financial modelling, charting & Excel concepts

■    Develop an understanding of advanced Excel functions for financial models

■    Learn to create powerful and dynamic charts

■    Continuous emphasis on tips and tricks in using Excel more efficiently