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 indicatorRefer the screenshots for the field configuration, which are unique to the Benchmark Total Level field and other fields of portfolio market values.
Add Comment