Financial Modelling for Petroleum Projects

See the course schedule for this course

Attend this intensive two day course to learn how to build a cashflow model for evaluating the economics of a petroleum project. You will learn the fundamentals of modelling the net cashflow of a petroleum case study and then layer on top a capital structure for return and debt cover analysis. By working in a 100% hands-on, limited participant, environment you will also learn invaluable Excel tips and tricks as well as learn Navigator’s best practice financial modelling methodology from the best in the industry.

This two day course, offered jointly by Navigator and REDMoney is limited to just 15 participants. Because of Navigator’s acclaimed experience in delivering a global training programme the course is suited to participants with a range of experience.

Who should attend

Analysts new to the Oil and Gas sector, experience oil and gas professionals new to financial analysis, government and legislative professionals. All personnel interested in attaining a knowledge of the analysis of oil and gas projects.

Day 1

• Introduction to Navigator’s Best Practice Methodology
• Construction: Modelling the S-curve; Including contingency (cost and time over-runs)
• Pricing: Creating a price from a base (Brent Crude, TAPIS); Including different price paths for different stakeholders; Modelling hedging instruments, floors, caps, collars, options; Modelling contracted volume off-take
• Production: Volume; Production rate profiles; Dynamic P90, P50 switching; Dynamic reserve tail cut-off;
• Operating costs: Typical fixed costs; How to model variable costs such as lifting costs; Escalating costs with inflation (or not..); O&M contract optionality

Day 2

• Tax and Depreciation: Royalties; Income tax; Loss accounts; Depreciation
• Project Finance: Repayment according to a target DSCR; Calculation of the RLCR; Understanding typical debt sizing constraints
• Equity: Calculation of dividends; Assessment of Return using NPV, IRR and Payback
• Project Evaluation: Comparing different projects using the Scenario Manager; Understanding the impact of a construction delay upon returns; Valuing opening exploration losses; Producing key metrics for all scenarios at one using a Data Table

General emphasis on

• Cashflow ‘thinking’
• Setting the model up to handle scenarios / sensitivities
• Best practice methodology
• Working efficiently in Excel
• Investment theory (Real vs Nominal, Sunk costs, etc)

Register now

Michael Moran
+61 2 9229 7409

Next Courses Available (see all courses) Back to Top