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
| Input | Value |
|---|---|
| Financing rate per period | 10% |
| Reinvestment rate per period | 10% |
Periods in chronological order
| Net cash flow |
|---|
| -100 |
| 10 |
| 110 |
| Result | Value |
|---|---|
| Return | 10% |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Reinvestment rate per period | 10% | 11% | Return | 10% | 10.045445% |
| Net cash flow (row 1) | -100 | -90 | Return | 10% | 15.950181% |
