Financial Modelling

Build

We build bespoke financial models to fit our client’s unique requirements. Working to an agreed structure we work with our clients to agree key input and working capital assumptions for each model with the ability to flex these easily. We work with the client team to integrate key accounting policies such as project revenue recognition in order that the model we produce fits with existing company data and provides a high degree of transparency.

Our financial models are built to best practice guidelines and follow the standard approach of dedicated inputs sheets feeding through to the model workings and outputs (primarily cash flow forecast, profit and loss account and balance sheet). The model must be designed to allow sensitivities to be run and include the ability to flex funding structures to enable the business to be presented under various funding structures (different loan classes incl. loan notes) with appropriate covenant tests embedded within.

Management & support

We provide ongoing management and support of financial models for clients. We update financial forecasting models to reflect actual results allowing clients both the ability to see performance against budget and to facilitate reforecasting should this be required.

We also support clients with updates to financial models for changes in projects, such as acquisitions or additional projects.

Review

We perform financial models reviews for a variety of schemes, from project finance structures to development/investment appraisals. We have experience of both providing assurance to clients on such models, and of taking base client models and adapting and improving as appropriate.

The output from our review is a report setting out the finding of the review both in summary and detailed form. The review is carried out in a holistic and detailed way and findings will be highlighted using specific references allowing quick identification of where any issues lie. Our findings are structured to identify issues of clarification, model integrity and best practice allowing the client to make changes as required.

Related Projects

David Phillips

We were brought in to build a 5-year financial forecasting model for this furnishing company which services the UK property market. Initially the mandate was to cover the initial development of the ...