Excel functions / Financial

MIRR function

Rate of return when money borrowed and money reinvested earn different rates.

Syntax

=MIRR(values, finance_rate, reinvest_rate)

Arguments

When to use it

MIRR gives the rate of return on a series of cash flows, like IRR, but with two realistic assumptions: money borrowed costs a finance rate, and money received is reinvested at a reinvestment rate. IRR assumes everything is reinvested at the IRR itself, which flatters good projects.

Examples

  1. A five-year project

    ABCD
    1YearCash flow
    20-12000012.6%
    3139000
    4230000
    5321000
    6437000
    7546000

    In D2: =MIRR(B2:B7, 10%, 12%) → 12.6%

    10% is the cost of borrowing; 12% is what returns can be reinvested at.

    Try this example

Common mistakes

MIRR in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try MIRR in the playground

Related functions