You can create a Performance calculation report profile to allocate Cash for Carved out segment from the Parent Portfolio.
To allocate cash for carve out:
- Create a sub-portfolio (SUB) with translation criteria for a particular Segment and Cash and Cash Equivalents from the parent portfolio.
- Assign the same parent portfolio as a benchmark to the sub-portfolio created in step one.
- Determine the percentage of the parent portfolio that the sub-portfolio represents using a Rollup Calculation field.
- Use the Detail Calculation field to change the weight of the cash securities.
- Reweigh everything else accordingly.
- Roll this up to a total return for the sub portfolio using the new weight.
- Another, special configurations are required at the field level to implement the cash allocations and calculate the carve out returns as follows:
– Holdings' Position Detail Regular field (security level) for both Portfolio and Benchmark need to be configured pointing to User Defined in the field indicator.
– Holdings’ Position Regular field (total level) for portfolio needs to be configured pointing to User Defined in the field indicator
– Holdings’ Position Regular field (total level) for benchmark needs to be configured pointing to User Defined in the field indicator - Refer the screenshots for the field configuration, which are unique at Benchmark Total Level field and other fields of portfolio market values.
0 Comments