Modified Internal Rate of Return (MIRR) Explained for 2026

For years, IRR was the go-to metric for weighing up projects, especially in sectors like property, renewables, and business expansion. But IRR’s biggest flaw? It assumes all interim cash flows can be reinvested at the same high rate as the project’s return—a scenario rarely seen in the real world. Enter MIRR, which lets you input a realistic reinvestment rate (often your actual cost of capital or a market benchmark) and a finance rate for project outlays.

• Reflects real-world reinvestment: MIRR incorporates the actual rate at which cash flows can be reinvested, especially relevant as the RBA’s cash rate and bank deposit rates fluctuate in 2026.

• Accounts for project financing costs: With business loan rates and green finance packages changing, MIRR provides a more accurate cost-benefit snapshot.

• Reduces misleading results: Projects with unconventional cash flows (like renewable energy installations or phased property developments) often yield multiple IRRs. MIRR delivers a single, sensible figure.

Let’s break down MIRR’s appeal with a practical example. Suppose a Sydney-based SME is considering a $500,000 solar upgrade. The project promises annual savings and government incentives, but also involves upfront financing at 7% and realistic reinvestment opportunities at 4%—in line with 2026’s term deposit rates.

• Calculate the future value (FV) of all inflows, reinvested at 4%.

• Determine the present value (PV) of all outflows, discounted at 7%.

• Solve for the rate (MIRR) that equates these two over the project’s timeline.

This approach acknowledges the true opportunity cost and actual earning potential, not just theoretical returns. For investment committees and finance managers juggling multiple projects in 2026’s competitive market, this realism can make all the difference.

1. Property Development in Melbourne: A developer compares two projects: one with steady rental yields, the other with volatile sales proceeds. IRR suggests the riskier project is better, but MIRR—using conservative reinvestment rates—reveals the steady income is actually superior for long-term returns.

2. Renewable Energy Investment: With the Australian government’s 2026 Clean Energy Finance Corporation (CEFC) incentives, many businesses face upfront costs offset by long-term savings. MIRR factors in low-risk reinvestment rates and the cost of green loans, clarifying which projects deliver true value beyond the headline IRR.

3. Small Business Expansion: As business lending rates fluctuate post-pandemic, SMEs can use MIRR to compare funding options and determine which expansion project aligns with their real borrowing and reinvestment environment.

• Shifting Interest Rates: The RBA’s 2026 guidance impacts both borrowing costs and safe reinvestment opportunities, making accurate MIRR inputs more crucial than ever.

  • Government Investment Incentives: New tax breaks and grants (such as the 2026 instant asset write-off extension) affect both inflow and outflow timing, directly feeding into MIRR calculations.

  • Heightened Focus on Project Risk: Institutional investors and lenders are scrutinising not just returns, but the assumptions behind them. MIRR’s transparency is a plus for due diligence and board approvals.

MIRR calculations aren’t just for big corporations. Most spreadsheet software (including the latest versions of Excel and Google Sheets) features built-in MIRR functions—simply plug in your projected cash flows, finance rate, and reinvestment rate. For larger projects, consider financial modelling software or consulting a commercial analyst to ensure your inputs reflect 2026’s economic realities.

• Be conservative with reinvestment rates—look to current term deposit or government bond rates.

• Update finance rates to reflect today’s lending market, not last year’s.

• Use MIRR alongside Net Present Value (NPV) for a fuller investment picture.