Finance Modelling
for Natural Resources Projects4 day or 8 half-day course
Learn how to construct a robust project finance model from scratch and use it to assess the feasibility of a project and develop a financing plan.
The financial modelling course is aimed at financial analysts seeking a best practice approach to building a project finance model.
During this course, you will develop your own project finance model to perform a discounted cash flow analysis for the investment decision.
With pricing set by world commodity markets, you will need to run detailed sensitivity analysis to understand how your project reacts to external forces.
You will learn to model senior debt with a sculpted repayment profile to match a specified cover ratio and to develop a financing plan which provides a reasonable return to lenders and investors.
This course is designed to help you:
- Develop and build flexible and robust financial models
- Develop and optimise a financing plan
- Understand and use NPV, IRR and debt cover ratio techniques
- Understand and test model dynamics and performance
- Construct and use a cash cascade to service financial instruments and reserve accounts
- Simplify formulas using logical masks, switches and counters
- Use audit checks and tests throughout the model development process
- Perform sensitivity and scenario analysis
For convenience, the course can be delivered in two parts, and we can offer the first part as a standalone course in its own right.
-
Part 1: Methodology & Techniques
You will construct a model to perform a discounted cash flow analysis for the investment decision, and explore the relevant sensitivities, to introduce an overall approach to building models, as well as a number of fundamental techniques and concepts which will prove invaluable in future modelling assignments.
-
Part 2: Extended Techniques
Expand the model constructed in part 1 and explore a range of sophisticated techniques for developing a plan for financing a project.
Starting with a simple term loan, you will develop a number of increasingly complex features associated with debt modelling, including grace periods, the cash cascade, debt sculpting, the cash sweep and the debt service reserve account (DSRA). Techniques for handling and managing circularities are explored, as are the concepts and applications of the various debt cover ratios.
-
Date Course Format Time Zone Price Register interest 15-18 February 2021 Part 1 Online GMT £1200 15-18 February 2021
22-25 February 2021Parts 1 & 2 Online GMT £2400 VAT of 20% is required to be levied for training courses conducted in the United Kingdom. Training courses conducted outside the UK may include local sales taxes, where applicable. The fees below are quoted net of any taxes.
In-house Courses
Where there is demand for multiple delegates from the same firm, it may be better to run an in-house course. This is a cost-effective method of training participants from the one company, conducted on your chosen date, either at your premises or ours, for up to eight delegates.