Modified Internal Rate of Return (MIRR) Calculator Online

Free MIRR Calculator — Calculate Modified Internal Rate of Return Accurately

IRR has one flaw that financial analysts have known about for decades: it assumes every dollar of cash flow generated by an investment gets reinvested at the IRR itself. That assumption is fine when the IRR is modest. At 25% or 30%, it becomes unrealistic — and the IRR figure starts to overstate the true expected return by a meaningful margin. MIRR fixes that. The Modified Internal Rate of Return separates the financing cost from the reinvestment rate, plugging in real-world rates for both rather than recycling the IRR assumption. Bluxe’s free MIRR calculator handles the full computation — enter your finance rate, reinvestment rate, and cash flows, and you get a more conservative, more accurate picture of what an investment genuinely returns. No sign-up required.

What Is the Modified Internal Rate of Return?

MIRR is a refined version of IRR that addresses two structural weaknesses in the standard calculation. First, it replaces the IRR’s implicit reinvestment assumption with an explicit reinvestment rate you supply — typically reflecting what interim cash flows can realistically earn when redeployed. Second, it discounts negative mid-period cash flows at the finance rate — the cost of borrowing or the cost of capital — rather than at the IRR itself.

The result is a single annual return percentage that’s grounded in achievable rates rather than the circular logic of the standard IRR. For most practical investments, MIRR will be lower than IRR — sometimes only marginally, sometimes by several percentage points. That gap represents the correction for over-optimistic reinvestment assumptions, and it’s the gap that matters most when comparing high-IRR projects against realistic alternatives.

How Does This Calculator Work?

The MIRR formula has two components: a terminal value of positive cash flows compounded forward at the reinvestment rate, and a present value of negative cash flows discounted back at the finance rate. These two values are then used to derive a single equivalent annual return.

The Formula

MIRR = [(FV of Positive Cash Flows / PV of Negative Cash Flows)^(1/n) − 1] × 100

Where:

• FV of Positive Cash Flows = Each positive cash flow compounded forward to period n at the reinvestment rate
• PV of Negative Cash Flows = Each negative cash flow (including the initial investment) discounted back to period 0 at the finance rate
• n = Total number of periods

Step-by-Step Breakdown

Step 1 — Compound positive cash flows forward:

Each positive cash flow in period t is compounded to the final period n using the reinvestment rate:

FV contribution = CF_t × (1 + reinvestment rate)^(n − t)

Sum all these to get the total Terminal Value (TV).

Step 2 — Discount negative cash flows back:

Each negative cash flow in period t (including period 0) is discounted to the present using the finance rate:

PV contribution = |CF_t| / (1 + finance rate)^t

Sum all these to get the total Present Value of costs (PVC).

Step 3 — Combine:

MIRR = (TV / PVC)^(1/n) − 1

Worked Example

Initial investment: −$10,000 | Cash flows: Year 1: $3,000 | Year 2: $4,000 | Year 3: $4,500 | Year 4: $3,500 Finance rate: 8% | Reinvestment rate: 6% | n = 4 years

Step 1 — Terminal Value of positive cash flows at 6%:

Year 1: $3,000 × (1.06)^3 = $3,573.05 Year 2: $4,000 × (1.06)^2 = $4,494.40 Year 3: $4,500 × (1.06)^1 = $4,770.00 Year 4: $3,500 × (1.06)^0 = $3,500.00

TV = $16,337.45

Step 2 — Present Value of negative cash flows at 8%:

Year 0: $10,000 / (1.08)^0 = $10,000.00

PVC = $10,000.00

Step 3 — MIRR:

MIRR = ($16,337.45 / $10,000.00)^(1/4) − 1 = (1.6337)^0.25 − 1 = 1.1306 − 1 = 13.06%

For comparison, the standard IRR on this same cash flow sequence is approximately 16.2%. The 3.14 percentage point gap is the reinvestment correction — a concrete illustration of why MIRR matters when the IRR figure is elevated.

MIRR vs. IRR Reference Table

The fourth row is the most instructive: a small, high-return project with an IRR of 22.18% corrects down to 15.67% under MIRR — a 6.5 percentage point gap driven entirely by replacing the IRR’s implicit 22.18% reinvestment assumption with a realistic 5%. The higher the IRR, the larger the MIRR correction tends to be.

How to Use the Calculator on Bluxe

1. Open the free MIRR calculator on Bluxe — no account, no login, and no restriction on the number of cash flow periods you model.
2. Select the compounding frequency — annual for most project evaluations, quarterly or monthly for investments with more frequent cash flows such as rental income or recurring contract payments.
3. Enter the finance rate — the annual cost of capital or borrowing cost applicable to the investment; this is used to discount negative mid-period cash flows back to the present.
4. Input the reinvestment rate — the annual rate at which positive cash flows can realistically be reinvested; a conservative choice is the risk-free rate or the return on a comparable low-risk instrument.
5. Enter the initial investment as a negative number, followed by each period’s cash flow — positive for inflows, negative for additional capital outlays.
6. Click Calculate MIRR — the result appears immediately as an annual percentage to four decimal places.

