Sumproduct & XNPV

Mar 14th, 2002, 06:56 AM

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. · Mar 14th, 2002, 08:08 AM

Quote:

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'?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 06:56 AM	#1
Guest Posts: n/a	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.