Modified Internal Rate of Return (MIRR)
An improved version of IRR that uses separate rates for financing costs and reinvestment returns.
What is MIRR?
Modified Internal Rate of Return (MIRR) fixes two well-known flaws in conventional IRR. First, IRR assumes that positive cash flows are reinvested at the project's own IRR — an unrealistically high assumption for most projects. MIRR instead specifies a realistic reinvestment rate for positive cash flows and a financing rate for negative ones. Second, MIRR always produces a single solution, eliminating the multiple-IRR problem that arises when cash flow signs flip more than once. The result is a more conservative and theoretically sound return metric that is increasingly favoured by CFOs and capital allocators.
Formula
Worked Example
Same 5-year project; finance rate 10%, reinvest rate 8%
Source: CFA Institute — Corporate Finance, 4th ed., Capital Budgeting (2024-01-01)
Calculate MIRR
Enter comma-separated cash flows starting at t=0. Negative values are financed; positive values are reinvested. E.g.: -1000, 300, 400, 500, 200
Cost of capital for negative cash flows
Rate at which positive cash flows are reinvested
MIRR
—