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.
WHO SHOULD ATTEND
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
MODELING SKILL LEVEL
Intermediate-to-Advanced
OBJECTIVES
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.
OUTLINE
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