Formula XNPV

[Stan]

Can someone explain what "XNPV" does? How is it difference from "NPV"?
Thanks.Stan

[Mike Middleton]

Stan -

Is there something about the Help description for XNPV that is not clear?
XNPV "Returns the net present value for a schedule of cash flows that is not
necessarily periodic. To calculate the net present value for a series of
cash flows that is periodic, use the NPV function."

For XNPV you must specify dates for the cash flows. For NPV the cash flows
are assumed to be equally-spaced time intervals.

- Mike
www.mikemiddleton.com

"Stan" <Stan@discussions.microsoft.com> wrote in message
news:51AFF8B9-07A2-4CC6-A707-BD2AE37CDD58@microsoft.com...
> Can someone explain what "XNPV" does? How is it difference from "NPV"?
> Thanks.Stan

[Vacation's Over]

NPV is for set series of cash flows say $100 every month for 36 months

XNPV allows an array of irregular cash payments
cash dates
(100,200,300,400) , ( 3/3/05, 5/17/05, 3/4/06, 4/21/07)

look it up in help for example

"Stan" wrote:

> Can someone explain what "XNPV" does? How is it difference from "NPV"?
> Thanks.Stan

[Warren]

Mike

I have a problem with excel recignising the date in the XNPV formula. It
returns the #name? error. What do I need to do to solve this error?
--
Warren B


"Mike Middleton" wrote:

> Stan -
>
> Is there something about the Help description for XNPV that is not clear?
> XNPV "Returns the net present value for a schedule of cash flows that is not
> necessarily periodic. To calculate the net present value for a series of
> cash flows that is periodic, use the NPV function."
>
> For XNPV you must specify dates for the cash flows. For NPV the cash flows
> are assumed to be equally-spaced time intervals.
>
> - Mike
> www.mikemiddleton.com
>
> "Stan" <Stan@discussions.microsoft.com> wrote in message
> news:51AFF8B9-07A2-4CC6-A707-BD2AE37CDD58@microsoft.com...
> > Can someone explain what "XNPV" does? How is it difference from "NPV"?
> > Thanks.Stan
>
>
>