FUNCTION CATALOGUE / FINANCIAL
NPV Excel function
Calculates net present value of periodic cash flows.
Correct sentence to use
Calculate net present value at discount rate [rate] for [cash flows].
Modify this query in PlainFormula →Example formula
=NPV(10%,B2:B10)
Returns net present value for future cash flows.
Syntax
NPV(rate, value1, [value2], …)
Argument signature: rate, value1, [value2], …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.