Course Objective - BFI School

Course Objective - BFI School

Project Finance Modeling Course Objective

Project Finance Modeling

0% Completed

Introduction

Course Objective

Video - 00:1:33 mins

Course Prerequisite

Video - 00:2:04 mins

What is Project Finance

Video - 00:00:35 mins

Understanding the Start Model

Review of Case Study

Video - 00:7:33 mins

Review of Start Model

Video - 00:2:03 mins

Review of the Input Sheet

Video - 00:3:06 mins

Setting up Macros (Bonus Module)

Formatting & Productivity Macros

Video - 00:7:33 mins

Setting Up Macros

Video - 00:4:42 mins

PF Modeling – Construction Cost

Base Capital Cost

Video - 00:8:46 mins

Contingency Cost

Video - 00:2:28 mins

PF Modeling – Construction period Sources and Uses of Funds

Primary Structure for Sources & Uses of Funds

Video - 00:1:59 mins

Risk & Avoidance of Model Circularities

Video - 00:2:05 mins

PF Modeling – Sources of Finance

Construction Debt & Equity Investment

Video - 00:5:24 mins

Target Debt Facility Amount Using Goal Seek

Video - 00:4:03 mins

PF Modeling – Finance Cost and Fees during Construction

Video - 00:11:25 mins

Summary of Finance Cost

Video - 00:5:13 mins

PF Modeling – Interest during construction

Impact of Circularities

Video - 00:2:38 mins

Basic Approaches to Avoid Circular Calculation

Video - 00:00:59 mins

Interest During Construction

Video - 00:8:40 mins

Construction Debt Balance

Video - 00:5:58 mins

PF Modeling – Construction debt drawdown structure

Type of Construction Debt Drawdown Structure

Video - 00:1:06 mins

Construction Debt Drawdown Equity First

Video - 00:17:08 mins

Impact of Both Approach to Funding Requirements

Video - 00:2:25 mins

PF Modeling – Opening Balances and Timelines

Approaches to Model Timeliness

Video - 00:4:04 mins

Problems of Two Timeliness

Video - 00:1:40 mins

Export of Opening Balance to Operation Model

Video - 00:4:41 mins

Non-current Assets

Video - 00:3:30 mins

Impact of Construction Phase Model

Video - 00:1:58 mins

PF Modeling – Debt Service Coverage Ratio

Importance of DSCR

Video - 00:2:18 mins

Current Period 3-Months DSCR

Video - 00:6:46 mins

Backward Looking 12-Months DSCR

Video - 00:4:55 mins

Forward Looking 12 Months DSCR

Video - 00:3:57 mins

Simple and Weighted Average 3-Months DSCR

Video - 00:5:32 mins

PF Modeling – Loan Life Cover Ratio

Importance of LLCR

Video - 00:2:24 mins

Current Period 3-Months LLCR

Video - 00:7:39 mins

PF Modeling – Project Life Cover Ratio

Importance of PLCR

Video - 00:2:14 mins

Current Period 3-Months PLCR

Video - 00:8:13 mins

PF Modeling – Debt Sculpting and Debt Sizing

Difference Between Debt Sculpting and Debt Sizing

Video - 00:4:02 mins

Video - 00:6:39 mins

Sculpted Debt Repayment to Minimum DSCR

Video - 00:10:08 mins

PF Modeling – Blended equity rate of return

What is Blended Equity Rate of Return

Video - 00:1:14 mins

PV of Shareholder Cash Inflow

Video - 00:11:14 mins

PV of Shareholder Cash Outflow

Video - 00:5:49 mins

Equity Internal Rate of Return

Video - 00:5:51 mins

PF Modeling – Debt Service Reserve Account

Purpose of DSRA

Video - 00:1:50 mins

Understanding DSRA Deposit and DSRA Withdrawal

Video - 00:1:58 mins

Target DSRA Balance

Video - 00:8:30 mins

Senior DSRA Deposits

Video - 00:5:01 mins

Senior DSRA Withdrawals

Video - 00:3:26 mins

Video - 00:10:59 mins

PF Modeling – Revolving Credit Facilities

Using RCF as a Standby Facility

Video - 00:1:49 mins

RCF Interest Due, Paid, and Unpaid

Video - 00:8:35 mins

RCF Principal Repayment

Video - 00:2:33 mins

Video - 00:9:08 mins

PF Modeling – Shareholders Loan

Benefits of Shareholders Loan to Equity Investors

Video - 00:1:31 mins

Shareholder Loan Interest Due, Paid, and Unpaid

Video - 00:7:29 mins

SHL Principal Repayment

Video - 00:2:24 mins

Shareholder Loan Balance

Video - 00:19:43 mins

PF Modeling – Model Optimization

Automation Macro for Sculpted Debt

Video - 00:14:20 mins

Create a Looping Macro to Iterate SHL Interest

Video - 00:6:46 mins

Model Optimization to Hit Target IRR and Cover Ratio

Video - 00:25:47 mins

CAPSTONE PROJECT

Wingspan Airport - Project Finance Modeling

Announcements Reviews Live Classes Gradebook Certificate Course Info