XNPV

Definition: The XNPV function in Excel is used to calculate the net present value of a series of cash flows that occur at irregular intervals.

Syntax: ==XNPV(rate, values, dates).

Situation: This formula is appropriate in situations where you need to calculate the net present value of a series of cash flows that occur at irregular intervals.

Example: If you have a series of cash flows that occur on January 1, 2022, January 15, 2022, and February 1, 2022, and you want to calculate the net present value of the series of cash flows using a discount rate of 10%, you would use the formula =XNPV(0.1, A1:A3, B1:B3). This would return a value that represents the net present value of the series of cash flows.