MIRR

by / ⠀ / March 22, 2024

Definition

Modified Internal Rate of Return (MIRR) is a financial measure that helps investors or companies understand the attractiveness of a project or investment. It accounts for the time value of money and the cost of capital, giving a more balanced outlook to the potential profitability of an investment. Unlike the standard IRR, MIRR provides decision-makers with a more accurate estimate of an investment’s return rate while taking compounding and investment costs into consideration.

Key Takeaways

  1. MIRR, or Modified Internal Rate of Return, is a financial measure that provides a more accurate projection of the potential profitability of an investment than the regular Internal Rate of Return (IRR).
  2. MIRR considers not only the cash flow from the project but also the interest earned on reinvestment of cash and cost of capital, making it a more comprehensive representation of a project’s potential return.
  3. MIRR is particularly useful for comparing and ranking projects of varying sizes and lengths, helping investors make more informed decisions about which projects to invest in for optimal returns.

Importance

The Modified Internal Rate of Return (MIRR) is a vital financial metric that businesses use to assess the profitability and attractiveness of an investment or project.

Compared to the traditional Internal Rate of Return (IRR), MIRR offers a more accurate reflection of an investment’s potential for long-term growth as it assumes that positive cash flows are reinvested at the project’s cost of capital and the initial outlays are financed at the firm’s financing cost.

This technique also mitigates the multiple IRR problem in capital budgeting.

Therefore, it provides investors with a more comprehensive view of the viability and value of a proposed project, making it a crucial tool in business decision-making.

Explanation

The Modified Internal Rate of Return, or MIRR, is a financial measure that organizations utilize to assess the profitability and efficiency of their investments and potential projects. Its main purpose is to provide a more accurate reflection of the investment’s profitability by factoring in certain realities such as the cost of capital and reinvestment rate, which can affect the overall return.

By incorporating these realistic aspects of investment, MIRR prevents the overestimation of annual returns, thus offering a more balanced assessment of an investment’s feasibility and potential financial success. MIRR is often used for capital budgeting decisions, where businesses need to evaluate numerous potential investments or projects.

It serves as a crucial tool to determine which investment offers the highest rate of return or which is the best use of firm’s assets in relation to others. In this context, higher MIRR value indicates a better project or investment to undertake.

It also plays a significant role in comparing projects of unequal size, risk, timing, and different reinvestment assumptions, thereby promoting wise investment decisions and increasing the likelihood of organizational financial stability and growth.

Examples of MIRR

Business Investment: Consider a small business owner who invests $50,000 in a new product line, with expected future cash flows of $30,000, $20,000, and $10,000 over the next three years. The business owner can reinvest these cash flows into a savings account with the annual interest rate of 5%. By calculating MIRR, the owner can find an accurate rate of return, which can help them compare it with other possible investment opportunities.

Real Estate: A real estate investor purchases a property for $200,000 and expects to generate rental revenue of $40,000, $50,000, and $60,000 over the next three years, after which they plan to sell the property for $250,

They expect that any cash inflow will be reinvested in other properties at an 8% return. The MIRR will help the investor to get a more precise estimate of the IRR and better evaluate the profitability of the investment.

Mutual Funds: An investor places $10,000 in a mutual fund that promises returns of $2,500, $3,000, and $3,500 over three years, and the investor can reinvest the returns at a rate of 6% in another fixed deposit scheme. Using MIRR, the investor can get a better idea of the accurate return rate on their investment, consequently assessing whether this investment is more viable compared to other options.

Frequently Asked Questions about MIRR

What is MIRR in finance?

MIRR stands for Modified Internal Rate of Return. It’s a financial measure that is used as an indicator of the profitability potential of investments. Unlike regular IRR, MIRR takes into consideration reinvestment risk and assumes that positive cash flows are reinvested at the firm’s cost of capital and initial outlays are financed at the firm’s financing cost.

How is MIRR calculated?

MIRR is computed using three inputs: the finance rate (the cost of capital), the reinvestment rate (the rate of return on the reinvestment of cash flows), and the series of cash flows that occur at regular intervals. The formula for MIRR is somewhat complex, but it is generally calculated with a financial calculator or software.

What is the difference between IRR and MIRR?

The main difference between IRR (Internal Rate of Return) and MIRR is that IRR assumes cash flows generated by an investment are reinvested at the IRR itself, nonetheless, the MIRR assumes reinvestment at the project’s cost of capital. This makes the MIRR a more realistic reflection of the investment’s profitability when the reinvestment rate is different from the project rate.

When should you use MIRR instead of IRR?

MIRR should be used instead of IRR when the assumption of reinvesting future cash flows at the IRR itself doesn’t seem logical or when a project generates substantial cash flows before it is completed. In these cases, MIRR can provide a more accurate calculation and reflection of the eventual profitability of the investment.

Related Entrepreneurship Terms

  • Discount Rate: This is the rate used to calculate the present value of future cash flow in the calculation of MIRR (Modified Internal Rate of Return).
  • Finance Rate: Finance rate, or cost of borrowing, is used in MIRR calculations to discount outflows to the present value.
  • Reinvestment Rate: This rate is used in the MIRR to calculate the future value of the cash inflows. It assumes that all positive cash flows are reinvested at the reinvestment rate.
  • Net Present Value (NPV): MIRR is a measure to compare the profitability of investments and it effectively overcomes the limitations of NPV and IRR by assuming reinvestment at the finance rate rather than the IRR.
  • Compound Annual Growth Rate (CAGR): MIRR method provides a better reflection of an investment’s profitability, akin to CAGR, as it considers each positive cash flow’s compounding effect from the time of receipt until the end of the project period.

Sources for More Information

  • Investopedia – They offer a comprehensive explanation of various finance terms including MIRR (Modified Internal Rate of Return).
  • Corporate Finance Institute (CFI) – They provide professional courses and resources in finance and MIRR is one of the topics they cover.
  • Khan Academy – They have a vast amount of learning resources in different areas including finance.
  • My Accounting Course – This site provides detailed courses and articles in finance and accounting that include definitions and explanations of MIRR.

About The Author

Editorial Team

Led by editor-in-chief, Kimberly Zhang, our editorial staff works hard to make each piece of content is to the highest standards. Our rigorous editorial process includes editing for accuracy, recency, and clarity.

x

Get Funded Faster!

Proven Pitch Deck

Signup for our newsletter to get access to our proven pitch deck template.