Excel - Microsoft Excel XNPV Function

Description

The Excel XNPV function calculates the Net Present Value for a schedule of cash flows that is not necessarily periodic. 

The format of the function is : 

XNPV( rate, values, dates ) 

Where the arguments are listed in the table below : 

XNPV Function Example

The spreadsheet on the right shows an example of the Xnpv function. The data used is in cells A1-B7 of the spreadsheet, with the discounted rate shown in cell B1, the dates of the returns are stored in cells A2-A7 and the values of the returns are stored in cells B2-B7. 

The Xnpv function used to calculate the net present value of the investment with these terms is shown in cell C10. 

This function gives the result $4,449.60

XNPV Function Errors

If you get an error from the Excel Xnpv function this is likely to be one of the following : 

Common Errors