@IRR and @CalcMgrExcelIRR does not return a value equalent to the Excel IRR calculation
Summary:
We are using @IRR inbuilt oracle function in our Calculation rules to arrive at the IRR value , IRR(AC.PBC.6013)= IRR( Cumulative(Free Cash Flow (FCF)(AC.PBC.5003)), WACC(STC.PBC.SRS.0002)). Here FCF = Cash Inflow - Cash Outflow. But we get incorrect IRR values for some cases. We performed few tests of multiple cases with returns incorrect IRR value and i have attached the documents for review. We have used @IRR and @CalcMgrExcelIRR , both are inconsistent with the Excel IRR calculation
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):