# Documentation/Calc Functions/MIRR

From The Document Foundation Wiki

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

MIRR

## Category:

Financial Analysis

## Summary:

Calculates the modified internal rate of return of a series of investments.

## Syntax:

MIRR(**Values**; **Investment**; **Reinvest Rate**)

## Returns:

## Arguments:

**Values** corresponds to the array or the cell reference for cells whose content corresponds to the payments.

**Investment** is the rate of interest of the investments (the negative values of the array)

**Reinvest Rate**:the rate of interest of the reinvestment (the positive values of the array)

## Additional details:

## Examples:

Assuming a cell content of A1 = -5, A2 = 10, A3 = 15, and A4 = 8, and an investment value of 0.5 and a reinvestment value of 0.1, the result is 94.16%.