Description:
To have an NPV formula function that calculates NPV exactly as Excel's period-based NPV formula does.
Benefit/impact:
Current NPV formula returns results as Excel's XNPV formula does (using elapsed days instead of periods). We are in a position of having prospective customers and existing customers use workarounds in order to feel that they are capable of using Anaplan to reproduce their existing results.
This is not an issue of accuracy, rather it is an opportunity to expand our capacity in this area to accommodate a prevalent method of calculating NPV that is entrenched in current business practices. Our current "fix" appears to be spending time in building one-off NPV modules to calculate NPV in the Excel style which adds inefficiency to the sales cycle and to workspace size.