IRR Calculator

The Internal Rate of Return (IRR) is the discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero. In plain terms, it is the annualised return you earn on an investment, accounting for the timing and size of every rupee that goes in and comes out. Because real investments rarely pay the same amount each year, IRR is the right tool when cash flows are irregular — a property that yields rising rent, a business that loses money early then turns a profit, or a fund that returns capital in lumpy instalments. It is the go-to metric for evaluating capital projects, private equity and venture deals, real estate, and any investment with an uneven payout schedule.

Unlike a simple return percentage, IRR respects the time value of money — a rupee received next year is worth more than the same rupee five years out. The first cash flow (typically negative) is the money you put in; the later positive flows are what you get back. If the IRR clears your cost of capital or hurdle rate, the investment is creating value; if it does not, your money would do better elsewhere.

This tool is for the founder appraising a project, the investor comparing a private deal against an index fund, the landlord checking whether a rental actually beats an FD, or the student learning capital budgeting. Enter your cash flows as comma-separated values, with the initial investment as a negative number.

How it works — the formula

IRR is the rate r that satisfies NPV = Σ [CFt / (1 + r)^t] = 0, where CFt is the cash flow in period t (period 0 being your initial outlay). There is no algebraic way to isolate r, so the calculator finds it numerically using Newton-Raphson iteration: it starts with a guess, measures how far NPV is from zero, adjusts the rate using the slope of the NPV curve, and repeats until it converges — the same method behind Excel's IRR() function. The result is one annualised rate that summarises the whole cash-flow stream.

A worked example in ₹ (irregular cash flows)

Suppose you invest ₹2,00,000 in a small venture and it returns ₹50,000 in year 1, ₹60,000 in year 2, ₹70,000 in year 3 and ₹80,000 in year 4 — a different amount every year, which is exactly where simple averages fail. Enter -200000, 50000, 60000, 70000, 80000 and the IRR comes out to about 10.48%. Note that the total received is ₹2,60,000 — a ₹60,000 nominal gain, or 30% spread over four years — yet the IRR is only ~10.5% per year, because the money was tied up over time and the larger payouts arrived late. That gap between “30% total” and “10.5% a year” is precisely the insight IRR gives you, and it is what lets you compare this deal against, say, a fixed deposit or a debt fund on equal footing.

Key tips

• Make the first value negative — it is the cash leaving your pocket. At least one later value must be positive, or no IRR exists.
• Keep cash flows in chronological order and use a consistent period (usually one year per entry). The IRR is then a per-period rate; with yearly flows it is an annual rate.
• Always judge IRR against a benchmark: your cost of capital, an FD rate, or the return on a comparable index fund. A 10% IRR is good against a 6% FD but weak against 12% from equities.
• Net each period to a single figure — combine inflows and outflows in the same year into one number before entering it.

Common mistakes & India-specific notes

• IRR is not the same as absolute profit. A high IRR on a tiny, short investment can create less wealth than a modest IRR on a large, long one. For ranking mutually exclusive projects, also look at NPV, which measures rupees created.
• Use XIRR for real, date-based SIPs. This calculator assumes evenly spaced periods. Indian SIP and lump-sum investments happen on specific dates, so for actual mutual-fund portfolios the date-aware XIRR (as used by your AMC or broker statement) is the right measure.
• IRR is pre-tax and pre-inflation. It does not adjust for capital-gains tax or inflation, so the return you keep in hand will be lower. Compare after-tax returns when the tax treatment of two options differs.
• Unconventional cash flows can break IRR. If the sign of your cash flows changes more than once (for example a big mid-project reinvestment), there can be multiple IRRs or none, and the tool may return no result. In those cases rely on NPV, or use Modified IRR (MIRR).

This tool is for general information only and is not financial advice. Returns from any real investment are not guaranteed.