IRR calculator

The internal rate of return is the yearly rate at which the net present value of all the cash flows is exactly zero. Think of it as the interest rate the investment pays you. If it is above your cost of money, the investment adds value.

YearCash flow (₹)
0
1
2
3
4
5
Year 0 is the start: enter money you spend as a negative (−500000). Money coming back is positive.
IRR (yearly return)
17.93%
Total cash out₹5,00,000 (5.00 lakh)
Total cash in₹7,80,000 (7.80 lakh)
NPV at this rate₹0

The formula

IRR is the rate r that solves 0 = CF₀ + CF₁ ÷ (1 + r) + CF₂ ÷ (1 + r)² + … + CFₙ ÷ (1 + r)ⁿ. There is no direct formula, so the calculator searches for r, as Excel does.

Worked example

A courier business buys two delivery vans for ₹5,00,000 and expects extra cash of ₹1,50,000, ₹1,80,000, ₹2,00,000, ₹1,50,000, ₹1,00,000 over 5 years, the last including the resale value. The IRR is 17.93% a year. If the vans are bought with a loan at 12%, the investment earns more than it costs.

Checked against Excel

Microsoft's help page for the IRR function uses a business that costs 70,000 to start and earns 12,000, 15,000, 18,000, 21,000 and 26,000 in its first five years. This calculator gives the same answers.

Cash flowsExcel's answerThis calculator
After four years−2.1%-2.12%
After five years8.7%8.66%
After two years−44.4%-44.35%
Microsoft Support, IRR function, checked 16 November 2026

More business calculators

Questions people ask

How is IRR different from XIRR?

IRR assumes one cash flow at the end of each equal period. XIRR uses the exact date of each flow, which suits SIPs and irregular payments.

Can there be more than one IRR?

Yes, when the flows change from negative to positive and back again, for example a big repair in a later year. Each change of sign can add another rate where NPV is zero. The calculator warns you; in that case judge by NPV at your own rate.

What is a good IRR?

One comfortably above what the money costs you: the interest on the loan that funds it, or the return you could get elsewhere with similar risk. Small businesses usually want a wide gap, because forecasts of future cash are uncertain.

Why does the calculator show no answer?

IRR needs at least one negative and one positive flow. If every flow has the same sign, no rate makes NPV zero.

Need help with tax, GST or your accounts?

A tax professional can call you back. Asking is free.

Get help

More calculators

Results are estimates for information only, not financial or tax advice. Rates, rules and limits change, so check with your bank, employer or a qualified adviser before you decide.