The modified internal rate of return (MIRR) is a capital-budgeting metric that recalculates a project’s annual return by compounding its positive cash flows forward at a realistic reinvestment rate and discounting its negative cash flows back at a financing rate. The formula is compact: MIRR equals the nth root of the terminal value of positive cash flows divided by the present value of costs, minus one. That single adjustment fixes two well-known weaknesses in the traditional internal rate of return (IRR) and produces a percentage closer to what a company will actually earn.
Why MIRR Exists
Standard IRR finds the discount rate that drives a project’s net present value to zero. Buried in that math is an assumption that every dollar the project throws off gets reinvested at the IRR itself. If a project’s IRR is 35%, the model treats every interim cash flow as though it immediately earns 35% elsewhere in the firm. In reality, corporate treasury departments park surplus cash in money-market accounts, short-term bonds, or existing operations. A secondary investment paying 35% is unlikely for most companies.
MIRR breaks that circular logic by letting you specify a reinvestment rate that reflects where the money actually goes. Most analysts set this rate equal to the company’s weighted average cost of capital (WACC), which blends the cost of debt and equity into one figure.1Xavier University Exhibit. MIRR: The Means to an End? Reinforcing Optimal Investment Decisions Using the NPV Rule By compounding positive cash flows forward at that more conservative rate, the terminal value represents wealth the firm can realistically accumulate rather than a theoretical ceiling. The gap matters most for projects with high early yields or erratic cash flow timing, where IRR tends to overstate returns.
IRR has a second, less intuitive flaw. When a project’s cash flows change sign more than once, say a large upfront cost followed by positive returns and then a major decommissioning expense, the IRR equation can yield two or more mathematically valid answers. An analyst staring at two different IRRs for the same project has no reliable way to pick the right one. MIRR sidesteps the issue entirely because it collapses all negative cash flows into a single present value and all positive cash flows into a single future value, leaving one ratio and one root to take. The output is always a single, unambiguous rate.2ACCA Global. Modified Internal Rate of Return For mining operations with reclamation costs, real estate developments with periodic capital calls, or any venture that alternates between spending and earning, that clarity alone is reason enough to prefer MIRR.
Inputs You Need Before Calculating
MIRR requires five pieces of information. Getting any one of them wrong will throw off the result.
- Initial investment, entered as a negative number. Any later capital injections are also negative cash flows.
- Periodic cash flows for each subsequent period, calculated as projected revenue minus operating expenses and taxes. Positive periods are inflows; negative periods are additional costs.
- Reinvestment rate, the rate at which positive cash flows are assumed to grow once they leave the project. WACC is the most common choice, though some analysts use a risk-free rate or a rate tied to the firm’s typical reinvestment opportunities.
- Finance rate, the rate the company pays to fund negative cash flows. This often reflects the firm’s borrowing cost, such as the interest rate on its credit facility or the yield on its corporate bonds.
- Number of periods, the total duration from the first expenditure to the final cash receipt, measured in whatever time unit matches your cash flow data (usually years).
The reinvestment rate and finance rate can be the same number. Setting both to WACC is defensible and simplifies the analysis. Separating them lets you model reality more precisely when borrowing cost differs meaningfully from the return on reinvested cash.
The MIRR Formula
The formula has three moving parts, and each one does a specific job:
MIRR = (Terminal Value of Positive Cash Flows ÷ Present Value of Negative Cash Flows)1/n − 1
The terminal value is built by compounding every positive cash flow forward to the end of the project at the reinvestment rate.3Oxford University Press. Modified Internal Rate of Return A cash inflow received in year one of a five-year project gets compounded for four remaining years. An inflow in year three gets compounded for two. An inflow in the final year sits at face value. Adding all those compounded amounts together produces the terminal value, meaning the total pile of money the project’s proceeds will have grown into by the end.
The present value of costs works in the opposite direction. Every negative cash flow is discounted back to the start date at the finance rate. If the only negative cash flow is the initial outlay at year zero, no discounting is needed. If additional costs arise later, such as equipment replacements or cleanup obligations, those get discounted back. The sum represents the total economic cost of the project measured today.
Dividing terminal value by present-value cost, raising the result to the power of 1/n, and subtracting one converts the ratio into an annualized percentage.2ACCA Global. Modified Internal Rate of Return That percentage is the single compound annual growth rate that would turn the present value of costs into the terminal value over the life of the project.
A Worked Example
Suppose your firm evaluates a three-year project with a $10,000 upfront cost. It generates $4,000 in year one, $5,000 in year two, and $6,000 in year three. The finance rate is 8%, and the reinvestment rate is 10%.
Step 1 — Present value of costs. The only negative cash flow is the $10,000 initial outlay, already at time zero. No discounting required. Present value of costs = $10,000.
Step 2 — Terminal value of positive cash flows. Compound each inflow forward to the end of year three at 10%:
- Year 1: $4,000 × (1.10)2 = $4,840
- Year 2: $5,000 × (1.10)1 = $5,500
- Year 3: $6,000 × (1.10)0 = $6,000
Terminal value = $4,840 + $5,500 + $6,000 = $16,340.
Step 3 — Apply the formula. MIRR = ($16,340 ÷ $10,000)1/3 − 1 = (1.634)0.3333 − 1 ≈ 0.178, or about 17.8%.
That 17.8% is the compound annual return the project delivers when you assume reinvested cash earns 10%. If the firm’s hurdle rate is 12%, this project clears it comfortably. If the hurdle rate were 20%, it would not make the cut.
Using MIRR in a Spreadsheet
Microsoft Excel and Google Sheets both have a built-in MIRR function that handles the compounding and discounting automatically. The syntax is identical:4Microsoft Support. MIRR Function
=MIRR(values, finance_rate, reinvest_rate)
The values argument is a range of cells containing the cash flows in chronological order, with the initial investment entered as a negative number. The range must include at least one negative value and one positive value. The finance rate and reinvestment rate are entered as decimals, so 8% becomes 0.08.
For the worked example, enter -10000 in cell B2, then 4000, 5000, and 6000 in B3 through B5. The formula =MIRR(B2:B5, 0.08, 0.10) returns about 17.8%. One common mistake is entering rates as whole numbers rather than decimals, which produces nonsense. Another is leaving a gap in the cash flow range or entering flows out of order; the function reads cells sequentially and assumes each cell represents the next period.
When a Project Passes or Fails
The decision rule is simple. If MIRR exceeds the firm’s hurdle rate, the project adds value. If it falls below, the project destroys it. Most companies set the hurdle at or near WACC, so the comparison is essentially asking whether the project earns more than the blended cost of the capital it consumes.5Journal of Economics and Finance Education. Teaching MIRR to Improve Comprehension of Investment Performance Evaluation Techniques
When ranking competing projects, a higher MIRR generally indicates more efficient use of capital. The comparison works cleanly only when the projects require similar initial investments and run for similar durations. For projects of the same scale and lifespan, MIRR rankings align with net present value (NPV) rankings.6Stern School of Business, New York University. Chapter 6: Project Interactions, Side Costs, and Side Benefits When scale or duration differs, the two metrics can point in different directions.
MIRR vs. NPV
NPV and MIRR answer different questions. NPV tells you the total dollar value a project creates above the cost of capital. MIRR tells you the annualized percentage return after adjusting for realistic reinvestment. A project with a higher NPV creates more wealth in absolute terms; a project with a higher MIRR is more efficient per dollar invested.
Set MIRR’s reinvestment rate equal to the discount rate used in the NPV calculation, and the two methods will agree on which projects to accept or reject.7University of Richmond Scholarship Repository. Visual Presentation of MIRR and MNPV Calculations Conflicts emerge when comparing projects of different sizes. A small project might earn a 25% MIRR while a large project earns 18%, but the large project generates far more total value. NPV captures that difference; MIRR does not. Financial theory holds that NPV should take priority when the two disagree, because maximizing shareholder wealth means maximizing total dollars earned rather than percentage return.1Xavier University Exhibit. MIRR: The Means to an End? Reinforcing Optimal Investment Decisions Using the NPV Rule Many firms still lean on rate-of-return metrics because percentages are easier to communicate. MIRR serves that role while incorporating more realistic assumptions than IRR.
Limitations
MIRR fixes real problems and introduces smaller ones. The most significant is that the reinvestment rate and finance rate are judgment calls. Two analysts evaluating the same project can arrive at different MIRRs by choosing different rates. If one uses 6% and another uses 10%, their conclusions about project viability may diverge. That subjectivity is absent from standard IRR, where the math produces a single answer regardless of assumptions.
MIRR also cannot account for differences in project scale. When two mutually exclusive projects require different initial capital, MIRR may rank the smaller one higher even though the larger one generates more total wealth. In those situations, NPV or an adjusted MIRR approach is necessary.5Journal of Economics and Finance Education. Teaching MIRR to Improve Comprehension of Investment Performance Evaluation Techniques Projects with different lifespans pose a similar challenge. Comparing a three-year project’s MIRR to a ten-year project’s MIRR is not an apples-to-apples comparison, and techniques like equivalent annuities or project replication are better suited.6Stern School of Business, New York University. Chapter 6: Project Interactions, Side Costs, and Side Benefits
MIRR is also less widely recognized than IRR. Presenting a MIRR figure in a boardroom or to an outside lender often requires explaining what it is and why it differs from the IRR they are used to seeing. That extra explanation is not a mathematical limitation, but it is a practical one.