Present value of cash flows with different discount rates

[tnis0612]

I'm trying to find the present value of a series of all different cash flows but I want to use a series of rates to discount these cash flows instead of one fixed rate. Is there a function in Excel that will do this? Thanks.

 

[tnis0612]

it looks to me like it's not something you can do in Excel. The PV and NPV functions both ask for a single rate and I get a VALUE error if I try to put in a range.

 

[cnestg8r]

Here is how to do it. If you need it in a function, you can use VBA. Perhaps a complex array can be used. It just depends upon your needs.

npv_irr.xlsx.xls
	L	M	N	O	P	Q	R
2	Year	Interestrate	Cashflow	PVfactor	PVofcashflow	CumPV	NetPresentValue
3	0		(600)	100%	(600)	(600)	161
4	1	8%	200	93%	185	(415)
5	2	6%	200	87%	175	(240)
6	3	9%	500	80%	401	161
NPV Rule