|
<< Click to Display Table of Contents >> XNPV (net present value) |
Syntax:
XNPV(Rate, Values, Dates)
Description:
Returns the net present value of an investment with irregular cash flows.
The calculation is based on the cash flows specified in the Values argument. Payments have to be entered as negative values, income as positive values. Payments may be made at any time. The date of each cash flow has to be specified using the Dates argument.
The function expects the following arguments:
Rate is the discount rate to apply to the cash flows.
Values is a cell range or array containing the cash flows. At least one payment and one income have to be given.
Dates is a cell range or array containing the dates for each cash flow specified in Values.
See also: