Excel Function : XNPV
Category
Financial
Description
Returns the net present value for a schedule of cash flows that is not necessarily periodic
Microsoft Excel Reference Page
https://support.office.com/en-us/article/XNPV-function-1b42bbf6-370f-4532-a0eb-d67c16b664b7
Syntax and Description of the XNPV Excel Function
The syntax for the XNPV function in Microsoft Excel is: XNPV(rate, values) rate - The discount rate to use. values - A series of cash flows that correspond to a schedule of payments.
About XNPV Excel Function
The XNPV function calculates the present value of an investment, using a schedule of periodic cash flows and a discount rate. The present value is the sum of the discounted cash flows.
