Greg Ahuy – Complete Financial Modeling for Project Finance in Excel

This course is now available for Pre-Delivery and order within a few days)In The Project Finance Modeling Course we will build complex greenfield project finance transactions for greenfield tollroad projects from scratch in excel.File size: 5.95GB

Greg Ahuy – Complete Financial Modeling for Project Finance in Excel

The high life is possible-Financial modeling skills that are essential for creating, modifying and analyzing financial models for Projects in Sector of infrastructure

You can create an online community by starting with a blank page. Excel A workbook that can be used to create a financial model for Analyse of investment, analysis of debt structuring, evaluation of operating scenario. This course will help you take the next step.-By-Step by step instructions to create a suitable financial model for Analysis of project finance transactions

What’s the point of this course?

Project To assess risk, finance models are used-The rewards of lending and investing in An infrastructure project. Project’s financial feasibility, debt capacity, valuation and value are affected by future cash flows generated from the project. To analyze this data, a financial model was built.

The Project Finance Modeling Course we will build complex greenfield project finance transactions for greenfield tollroad projects from scratch in Excel.

Learn about:

•  What is project financing?
•  Financial modeling Complex and real-Life Transaktions in project finance
•  How to sculpt debt to a target DSCR;
•  How to create best practice macro’s VBA codes To break Circularities;
• How to model Debt Service Reserve Account And Maintenance Reserve Account;
•  How to model Revolver and Shareholder Loan And IRR on Blended Equity;
•  Building project finance models in Excel that covers the The entire life cycle of the project;
•  Perform valuation analysis using the DCF (discounted cash flow) and IRR (internal rate of return) methods.
•  Prepare trusted project finance models for financiers and investors, with an emphasis on risk and valuation
•  Financial models that follow the F.A.S.T standard.

The same financial training was used to prepare top managers and analysts for top financial institutions as well as infrastructure funds.

Contenu du cours
35 sections • 103 sessions • Durée totale: 10 h 17 min
Aperçu
03:01
Aperçu
05:38
Take a quiz to test your knowledge of project finance. Take a Quiz
5 questions
Project Finance in Numbers
02:29
Take the test to see if you understand Project Finance Quiz: In Numbers
2 questions
Financial Players in Project Finance
05:32
Take the test to see if you understand Financial Players in Project Finance Quiz
5 questions
Industrial Players in Project Finance
03:04
Take a test to see if you understand industrial players in Project Finance Quiz
4 questions
Aperçu
03:45
Check Your Knowledge of the Role of Government in Project Finance
1 questions
Risk Analysis in Project Finance
09:53
Get a better 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
Check Your Understanding of Covenants in Project Finance
4 questions
Quezon Power Plant Project Case Study – Part 1
09:48
Quezon Power Plant – Test Your Knowledge Project Case Study – Part 1
2 questions
Quezon Power Plant Project Case Study – Part 2
04:59
Quezon Power Plant – Test Your Knowledge 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
Use 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 the MIN MAX Functions
02:38
Understanding Timeline in Project Finance Models
02:02
Check Your Knowledge 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
Check Your Knowledge of Escalation
2 questions
Modeling Escalation
06:43
Understanding Construction Costs
02:12
Get a better understanding of construction costs
2 questions
Aperçu
06:43
Understanding Construction Funding
01:40
Get a better understanding of construction funding
2 questions
Modeling Construction funding
07:04
Understanding the Financing Costs
03:39
Get a better understanding of the costs involved in financing
2 questions
Modeling Finance Costs – 1
06:57
Modeling Financing Costs – 2
05:36
Welcome to Part 3!
00:22
Understanding Revenue
01:43
Check out your understanding of revenue
1 questions
Modeling Revenue
06:44
Understanding Operating Costs
01:46
Check out your understanding of operating costs
1 questions
Modeling Operating Costs
06:29
Understanding Non-Current Assets
01:44
Check out 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
Get a better understanding of working capital
4 questions
Modeling Working Capital
10:01
Understanding Term Loan
01:39
Get a better understanding of the term loan
2 questions
Modeling Term Loan
08:19
Understanding Taxes
02:25
Take the quiz to test your understanding of taxes
2 questions
Modeling Taxes – 1
05:17
Modeling Taxes – 2
07:51
Understanding Equity Dividends
03:15
Check out your understanding of equity and dividends
2 questions
Modeling Equity, cash and dividends – 1
05:46
Modeling Dividends, Equity, and Cash – 2
07:42
Welcome to Part 4!!
00:32
Understanding DSCR
06:24
Take the test to see if you understand the DSCR.
3 questions
Modeling DSCR – 1
08:41
Modeling DSCR – 2
08:05
Understanding LLCR & PLCR
05:30
Get a better understanding of the loan process and Project Life Cover Ratios.
2 questions
Modeling LLCR
08:24
Modeling PLCR
10:47
Understanding Debt Sculpting
04:46
Take a test to see if you understand debt sculpting
2 questions
Modeling Debt Sculpting
08:32
Understanding DSRA – 1
02:24
Take the test to see if you understand DSRA.
2 questions
Understanding DSRA – 2
05:24
Modeling DSRA – 1
08:42
Modeling DSRA – 2
09:55
Understanding MRA – 1
02:25
Take a test to understand the maintenance reserve account
2 questions
Understanding MRA – 2
04:23
Modeling MRA – 1
09:19
Modeling MRA – 2
10:18
Understanding the Revolving Credit Facility – 1
02:14
Get a better understanding of the Revolving credit facility
2 questions
2 Understanding the Revolving Credit Facility
04:46
Modeling Revolving Credit Facility – 1
10:05
Modeling Revolving Credit Facility 2
10:26
Understanding Shareholder loan – 1
03:06
Get a better understanding of shareholder loans
2 questions
Understanding Shareholder Loan 2
04:24
Modeling Shareholder Loan – 1
07:43
Modeling 2 Shareholder Loan
06:53
Understanding Circular References in Project Finance Models
02:36
You can test your understanding of circular references
2 questions
Macro Goal Seeking Automation
10:06
Breaking Circularity in Project Finance Models
12:58
Understanding Valuation, DCF & IRR
06:06
Check Your Knowledge of Valuation
2 questions
Valuation, DCF & IRR
14:05
Implementing model optimization
05:56
Implementing the Track sheet
10:02
Modeling Checks
07:31
Analysis of Sensitivity
04:39
Scenario Manager
06:22
Part 5 is now open!!
00:47
Understanding Equity First Debt Pulldown 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

Download immediately Greg Ahuy – Complete Financial Modeling for Project Finance in Excel