Functions
MIRR
Modified internal rate of return
Try it
When to use it
When should I use MIRR instead of IRR?
Use MIRR when you want to avoid IRR's assumption that interim cash flows are reinvested at the same IRR — MIRR lets you specify a separate reinvestment rate and a finance rate for costs.
Used in
Syntax
MIRR(values, finance_rate, reinvest_rate)Examples
=MIRR({-4000,200,250,300,350},0.08,0.11) // => -0.25015913212038143