The Modified Internal Rate of Return (MIRR) is a capital budgeting tool that addresses some of the significant limitations of the traditional Internal Rate of Return (IRR) method.
While both are used to evaluate the attractiveness of an investment, the MIRR provides a more realistic and often more accurate picture of a project’s profitability.
The Problem with Traditional IRR
The main flaw of the traditional IRR method is its reinvestment assumption. It implicitly assumes that any positive cash flows generated by a project are reinvested at the project’s own IRR.
This is often an unrealistic assumption because a company may not have new investment opportunities that offer the same high rate of return. A more realistic scenario is that these cash flows will be reinvested at a rate closer to the firm’s cost of capital.
Furthermore, for projects with unconventional cash flow patterns (e.g., alternating between positive and negative cash flows), the IRR calculation can yield multiple rates of return, leading to confusion and ambiguity.
How Modified Internal Rate of Return (MIRR) Works?
The MIRR overcomes these issues by using two separate, more realistic discount rates:
- Reinvestment Rate: This is the rate at which positive cash flows from the project can be reinvested. This rate is typically set at the company’s cost of capital or a more conservative rate that reflects available investment opportunities.
- Financing Rate: This is the cost of borrowing for the company, used to discount any negative cash flows back to the present.
The MIRR calculation essentially modifies the project’s cash flows to create a single initial investment and a single terminal value. The steps are:
- Calculate the present value of all negative cash flows (outflows) by discounting them to the present using the financing rate.
- Calculate the future value of all positive cash flows (inflows) by compounding them to the end of the project’s life using the reinvestment rate.
- Determine the MIRR. The MIRR is the discount rate that makes the present value of the negative cash flows equal to the future value of the positive cash flows.
MIRR Formula
The formula for MIRR is:
$$MIRR = \left(\frac{\text{Future Value of Positive Cash Flows}}{\text{Present Value of Negative Cash Flows}}\right)^{1/n} – 1$$Where:
- Future Value of Positive Cash Flows is the sum of all positive cash flows, each compounded forward to the end of the project at the reinvestment rate.
- Present Value of Negative Cash Flows is the sum of all negative cash flows, each discounted back to time zero at the financing rate.
- n is the number of periods.
Advantages of Modified Internal Rate of Return (MIRR)
- More Realistic Reinvestment Rate: It uses a more sensible reinvestment rate (such as the cost of capital) rather than the project’s own, often high, rate of return.
- Single Solution: Unlike IRR, MIRR always yields a single, unambiguous rate of return, even for projects with irregular cash flows.
- Consistent with NPV: The MIRR is generally more consistent with the Net Present Value (NPV) method, which is considered the gold standard in capital budgeting. Projects with a positive NPV will typically have a MIRR greater than the cost of capital.
- Easy to Understand: The result is still a percentage rate of return, making it easy for managers to compare it to the cost of capital and other projects.
MIRR vs. IRR
| Feature | Internal Rate of Return (IRR) | Modified Internal Rate of Return (MIRR) |
| Reinvestment Assumption | Assumes cash flows are reinvested at the project’s IRR. | Assumes cash flows are reinvested at a specified, more realistic rate (e.g., cost of capital). |
| Number of Solutions | Can yield multiple solutions for non-conventional cash flows. | Always produces a single, unique solution. |
| Accuracy | Can overstate a project’s profitability, especially with a high IRR. | Provides a more conservative and realistic measure of a project’s return. |
| Ease of Use | Simple to calculate with a financial calculator or spreadsheet. | Slightly more complex to calculate manually but is readily available in financial software. |
| Mutually Exclusive Projects | Can sometimes lead to incorrect decisions when comparing projects of different sizes. | Generally more reliable for comparing mutually exclusive projects, particularly in combination with NPV. |
In summary, while the IRR is a widely used and intuitive metric, the MIRR provides a more robust and theoretically sound evaluation of a project’s profitability by correcting the flawed reinvestment assumption and eliminating the multiple-solution problem. For these reasons, many financial professionals consider MIRR to be a superior tool for capital budgeting.