NPV with Rolling Period

Ashutosh

Hi - I am trying to build a module with an NPV calculation which in each month calculates the NPV of cashflows starting from the next month until the last time period in the module.

So in Jan-24 it would calculate the NPV with cashflows from Feb-24 to the end of the module. Then in Feb-24 it would calculate the NPV from Mar-24 and so on.

I guess this needs a way of formulaically setting up the reference of the cells passed to the NPV function, so that the reference moves as you go through time in the model.

I can't see how this is done in an efficient way. Any ideas would be greatly appreciated

Thanks

Ashutosh

pyrypeura

Hi,

@Iain_Briggs wrote a great article on rolling NPV calculation in November. Article can be found here

https://community.anaplan.com/discussion/157134/rolling-npv-with-timescale-workaround

Ashutosh

Thank You for sharing the article @pyrypeura. It worked.

Regards

Ashutosh