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