Modified Internal Rate of Return (MIRR)

Modified Internal Rate of Return (MIRR)

Adam Hayes, Ph.D., CFA, is a financial writer with 15+ years Wall Street experience as a derivatives trader. Besides his extensive derivative trading expertise, Adam is an expert in economics and behavioral finance. Adam received his master’s in economics from The New School for Social Research and his Ph.D. from the University of Wisconsin-Madison in sociology. He is a CFA charterholder as well as holding FINRA Series 7, 55 & 63 licenses. He currently researches and teaches economic sociology and the social studies of finance at the Hebrew University in Jerusalem.

David Kindness is a Certified Public Accountant (CPA) and an expert in the fields of financial accounting, corporate and individual tax planning and preparation, and investing and retirement planning. David has helped thousands of clients improve their accounting and financial systems, create budgets, and minimize their taxes.

Jiwon Ma is a fact checker and research analyst with a background in cybersecurity, international security, and technology and privacy policies. Before joining Dotdash, she consulted for a global financial institution on cybersecurity policies and conducted research as a Research Analyst at the Belfer Center for Science and International Affairs.

What Is Modified Internal Rate of Return (MIRR)?

The modified internal rate of return (MIRR) assumes that positive cash flows are reinvested at the firm’s cost of capital and that the initial outlays are financed at the firm’s financing cost. By contrast, the traditional internal rate of return (IRR) assumes the cash flows from a project are reinvested at the IRR itself. The MIRR, therefore, more accurately reflects the cost and profitability of a project.

Formula and Calculation of MIRR

Given the variables, the formula for MIRR is expressed as:

Meanwhile, the internal rate of return (IRR) is a discount rate that makes the net present value (NPV) of all cash flows from a particular project equal to zero. Both MIRR and IRR calculations rely on the formula for NPV.

Key Takeaways

  • MIRR improves on IRR by assuming that positive cash flows are reinvested at the firm’s cost of capital.
  • MIRR is used to rank investments or projects a firm or investor may undertake.
  • MIRR is designed to generate one solution, eliminating the issue of multiple IRRs.

Watch Now: What Is MIRR?

What MIRR Can Tell You

The MIRR is used to rank investments or projects of unequal size. The calculation is a solution to two major problems that exist with the popular IRR calculation. The first main problem with IRR is that multiple solutions can be found for the same project. The second problem is that the assumption that positive cash flows are reinvested at the IRR is considered impractical in practice. With the MIRR, only a single solution exists for a given project, and the reinvestment rate of positive cash flows is much more valid in practice.

The MIRR allows project managers to change the assumed rate of reinvested growth from stage to stage in a project. The most common method is to input the average estimated cost of capital, but there is flexibility to add any specific anticipated reinvestment rate.

The Difference Between MIRR and IRR

Even though the internal rate of return (IRR) metric is popular among business managers, it tends to overstate the profitability of a project and can lead to capital budgeting mistakes based on an overly optimistic estimate. The modified internal rate of return (MIRR) compensates for this flaw and gives managers more control over the assumed reinvestment rate from future cash flow.

An IRR calculation acts like an inverted compounding growth rate. It has to discount the growth from the initial investment in addition to reinvested cash flows. However, the IRR does not paint a realistic picture of how cash flows are actually pumped back into future projects.

Cash flows are often reinvested at the cost of capital, not at the same rate at which they were generated in the first place. IRR assumes that the growth rate remains constant from project to project. It is very easy to overstate potential future value with basic IRR figures.

Another major issue with IRR occurs when a project has different periods of positive and negative cash flows. In these cases, the IRR produces more than one number, causing uncertainty and confusion. MIRR solves this issue as well.

The Difference Between MIRR and FMRR

The financial management rate of return (FMRR) is a metric most often used to evaluate the performance of a real estate investment and pertains to a real estate investment trust (REIT). The modified internal rate of return (MIRR) improves on the standard internal rate of return (IRR) value by adjusting for differences in the assumed reinvestment rates of initial cash outlays and subsequent cash inflows. FMRR takes things a step further by specifying cash outflows and cash inflows at two different rates known as the “safe rate” and the “reinvestment rate.”

Safe rate assumes that funds required to cover negative cash flows are earning interest at a rate easily attainable and can be withdrawn when needed at a moment’s notice (i.e., within a day of account deposit). In this instance, a rate is “safe” because the funds are highly liquid and safely available with minimal risk when needed.

The reinvestment rate includes a rate to be received when positive cash flows are reinvested in a similar intermediate or long-term investment with comparable risk. The reinvestment rate is higher than the safe rate because it is not liquid (i.e., it pertains to another investment) and thus requires a higher-risk discount rate.

Limitations of Using MIRR

The first limitation of MIRR is that it requires you to compute an estimate of the cost of capital in order to make a decision, a calculation that can be subjective and vary depending on the assumptions made.

As with IRR, the MIRR can provide information that leads to sub-optimal decisions that do not maximize value when several investment options are being considered at once. MIRR does not actually quantify the various impacts of different investments in absolute terms; NPV often provides a more effective theoretical basis for selecting investments that are mutually exclusive. It may also fail to produce optimal results in the case of capital rationing.

MIRR can also be difficult to understand for people who do not have a financial background. Moreover, the theoretical basis for MIRR is also disputed among academics.

Example of How to Use MIRR

A basic IRR calculation is as follows. Assume that a two-year project with an initial outlay of $195 and a cost of capital of 12% will return $121 in the first year and $131 in the second year. To find the IRR of the project so that the net present value (NPV) = 0 when IRR = 18.66%:

To calculate the MIRR of the project, assume that the positive cash flows will be reinvested at the 12% cost of capital. Therefore, the future value of the positive cash flows when t = 2 is computed as:

Next, divide the future value of the cash flows by the present value of the initial outlay, which was $195, and find the geometric return for two periods. Finally, adjust this ratio for the time period using the formula for MIRR, given:

In this particular example, the IRR gives an overly optimistic picture of the potential of the project, while the MIRR gives a more realistic evaluation of the project.

Investopedia requires writers to use primary sources to support their work. These include white papers, government data, original reporting, and interviews with industry experts. We also reference original research from other reputable publishers where appropriate. You can learn more about the standards we follow in producing accurate, unbiased content in our editorial policy.

Financial Industry Regulatory Authority. “Regulatory Notice,” Page 6.

Kierulff, Herbert. “MIRR: A Better Measure.” Business Horizons, vol. 51, no 4, 2008, pp. 326-328.

New York University Stern School of Business. “Chapter 5: Measuring Return on Investments,” Pages 12-13.

New York University Stern School of Business. “Chapter 5: Measuring Return on Investments,” Page 67.

New York University Stern School of Business. “Chapter 5: Measuring Return on Investments,” Pages 62-63.

New York University Stern School of Business. “Chapter 5: Measuring Return on Investments,” Page 64.

Cary, David, and Dunn, Michael. “Adjustment of Modified Internal Rate of Return for Scale and Time Span Differences.” Allied Academics International Conference, vol. 2, no 2, 1997, pp. 57.

The offers that appear in this table are from partnerships from which Investopedia receives compensation. This compensation may impact how and where listings appear. Investopedia does not include all offers available in the marketplace.