Last updated:
What the MIRR Calculator Fixes About Standard IRR
The MIRR calculator was designed to solve a well-known problem with the standard internal rate of return: its reinvestment-rate assumption. When a project produces positive cash flows in the middle of its life, operating income, interest payments, or rents, standard IRR implicitly assumes every one of those flows is reinvested at the project's own IRR until the final period. For a project earning a 30% IRR, this means every dollar of interim cash is assumed to earn 30% when reinvested. In most real capital markets, that assumption is far too optimistic. The modified internal rate of return calculator replaces this single implicit rate with two explicit inputs: a finance rate for negative cash flows and a reinvestment rate for positive cash flows. The resulting MIRR is a compound annual return that more honestly reflects what an investor can actually achieve given the realities of their capital costs and reinvestment opportunities.
According to Investopedia's explanation of MIRR, the modified internal rate of return is taught in most MBA and CFA curricula as the preferred percentage-return metric for projects where the IRR reinvestment assumption is implausible, typically any project with a double-digit or higher IRR. By requiring the user to explicitly choose a finance rate and a reinvestment rate, the MIRR calculator forces a more disciplined capital budgeting conversation and produces results that can be compared across projects with very different risk and return profiles.
How the MIRR Calculator Works: The Modified Internal Rate of Return Formula
The modified internal rate of return formula used in this MIRR calculator follows three sequential steps. In the first step, every positive cash flow in the series is compounded forward to the final period at the reinvestment rate, producing a single terminal future value of all inflows. In the second step, every negative cash flow, including the initial investment at period zero, is discounted back to the present at the finance rate, producing a single present value of all outflows. In the third step, MIRR is computed as the nth root of the ratio of the future value to the absolute present value of outflows, minus one, where n is the total number of periods.
MIRR = (FV of positive flows at reinvestment rate / |PV of negative flows at finance rate|)^(1/n) − 1
This structure guarantees exactly one MIRR solution for any cash flow series, regardless of the number of sign changes. The U.S. Securities and Exchange Commission's guidance on IRR notes that IRR-based metrics can produce misleading results for non-conventional cash flows, precisely the problem MIRR is designed to solve. The MIRR calculator on this page also computes the standard IRR for comparison, so you can see at a glance how much the reinvestment assumption is inflating or deflating the standard IRR result.
Finance Rate vs Reinvestment Rate: Setting the Right Inputs
Choosing the right finance rate and reinvestment rate is the most important decision when using the modified IRR calculator. The finance rate should equal the cost of the capital that funds project outflows. For a corporation, this is most commonly the weighted average cost of capital (WACC), the blended after-tax cost of debt and equity. For a real estate investor using a mortgage, the finance rate may be the mortgage interest rate. For a private equity fund raising capital from limited partners, the finance rate reflects the preferred return or fund hurdle rate. The core principle is that the finance rate represents what it actually costs to hold the negative cash flows, not an aspirational return target.
The reinvestment rate should reflect what you can realistically earn when you redeploy the positive cash flows generated by the project. Setting it equal to the finance rate is the most conservative and widely recommended approach. It implies that interim cash simply returns capital at the cost of capital rather than earning any excess return. If your firm has a backlog of value-creating projects, you can set the reinvestment rate higher to reflect the return on the next opportunity. For individual investors, the long-run expected return of a balanced portfolio, roughly 7 to 8 percent in historical terms, is a reasonable reinvestment rate. Our NPV calculator uses the same discount-rate concept and can help you calibrate the right rate for your specific situation.
When to Use MIRR: Capital Budgeting and Real-World Applications
The modified internal rate of return calculator is most valuable in three situations. First, when the standard IRR is high enough that the reinvestment assumption is implausible, typically above 15 to 20 percent. A corporate capital project with a reported 40% IRR may look far less attractive when the MIRR calculator is applied with a realistic 8% reinvestment rate, revealing that the actual compound return on capital over the project's life is closer to 15 to 18 percent. Second, when cash flows change sign more than once. Renovation projects, mine developments, and infrastructure deals often have large negative outflows in the middle of an otherwise positive cash flow series. Standard IRR can produce multiple valid answers in these cases, while the MIRR calculator always yields exactly one. Third, when comparing projects of different scale and duration on a percentage-return basis. Applying the same finance and reinvestment rates to all projects in a capital budget creates a level playing field that IRR alone cannot provide.
Real estate investors routinely use the MIRR calculator to stress-test reported IRRs from deal sponsors. A value-add apartment deal might show a 22% gross IRR in the sponsor's pro forma, but running the same cash flows through the MIRR calculator with an 8% reinvestment rate may produce an MIRR of 14 to 16 percent, still an attractive return, but a more honest representation of what the investor will actually compound. The Federal Reserve's interest rate data is a useful reference for calibrating the finance rate when the project is financed with variable-rate debt. Combine the MIRR calculator with our payback period calculator to get both a percentage return and a liquidity timeline for any capital project.
MIRR vs NPV: Which Metric Should Drive Your Decision?
The MIRR calculator and NPV calculator measure different dimensions of the same investment. NPV answers how many dollars of value the investment creates above the required return, expressed as an absolute dollar amount. MIRR answers what compound annual percentage return the investment earns, assuming the finance rate and reinvestment rate you specify. For a single accept-or-reject decision, both metrics usually agree: a positive NPV corresponds to a MIRR above the finance rate. The two metrics can diverge, however, when ranking mutually exclusive projects of different sizes. A small high-MIRR project may create less total wealth than a large lower-MIRR project, because MIRR ignores scale. In those cases, NPV is the authoritative ranking metric, always choose the project with the highest positive NPV, using the higher-MIRR figure as supplementary context.
Corporate finance textbooks and the CFA curriculum generally recommend using NPV as the primary capital budgeting decision rule, with MIRR serving as a cross-check and a communication tool. Percentage returns are more intuitive for many stakeholders than dollar-denominated NPVs, which is why MIRR remains valuable even when NPV is the official decision criterion. Explore the full suite of investing calculators on Quant Calculators, including the IRR calculator, NPV calculator, discounted cash flow calculator, and payback period calculator, to build a complete multi-metric view of any capital allocation decision.