ReferenceFunctionsFinancial Functions
MIRR
MIRR: Calculates modified internal rate of return with separate finance and reinvest rates.
Summary
Negative cash flows are discounted at finance_rate and positive cash flows are compounded at
reinvest_rate, then combined into a single periodic return.
Remarks
finance_rateandreinvest_rateare both rates per cash-flow period.- Cash-flow sign convention: at least one negative and one positive cash flow are required.
- Non-numeric cells in arrays/ranges are ignored; direct scalar errors are propagated.
- A callable value input returns
#CALC!. - Returns
#NUM!for insufficient cash flows, and#DIV/0!when computed positive/negative legs are invalid.
Examples
Example
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
null
Example
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
null
Related functions
FAQ
Why does MIRR return #DIV/0! for some cash-flow sets?
MIRR needs both a negative leg and a positive leg; if discounted negatives or compounded positives are invalid, it returns #DIV/0!.
Runtime metadata
Category
Financial
Signature
MIRR(arg1: Any, arg2: Number, arg3: Number)Arity
min 3, max 3
Arguments
arg1Any · Scalar
arg2Number · Scalar · coercion NumberLenientText
arg3Number · Scalar · coercion NumberLenientText
Caps
PURE
Source