IRR Calculator
Calculate Internal Rate of Return for a series of cash flows using Newton-Raphson method.
Enter details and click Calculate
IRR Calculator โ Evaluate Projects and Investments by True Rate of Return
An IRR (Internal Rate of Return) calculator finds the discount rate at which the Net Present Value (NPV) of all cash flows from an investment equals zero. IRR represents the effective annual return rate of an investment accounting for all cash inflows and outflows across time. It is the standard tool used by businesses, investors, and financial analysts to evaluate and rank investment opportunities, capital expenditure decisions, and real estate projects.
Here is a concrete example: a โน10,00,000 investment generates cash inflows of โน3,00,000, โน3,50,000, โน4,00,000, and โน2,50,000 over 4 years. The IRR is the rate that makes: โ10,00,000 + 3,00,000/(1+r)ยน + 3,50,000/(1+r)ยฒ + 4,00,000/(1+r)ยณ + 2,50,000/(1+r)โด = 0. Solving iteratively gives an IRR of approximately 14.5%. If your company's hurdle rate (minimum acceptable return) is 12%, this project should be accepted โ it earns more than the cost of capital. If a competing project has an IRR of 17%, it should be prioritised over this one.
What is IRR?
Internal Rate of Return (IRR) is the discount rate at which the net present value (NPV) of all cash flows from an investment equals zero. In simpler terms, IRR is the annualised effective return rate of an investment, accounting for the timing and magnitude of all cash inflows and outflows.
- IRR is used to compare investment opportunities on a consistent basis: an investment with IRR > cost of capital creates value; IRR < cost of capital destroys value.
- Unlike simple ROI, IRR accounts for the time value of money โ a โน10 lakh return in year 1 is worth more than โน10 lakh in year 10, and IRR captures this difference.
- XIRR is the variant used for irregular cash flows (like monthly SIP investments) โ mutual fund return statements typically show XIRR as the true annualised return measure.
- Limitations: IRR assumes reinvestment of interim cash flows at the IRR rate itself (often unrealistic) and can give multiple solutions for non-conventional cash flow patterns.
How to Use This Calculator
- Enter the Initial Investment as a negative cash flow (outflow, e.g., โโน10,00,000).
- Click Add Year for each year of expected cash inflows.
- Enter each year's Cash Inflow (positive for inflows, negative for additional outflows).
- Click Calculate to find the IRR.
- Compare the IRR against your hurdle rate (cost of capital or minimum acceptable return) to decide whether to proceed.
- Compare IRRs across multiple projects to rank and prioritise investments.
IRR Formula and Calculation
- (IRR is solved iteratively โ no closed-form formula exists)
- Example: Initial investment โน10,00,000
- Year 1: โน3,00,000 | Year 2: โน3,50,000 | Year 3: โน4,00,000 | Year 4: โน2,50,000
- At r = 14.5%: NPV โ โ10,00,000 + 2,62,009 + 2,67,386 + 2,68,265 + 1,47,349 โ 0
- IRR โ 14.5%
- Total cash received = โน13,00,000 on โน10,00,000 invested over 4 years
Key Terms
- IRR (Internal Rate of Return)
- The annualised effective return rate of an investment that accounts for the timing and magnitude of all cash flows. A higher IRR indicates a more profitable investment (for the same risk level). IRR is scale-independent โ it tells you the rate of return, not the absolute dollar gain.
- Hurdle Rate
- The minimum acceptable return rate for an investment, typically set equal to the company's Weighted Average Cost of Capital (WACC) or an investor's required rate of return. If IRR > hurdle rate, the project creates value; if IRR < hurdle rate, it destroys value. For Indian businesses, hurdle rates are typically 12%โ18% depending on the risk profile.
- NPV vs IRR
- Both are discounted cash flow (DCF) methods, but they measure different things. NPV gives absolute value creation in rupees; IRR gives the percentage rate of return. NPV is generally more reliable for comparing mutually exclusive projects of different scales. IRR is useful for quick screening and ranking. When NPV and IRR conflict, NPV is the better decision criterion.
- Modified IRR (MIRR)
- A refinement of IRR that addresses a key IRR assumption โ that interim cash flows are reinvested at the IRR itself (often unrealistically high). MIRR allows you to specify a realistic reinvestment rate, giving a more accurate return estimate. For most practical purposes, IRR and MIRR produce similar results.
Tips
- An IRR above your cost of capital (hurdle rate) indicates value creation โ but ensure the IRR calculation includes ALL costs, including maintenance, working capital, and terminal costs.
- Compare IRR across competing investment options, but don't choose solely on IRR โ a 25% IRR project generating โน5 lakh profit may be inferior to an 18% IRR project generating โน50 lakh profit in absolute terms.
- For real estate investments in India, calculate IRR including rental income, appreciation, all purchase costs (stamp duty, registration, brokerage), maintenance, property tax, and eventual sale proceeds.
- Non-conventional cash flows (multiple sign changes) can produce multiple IRR values โ use NPV for decision-making in such cases.
- Always perform sensitivity analysis โ how does IRR change if revenues are 10% lower or costs 10% higher? This reveals the robustness of your investment thesis.
Frequently Asked Questions
ROI is a simple ratio: (Gain โ Cost) รท Cost. It ignores the timing of cash flows โ whether you receive money in Year 1 or Year 4 makes no difference to simple ROI. IRR accounts for timing โ receiving โน5,00,000 in Year 1 is more valuable than receiving โน5,00,000 in Year 4 because the Year 1 money can be reinvested sooner. IRR is therefore more accurate for evaluating investments with multiple cash flows over time. Use ROI for simple one-time investments; use IRR for multi-year projects with complex cash flows.
A "good" IRR depends on the industry, risk level, and alternative investment options. General benchmarks for India: Real estate: 12%โ18% IRR is considered good. Business expansion: 20%โ30% IRR for justified capital expenditure. Venture capital: 25%โ35%+ to justify high startup risk. Infrastructure projects: 12%โ16% with government guarantees. The minimum threshold is typically the company's WACC (cost of capital). If your business borrows at 12%, any project with IRR below 12% is destroying value.
NPV is generally the more reliable criterion for mutually exclusive investment decisions (choose between A or B). IRR is better for screening and ranking many potential investments when you don't want to specify a discount rate. When they conflict: NPV is correct. Key IRR limitation โ it doesn't account for scale. A 30% IRR project returning โน5 lakh may be inferior to a 20% IRR project returning โน50 lakh. NPV captures absolute value creation directly.
For real estate IRR: Initial outflow = Purchase price + Stamp duty + Registration + Renovation + Brokerage. Annual inflows = Net rental income (rent โ maintenance โ property tax โ management fee). Final year inflow = Net sale proceeds (sale price โ brokerage โ capital gains tax). Enter these as cash flows into this calculator. A well-located residential property in India with 3% rental yield and 7% annual appreciation delivers an IRR of approximately 10%โ12% โ comparable to or below long-term equity returns but with lower volatility.
The hurdle rate is the minimum acceptable return for an investment. For businesses, it is typically set at the WACC (Weighted Average Cost of Capital) โ the blended cost of equity and debt financing. For individual investors, it is often set at the best available risk-free return (e.g., G-Sec yield of 7%) plus a risk premium appropriate for the investment. For an equity-type business investment, a hurdle rate of 15%โ18% is reasonable in the Indian context, reflecting both the cost of capital and the required risk premium.