Project Finance Modelling

Project Finance Modelling Course

Advanced financial modelling taught using best practice principles

Our Project Finance Modelling course will teach you how to build a financial model to evaluate equity returns and secure non-recourse debt (known as project finance). On completing the course, you will have built a fully-functional financial model covering the period from the beginning of construction through to the end of the project’s operating period.

After attending the course you will receive access to the online version of the course to help you implement what you learned in the classroom. Online access and post-course support is ongoing.

Our public courses are run in London and Dubai. The course is also available live online.

Book and pay online for your place below, or contact us to request an invoice.

What you will learn?

We will apply general business and non-recourse finance theory to build a cash flow forecast appropriate for the financing of greenfield projects and special purpose vehicles (“SPVs”). You will build a model that evaluates equity returns and may be used to negotiate and secure non-recourse debt through a process of model optimisation.

On completing the course, you will have built for yourself a fully-functional financial model covering the period from the beginning of construction through to the end of the project’s operating period.

Who should attend?

Our Project Finance Modelling training is designed for professionals who need to build, modify and understand financial models associated with project finance and other infrastructure-related transactions (including PPP/PFI projects).

The course is designed for analysts and managers with some modelling experience who have responsibility within their organisations for developing or maintaining project finance models. Many of our participants benefit from completing our Best Practice Financial Modelling course (either online or in the classroom) in preparation for this more advanced financial modelling course.

If you would like to do the course online, you can find an online-specific brochure and details here.

Book your course

Change currency

Date

Format

Location

Duration

Instructor

Price

13 & 14 Feb

Classroom Based

London

2 days

John Dimberline

£1,900

26 & 27 Feb

Classroom Based

Dubai

2 days

Omar Shaker

£1,900

17, 18 & 19 Mar

Live Online

Europe/Gulf timezone

12 hours

John Dimberline

£1,595

Any

Video Based

online

25 hours

Andrew Berkley

£595

As requested

In House

As requested

Any

£ - Variable

13 & 14 Feb

£1,900

Location

London

Instructor

John Dimberline

Duration

2 days

Format

Classroom Based
26 & 27 Feb

£1,900

Location

Dubai

Instructor

Omar Shaker

Duration

2 days

Format

Classroom Based
17, 18 & 19 Mar

£1,595

Location

Europe/Gulf timezone

Instructor

John Dimberline

Duration

12 hours

Format

Live Online
Any

£595

Location

online

Instructor

Andrew Berkley

Duration

25 hours

Format

Video Based
As requested

Price £ - Variable

Location

As requested

Instructor

Any

Duration

As requested

Format

In House

ENQUIRE

Course topics

Model design Drawdown phase

Construction period expenditure
Sources and uses of funds
Drawdown of senior debt and equity

Senior debt interest and fees during construction

Arrangement fee, commitment fee and interest
Applying day conventions to interest
Understanding model periods and debt balances

Drawdown phase circularity

Concept of drawdown phase circularity
Creating the circularity and solving manually
Creating a macro to solve the circularity

Transition from drawdown phase to repayment phase Repayment phase: senior debt

Simple principal payment & interest
Debt Service Cover Ratio
Sculpted debt repayments to achieve a target DSCR
Loan Life Cover Ratio
Debt Service Reserve Account

Repayment phase: equity

Dividends
Shareholder returns

Financial statements

Integration of the financial statements
Using double entry to balance the balance sheet

Model optimisation

Assessing optimisation using a Track sheet
Optimisation for gearing / leverage
Optimisation for DSCR
Impact of changes to tenor

Refining the funding solution

Assessing the impact of adding a shareholder loan

Running post-close sensitivities

Fixing the repayment profile
Running and rationalising sensitivities

Find out more:

Project Finance Modelling brochure cover

DOWNLOAD COURSE BROCHURE

Would you like us to come to you?

We can bring our project finance modelling course to you. Expert teams delivering training at a date and place convenient for the group. Discussions can be tailored to suit the participants and course content tweaked accordingly. Train a group at the same time with no distractions, making it easier to implement project finance modelling best practice.

Find out more

Our clients

I use my new found skills on a daily basis and can’t speak highly enough of the course and what it has given myself and my colleague. It has changed how we do all of our modelling in the company and has received really positive feedback from everyone that has used the model or reviewed the model.

Sally Brierley, Financial Modeller, FCC Environment

We were stunned at the difference that a standardised approach made. Our new Excel models can provide information that just isn’t accessible through an ERP.

Philip Whittingham COO (and former FD), Virgin Trains

The course was great. I learned so much and really enjoyed it. I’m looking forward to using it in my own work. I would be very happy to recommend the course.

Eric Eastlund, Head of Analytics, SCIO Capital

From start to finish the team were very professional and demonstrated considerable experience in what they were doing. The end result is an exceptionally powerful tool, which is straightforward to use, and now forms the backbone to our forecasting process. I would have no hesitation in recommending F1F9.

Douglas McArthur, CA Group FD, Asset Alliance

[The instructor] was enthusiastic about the material and the course itself which created good engagement in class. I particularly liked the fact that we were consistently taking part in the course, rather than being "taught" we were facilitated.

Andrew Dias, Finance Business Partner, Stansted Airport

The Enterprise model is great value for money. We compared it to the other standard reporting systems available such as Sage and Oracle but the F1F9 solution was much cheaper and also gave us the flexibility to change the way we report our business as it grows and develops. It has halved the time our month end reporting process takes. We started out wanting a model for budgeting purposes only but when we saw what the model could do we decided to use it for actuals reporting as well as our rolling forecasts.

Charles Carolan, Senior Financial Analyst, Skrill

[The instructor] was absolutely excellent. Everything was extremely clear, the pace of the class was spot on. I thought I would come away being slightly better at reading models but actually now I would feel completely confident starting my own.

