What does the Project Finance Modeling Program Cover?

Develop a project finance model and analyze financing proposals at our two-day program. Starting from scratch, the delegates will develop a fully integrated and flexible project finance model, forecast project cash flows and key KPIs using advanced excel tools and best practices in financial modeling.

Learning Objectives

icon

Apply advanced excel tools in project feasibility modeling

icon

Develop EPC (Engineering, Procurement, and Construction), CapEx (Capital Expenditures) and funding schedule using timing flags

icon

Build a project's flexible debt repayment schedule for various sources of financing

icon

Model key financial drivers used to evaluate a project finance transaction

icon

Perform scenario and sensitivity analysis in a project finance model

Program Agenda

Introduction to the Project Finance Model

Grasp advanced Excel tools in Project Finance modeling
Explore the differences between project finance and traditional finance
Understand the life-cycle of a project finance transaction and model
Developing the model

Timing and Debt Structure

Input sheet and its assumptions
Build a flexible timing structure using timing flags
EPC and CapEx schedule
Revenue, operational and maintenance expenditures
Debt modeling

Forecasting

Forecast cash flow available for debt servicing (CFADS)
Forecast debt repayment and interest schedule (For different types of debt structures)
Interest during construction & controlling circular referencing
Repayment waterfall
Reserve accounts, cash sweeps

Modeling for Key Model outputs

DSCR (Debt Coverage Ratio), LLCR (Loan Life Coverage Ratio) and PLCR (Project Life Cover Ratio)
NPV (Net Present Value) and IRR (Internal Rate of Return) for different sponsors and investors in the project
DSRA (Debt Service Reserve Account)

Scenario and Sensitivity Analysis

Perform one or two variable data table sensitivity analysis for key project inputs
Perform scenario analysis by changing multiple project inputs and evaluate the impact on key model outputs

Our Expert Trainers

Upcoming Dates

Course Title Level Term Location Course Date Duration / Days Price*
7CMA – Part 2 – Revision Pro Level 1 June 28, 2021 Ajman June 30, 2021 34 days (Sun,Tue,Fri) AED 1500
8Level II CFA® Program – Prep Pro Level 3 July 18, 2021 Abu Dhabi June 15, 2021 34 days (Sun,Tue,Fri) AED 1322

Request a Call Back

The answer to your doubts is just a click away! Simply fill in your details in the form, and we will get in touch with you shortly.