This course covers project finance modeling in excel in a very simple and structured manner. The examples and structure of the course has been designed by a finance professional with 15 years of working experience with financial modelling. While this course is useful for all finance professionals or students aspiring a finance career; this is particularly recommended for professionals involved in financial modeling and debt structuring for projects. Project finance is an important skill for professionals working in infrastructure development and financing.

The course covers the conceptual framework for project finance and uses a case study to build a full scale project finance model from scratch. Though theoretical framework is covered in the course, focus is on applications using a practical example. This course should provide you end-to-end overview and application of project financial modelling. We have in-depth discussion on modeling the debt in the course and cover sizing of debt, interest during construction, DSRA and debt covenants.

The course is structured using a step by step approach to develop the final model. We also encourage the learners to work along side as they go through the lectures. Financial modeling is best learned with practice.

We have divided the course in 7 modules:

1. Course introduction and overview of project finance

2. Introduction to case study and initial model set up

3. Modeling for construction phase

4. Operation phase modeling including revenue, cost, working capital, decommissioning reserve

5. Debt and equity calculation including debt sizing based on project cash flows, repayment schedule, IDC equity cash flows

6. Integrated financial statements

7. Project return and debt covenants