Presented in association with:

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

Financial Analysts, Investment & Evaluation Professionals, Business Development Planners, Mergers & Acquisitions Specialists, Accountants, Infrastructure Heads, Corporate & Structured Finance Teams, Joint Ventures Specialists, CFOs, Financial Directors

Intermediate-to-Advanced

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 Palisade's @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 liquidated-damages analysis and appropriate security packages. Palisade's @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.