Investors frequently use the internal rate of return (IRR) to evaluate whether a project or asset will generate adequate returns. Yet traditional IRR can be misleading when projects involve alternating positive and negative cash flows or when the reinvestment of interim returns occurs at a rate different from the financing cost. The Modified Internal Rate of Return, abbreviated MIRR, addresses these shortcomings by separating the discount rate for costs from the reinvestment rate for gains. By doing so, it produces a single annualized rate that more accurately reflects the economic realities of complex investments.
MIRR begins by discounting all negative cash flows—money you invest or pay out—at the finance rate. It then compounds all positive cash flows at the reinvestment rate. Finally, it calculates the rate of return that sets the present value of costs equal to the future value of gains. Because it handles sign changes and reinvestment assumptions explicitly, MIRR often gives a clearer picture of profitability for projects such as real estate developments, infrastructure investments, or venture capital rounds where cash flows can swing dramatically from year to year.
The calculation can be expressed concisely as follows:
Here, represents the future value of positive cash flows compounded at the reinvestment rate, represents the present value of negative cash flows discounted at the finance rate, and is the number of periods. The result is expressed as a decimal or percentage. Because it uses future and present values, MIRR assumes reinvested earnings grow at a predictable rate, which may differ from the cost of financing.
One of the biggest advantages of MIRR is that it generates a single unique solution even when cash flows change sign multiple times. Traditional IRR can produce multiple mathematically valid rates or fail to converge at all in those situations. Additionally, MIRR forces you to specify how interim cash inflows will be reinvested, which is often more realistic than assuming they earn the same rate as the project itself. This distinction is especially important for long-term projects where profits from early years might be rolled into safer investments or used to pay down debt.
Many financial analysts prefer MIRR when comparing mutually exclusive projects with different risk profiles. By applying separate finance and reinvestment rates, you can align the calculation with a company’s capital costs and its expected yield on reserves. This produces a figure that is easier to interpret alongside metrics like Net Present Value (NPV) or the Weighted Average Cost of Capital (WACC). Investors can quickly see whether an opportunity exceeds their hurdle rate once real-world financing and reinvestment conditions are factored in.
To compute MIRR using the form above, list all cash flows from start to finish separated by commas. The first value typically represents your initial investment and should be negative if it is an outflow. Enter the finance rate as a percentage reflecting the cost of borrowing or capital—for example, a 6% annual rate would be typed as 6. Next, enter the reinvestment rate, which might correspond to the rate you expect to earn on interim cash inflows. When you click the calculate button, the script sums the present value of all negative flows, compounds the positive flows to the end of the final period, and applies the MIRR formula to find the annualized return.
Keep in mind that this online calculator simplifies a few aspects of project finance. It assumes that cash flows occur at evenly spaced periods, typically annually, and that rates remain constant over the entire horizon. Real-world projects may have irregular timing or fluctuating interest rates, in which case spreadsheet software or more advanced financial tools can offer greater precision. Nevertheless, MIRR provides a helpful benchmark for quickly comparing investment options or validating assumptions made by promoters and sales materials.
Once you have your MIRR figure, compare it to your desired rate of return or to the yield you could earn from a relatively risk-free investment. If the MIRR exceeds your target, the project may be worthwhile. If it falls short, reconsider the investment or explore ways to reduce financing costs and boost reinvestment returns. Because MIRR focuses on the time value of money, it is particularly useful for evaluating long-term commitments where early gains can be reinvested for compounding growth. Whether you are assessing a real estate venture, a business expansion, or a personal investment opportunity, the MIRR can help reveal the potential for true wealth creation.
Compute the interest on a rental security deposit over time. Enter the principal, annual interest rate, and dates to estimate how much should be returned.
Compute the operating expense ratio to determine how efficiently a rental property converts income into net operating profit.
Predict how long your phone, laptop, or other gadget will run on a single charge using battery capacity and power consumption.