MIRR Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with no retirement established.
• Scope: Desktop Sheets with the Financial module. Examples use English semicolon-separated formulas.
• Checked: October 14, 2026. Selected formulas ran through the official 25.04.2 engine library. Source and independent mathematics were checked. This is engine evidence, with no GUI-cell or import verification; 26.08.2 was source-checked only.

MIRR combines the present value of negative cash flows, discounted at the finance rate, with the final-date value of positive cash flows, compounded at the reinvestment rate. With N supplied positions, the growth exponent spans N−1 intervals. Function-specific official reference.

=MIRR(values;financeRate;reinvestmentRate)

Exactly three arguments are required: an ordered cash-flow array or range, finance rate and reinvestment rate. The first position is time zero. For an ordinary model, supply numeric cash flows with at least one positive and one negative amount, and both rates greater than −1. Registration and implementation.

The engine and mathematical columns are separate. Results are rounded to twelve decimal places, or thirteen significant digits in scientific notation for very small or large values. This is a display choice, not an accuracy guarantee. Inline arrays in braces are formula values, not a workbook-import test. Their semicolons separate columns and vertical bars separate rows. Strings remain explicitly quoted, and booleans use TRUE()/FALSE().

For −1000 today and receipts of 200, 300, 400 and 500 at the next four period ends, finance and reinvestment rates of 10% give 0.119230598752, approximately 11.9230598752% per period.

The positive flows accumulate to 1569.2 at the final date: 200*1.1^3+300*1.1^2+400*1.1+500. The initial negative present value is 1000, so the independent calculation is (1569.2/1000)^(1/4)-1. Changing the reinvestment rate changes this result even when the cash flows remain identical.

With a 5% finance rate and 8% reinvestment rate, the same sequence returns approximately 0.112875548410. A later negative investment is discounted separately at the finance rate, rather than being added directly to the initial outlay.

At zero finance and reinvestment rates, the terminal positive amount is simply the sum of positive flows, but the N−1 root remains. The executed reconstruction below raises the returned growth factor to four and recovers 1.5692. MIRR is a stated reinvestment model; it is not the root-finding IRR equation.

The executed advanced check was:

=(1+MIRR({-1000;200;300;400;500};.1;.1))^4

Its engine result was 1.5692.

All-positive, all-negative and all-zero arrays return #VALUE!. A reinvestment rate at or below −1 is explicitly rejected. The finance-rate guard is missing: the tested two-flow case with finance rate −1 returned 1 because its only negative flow was at time zero. That observation is not a usable general rate allowance.

The cash-flow loop accesses each value directly as a float. Numeric text, nonnumeric text, Boolean and error elements in the tested position all became zero and retained that position. Scalar rate arguments use a different converter. Incorrect arity gives #VALUE!. Validate the actual cash-flow types before comparing returns.

• Function-specific implementation
• Versioned function help
• Stable Compounding helper
• Conversion helper

The financial module and value-calculation helpers are byte-identical between the inspected 25.04.2 and 26.08.2 sources. That comparison supports the source discussion but does not establish later-version execution, GUI-cell behavior or other locales.

COMPOUND, POWER, SUM.