IRR function to operate on a specified time period ranges
I would propose an idea of IRR function enhancement to operate on more dynamic environment and respect Anaplan time dimension in the same way as TIMESUM function.
Why it is necessary?
For IRR calculation when the sign of the cash flows changes more than once, for example when positive cash flows are followed by negative ones and then by positive ones (+ + − − − +), the IRR may have multiple real values. So it is essential to have an option to overview overall IRR of the full project, or have a chance to specify periods which need to be calculated. (WIKI)
Currently in Anaplan IRR applies to full timescale and "subsetting" dataset to smaller pieces would be not easy and produce sparcity and not aligned to the best practices calculations.
IRR(CF, From, To, [Ev]) where:
- CF - number formatted source of a Cash Flow
- From - Period or Date of a cashflow start
- To - Period or Date of a cashflow end
- Ev - Optional, number format for expected values of IRR
IRR becomes more customisable and could be compared similarly to EXCEL functional analogues with level of calculations customisation.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!