Complete Financial Modeling for Project Finance in Excel

どんな講座？

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

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.
Show more