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 Benchmarks in the Indian Market
Benchmarks vary sharply by asset class. Indian private equity funds target net IRRs of 20 to 25 percent over a 5 to 7 year fund life. Venture capital funds aim for 25 to 35 percent net IRR, given the higher loss ratio on individual investments. Infrastructure funds and InvITs operating in power, roads, and telecom typically deliver 10 to 14 percent IRR because of long stable cash flows and lower risk. Real estate development projects in tier-1 metros target 18 to 22 percent pre-tax IRR. Corporate capex proposals usually need to beat a 13 to 15 percent hurdle rate that reflects WACC plus a risk premium.
IRR for Capital Budgeting Decisions
Indian CFOs and corporate finance teams use IRR as one of three primary capex screening tools, alongside NPV and payback period. 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 should be used in such cases.
Ignoring scale: A Rs 10 lakh project with 40 percent IRR adds less value than a Rs 10 crore project with 18 percent IRR, even though the former looks better in percentage terms. Always cross-check with NPV.
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. Typical Indian PE deals underwrite at 22 to 25 percent deal IRR, assuming a 5-year hold and exit via IPO, secondary sale, or strategic acquisition. The General Partner's carried interest is typically triggered only after the fund crosses a preferred return (hurdle) of 8 percent. High IRR alone is not sufficient: investors also examine the Multiple on Invested Capital (MOIC), which measures absolute value created.
Regulatory and Disclosure Context
SEBI's disclosure norms for InvITs and REITs require sponsors to disclose project-level and portfolio IRRs in offer documents. RBI's external commercial borrowing (ECB) framework uses IRR indirectly through the all-in-cost ceilings. Companies listed on BSE and NSE disclose IRR in strategic capex approvals, especially in sectors like power and telecom. For individual taxpayers, the IRR concept is also relevant when evaluating ULIP, PMS, and alternative investment fund returns on a post-tax basis.