MIRR Calculator - Modified Internal Rate of Return

The reinvestment rate assumption flaw

Traditional Internal Rate of Return (IRR) has a fundamental flaw: it mathematically assumes that all positive cash inflows generated by a project are immediately reinvested at the same high IRR rate. For example, if a project has an IRR of 55%, this implies the company can immediately reinvest intermediate cash flows to earn 55%. In reality, businesses typically reinvest at their standard cost of capital or standard market rates, making the regular IRR highly optimistic and misleading for decision-makers.

By utilizing the Modified Internal Rate of Return (MIRR), analysts can resolve this reinvestment rate anomaly. The MIRR allows you to input a separate reinvestment rate that reflects the actual rate the firm can earn on cash flows returned from the project. Typically, this reinvestment rate is equal to the firm's Weighted Average Cost of Capital (WACC), which represents a far more conservative and realistic assumption.

Elimination of multiple root anomalies

When projects have non-normal cash flows (meaning outflows occur both at the start and during later years of the timeline), standard IRR equations can produce multiple mathematical roots. This occurs because the equation is a polynomial of degree n, and sign changes in the cash flow sequence can yield multiple discount rates that drive the Net Present Value (NPV) to zero.

MIRR resolves this issue completely. It does so by converting all negative cash flows into a present value at Year 0 using the financing rate, and compounding all positive cash flows to a terminal value at Year n using the reinvestment rate. Since there is only one positive terminal value at Year n and one negative present value at Year 0, the equation is solved for a single, unique rate. This guarantees a safe and reliable calculation under any cash flow structure.

Reinvestment efficiency adjustments

By decoupling funding cost and reinvestment rate, MIRR becomes an excellent tool for project risk appraisal. For cash-constrained firms, the financing rate can be set high (reflecting high bank debt margins), while the reinvestment rate can be set lower (reflecting conservative liquid treasury yields). This dual-rate modeling provides a dynamic hurdle assessment that standard single-rate IRR can never match.

Input financing and reinvestment parameters

Begin by entering your cost of capital or financing rate. This represents the interest rate you pay on borrowed funds or the hurdle rate for capital investment outflows. After that, enter the reinvestment rate, which represents the interest rate you expect to earn when positive intermediate cash inflows are returned and put back into the corporate treasury.

Configuring these two rates is the core benefit of the MIRR solver, ensuring that financing costs and reinvestment yields are separately modeled according to your actual corporate policies.

Define cash flows timeline and run solver

List your cash flows year-by-year. Period 0 should reflect the initial cash outflow, which must be entered as a negative number. Add subsequent cash flows for each forecasted period. You can easily add new years or delete unnecessary rows using the interactive buttons on the left panel.

Once your flows are entered, click the "Run Solver" button. The results panel will immediately refresh to display the solved MIRR, standard IRR, NPV, and a sensitivity matrix plotting varying rates.

Compare results and options

After executing the solver, inspect the "Allocation Summary" to review the solved rate. Navigate to the "Greedy Comparison" or "Sensitivity Grid" to see how the MIRR shifts under different reinvestment rate scenarios (typically +/- 2%). You can also save multiple scenario runs to compare portfolio yields across different macro cost structures.

Base scenario modeling

The base scenario represents your expected operating parameters. The cash flows are modeled under moderate sales assumptions, and the discount/reinvestment rates reflect the company's current WACC. This serves as the primary benchmark for investment screening.

Bull (upside) scenario testing

The bull scenario models upside operational performance. It assumes faster product adoption, higher revenues, and lower working capital requirements, yielding larger cash inflows. Additionally, reinvestment rates might be adjusted higher to reflect optimistic market yields.

Bear (downside) scenario testing

The bear scenario tests downside resiliency. It assumes reduced market demand, high inflation on operational costs, and delays in product launch. Financing rates are often adjusted higher in the bear scenario to model increased borrowing costs during credit crunches.

Reinvestment rate vs financing rate matrix

The sensitivity grid maps the solved MIRR against shifting reinvestment rates (horizontal) and financing rates (vertical). This grid is vital for financial planning because it highlights how sensitive the project's yield is to macroeconomic interest rate adjustments.

Identifying hurdle crossover boundaries

By observing the cell colors in the sensitivity matrix, you can instantly identify where the MIRR falls below the corporate hurdle rate. This boundary helps project sponsors determine the exact borrowing cost limit the project can support before becoming value-destructive.

Impairment risk mitigation

If a project's MIRR remains stable even when the reinvestment rate drops by 3%, the project is deemed robust. If a slight rate shift triggers a massive decline in yield, the project carries high financial risk, requiring a larger safety margin.

Project cash flows and rates

Let's consider an investment with a 4-year life. The initial cost at Year 0 is -$1,000. The subsequent annual inflows are: Year 1 = $300, Year 2 = $400, Year 3 = $400, and Year 4 = $450. The finance rate is set at 8%, and the reinvestment rate is set at 10%.

We will calculate the present value of outflows and the future value of inflows to solve for MIRR.

Solving step-by-step

The only outflow occurs at Year 0, so the PV of Outflows is exactly -$1,000.

Next, we compound the inflows to Year 4 at the 10% reinvestment rate:
- Year 1 flow ($300) compounded for 3 years: $300 * (1.10)^3 = $399.30
- Year 2 flow ($400) compounded for 2 years: $400 * (1.10)^2 = $484.00
- Year 3 flow ($400) compounded for 1 year: $400 * (1.10)^1 = $440.00
- Year 4 flow ($450) at Year 4: $450.00
Total Future Value of Inflows = $399.30 + $484.00 + $440.00 + $450.00 = $1,773.30.

Using the formula: MIRR = ($1,773.30 / $1,000)^(1/4) - 1 = (1.7733)^0.25 - 1 = 15.40%. The traditional IRR for this same project is 19.53%. The MIRR provides a more conservative estimate because it assumes inflows are reinvested at 10% rather than 19.53%.