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
People do not sign models - They sign the contracts that those models represent. Project Finance/Public-Private Partnership Advanced Modeling and Analysis is a Vair Training Master Class that focuses uniquely on PF and PPP projects and their related modeling and legal issues. After reviewing some basic elements of project finance and factors that separate PPP from traditional infrastructure and project financing, course 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 program demonstrates how to dovetail contracts and models and shows that nothing in PF/PPP is mutually exclusive.
Once completed, delegates review the model from a due-diligence analysis, usually taken from a government, lender or thirdparty equity perspective. The final phase of this module uses sophisticated model techniques to help the practitioner "price the deal" and "negotiate off the financial model". Special consideration is given to more advanced PF/PPP issues like liquidated-damages analysis, drop-down and direct agreements, and appropriate security packages. 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.)
Learn to analyze and model project documents including RFPs, Project Agreements, Guaranteed Price Contracts, Lenders' Direct Agreements, Value-for-Money Reports...and much more!
| 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 and Structuring |
| Part 6 | The Assumption Page |
| Part 7 | Revenue: Availability vs. Service and 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 and Lifecycle Reserves |
| Part 22 | Monte Carlo Simulations |
| Part 23 | Legal Analysis: Financing Issues, Regulatory and Political Aspects |
| Part 24 | Financing Different Types of Projects |
| Part 25 | Impact of Government-Supported Financing |
| Part 26 | Covenants and the Model |
As with our all our financial modeling courses, this is a hands-on practical course, whereby the delegate takes our "learn by doing" approach. The course structure for each module follows a four-step pattern: 1) presenting the section material, 2) a spreadsheet exercise, 3) review of the exercise; then 4) follow-up with a question and answer session. Each successive session builds from the previous session. Each participant will be given exercise and review files to insure course fluidity, no matter the participants' background or level.
Participants go through the process of building a fairly complex model step-by-step using a series of project document tariff sheets and macroeconomic information. This phase takes an equity view of the model. Next, the course reveals the power of the model by applying it to different perspectives, such as that of project lenders or equity holders. The third phase of the course uses more sophisticated modeling techniques, such as tables, goal searches and Solver, as well as discussion of Monte Carlo simulations.
(NB: Prerequisite - A general knowledge of Excel, accounting principals and financial modeling is a minimum requirement for this course; particularly, the ability to generate a Statement of Cash Flows from an Income Statement and Balance Sheet. It is strongly suggested that those delegates with limited financial modeling experience consider taking Vair's Financial Statement Modeling and Analysis course)
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.
Project Finance and PPP Advanced Modeling
Financial Modeling and Analysis + Project Finance and PPP Advanced Modeling
Project Finance and PPP Advanced Modeling
Financial Modeling and Analysis + Project Finance and PPP Advanced Modeling
Project Finance and PPP Advanced Modeling
Financial Modeling and Analysis + Project Finance and PPP Advanced Modeling
Project Finance and PPP Advanced Modeling
Project Finance and PPP Advanced Modeling
Financial Modeling and Analysis + Project Finance and PPP Advanced Modeling
Project Finance and PPP Advanced Modeling
Financial Modeling + Project Finance and PPP Advanced Modeling