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
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 @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. @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 @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.