What Is Internal Rate of Return?
The Internal Rate of Return (IRR) is the single annualised discount rate at which the present value of all future cash inflows from a project exactly equals the initial investment, making the Net Present Value (NPV) zero. Put simply, it is the effective compounded return that an investment generates over its life, accounting for the precise timing of every cash flow. IRR is the most widely used hurdle metric in Indian corporate finance, particularly for capex proposals, private equity exits, real estate development projects, and infrastructure deals.
IRR gives a clean yes-or-no answer when compared to a required return, often called the hurdle rate. If the IRR of a project exceeds the cost of capital, the project creates value; if not, it destroys value. Indian boards routinely see IRR on every capex proposal above Rs 10 crore, and SEBI-regulated InvITs and REITs report project-level IRR in their offering documents.
The Mathematics of IRR
Mathematically, IRR is the rate r that satisfies: Sum of CF_t / (1 + r)^t = 0, where CF_t is the cash flow at time t (the initial investment is a negative cash flow at time 0). There is no closed-form solution for projects with more than two cash flow periods, so IRR is computed iteratively. Excel's IRR function assumes evenly spaced annual cash flows, while XIRR accepts actual dates and is the more accurate choice for real-world projects with irregular timing.
A simple example: an Indian manufacturer invests Rs 50 lakh in new equipment that generates Rs 15 lakh of annual cash flow for 5 years and has Rs 5 lakh salvage value. The IRR is approximately 19.2 percent, comfortably above the typical 10 percent cost of capital, making it a clear value-creating project.
Using the IRR Calculator
The calculator accepts an initial investment and a series of periodic cash flows (positive for inflows, negative for additional outflows). It solves iteratively for the IRR and displays the result with NPV at common discount rates. Use actual post-tax, after-working-capital cash flows rather than accounting profits. Include terminal value or disposal proceeds as the final cash flow for fixed-duration projects.
IRR and Required Returns
The return an investor requires differs by asset class and risk: long-lived assets with steady cash flows, such as infrastructure, are usually priced at lower returns than early-stage ventures with a high failure rate. Each company or fund sets its own hurdle rate; this page does not publish target IRRs.
IRR for Capital Budgeting Decisions
Corporate finance teams often use IRR alongside NPV and payback period to screen capital spending. When projects are independent (accepting one does not preclude another), IRR gives the correct answer as long as the hurdle rate is reasonable. When projects are mutually exclusive, such as two alternative plant locations, NPV is the tie-breaker because IRR ignores project scale and can favour a smaller, higher-IRR project over a larger, value-creating one.
Common IRR Pitfalls
Reinvestment assumption: IRR implicitly assumes that interim cash flows are reinvested at the IRR itself. For high-IRR projects, this is unrealistic. The Modified IRR (MIRR) corrects this by reinvesting at the cost of capital.
Multiple IRRs: Projects with unconventional cash flows (e.g., an inflow followed by an outflow followed by an inflow) can have multiple IRRs or no solution at all. NPV gives a single answer in such cases.
Ignoring scale: At a cost of capital below 18 percent, a Rs 10 lakh project with a 40 percent IRR can add less value than a Rs 10 crore project with an 18 percent IRR, even though the former looks better in percentage terms. NPV shows the difference in rupees.
IRR in Indian M&A and Private Equity
In M&A, acquirers compute transaction IRR based on the purchase price, annual synergies, tax benefits, and the terminal value at exit. Private equity funds model a deal IRR over an expected holding period and exit. A fund's carried interest is often paid only after investors receive a preferred return set in the fund's terms. Because IRR can be high on a short, small gain, investors also look at the Multiple on Invested Capital (MOIC), which measures the absolute value created.