Greg Ahuy – Complete Financial Modeling for Project Finance in Excel

Description

Greg Ahuy – Complete Financial Modeling for Project Finance in Excel

Master the high-end financial modeling skills pivotal to developing, modifying and analyzing financial models for projects in infrastructure sector.

In an online environment you will go from a blank Excel workbook to a financial model suitable for investment analysis, debt structuring and operational scenario evaluation. This course will provide step-by-step instructions on how to build financial model suitable for analyzing project finance transactions.

You will learn about:

• what is project finance;
•  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 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;
•  building project finance models in excel that cover the entire life of the project;
• carry out valuation analysis based on the discounted cash flow (DCF) and internal rate of return (IRR) methods;
• preparing trusted project finance models tailored to investors and financiers, with a focus on valuation and risk
•  financial models that are designed according to the F.A.S.T standards.
• This is the same comprehensive financial training used to prepare analysts and managers at top financial institutions and infrastructure funds.

Get Greg Ahuy – Complete Financial Modeling for Project Finance in Excel download