Project Finance Modeling

0 (0 Ratings)

Enrolled:134

Level

Intermediate
Duration

10 hours 10 minutes
Last Updated

November 27, 2024
Enrollment validity

Enrollment validity: 365 days
Certificate

Certificate of completion

About Course

This course is designed to provide learners with the knowledge and skills they need to build, review, or analyze project finance models. In this course, our expert instructors has incorporated all the intricacies of project finance modeling, covering topics like construction costs, sources of funds, debt service ratios, equity rates of return, model optimization, etc., all while adhering to the widely adopted and independently administered FAST Standard. By completing this course, you will be equipped with the knowledge and skills needed to become proficient in financial modeling and analysis for project finance transactions. This knowledge will allow you to make a meaningful impact on infrastructure and sustainability projects in the Global South and other regions, helping to close the infrastructure and sustainability gaps that exist today. Join us and take the first step towards becoming an expert in project finance modeling!

Construction Cost
Construction Period Sources and Uses of Funds
Sources of Finance
Finance Costs and Fees During Construction
Interest during construction
Construction debt drawdown structure
Opening Balances and Timelines
Debt Service Coverage Ratio
Loan Life Cover Ratio
Project Life Cover Ratio
Debt Sculpting and Debt Sizing
Blended equity rate of return
Debt Service Reserve Account
Revolving Credit Facilities
Shareholders Loan
Model Optimization

Course Curriculum

Introduction

Understanding the Start Model
Locate the accompanying files for the lessons within this module beneath the respective course video.

Setting up Macros (Bonus Module)

PF Modeling – Construction Cost
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Construction period Sources and Uses of Funds
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Sources of Finance
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Finance Cost and Fees during Construction
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Interest during construction
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Construction debt drawdown structure
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Opening Balances and Timelines
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Debt Service Coverage Ratio
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Loan Life Cover Ratio
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Project Life Cover Ratio
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Debt Sculpting and Debt Sizing
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Blended equity rate of return
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Debt Service Reserve Account
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Revolving Credit Facilities
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Shareholders Loan
Locate the accompanying files for the lessons within this module beneath the respective course video.

PF Modeling – Model Optimization
Locate the accompanying files for the lessons within this module beneath the respective course video.

CAPSTONE PROJECT

Student Ratings & Reviews

No Review Yet

Project Finance Modeling

About Course

What will I learn?

Course Curriculum

Introduction

Course Objective

Course Prerequisite

What is Project Finance

Understanding the Start Model Locate the accompanying files for the lessons within this module beneath the respective course video.

Review of Case Study

Review of Start Model

Review of the Input Sheet

Setting up Macros (Bonus Module)

Formatting & Productivity Macros

Setting Up Macros

PF Modeling – Construction Cost Locate the accompanying files for the lessons within this module beneath the respective course video.

Base Capital Cost

Contingency Cost

PF Modeling – Construction period Sources and Uses of Funds Locate the accompanying files for the lessons within this module beneath the respective course video.

Primary Structure for Sources & Uses of Funds

Risk & Avoidance of Model Circularities

PF Modeling – Sources of Finance Locate the accompanying files for the lessons within this module beneath the respective course video.

Construction Debt & Equity Investment

Target Debt Facility Amount Using Goal Seek

PF Modeling – Finance Cost and Fees during Construction Locate the accompanying files for the lessons within this module beneath the respective course video.

Finance Cost

Summary of Finance Cost

PF Modeling – Interest during construction Locate the accompanying files for the lessons within this module beneath the respective course video.

Impact of Circularities

Basic Approaches to Avoid Circular Calculation

Interest During Construction

Construction Debt Balance

PF Modeling – Construction debt drawdown structure Locate the accompanying files for the lessons within this module beneath the respective course video.

Type of Construction Debt Drawdown Structure

Construction Debt Drawdown Equity First

Impact of Both Approach to Funding Requirements

PF Modeling – Opening Balances and Timelines Locate the accompanying files for the lessons within this module beneath the respective course video.

Approaches to Model Timeliness

Problems of Two Timeliness

Export of Opening Balance to Operation Model

Non-current Assets

Impact of Construction Phase Model

PF Modeling – Debt Service Coverage Ratio Locate the accompanying files for the lessons within this module beneath the respective course video.

Importance of DSCR

Current Period 3-Months DSCR

Backward Looking 12-Months DSCR

Forward Looking 12 Months DSCR

Simple and Weighted Average 3-Months DSCR

PF Modeling – Loan Life Cover Ratio Locate the accompanying files for the lessons within this module beneath the respective course video.

Importance of LLCR

Current Period 3-Months LLCR

PF Modeling – Project Life Cover Ratio Locate the accompanying files for the lessons within this module beneath the respective course video.

Importance of PLCR

Current Period 3-Months PLCR

PF Modeling – Debt Sculpting and Debt Sizing Locate the accompanying files for the lessons within this module beneath the respective course video.

Difference Between Debt Sculpting and Debt Sizing

Debt Sizing

Sculpted Debt Repayment to Minimum DSCR

PF Modeling – Blended equity rate of return Locate the accompanying files for the lessons within this module beneath the respective course video.

What is Blended Equity Rate of Return

PV of Shareholder Cash Inflow

PV of Shareholder Cash Outflow

Equity Internal Rate of Return

PF Modeling – Debt Service Reserve Account Locate the accompanying files for the lessons within this module beneath the respective course video.

Purpose of DSRA

Understanding DSRA Deposit and DSRA Withdrawal

Target DSRA Balance

Senior DSRA Deposits

Senior DSRA Withdrawals

DSRA Balance

PF Modeling – Revolving Credit Facilities Locate the accompanying files for the lessons within this module beneath the respective course video.

Using RCF as a Standby Facility

RCF Interest Due, Paid, and Unpaid

RCF Principal Repayment

RCF Balance

PF Modeling – Shareholders Loan Locate the accompanying files for the lessons within this module beneath the respective course video.

Benefits of Shareholders Loan to Equity Investors

Shareholder Loan Interest Due, Paid, and Unpaid

SHL Principal Repayment

Shareholder Loan Balance