an intensive 2-week training course the 10-day advanced...

The 10-DayAdvanced Financial Modelling & Petroleum Project EconomicsVital Techniques for Managing Risk & Performance in Oil and Gas

An Intensive 2-Week Training Course

This course is Designed, Developed, and will be Delivered underISO 29990 : 2010 & ISO9001 : 2015 Quality Standards

01 - 12 Nov 2020, Dubai

14-J

AN

-20

WHY CHOOSE THIS TRAINING COURSE?

In the globally competitive world of the 21st century business decision-makers face unprecedented levels of change, risk and uncertainty and nowhere is this more true than in the oil and gas sector. To survive and flourish in this dynamic environment petroleum professionals need the right tools with which to analyse the economic and other challenges faced by their organisations and to anticipate and manage the many opportunities and threats that may emerge. Traditional forms of economic and financial analysis no longer meet these needs and the most progressive firms are using the power of financial models to help them analyse the challenges and take a more powerful approach to managing risk and uncertainty in their planning and forecasting

This training course will highlight:

• The challenge of risk and uncertainty in modern business

• Principles of business planning and performance management

• How financial models can be used to improve business decision-making

• Practical skills in designing financial models using Excel

• Advanced approach to analysing oil and gas sector economic indicators

THE STRUCTURE

This comprehensive training course consists of two modules which can be booked as a 2-week Training event, or as individual, 5 Day courses.

Module 1 - Financial Analysis, Modelling & Forecasting

Module 2 - Petroleum Project Economics & Risk Analysis

HOW WILL THIS TRAINING COURSEBE PRESENTED?

This is a highly participative workshop style training course focused on developing practical skills that delegates can apply in real life business situations on return to their own organisation. Each module includes a thorough review of the relevant theory before focusing on life-like business case studies with which delegates can practice the design and construction of financial models, analysis tools and forecast applications in Excel, using laptops provided for the course.

WHAT ARE THE GOALS?

This hands-on PetroKnowledge training course has been designed to provide petroleum sector delegates with real practical skills to design and build financial models that will have highly relevant applications in modern oil and gas organisations. By applying advanced techniques for economic and financial analysis, delegates will develop improved skills in forecasting and business decision-making.

By the end of this training course, participants will learn to:

• Plan the design and functionality of economic and financial models in Excel

• Use powerful functions built in to Excel for statistical and financial analysis

• Apply financial analysis techniques to improve investment decision-making

• Design and build financial models for forecasting sales, costs and profit

• Implement up to date techniques for managing risk and uncertainty

• Use financial models to assist in business decision-making

WHO IS THIS TRAINING COURSE FOR?

The training course is designed to provide useful insights and practical skills to professionals from a wide range of disciplines and industry sectors, but particularly those involved in planning, forecasting and investment decision-making in an age of risk and uncertainty.

This PetroKnowledge training course is suitable to a wide range of petroleum sector professionals but will greatly benefit:

• Finance professionals• Budgeting and planning managers• Commercial managers• Divisional managers• Purchasing and supply chain managers• Project managers

www.petroknowledge.com


QUALITYCERTIFICATION

The PMI® Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.

Clear Concepts. Clean Environment.

Member of

Membership No.: 125094

DAILY AGENDA

The 10-Day Advanced Financial Modelling & Petroleum Project Economics

MODULE 1 - FINANCIAL ANALYSIS, MODELLING & FORECASTING

Day One: The Competitive Challenge in the 21st Century

• Identifying and managing stakeholder needs• Business models and how they are disrupted• An integrated approach to risk management• The essentials of business performance

management

Fundamentals of Financial Modelling

• Financial statements basics• Fundamentals of financial modelling

Day Two: Mastering Financial Analysis

• Building a financial ratio database in Excel• Practical modelling: The cost-volume-profit

relationship• Measuring and improving return on investment• Measuring and improving asset management

efficiency• Measuring and managing capital structure and risk• Practical modelling: The effect of gearing on

shareholders’ earnings

Day Three: Improving Financial Forecasting

• Practical modelling: using Excel statistical analysis tools

• Avoiding common forecasting problems• Using moving averages to analyse time series data• Using linear regression for sales trend analysis• Using Excel Solver to minimise forecasting error• Using regression and correlation to forecast costs• Practical modelling: Cash flow forecasting

Day Four: Financial Models to Improve Investment Decision-Making

• Principles of capital investment decision-making• Sources and cost of business finance• Practical modelling: using Excel discounted cash

flow tools• Practical modelling: Capital investment analysis• Essentials of business valuation• Practical modelling: Business valuation based on

shareholder value added

Day Five: Managing Risk and Uncertainty

• Identifying and analysing business risk• Probability based approach to decision-making• Monte Carlo simulation• Sensitivity analysis and “what-if” forecasting• Identifying the key drivers of financial performance• Practical modelling: Key driver “what-if” forecast

MODULE 2 - PETROLEUM PROJECT ECONOMICS & RISK ANALYSIS

Day Six: Cash Flow Analysis

• Familiarization with Economic terms• Setting up Cash Flow Calculation• Depreciation Methods• Loss Carry Forwards• Inflation• Nominal & Real Cash Flow• Sunk Costs• Project Financing

Day Seven: Economic Indicators

• Economic Indicators Definitions• Present Value Concept• Discount Factor• Net Present Value• Internal Rate of Return• Effect of Project Delay• Payback Period• Profit/Investment Ratio• Incremental Projects

