Skip to main content

Hi Pigment Team,

Could you please share examples of NPV and XNPV Function in details?

Hi

Anyone can share example here.


Hi Abhilash,

We’ve shared some examples in our documentation for NPV (NPV function | Community (gopigment.com)) and XPNV (XNPV function | Community (gopigment.com)) - you may need to Click on the images to enlarge them but these cover some common use cases.

Is there any specific scenario that you want to use these functions in that I can help with?


We recently used XNPV to fulfil a client requirement. In some cases, they had an XNPV calculated on the exit period asset sale value, which meant most of the yearly CF were zeroes except for 1 single time period.

In order to get it to work in Pigment similar to Excel, we had to deviate from the approach of having zeroes as Blanks in Pigment. The CFs with zeroes were important to get the function to behave similarly to Excel. Hence, I would recommend others to check their IF statements for the ‘Payment Metric’ argument carefully.


Reply