Calculate Multiple on Invested Capital
- Kinga Huszno
About MOIC Fields
The Multiple on Invested Capital (MOIC) is the ratio of the total capital invested by limited partners to the Committed Capital for that limited partner.
The Money Multiple Field Type is a Performance Calculation based field therefore the results can be committed to the Performance database for downstream analysis. 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.
Multiple on Invested Capital (MOIC) Formula
The formula for the MOIC Multiple:
Inputs
There are three inputs for the calculation of the Paid-In Capital ratio.
Sum of Distributions
The sum of cash distributed from the private equity investment to the account over a time range.
Market Value
The unrealized value of the private equity investment
Committed Capital
The total amount of money agreed upon by a partner to invest in the fund within a time period.
Additional Field Attribute Inputs:
Begin Date
The first date of the time range and the first date cash flows are eligible to be included in the calculation.
End Date
This is the report’s end date and therefore the default last date of the time range for which cash flows are eligible to be included in the calculation. This is also the date used in fetching the committed capital amount and ending market value.
MOIC Example
Effective Date | Transaction Type | Flow Amount |
|---|---|---|
July 12, 2022 | LPCALL | $30,000,000.00 |
October 12, 2022 | LPCALL | $5,000,000.00 |
October 31, 2022 | End Market Value | $29,000,000.00 |
October 31, 2022 | Committed capital | $50,000,000.00 |
| MOIC | 0.68 |
LPCALL is a contribution and does not impact the MOIC.
LPCALL and LPCASH are transaction types in the CASHDBO.CASH_ACTIVITY table for contributions and distributions respectively. This example divides the sum of distributions plus the Ending Market Value by the Committed Capital. The result is a MOIC equal to 0.68.
Eagle Performance Money Multiple Fields
You can find the Multiple on Invested Capital option on Money Multiple fields. Money Multiple fields are located in General Reporting under the Custom fields folder. After creating a Money Multiple field, you select from the Money Multiple dropdown the Multiple on Invested 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.
Building the Money Multiple Field
Money Multiple fields are designed for Performance Calculation reports. Select them from the Custom folder when creating or editing a field rule in General Reporting.
Distributions
Cash Flows across a date range
The Sum of distribution cash flows using the Cash Adjustment field logic to identify flows that meet the specific criteria for Private Equity contributions.
Cash Adjustment fields use security reference data as well as cash transaction details to select the correct flows. In this example, the Cash Adjustment field selects securities with Processing Security Type (SECURITYDBO.SECURITY_MASTER table) = Capital Base Fund Investments, this identifies Private Equity Investments, and also selects cash transactions with TransType (CASHDBO.CASH_ACTIVITY) = LPCASH which define distributions to LPs.
Committed Capital
The PIC field requires a Committed Capital Amount. PIC fields use Detail Calculation fields to define the security criteria and the field in POSITION_DETAIL table where the committed capital is stored. The committed capital is fetched using the report results end date. Here is an example of the Detail Calculation field and the embedded ORIG_FACE holdings field.
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 those who are members as of the report's end effective date.
End Date
The field’s end date is directly taken from the end date of the calculation report period.
Add to the Report Rule and/or Field Rule
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 for Setting up MOIC Field
Here is an example of the MOIC field and the other field’s options when creating.
Field Options
Field | Description |
|---|---|
Money Multiple | Select the Money Multiple from this dropdown to Calculate (Residual Value to Paid in Capital) |
Distribution Cash Flow | Select the Cash Adjustment field which defines a Fund Distribution to Limited Partner |
Contribution Cash Flow (Not MOIC, or PIC) | Selected 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 |
Committed Capital (PIC, MOIC) | Select the Detail Calculation field which defines the security criteria for Private Equities and the holdings field where the committed amount is stored |
Begin Date options | Defines the first date that cash flows will be included in the calculation |
Include Above Fields in Results | When selected the supporting fields and their results are displayed in report results |
View the Results
MOIC field results show up in the security rows for the securities which have cash flows and commit values that meet the criteria of the Cash Adjustment and/or Detail Calculation fields selected. The security criteria should be the same in both input fields.
Along with the MOIC fields the report results can also display the supporting fields Distributions Cash Flow (DCF) and Committed Capital (CCAP) in the results. To remove the supporting fields from the results do not select the Display Above Fields in Results. In this example, MOIC ITD is the resulting MOIC value, MOIC ITD DCF is the summed distributions, and MOIC ITD CCAP is the committed capital for the relevant securities.