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.
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 flows | Excel's answer | This calculator |
|---|---|---|
| After four years | −2.1% | -2.12% |
| After five years | 8.7% | 8.66% |
| After two years | −44.4% | -44.35% |
More business calculators
- Business and accounting calculators
- Break-even calculator
- Gross profit calculator
- EBITDA calculator
- ROI calculator
- NPV calculator
- Payback period calculator
- Working capital calculator
- Current ratio calculator
- Quick ratio calculator
- Debt to equity ratio
- Inventory turnover calculator
- Debtor days calculator
- Depreciation calculator
- Cash flow forecast
- Accounting basics
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.
A tax professional can call you back. Asking is free.
Get helpMore 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.