The Modified Internal Rate of Return (MIRR) is a crucial financial metric used by businesses and investors to assess the profitability of potential investments or projects. Unlike the traditional Internal Rate of Return (IRR), MIRR considers both the costs of investment and the interest received on reinvestment of cash. It provides a more realistic measure of an investment’s expected return.
Purpose and Functionality of the MIRR Calculator
The MIRR calculator is designed to give investors a clearer picture of their investment’s potential by considering different rates for reinvesting the cash flows and financing the project. Here’s what the calculator does:
- Calculates the future value (FV) of positive cash flows using a specified reinvestment rate. This shows what all the incoming cash flows will amount to, assuming they are reinvested at a consistent rate until the project’s end.
- Calculates the present value (PV) of negative cash flows using a financing rate. This reflects the initial and any ongoing costs discounted back to their value today.
- Computes the MIRR by taking the ratio of the future value of inflows to the present value of outflows, raised to the power of 1 divided by the number of periods, and then subtracting 1.
MIRR Calculation Formula
The formula to calculate MIRR is:
MIRR=(FV of positive cash flowsPV of negative cash flows)1𝑛−1MIRR=(PV of negative cash flowsFV of positive cash flows)n1−1
Where:
- FV represents the future value of positive cash flows,
- PV is the present value of negative cash flows,
- n is the number of periods over which the cash flows are projected.
Step-by-Step Example
Consider a project requiring an initial investment of $100,000 (a negative cash flow) and returns $30,000 annually for the next 5 years. Assume a reinvestment rate of 5% and a financing rate of 3%.
- Calculate the PV of the initial investment: Already given as $100,000.
- Calculate the FV of the returns: Each of the $30,000 cash inflows is reinvested at a 5% rate for each remaining year of the project.
- Compute the MIRR using the formula provided above.
Here’s how the numbers might look (simplified for clarity):
- Future Value of inflows: $162,889
- Present Value of outflows: $100,000
- MIRR = (162,889100,000)0.2−1(100,000162,889)0.2−1 = 10.24%
Relevant Information Table
| Year | Cash Flow | Cumulative FV at 5% (Reinvest) |
|---|---|---|
| 0 | -$100,000 | N/A |
| 1 | $30,000 | $36,552.55 |
| 2 | $30,000 | $34,812.43 |
| 3 | $30,000 | $33,154.22 |
| 4 | $30,000 | $31,574.97 |
| 5 | $30,000 | $30,000.00 |
| Total | $166,094.17 |
Conclusion
The MIRR calculator is a powerful tool that provides a more accurate and detailed evaluation of an investment’s viability. By considering both the reinvestment and financing rates, it offers a more comprehensive assessment compared to the traditional IRR. Whether you’re a seasoned investor or just starting out, understanding and using the MIRR can greatly enhance your decision-making process for future investments.