A large, global Private Equity firm with multiple office locations, 130+ investments and €40bn in total funds raised. One of the largest Private Equity firms in the UK, with over fifty carry and co-investment scheme participants.
What was the initial problem?
The firm’s carry and co-investment data was held in a legacy database, alongside multiple Excel spreadsheets. Their use of leverage to fund co-investments had added a layer of complexity around how much each individual would borrow and those individuals’ balances and interest rates.
The reporting process was manual, slow and dependent on individual team members. PDF reports were produced on a quarterly basis, often distributed to the scheme’s participants months after the quarter end. There were significant concerns around scalability.
The firm needed a robust solution that would enable them to update information with the right controls and processes in place, and to enable as close to real time reporting as possible.
How did Holland Mountain help?
Holland Mountain’s data solutions team were engaged to implement the Carry & Co-Investment module of our ATLAS Data Platform. The team loaded the carry & co-investment scheme data into the Data Platform and developed a mechanism for the business to input data directly into the platform going forwards, thereby decommissioning the legacy database. The necessary calculations and other data transformations were setup in the calculation layer to manage the complexity related to the interest calculations and loan balances. A location was setup to store transactional data.
Holland Mountain worked with the business to design a set of Power BI dashboards to be rolled out to all scheme participants. Now developed and released, these dashboards provide scheme participants with secure, real time access to their positions, with the ability to drill through to transaction level data and to slice and dice. We published the combined data via dynamic Power BI dashboards, designed iteratively with the client, providing the individual scheme participants with secure, real time access to their positions, and the ability to drill through to transaction-level data and perform analysis.
What were the benefits?
Scheme participants are now able to securely access their positions in real time and drill through to transaction-level data. In a 6-week implementation sprint, Holland Mountain delivered a solution that reduced the time it takes to provide scheme participants with their positions from several months to real time.
The ability for scheme participants to self-service their own analysis has vastly reduced the number of questions that the scheme administrator receives, which has greatly improved scalability. Overall, better access to data has strengthened the firm’s carry and co-investment schemes as a long term incentive tool.
About Holland Mountain
Established in 2009, Holland Mountain works exclusively with Private Capital managers, supporting them on their journey to ‘Data as an Asset’. Firms leverage our ATLAS data platform to connect and integrate industry standard solutions, and improve the quality of their analytics and reporting. Managers looking to improve their operating model can leverage our strategic advisory services, systems selection support or implementation services.