Complete Financial Modeling for Project Finance in Excel
Learn Financial Modeling for Project Finance and Infrastructure Valuation ( DCF and IRR ).
4.56 (743 reviews)
2,135
students
10.5 hours
content
Mar 2025
last update
$109.99
regular price
What you will 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.
Screenshots
Related Topics
2762030
udemy ID
1/16/2020
course created date
5/1/2020
course indexed date
Lee Jia Cheng
course submited by