GuidesRecipesAPI Reference
Log In
Guides

Investor group summary dashboard

Investor group summary provides the key statistics of an investor group (i.e. sum of all investor entities which belong to the investor group) as of a selected date and currency

Generating investor group summary output

Value

HTTP Method

GET

Path

/api/summary/investorgroup/{scopeId}/{investorgroupId}/{asOfDate}/{currency}

Request parameters

Scope ID (string): An ID of the selected scope which can be acquired by the [Scope list API]

investorgroupId: unique ID of investor group

asOfDate: "YYYY-MM'DD" format

currency: example: USD, EUR, CNY

Reference

API Reference InvestorGroup Summary Dashboard

Definition

The investor group summary dashboard consists of standard fieldsets of output calculation from Quantium CORE.

The output is an investor group summary as of a specific date and currency.

The following is a list of standard fieldset returned from Quantium API.

The response contains 4 parts as follows:

1. compareQoQ - contains a comparison of fund performance between the selected quarter and the previous quarter

Output

Description

dpi

Total DPI of the investor group

commitment

Total investor group commitment to fund vehicles

contribution

Total investor group paid-in capital to fund vehicles

distribution

Total investor group distribution (including recallable portion) from fund vehicles

nav

Investor group total NAV before deduction of carried interest of a fund vehicle

rvpi

Total RVPI of the investor group

tvpi

Total TVPI of the investor group

asOfDate

The selected date

2. performanceByFund - Summary of performance by fund

Output

Description

fundName

Name of fund vehicle which the investor entity invests in

investorName

Investor entity display name

investorId

Investor's unique ID

investorInternalId

Investor's unique ID in a string format, this ID is used for importing the investor into other scope

fundVehicleInternalId

Fund's unique ID in a string format

fundVehicleId

Fund vehicle's unique ID

commitment

Investor entity commitment to a fund vehicle

contribution

Investor entity capital contribution or paid-in capital to a fund vehicle

distribution

Investor entity capital distribution (including recallable portion) from a fund vehicle

nav

Investor entity NAV before deduction of carried interest of a fund vehicle

totalValue

Total value = NAV after carry + Distribution

tvpi

Total value = Total value / Contribution

carry

Carry interest of the investor entity

lpNetIrr

Internal rate of return using all contribution/distribution related cash flows and NAV after carried interest deduction as of the selected date

If the value of Net IRR cannot be determined based on the given cash flow, the value inside the field "isNetIrrNotAvailable" will be true

totalPerformance

Summary of all fund performance

3. assetExposure - A summary of investor group investment exposure. The numbers are displayed in the given investor group portion

Output

Description

assetName

Name of the asset

initialDate

Initial date that records a new of an asset

totalCost

The asset total investment cost allocated to a given investor group

unrealized

The asset remaining FMV allocated to a given investor group

realized

The asset realized value allocated to a given investor group

exposureTotalCost

Percentage of total cost exposure =
the asset total investment cost (investor group portion) / all investments total investment cost (investor group portion)

exposureTotalValue

Percentage of total value exposure =
the asset total value (investor group portion) / all investments total value (investor group portion)

multipleOfCost

Total value / total investment cost of the asset (investor group portion)

dealExpense

Investment-related expense(s) of the asset (investor group portion)

topTenAssets

Top most at the first 10 assets exposure

totalTop10

Summary of the first 10 assets exposure

total

Summary of all assets exposure

4. valueCreationChart - a summary of investor group contribution, distribution and total value provided in ready-to-chart format (compatible with Google Bar chart library)

Output

Description

contribution

Investor group entity's capital contribution or paid-in capital to fund vehicles

distribution

Investor group entity's capital distribution (including recallable portion) from fund vehicles

changeInNav

Investor group entity's NAV after carry interest

totalValue

Total value = NAV + Distribution

Example of JSON Result

