Are you familiar with the PV and NPV functions in excel? See Help

"Stratuser" wrote:

I have an array that contains N cash flows. I want to get the present value
of the cash flows for all remaining years, starting from 1 to N, then from 2
to N, then 3 to N... and so on, until I reach N, and store these present
values in a separate array.

What's a good way to do this?