Modified internal rate of return · Calculation guide

Measure cash-flow returns using separate financing and reinvestment rates.

Calculation guide

Row 1 is time zero; last row is time N. Retain zero rows to preserve timing. Both rates and the result refer to one cash-flow interval.

N=rows−1; negativesPV=Σ(−min(flow[t],0))/(1+finance/100)^t; positivesFV=Σmax(flow[t],0)×(1+reinvest/100)^(N−t); MIRR_pct=100×((positivesFV/negativesPV)^(1/N)−1).

Inputs

Financing rate per period

Example entry 10 %. Allowed range -99.99999999999999 to 10000000.0.

Reinvestment rate per period

Example entry 10 %. Allowed range -99.99999999999999 to 10000000.0.

Net cash flow

Example entry -100 (in the selected currency).

Worked example

InputValue
Financing rate per period10%
Reinvestment rate per period10%

Periods in chronological order

Net cash flow
-100
10
110
ResultValue
Return10%

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Reinvestment rate per period10%11%Return10%10.045445%
Net cash flow (row 1)-100-90Return10%15.950181%
Modified internal rate of return →

Sources