S
Stan
Can someone explain what "XNPV" does? How is it difference from "NPV"?
Thanks.Stan
Thanks.Stan
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
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
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
V
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
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
W
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?
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?