Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The TVPI multiple is an option found on Money Multiple field fields.  Money Multiple fields are found in General Reporting in the Custom fields folder.  Once a new Money Multiple field is created you can select the Money Multiple “Total Value to Paid in Capital”.

...

The Money Multiple Field type is also available in Metadata Center.  You can find Money Multiple fields under Direct and Derived fields and setting the Field Type Parameter to Money Multiple.

...

How the Field Works

Contributions and Distributions

Cash Flows across a date range

The Money Multiple Field Type is a Performance Calculation based field.  It is designed to utilize data from the CASHDBO.CASH_ACTIVITY table and HOLDINGDBO.POSITION_DETAIL table.  Money Multiple fields offer the unique capability to sum cash flows across a time range.  The cash flows are selected using the Cash Adjustment field logic to identify flows that meet the specific criteria for Private Equity contributions of distributions.

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.