Financial formula for Discounting Cashflows

[Guest]

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

 

[Michael R Middleton]

Jeff -

Try =NPV(0.08,C1:C21).

But, the range C1:C21 contains 21 cells, not 20.

- Mike

www.mikemiddleton.com

++++++++++++++++++++++++

 

[dcronje]

=npv(0.08,c1:c21)