mirr

Modified internal rate of return

Syntax

Return = mirr(CashFlow,FinRate,Reinvest)

Description

Return = mirr(CashFlow,FinRate,Reinvest) calculates the modified internal rate of return for a series of periodic cash flows. This function calculates only positive rates of return; for nonpositive rates of return, Return = 0.

Examples

Compute Modified Internal Rate of Return

This cash flow represents the yearly income from an initial investment of $100,000. The finance rate is 9% and the reinvestment rate is 12%.

Year 1 $20,000

Year 2 ($10,000)

Year 3 $30,000

Year 4 $38,000

Year 5 $50,000

To calculate the modified internal rate of return on the investment:

Return = mirr([-100000 20000 -10000 30000 38000 50000], 0.09,0.12)

Return = 
0.0832

Input Arguments

CashFlow — Cash flow

vector | matrix

Cash flow, specified as a vector or matrix. The first entry is the initial investment. If CashFlow is entered as a matrix, each column is treated as a separate cash flow.

Data Types: double

FinRate — Finance rate for negative cash flow values

decimal

Finance rate for negative cash flow values, specified as a decimal.

Data Types: double

Reinvest — Reinvestment rate for positive cash flow values

decimal

Reinvestment rate for positive cash flow values, specified as a decimal.

Data Types: double

Output Arguments

Return — Modified internal rate of return

numeric

Modified internal rate of return, returned as a scalar or vector.

References

[1] Brealey and Myers. Principles of Corporate Finance. McGraw-Hill Higher Education, Chapter 5, 2003.

[2] Hazen G. “A New Perspective on Multiple Internal Rates of Return.” The Engineering Economist. Vol. 48-1, 2003, pp. 31–51.

Version History

Introduced before R2006a