Investment & Savings

IRR Calculator

Calculate Internal Rate of Return for a series of cash flows using Newton-Raphson method.

Details
โ‚น
Year 1
โ‚น
Year 2
โ‚น
Year 3
โ‚น
%
Results

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

  1. Enter the Initial Investment as a negative cash flow (outflow, e.g., โˆ’โ‚น10,00,000).
  2. Click Add Year for each year of expected cash inflows.
  3. Enter each year's Cash Inflow (positive for inflows, negative for additional outflows).
  4. Click Calculate to find the IRR.
  5. Compare the IRR against your hurdle rate (cost of capital or minimum acceptable return) to decide whether to proceed.
  6. Compare IRRs across multiple projects to rank and prioritise investments.

IRR Formula and Calculation

NPV = 0 = โˆ’Cโ‚€ + CFโ‚/(1+IRR)ยน + CFโ‚‚/(1+IRR)ยฒ + ... + CFโ‚™/(1+IRR)โฟ
  • (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.

Related Calculators