NPV

Definition: NPV is a function that calculates the net present value of a series of cash flows.

Syntax: =NPV(rate, value1, [value2], …)

Situation: This formula is appropriate when you need to calculate the net present value of a series of cash flows.

Example: If you have a series of cash flows and want to find the net present value with a discount rate of 10%, the formula =NPV(10%, A1:A10) can be used, where A1:A10 contains the cash flows.