(This course is available for Pre-order and delivery within a few days!)In The Project Finance Modeling course we will model complex greenfield toll road project finance transactions from scratch in excel.File Size: 5.95 GB
Greg Ahuy – Complete Financial Modeling for Project Finance in Excel
Master the high-end financial modeling skills pivotal to developing, modifying and analyzing financial models for projects in infrastructure sector.
In an online environment you will go from a blank Excel workbook to a financial model suitable for investment analysis, debt structuring and operational scenario evaluation. This course will provide step-by-step instructions on how to build financial model suitable for analyzing project finance transactions.
What this course is about?
Project finance models are used to assess the risk-reward of lending to and investing in an infrastructure project. The project’s debt capacity, valuation and financial feasibility depend on expected future cash flows generated by the project itself and a financial model is built to analyze this.
In The Project Finance Modeling course we will model complex greenfield toll road project finance transactions from scratch in excel.
You will learn about:
 what is project finance;
 financial modeling of complex, real-life project finance transactions;
 how to sculpt debt to a target DSCR;
 how to create best practice macro’s and VBA codes to break circularities;
how to model Debt Service Reserve Account and Maintenance Reserve Account;
 how to model Shareholder Loan, Revolver and Blended Equity IRR;
 building project finance models in excel that cover the entire life of the project;
 carry out valuation analysis based on the discounted cash flow (DCF) and internal rate of return (IRR) methods;
 preparing trusted project finance models tailored to investors and financiers, with a focus on valuation and risk
 financial models that are designed according to the F.A.S.T standards.