{
  "compareQoQ": {
    "investorGroupSummaryPerformanceList": [
      {
        "isPreviousQuarter": true,
        "totalValue": 623311.1,
        "dpi": 0,
        "commitment": 6500000,
        "contribution": 854133.999999999,
        "distribution": 0,
        "nav": 623311.1,
        "rvpi": 0.7297579770855636,
        "tvpi": 0.7297579770855636,
        "asOfDate": "2020-09-30"
      },
      {
        "isPreviousQuarter": false,
        "totalValue": 642913.76,
        "dpi": 0,
        "commitment": 6500000,
        "contribution": 854133.999999999,
        "distribution": 0,
        "nav": 642913.76,
        "rvpi": 0.7527083104056281,
        "tvpi": 0.7527083104056281,
        "asOfDate": "2020-12-31"
      }
    ],
    "investorGroupSummaryListCompare": {
      "totalValue": 19602.66,
      "dpi": 0,
      "commitment": 0,
      "contribution": 0,
      "distribution": 0,
      "nav": 19602.66,
      "rvpi": 0.02295033332006456,
      "tvpi": 0.02295033332006456
    }
  },
  "performanceByFund": {
    "performanceList": [
      {
        "fundName": "ExtraFund, L.P.",
        "investorName": "TestMan",
        "investorId": 182,
        "investorInternalId": "6138646604646ddb4cdeb731",
        "fundVehicleInternalId": "6137300ef569e5a223849fd7",
        "fundVehicleId": 23,
        "commitment": 6500000,
        "contribution": 854133.999999999,
        "distribution": 0,
        "nav": 642913.76,
        "totalValue": 642913.76,
        "tvpi": 0.7527083104056281,
        "carry": 0,
        "lpNetIrr": -0.281624268796863,
        "year": 0
      }
    ],
    "totalPerformance": {
      "commitment": 6500000,
      "contribution": 854133.999999999,
      "distribution": 0,
      "nav": 642913.76,
      "totalValue": 642913.76,
      "tvpi": 0.7527083104056281,
      "carry": 0,
      "lpNetIrr": null,
      "year": 0
    }
  },
  "assetExposure": {
    "assets": [
      {
        "assetInternalId": "6138661004646ddb4cdeb743",
        "assetId": 81,
        "assetName": "AB",
        "initialDate": "03-2020",
        "fundNameList": [
          "ExtraFund, L.P."
        ],
        "totalCost": 145586.076529477,
        "unrealized": 145586.07652947807,
        "realized": 0,
        "totalValue": 145586.07652947807,
        "exposureTotalCost": 0.1933981878758276,
        "exposureTotalValue": 0.19339818787582871,
        "multipleOfCost": 1.0000000000000073,
        "dealExpense": 0
      },
      {
        "assetInternalId": "6138661004646ddb4cdeb744",
        "assetId": 82,
        "assetName": "CD",
        "initialDate": "05-2020",
        "fundNameList": [
          "ExtraFund, L.P."
        ],
        "totalCost": 109432.835372636,
        "unrealized": 109432.8353726362,
        "realized": 0,
        "totalValue": 109432.8353726362,
        "exposureTotalCost": 0.14537181411641686,
        "exposureTotalValue": 0.1453718141164169,
        "multipleOfCost": 1.000000000000002,
        "dealExpense": 0
      },
      ...
    ],
    "topTenAssets": [
      {
        "assetInternalId": "6138661004646ddb4cdeb743",
        "assetId": 81,
        "assetName": "AB",
        "initialDate": "03-2020",
        "fundNameList": [
          "ExtraFund, L.P."
        ],
        "totalCost": 145586.076529477,
        "unrealized": 145586.07652947807,
        "realized": 0,
        "totalValue": 145586.07652947807,
        "exposureTotalCost": 0.1933981878758276,
        "exposureTotalValue": 0.19339818787582871,
        "multipleOfCost": 1.0000000000000073,
        "dealExpense": 0
      },
      {
        "assetInternalId": "6138661004646ddb4cdeb744",
        "assetId": 82,
        "assetName": "CD",
        "initialDate": "05-2020",
        "fundNameList": [
          "ExtraFund, L.P."
        ],
        "totalCost": 109432.835372636,
        "unrealized": 109432.8353726362,
        "realized": 0,
        "totalValue": 109432.8353726362,
        "exposureTotalCost": 0.14537181411641686,
        "exposureTotalValue": 0.1453718141164169,
        "multipleOfCost": 1.000000000000002,
        "dealExpense": 0
      },
      ...
    ],
    "totalTop10": {
      "assetInternalId": null,
      "assetId": 0,
      "assetName": null,
      "initialDate": null,
      "fundNameList": null,
      "totalCost": 752778.9072302547,
      "unrealized": 752778.9072302559,
      "realized": 0,
      "totalValue": 752778.9072302559,
      "exposureTotalCost": 1,
      "exposureTotalValue": 1,
      "multipleOfCost": 1.0000000000000018,
      "dealExpense": 0
    },
    "total": {
      "assetInternalId": null,
      "assetId": 0,
      "assetName": null,
      "initialDate": null,
      "fundNameList": null,
      "totalCost": 752778.9072302547,
      "unrealized": 752778.9072302559,
      "realized": 0,
      "totalValue": 752778.9072302559,
      "exposureTotalCost": 1,
      "exposureTotalValue": 1,
      "multipleOfCost": 1.0000000000000018,
      "dealExpense": 0
    }
  },
  "valueCreationChart": [
    {
      "fundName": "ExtraFund, L.P.",
      "contribution": 854133.999999999,
      "distribution": 0,
      "changeInNav": 642913.76,
      "totalValue": 642913.76
    }
  ]
}