Modified Internal Rate of Return (MIRR): A More Realistic Alternative to IRR

The modified internal rate of return (MIRR) is a project-return metric designed to fix some of the weaknesses of ordinary internal rate of return (IRR).

It does that by separating two assumptions:

• the rate used to finance negative cash flows
• the rate used to reinvest positive cash flows

That usually makes MIRR more realistic than IRR, especially in capital-budgeting work.

Why MIRR Exists

Traditional IRR can mislead because it often assumes interim positive cash flows are reinvested at the IRR itself. That may be unrealistic, especially when the IRR is unusually high.

MIRR improves on that by using explicit rates instead:

• a finance rate for negative cash flows
• a reinvestment rate for positive cash flows

It also avoids the multiple-IRR problem that can appear when cash flows change sign more than once.

Basic Formula

Where:

• positive cash flows are compounded forward at the reinvestment rate
• negative cash flows are discounted back at the finance rate
• \(n\) is the number of periods

Worked Example

Suppose a project has:

• an initial outflow of $100,000
• inflows of $50,000 in years 1, 2, and 3
• a reinvestment rate of 8%
• a finance rate of 6%

First, compound the positive cash flows to year 3:

Then compare that with the present value of the initial outflow:

That rate summarizes the project under more realistic reinvestment assumptions than plain IRR.

MIRR vs. IRR

MIRR usually differs from IRR in three important ways:

• it uses explicit reinvestment and financing assumptions
• it gives a single answer when IRR might produce multiple answers
• it is often easier to compare across projects with unconventional cash flows

That does not make IRR useless. It just means MIRR can be the cleaner tool when reinvestment assumptions matter.

MIRR vs. NPV

Net present value (NPV) still has an important advantage: it measures value created in dollar terms.

MIRR remains a percentage metric.

That means:

• MIRR is useful for communicating return efficiency
• NPV is usually stronger when the real question is value creation

In practice, analysts often look at both.

Related Terms

• Internal Rate of Return (IRR): The traditional return metric that MIRR is designed to improve on.
• Net Present Value (NPV): The value-based metric often used alongside MIRR.
• Hurdle Rate: The required return a project must exceed to be attractive.
• Discount Rate: Central to how project cash flows are valued.
• Capital Budgeting: The decision framework where MIRR is commonly applied.

FAQs