A large private equity portfolio including recently launched funds as well as legacy funds relied on multiple internal and external information sources with different formats, structures and levels of granularity. Labour-intensive mapping, aggregation, validation and reconciliation limited consolidated visibility of performance, exposure and concentration across the portfolio and underlying investments.
Consistent mapping was established across products, funds and underlying investments, with performance, exposure and concentration data aggregated and validated at each reporting level. Reporting was designed to provide clear consolidated views across the portfolio, funds, direct investments and co-investments.
Automated data imports, processing and report production substantially reduced manual effort and enabled production within minutes, subject to targeted reconciliation and consistency checks, providing reliable consolidated information for senior management oversight and decision making.
Consolidated visibility and control at every level
Performance · Exposure · Concentration
Multiple source databases across five booking locations included both consolidated sources and sources requiring manual Excel consolidation of equity and fixed income exposures. Security and issuer mapping, particularly for special purpose vehicles, made it difficult to obtain a rapid consolidated view of maximum default exposure by issuer.
A reporting tool was built together with the database structures required for consolidation, embedding security and issuer mapping and consolidating all five booking locations into one issuer risk reporting process using the latest available data.
Consolidated issuer risk reports could be produced within a few minutes, particularly valuable during periods of market stress, while the issuer data could also be reused for other concentration views, including sector concentration. The reporting also supported senior risk management and governance oversight.
Maximum default exposure by issuer across booking locations
Equity · Fixed income