Nail Financial Modeling
Project Finance Modeling is about as tricky as it gets. Get the Blueprint and know the next step.
Assemble your knowledge step-by-step
Build up a best practice cashflow model with a case study of a Greenfield Wind Farm
THE FINMODO ROADMAP
WATCH THE TRAINING
Dive in to our step-by-step 6 hour video training, showing you exactly how to build a project finance cashflow model from scratch.
BUILD THE MODEL
Set aside one hour per day to build up each module. Learn by doing and improve your skills.
LEVEL UP YOUR GAME
Know exactly the next step in your job, breeze through your modeling tasks, and reduce the risk in making the wrong call.
The Best Time To Have A Map Is Before You Start The Journey
With the Blueprint for Project Finance Modeling there is no guess work. Learn financial modeling like you've never seen before - and wow your colleagues and your bosses.
WHAT YOU ARE GOING TO GET
-
6 hours of jammed packed video content
-
40 bite-size videos breaking down exactly how to build up a PF model
-
The Excel start model to the windfarm case-study
-
Private Access to our Mastermind Community
-
A private 1 on 1 personal troubleshooting call
-
LIFETIME Access to all the training material
Detailed Course Breakdown
- Introduction to project finance and the role of the financial model
- 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 functions
- 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.
"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
Project Finance Professional
SIGN UP TODAY
Get the blueprint, and decode the deal in as little time as possible.
