NAIL FINANCIAL MODELING
Assemble your knowledge step-by-step
Extend a cashflow project finance model to integrate a DSRA, refinancing, a shareholder loan and automate debt sizing & the data table.
NAIL FINANCIAL MODELING
Decode the deal
Project Finance Modeling is some of the most sophisticated
modeling there is. See it simplified like never before.
Thank you so much for your interest in Project Finance Advanced Debt & Equity
I’ve been working closely with Project Finance Banks, Sponsors, and Infrastructure Funds and helping them to get the most out of their deals.
- Have you built a Project Finance model but need to optimise your debt structure?
- Are you needing to integrate VBA and macros into your model?
- Do you want to automate Investment Committee style analysis at the click of a button?
Then this course is for you. Building on the Blueprint for Project Finance modeling this is an advanced course to dive deeper into the world of Debt and Equity for Infrastructure deals.
Watch, Build, Refresh
Get "transaction level experience" in Project Finance modeling
Watch The Training
Dive in to our step-by-step 4 hour video training, showing you exactly how to build a project finance cashflow model from scratch.
Build The Case Study
Get hands on experience building the case study alongside the videos, to make sure you're applying your knowledge.
Refresh your Skills
Use the supplementary handouts and dip back into the course content the next time you need to build a DSRA, or create a macro...
WHAT TO EXPECT FROM THE TRAINING
Project Finance Advanced
Debt & Equity
Get "transaction level experience" in Project Finance Modeling.
Build expertise in project Finance Debt & Equity modelling by extending the Blueprint for Project Finance Modelling. At the conclusion of the course, you will have covered most of the features of financing a real project finance transaction model.
- Go through a term sheet & sculpt debt to a target DSCR
- Size debt based off a target DSCR and gearing covenants.
- Break circularities using the model structure and learn how to create elegant and fast best practice macros
- Build your understanding with macro automation, using For Loop, Do Until, and GoalSeek
- Discuss & integrate a Debt Service Reserve Account (DSRA)
- Discuss the options for refinancing and model a rolling refinance
- Model a Shareholder Loan, understand capitalised (PIK) interest and its impact on the financial statements. Repay with a cash sweep structure.
- Automate the data table to bring rigour to an "Investment Committee” type analysis, and size debt like going through a transaction
SIGN UP TODAY
Complex Concepts Broken Down Like Never Before
What You Are Going To Get
4 Hours of jammed packed video
46 bite-size videos breaking down exactly how to build up a PF model
The Excel Start and End Model.
Private Access to our Mastermind Community
Key Slides PDF Download
12 MONTH Access to All the Training Material
Option to extend for $50 P.A
Detailed Course Breakdown
Build up a best practice cashflow model with a case study of a Greenfieled Wind Farm
COURSE OVERVIEW
- 1A Course Content
3mins
- 1B Intro to model
5mins
MODULE 4: Introduction - Motivations for Refinancing Debt & Types of Refinancing
- 5A Introduction - Motivations for
Refinancing Debt & Types of Refinancing
2mins
- 5B Inputs for Refinancing Debt
3mins
- 5C Timing of Refinancing Debt &
Modifying the Senior Debt Structure
2mins
- 5D Calculating the Refinancing Fee
4mins
- 5E Calculating the Refinancing Margin &
Incorporatng it into the Debt Structure
5mins
MODULE 1: The Relationship Between
Debt Sculpting & Debt Sizing to a Term Sheet
- 2A Introduction to Debt
Scupting & Debt Sizing
5mins
- 2B Seeing the Relationship Between Debt
Sculpting & Sizing with the Mini-model:
Setup, Sculpting & Tenor vs Sizing
3mins
- 2C Seeing the Relationship between
Debt Sculpting & Sizing with the Mini-
model: Debt Sizing
3mins
- 2D Seeing the Relatinship Between
Debt Sculpting & Sizing with the Mini-
model: Resolving Circularities
2mins
- 2E Seeing the Relationship between Debt
Sculpting & Sizing with the Mini-model:
Manual sizing, Bisection Method, Recap
4mins
- 2F Capital Structure - Macro Sheet & Max
Permissible Debt Size
5mins
- 2G Capital Structure - The Calculated/Applied
Structure and Linking
5mins
MODULE 5: Sophisticated Equity Structures with Shareholder Loans
- 6A SHL - Introduction to Shareholder Loan,
Purpose and Order of Repayment
3mins
- 6B Creating Inputs for the Shareholder
Loan and Building an Account
4mins
- 6C SHL Drawdowns-Integrating the
SHL into Funding Sources & Updating
the Capital Structure
7mins
- 6D Calculating SHL Interest Capitalised
and Interest Paid
4mins
- 6E Calculating SHL Principal
Repayment and Updating Distrbutions
6mins
- 6F Updating the CFW, Testing and
Recap
3mins
MODULE 2:Writing Elegant & Robust Macros to size Debt Quickly
- 3A Introduction to Macros
3mins
- 3B Recording & Triggering a
Macro to Get Started
6mins
- 3C Getting into VBA & Refining Code
5mins
- 3D Using the For Loop to Iterate
the Macro
5mins
- 3E Improving Robustness &
Using Named Ranges
2mins
- 3F Using the Do While Loop to
Iterate the Macro
2mins
- 3G BAsic Improvements to
Speed up the Macro
3mins
- 3H Recap to Understand the Role of Loops,
Using shortcuts and Speed Improvements
6mins
MODULE 6: Analysis & Advanced Macros
- 7A Introduction to Automating Debt
Sizing & Equity Calculations with Macro's
5mins
- 7B Introducing the Debt Sizing
Switch & Scheduling Repayment
5mins
- 7C Creating a Master Macro
to Run All Macro's Once
9mins
- 7d Testing & Updating the Scenario Manager
5mins
- 7E Setting up the Data Table for a Macro
4mins
- 7F Writing the Data Table Macro to Run All
Cases AND Run Debt Sizing
Macro's where Required
8mins
- 7G Performing Debt and Equity Analysis
4mins
- 7H Reprofiling Debt in the Case of
Gearing Governed Debt Size
to Improve Equity Returns
5mins
MODULE 3: Incorporating a Debt Service Reserve Account to Reduce the Probability of Default
- 4A Introduction to the DSRA
4mins
- 4B Overview of the DSRA - The Logic Behind
Addition & Releases of Cash
5mins
- 4C Setting up the DSRA &
Establishing the Target Balance
7mins
- 4D Funding the DSRA from
Sources of Cash
5mins
- 4E How to Break the Circularity &
Creating a DSRA Macro
5mins
- 4F Funding from Cashflows to
Top-Up the DSRA
11mins
- 4G Release from DSRA in the
Event of CFADS Shortfall
4mins
- 4H Release from DSRA for DSRA in
Excess of Target Balance
3mins
- 4I Review of DSRA, Linking to
Financial Statements and
Distribution Lock-Up Flag
7mins
CLOSING
- 8 Conclusion
1min
Detailed Course Breakdown
Build up a best practice cashflow model with a case study of a Greenfieled Wind Farm
COURSE OVERVIEW
- 1A Course Content
3mins
- 1B Intro to model
5mins
MODULE 1: The Relationship Between
Debt Sculpting & Debt Sizing to a Term Sheet
- 2A Introduction to Debt
Scupting & Debt Sizing
5mins
- 2B Seeing the Relationship Between Debt
Sculpting & Sizing with the Mini-model:
Setup, Sculpting & Tenor vs Sizing
3mins
- 2C Seeing the Relationship between
Debt Sculpting & Sizing with the Mini-
model: Debt Sizing
3mins
- 2D Seeing the Relatinship Between
Debt Sculpting & Sizing with the Mini-
model: Resolving Circularities
2mins
- 2E Seeing the Relationship between Debt
Sculpting & Sizing with the Mini-model:
Manual sizing, Bisection Method, Recap
4mins
- 2F Capital Structure - Macro Sheet & Max
Permissible Debt Size
5mins
- 2G Capital Structure - The Calculated/Applied
Structure and Linking
5mins
MODULE 2:Writing Elegant & Robust Macros to size Debt Quickly
- 3A Introduction to Macros
3mins
- 3B Recording & Triggering a
Macro to Get Started
6mins
- 3C Getting into VBA & Refining Code
5mins
- 3D Using the For Loop to Iterate
the Macro
5mins
- 3E Improving Robustness &
Using Named Ranges
2mins
- 3F Using the Do While Loop to
Iterate the Macro
2mins
- 3G BAsic Improvements to
Speed up the Macro
3mins
- 3H Recap to Understand the Role of Loops,
Using shortcuts and Speed Improvements
6mins
MODULE 3: Incorporating a Debt Service Reserve Account to Reduce the Probability of Default
- 4A Introduction to the DSRA
4mins
- 4B Overview of the DSRA - The Logic Behind
Addition & Releases of Cash
5mins
- 4C Setting up the DSRA &
Establishing the Target Balance
7mins
- 4D Funding the DSRA from
Sources of Cash
5mins
- 4E How to Break the Circularity &
Creating a DSRA Macro
5mins
- 4F Funding from Cashflows to
Top-Up the DSRA
11mins
- 4G Release from DSRA in the
Event of CFADS Shortfall
4mins
- 4H Release from DSRA for DSRA in
Excess of Target Balance
3mins
- 4I Review of DSRA, Linking to
Financial Statements and
Distribution Lock-Up Flag
7mins
MODULE 4: Introduction - Motivations for Refinancing Debt & Types of Refinancing
- 5A Introduction - Motivations for
Refinancing Debt & Types of Refinancing
2mins
- 5B Inputs for Refinancing Debt
3mins
- 5C Timing of Refinancing Debt &
Modifying the Senior Debt Structure
2mins
- 5D Calculating the Refinancing Fee
4mins
- 5E Calculating the Refinancing Margin &
Incorporatng it into the Debt Structure
5mins
MODULE 5: Sophisticated Equity Structures with Shareholder Loans
- 6A SHL - Introduction to Shareholder Loan,
Purpose and Order of Repayment
3mins
- 6B Creating Inputs for the Shareholder
Loan and Building an Account
4mins
- 6C SHL Drawdowns-Integrating the
SHL into Funding Sources & Updating
the Capital Structure
7mins
- 6D Calculating SHL Interest Capitalised
and Interest Paid
4mins
- 6E Calculating SHL Principal
Repayment and Updating Distrbutions
6mins
- 6F Updating the CFW, Testing and
Recap
3mins
MODULE 6: Analysis & Advanced Macros
- 7A Introduction to Automating Debt
Sizing & Equity Calculations with Macro's
5mins
- 7B Introducing the Debt Sizing
Switch & Scheduling Repayment
5mins
- 7C Creating a Master Macro
to Run All Macro's Once
9mins
- 7d Testing & Updating the Scenario Manager
5mins
- 7E Setting up the Data Table for a Macro
4mins
- 7F Writing the Data Table Macro to Run All
Cases AND Run Debt Sizing
Macro's where Required
8mins
- 7G Performing Debt and Equity Analysis
4mins
- 7H Reprofiling Debt in the Case of
Gearing Governed Debt Size
to Improve Equity Returns
5mins
CLOSING
- 8 Conclusion
1min
WORDS FROM MY CLIENTS
“As a past M&A advisor and latterly a direct investor (via corporate and project finance), I can safely say that Kyle has been the best trainer I’ve ever seen. He’s been able to take my team, some with little knowledge of financial modelling, to a highly competent level in a short period of time."
Jason Frank, Group Director of Data Analytics, European Tyre Enterprise Ltd
WORDS FROM MY CLIENTS
“Kyle was an excellent trainer – very focused
on developing our skills and making sure we understood each aspect of the course."
Alexander G., STUDENT
WORDS FROM MY CLIENTS
“Kyle was fantastic – deep understanding
of the overarching principals of modeling and finance, but also great knowledge of the nuts and bolts of it."
Gabriel Davies, Head of Energy Access, Cross Boundary
WORDS FROM MY CLIENTS
“Kyle had a wealth of knowledge and was able to answer any questions that were asked."
Sarah D., STUDENT
PS - if you’re on the fence.
May I make a suggestion?
Don’t make a decision now. Put the training to the test and try it for 30 days. Go through the fully built model and have a play with it. Explore the step-by-step trainings which show you EXACTLY what to do.
Feel what it feels like to have an advanced macro-enabled Project Finance model at your fingertips.
See what it looks like to click a button and have debt size optimised for all different cases (e.g. P90, Price high/low cases) .
Learn with the same crisp explanations you’re used to on my other courses.
If after 30 days it isn’t everything I’ve promised and more, let me know and I’ll refund every penny.
