Shopping Cart

No products in the basket.
Course Content
Introduction
0/3
Course Objective
01:33
Course Prerequisite
02:04
What is Project Finance
00:35
Understanding the Start Model
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/3
Review of Case Study
07:33
Review of Start Model
02:03
Review of the Input Sheet
03:06
Setting up Macros (Bonus Module)
0/2
Formatting & Productivity Macros
07:33
Setting Up Macros
04:42
PF Modeling – Construction Cost
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/2
Base Capital Cost
08:46
Contingency Cost
02:28
PF Modeling – Construction period Sources and Uses of Funds
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/2
Primary Structure for Sources & Uses of Funds
01:59
Risk & Avoidance of Model Circularities
02:05
PF Modeling – Sources of Finance
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/2
Construction Debt & Equity Investment
05:24
Target Debt Facility Amount Using Goal Seek
04:03
PF Modeling – Finance Cost and Fees during Construction
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/2
Finance Cost
11:25
Summary of Finance Cost
05:13
PF Modeling – Interest during construction
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/4
Impact of Circularities
02:38
Basic Approaches to Avoid Circular Calculation
00:59
Interest During Construction
08:40
Construction Debt Balance
05:58
PF Modeling – Construction debt drawdown structure
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/3
Type of Construction Debt Drawdown Structure
01:06
Construction Debt Drawdown Equity First
17:08
Impact of Both Approach to Funding Requirements
02:25
PF Modeling – Opening Balances and Timelines
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/5
Approaches to Model Timeliness
04:04
Problems of Two Timeliness
01:40
Export of Opening Balance to Operation Model
04:41
Non-current Assets
03:30
Impact of Construction Phase Model
01:58
PF Modeling – Debt Service Coverage Ratio
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/5
Importance of DSCR
02:18
Current Period 3-Months DSCR
06:46
Backward Looking 12-Months DSCR
04:55
Forward Looking 12 Months DSCR
03:57
Simple and Weighted Average 3-Months DSCR
05:32
PF Modeling – Loan Life Cover Ratio
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/2
Importance of LLCR
02:24
Current Period 3-Months LLCR
07:39
PF Modeling – Project Life Cover Ratio
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/2
Importance of PLCR
02:14
Current Period 3-Months PLCR
08:13
PF Modeling – Debt Sculpting and Debt Sizing
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/3
Difference Between Debt Sculpting and Debt Sizing
04:02
Debt Sizing
06:39
Sculpted Debt Repayment to Minimum DSCR
10:08
PF Modeling – Blended equity rate of return
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/4
What is Blended Equity Rate of Return
01:14
PV of Shareholder Cash Inflow
11:14
PV of Shareholder Cash Outflow
05:49
Equity Internal Rate of Return
05:51
PF Modeling – Debt Service Reserve Account
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/6
Purpose of DSRA
01:50
Understanding DSRA Deposit and DSRA Withdrawal
01:58
Target DSRA Balance
08:30
Senior DSRA Deposits
05:01
Senior DSRA Withdrawals
03:26
DSRA Balance
10:59
PF Modeling – Revolving Credit Facilities
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/4
Using RCF as a Standby Facility
01:49
RCF Interest Due, Paid, and Unpaid
08:35
RCF Principal Repayment
02:33
RCF Balance
09:08
PF Modeling – Shareholders Loan
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/4
Benefits of Shareholders Loan to Equity Investors
01:31
Shareholder Loan Interest Due, Paid, and Unpaid
07:29
SHL Principal Repayment
02:24
Shareholder Loan Balance
19:43
PF Modeling – Model Optimization
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/3
Automation Macro for Sculpted Debt
14:20
Create a Looping Macro to Iterate SHL Interest
06:46
Model Optimization to Hit Target IRR and Cover Ratio
25:47
CAPSTONE PROJECT
0/1
Wingspan Airport - Project Finance Modeling
Project Finance Modeling
Previous
Next
0% Complete