Modified IRR Calculator - Cash Flow MIRR

A modified IRR calculator estimates the modified internal rate of return for periodic project or investment cash flows. Use it when a project has one or more upfront costs, later receipts, and explicit assumptions for financing cost and reinvestment return. It is useful for capital budgeting, private investment review, acquisition modeling, and comparing projects whose ordinary IRR may overstate reinvestment performance.

• • Capital budgeting: Compare a proposed project with the company's required return while using a finance rate that reflects cost of capital.
• • Private investment review: Test whether interim distributions still produce an acceptable return after using a realistic reinvestment assumption.
• • Project ranking: Place MIRR beside NPV, payback period, and profitability index before choosing between competing uses of cash.
• • Spreadsheet audit: Check a MIRR function result by seeing the terminal value of inflows and present value of outflows separately.

MIRR starts from the same signed cash-flow idea as IRR: money paid out is negative, and money received is positive. The difference is that MIRR does not assume every interim receipt can be reinvested at the IRR itself. You choose a finance rate for costs and a reinvestment rate for receipts, which makes the assumption visible.

Use the result as an investment worksheet, not as a recommendation. A project can show an attractive MIRR and still be unsuitable because of liquidity, taxes, execution risk, accounting constraints, or a poor fit with the rest of the portfolio.

When you need the ordinary internal-rate view before applying separate reinvestment assumptions, compare this result with the IRR Calculator.

The calculator separates the cash-flow stream into costs and receipts before converting them to the same timeline.

• Positive cash flows: Receipts, distributions, salvage value, or operating inflows entered as positive numbers.
• Negative cash flows: Initial investments, later capital calls, or project costs entered as negative numbers.
• Finance rate: The rate used to discount negative cash flows back to period 0.
• Reinvestment rate: The rate used to compound positive cash flows to the final period.

First, each negative cash flow is discounted to the start using the finance rate. A later cost matters less in present-value terms than the same cost paid immediately, assuming the finance rate is positive. The calculator reports the absolute present value of those outflows so you can see the cost base used in the MIRR formula.

Second, each positive cash flow is compounded to the final period using the reinvestment rate. A receipt received early has more periods to compound than a receipt received near the end. The terminal value output shows the future-value side of the calculation before it is annualized.

Finally, the calculator divides terminal inflows by present-value outflows, raises the ratio to one divided by the number of periods, and subtracts one. The displayed MIRR is a periodic rate expressed as an annual-style percentage when each period is one year.

According to Microsoft Support, Excel's MIRR function returns modified internal rate of return for periodic cash flows and requires at least one positive and one negative value.

For a standalone check of how receipts compound to a terminal amount, the Future Value Calculator isolates the future-value step.

Four ideas explain why MIRR can differ sharply from ordinary IRR.

Ordinary IRR solves for the discount rate that sets net present value to zero. MIRR instead builds a bridge from present-value costs to future-value receipts. That structure avoids some multiple-IRR problems, but it does not remove judgment because both rates are selected inputs.

A higher reinvestment rate raises terminal value and therefore raises MIRR. A higher finance rate can reduce the present value of later negative cash flows, which may also raise MIRR in projects with staged investments. For that reason, rate assumptions should be documented whenever the result is used in a memo.

According to CFA Institute Enterprising Investor, modified IRR uses predetermined financing and reinvestment rates to compute an overall rate of return.

If the cash flows happen on irregular dates instead of equal periods, the XIRR Calculator is the closer return model.

Use the modified IRR calculator after you have listed cash flows in chronological order and kept the period length consistent.

1. 1 List each period: Use period 0 for the starting investment, then enter period 1 through period 5 in order.
2. 2 Use correct signs: Enter investments, costs, and capital calls as negative numbers; enter receipts and distributions as positive numbers.
3. 3 Set the finance rate: Use a periodic cost of capital, borrowing rate, or required return that fits the negative cash flows.
4. 4 Set the reinvestment rate: Use the rate you believe interim positive cash flows could earn outside the project.
5. 5 Read the supporting outputs: Compare MIRR with terminal value, present-value costs, and net cash flow before ranking the project.

A business reviewing a machine purchase might enter the equipment cost in period 0, expected operating cash flow in periods 1 through 4, and resale proceeds in period 5. If MIRR clears the required return only when the reinvestment rate is very high, the project may need a more conservative scenario before approval.

When the finance rate needs its own review, the Discount Rate Calculator helps frame the rate used for present-value costs.

MIRR is most useful when it makes assumptions visible and keeps return comparisons disciplined.

• • Separates financing and reinvestment: The two-rate setup prevents a high IRR from quietly implying that every interim receipt earns the same high return.
• • Handles staged investments: Later negative cash flows are discounted instead of being treated as if all costs occurred at the start.
• • Supports project memos: Terminal value and present-value cost outputs make the rate easier to audit than a single percentage alone.
• • Improves scenario work: Changing the finance or reinvestment rate shows how sensitive the return is to funding and cash-management assumptions.
• • Pairs with other metrics: MIRR can sit beside NPV, payback, and profitability index rather than replacing them.

The calculator also helps catch sign mistakes. If all cash flows are positive or all are negative, MIRR is not defined in the usual way. Showing zero MIRR with the supporting totals makes the input issue visible before the result is copied into a decision file.

For competing projects, use the same period length and rate assumptions. A five-year project and a ten-year project can have similar MIRRs while tying up capital for very different lengths of time.

For capital rationing, pair MIRR with the Profitability Index Calculator to compare value created per dollar invested.

The result changes when the cash-flow timing, selected rates, or project structure changes.

• • This calculator uses six equally spaced cash-flow slots. For irregular dates, use a dated cash-flow return method instead.
• • MIRR is assumption-sensitive. It should be reviewed with NPV, project scale, risk, taxes, fees, and liquidity constraints.
• • The output is informational and should not be treated as investment, accounting, tax, or financing advice.

If MIRR is being used for capital allocation, document the source of each rate. A weighted average cost of capital, borrowing rate, treasury rate, or hurdle rate can all be defensible in different settings, but they answer different questions.

When the MIRR is close to the required return, run conservative cases. Lower the reinvestment rate, delay a receipt, or add a later cost to see whether the decision still holds. A robust project should not depend on one fragile assumption.

According to ACCA Global, one MIRR approach compounds return-phase cash flows to a terminal value and compares that value with the present value of investment-phase cash flows.

To audit the discounted-cost side of the MIRR formula, use the Present Value Calculator with the same finance rate.