What the Modified Internal Rate of Return Measures
A standard internal rate of return calculator answers a narrow question: what discount rate makes the project's net present value zero? The number is useful, but it hides a demanding assumption. IRR treats every interim cash distribution as if it can be redeployed at that same eye-catching rate, so a project showing 22% behaves in the math as if each early payout also earns 22% somewhere else.
MIRR replaces that assumption with rates you can actually achieve. Positive flows compound forward at a reinvestment rate you set, negative flows discount at a finance rate you set, and the final figure is the single annual return connecting the two. Peter Kierulff described the measure in a 1981 Financial Management paper, and it has shipped as a standard Excel function since the early 1990s, which tells you how mainstream the correction became.
The output reads like any other annual return. An MIRR of 9.4% means the project's outlays, financed at your stated cost, grow into the compounded value of its inflows at exactly 9.4% per year over the project's life. That framing survives contact with finance committees far better than an IRR built on heroic reinvestment.
The MIRR Formula, Term by Term
The formula is MIRR = (FV of inflows / PV of outflows)^(1/n) - 1. The numerator compounds each annual inflow forward to the final year at the reinvestment rate r, so a cash flow arriving in year t grows by (1 + r)^(n - t). Summing those terminal values gives the future value the project hands you on its last day. A future value calculator demonstrates the same compounding step for a single lump sum.
The denominator discounts outflows back to year zero at the finance rate f. The initial investment sits at full value because it is spent on day one, while each year of operating cost divides by (1 + f)^t. Taking the nth root of the ratio converts the total growth multiple into an annual figure, and subtracting one leaves the rate itself.
Because every positive flow moves to one side of the timeline and every negative flow to the other, the equation always has exactly one solution. There is no hunt for multiple roots the way there can be with IRR on projects whose cash flows change sign more than once. The calculation is deterministic, which is exactly what you want in a spreadsheet heading to a board meeting.
Choosing the Reinvestment Rate and the Finance Rate
The reinvestment rate should describe where interim cash realistically lands. For most corporations that is the weighted average cost of capital, since returned cash either pays down debt or funds the next project at the firm's average return. Analysts at large US industrials commonly plug in 7% to 9%, regulated utilities sit near the bottom of that band, and venture-stage firms sit well above it.
The finance rate prices the money tied up in outflows. When a project is debt funded, use the loan's interest rate. When it draws on cash reserves, use the yield surrendered on that cash, such as the treasury or money market rate the balance was earning. This rate matters most for projects with heavy ongoing costs, because each additional year of outlay compounds the burden at f.
Getting the flows themselves right comes first, since a wrong input poisons both sides of the ratio. A cash flow calculator helps you lay out the annual inflows and outflows before committing them here. Investors who track distributions month by month should convert those figures to annual amounts so the end-of-year timing assumption stays honest.
Why IRR Overstates High Yield Projects
IRR's reinvestment assumption is harmless on modest projects and dangerous on spectacular ones. A strip mall returning 11% internally reinvests interim rent at a plausible 11%. A mining project showing a 35% IRR pretends early cash also finds 35% homes, and almost nothing in public markets pays that consistently. The gap between assumed and achievable reinvestment widens exactly when the headline number is most seductive.
Run a concrete comparison: a $100,000 equipment purchase that nets $35,000 a year for five years carries an IRR near 22.1%. Compounding those inflows at a realistic 10% reinvestment rate and discounting $5,000 of annual costs at an 8% finance rate produces an MIRR near 12.2%. Same project, same dollars, and nearly ten points of the advertised return evaporate once reinvestment faces reality.
Neither number is wrong; they answer different questions. IRR prices the project in isolation, while MIRR prices the project plus the world your cash returns to. When you report an annualized rate of return to outside investors, the MIRR framing is usually the more defensible one because its assumptions are printed on the label.
Reading the Result Against a Hurdle Rate
An MIRR only means something next to a benchmark. The usual benchmark is the hurdle rate: WACC plus a premium for project risk, often 3 to 5 percentage points. A 12% MIRR against a 9% hurdle clears the bar with room for estimate error, while the same 12% against an 11% hurdle on an unproven technology is a coin flip dressed up as a forecast.
Growth multiples put the rate in context. An MIRR of 12.2% over five years turns each dollar of outlay into about $1.77 of compounded inflow value, while 8% turns a dollar into $1.47. Small annual differences compound into different decisions, which is the entire discipline of capital budgeting in one sentence.
MIRR is mathematically a compound growth rate, so it compares cleanly with the figures you get from a CAGR calculator for portfolios and revenue lines. One caution applies: CAGR measures a market value path, while MIRR measures a cash flow structure with two different rates embedded, so treat the comparison as directional rather than exact.
Realistic Rate Benchmarks by Source
Reinvestment rates deserve research, not defaults picked from habit. Public companies disclose WACC estimates between roughly 6% and 9% across most industrial sectors. When interim cash sits in treasury bills or money market funds while awaiting redeployment, the current bill yield is the honest reinvestment number, and it moves with every rate cycle, so a figure locked in during a low-rate year can flatter today's project.
Compounding frequency adds a wrinkle worth settling early. This calculator applies annual compounding, which matches how most capital budgets are staged and how the underlying formula is written. If your institution compounds more often, a compound interest calculator shows the effective annual rate you should feed in so the two conventions stay consistent.
Finance rates are easier to source and easier to fudge. Use the marginal borrowing rate on the actual facility, with covenants and fees rolled into the APR, not the teaser rate on a term sheet. For cash funded projects the surrendered yield is the cost, and for mixed debt-plus-cash funding a weighted blend of the two tracks the truth closely enough for screening.
Using MIRR in the Capital Budgeting Process
MIRR earns its keep in comparison work: ranking projects of equal life and scale under one reinvestment policy. When a committee sees that Project A carries a 13.8% MIRR against Project B's 11.4% under identical rate assumptions, the ranking reflects operating quality rather than differing hidden assumptions. That consistency is the whole argument for standardizing on MIRR inside a portfolio review.
The measure slots in naturally beside return on investment math. An ROI calculator gives the simple multiple on committed capital, while MIRR annualizes the same story and prices the time value of money. Presenting both numbers together answers the two questions stakeholders ask first: how much did we make, and how fast did we make it.
NPV still outranks both in most corporate finance textbooks, and for good reason. NPV measures dollars of value created at a stated discount rate, which is what shareholders actually receive. The practical workflow is to screen with NPV, break ties and communicate with MIRR, and reserve IRR for conversations where the counterparty expects that specific figure.
Where MIRR Still Falls Short
MIRR does not cure every capital budgeting ailment. Two projects can post identical MIRRs while one creates ten times the dollar value, because a rate says nothing about scale. Projects of different lengths also resist direct comparison, since a 12% MIRR over three years and a 12% MIRR over nine years imply very different total wealth outcomes for the balance sheet.
The measure also inherits whatever your inputs encode. Optimistic inflow forecasts produce optimistic MIRRs with equal precision, and the formula has no opinion about the quality of your market research. Before trusting any single figure, run the project through a DCF calculator with conservative and aggressive cases so the decision rests on a range rather than a point estimate.
The two-rate structure invites gaming as well. Push the reinvestment rate up one point and a marginal project starts looking acceptable, which is why disciplined firms lock rate assumptions portfolio-wide before any individual proposal is scored. A rate policy written into the capital manual keeps every project champion honest and makes the MIRR column comparable across the whole pipeline.