Skip to content
Omnikalc

MIRR calculator: a more realistic rate of return than the IRR

Enter the investment, the yearly inflows, the final outflow, the finance rate and the reinvestment rate to get the modified internal rate of return.

Updated on
Your inputs
$

Value out of range

$

Value out of range

Value out of range

$

Value out of range

%

Value out of range

%

Value out of range

Results

Modified internal rate of return (MIRR)

9.63%

Above the finance rate
Future value of the inflows
$169,113
Present value of the outflows
$106,806
Growth multiple
1.58 ×

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.

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.

Frequently asked questions

What is the MIRR?

The modified internal rate of return is the annual growth rate that turns the present value of all outflows into the future value of all inflows, with the inflows reinvested at a stated rate and the outflows financed at another rate. It corrects two weak points of the IRR.

Why use the MIRR instead of the IRR?

The IRR assumes that every inflow is reinvested at the IRR itself, which is often too high, and it can give several answers or none when the cash flows change sign. The MIRR uses a rate you choose, so it is more realistic and gives a single number.

What are the finance and reinvestment rates?

The finance rate is the cost of the money that pays for the outflows, such as a loan rate or the cost of capital. The reinvestment rate is the return you can earn on the cash that the project produces, such as a savings or market rate. Both are assumptions, so try a few values.

When is a MIRR good enough?

A project is attractive when its MIRR is above the cost of capital or the rate you require. The result is then consistent with a positive NPV at that rate. Compare projects of the same length, and also check the size of the profit, since the MIRR ignores scale.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.