Infrastructure Sector Modeling

Overview
Curriculum
Instructor

What You Will Learn ?

How to build a 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 create best practice macros and Excel VBA codes to break circularities;
How to model Equity IRR; NPV, Payback period
How to carry out sensitivity and scenario analysis;
How to build an integrated, 3 financial statements model;
How to prepare trusted project finance models tailored to investors and financiers.

Requirement

General knowledge of MS Excel and essential financial modeling knowledge is recommended
Basic Knowledge of financial statements is recommended

Description

Project finance models are used to assess the risk-reward of lending to and investing in an infrastructure project. The project’s debt capacity, valuation, and financial feasibility depend on expected future cash flows generated by the project itself and a financial model is built to analyze this. In this Project Finance Modeling course, we will model complex toll road project finance transactions from scratch in excel.