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 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 | 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 ModelRisk |
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.
Public-Private Partnership Advanced Modeling with Legal Analysis
Financial Modeling and Analysis in Excel + Public-Private Partnership Advanced Modeling with Legal Analysis
Public-Private Partnership Advanced Modeling with Legal Analysis