Model Build for the Energy and Utilities Industries

Every project is unique and factors that affect project outcomes can change quickly. We’re highly experienced in structuring models that can quickly test changing variables and enable rapid model solving and optimisation. Our use of the FAST Standard facilitates rapid and low-risk changes to model functionality. We provide best-in-class standard structures for funding calculations and covenants.

 

How can we help?

Renewables

We’ve developed numerous feasibility, financial close and operational models across all the major renewable technologies. We’ve also completed feasibility models for micro-grid and district heating projects, including granularity down to hourly periodicity.

Oil and gas

We’ve designed and built models for upstream, midstream and downstream projects, numerous feasibility models, as well as models used to manage technical and financial elements of contracts, to monitor operations and portfolio models.

Utilities

We work closely with regulators and provide support to regulated companies. Our experience includes working with Ofwat to deliver the PR19 model, and work on distribution projects – overland, underwater interconnectors and OFTOs. We also work directly with suppliers on business planning and reporting.

Get in touch

Our financial modelling consultants are here to help, whether you already know what you need or are still exploring your options.

Get in touch

Case studies

In 2016, F1F9 won a tender to work with Ofwat, the body responsible for economic regulation of the privatised water and sewerage industry in England and Wales, and we continued to support them through to 2018. We worked closely with the regulator to rebuild the 2019 price review model (PR19) that Ofwat and the regulated water companies would use in the price review process.
Read more
In 2016, F1F9 won a tender to work with Ofwat, the body responsible for economic regulation of the privatised water and sewerage industry in England and Wales, and we continued to support them through to 2018. We worked closely with the regulator to rebuild the 2019 price review model (PR19) that Ofwat and the regulated water companies would use in the price review process. A large number of complex and interrelated elements need to be incorporated into this type of model, with further layers of complexity introduced from functionality for sensitivities, adjustments and overlays. Transparent calculations and consistency of excel model structure was paramount for this tool, which led Ofwat to specify a model built using the FAST standard. F1F9 worked very closely with the Ofwat Analytics team to develop a model that they were confident would facilitate a smooth and efficient price review.

Our client described their experience of working with us:
“F1F9 has been a flexible, responsive partner for the PR19 model build. With a large team of skilled financial modellers they have always been able to meet our financial modelling requirements, even when deadlines have been very short… I have shared beta versions of the model with companies and feedback from them has been positive: companies have found the FAST-compliant model much more transparent and easier to use. Feedback on the model from internal Ofwat stakeholders has also been very positive”.
Masdar is a global leader in renewable energy and sustainable urban development and has more than a decade of experience working in partnership with business and government as a renewable energy developer and investor. Masdar chose F1F9 as its modelling partner to provide support in the development and monitoring of investments in renewable wind and solar energy projects. We have been adding value to their modelling work since 2012.
Read more
Masdar is a global leader in renewable energy and sustainable urban development and has more than a decade of experience working in partnership with business and government as a renewable energy developer and investor. Masdar chose F1F9 as its modelling partner to provide support in the development and monitoring of investments in renewable wind and solar energy projects. We have been adding value to their modelling work since 2012. Masdar wanted a single point of contact to coordinate the delivery of consistent modelling solutions for several projects under development as well as for a portfolio of operational projects. F1F9 applied the FAST standard and highly-refined model structures to build models that gave both clarity to calculations and maximised the commonality between models. This was supported by bespoke classroom training and reinforced with online resources. We worked closely with the Masdar team to develop effective dashboards focussed on user efficiency and printable reports to communicate results to decision makers.

F1F9’s approach meant that our client’s teams could achieve their desired improvement in transparency and usability across the model estate. The models were used by Masdar to support numerous operational and business development projects, with the experience gained on each project improving productivity on the next.

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