Modified IRR (MIRR) - Corporate Finance

SECTION 1

Historical Context & Motivation

Capital budgeting has always demanded a reliable way to rank competing investment projects, and for decades the internal rate of return (IRR) served as the go-to metric alongside net present value (NPV). The IRR approach, however, carries a subtle but critical assumption: every interim cash flow generated by a project is reinvested at the IRR itself, an assumption that can be wildly unrealistic for high-return ventures. As financial scholarship matured through the latter half of the twentieth century, academics and practitioners recognized that this reinvestment-rate assumption could distort project rankings and even produce multiple IRR solutions for non-conventional cash-flow patterns. The Modified Internal Rate of Return (MIRR) emerged as a direct response to these shortcomings, offering a single, unambiguous return figure grounded in more defensible reinvestment and financing-rate assumptions.

1930s • IRR Formalized

Kenneth Boulding and John Maynard Keynes popularize the concept of a discount rate that sets NPV to zero, establishing the IRR as a central capital budgeting criterion.

1955 • Lorie–Savage Critique

James Lorie and Leonard Savage publish influential work highlighting the multiple-IRR problem for projects with non-conventional cash flows, raising questions about IRR's theoretical soundness.

1976 • Reinvestment Rate Debate

Academic literature increasingly challenges the implicit assumption that intermediate cash flows can be reinvested at the project's own IRR, motivating the search for a modified metric.

1982 • MIRR Gains Prominence

Financial textbooks by Brigham and others formally introduce the MIRR, specifying separate reinvestment and financing rates that remove the multiple-root and reinvestment-rate problems.

2000s • Spreadsheet Adoption

Excel's built-in MIRR() function and widespread financial calculator support make the metric accessible to practitioners, embedding it into corporate capital-allocation processes worldwide.

The central question the MIRR addresses is deceptively simple: What is the true annualized return of a project when we acknowledge that interim cash flows are not reinvested at the project's own rate of return? By replacing the IRR's implicit reinvestment assumption with an explicit, user-specified rate—typically the firm's weighted average cost of capital (WACC) or another opportunity cost—the MIRR yields a single, economically meaningful return that always agrees with the NPV rule in accept-or-reject decisions.

SECTION 2

Core Principles & Definitions

Understanding the MIRR requires grasping four foundational ideas that differentiate it from the traditional IRR. Each of these principles addresses a specific weakness in the conventional approach and collectively they produce a metric that is both theoretically robust and practically intuitive for corporate decision-makers.

Explicit Reinvestment Rate

Positive interim cash flows (inflows) are compounded forward to the project's terminal year at a user-specified reinvestment rate, typically the firm's WACC, rather than at the IRR itself.

Explicit Financing Rate

Negative cash flows (outflows occurring after Year 0) are discounted back to the present at a financing rate, often the cost of capital or the borrowing rate, creating the present value of costs.

Terminal Value & PV of Costs

The MIRR distills the entire project into two numbers: the terminal value (TV) of all inflows compounded to Year n and the present value of costs (PV) of all outflows discounted to Year 0.

Unique Solution

Because the MIRR formula reduces to a simple nth-root calculation, it always produces a single, unique rate of return—eliminating the multiple-IRR problem entirely.

✦

KEY TAKEAWAY

Think of the traditional IRR as assuming that every dollar your project generates can immediately be re-deployed into an equally profitable venture—like assuming every new restaurant you open will be as successful as your best one. The MIRR, by contrast, assumes those dollars earn a more realistic rate, perhaps the return on a diversified portfolio of your existing operations. This more conservative reinvestment assumption is analogous to an engineer stress-testing a bridge with real-world loads rather than ideal conditions: the result may be less spectacular, but it is far more reliable for making go/no-go decisions.

SECTION 3

Visual Explanation

The MIRR's mechanics become far clearer when viewed on a cash-flow timeline. The diagram below illustrates how a project's inflows are compounded forward to the terminal year and its outflows are discounted back to Year 0, leaving two single values from which the MIRR is extracted as a simple growth rate.

