The objective of the question is to calculate XIRR values for multiple users who have invested in multiple funds irregularly over the years and may have redeemed few values as well.
The data storage format is shown as under:
The Stamp duty (are taxes) whenever applicable is added to the Amount value for total investment value (Amount field is the total investment minus the taxes). XIRR is to be calculated against:
- Every transaction in the last column.
- As per the under mentioned format.
- As per the under mentioned format.
Any help is appreciated in the matter.
I have tried the undermentioned function for similar but simpler problem as shared in text but I couldn't get close to my requirement.
