The Hext Point™ Core Private Markets Portfolio Report provides an overview of a private markets portfolio and the ability to drill-down to analyse the performance of individual funds and co-investments and is freely available for you to use.

The report uses a Microsoft Excel workbook to store all the required data. All you need to make use of this report is Microsoft Excel, a Power BI subscription and Power BI Desktop.

Features:

• Full private markets support: support for all types of investment including, primary, secondaries, co-investment and direct.

• Multi-asset: supports all private market asset classes, including equity, credit, and real assets.

• Multi-currency: supports all major currencies for aggregate reporting and investments.

• FX attribution: supports FX P&L attribution using the on-market methodology.

• Investment metrics: support for multiple performance metrics (including IRR, TVPI/MOIC, DPI and P&L) and commitment metrics.

• Desktop & mobile: use the report on desktop/tablet devices and mobile. Perform deep analysis on desktop/tablet devices with the full experience, while still being able to do quick analysis on the go with the mobile ready report.

Customisation:

The source code to this sample report is freely available on GitHub. Use it as is or customise it your needs or use it for inspiration.

Should you want support to customise the report to meet your needs, book a free consultation to learn how we can help design a robust solution to meet your needs.

Quick start guide:

Use the quick start guide to take the sample Excel workbook and source code to publish the report with your data.

What's next

• Look-through data: support for holdings and/or aggregate sector, geography and currency exposure is missing. We will be adding look-though capabilities - Follow us on social media to find out when new version launches.

• Microsoft Excel as database: while using Microsoft Excel makes the solution very simple to implement and manage, it is not robust. There is limited data validation, no built-in backup/audit, or fine-grain access control. A more robust solution would be to have a Investment Book of Record ("IBOR") and import the data into a Microsoft Fabric Data Lakehouse for manipulation before import into Power BI. Book a free consultation to learn how we can help selecting a complete solution designed to meet your needs.

• Power BI for ETL: the solution uses Power Query and DAX calculated columns to performer the ETL (Extract, Transform, Load). Power Query is limited in its functionality and it can be complex and slow to perform what would be very easy in SQL. Additionally, the results are only available via the semantic model, so they cannot easily be used in another tool. A more robust solution would be load the Excel workbook into a Microsoft Fabric Data Lakehouse for manipulation before loading into Power BI. Book a free consultation to learn how we can help design a robust solution to meet your needs.

• Benchmarking: this solution does not have any benchmark data available. Private market benchmark data usually requires licenses from the benchmark provider, which has a cost. If this data is made available externally, the cost can be very high. Some performance analytics platforms take care of this problem for you and include public and private market benchmarks. Book a free consultation to learn how we can help bring in benchmark data into your solution or select a solution with benchmark data included.

• Liquidity, public markets, cash flow projections and more...: numerous additional features could be included to support the needs of reporting and analytics across a multi-asset portfolio. Once you enable the full power of Microsoft Fabric, then these features become a real possibility. Book a free consultation to learn how we can help bring the features you need to your 

Disclaimer & Notices

Report Provided “As Is”

This report and its contents are provided on an “as is” basis without any warranties, express or implied, including but not limited to warranties of accuracy, completeness, fitness for a particular purpose, or non-infringement. The author and/or organization accepts no liability for any loss, damage, or expense arising from the use of this report.

No Financial or Legal Advice

The information contained herein is for informational purposes only and does not constitute financial, investment, legal, or tax advice. Users should seek independent professional advice before making any decisions based on this report.

Data Sources

Foreign exchange (FX) rates used in this report have been sourced from the European Central Bank (ECB) and are publicly available for download at https://www.ecb.europa.eu.

Other data sources, if any, are believed to be reliable; however, no guarantee is made as to their accuracy or completeness.

Currency Conversions

All currency conversions are based on ECB reference rates as of the dates indicated. Historical rates may not reflect actual transaction rates.

Limitation of Liability

To the maximum extent permitted by law, the author and/or organization shall not be liable for any direct, indirect, incidental, consequential, or special damages arising out of or in connection with the use of this report.

Intellectual Property & Attribution

This report is made freely available for informational purposes. Redistribution, whether in whole or in part, is permitted provided that clear attribution is given to Hext Point and/or Lawrence Dwight. Attribution should include the original source name and, where possible, a link to the original report or hextpoint.com.