Modified Internal Rate of Return (MIRR)

Introduction

When it comes to evaluating the profitability of an investment, there are several metrics that investors use. One such metric is the Modified Internal Rate of Return (MIRR). MIRR is a financial indicator that takes into account the time value of money and provides a more accurate measure of an investment's return. In this article, we will explore what MIRR is, how it is calculated, and why it is a valuable tool for investors.

What is Modified Internal Rate of Return (MIRR)?

MIRR is a financial metric that calculates the rate of return on an investment by considering both the cash inflows and outflows over the life of the investment. Unlike the traditional Internal Rate of Return (IRR), which assumes that cash flows are reinvested at the same rate, MIRR assumes that cash inflows are reinvested at a different rate and cash outflows are financed at a different rate.

The MIRR formula takes into account the initial investment, the cash inflows, the cash outflows, and the reinvestment rate. It calculates the rate at which the present value of the cash inflows equals the present value of the cash outflows, taking into account the different rates of reinvestment and financing.

How is MIRR Calculated?

The MIRR formula involves several steps:

  1. Calculate the future value (FV) of all cash inflows using the reinvestment rate.
  2. Calculate the future value (FV) of all cash outflows using the financing rate.
  3. Calculate the present value (PV) of the future value of cash inflows.
  4. Calculate the present value (PV) of the future value of cash outflows.
  5. Calculate the MIRR by finding the discount rate that equates the present value of cash inflows to the present value of cash outflows.

Here is the formula for calculating MIRR:

MIRR = (PV of Cash Inflows / PV of Cash Outflows)^(1/n) – 1

Where:

  • PV of Cash Inflows = Present value of the future value of cash inflows
  • PV of Cash Outflows = Present value of the future value of cash outflows
  • n = Number of periods

Why is MIRR a Valuable Tool for Investors?

MIRR offers several advantages over other financial metrics, making it a valuable tool for investors:

1. Considers the Time Value of Money

MIRR takes into account the time value of money by discounting the future cash flows to their present value. This is important because a dollar received in the future is worth less than a dollar received today due to inflation and the opportunity cost of capital. By considering the time value of money, MIRR provides a more accurate measure of an investment's return.

2. Considers Different Reinvestment and Financing Rates

Unlike the traditional IRR, which assumes that cash flows are reinvested at the same rate, MIRR allows for different rates of reinvestment and financing. This is more realistic as investors often reinvest their cash inflows at a different rate and finance their cash outflows at a different rate. By considering different rates, MIRR provides a more accurate measure of an investment's return.

3. Helps in Comparing Investments

MIRR allows investors to compare investments with different cash flow patterns and different rates of reinvestment and financing. By calculating the MIRR for each investment, investors can determine which investment offers the highest return, taking into account the time value of money and different rates of reinvestment and financing.

4. Provides a Clear Decision Rule

MIRR provides a clear decision rule for investors. If the MIRR is greater than the required rate of return, the investment is considered acceptable. If the MIRR is less than the required rate of return, the investment is considered unacceptable. This decision rule helps investors make informed decisions about whether to proceed with an investment or not.

Example of MIRR Calculation

Let's consider an example to illustrate how MIRR is calculated:

Suppose you are evaluating two investment opportunities: Investment A and Investment B. Investment A requires an initial investment of $10,000 and is expected to generate cash inflows of $3,000 per year for 5 years. Investment B requires an initial investment of $15,000 and is expected to generate cash inflows of $4,000 per year for 5 years. The reinvestment rate is 8% and the financing rate is 5%.

To calculate the MIRR for Investment A:

  1. Calculate the future value (FV) of all cash inflows using the reinvestment rate:

FV of Cash Inflows = $3,000 * (1 + 8%)^5 = $3,000 * 1.469 = $4,407

  1. Calculate the future value (FV) of all cash outflows using the financing rate:

FV of Cash Outflows = $10,000 * (1 + 5%)^5 = $10,000 * 1.276 = $12,760

  1. Calculate the present value (PV) of the future value of cash inflows:

PV of Cash Inflows = $4,407 / (1 + 5%)^5 = $4,407 / 1.276 = $3,450

  1. Calculate the present value (PV) of the future value of cash outflows:

PV of Cash Outflows = $10,000

  1. Calculate the MIRR by finding the discount rate that equates the present value of cash inflows to the present value of cash outflows:

MIRR = ($3,450 / $10,000)^(1/5) – 1 = 0.345 – 1 = -0.655

To calculate the MIRR for Investment B, follow the same steps:

FV of Cash Inflows = $4,000 * (1 + 8%)^5 = $4,000 * 1.469 = $5,876

FV of Cash Outflows = $15,000 * (1 + 5%)^5 = $15,000 * 1.276 = $19,140

PV of Cash Inflows = $5,876 / (1 + 5%)^5 = $5,876 / 1.276 = $4,600

PV of Cash Outflows = $15,000

MIRR = ($4,600 / $15,000)^(1/5) – 1 = 0.307 – 1 = -0.693

Based on the MIRR calculations, both investments have negative MIRR values, indicating that they do not meet the required rate of return. Therefore, neither investment would be considered acceptable.

Conclusion

Modified Internal Rate of Return (MIRR) is a valuable tool for investors to evaluate the profitability of an investment. By considering the time value of money and different rates of reinvestment and financing, MIRR provides a more accurate measure of an investment's return. It helps investors compare investments, make informed decisions, and determine whether an investment meets the required rate of return. By incorporating MIRR into their investment analysis, investors can make more informed and profitable investment decisions.

Leave a Reply