Project Finance Modelling Workshop
Dates: June 18 - 19, 2018
Price: EUR 1,400
Location: Prague, NH Hotel Prague
Lecturer: Alastair Day
Best Practices in Project Finance Modelling
Model Design and Structure
Modelling of Production Forecast
Analysing the Key Operating Assumptions
Fixed Assets, CAPEX and Depreciation Schedules
Analysing Debt Capacity and Debt Servicing Ratios
International Cash Flow Statement and Ratios
DCF, Project Returns and Risk
Contractual Issues and Arrangements
The purpose of the workshop is for participants to learn how to build a project finance model using best practice principles. This will include the development of financial statements and the mastering of the main Excel techniques (such as forecasting, risk issues, differing scenarios and optimisation). They will learn how to deal with more problematic modelling issues and gain hands-on experience of applying these skills. By building a complete model, participants will gain the confidence to build and revise their own models.
Many models fail due to inadequate structures and methodology and this workshop offers the opportunity to build a comprehensive financial model using international best-practice principles. The workshop commences with a discussion of objectives and common mistakes and then develops the case model in stages. On completion, participants will have built a complete model for future use and review.
Who should attend?
Project finance executives
Financial controllers and managers
Financial and business analysts
Project risk managers
The workshop is taught using demonstrations combined with practical and interactive case studies. The exercises in each session reinforce the concepts covered in each of the units. Emphasis is placed on delegates gaining practical, hands-on experience of the design and construction of financial models in Excel. Comprehensive product notes and modelling software are provided for future reference.
Participants will receive printouts of all slides and the Excel spreadsheets used during the workshop plus a selection of templates and add-ins.
The workshop will be highly practical and hands-on. Participants are required to bring a notebook with MS Excel. Course files will be distributed during and after the workshop.
Monday, June 18
09.00 - 09.15 Welcome and Introduction
09.15 - 12.00
Overview of the Workshop and Project Model Case
Presentation of workshop case and review of theory
Offtake agreements, completion undertakings and security issues