This is the same comprehensive financial training used to prepare analysts and managers at top financial institutions and infrastructure funds.
Contenu du cours
35 sections • 103 sessions • Durée totale: 10 h 17 min
Aperçu
03:01
Aperçu
05:38
Test Your Understanding of what is project finance? – Quiz
5 questions
Project Finance in Numbers
02:29
Test Your Understanding of Project Finance In Numbers – Quiz
2 questions
Financial Players in Project Finance
05:32
Test Your Understanding of Financial Players in Project Finance – Quiz
5 questions
Industrial Players in Project Finance
03:04
Test Your Understanding of Industrial Players in Project Finance – Quiz
4 questions
Aperçu
03:45
Test Your Understanding of Role of the Government in Project Finance
1 questions
Risk Analysis in Project Finance
09:53
Test Your Understanding of Risk Analysis in Project Finance
5 questions
Capital & Operating Cash Flows in Project Finance
04:02
Test Your Understanding of Capital & Operating Cash Flows in Project Finance
3 questions
Control Accounts & Cash Flow Waterfall
05:32
Test Your Understanding of Control Accounts & Cash Flow Waterfall
5 questions
Covenants in Project Finance
04:16
Test Your Understanding of Covenants in Project Finance
4 questions
Quezon Power Plant Project Case Study – Part 1
09:48
Test Your Understanding of Quezon Power Plant Project Case Study – Part 1
2 questions
Quezon Power Plant Project Case Study – Part 2
04:59
Test Your Understanding of Quezon Power Plant Project Case Study – Part 2
1 questions
Welcome to Part 2 !!!
00:37
Aperçu
08:38
Calculations In Blocks
10:23
Paste Forward Link
04:30
Daisy Chains and Link Formatting
03:55
Using Placeholders
02:13
Most Used Excel Shortcut Keys
07:52
Aperçu
03:52
Excel Refresher – Understanding Dates
05:26
Excel Refresher – Understanding IF Statements
04:52
Excel Refresher – Understanding SUMIF Function
06:05
Excel Refresher – Understanding LOOKUP functions
05:37
Excel Refresher – Understanding MIN MAX Functions
02:38
Understanding Timeline in Project Finance Models
02:02
Test Your Understanding of Timeline in Project Finance Models
3 questions
Modeling Timing – 1
05:46
Modeling Timing – 2
06:30
Modeling Timing – 3
05:48
Modeling Timing – 4
06:34
Understanding Escalation
02:43
Test Your Understanding of Escalation
2 questions
Modeling Escalation
06:43
Understanding Construction Costs
02:12
Test Your Understanding of Construction Costs
2 questions
Aperçu
06:43
Understanding Construction Funding
01:40
Test Your Understanding of Construction Funding
2 questions
Modeling Construction Funding
07:04
Understanding Financing Costs
03:39
Test Your Understanding of Financing Costs
2 questions
Modeling Financing Costs – 1
06:57
Modeling Financing Costs – 2
05:36
Welcome to Part 3 !!!
00:22
Understanding Revenue
01:43
Test Your Understanding of Revenue
1 questions
Modeling Revenue
06:44
Understanding Operating Costs
01:46
Test Your Understanding of Operating Costs
1 questions
Modeling Operating Costs
06:29
Understanding Non-Current Assets
01:44
Test Your Understanding of Non-Current Assets
2 questions
Modeling Non-Current Assets – 1
05:53
Modeling Non-Current Assets – 2
07:33
Understanding Working Capital
02:38
Test Your Understanding of Working Capital
4 questions
Modeling Working Capital
10:01
Understanding Term Loan
01:39
Test Your Understanding of Term Loan
2 questions
Modeling Term Loan
08:19
Understanding Taxes
02:25
Test Your Understanding of Taxes
2 questions
Modeling Taxes – 1
05:17
Modeling Taxes – 2
07:51
Understanding Equity and Dividends
03:15
Test Your Understanding of Equity and Dividends
2 questions
Modeling Equity, Cash and Dividends – 1
05:46
Modeling Equity, Cash and Dividends – 2
07:42
Welcome to Part 4 !!!
00:32
Understanding DSCR
06:24
Test Your Understanding of DSCR
3 questions
Modeling DSCR – 1
08:41
Modeling DSCR – 2
08:05
Understanding LLCR & PLCR
05:30
Test Your Understanding of Loan Life and Project Life Cover Ratios.
2 questions
Modeling LLCR
08:24
Modeling PLCR
10:47
Understanding Debt Sculpting
04:46
Test Your Understanding of Debt Sculpting
2 questions
Modeling Debt Sculpting
08:32
Understanding DSRA – 1
02:24
Test Your Understanding of DSRA
2 questions
Understanding DSRA – 2
05:24
Modeling DSRA – 1
08:42
Modeling DSRA – 2
09:55
Understanding MRA – 1
02:25
Test Your Understanding of Maintenance Reserve Account
2 questions
Understanding MRA – 2
04:23
Modeling MRA – 1
09:19
Modeling MRA – 2
10:18
Understanding Revolving Credit Facility – 1
02:14
Test Your Understanding of Revolving Credit Facility
2 questions
Understanding Revolving Credit Facility – 2
04:46
Modeling Revolving Credit Facility – 1
10:05
Modeling Revolving Credit Facility – 2
10:26
Understanding Shareholder Loan – 1
03:06
Test Your Understanding of Shareholder Loan
2 questions
Understanding Shareholder Loan – 2
04:24
Modeling Shareholder Loan – 1
07:43
Modeling Shareholder Loan – 2
06:53
Understanding Circular References in Project Finance Models
02:36
Test Your Understanding of Circular References
2 questions
Goal Seek Automation Macro
10:06
Breaking Circularity in Project Finance Models
12:58
Understanding Valuation, DCF & IRR
06:06
Test Your Understanding of Valuation
2 questions
Valuation, DCF & IRR
14:05
Implementing model optimization
05:56
Implementing Track Sheet
10:02
Modeling Checks
07:31
Sensitivity Analysis
04:39
Scenario Manager
06:22
Welcome to Part 5!!!
00:47
Understanding Equity First Debt Drawdown Method
01:20
Equity First Funding – 1
09:57
Aperçu
06:17
Equity First Funding – 3
06:42
Understanding Debt Sizing
02:41
Debt Sizing – 1
14:20
Debt Sizing – 2
07:20
DSRA Automation
16:28
Automating Scenario Analysis – 1
08:02
Automating Scenario Analysis – 2
13:31
Get immediately download Greg Ahuy – Complete Financial Modeling for Project Finance in Excel