Excel Function : XNPV
Returns the net present value for a schedule of cash flows that is not necessarily periodic
Microsoft Excel Reference Page
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.