You are here:

Use the Modified Internal Rate Of Return Calculator to measure of an investment's attractiveness. Modified Internal Rate Of Return (MIRR) is used in capital budgeting to rank alternative investments of equal size. As the name implies, MIRR is a modification of the internal rate of return (IRR).

**Note1 :** When a positive cash flow is detected, the MIRR Calculator will use the Reinvestment rate r_{ri} for the calculation of FV and PV.

**Note2 :** When a negative cash flow is detected, the MIRR Calculator will use the Finance rate r_{f} for the calculation of FV and PV.

The Modified Internal Rate Of Return (MIRR) is % |

The Future Value (FV) is |

The Present Value (PV) is |

The number of periods (n) for the MIRR return calculation is |

Modified Internal Rate Of Return MIRR formula and calculations |
---|

MIRR = FV/PV^{1/n} - 1MIRR = /^{1/} - 1MIRR = ^{} - 1MIRR = - 1MIRR = MIRR = % |

Present Value PV formula and calculations |

PV_{x} = c_{x}/( 1 + r_{ri} )^{tx} |

Future Value FV formula and calculations |

FV_{x} = c_{x}(1 + r_{ri} × t_{x}) |

MIRR Calculator Input Values |

Total Cash Flows (c_{total}) (max 20) = |

Re-investment Rate (r_{ri}) % = % |

Finance Rate (r_{f}) % |

If you would like to manual calculate the Present Value for the cashflows above then please use the Present Value Calculator

If you would like to manual calculate the Future Value for the cashflows above then please use the Future Value Calculator

As the name suggests the modified internal rate of return is the improved version of the profitability measure known as Internal Rate of Return (IRR). The MIRR assumes that positive cash flows are reinvested at the firm's cost of capital or a steady reinvestment rate.

It helps you in gauging the attractiveness of an investment as well as for comparing various investments MIRR is one of the best financial instruments. MIRR is designed to generate one solution, eliminating the issue of multiple IRRs. Let's see how it is different than IRR.

The MIRR and the IRR are very closely related financial terms. The IRR misinterprets some factors that are rectified in MIRR ratio calculations. One of the major issues in IRR calculation is that it assumes that the obtained positive cash flows get reinvested at the rate of their generation. On the other hand, the considerations in MIRR calculation allows for the fact that the proceeds from the positive flows of cash, get reinvested at an external rate of return. This external rate of return is most of the times, equal to the cost of capital of the company.

It is considered that the MIRR provides a better picture of the return one can expect from an investment. This is not the case with the standard IRR calculations. Thus, MIRR is most of the times lower than the IRR.

The internal rate of return is an interest rate at which Net present value (NPV) is equal to zero, whereas MIRR is the rate of return at which NPV of terminal cash inflows is equal to the outflows (i.e. investment). MIRR can be calculated manually as well as with the help of an online calculator such as modified internal rate of return calculator by iCalculator; the method to use the calculator is explained below.

There are basically three variables that you should take into consideration for the calculation of MIRR:

- The future value of positive cash flows which gets discounted at the same rate as the reinvestment rate.
- The present value of negative cash flows which gets discounted at the financing rate.
- The number of periods.

You can calculate MIRR by using the following formula:

MIRR = *FV (reinvestment rate)**/**PV (finance rate)*^{1/n} - 1

On the basis of the above inputs, the calculator will provide you with MIRR ratio for your project.

The MIRR calculator is an online tool designed by iCalculator in a way that allows you to calculate the MIRR ratio at the comfort of your home or office.

You can calculate MIRR manually and even using the spreadsheets but the process is quite complicated. Using the calculator is really easy and saves you effort and time. Additionally, the calculator allows you to enter a huge number of cash flow periods. This can be very useful in evaluating big projects. Let's find out how evaluation the projects by MIRR method can be useful.

The MIRR ratio of assessing the profitability of your projects can be a really useful tool in various ways, because:

- You can use the MIRR to compare various projects, the only condition being, all of them have to be mutually exclusive. The project with higher MIRR ratios will be the most appealing one.
- MIRR is capable of overcoming the two major drawbacks of IRR. It eliminates multiple IRRs in those investments which have unusual timing of the cash to flow in.
- The MIRR also helps to measure the sensitivity of a typical investment towards any kind of change in the cost of capital.

Even though the MIRR calculations are quite useful, let's take a look at some of the drawbacks of this method.

Though MIRR is a better financial tool, for calculating the attractiveness of an investment, it also has certain limitations:

- MIRR can also lead to the sub-optimal making of decisions when there are many investments to consider. MIRR is not capable of providing a numerical value to the effect of various investments on the financial condition of the investors.
- People who belong to non-financial backgrounds, often find it difficult to understand the concept of MIRR.

The MIRR is used for capital budgeting, to understand whether an investment would be viable or not. If the MIRR of a project is higher than the returns expected from it, the investment will be considered attractive. On the other hand, if the MIRR is less than the return expected, it is better not to undertake that project.

You may also find the following Finance calculators useful.

- Capital Gains Tax Calculator
- Simple Profit Calculator
- Foreign Currency Quarterly Income Deposits Calculator
- Currency Converter
- Average Collection Period Calculator
- Weighted Average Cost Of Capital Calculator
- Acturial Method Lease Calculator
- Debt Payoff Calculator
- Net Worth Calculator
- Absolute Change Calculator
- Equivalent Annual Annuity Calculator
- Accrued Interest Calculator
- Small Business Rate Relief Calculator
- Home Equity Line Of Credit Calculator
- Mortgage Early Repayment Calculator
- Profitability Calculator
- Rental Property Calculator
- Cagr Calculator
- Capital Asset Pricing Model Calculator
- Electrical Consumption Calculator