NPV

Returns the net present value of a series of future cash flows using a discount rate.

Function syntax

NPV(rate, value1, value2, ...)

Arguments:

• rate: The discount rate applied per period.
• value1, value2, …: Payments (negative values) and income (positive values). Can be individual cell references, literal numbers, or a cell range.

Examples

• NPV(0.12, C1, C2, C3, C4) - Returns the net present value of the cash flows in cells C1 through C4, discounted at 12% per period.
• NPV(0.15, -1000, 400, 450, 700) - Returns the net present value of the cash flows -1000, 400, 450, and 700, discounted at 15% per period.