Practical tip: when unsure what reinvestment rate to use, start with the prevailing rate on a short-duration government bond or a high-quality fixed deposit — these reflect the realistic opportunity cost of parking interim cash flows conservatively. Avoid using an aspirational reinvestment rate that assumes future cash flows can be redeployed at the same return as the project itself.

Understanding Your Results

The MIRR output is a single annual percentage — the true compounded return on the investment after applying realistic rates to both the financing and reinvestment sides. Compare it against your required rate of return or cost of capital using the same decision logic as IRR: MIRR above the hurdle rate indicates the investment creates value; below it indicates value destruction.

MIRR Decision and Context Guide

The last row deserves emphasis. When MIRR is substantially lower than IRR on the same cash flows, it’s a signal that the IRR figure was being driven by an unrealistic reinvestment assumption — and that decisions made on the basis of that IRR alone would have accepted a worse-than-expected investment.

Why This Matters

MIRR has gained traction in recent years as financial literacy has improved among investors evaluating private deals, infrastructure projects, and alternative assets where interim cash flows are significant and the reinvestment rate matters. A private lending arrangement returning 20% IRR sounds compelling — but if those monthly repayments can only be redeployed at 7% or 8%, the true compounded return is considerably lower. MIRR makes that correction explicit and quantified rather than leaving it as an unstated assumption buried in the methodology.

There’s also a practical advantage in the MIRR’s uniqueness. Because it doesn’t rely on the iterative IRR-solving process, it always produces exactly one answer — unlike IRR, which can produce multiple solutions when cash flows change sign more than once. Projects with mid-life capital injections, decommissioning costs, or clean-up expenses in later periods are better suited to MIRR analysis precisely because those sign changes don’t create computational ambiguity.

Practical Tips

Set the reinvestment rate conservatively, not optimistically The whole point of MIRR is to replace an unrealistic reinvestment assumption with a realistic one. Using a reinvestment rate close to the project’s own IRR defeats that purpose and produces a MIRR figure nearly identical to the IRR. A rate anchored to the risk-free rate, a fixed deposit return, or a short-duration bond yield gives the most defensible result.

Use the finance rate to reflect your actual funding cost If the investment is funded partly by debt, the finance rate should reflect the blended cost of that debt — not a theoretical WACC that includes equity. If the capital comes entirely from retained earnings, the finance rate is the opportunity cost of those funds, which is typically the expected return on the next-best available investment.

Run MIRR and IRR together, then examine the gap The difference between IRR and MIRR is itself informative. A small gap — less than 1 or 2 percentage points — suggests the IRR’s reinvestment assumption was already close to realistic. A large gap — 5 points or more — means the IRR figure was significantly inflated by an aggressive implicit assumption. Consistently large gaps across a portfolio of projects should prompt a reassessment of how IRR-based decisions have been made historically.

Account for compounding frequency on shorter-interval cash flows For investments generating monthly or quarterly cash flows — rental income, loan repayments, recurring contract revenue — switching the compounding frequency to monthly or quarterly in the calculator produces a more accurate MIRR than the default annual setting. The difference may be small but is worth capturing on longer-duration, higher-value investments.

Who Should Use This Calculator?

MIRR is most valuable when IRR analysis is already being used but its reinvestment assumption is a known concern:

• Private equity and venture capital analysts assessing portfolio company investments where interim distributions can only realistically be redeployed at market rates — not at the fund’s own target IRR
• Corporate finance teams evaluating capital expenditure proposals where a more conservative and auditor-defensible return metric is preferred over standard IRR
• Real estate investors modelling rental property returns where monthly rental income is a significant cash flow component and reinvestment assumptions meaningfully affect the headline return figure
• Project finance teams assessing infrastructure or energy projects with mid-life capital requirements or decommissioning costs that create multiple sign changes in the cash flow sequence
• Sophisticated individual investors comparing two high-IRR private opportunities who want to level the comparison by correcting for differing reinvestment conditions

If you found this helpful, you might also want to try Bluxe’s [IRR Calculator] to calculate the standard internal rate of return on the same cash flows — then compare the two figures to see exactly how much the reinvestment assumption was affecting the result.

A Note Before You Go

MIRR is a more realistic metric than IRR for most real-world investments — but it’s still only as reliable as the cash flow projections and rate assumptions feeding into it. The finance and reinvestment rates you choose introduce judgment into the calculation, and different analysts may reach different MIRR figures on identical cash flows by choosing different input rates. Use this calculator to generate a well-reasoned, assumption-transparent return estimate — and for significant capital decisions, have both the cash flow projections and the rate assumptions reviewed by a qualified financial professional.