Day Eight: Risks and Uncertainties

• Risk & Uncertainty• Expected Value Concept• Decision Tree Analysis• Farm-out Decision• Probability Analysis• Sensitivity Analysis• Probability Distribution• Monte Carlo Simulation

Day Nine: Setting up Spreadsheet Calculation

• Introduction to Spreadsheet Calculation• Simple Cash Flow using Excel• NPV calculations• Application of economic indicators• Class discussion

Day Ten: Setting up Oil Field Development Model

• Group activities• Setting up an Integrated Economic Model of a

Typical Oil Field Development• Project Sensitivity Analysis for the selected model• Introduction to Russell field model• Final remarks

The 10-Day Advanced Financial Modelling & Petroleum Project Economics

Please use BLOCK CAPITALS to fill in this form. It is important that you read carefully through all information before starting to complete the form.

REGISTRATION DETAILS

AUTHORISATION

IN-HOUSE TRAINING

Family Name: ____________________________________________ First Name (Mr./Ms.): _________________________________________

Position: ________________________________________________ Company: ____________________________________________________

Mailing Address: _______________________________________________________________________________________________________

Telephone:____________________ Mobile: _____________________ Fax: ________________________ Email: ________________________

Authorisation By: ______________________________________________________________________________________________________

Position: ________________________________________________ Company: ____________________________________________________

Mailing Address: _______________________________________________________________________________________________________

Telephone:____________________ Mobile: _____________________ Fax: ________________________ Email: ________________________

Maximize your training budget and have several members of your staff, who require specific training, to attend with the advantage of not incurring additional travel costs when attending a ‘public’ training courses & seminars.

Would you like a PetroKnowledge training course delivered at a time or location to suit you? Would you like PetroKnowledge to tailor a course from our comprehensive library of programmes? Or would you like us to create an entirely new, bespoke course to suit the exact needs of your organisation?

Working in partnership with our clients, PetroKnowledge provides an enjoyable, creative learning experience that enables participants to develop their skills and knowledge. We can deliver not only generic, off-the-shelf courses from our extensive learning portfolio, but we can provide tailored as well as bespoke learning on any aspect of skill development or knowledge. Our in-house courses are conducted by the same expert trainers who conduct PetroKnowledge public courses so you can be assured they will fulfill the learning objective of any organisation

4 DATE VENUE FEE($)

01 - 12 Nov 2020 Dubai - UAE 9,900

This fee is inclusive of Documentation, Lunch and Refreshments


BOOKING TERMS & CONDITIONS

Booking• Bookings for courses can be made via our website (petroknowledge.

com) or by contacting our Registration Desk on +971 2 5577389 or at [email protected]

• For on-line bookings, please select the course that you require and click on the “Register Now” button, following the instructions step by step

• Upon receipt of booking in order, enrollment on the respective training course will be confi rmed by Registration Team with all necessary documentation

Invoicing and Payment• Our fees include course presentation, relevant materials, physical &

digital documentation, lunch and refreshments served during entire training. Accommodation charges are not included in the course fees

• Course fees are payable upon booking unless a valid, authorized Purchase Order is provided and accepted

• Invoices will be sent via email/courier to the ID/name and address provided

• We prefer to have the fees payment in our account before the start of training course. However, if your company has a different payment policy, the same should inform us in advance

• The currency of fees is in US Dollars (USD). Payments can be made in USD or UAE local currency AED (Arab Emirates Dirhams) either by Bank Transfer or by Credit Card. Our Bank Account details will be provided on the Invoice

• Please note that we do accept payment by cash, in USD or AED, only for the last minute bookings

Cancellation of Courses• It may be necessary for PetroKnowledge to amend or cancel any

course, course times, instructors, dates or published fees due to unforeseen circumstances and we reserve the right for such changes

• Any amendments will be advised before the course start date and any bookings already paid in full will not be subject to increased fees

Cancellation by Client• Once you have completed your booking, received your confi rmation

of enrollment and a dated payment Invoice, you are deemed to have a contract with PetroKnowledge. You reserve the right to cancel this contract given the below terms

• All cancellations must be received in writing at [email protected] and [email protected] at least 21 days prior to the training

• After the cancellation period has expired, consideration may be given, on a case to case basis, if a registered delegate nominates a substitute on the same course, shifts to next session of the course or moves to a new course

• For a cancellation request made on or before the statutory 21 day cancellation period, a credit note issued which can be used against future course fees

• A 25% administration fee (of the total course fee at the time of booking) will be charged for any cancellations made outside of the statutory cancellation period

Attendance Certifi cate• The daily course schedule should be accurately followed to ensure

undeterred implementation of our training• All delegates, who participated in their course throughout, will receive

the Certifi cate of Completion on the last day• Please report any foreseeable absences to a PetroKnowledge

representative or to your sponsors directly• An absence of three (3) or more sessions of the course will invalidate

your eligibility for the Certifi cate of Completion

OFFICES:

MENA Head Office:P.O. Box: 215074, Office No. 2101BTower B, Business Central TowersDubai, United Arab EmiratesTel: +971 4 571 4600Mobile: +971 56 222 7795

Abu Dhabi Representative Office:P.O. Box: 135120Abu DhabiUnited Arab EmiratesTel: +971 2 557 7389 Fax: +971 2 557 7128

E: [email protected]

Follow us on:

an intensive 2-week training course the 10-day advanced...

Documents