mirr
Modified internal rate of return.
Syntax
Section titled “Syntax”v = mirr(values, finance_rate, reinvest_rate)Description
Section titled “Description”Returns the modified IRR: assumes negative cash flows are financed at finance_rate and positive cash flows are reinvested at reinvest_rate. Avoids IRR’s unrealistic assumption that all flows are reinvested at the IRR itself.
Example
Section titled “Example”mirr([-10000 3000 4200 6800], 0.10, 0.12)See also
Section titled “See also”irr— Internal rate of return for a series of cash flows.