The usual internal rate of return can look better than reality because it assumes that cash is reinvested at the same high rate. The modified internal rate of return fixes this. This MIRR calculator takes the initial investment, the annual cash inflow, the number of years, a final outflow, the finance rate and the reinvestment rate to give the MIRR, the future value of the inflows, the present value of the outflows and the growth multiple.
How the calculation works
- Future value of the inflows = annual cash flow × ((1 + reinvestment rate)^n − 1) ÷ reinvestment rate. It assumes that each inflow is reinvested until the end.
- Present value of the outflows = initial investment + any final outflow ÷ (1 + finance rate)^n.
- MIRR = (future value of the inflows ÷ present value of the outflows)^(1 ÷ n) − 1.
- Unlike the IRR, the MIRR assumes a realistic reinvestment rate and has one answer, even when the cash flows change sign more than once.
Example
A project costs $100,000, brings $30,000 a year for 5 years and ends with a $10,000 cleanup cost. The finance rate is 8% and the reinvestment rate 6%. The inflows grow to 30,000 × 5.6371 = $169,113. The outflows are worth 100,000 + 10,000 ÷ 1.08⁵ = $106,806 today. The MIRR is (169,113 ÷ 106,806)^(1/5) − 1 = 9.63%.
Why it matters
Finance students, analysts and investors use the MIRR to compare projects and to check an IRR that looks too good. It is a standard topic in corporate finance courses and appears as a built-in function in spreadsheets.
Good to know
The calculator assumes one investment at the start, equal inflows each year and one final outflow. Real projects may have several outflows and uneven inflows, which a spreadsheet function handles better. The MIRR depends on the finance and reinvestment rates that you choose, so it is as uncertain as they are. Use it with the NPV, and do not take it as investment advice.
Related tools
The IRR calculator gives the classic rate of return, the net present value calculator values the cash flows in today’s money and the effective annual rate calculator converts nominal rates.