You can create a Performance calculation report profile to allocate cash for the carved segment 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.
- Additional special configurations required at the field level to implement the cash allocations and calculate the carve out returns are as follows:
– Holdings' Position Detail Regular field (security level) for both portfolio and benchmark need to be set to User Defined in the field indicator.
– Holdings’ Position Regular field (total level) for portfolio needs to be set to User Defined in the field indicator
– Holdings’ Position Regular field (total level) for benchmark needs to be set to User Defined in the field indicator - Refer the screenshots for the field configuration, which are unique to the Benchmark Total Level field and other fields of portfolio market values.
Add Comment