# Learn How to Use Microsoft Excel XNPV Function

Written by | 0 Comments | 599 Views

In this article, you will learn how to use the Microsoft Excel XNPV function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel XNPV function return value and syntax with the help of some examples.

Microsoft Excel XNPV Function

The main purpose of the Microsoft Excel XNPV function is to calculate the net present value for irregular cash flows. That implies, with the help of the XNPV function you can able to calculate the net present value, abbreviated as NPV of an investment using a discount rate and a series of cash flows that occur at irregular intervals. So, with the help of the XNPV function, you can able to calculate the net present value for the irregular cash flows.

Return Value of XNPV Function

The return value will be the net present value.

Syntax of XNPV Function

=XNPV(rate, values, dates)

Where the arguments:

• rate: This is the discount rate to apply to the cash flows.
• values: These are the values representing the cash flows.
• dates: The are the dates corresponding to the cash flows.

How to Use Microsoft Excel XNPV Function?

So we know that Microsoft Excel XNPV function you can able to calculate the net present value for the irregular cash flows. That implies, with the help of the XNPV function you can able to calculate the net present value, abbreviated as NPV of an investment using a discount rate and a series of cash flows that occur at irregular intervals. So, with the help of the XNPV function, you can able to calculate the net present value for the irregular cash flows.