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 MethodGET
Path/api/summary/investorgroup/{scopeId}/{investorgroupId}/{asOfDate}/{currency}
Request parametersScope 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
ReferenceAPI 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

OutputDescription
dpiTotal DPI of the investor group
commitmentTotal investor group commitment to fund vehicles
contributionTotal investor group paid-in capital to fund vehicles
distributionTotal investor group distribution (including recallable portion) from fund vehicles
navInvestor group total NAV before deduction of carried interest of a fund vehicle
rvpiTotal RVPI of the investor group
tvpiTotal TVPI of the investor group
asOfDateThe selected date

2. performanceByFund - Summary of performance by fund

OutputDescription
fundNameName of fund vehicle which the investor entity invests in
investorNameInvestor entity display name
investorIdInvestor's unique ID
investorInternalIdInvestor's unique ID in a string format, this ID is used for importing the investor into other scope
fundVehicleInternalIdFund's unique ID in a string format
fundVehicleIdFund vehicle's unique ID
commitmentInvestor entity commitment to a fund vehicle
contributionInvestor entity capital contribution or paid-in capital to a fund vehicle
distributionInvestor entity capital distribution (including recallable portion) from a fund vehicle
navInvestor entity NAV before deduction of carried interest of a fund vehicle
totalValueTotal value = NAV after carry + Distribution
tvpiTotal value = Total value / Contribution
carryCarry interest of the investor entity
lpNetIrrInternal 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
totalPerformanceSummary of all fund performance

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

OutputDescription
assetNameName of the asset
initialDateInitial date that records a new of an asset
totalCostThe asset total investment cost allocated to a given investor group
unrealizedThe asset remaining FMV allocated to a given investor group
realizedThe asset realized value allocated to a given investor group
exposureTotalCostPercentage of total cost exposure =
the asset total investment cost (investor group portion) / all investments total investment cost (investor group portion)
exposureTotalValuePercentage of total value exposure =
the asset total value (investor group portion) / all investments total value (investor group portion)
multipleOfCostTotal value / total investment cost of the asset (investor group portion)
dealExpenseInvestment-related expense(s) of the asset (investor group portion)
topTenAssetsTop most at the first 10 assets exposure
totalTop10Summary of the first 10 assets exposure
totalSummary 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)

OutputDescription
contributionInvestor group entity's capital contribution or paid-in capital to fund vehicles
distributionInvestor group entity's capital distribution (including recallable portion) from fund vehicles
changeInNavInvestor group entity's NAV after carry interest
totalValueTotal 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
    }
  ]
}