Use
If you made an investment that pays serious of cash flows, particularly not periodic, by using the XNPV function, you can calculate the net present value for the investment. To calculate the NPV for serious of periodic regular payment, use the NPV function.
Syntax
XNPV(rate, values, dates)
The XNPV function has the following arguments:
rate – Required. The discount rate to be used to find the NPV of irregular cash flows.
values – Required. The serious of cash flows including the first initial investment represented as negative payment and subsequent positive payments or income.
dates – Required. Dates that correspond to the cash flow payments
Example
The investment with the above terms has the XNPV valued of 1043.531.
Function Errors
Error | Occurs |
#VALUE! | If any supplied argument is non-numeric. |
If any supplied date is invalid. | |
#NUM! | If the discount rate is missing in the function. |
If any number in dates precedes the starting date. | |
If values and dates contain a different number of values. |