Present Value of Remaining Cash Flows

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?

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?