Flexibility
A vital aspect of the model for investors was to understand the impact of changes in assumptions on cash generation in the business. The model was set up to analyse various upside and downside scenarios with flexibility to quickly amend or switch between scenarios.
Consolidation of a New Business Unit
The existing business would be supported by a new business unit which needed to be modelled from scratch. Through several scoping sessions and iterative testing, the new business unit was set up as a standalone entity with its own inputs and reports as well as a set of consolidated group financials.
Consistent Reporting
Reporting mirrored existing management accounts and was consistent across the business units. This allowed users of the model to efficiently navigate the model and understand where to review assumption changes made throughout the process.
Challenge
To support its equity-raising ambitions and as part of the due diligence process, our client wanted to provide a forecasting model to investors. The model would need to combine a mature existing business unit with a relatively new business unit and be simple to digest while allowing granular scenario testing.
Solution
We developed a final model that allowed the two business units of Elements to be modelled separately before producing consolidated reports. Scenarios could be set up and adjusted with ease, and management can adapt the model for use in business-as-usual planning and forecasting.
Results
The model was a vital element of a successful equity-raising process. The scenario functionality and general ease of use received positive feedback and we were able to deliver the final model in less than two weeks from the initial scoping session. The use of Numeritas modules, as well as the experience of the team, was critical in ensuring the strict deadline was met.
Related Success Stories
We’re trusted modelling advisors across a wide range of business industries, including 10 FTSE 100 companies and Fund Managers with over £1.75 Trillion of assets under management.
Basalt Infrastructure Partners
Infrastructure Fund
