Training Financial Modelling and Petroleum Project Economics

Training Financial Modelling & Petroleum Project Economics

Introduction

Highlights of the seminar include:

• A seminar which takes delegates from Excel basics to the most advanced use of Excel.
• Real world approach to the discipline.
• Numerous examples based around the oil and gas industry.
• Dual approach that not only develops modelling skills but also financial management skills.

Objectives

The seminar provides delegates with the tools required to find better answers to questions such as:

• How to improve the quality of the quantitative analysis of my corporate presentations
• How to model and advise on hedging price changes in the oil and gas industry
• How to model investment appraisal techniques and utilise decision trees to model the option to abandon

Training Methodology

Each of the sessions will involve formal lectures, demonstration of modelling techniques and the opportunity for practical application.  Screen recordings of important techniques and examples will be made available to delegates to assist in the practical applications and to facilitate application of the techniques used when they approach to the workplace.

Organizational Impact

By sending delegates on the 4 day Programme in Financial Modelling & Petroleum Project Economics your organisation will benefit by:

• Providing your staff with the opportunities to develop high level financial management techniques appropriate to the Oil and Gas industry.
• Updating their quantitative techniques to enable them to make better informed decisions.
• Transforming their Excel skills so that the leave with advanced knowledge of Excel for financial modelling.

 Personal Impact

By attending this seminar you will:

• Have advanced ability in financial modelling using Excel.
• Have a larger skills set when contributing to corporate decisions.
• The ability to question important decisions formed using financial modelling.

Who Should Attend?

• Decision makers and financial modellers in the up-stream and down-stream oil and gas industry
• High level managers integral to the decision making process who wish to develop their financial modelling skills.

Programme Outline

1 – An introduction to the Excel Environment, with Petroleum based examples Background to the Petroleum industry Cell referencing, using formula’s, formatting Advanced charting within Excel Data manipulation and management

2 – Financial Analysis in the up and down stream Oil and Gas industry I Introduction to financial statements Ratio analysis applied to the Oil and Gas Industry

3 – Financial Analysis in the up and down stream Oil and Gas industry II Trend analysis using Excel Projecting financial statements using forecasting techniques available within Excel

4 – Statistical analysis (applied to the Oil and Gas industry) using Excel Analysis of equity returns of oil and gas industry companies Use of Excel functions for statistical analysis Use of scatter diagrams and regression techniques to calculate cost of equity financing.

5 – Capital Structure in the Oil and Gas industry Analysis of capital structure throughout the up-stream and down-stream oil and gas industry. Examination of bond issues and IPO’s by oil and gas industry participants.   Examination and calculation of the cost of debt financing. Calculation of a company’s weighted average cost of capital (WACC)

6 – Investment Appraisal using Excel I Investment appraisal using NPV, IRR and payback as applied to the oil and gas industry. Use of Excel functions for investment appraisal: IRR, PV and NPV Use of solver in scenario analysis and stress testing

7 – Investment Appraisal using Excel II Using Excel to model decision trees Using Excel to calculate the value of a real option and the abandonment decision

8 – An introduction to energy derivatives An introduction to the derivatives market Examination of petroleum based derivatives, including futures and options. Modelling up-stream down stream energy products using Excel

9 – Hedging risk using energy derivatives Hedging against price decreases and increases using petroleum futures Using VBA to create functions to value energy derivatives Hedging against price changes using petroleum based options

10 – Oil product spreads Examining the relationship between energy products Using futures spreads to speculate and to hedge against profit margin risk

______________________________________________________________________________________________________________________

Kami memberikan alternatif Fasilitas atas Investasi anda dalam Program ini, diantaranya :

1. Sertifikat, Peralatan Training, USB, Souvenir, Lunch, Coffe Break, City Tour
2. Running minimal 2 Orang (Semarang, Jogja, Solo), Running minimal 3 Orang (Bandung, Jakarta), Running 4 Orang diperuntukan untuk daerah (Bali, Lombok, Manado, Balikpapan)
3. Kami menyediakan transportasi antar Jemput dari Stasiun/Bandara ke Tempat Pelatihan(Hotel) bagi perusahaan yang Running minim 2 Orang
4. Harga dilampirkan di Brosur Penawaran

______________________________________________________________________________________________________________________

Tambahan Informasi :

1. Silahkan tanyakan ketersediaan Tanggal dan Waktu dari jadwal training terbaru apabila anda tidak menemukan waktu yang sesuai dengan jadwal anda.

2. Training dapat disesuaikan dengan kebutuhan perusahaan jika dalam bentuk In-House Training. Silahkan baca ketentuan In-House Training diwebsite kami atau hubungi kami di Nomer Mobile untuk mendapatkan Fast Respon.

3. Silahkan mengisi Form Request Training di website kami untuk mendapatkan informasi tambahan yang belum ada, atau jika anda ingin menanyakan usulan materi sesuai kebutuhan perusahaan. Hubungi kami lewat email yang tertera atau Register disini!

4. Apabila telah menerima Silabus Training, Customer dapat Request Waktu Training yang diinginkan.

5. Informasi dan Data yang jelas akan memudahkan kami untuk segera merespon permintaan anda.

Customer Dapat Request Tempat, Waktu, serta Fasilitas Training. Silahkan Hubungi kami untuk Menerima Brosur Penawaran.