Complete Financial Modeling for Project Finance in Excel
Learn Financial Modeling for Project Finance and Infrastructure Valuation ( DCF and IRR ).
4.53 (752 reviews)
2 182
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
Charts
Students
Price
Rating & Reviews
Enrollment Distribution
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