Tuesday 2 May 2017

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 

No comments:

Post a Comment