Emma Paterson, SSE/ Beatrice Offshore Windfarm Limited

The team at F1F9 were responsive, hardworking and helped us upgrade our model to be fit for purpose post acquisition. F1F9 took the time to understand our needs early in the process, met deadlines and were professional in their approach.

Investment Manager, UK Private Equity House

Thanks for the excellent academy which has so boosted my own modest modeling skills. F1F9's strong customer service culture is a big help.

Geoffrey Finch, Resident Adviser for Infrastructure Finance for the US Treasury Office of Technical Assistance - Government of Paraguay, Ministry of Finance

I particularly liked the setup of the online training, and the portions provided in each section. The ability to go back and review and exercise with the models after each training and even after a few training provided an excellent opportunity to really 'learn' the skills. The setup allowed for my own pace of learning and the time I was able to dedicate besides work to complete the training. I highly recommended the training to colleagues.

Hartmut Weissmann

Very useful tips and tricks, certainly helped me a lot in understanding and 'simplifying' the enormous models. Thank you very much!

Julie de Bock, Senior Advisory / Corporate Finance, BDO

Can't see the course you need?

Let us know your course requirements and we’ll get back to you.

Get in touch

Course reviews

Very well rounded training session. Interesting to learn all these shortcuts and technics that will save us a lot of time going forward. Thanks a lot!

D. D. Engie

January 30, 2024

John was a great teacher, he was super clear on topics and he was always willing to give a hand. Loved the course. I actually want to try other F1F9 courses with John after this session :)

M. C. Engie

January 23, 2024

Instructors were clear, helpful and provided good insight into modelling standards.

Aliston Jeroff

January 18, 2024

Instructor was very good at explaining concepts and making sure everyone was on the same page. Additionally, the teaching assistant's role was very helpful to answer any additional questions when things went wrong.

A. F. Reventus Power

December 21, 2023

John was very easy to understand and knowledgable in that he anticipates our questions before we can even say them.

M. A. EBRD

October 20, 2023

Valuable course with the instructor trying to make the attendees think of how the model works

H. H.

October 18, 2023

Very interesting course! The concepts covered in this course are valuable. Would be however useful to take a step back (sometimes) to understand a little better what we are doing rather than executing! Overall, very satisfied!

A. A.

October 18, 2023

The instructor was knowledgable on the topic and related topics. The course was well presented and the material relevant. Great experience overall

H. B.

July 30, 2023

Omar is an excellent and enthusiastic teacher, with a great ability to explain complex / new concepts in ways that are easy to understand. He has a lot of patience, and also allows students to think about and talk through concepts before moving on. And during the lunches we had, he was also a fun and smart guy to talk to, so learnt a lot from him in a short time.

E. J.

July 28, 2023

Andrew and Morton were very clear, interesting, funny, friendly.

M. L. Proparco

June 20, 2023

Always happy to learn new XL shortcuts :) Instructors are really experimented and willing to share their experiences Thanks John & Andrew

V. J.

June 16, 2023

Very instructive lesson, I really learnt how to create and deepen a project finance model. One idea would be to copy/paste the value of the formula next to the "main cell" so that everyone can follow along if they have a moment out. Otherwise very nice instructors with good tips.

E. V.

June 16, 2023

John and Andrew were excellent in teaching this course. They knew how to adapt to every pace, and were very patient and helpful. I've learned a lot of new elements, both on style and content. This will without a doubt help me in the future. I will use the template, macros and model template when construcing my next FM. Thank you ! C.

C. V.

June 12, 2023

This course was extremely helpful for me! I am working in industry and use models to pull data that were built in the "FAST standard" and now they are so much easier to understand after taking this course. The instructor, Mark Ringrose, was great, he took time to answer questions and make sure we understood things before moving on, and he was very engaging and easy to listen to.

M. W. Rebel

June 6, 2023

Very interesting course with enthusiastic and passionate teachers! A good way to learn modeling best practices! Thank you John & Andrew !

F. L-S

May 16, 2023

I found the course hugely helpful and really appreciated Andrew's teaching style. He is excellent at delivering clear messages and also has a great manner that means people are open about asking questions and discussing key issues. I thought the course was challenging but delivered in a way that was manageable and really enjoyable. Thanks!

James Meakin

April 28, 2023

I really enjoyed the course as it has enabled me to further advance my modelling skills. Andrew was a very enthusiastic teacher who was always aware of everyone in the room. He provided additional guidance based on our questions and adapted to what we wanted to learn. For me, he even provided additional materials which I wanted to learn more about to provide an extra challenge. Overall, I am certainly satisfied with what I learned over this short period and would be very interested if a more advanced course on VBA would be made available.

Anke Dom

April 21, 2023

Very interesting training, thank you very much. Timing is a bit tight, a couple of additionnal hours would be welcome.

T. B.

April 30, 2023

The instructor had very clear explanations, genuine motivation to help understand, impressive knowledge. The format worked perfectly for me.

Julien Vaillant WMC Energy

January 22, 2021

I think they were very clear in a subject that's very complicated. Basically what I loved about the course was the fact that the modeling was simple. Best!

Axel Versulys

September 29, 2020

Why choose the Project Finance Modelling Course from F1F9?

Our project finance modelling course is designed to allow you to build your own project finance models and also to effectively operate and solve project finance models. The course is taught by trainers who have vast practical experience in delivering project finance transactions. The principles of project finance will be explained to you alongside building the elements of the financial model they relate to. Our curriculum focuses on the fundamentals of the draw-down and repayment phases first, before moving onto model optimization and more advanced project finance modelling topics.

We have been delivering our project finance modelling course for more than ten years to leading banks, investors and advisers, with many embedding our approach in their in-house financial models.