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.


Assemble your knowledge step-by-step

Build up a best practice cashflow model with a case study of a Greenfield Wind Farm.


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

Intro & Theory of PF Debt - Components of a Term Sheet, Evaluating Debt Tenor & Four Repayment Types

3b. Case Study and End Game - End Game

Creating A Robust Structure for Sources n Uses of Construction Funds


The Best Time To Have A Map Is Before You Start The Journey

With the Blueprint Finance 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

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

MODULE 2:  Principles of Project Finance

  • 2a Project Finance Mechanics: Discuss the
    Characteristics, Complexity and Players 

MODULE 3: Foundations of Best Practice

  • 3a Discover Financial Modeling
    Best Practices and See
    Examples of What Not To Do!

MODULE 4:The Case Study and The End Game

  • 4a Introduction to Case Study & the
    Purpose of a Financial Model
  • 4b The End Game of Project Finance:
    Using the Scenario Manager to Analyse the Deal

MODULE 5: The Timing Sheet: Transform a
Spreadsheet into a Financial Model

  • 5a Introduction to
    Timing & Timing Sheet Setup
  • 5b Creating the Timing Strip
    with Dates & Flags
  • 5c Counters: The Connective
    Tissue of a Model
  • 5d Rounding out the Timing Sheet with
    Escalation & Base Rate Interest
  • 5e Finishing the Timing Sheet & Copy Sheet

MODULE 6: Constructing a Greenfield Infrastructure
Project and Calculating Sources Of Funds

  • 6a Introduction & Calculating Construction
    Spend Profile
  • 6b Creating A Robust Structure for Sources &
    Uses of Construction Funds
  • 6c The Cost of Debt: Calculating Interest
    During Construction and Financing Fees

MODULE 7: Operations Over the Lifetime of the Asset -
Revenue and Costs

  • 7a Introduction and Review the Inputs
  • 7b Calculating Revenue of a
    Windfarm with Merchant Revenues
  • 7c Split Opex into Fixed and Variable,
    Escalating Fixed Opex
  • 7d Grouping, Recap & Explanations

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 
  • 8b Modeling the CFW in Excel

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
  • 9b Setup & Modeling the Debt Account
  • 9c Calculating Interest Expense
  • 9d Modeling the Annuity Calculation
    from First Principles
  • 9e Modeling Debt Sculpting through
    the Target Ratio
  • 9f Debt Ratios: Understanding and
    Calculating the Debt Service
    Coverage Ratio; Pulling
  • 9g Debt Ratios: Understanding and
    Calculating the Loan Life Coverage Ratio

MODULE 10: Equity Account, Distributions and Returns to Project and Equity Holders

  • 10a Introduction and Calculating
    Distributions to Equity Holders
  • 10b Setting up Equity Returns Cashflows
  • 10c Theory and Calculation of Net Present
    Value from First Principles and XNPV Function
  • 10d Theory of IRR and Calculation using XIRR
  • 10e Calculating Project Returns

MODULE 11: Using The Scenario Manager
To Turbocharge Your Analysis

  • 11a Introduction to the Scenario Manager;
    What It Does & How it Works
  • 11b Setting up the Scenario Manager in
    Excel to Sensitise Key Variables
  • 11c Creating a Data Table to Simultaneously
    Output Results for All Cases

“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

“Great course. I work at a bank in project finance and I’m wishing I had done this course when I started out modelling!”

Karthik Panicker, Westpac Institutional Bank

The model Kyle built for us is at the core of every management discussion and conversation with investors… including our recent $1bn raise for clean-energy investments” - Jack Stark, CFO, Generate Capital

Jack Stark, CFO, Generate Capital


Get the blueprint, and decode the deal in as little time as possible.

Get the behind-the-scenes top 15 Excel tips and shortcuts I use to build financial models known only by top financial modelers


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.


50% Complete

Two Step

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.