Sumproduct & XNPV

[Guest]

Im trying to do an XNPV calculation in which each of my cash flows (values) are first being multiplied by a factor (tax rate) on another page, then the NPV determined from that new after-tax stream. Ive tried =xnpv(rate,values array*taxrate,dates array), but it reports an error. Is there a way to do this? Thanks in advance.

 

[Mark W.]

On 2002-03-14 05:56, Anonymous wrote:
Im trying to do an XNPV calculation in which each of my cash flows (values) are first being multiplied by a factor (tax rate) on another page, then the NPV determined from that new after-tax stream. Ive tried =xnpv(rate,values array*taxrate,dates array), but it reports an error. Is there a way to do this? Thanks in advance.

What are the cell references for 'values array' and 'taxrate'?