MIRR
Returns the internal rate of return where positive and negative cash flows are financed at different rates.
FinancialFinance & Accounting
What it does
Calculates Modified Internal Rate of Return.
Syntax
MIRR(values, finance_rate, reinvest_rate)
Arguments
values(range) — Cash flows.finance_rate(number) — Interest rate on borrowing.reinvest_rate(number) — Interest rate on reinvested cash.
Examples
Modified IRR
Calculate MIRR.
FORMULA
=MIRR(A2:A5, 0.1, 0.12)
RESULT
0.12
SAMPLE DATA
| A | |
|---|---|
| 1 | Cash |
| 2 | -1000 |
| 3 | 200 |
| 4 | 400 |
| 5 | 600 |