Documentation/Calc Functions/MIRR

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)

• 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%

MIRR