Formualizer Docs
ReferenceFunctionsFinancial Functions

XNPV

XNPV: Calculates annualized net present value for irregularly dated cash flows.

Summary

Discounting uses an actual-day offset divided by 365 from the first provided date.

Remarks

  • rate is an annual discount rate.
  • Cash-flow sign convention: outflows are negative and inflows are positive.
  • values and dates are flattened to numeric entries; non-numeric entries are ignored.
  • Scalar error inputs are propagated; callable inputs return #CALC!.
  • Returns #NUM! when values and dates lengths differ or no numeric pair exists.

Examples

Example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
null
Example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
null

FAQ

How are dates interpreted in XNPV?

Each cash flow is discounted by (date_i - first_date) / 365, so dates must align one-to-one with values.

Runtime metadata

Category

Financial

Signature

XNPV(arg1: Number, arg2: Any, arg3: Any)

Arity

min 3, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Any · Scalar

arg3

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/financial/tvm.rs

XIRR

XIRR: Calculates annualized internal rate of return for irregularly dated cash flows.

YIELD

Returns annual yield for a coupon-paying security from its market price.

On this page

SummaryRemarksExamplesRelated functionsFAQHow are dates interpreted in XNPV?Runtime metadata