- Create models that are easy to navigate without forfeiting proper deal sophistication and analysis
- Produce a robust model from feasibility stages through project documentation to financial close
- Identify and quantify the risks of the project through the model - from sponsor, participant and lender viewpoints
- Learn the power of "negotiating off the model" instead of "modeling off the negotiations"
- Enhance spreadsheet analysis, presentation and negotiations with Palisade @RISK 5.0
Taught by Charles T. "Chip" Haskell, Jr, Managing Director of The Vair Companies and Internationally-Renowned Financial Modeling Instructor.
Advanced Modeling for Project Finance is a master-level class and focuses uniquely on project finance and its related modeling issues. After reviewing some basic elements of project finance, the participants are given a full suite of project documents and macroeconomic information that are indicative to any infrastructure project. Immediately following is a step-by-step procedure of building a complex equity case model. This phase of the course is to demonstrate how contracts dovetail and that nothing in project finance is mutually exclusive.
Once completed, the delegates review the model from a due-diligence analysis, usually taken from a lender's or third-party equity perspective. The final phase of this module uses sophisticated model techniques to help the practitioner price the deal. Special consideration is given to more advanced project-finance issues like liquidated damages analysis and appropriate security packages. The overriding theme of this specialty course is to use the model as a highly-developed financial analysis tool that reviews the appropriate risk-versus-reward profiles of project finance. By employing Palisade @RISK software, the course demonstrates the power of Monte Carlo simulation analysis, creating a dynamic decision-making tool, elevating past simple static input and output spreadsheets. This is an advanced course and is geared to the intermediate-to-advanced delegate.
Part 1 - Project Finance versus Corporate Finance
Part 2 - The Role of the Model & Common Rules
Part 3 - The Risk Matrix
Part 4 - Introduction of a Project for Modeling
Part 5 - The Project Documents
Part 6 - The Assumption Page
Part 7 - Operations
Part 8 - Construction
Part 9 - Insurance
Part 10 - Taxes
Part 11 - Depreciation
Part 12 - Financing(s)
Part 13 - The Income Statement
Part 14 - The Balance Sheet
Part 15 - The Statement of Cash Flows
Part 16 - Equity Returns
Part 17 - Loan Values
Part 18 - "Pricing the Deal" and Scenario Analysis
Part 19 - Monte Carlo Simulations w/ Palisade @RISK 5.0
Part 20 - Running Sensitivities & Documenting Changes
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.
Available Dates
- No available dates.
