IRR Calculator

The Internal Rate of Return (IRR) is one of the most important metrics in corporate finance and project evaluation. It represents the discount rate at which the net present value (NPV) of all cash flows from a project equals zero. In simple terms, IRR tells you the annualised effective rate of return that a project is expected to generate. If the IRR exceeds the company's cost of capital or hurdle rate, the project is worth pursuing because it creates value for shareholders.

How IRR Is Calculated

The IRR cannot be solved algebraically for most real-world cases. Instead, it is found through iterative numerical methods. Our calculator uses the Newton-Raphson method, which converges rapidly for well-behaved cash flow patterns, with a bisection fallback for edge cases. The process starts with an initial guess and iteratively refines the discount rate until NPV converges to zero within a tiny tolerance (one ten-millionth of a rupee).

Modified Internal Rate of Return (MIRR)

A well-known criticism of IRR is that it implicitly assumes all interim cash flows are reinvested at the IRR itself, which may be unrealistic for projects with very high or very low IRRs. The Modified IRR (MIRR) addresses this by using two separate rates: a finance rate for discounting negative cash flows to the present, and a reinvestment rate for compounding positive cash flows to the terminal year. MIRR provides a single, unambiguous rate of return even when the conventional IRR produces multiple solutions (which can happen with non-conventional cash flow patterns).

IRR vs Hurdle Rate: The Decision Rule

The basic IRR decision rule is straightforward: accept a project if its IRR exceeds the hurdle rate (typically the WACC), and reject it if the IRR falls below the hurdle rate. For Indian companies, the hurdle rate typically ranges from 10-15% depending on the industry, company size, and risk profile. IT services firms with low capital intensity might use 12%, while capital-heavy manufacturing or infrastructure companies might require 14-16%.

When IRR Can Mislead

IRR has several well-documented pitfalls. For mutually exclusive projects of different sizes, a smaller project with a higher IRR may have a lower NPV than a larger project with a modest IRR. In such cases, NPV should be the primary decision criterion. Projects with non-conventional cash flows (alternating positive and negative flows) can produce multiple IRRs or no real IRR at all. The reinvestment rate assumption can significantly overstate returns for projects with high IRRs. For all these reasons, always use IRR alongside NPV and MIRR.

IRR in Indian Corporate Practice

In India, IRR is extensively used for project finance decisions by banks, NBFCs, and infrastructure investors. The Reserve Bank of India and SEBI expect companies to disclose project return metrics in certain contexts. Private equity funds evaluating Indian investments typically target gross IRRs of 20-25%, while infrastructure debt funds may accept 10-14%. Understanding the distinction between project IRR (unleveraged) and equity IRR (leveraged, and therefore higher) is crucial for proper analysis.

Practical Tips for IRR Analysis

Always compute both IRR and MIRR. Use MIRR when interim cash flows are likely to be reinvested at a rate different from the project's own IRR (which is usually the case). Run sensitivity analysis by varying key inputs to understand how robust the IRR is to changes in assumptions. For long-duration projects (10+ years), even small changes in cash flow estimates can swing the IRR by several percentage points. Consider scenario analysis (base, optimistic, pessimistic) rather than relying on a single-point IRR estimate.