The timeline shows negative outflows (red arrows pointing down) discounted to Year 0 to form the PV of Costs, and positive inflows (green arrows pointing up) compounded forward to Year n to form the Terminal Value. The MIRR is the annualized growth rate connecting these two values.

Notice how the MIRR effectively transforms a complex multi-period cash-flow stream into a simple two-point problem. All outflows collapse into a single present-value figure at Year 0, and all inflows collapse into a single future-value figure at Year n. The annualized growth rate between these two anchor points is the MIRR. This elegant simplification is precisely what eliminates the possibility of multiple solutions—there is always exactly one nth root relating a positive terminal value to a positive present value of costs.

SECTION 4

Mathematical Framework

The MIRR computation proceeds in three stages: (1) compute the present value of all cash outflows using the financing rate, (2) compute the terminal (future) value of all cash inflows using the reinvestment rate, and (3) solve for the rate that equates the two across the project's life. We formalize each step below.

PRESENT VALUE OF COSTS

PV(costs) = Σ [ COFₜ / (1 + r_f)ᵗ ] for t = 0, 1, …, n

Where COFₜ represents the cash outflow (negative cash flow) at time t, $r_f$ is the financing rate (often the firm's cost of capital), and n is the project's life in years. All outflows are taken as absolute values for this computation.

TERMINAL VALUE OF INFLOWS

TV(inflows) = Σ [ CIFₜ × (1 + r_r)^(n−t) ] for t = 1, 2, …, n

Where CIFₜ is the cash inflow at time t and $r_r$ is the reinvestment rate. Each inflow is compounded forward from its receipt date to the terminal year n, accumulating interest for (n − t) periods.

MIRR FORMULA

MIRR = ( TV(inflows) / PV(costs) )^(1/n) − 1

This is the annualized compound growth rate that converts the present value of all costs into the terminal value of all inflows over n periods. Accept the project if MIRR > cost of capital; reject otherwise.

💡

Special Case: Single Outflow at Year 0

When the only cash outflow is the initial investment at t = 0, the PV of costs equals the initial investment itself (no discounting needed, since it already occurs at t = 0). This simplifies the MIRR formula to MIRR =

(TV / |CF₀|)^{1/n}

− 1, which is the version most commonly encountered in introductory corporate finance courses.

SECTION 5

IRR versus MIRR — A Detailed Comparison

A side-by-side comparison of the IRR and MIRR reveals the precise improvements the modified metric offers. The diagram below visualizes how the two approaches diverge in their treatment of interim cash flows and how this divergence can lead to different project rankings under capital rationing.

The left panel (red border) summarizes the traditional IRR's characteristics, including its potentially problematic reinvestment assumption and multiple-solution issue. The right panel (green border) shows how the MIRR resolves each of these weaknesses.

It is worth noting that both metrics share the same accept-or-reject threshold—compare the computed rate against the firm's cost of capital—but their numerical values will differ whenever the reinvestment rate deviates from the IRR. For projects whose IRR significantly exceeds the WACC, the MIRR will typically be lower because it no longer assumes that interim cash flows earn that extraordinary rate. Conversely, for projects with an IRR below the reinvestment rate assumption, the MIRR may actually exceed the IRR, though such situations are less common in practice since firms rarely pursue projects whose IRR falls below the cost of capital.

⚠

The Multiple-IRR Problem

Descartes' rule of signs tells us that a polynomial of degree n can have up to n real roots. Since the IRR is a root of the NPV polynomial, projects with sign changes in their cash-flow stream (e.g., an initial outflow, a series of inflows, and then a large terminal outflow for decommissioning) can produce two or more valid IRRs. The MIRR completely avoids this pitfall because it never solves a higher-degree polynomial—it computes a simple nth root.

SECTION 6

Worked Example

Consider a capital project with an initial investment of $100,000 and the following annual cash inflows over a four-year life: Year 1 = $30,000, Year 2 = $40,000, Year 3 = $35,000, Year 4 = $25,000. The firm's WACC is 10%, which we will use as both the reinvestment rate and the financing rate.

Computing the MIRR

1
Step 1 — Identify Given Values

Initial investment (CF₀) = −$100,000. Cash inflows: CF₁ = $30,000, CF₂ = $40,000, CF₃ = $35,000, CF₄ = $25,000. Reinvestment rate (r_r) = 10%. Financing rate (r_f) = 10%. Project life n = 4 years.

Only outflow occurs at t = 0, so PV(costs) = $100,000
2
Step 2 — Compute Terminal Value of Inflows

Compound each inflow forward to Year 4 at 10%: CF₁ × (1.10)³ = 30,000 × 1.331 = $39,930. CF₂ × (1.10)² = 40,000 × 1.21 = $48,400. CF₃ × (1.10)¹ = 35,000 × 1.10 = $38,500. CF₄ × (1.10)⁰ = 25,000 × 1.00 = $25,000.

TV = $39,930 + $48,400 + $38,500 + $25,000 = $151,830
3
Step 3 — Apply the MIRR Formula

MIRR = (TV / PV)^1/n − 1 = (151,830 / 100,000)^1/4 − 1 = (1.5183)^0.25 − 1

(1.5183)^0.25 = 1.1098, so MIRR = 1.1098 − 1 = 11.0%
4
Step 4 — Decision

Since the MIRR of 11.0% exceeds the firm's WACC of 10%, the project clears the return hurdle. This project would also yield a positive NPV, confirming that the MIRR and NPV rules are aligned for accept/reject decisions.

ACCEPT the project (MIRR 11.0% > WACC 10%)

SECTION 7

Strengths & Limitations

No single capital budgeting metric is without trade-offs, and the MIRR is no exception. While it corrects several well-documented flaws of the traditional IRR, it introduces its own set of considerations that financial managers should weigh when incorporating it into their decision frameworks.

Dimension	Strengths	Limitations
Reinvestment Assumption	Uses an explicit, realistic rate (e.g., WACC) rather than the project's own IRR	Requires the analyst to choose an appropriate reinvestment rate, introducing subjectivity
Uniqueness	Always yields a single, unambiguous return figure regardless of cash-flow patterns	The metric's value changes with different reinvestment/financing rate assumptions, so sensitivity analysis is prudent
NPV Consistency	Accept/reject decisions always agree with NPV when the reinvestment rate equals the discount rate	Ranking of mutually exclusive projects can still differ from NPV rankings when projects differ in scale or duration
Interpretability	Expressed as a percentage return, which managers and boards find intuitive	Less widely taught and recognized than IRR; some stakeholders may be unfamiliar with the metric
Computation	Straightforward algebra (no iterative root-finding required) and supported by Excel's MIRR() function	Still does not capture project risk, optionality, or the time value of strategic flexibility

Strengths and limitations of the MIRR as a capital budgeting metric

✦

KEY TAKEAWAY

The MIRR should be viewed as a complement to NPV, not a replacement. NPV remains the theoretically superior metric for value-maximizing decisions because it directly measures the dollar amount of wealth created. The MIRR's advantage lies in communicating returns in the percentage language that executives, board members, and investors instinctively understand. Best practice in corporate capital budgeting is to report both NPV and MIRR: NPV for the decision, MIRR for the conversation.

SECTION 8

Connection to Advanced Capital Budgeting Theory

The MIRR sits at the intersection of introductory return analysis and more sophisticated capital budgeting techniques. Understanding how it relates to advanced methods helps you appreciate both its utility and the contexts in which practitioners may reach for more powerful tools.

Feature	MIRR	Advanced Methods
Risk Handling	Risk is embedded in the discount/reinvestment rate selection; no explicit probability modeling	Monte Carlo simulation generates probability distributions of returns; Real Options Analysis prices managerial flexibility
Cash-Flow Timing	Assumes discrete annual cash flows; uses a single reinvestment rate across all periods	Stochastic models can accommodate varying reinvestment rates and continuous cash flows
Strategic Flexibility	No mechanism for valuing the option to expand, abandon, or defer a project	Real Options uses option-pricing theory (e.g., Black–Scholes) to quantify the value of managerial flexibility
Practical Adoption	Widely supported in spreadsheets and financial calculators; suitable for most standard projects	Requires specialized software and deeper quantitative expertise; reserved for large or complex capital decisions

MIRR versus advanced capital budgeting methods

For most corporate capital allocation decisions—equipment purchases, facility expansions, product launches—the MIRR combined with NPV analysis provides a well-grounded framework. When projects involve significant uncertainty, multi-stage decision gates, or strategic optionality (such as R&D pipelines in pharmaceuticals or staged development in real estate), firms often supplement MIRR and NPV with Real Options Analysis or Monte Carlo simulation. As you advance in corporate finance, you will find that these tools do not replace the MIRR but rather build on the same conceptual foundation of time value of money and explicit rate assumptions.

SECTION 9

Practice Problems

Question 1: CONCEPTUAL

Explain why the MIRR always produces a single, unique solution while the traditional IRR can produce multiple solutions for the same project. In your answer, reference the mathematical structure underlying each metric.

Show answer

The traditional IRR is found by solving the NPV equation set to zero, which is a polynomial of degree n (where n is the number of periods). By Descartes' rule of signs, this polynomial can have as many positive real roots as there are sign changes in the cash-flow sequence, so a project with two sign changes could yield two valid IRRs. The MIRR, by contrast, collapses all inflows into a single terminal value and all outflows into a single present value, then takes the nth root of their ratio. This nth-root operation always yields exactly one positive real number, eliminating the multiple-root problem entirely. The MIRR achieves this by separating the compounding and discounting steps from the rate-solving step.

Question 2: BASIC CALCULATION

A project costs $60,000 today and produces cash inflows of $20,000 per year for four years. Using a reinvestment rate and financing rate of 8%, compute the MIRR.

Show answer

Since the only outflow is at t = 0, PV(costs) = $60,000. Compute the terminal value by compounding each $20,000 inflow to Year 4 at 8%: TV = 20,000 × (1.08)³ + 20,000 × (1.08)² + 20,000 × (1.08)¹ + 20,000 × (1.08)⁰ = 25,194.24 + 23,328.00 + 21,600.00 + 20,000.00 = $90,122.24. Applying the MIRR formula: MIRR =

(90,122.24 / 60,000)^{1/4}

− 1 =

(1.50204)^{0.25}

− 1 ≈ 1.1071 − 1 = 10.71%. Since 10.71% > 8% WACC, the project should be accepted.

Question 3: INTERMEDIATE

Project Alpha requires an initial outlay of $200,000 and a maintenance expenditure of $30,000 at the end of Year 3. It generates cash inflows of $80,000 in Years 1 and 2, and $120,000 in Year 4. The reinvestment rate is 9% and the financing rate is 7%. Compute the MIRR.

Show answer

First, find PV(costs). The Year 0 outflow is $200,000 (already at present). The Year 3 outflow of $30,000 must be discounted at the financing rate: 30,000 / (1.07)³ = 30,000 / 1.22504 = $24,489.53. Thus PV(costs) = $200,000 + $24,489.53 = $224,489.53. Next, compute TV(inflows) at Year 4 using the reinvestment rate of 9%: CF₁ = 80,000 × (1.09)³ = 80,000 × 1.29503 = $103,602.40. CF₂ = 80,000 × (1.09)² = 80,000 × 1.1881 = $95,048.00. CF₄ = 120,000 × (1.09)⁰ = $120,000.00. TV = $103,602.40 + $95,048.00 + $120,000.00 = $318,650.40. MIRR =

(318,650.40 / 224,489.53)^{1/4}

− 1 =

(1.41941)^{0.25}

− 1 ≈ 1.0914 − 1 = 9.14%. Since the MIRR of 9.14% exceeds the WACC (whichever is applicable), the project creates value.

Question 4: APPLIED

Your firm is evaluating two mutually exclusive factory expansion projects. Project X: initial cost $500,000, annual inflows of $180,000 for 4 years. Project Y: initial cost $500,000, inflows of $50,000, $100,000, $200,000, and $350,000 in Years 1–4, respectively. WACC is 10% and is used as both the reinvestment and financing rate. Compute the MIRR for each project and discuss which project should be selected and whether MIRR alone is sufficient for the ranking.

Show answer

Project X: PV(costs) = $500,000. TV = 180,000 × (1.10)³ + 180,000 × (1.10)² + 180,000 × (1.10)¹ + 180,000 = 239,580 + 217,800 + 198,000 + 180,000 = $835,380. MIRR_X =

(835,380 / 500,000)^{0.25}

− 1 =

(1.67076)^{0.25}

− 1 ≈ 13.69%. Project Y: TV = 50,000 × (1.10)³ + 100,000 × (1.10)² + 200,000 × (1.10)¹ + 350,000 = 66,550 + 121,000 + 220,000 + 350,000 = $757,550. MIRR_Y =

(757,550 / 500,000)^{0.25}

− 1 =

(1.51510)^{0.25}

− 1 ≈ 10.93%. Project X has the higher MIRR (13.69% vs. 10.93%). However, since both projects have identical initial costs and lifespans, the MIRR ranking is likely consistent with NPV here. In general, when mutually exclusive projects differ in scale or duration, NPV should be the primary ranking criterion, with MIRR serving as a supplementary return-based check.

Question 5: CRITICAL THINKING

A colleague argues that setting the reinvestment rate equal to the WACC is always the correct assumption for MIRR calculations. Critically evaluate this position. Under what circumstances might a different reinvestment rate be more appropriate, and what are the implications for the MIRR's usefulness as a decision tool?

Show answer

Using WACC as the reinvestment rate is a reasonable default because it represents the firm's marginal opportunity cost of capital—interim cash flows can, in theory, be deployed into projects of average risk yielding the WACC. However, this assumption may not always hold. First, if the firm faces capital constraints, reinvested dollars may earn a return above WACC on the next best project (a higher marginal return). Second, in a low-yield environment where excess cash sits in money-market instruments, the effective reinvestment rate may be well below WACC. Third, divisional or project-specific risk differences suggest that a risk-adjusted reinvestment rate may be more accurate than a firm-wide WACC. The key implication is that the MIRR is only as good as the reinvestment and financing rate assumptions feeding it—garbage in, garbage out. Best practice is to conduct sensitivity analysis, computing the MIRR across a range of reinvestment rates, and to pair the MIRR with NPV analysis to ensure robust capital allocation decisions.

SUMMARY

Lesson Summary

Summary

The Modified Internal Rate of Return (MIRR) corrects two critical flaws of the traditional IRR: the unrealistic reinvestment-rate assumption and the multiple-IRR problem. It does so by compounding all positive cash inflows to a terminal value at a specified reinvestment rate and discounting all outflows to a present value of costs at a financing rate, then solving for the annualized growth rate between the two.

The decision rule is straightforward: accept a project if the MIRR exceeds the firm's cost of capital. For accept-or-reject decisions, MIRR always agrees with NPV when the reinvestment rate equals the discount rate. However, for ranking mutually exclusive projects that differ in scale or duration, NPV remains the gold standard. In practice, financial managers should report both NPV and MIRR: NPV drives the decision, while the MIRR communicates the project's return in the intuitive percentage format that stakeholders expect.