Complete Financial Modeling for Project Finance in Excel
Learn Financial Modeling for Project Finance and Infrastructure Valuation ( DCF and IRR ).
4.61 (761 reviews)
2 216
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.
Course Gallery
Loading charts...
Comidoc Review
Our Verdict
Though the course shows room for improvement in certain areas, its well-rounded approach to project finance modeling makes it a valuable resource. Students should expect some prior knowledge of Excel functions and be prepared to revisit some sections for clarity. Nonetheless, the detailed tutorials and abundant resources offer a solid foundation for financial professionals looking to enhance their skillset.
What We Liked
- In-depth coverage of project finance modeling from scratch using a toll road project case study.
- Clear explanations of complex topics like DSCR, Debt Service Reserve Account, Maintenance Reserve Account.
- Comprehensive explanation of financial modeling tools and techniques, appreciated by beginners and professionals alike.
- Valuable insights into industry best practices, macro usage, and VBA codes.
Potential Drawbacks
- Occasional discrepancies between 'before' and 'after' files, causing confusion in the modeling process.
- Instructor's assumption of prior knowledge related to some functions and concepts.
- Infrequent use of latest Excel features such as xlookup and logic ifs.
- Limited elaboration on more complex concepts and their corresponding excel formulas.
Related Topics
2762030
udemy ID
16/01/2020
course created date
01/05/2020
course indexed date
Lee Jia Cheng
course submited by