If you're looking to integrate the XIRR Excel function into your Salesforce Organization, I'd like to offer you this Apex code. It produces results identical to the Google Spreadsheet XIRR function.
The XIRR method calculates the internal rate of return for a schedule of cash flows, even when they are not necessarily periodic.
https://github.com/stonarelli/stonarelli/tree/master/XIRR/Salesforce/src/classes
ALso you can find test examples
Regards!
Top comments (0)