Skip to content

XNPV

Financial

Net present value for cash flows on specific dates.

Syntax

XNPV(rate, values, dates)

Full notes for XNPV are still being written. Use the AI explainer below for the arguments, a worked example and common mistakes.

More Financial functions

ACCRINTACCRINTMAMORDEGRCAMORLINCCOUPDAYBSCOUPDAYSCOUPDAYSNCCOUPNCDCOUPNUMCOUPPCDCUMIPMTCUMPRINC

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.