# Documentation/Calc Functions/MIRR

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:

Return a non-negative real number (expressed as a percentage or fraction) which is the modified internal rate of return of a series of investments.

## Arguments:

**Values** is an array or a reference to a range of cells containing real numbers which are the payments.

**Investment** is a real number or a reference to the cell containing that number which is the rate of interest of the investments (the negative values of the array)

**Reinvest Rate** is a real number or a reference to the cell containing that number which is the rate of interest of the reinvestment (the positive values of the array)

## Additional details:

- The formula for MIRR is:

## Examples:

Formula | Description | Returns |
---|---|---|

=MIRR(A1:A16;0.09;0.11) where A1:A6 contains -5000,4000,9000,15000,19000,26000 | The function calculates the modified internal rate of return of a series of investments mentioned in A1 to A6. | 75.80% |

=MIRR(A1:A16;9%;11%) where A1:A6 contains -5000,4000,9000,15000,19000,26000 | The function calculates the modified internal rate of return of a series of investments mentioned in A1 to A6. | 75.80% |

=MIRR(A1:A16;-0.09;-11) where A1:A6 contains -5000,4000,9000,15000,19000,26000 | The function calculates the modified internal rate of return of a series of investments mentioned in A1 to A6. Here Investment and Reinvest Rate can be negative as well. |
478.29% |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

MIRR