Presented in association with:

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

Public-Private Partnership Modeling with Excel and Palisade @RISK 5.0 is one of Vair Training’s Specialty Classes 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 dovetail 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 Palisade @RISK 5.0, to help the practitioner price the deal and negotiate off the financial model. Special consideration is given to more advanced PPP issues like liquidateddamages analysis and appropriate security packages. Palisade @RISK 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 - Operations
Part 9 - Construction
Part 10 - Insurance
Part 11 - Taxes
Part 12 - Depreciation
Part 13 - Financing
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 Palisade @RISK

Vair Training courses are held at world-class international venues. Registration fees include morning coffee/tea, networking lunches and afternoon refreshments. Course materials are provided electronically on-site. Detailed venue descriptions, times and logistics are included with post-registration materials and documents.