Excel Function : XNPV

Download now!

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.