Hi,

I have a column of cashflows for 20 years in cells C1:C21

I want the sum of the discounted cash flows, at a discount rate of 8%.

So... the cashflow in cell C1 is C1/1.08 and C2 is C2/1.08*1.08 ,...etc.

And I need the sum of these... so C1/1.08 + C2/1.08*1.08 + ...+C21/1.08^20

Is there a "Discount formula" that can do this calculation neatly in a
single cell?

Thanks a lot for your help