Understanding the data monitor

The monitor is designed to give you a high-level understanding of the completeness of your data, but also the ability to drill down to investigate individual metrics.

The Investors define which entities and events in your investments network are needed to construct the monitor. So if you select 1 investor that’s invested into 10 funds that are each invested into 10 companies, these 10 commitment events, 10 funds, 100 investment events and 100 companies are going to be skeleton against which metrics are generated

The Report periods simply define which quarters you want to cover in your data monitor.

When filing in metrics we will be checking against the metric date rather than the report date

The metric filters define which metrics are required as part of your data monitor. You are able to select multiple filters from each document type.

Today we only look at selected metrics and periods when defining metric requirements for a monitor. We also don’t currently include any cashflow data

We then combine these selection to generate your metric requirements to ‘complete’ a data monitor

‍

Helpful hints

To have better control over the different metric groups and period types we recommend creating a different filter for each metric group.

For example, in performance reports you would have different filters for fund metrics, investment metric and asset performance metrics. You would simply then select all three filters to include all those metrics groups in a single monitor.

Example

Assume we select the following parameters for a monitor:

1 investor with commitments to 10 funds each with 10 investments linked to 99 companies (i.e. 2 of the funds have one mutual asset)
4 filters
- Capital account statement filter
  - Metrics = Account balance, Capital contributions, Capital distributions
  - Periods = Inception
- Fund metrics filter (performance report)
  - Metrics = NAV, TVPI, IRR
  - Periods = Inception
- Investment metrics filter (performance report)
  - Metrics = Residual value, Remaining capital invested, Total distributions
  - Periods = Inception
- Asset performance metrics (performance report)
  - Metrics = EBITDA, Revenue, Net debt
  - Periods = LTM, YTD
1 report period

This would produce the following metric requirements

Commitment metrics = 10 commitments x 3 metrics x 1 period x 1 report period = 30 metrics
Fund metrics = 10 funds x 3 metrics x 1 period x 1 report period = 30 metrics
Investment metrics = 100 investments x 3 metrics x 1 period x 1 report period = 300 metrics
Asset metrics = 99 assets x 3 metrics x 2 periods x 1 report period = 495 metrics

Total metrics = 855 metrics

‍

In the case of the asset metrics calculation, Net debt does not require a metric period and therefore we don’t multiply that particular metric by the selected periods resulting in 495 metrics required instead 594

‍

Fund of funds

This logic is slightly different if you have a commitment into a fund of funds that you want to include in your data monitor.

In this case we will continue to display all commitment events, all investment events (including the investment events between two funds as well as any additional investment events between an underlying fund and it’s underlying assets) and all assets of type Company, Infrastructure, Real estate or Project.

The main difference comes in the fund metric section where we will only display funds associated with a commitment event based on the investors you have selected.

An example

As an example, think about an investor invested in a fund of funds that invested into a single fund that is invested into 10 assets. In total this will produce the following in the data monitor:

1 Commitment
1 Fund
11 Investments
10 assets

‍

Viewing your monitor

When you access a monitor you will land on the Overview tab.

Here you will be presented with the Summary banner, which will be visible regardless of the tab that you navigate to, and the monitor completeness grid.

‍

Metric statuses

Before we continue with the core functionality of the monitor it is important to define each metric status and distinguish these from the validation workflow.

Each metric falls into one of three different categories:

Validated: This is a metric that has either been extracted from a document and validated by a user or that has been uploaded to the Accelex platform via CSV
Unconfirmed: This is a metric that we have found in a document that hasn’t yet been validated by a user
Missing: This is a metric that we have been unable to locate anywhere in the database be it from a document, the reference data or a CSV import

‍

Summary banner

The summary banner allows you to see the entities that make up your monitor, your requirements in terms of total metrics, the breakdown of the statuses of all of those metrics and how close you are to completing the monitor itself.

% completion is calculated by diving the total number of validated metric by the total number of required metrics

‍

Monitor completeness grid

The monitor completeness grid allows you to view progress broken down by Fund and Metric group.

These are further broken down by the same statuses and % completion calculation as in the summary banner but includes an additional category name To process. This is calculated as Required - Validated but can also be calculated by summing Unconfirmed + Missing.

% completion is also calculated at the metric group level and the fund level

‍

Metric grid

Metrics are split up into 4 tabs, Commitment, Fund, Investment and Asset. Each tab displays the full set of metrics associated with the relevant metric group (up to a maximum of 10,000 per grid, anymore than this then filters must be applied).

‍

Monitor filters

The filter tray allows users to filter all grids in the monitors. Today this can be done using:

Investor
Fund
Report period

‍

‍Exploring your data – Viewing metric details

Click on a metric in the grid to view its details, such as main attributes, validation status and source document;