Hi,

Try this

=SUMPRODUCT(100*(1+3%)^ROW(1:10))

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Jes Johansen" wrote:

Can anyone assist with this:

I have annual cash flows that are based on tenure of a building lease. The
cash flows are stable and I want to calculate the total cumulative value of
those annually adjusted cash flows.

Say for instance the cash flow in year 1 is 100 and inflation is 3% then the
cash flow in year 10 is 134, which is reach with either of these two formulas:

=100*POWER(1+3%,10)
=100*(1+3%)^10

Instead of entering the values these can of course be linked to other cells.

Both formulas will give me the value in year 10, but not the cumulative
total of the CF for the in-between years. Is there a formula for calculating
this other than calculating the annual CF in separate cells and then
including part of these in an €˜IF= function?