|
B5: Oil & Gas Financial Modelling
Course Length: 3 days
Financial Modelling for oil & gas companies including project evaluation and finance.
Dates, Locations & Fees | Facilitator |
Download Brochure | Run this course In-House | Back
What you get From this Course
- An excellent working knowledge of the most useful functions in Excel for financial modelling in the oil & gas industry.
- A sound understanding of oil & gas financial modelling and project evaluation concepts.
- Experience in designing solutions to real-world financial modelling challenges.
Top | Back
Agenda Highlights
Download Brochure
This course provides a sound understanding
of both the principles of financial modelling and the
practical application of these to real-world situations
through the use of spreadsheets.
The course then builds upon the financial
modelling principles and practices learned to apply these
to project evaluations. In this, participants improve
their mastery of project evaluation principles and concepts,
and then see how to apply these in practical applications.
Finally, the course describes how
to both detect and prevent errors from occurring.
Part 1: Financial
Modelling Principles & Practices
Introduction to Financial Modelling
- What is a model?
- Spreadsheet models
- Types of oil & gas sector models
Principles of Financial Modelling
- Steps in model building
- Best practice guidelines and spreadsheet modelling standards
- Designing for flexibility and scalability
- Designing for consistency
- Designing for usability and functionality
- Designing checks and balances
- Using VBA in financial models
Part 2: Applications of Financial
Modelling
Principles of Risk and
Return
- Volatility
- Capital Structures
- Weighted Average Cost of Capital (WACC)
- Cost of Equity Capital
Project Evaluation: Theory
and Application
- Recap of oil and gas accounting principles
- Role of project evaluation
- Approaches to project evaluation
- Free cash flow
- Forecasting future performance
- Capital expenditure modelling
- Modelling uncertainty
- Discounted cash flow modelling
- Sensitivity analysis and an introduction to Monte Carlo
simulation and stochastic modelling
- Alternative project evaluation methodologies such as
real options
- Interpreting results
Part 3: Control of Financial Models
Financial Model Auditing/Review
- Why audit?
- Excel's auditing tools
- Automated testing tools: role, purpose and limitations,
demonstration
- Model documentation
Download Brochure | Top | Back
Who Should Attend?
- Business & Finance Analysts
- Finance Managers
- Investment Managers
- Investment Analysts
- CFO's
- Strategic Planning Analysts
- Financial Modellers
- Business Development Analysts
- Investment & Corporate Bankers
- Corporate Finance Managers
- Finance Professionals
- Accountants
Top | Back
Facilitator: Jeff Robson
 Masters (Applied Finance) - Current, BCom (Accounting & Information Systems), CISA, MAICD, AFAIM, A Fin, MS Excel Expert
Jeff Robson is the Principal and Founding Director of Access Analytic, a specialist consultancy that specialises in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world.
He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings.
He has worked extensively with Chevron plus a variety of other producers and explorers over many years. Other clients include: ENI, Petronas, and Strike Oil.
He provides training in financial modelling for companies throughout the Asia Pacific and Middle-Eastern regions.
Before Access Analytic, Jeff spent 6 years working in the Corporate and IT Consulting divisions of a large, multi-national Chartered Accounting firm.
Jeff is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing. Earlier in his career, he spent five years in banking and finance.
Highlights from his oil and gas experience include:
- Development of economic models to assist Decision Analysts modelling a wide range of scenarios for major Chevron assets.
- Auditing and further development of 20-year models developed by Chevron’s Strategic Planning Division for their North West Shelf assets.
- Development of business plan and budgeting models for Chevron’s North West Shelf assets.
- Development of cash flow and taxation models for Chevron’s Australasian Business Unit.
- Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment.
Top | Back
Benefits & Inclusions
 |
|
 |
Practical:
Jeff Robson is a highly experienced facilitator who
actively and regularly consults to clients also. |
 |
Applicable:
apply what you learn to your job to further your career. |
 |
Hands-on:
the course is designed to provide maximum hands-on
experience. |
 |
