Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Project Finance Modeling for Infrastructure Projects
Course Introduction
Introduction to Project Finance Modeling Course (3:01)
Part 1 - Project Finance Primer
What Is Project Finance? (5:38)
Project Finance in Numbers (2:29)
Financial Players in Project Finance (5:32)
Industrial Players in Project Finance (3:04)
Role of the Government in Project Finance (3:44)
Concession or Project Agreement in Project Finance? (4:47)
Risk Analysis in Project Finance (9:53)
Capital & Operating Cash Flows (4:02)
Control Accounts & Cash Flow Waterfall (5:32)
Covenants in Project Finance (4:16)
Quezon Power Plant Project Case Study - 1 (9:49)
Quezon Power Plant Project Case Study - 2 (4:59)
Part 2 - Case Review, Timeline, Construction Cost & Construction Funding Modeling
Welcome to Part 2 !!! (0:37)
Introduction to Modeling
Introduction to the Case Study (8:38)
Calculations in Blocks (10:23)
Paste Forward Link (4:30)
Daisy Chains and Link Formatting (3:55)
Most Used Excel Shortcut Keys (7:52)
Using Placeholders (2:13)
Excel Refresher - Understanding Anchoring (3:52)
Excel Refresher - Understanding Dates (5:25)
Excel Refresher - Understanding IF Statements (4:52)
Excel Refresher - Understanding SUMIF Function (6:04)
Excel Refresher - Understanding LOOKUP Functions (5:37)
Excel Refresher - Understanding MIN MAX Functions (2:38)
Timeline Development
Understanding Timing (2:02)
Modeling Timing - 1 (5:46)
Modeling Timing - 2 (6:30)
Modeling Timing - 3 (5:48)
Modeling Timing - 4 (6:34)
Escalation
Understanding Escalation (2:43)
Modeling Escalation (6:43)
Construction Costs
Understanding Construction Costs (2:12)
Modeling Construction Costs (6:43)
Construction Funding
Understanding Construction Funding (1:40)
Modeling Construction Funding (7:04)
Financing Costs
Understanding Financing Costs (3:39)
Modeling Financing Costs - 1 (6:57)
Modeling Financing Costs - 2 (5:36)
Part 3 - Modeling Financial Statements
Welcome to Part 3 !!! (0:22)
Revenue
Understanding Revenue (1:43)
Modeling Revenue (6:44)
Operating Cost
Understanding Operating Cost (1:46)
Modeling Operating Cost (6:29)
Non - Current Assets
Understanding Non - Current Assets (1:44)
Modeling Non - Current Assets 1 (5:53)
Modeling Non - Current Assets 2 (7:33)
Working Capital
Understanding Working Capital (2:38)
Modeling Working Capital (10:01)
Term Loan
Understanding Term Loan (1:39)
Modeling Term Loan (8:19)
Tax
Understanding Taxes (2:25)
Modeling Taxes - 1 (5:17)
Modeling Taxes - 2 (7:51)
Equity, Cash and Dividends
Understanding Equity and Dividends (3:14)
Modeling Equity, Cash and Dividends - 1 (5:46)
Modeling Equity, Cash and Dividends - 2 (7:42)
Part 4 - Modeling Project Finance
Welcome to Part 4 !!! (0:32)
Debt Service Coverage Ratio ("DSCR")
Understanding DSCR (6:23)
Modeling DSCR - 1 (8:41)
Modeling DSCR - 2 (8:05)
Loan Life & Project Life Cover Ratios ("LLCR" & "PLCR")
Understanding LLCR & PLCR (5:30)
Modeling LLCR (8:24)
Modeling PLCR (10:47)
Debt Sculpting
Understanding Debt Sculpting (4:46)
Sculpted debt modeling (8:32)
Debt Service Reserve Account ("DSRA")
Understanding DSRA - 1 (2:24)
Understanding DSRA - 2 (5:24)
Modeling DSRA - 1 (8:42)
Modeling DSRA - 2 (9:55)
Maintenance Reserve Account ("MRA")
Understanding MRA - 1 (2:25)
Understanding MRA - 2 (4:23)
Modeling MRA - 1 (9:19)
Modeling MRA - 2 (10:18)
Revolving Credit Facility
Understanding Revolving Credit Facility - 1 (2:14)
Understanding Revolving Credit Facility - 2 (4:46)
Modeling Revolving Credit Facility -1 (10:05)
Modeling Revolving Credit Facility - 2 (10:25)
Shareholder Loan
Understanding Shareholder Loan - 1 (3:06)
Understanding Shareholder Loan - 2 (4:23)
Modeling Shareholder Loan - 1 (7:43)
Modeling Shareholder Loan - 2 (6:53)
Course Review
Automation and Breaking Circularity With Excel VBA
Understanding Circular References in Project Finance Models (2:35)
Goal Seek Automation Macro (10:06)
Breaking Circularity in Project Finance Models (12:58)
Valuation Analysis
Understanding Valuation (6:06)
Valuation (14:05)
Optimization
Implementing Model Optimization (5:56)
Modeling Track Sheet and Checks
Implementing Track Sheet (10:02)
Modeling Checks (7:31)
Sensitivity and Scenario Analysis
Sensitivity Analysis (4:39)
Scenario Manager (6:22)
Part 5 - Advanced Project Finance Modeling Techniques
Welcome to Part 5 !!! (0:47)
Equity First - Debt Drawdown Method
Understanding Equity First Debt Drawdown Method (1:20)
Equity First Funding - 1 (9:57)
Equity First Funding - 2 (6:17)
Equity First Funding - 3 (6:42)
Debt Sizing Automation
Understanding Debt Sizing (2:41)
Debt Sizing - 1 (14:20)
Debt Sizing - 2 (7:20)
Revisiting Debt Service Reserve Account
DSRA Automation (16:28)
Revisiting Scenario Analysis
Automating Scenario Analysis - 1 (8:02)
Automating Scenario Analysis - 2 (13:31)
Course Review
Course Review
Excel Refresher - Understanding Anchoring
Download
Anchoring before.xlsx
Download
Anchoring after.xlsx
Complete and Continue
Discussion
0
comments
Load more
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login
0 comments