Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: XNPV function

XNPV function: Description, Usage, Syntax, Examples and Explanation

What is XNPV function in Excel? XNPV function is one of Financial functions in Microsoft Excel that returns the net present value for a schedule of cash flows that is not necessarily periodic. To calculate the net present value for a series of cash flows that is periodic, use the NPV function. Syntax of XNPV function XNPV(rate, values, dates) The XNPV…