XNPV Function Explained
The XNPV() function in Microsoft Excel calculates the net present value of an investment based on a series of cash flows and a discount rate. It takes three arguments: rate, values, and dates. The rate argument is the discount rate, the values argument is an array of cash flows, and the dates argument is an array of dates corresponding to the cash flows. The function returns the net present value of the investment.
XNPV Function Syntax
XNPV(rate, values, dates)
- rate: The discount rate to be used to calculate the present value of the cash flows.
- values: An array or a reference to cells that contain numbers that represent a series of payments (negative values) and income (positive values) at a regular interval.
- dates: An array or a reference to cells that contain dates that represent the payment and income dates.