MIRR (Modified Internal Rate of Return)
Executive Summary
Key Takeaways
- ✓ MIRR corrects IRR's implicit assumption that interim cash flows reinvest at the IRR itself, replacing it with an explicit, separately specified reinvestment rate.
- ✓ MIRR also eliminates the multiple-IRR (or no-real-IRR) problem that can arise for non-conventional cash flow series with more than one sign change.
- ✓ MIRR requires two separate rate inputs — a finance rate applied to outflows and a reinvestment rate applied to inflows — rather than IRR's single, self-referential rate.
- ✓ A MIRR calculated with an unrealistically high reinvestment rate can overstate a project's true return just as easily as an unadjusted IRR can.
Definition¶
Modified Internal Rate of Return (MIRR) is a capital budgeting metric that corrects two specific weaknesses of IRR: its implicit assumption that interim cash inflows are reinvested at the IRR itself for the remainder of the project, and its potential to produce multiple or no real solutions for a non-conventional cash flow series. MIRR resolves both issues by using two explicit, separately specified rates — a finance rate for outflows and a reinvestment rate for inflows — rather than IRR's single, self-referential rate.
Why It Matters¶
IRR is intuitive and widely used, but its reinvestment assumption is a genuine analytical weakness: a project showing a 35% IRR is implicitly assumed to reinvest every interim cash inflow at 35% for the balance of the project's life, an assumption that is rarely achievable in practice, particularly outside the specific project generating the return. MIRR replaces this embedded, often unrealistic assumption with an explicit, analyst-chosen reinvestment rate, producing a return figure that is more defensible when compared against a firm's actual reinvestment opportunities.
MIRR also resolves the multiple-IRR problem that arises for non-conventional cash flow series — those with more than one change of sign, such as a project requiring a major mid-life capital reinvestment or decommissioning outflow. Because MIRR compounds every outflow and inflow to a single value at each end of the project timeline before solving for a rate, it always produces exactly one solution, unlike IRR, which can mathematically yield more than one discount rate at which NPV equals zero, or none at all.
Technical Background¶
The MIRR Formula¶
MIRR = [ FV(inflows, reinvestment_rate) / PV(outflows, finance_rate) ]^(1/n) - 1
Where FV(inflows, reinvestment_rate) is the future value, at the end of the project (period n), of all cash inflows compounded forward at the reinvestment rate, and PV(outflows, finance_rate) is the present value, at time zero, of all cash outflows discounted back at the finance rate.
How MIRR Differs Mechanically from IRR¶
| Step | IRR | MIRR |
|---|---|---|
| Reinvestment rate for inflows | Implicit — assumed equal to the IRR itself | Explicit — separately specified by the analyst |
| Rate applied to outflows | Same single rate solved for | Explicit finance rate, which may differ from the reinvestment rate |
| Non-conventional cash flows (multiple sign changes) | Can produce multiple or no real solutions | Always produces exactly one solution |
| Number of rate inputs required | None (single rate is the unknown solved for) | Two (finance rate and reinvestment rate) |
The Two Rate Inputs¶
- Finance rate. The rate at which cash outflows are discounted back to time zero — commonly the project's cost of capital or the rate at which the outflow would otherwise be financed.
- Reinvestment rate. The rate at which cash inflows are assumed to be reinvested until the end of the project — commonly a rate reflecting realistically achievable reinvestment opportunities, which may be materially lower than the project's own IRR.
MIRR in Excel¶
=MIRR(cash_flow_range, finance_rate, reinvestment_rate)
Unlike IRR, which takes only the cash flow range as its primary input, MIRR requires both rates to be specified explicitly, forcing the analyst to make the reinvestment assumption visible rather than leaving it embedded and unstated inside the metric.
Common Errors¶
| Error | Description | Risk |
|---|---|---|
| Reinvestment rate set equal to the finance rate by default | Analyst does not distinguish the two rates, collapsing MIRR toward a different but still simplified assumption | Understates the analytical value MIRR is meant to add |
| Reinvestment rate set unrealistically high | Reinvestment rate approaches or exceeds the project's own IRR | MIRR overstates the true return, defeating its purpose |
| MIRR calculated but not compared against IRR or NPV | MIRR presented in isolation without the context of the other metrics | Loses the comparative insight into how sensitive the return is to the reinvestment assumption |
| Cash flow sign convention errors | Outflows entered as positive or inflows as negative in the range passed to MIRR |
Formula returns an invalid or nonsensical result |
Best Practices¶
Set the reinvestment rate to a level that reflects realistically achievable reinvestment opportunities for the entity, commonly its cost of capital or a comparable market rate, rather than defaulting it to the project's own IRR. Present MIRR alongside IRR and NPV rather than as a standalone figure, so a reader can see how much of the IRR result depends on its optimistic reinvestment assumption. Use MIRR, rather than IRR, whenever the cash flow series is non-conventional, to avoid the multiple-IRR problem entirely.
Continue Reading¶
Related Pillars¶
Related Glossary¶
Related Comparisons¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is MIRR?
Modified Internal Rate of Return — a capital budgeting metric that corrects IRR's implicit assumption that interim cash flows reinvest at the IRR itself, using an explicit finance rate for outflows and a separately specified reinvestment rate for inflows.
Why does IRR's reinvestment assumption matter?
IRR implicitly assumes that every interim cash inflow is reinvested at the IRR itself for the remainder of the project's life. For a project with a high IRR, this assumption requires finding equally attractive reinvestment opportunities at that same high rate, which is frequently unrealistic in practice, particularly for short-duration, high-return projects.
What is the multiple-IRR problem, and how does MIRR solve it?
A non-conventional cash flow series — one with more than one change of sign, such as an outflow, followed by inflows, followed by another outflow — can mathematically produce more than one discount rate at which NPV equals zero, or none at all, making IRR ambiguous or undefined. MIRR avoids this entirely because its formula compounds all outflows and inflows to single terminal values before solving for a single rate, which by construction has exactly one solution.
What two rates does MIRR require?
A finance rate, used to discount cash outflows back to time zero (often the cost of capital), and a reinvestment rate, used to compound cash inflows forward to the end of the project (often a rate reflecting the return actually achievable on reinvested cash, which may differ from the cost of capital).
Is MIRR always lower than IRR?
For a project with a high IRR and a reinvestment rate assumption set below that IRR, MIRR is typically lower, since it no longer credits the project with reinvesting inflows at its own high internal rate. This is generally viewed as a more realistic, conservative result rather than a flaw.
How do you calculate MIRR in Excel?
Using the MIRR function, which takes the cash flow range, a finance rate, and a reinvestment rate as its three arguments — =MIRR(cash_flow_range, finance_rate, reinvestment_rate).
Related Articles
IRR (Internal Rate of Return)
Internal Rate of Return (IRR) is the discount rate at which the net present value of a series of cash flows equals zero. It is the generic form of a metric that appears in financial models in several more specific variants, most commonly Project IRR and Equity IRR, each defined on its own cash flow basis. This page defines the generic IRR concept and the Excel functions used to calculate it; for the project finance-specific variants, see Project IRR and Equity IRR.
MIRR vs. IRR
Internal rate of return (IRR) and modified internal rate of return (MIRR) both express a project's return as a single percentage figure calculated from the same underlying cash flow series, but they differ in a specific and consequential way: IRR implicitly assumes that interim cash flows are reinvested at the IRR itself for the remainder of the project's life, an assumption that is often unrealistic, particularly for projects with a high IRR. MIRR replaces this implicit assumption with two explicit, separately specified rates — a finance rate for outflows and a reinvestment rate for inflows — producing a single, more defensible rate of return and eliminating the possibility of multiple or no real solutions for a non-conventional cash flow series.
NPV (Net Present Value)
Net Present Value (NPV) is the sum of a series of future cash flows, each discounted back to the present at a chosen discount rate, minus any initial investment. It is one of the two most commonly used discounted cash flow metrics in financial modelling, alongside IRR, and one of the more frequently misapplied Excel functions, due to a timing convention that is easy to get wrong.
Investment Analysis and Capital Budgeting
Investment analysis and capital budgeting is the discipline of deciding whether a project or investment is expected to create value, using a toolkit of quantitative techniques — net present value, internal rate of return, modified internal rate of return, payback period, and the profitability index — each applied to the same underlying forecast cash flow series but answering a subtly different question. This page is the hub for the Knowledge Centre's investment analysis content: what each technique measures, how the techniques relate to and sometimes conflict with one another, how discount rates and hurdle rates are set, how risk is layered onto the analysis through sensitivity, scenario, and Monte Carlo methods, and — distinctively — how capital-budgeting failure modes map onto FMAE's existing structural audit rule taxonomy.
Hurdle Rate
The hurdle rate is the minimum acceptable rate of return a project or investment must clear to be accepted. It is typically set at or above the entity's cost of capital, and is often, but not always, the same figure used as the discount rate in an NPV calculation. Where the two diverge, it is because the hurdle rate has been deliberately set above the base cost of capital to reflect a project-specific risk premium, a capital-constraint buffer, or an internal policy requiring a margin of safety above the theoretical minimum acceptable return.