Passionate:
Jeff Robson loves this subject! |
 |
Clear: we
specialise in translating complex subjects into concepts
that are easy to understand. |
 |
On-going help:
you can always e-mail the facilitator. |
 |
CD: includes
worked examples, suggested solutions, reference materials,
and a large variety of templates that can be immediately
applied to kick-start your projects. |
 |
Comprehensive course
notes. |
 |
Networking:
meet industry peers and hear how they approach this
subject. |
 |
Small groups:
seats are strictly limited to ensure maximum interaction
with the facilitator. |
 |
Certificate
of completion. |
 |
... and much more! |
Top | Back
Dates & Locations
Book for Open Sessions of
"Oil & Gas Financial Modelling"
Book one or more staff to attend an open session of this course:
|
Date(s)
|
Location
|
Last Earlybird
|
Start Time
|
Price
|
Book/
Info
|
| 4-6 Oct 10 |
Kuala Lumpur, Malaysia |
4 Oct 10 |
9:00 AM |
USD POA |
Click
|
Alternatively, register your interest below and we will notify you when future sessions are scheduled in your area. No courses near you?
Top | Back
Register/Enquiries
|
|
 |
Online: click
any link above to use our secure online registration |
 |
Phone: call
+61 8 6210 8500 & speak to our facilitators (GMT+8) |
|
E-mail: |
Top | Back
Clients who have 3-4 or more people interested in this course normally prefer to run this course on an in-house basis in their offices.
We can bring all the equipment for up to 8 people so all you need is a room!
Benefits
- Flexibility: we can combine
content from multiple courses to create a custom course
just for you, add-on a workshop or some mentoring sessions
then run everything at the times that suit you.
- Timing options: if you're
in Perth, we can split courses into half or single days
and schedule these at times to suit you
- No hidden extras: our fixed
fee includes all materials and equipment costs for up
to 10 participants
- Cost effective: no extra
fees for extra participants (maximum of 8 per session)
Optional Workshop Add-on
A Workshop is a half or full-day group session where participants bring along their Excel models to gain help, ideas and suggestions on how their models could be improved.
Clients often book a Workshop in addition to the standard training course since the Workshop provides a fantastic way for participants to:
- apply and reinforce the knowledge and principles from the course
- gain immediate productivity benefits in their Excel models
- better understand the models that are used in their office
For all these reasons, clients booking workshops gain a far greater return on their training investment.
Cost: AUD3,000 (full day), or AUD1,600(half-day)
To gain all these great benefits, just book your workshop when arranging your course.
In-house Course Fees
| |
Recommended Add-ons |
| Location |
Fee per Day |
1 Mentor Session |
6 Mentor Sessions |
| Perth metropolitan area |
AUD3,000 |
AUD400/person |
AUD2,160/person |
| Other Australia |
AUD3,500 |
AUD400/person |
AUD2,160/person |
| Overseas |
AUD4,000 |
AUD400/person |
AUD2,160/person |
|
Notes:
- Prices exclude GST
- Fees are per day, NOT per participant
- A 10% discount applies when booking 5+ full days
of training
- Fees include all disbursements
- Many courses can also be split into half-days (please enquire)
- Fees for locations outside of Perth do not include equipment
Call Jeff Robson on +61 8 6210 8500 to discuss your requirements.
Bundled Course & Mentoring
Mentoring sessions are 2-hour, individual, one-on-one sessions with the facilitator
where participants use their own files and work on any issue they choose.
Training in this manner allows participants to reinforce the principles they learned
on the course by applying them to real-life situations and get personalised assistance in private with anything they'd like to discuss.
This ensures a deeper understanding and therefore a much longer-lasting benefit by bridging the gap between what was learned on the course and what happens in real-life.
As a further benefit, it also provides an immediate payoff by improving and enhancing participants' productivity.
Mentoring Details
Booking
To take advantage of the bundled mentoring options, just discuss this when booking your
course and we'll arrange everything.
Call Jeff Robson on +61 8 6210 8500 to discuss
your requirements.
Top | Back
Related Courses
|
