Skip to main content

I’m looking for a way to calculate a Rolling XNPV in Pigment, but I see that only the standard XNPV function is available.

Here’s what I need:

  • The standard XNPV in Pigment calculates the NPV based on all future cash flows from a specific date onward, considering the given discount rate.
  • However, I need to dynamically roll the NPV forward each year, meaning:
    • In 2024, the NPV should only consider cash flows from 2025 onwards.
    • In 2025, the NPV should only consider cash flows from 2026 onwards, and so on.
    • Each year's NPV should exclude past cash flows and focus only on the future values starting from the next period.

Has anyone implemented something similar in Pigment, or is there a workaround to achieve this rolling effect?

Would appreciate any insights or alternative approaches!

Hi Wyunng 🙂

Pigment's XNPV function calculates the Net Present Value (NPV) by discounting all future cash flows from a specified date onward, using the given discount rate.

To achieve the desired result, please try setting the third parameter of the XNPV function to TRUE (Compute All Cells). This may return the outcome you’re looking for.

Let us know if you need further assistance!

Best,

Thanks for your help, Carole! I had actually managed to fix the formula before seeing your response by adding a time dimension filter in the cash flow.
This ensures that each year’s NPV only considers future cash flows from the next period onward. Appreciate the guidance nonetheless!

Reply


Ask your question here!

Terms & ConditionsCookie settings