Public-Private Partnership Advanced Modeling with Legal Analysis

  • Build an extensive concessionaire bid model
  • Learn advanced modeling techniques for robustness
  • Review for specific legal, contract and structure due diligence
  • Use financial models to guide negotiations and decision-making
  • Learn to "negotiate off the model" instead of "modeling off the negotiations"
  • Engage in current commercial discussions with active project developer/financial advisor and PPP legal experts


Taught by Charles T. "Chip" Haskell, Jr, Managing Director of The Vair Companies and Internationally-Renowned Financial Modeling Instructor.


Infrastructure Heads, CFOs, Financial Analysts, Project Finance Teams, Corporate & Structured Finance Teams, Investment & Evaluation Professionals, Business Development Planners, Joint Ventures Specialists, Contactors, Gov't Finance Officers/Treasurers, Accountants, PF/PPP Attorneys




Public-Private Partnership Modeling & Legal Analysis is a Vair Training Specialty Class and focuses uniquely on Public-Private Partnership ("PPP") projects in Canada and their related modeling issues. After reviewing some basic elements that separate PPP from traditional infrastructure and project financing, the participants are given a full suite of project documents and macroeconomic information that are indicative to infrastructure projects. This is followed by a step-by-step procedure of building a complex model for a concessionaire bid. This phase of the course demonstrates how to dove-tail contracts and shows that nothing in PPP is mutually exclusive.

Once completed, the delegates review the model from a due-diligence analysis, usually taken from a government, lender or third-party equity perspective. The final phase of this module uses sophisticated model techniques, including ModelRisk, to help the practitioner price the deal and negotiate off the financial model. Special consideration is given to more advanced PPP issues like liquidated-damages analysis and appropriate security packages. ModelRisk Monte Carlo Simulation capabilities will bring a value-add and more dynamic dimension to the normally static spreadsheet analysis. The course's overriding theme is to use the model as a highly-developed financial analysis tool that reviews the appropriate risk-versus-reward profiles of project finance. This is an advanced course and is geared to the intermediate-to-advanced delegate.


Part 1

Project Finance for PPP

Part 2

The Role of the Model and Common Rules

Part 3

The Risk Matrix

Part 4

Introduction of a Project for Modeling

Part 5

Legal Due Diligence, Documentation, Permitting & Structuring

Part 6

The Assumption Page

Part 7

Revenue: Availability vs. Service & Unitary Payment

Part 8


Part 9


Part 10


Part 11


Part 12


Part 13


Part 14

The Income Statement

Part 15

The Balance Sheet

Part 16

The Statement of Cash Flows

Part 17

Equity Returns

Part 18

Loan Values

Part 19

"Pricing the Deal" and Analysis

Part 20

Documenting Changes to the model

Part 21

Analysis of Liquidated Damages ("LD"), Asset Renewal & Lifecycle Reserves

Part 22

Monte Carlo Simulation using ModelRisk