Advanced PPP Financial Modelling

Advanced PPP Financial Modelling

Jerusalem , Israel

28 Oct - 29 Oct
Course Details


2 Days




Basic understanding of PPP Framework


$ 2150.00



This course follows on from our Essential PPP Financial Modelling programme. Whilst it is not necessary to attend the Essential course first, it is advisable. This programme will be delivered as a three day course. The training program will provide participants with sets of techniques, greater understanding and hands-on practice in:
  • Determining the most effective methodologies to design, cross check and structure financial models for PPP projects.
  • Discovering the key elements to prepare realistic and reliable PPP financial models.
  • Examining the financial risk profile to incorporate risk factors in the financial model.
  • Building efficient and flexible financial models to perform add-ins and make amendments while maintaining the integrity of the spreadsheets.
  • Analysing financial data using a various database functions.
  • Investigating the key steps in financial modelling audits to assure the value of the money invested is achieved.
  • Utilising the financial models to assist on decision making process.
The emphasis in this program is on learning skills about best practice in building financial models and the detailed techniques and calculations involved, with particular application to infrastructure project finance. Many techniques taught have use in other applications, such as corporate finance, but the emphasis will remain firmly on project finance modelling. The use of models to understand and analyze a project will be covered briefly, but it is essentially a practical hands-on course in detailed building techniques. It should not be regarded as a general Microsoft Excel training course, although the models built will use Excel software; rather, the emphasis is on applying excel to model and analyze project finance transactions. By the end of the course, participants will have produced the main building blocks of a well-structured integrated financial model for an infrastructure transaction. As a result of this training, participants will be capable of building up a robust model, which can be rapidly changed, is flexible and is consistent in its logic and treatment of components of cash flow. They will be able to use Excel tools to facilitate sensitivity analysis, build cash flow cascades, solve circular references and write simple macros. The course is intensive, and requires focus from the delegates to absorb a large range of material in just 2 days. We encourage active involvement of the participants, questions and answers, and discussion. Concepts will be presented through formal presentations and demonstrated examples, which can be followed by delegates on their own laptop computers; supervised exercises are then used to practice and reinforce understanding of the topics. Each exercise has a suggested answer for self-review or review in the class. These exercises cumulatively build the basics of a fully-integrated infrastructure model which is used as the core case study throughout the training programme.
Case studies & Exercises
Case studies will focus on putting into practice modelling techniques, and participants will gradually build an infrastructure PPP model themselves using techniques and principles as they are taught and demonstrated. Each exercise is designed to be done either in teams or individually, and is self-contained in terms of putting into practice a limited degree of model-building. The exercises build on one another, until a full-scale, integrated model has been built using best-practice techniques. Model answers are available for each, and are reviewed in the class for participants to check their own work; these models can be used as a reference source later when participants are back in their normal work environments. For further information on this course please contact Reanna Roach, Marketing and Events Co-ordinator at
We use a blend of the most advanced and proven learning methods incorporating key principles of cognitive-social psychology, organisational psychology as well as NLP. Whether you prefer to learn through a cognitive approach or behavioural, our courses are balanced to reflect the different learning styles of our audience. Our training techniques will include;
    • building on participants’ experience through small interactive tutorials, building of a framework of skills or strategies and group discussion, brainstorming and collective workshops in larger groups,
    • simulation/role playing,
    • reflexive practice: skills modelled and replicated through supervised practice, then feedback,
    • basis for further self-study through materials that allow participants to go beyond the initial training,
    • follow-up and self-assessment with trainers after the session,
    • facilitated review and summation of training sessions,
We are here to support your development by employing the most efficient learning styles. If you require any special assistance, please contact us so that we may provide you with the necessary support. You can email us at”>
The course is intended for junior analysts with a few years’ experience in analysis and valuation, with a good (but not necessarily comprehensive) knowledge of Excel. It is therefore expected that participants will be familiar with the fundamental principles of business risk analysis and investment appraisal techniques and the key features of financial instruments. They should be able to navigate around large Microsoft Excel worksheets and be familiar with the core functions of Microsoft Excel, such as copy, paste, sum, round and sumproduct, logic functions such as IF, AND, and OR, simple lookups, and financial functions such as NPV, IRR, PMT and FV. Limited practical experience of corporate and project finance will be assumed. CFOs, COOs, Managing Directors, Directors, Vice Presidents, General Managers,Heads, RegionalManagers, Managers and other senior executives from;
  • PPP units
  • Project planning and management
  • Project Finance
  • Financial Analysts
  • Financial Modellers
  • Accountants
  • Investment and evaluation
  • Infrastructure development
  • Urban planning and development
  • Investment
  • Legal and contracts
  • Finance
From all industries, especially
  • Ministries of: Finance, Economy, Work, Energy, Water, Transportation, Telecommunications, Health and Education
  • Property development and construction
  • Power and utilities
  • Waste management
  • Financial Institutions
  • Privatisation agencies
  • PPP Units
  • Public sector contractors.
After gaining his MA in Engineering at Cambridge University, he joined KPMG and qualified as a Chartered Accountant in 1984. He then joined KPMG’s Management Consulting Firm, specialising in writing financial forecasts using a variety of spreadsheets. During his time he realised the importance of setting work out clearly and how difficult that can be with spreadsheets. He developed his own spreadsheet methodology and applied it to numerousacquisition and other scenarios, he was asked to lecture it to other spreadsheet users andto clients, including Schroeders, SBC Warburg, Hambros, NM Rothschild and NatWest Bank. He left KPMG to join UBS Warburg’s Education Department at the start of 1996. There he continued to present his basic financial modelling course. He also developed and presented courses covering the main technical topics that are essential knowledge for a corporate financier. In April 1998 he left Warburg to set up as an independent management consultant, specialising in educating and advising people about financial modelling. He also lectures to the MBA students at the London School of Business and Finance and atKingston University.

Jerusalem , Israel