G
Guest
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.