Formualizer Docs
ReferenceFunctionsFinancial Functions

IRR

IRR: Calculates periodic internal rate of return for regularly spaced cash flows.

Summary

The function iteratively finds the per-period rate where discounted cash flows sum to zero.

Remarks

  • Output is a rate per cash-flow period (not automatically annualized).
  • Cash-flow sign convention: outflows are negative and inflows are positive.
  • Non-numeric cells in arrays/ranges are ignored; direct scalar errors are propagated.
  • A callable value input returns #CALC!.
  • Returns #NUM! if fewer than two numeric cash flows are available, if derivative is near zero, or if iteration does not converge.

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

Why can IRR return #NUM! even with numeric cash flows?

The Newton solve can fail if derivative terms become unstable or no convergent root is reached from the chosen guess.

Runtime metadata

Category

Financial

Signature

IRR(arg1: Any, arg2…: Number)

Arity

min 1, max variadic

Arguments

arg1

Any · Scalar

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

IPMT

IPMT: Returns the interest-only component of a payment for a specific period.

MIRR

MIRR: Calculates modified internal rate of return with separate finance and reinvest rates.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy can IRR return #NUM! even with numeric cash flows?Runtime metadata