You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

@IRR and @CalcMgrExcelIRR does not return a value equalent to the Excel IRR calculation

in Planning 10 comments

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):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!