Hi Pigment Team,
Could you please share examples of NPV and XNPV Function in details?
Solved
NPV & XNPV Functions
+7- Wallflower
Best answer by Keiran
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?
+11- Wallflower
- Answer
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?
- Apprentice Author
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.
Log into the Pigment Community
No account yet? Create an account
Single Sign-On Need help?
Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.