Model Build: adding value to your business

With over 400 models built to date, we have experience of a vast variety of model structures, conventions and calculations to call upon. So, while your model may be unique, we are rarely starting from scratch.

How can we help?

Approach

We advocate spending a significant proportion of time on scoping, planning and designing — ensuring that the model delivers as much utility and usability as possible.

Our adaptive and personalised approach means our clients feel in control of model development at every stage of the process and ensures the final product is truly fit for purpose.

Examples

  • a dealership scorecard model for a major European car manufacturer
  • a tool to enable our client to understand and bid for large medical equipment contracts
  • a tool to analyse and report questionnaire responses for a major UK university
  • a model to prioritise alterations to a portfolio of wind turbines based on quantitative and qualitative factors
  • a model to analyse historic healthcare costs to support an NHS Sustainability and Transformation Plan

Our clients

Virgin Trains logo
Asset Alliance Group 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

Case Studies

Virgin Trains is a train operating company that has operated the InterCity West Coast franchise since 1997. It operates long-distance passenger services on the West Coast Main Line between London, West Midlands, North West England, North Wales and Scotland.

The company’s previous process for budgeting, reporting actuals and updating forecasts was complex and time-consuming, with the complexity leading to errors in the final output. Over 80 spreadsheets were in use across 11 departments for the budget process alone. Duplication of common inputs led to inconsistency.
Read more
Virgin Trains is a train operating company that has operated the InterCity West Coast franchise since 1997. It operates long-distance passenger services on the West Coast Main Line between London, West Midlands, North West England, North Wales and Scotland.

The company’s previous process for budgeting, reporting actuals and updating forecasts was complex and time-consuming, with the complexity leading to errors in the final output. Over 80 spreadsheets were in use across 11 departments for the budget process alone. Duplication of common inputs led to inconsistency.
F1F9 created a new process for updating, analysing and communicating large financial datasets in 8 Excel financial models which take inputs from core non-Excel management information systems. This dramatically increased budgeting and forecasting efficiency as well as reducing the risk of errors. The reporting process is now simple and more accurate with a rapid turnaround. We worked in close collaboration with our Virgin Trains contacts and completed the work in 2 months. The new process has been fully adopted within Virgin Trains and F1F9 are providing ongoing support.
Read less

Get in touch

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