How to Use the MIRR Calculator
The MIRR (Modified Internal Rate of Return) Calculator provides a more realistic measure of investment profitability than traditional IRR by using separate rates for financing costs and reinvestment returns. Enter your initial investment as a negative number, specify the finance rate (your cost of capital) and reinvestment rate (the rate at which positive cash flows can be reinvested), then enter up to five years of cash flows. The calculator computes the MIRR, total invested amount, terminal value of positive cash flows, and the net present value of the investment at your finance rate.
What Is MIRR?
The Modified Internal Rate of Return addresses two major limitations of the traditional Internal Rate of Return calculation. Standard IRR assumes that all positive cash flows are reinvested at the IRR itself, which is often unrealistically high, and it can produce multiple solutions for projects with alternating positive and negative cash flows. MIRR solves both problems by using explicit rates for financing and reinvestment. The finance rate represents your cost of borrowing or opportunity cost of capital, while the reinvestment rate represents the realistic return you can earn on positive cash flows when they are received. This makes MIRR a more conservative and often more accurate measure of project profitability.
The MIRR Formula
MIRR is calculated in three steps. First, compute the future value (terminal value) of all positive cash flows compounded forward to the end of the project at the reinvestment rate. Second, compute the present value of all negative cash flows discounted back to time zero at the finance rate. Third, MIRR equals the nth root of the terminal value divided by the present value of negatives minus one, where n is the number of periods. Mathematically, MIRR equals the quantity FV of positives divided by PV of negatives, raised to the power of one over n, minus one. This single formula always produces a unique result, unlike traditional IRR which may have multiple solutions.
MIRR vs IRR
While IRR solves for the discount rate that makes the net present value equal to zero, MIRR provides a more practical measure by acknowledging that cash flows received during the project life will be reinvested at a rate different from the IRR. Consider a project with IRR of 25 percent but a realistic reinvestment rate of only 8 percent. The IRR overstates the actual return because it assumes intermediate cash flows earn 25 percent when they really earn 8 percent. MIRR accounts for this reality and typically produces a lower but more achievable return estimate. For mutually exclusive projects, MIRR also resolves the ranking conflicts that sometimes occur between IRR and NPV analysis.
When to Use MIRR
MIRR is particularly valuable in several situations. Use it when comparing mutually exclusive projects of different sizes or durations, as it accounts for reinvestment assumptions more realistically. Use it when a project has non-conventional cash flows with multiple sign changes, which can cause traditional IRR to produce multiple solutions. Use it in corporate capital budgeting when the cost of capital and reinvestment opportunities are well defined. Use it for real estate development analysis where cash outflows for construction are followed by cash inflows from sales or rental income. Finance professionals and CFA candidates should be comfortable with MIRR as it appears in advanced corporate finance analysis.
Interpreting MIRR Results
A positive MIRR that exceeds your cost of capital indicates a profitable investment. Compare MIRR to your hurdle rate or weighted average cost of capital (WACC) to make accept/reject decisions. If MIRR equals 12 percent and your WACC is 10 percent, the project creates value and should be accepted. Unlike IRR, you can directly compare MIRR values across projects with different cash flow patterns because MIRR always produces a single unique solution. The terminal value shown represents the accumulated future value of all positive cash flows at the reinvestment rate, giving you a sense of the total wealth generated by the project.
Limitations of MIRR
While MIRR improves upon IRR, it still has limitations. It requires you to estimate the reinvestment rate and finance rate, which introduces subjectivity. If these rates are chosen poorly, the MIRR result may be misleading. MIRR also does not account for differences in project scale, so a small project with a high MIRR might create less total value than a large project with a lower MIRR. For this reason, NPV remains the theoretically preferred capital budgeting technique, and MIRR should be used as a complementary measure rather than the sole decision criterion.
Practical Example
Consider a business investing 50,000 dollars in equipment that generates cash flows of 15,000 dollars per year for five years. With a finance rate of 10 percent and reinvestment rate of 8 percent, the terminal value of positive cash flows compounded at 8 percent equals approximately 87,980 dollars. The MIRR equals the fifth root of 87,980 divided by 50,000 minus one, which is approximately 11.96 percent. This tells you the investment effectively returns about 12 percent per year when accounting for realistic reinvestment. Compare this to the standard IRR of 15.24 percent to see how reinvestment assumptions affect the measured return.