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!

How to Implement a Rolling XNPV in Pigment?

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!

Be the first to reply!