NPV with rolling start date
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!