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