Complete Financial Modeling for Project Finance in Excel

Learn Financial Modeling for Project Finance and Infrastructure Valuation ( DCF and IRR ).

Created by: Greg Ahuy
Financial Modeler at FMO - Financial Model Online

What Will I Learn?

• How to build project finance model from scratch in excel based on the toll road project case study;
• What is project finance, how infrastructure projects financing is arranged and who are the players in project finance;
• How to do financial modeling of complex, real-life project finance transactions;
• How to sculpt debt to a target DSCR;
• How to create best practice macro’s and Excel VBA codes to break circularities;
• How to model Debt Service Reserve Account and Maintenance Reserve Account;
• How to model Shareholder Loan, Revolver and Blended Equity IRR;
• How to carry out valuation analysis based on Discounted Cash Flow (DCF) and Internal Rate of Return (IRR) methods;
• How to carry out sensitivity and scenario analysis;
• How to build integrated, 3 financial statements model;
• How to integrate monthly construction sheets into semi-annual operations sheets;
• How to prepare trusted project finance models tailored to investors and financiers.

Requirements

• You will need previous exposure to Excel in a financial modelling context and basic knowledge of investment concepts such as NPV and cash flows.

Target audience

• Typical students include finance students, recent graduates, analysts, managers, senior managers, associate directors, advisers, financiers and CFOs from financial and infrastructure companies.