ReferenceFunctionsFinancial Functions

RRI

RRI(nper, pv, fv) — equivalent interest rate for growth of an investment. Returns (fv/pv)^(1/nper) - 1 (i.e. CAGR).

Summary

RRI(nper, pv, fv) — equivalent interest rate for growth of an investment. Returns (fv/pv)^(1/nper) - 1 (i.e. CAGR).

Formula example

=RRI(A1, B1)

Runtime metadata

Category

Financial

Signature

RRI(arg1: Number, arg2: Number, arg3: Number)

Arity

min 3, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

RATE

Solves for the periodic interest rate implied by annuity cash flows.

SLN

SLN: Returns straight-line depreciation for a single period.

On this page

Summary Formula example Related functions Runtime metadata