...
Cash Adjustment field can use security reference data as well as cash transaction details to select the correct flows. In this example the Cash Adjustment field is selecting Capital Base Fund Investments which are Private Equity Investments, transaction types equal to LPCASH, and event types equal to RECPTS (receipts) to define distributions to LPs.
...
Residual Market value
The TVPI field requires an ending market value for the residual value. For this the TVPI field uses a Detail Calculation fields to define the security criteria and also to select the field in POSITION_DETAIL table where the market value is stored. The market value will be taken from the report results end date. Here is an example:
Define the Date Range
Begin Date
You can define the begin date by selecting a specific date or using the date macros provided in the Begin Date options. For Performance Composites (ACOM) the inception date is the most recent date of the membership Start Date or the Inception Date within
the member’s range. For Reporting Composites (COMP) the Inception Date is simply the member inception date for the members as of the report's end effective date.
End Date
The field’s end date is always the end date of the calculation single period in each performance calculation result.
Building Money Multiple Fields
Adding to a Report and Field Rule
Money Multiple fields are designed for Performance Calculation reports. They can be selected from the Custom folder in General Reporting or by selected the Money Multiple as the Field Type in Metadata Center.
All Money Multiple fields in a Field Rule must have the same begin date. If not the report will result in an error and null values in the report results.
Options When Setting Up the TVPI Field
Here is a breakdown of the field and the field’s options when creating:
...
Option | Definition |
|---|---|
Money Multiple | Select the Money Multiple Ratio to Calculate (Distribution to Paid in Capital) |
Distribution Cash Flow | Select the Cash Adjustment field which defines a Fund Distribution to Limited Partner |
Contribution Cash Flow | Select the Cash Adjustment field which defines a called contribution by the Limited Partner into the Fund |
End Market Value | Select the Detail Calculation field which defines the market value and security criteria for Ending Market Value |
Begin Date options | Defines the first date that cash flows will be included in the calculation |
View the Results
TVPI field results will show up in the security rows for the securities which have cash flows and market values that meet the criteria of the Cash Adjustment and Detail Calculation fields selected. The security criteria should be the same in both fields.
Along with the TVPI field the report results also display the supporting fields Contributions Cash Flow (CCF), Distributions Cash Flows (DCF), and Ending Market Value (EMV) in the results.
...