Finance

Modified Internal Rate of Return (MIRR) Calculator

Find MIRR using an explicit reinvestment rate instead of IRR's implicit assumption.


Modified Internal Rate of Return (MIRR) Calculator

Advertisement

Standard IRR implicitly assumes every interim cash flow gets reinvested at the IRR itself — often an unrealistically high rate. MIRR fixes that by using an explicit, separate reinvestment rate.

How it works

Every positive cash flow is compounded forward to the final year at the stated reinvestment rate, summed into one future value; the geometric-mean rate that grows the initial investment to that future value over the number of periods is the MIRR.

What this does not include

This does not include a separate finance rate for discounting interim negative cash flows (some MIRR variants use one) — this calculator handles the common case of a single upfront investment followed only by positive inflows.

How to use this calculator

  1. Enter the initial investment, yearly cash flows, and a reinvestment rate.

Frequently asked questions

Why is MIRR usually lower than IRR for the same cash flows?

Because IRR implicitly assumes reinvestment at its own (often high) rate, while MIRR uses a more conservative, realistic reinvestment rate — the gap between the two grows as the true reinvestment opportunity gets further from the calculated IRR.

Does MIRR solve IRR’s multiple-solutions problem?

Yes — because MIRR is solved with a direct closed-form formula rather than searching for where NPV crosses zero, it always produces exactly one unique answer, unlike IRR for unusual cash flow patterns.

Which one should I actually use for decision-making?

Many finance practitioners consider MIRR the more realistic figure specifically because of its reinvestment assumption, though IRR remains far more commonly cited and quoted in practice.

Important: This is general information, not financial advice. Figures are estimates, and your lender or provider decides the real numbers. Check with a qualified adviser before acting on them.

Be the first to rate this

Written by

M. Whitfield

Personal finance writer

M. Whitfield writes the personal finance calculators, covering loans, mortgages, savings, tax and investment maths. The focus is on showing exactly which number goes into a formula and which assumptions a result depends on, so readers can tell when a figure applies to their situation and when it does not. Every finance page states what it does not account for as plainly as what it does.

Reviewed by

A. Whitfield-Reyes

Calculator reviewer — finance

A. Whitfield-Reyes reviews the finance calculators, checking compounding conventions, rate-period alignment, and whether each page is explicit about the costs and tax treatment it leaves out. Financial results are easy to state with false precision, so review focuses on whether the page makes its assumptions visible to a reader who is not looking for them.

How we write and review

Related calculators