MIRR in Collabora Office: Model Separate Financing and Reinvestment Rates

=MIRR(Values; Investment; ReinvestRate)

Values is the payment array or range. Investment is the interest rate applied to the negative cash-flow values; despite its name, this argument is a rate, not the initial invested amount. ReinvestRate is the rate applied to positive cash flows.

There is no optional Guess argument and no date array. The independent model in this guide uses cash flows at regular one-period steps. If actual dates are irregular, this three-argument function does not accept those dates explicitly.

Use the same period units for both rates and the cash-flow spacing. A monthly series paired with annual rate inputs is not a consistent model unless the rates are converted appropriately first.

Enter −5,10,15,8 into A2:A5. Put 50% in C2 and 10% in D2, then enter:

=MIRR(A2:A5;C2;D2)

The documented result is 94.16%. Independently, the positive receipts carried to the final period are:

• 10 grows for two periods: 10×1.1²=12.1
• 15 grows for one period: 15×1.1=16.5
• 8 is already at the final period: 8

Their terminal total is 36.6. The only negative flow is the initial 5, so it requires no discounting back from a later period. The independent MIRR is (36.6/5)^(1/3)−1, approximately 94.164737671%, matching the source’s rounding.

There are four cash-flow entries but only three elapsed periods between the first and last. Using a fourth root would answer a different timing model.

Use a new series −100,40,−20,100, financing rate 10%, and reinvestment rate 12%. The independent terminal value of positive receipts is:

=40*(1+12%)^2+100

Result: 150.176. The magnitude of negative flows discounted to the first period is:

=100+20/(1+10%)^2

Result: approximately 116.528925620. The corresponding independent rate is (150.176/116.528925620)^(1/3)−1, approximately 8.823393192%.

Unlike the first example, a negative flow occurs after the initial period, so changing the financing rate changes the discounted negative-flow total. Keep the two rates separately labeled rather than using one generic “interest” input.

For the second example, compound the negative-flow present-value magnitude forward three periods at the calculated MIRR. It should reproduce the positive-flow terminal value, within chosen numerical tolerance:

=116.528925619835*(1+8.82339319229808%)^3

The independent target is approximately 150.176. In a workbook, reference the unrounded calculation cells instead of typing rounded constants when performing this audit.

ROUND can simplify the displayed percentage, but retain full precision for reconciliation. SUM can total cash flows; that net total is not itself MIRR because it discards timing and the two rate assumptions.

A high modified rate in the small source example reflects its deliberately large positive receipts relative to a small initial payment. It is a mathematical control, not evidence about a realistic investment opportunity.

Validate a mix of positive and negative flows for the ordinary model, consistent periodic timing, and sensible rates. The dedicated section does not enumerate all zero-rate, all-one-sign, blank/text, or invalid-input native outcomes. This guide does not assign unverified error codes or claim a complete implementation contract for those boundaries.

Changing financing or reinvestment assumptions changes the model. MIRR does not discover those rates from the data, include unlisted fees or taxes, or guarantee that future receipts can actually be reinvested at the assumed rate.

The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.

The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.

• Collabora Office 26.04: MIRR (checked October 17, 2026).
• Editorial testing standards.