Financial Modelling for Renewables

Financial Modelling for Renewables Course

Sector-specific financial modelling taught using best practice and the FAST Standard

Financial Modelling for Renewables focuses on the challenges that arise in preparing financial models for renewables projects: construction vs operations, seasonality, monthly timelines, P90 / P50 forecasting and financing. It is a modular course for analysts and financiers in the renewables sector who need to build, modify, or run financial models. It is available as a 2-day intensive and immersive classroom course, or as interactive live online course over 12 sessions.

We run this course on an open basis in London and Dubai.

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


What you will learn

This course will teach you:

  • The concepts of P90 and P50 and how to apply those within the model’s financial forecasts
  • Approaches for taking annual inputs and implementing those into a monthly financial model and how to aggregate monthly models into broader timelines
  • Methods for selecting different draw down options and how construction phase revenues can impact funding
  • How to optimise financial models under both P50 and P90 cases

Who should attend

This course is suited to participants who already have some basic Excel skills and aspire to, have recently started or know they are going to start building financial models in the renewable energy sector. We also assume that participants have a basic familiarity with the layout of financial statements (income statement, balance sheet and cash flow) but not necessarily how they are modelled.

Based on a template financial model with a monthly timeline, participants will cover – step-by-step – the construction phase (costs, income and financing), model optimisation for lenders and sponsors, equity bridge loans, cash sweeps and debt refinancing.

Book your course

Change currency
18, 19 & 20 Nov
Live Online
GMT Timezone
12 sessions
John Dimberline
As requested
In House
As requested
As requested
$ - Variable
  • 18, 19 & 20 Nov
    GMT Timezone
    John Dimberline
    12 sessions
    Live Online
  • As requested
    Price $ - Variable
    As requested
    As requested
    In House

Course Topics

Project finance fundamentals Model design Best practice fundamentals Generation
  • Applying seasonality and degradation
  • Fixed PPA revenues followed by variable merchant revenues
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 and interest
  • Debt Service Cover Ratio
  • Sculpted debt repayments to achieve a target DSCR
Repayment phase: equity
  • Dividends
  • Shareholder returns
Model optimisation fundamentals
  • Assessing optimisation using a Track sheet
  • Optimisation for gearing
  • Optimisation for revenue unit rate
Optimising for P50 and P90 scenarios
  • Fixing the repayment profile
  • Optimising at P90 and at P50
Find out more:
Financial modelling for renewables brochure cover

Our clients

Asset Alliance Group logo
Energia logo
Drax logo
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.

Course reviews

Contact Us