NAIL FINANCIAL MODELING
Assemble your knowledge step-by-step
Build up a best practice cashflow model with a case study of a Greenfield Wind Farm.
NAIL FINANCIAL MODELING
BLUEPRINT for Project Finance Modeling
Project Finance Modeling is about as tricky as it gets. Get the Blueprint and know the next step.
Thanks so much for your interest in Blueprint for Project Finance Modeling;
- Do you want to work on Project Finance and Infrastructure Deals?
- Are you currently working in Project Finance, but need an understanding of how the numbers come together?
- Want to learn a methodology that is the product of tens of thousands of hours of refinement?
I’ve personally raised > £40m in funding off THIS model, and using the teachings in this course built tens to hundreds of models including:
- A californian renewables fund with > $3bn in assets under management
- A European insurer with > $E2.3 bn of 100 wind and solar farms spread through 100 countries
- A major Russian toll road
I’ve taught this course IN PERSON to project finance bankers, project sponsors, and students looking to get ahead… each who paid $2500 for the privilege... and every course I’ve honed down the teaching methodology… and now it’s your turn.
Here’s a few of the things you’ll end up with
Build up a best practice cashflow model with a case study of a Greenfield Wind Farm
“Project Finance Insider” Clarity
An understanding of project finance mechanics and an A-Z view of how concepts translate into practice.
A rock-solid PF model
A wind-farm cashflow model that builds up from inputs through to cashflow waterfall, complete with a scenario manager.
Saved time
Tens or hundreds of hours figuring it out yourself.
WHAT TO EXPACT FROM THE TRAINING
Blueprint for Project Finance Modeling
Model Working Capital, Accounting & Tax Depreciation, Corporate Tax and a Profit & Loss Statement and a Balance Sheet, threading them into an existing cashflow model.
- Understand the mechanics of project finance, the SPV, the drivers of complexity in a PF model, who uses the model, and the role the financial model plays in a transaction
- Break down what makes best practice modelling. Get ample examples of what to do and what not to do, and why
- Develop the model infrastructure and discuss timing differences in building models, e.g. monthly, quarterly, semi-annual. Develop the Timing sheet
- Model a greenfield asset construction schedule, discussing flexible ways of incorporating costs.
- Build up a flexible method for Sources and Uses funding and discuss how this will change to incorporate additional senior debt tranches, junior debt, shareholder loans. Model interest during construction & financing costs and discuss circularities
- Build up the operating revenue and expenses
- Model escalation in a flexible way (which will enable you to model to almost any contract).
- Model senior debt and debt repayments with annuity and sculpted styles repayments. Discuss PMT function.
- Discuss the debt service coverage ratio and discuss its different applications at the different stages throughout the project.
- Model debt metrics (DSCR & LLCR), discuss PLCR
- Model and understand equity and project returns. Understand first principles calculations, XIRR, XNPV and how the discount rate fits into the model
- Build up the Cashflow Waterfall, discuss hierarchy of cashflows and drivers behind these in a PF model
- Develop a Scenario Manager, allowing ultimate flexibility in the model.
- Incorporate a Data Table into the model; and Perform an advisory style case study, to examine key variables affecting model returns.
Course Samples
X
Intro & Theory of PF Debt - Components of a Term Sheet, Evaluating Debt Tenor & Four Repayment Types
X
3b. Case Study and End Game - End Game
X
Creating A Robust Structure for Sources n Uses of Construction Funds
SIGN UP TODAY
The Best Time To Have A Map Is Before You Start The Journey
What You Are Going To Get
6 Hours of jammed packed video
37 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 Greenfield Wind Farm
MODULE 1: Introduction, Course Aims & Structure
- Intro
3mins
MODULE 2: Principles of Project Finance
- 2a Project Finance Mechanics: Discuss the
Characteristics, Complexity and Players
10mins
MODULE 3: Foundations of Best Practice
- 3a Discover Financial Modeling
Best Practices and See
Examples of What Not To Do!
12mins
MODULE 4:The Case Study and The End Game
- 4a Introduction to Case Study & the
Purpose of a Financial Model
4mins
- 4b The End Game of Project Finance:
Using the Scenario Manager to Analyse the Deal
9mins
MODULE 5: The Timing Sheet: Transform a
Spreadsheet into a Financial Model
- 5a Introduction to
Timing & Timing Sheet Setup
11mins
- 5b Creating the Timing Strip
with Dates & Flags
16mins
- 5c Counters: The Connective
Tissue of a Model
9mins
- 5d Rounding out the Timing Sheet with
Escalation & Base Rate Interest
11mins
- 5e Finishing the Timing Sheet & Copy Sheet
15mins
MODULE 6: Constructing a Greenfield Infrastructure
Project and Calculating Sources Of Funds
- 6a Introduction & Calculating Construction
Spend Profile
9mins
- 6b Creating A Robust Structure for Sources &
Uses of Construction Funds
15mins
- 6c The Cost of Debt: Calculating Interest
During Construction and Financing Fees
22mins
MODULE 7: Operations Over the Lifetime of the Asset -
Revenue and Costs
- 7a Introduction and Review the Inputs
5mins
- 7b Calculating Revenue of a
Windfarm with Merchant Revenues
14mins
- 7c Split Opex into Fixed and Variable,
Escalating Fixed Opex
12mins
- 7d Grouping, Recap & Explanations
6mins
MODULE 8: Explore the Cashflow Waterfall; Theory and Bring In Cash Items to One Central Location
- 8a Theory, Criticial Line Items, Hierarchy
of CFW and Difference Between CFW and CFS
8mins
- 8b Modeling the CFW in Excel
8mins
MODULE 9: Learn about Project Finance Debt Modeling through Annuity, Sculpting & Debt Metrics
- 9a Intro & Theory: Components of a
Term Sheet, Evaluating
Debt Tenor & Four Repayment
8mins
- 9b Setup & Modeling the Debt Account
9mins
- 9c Calculating Interest Expense
6mins
- 9d Modeling the Annuity Calculation
from First Principles
9mins
- 9e Modeling Debt Sculpting through
the Target Ratio
12mins
- 9f Debt Ratios: Understanding and
Calculating the Debt Service
Coverage Ratio; Pulling
18mins
- 9g Debt Ratios: Understanding and
Calculating the Loan Life Coverage Ratio
14mins
MODULE 10: Equity Account, Distributions and Returns to Project and Equity Holders
- 10a Introduction and Calculating
Distributions to Equity Holders
9mins
- 10b Setting up Equity Returns Cashflows
3mins
- 10c Theory and Calculation of Net Present
Value from First Principles and XNPV Function
11mins
- 10d Theory of IRR and Calculation using XIRR
4mins
- 10e Calculating Project Returns
7mins
MODULE 11: Using The Scenario Manager
To Turbocharge Your Analysis
- 11a Introduction to the Scenario Manager;
What It Does & How it Works
5mins
- 11b Setting up the Scenario Manager in
Excel to Sensitise Key Variables
Throughout
11mins
- 11c Creating a Data Table to Simultaneously
Output Results for All Cases
15mins
“As a past M&A adviser 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
“This is a really well designed course. I would recommend this course for both those looking to build their first financial model as well as experienced modelers looking to take the next step”
Chris Gavin, Someva Renewable
“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
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 a best practice cashflow Project Finance model at your fingertips.
See what it looks like to run sensitivities as if you’re doing it for yourself on a deal.
Get used to crystal clear explanations.
If after 30 days it isn’t everything I’ve promised and more, let me know and I’ll refund every penny.
