Formualizer Docs
ReferenceFunctionsFinancial Functions

XIRR

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

Summary

The solver uses Newton-Raphson on XNPV(rate, values, dates) = 0 with day-count basis 365.

Remarks

  • Output is an annualized rate.
  • Cash-flow sign convention requires at least one negative and one positive value.
  • guess defaults to 0.1 and can materially affect convergence.
  • Non-numeric entries in value/date arrays are ignored; callable inputs return #CALC!.
  • Returns #NUM! for mismatched lengths, insufficient valid points, missing sign change, derivative failure, or non-convergence.

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

What data shape does XIRR require?

values and dates must have equal numeric length with at least one positive and one negative cash flow, or #NUM! is returned.

Runtime metadata

Category

Financial

Signature

XIRR(arg1: Any, arg2: Any, arg3…: Number)

Arity

min 2, max variadic

Arguments

arg1

Any · Scalar

arg2

Any · Scalar

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

SYD

SYD: Returns sum-of-years'-digits depreciation for a requested period.

XNPV

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhat data shape does XIRR require?Runtime metadata