IRR Calculator - Internal Rate of Return
Find the discount rate that makes an investment’s net present value equal to zero.
Enter the initial cash flow as a negative amount, comma-separated future cash flows, and optional solver tolerance and iteration limit.
IRR Calculator - Internal Rate of Return
Find the discount rate that makes an investment’s net present value equal to zero.
About Internal Rate of Return
Internal rate of return is the discount rate that sets an investment’s net present value to zero. If you pay cash today and collect cash later, IRR is the constant annual yield that makes those flows break even in present-value terms. Capital-budgeting teams compare IRR with a hurdle rate; private-market investors use it to summarize a deal; students use it to see why timing matters as much as the total dollars received.
The IRR calculator solves 0 = initial investment + Σ(cash flow in period t ÷ (1 + r)^t) with bisection. Enter the initial outlay as a negative number and later inflows as a comma-separated list in time order. With −$100,000 followed by $30,000, $35,000, $40,000, $45,000, and $50,000, IRR is about 25.75%. Level $15,000 receipts for five years on a −$50,000 outlay produce about 15.24%. Because later cash is discounted more, a back-loaded stream needs larger late receipts to match an even stream’s IRR.
NPV at the solved rate should be near zero; that is a numerical check, not a second performance measure. Total future cash flows and net cash gain ignore time value and will look more generous than IRR when receipts arrive late. Multiple sign changes can produce multiple real roots; the solver looks for a root between −99.99% and 1,000% and returns nothing if the NPV does not change sign.
IRR assumes cash flows can be reinvested at the same rate, which is often unrealistic for very high IRRs. It also says nothing about scale: a tiny project can outrank a large one on IRR and still create less wealth. Compare IRR with NPV at your cost of capital, and do not treat a solved rate as a guaranteed yield. The calculator is a planning identity, not an appraisal of risk, leverage, or accounting earnings.
IRR Calculator Worked Examples
Use these worked scenarios to check inputs and understand how the estimate responds.
| Inputs | Result | Interpretation |
|---|---|---|
| −$100,000 initial investment; $30,000, $35,000, $40,000, $45,000, $50,000 annual flows | IRR about 25.75% | The return reflects both the size and timing of cash receipts. |
| −$50,000 initial investment; $15,000 for five years | IRR about 15.24% | Equal cash flows form a level annual annuity. |
| −$200,000 initial investment; $20,000, $40,000, $80,000, $120,000, $150,000 | IRR about 21.48% | Later cash flows receive more discounting. |
How to Calculate Internal Rate of Return
- Enter the initial investment as a negative outflow, such as -100000.
- Enter later cash flows in order, separated by commas, using negative numbers for additional outflows.
- Leave tolerance and max iterations at the defaults unless a cash-flow set fails to converge.
- Select Calculate and confirm that NPV at the reported IRR is essentially zero before you rely on the rate.
IRR Calculator FAQ
Why must the initial investment be negative?
IRR is defined on a signed cash-flow series. The opening outlay is cash leaving you, so it must be negative. Positive inflows later create the sign change the solver needs.
What if the IRR calculator returns no result?
Usually every trial NPV has the same sign, so there is no root in the search range. Check that the initial outlay is negative and that later flows are large enough, in total, to recover the investment.
Is IRR the same as ROI or CAGR?
No. ROI ignores timing. CAGR describes a starting and ending value. IRR is the rate that zeros NPV for the whole dated series, including interim flows.
Can a project have more than one IRR?
Yes, if the cash-flow signs change more than once. The bisection search returns one root in a wide interval and can miss another. Unusual financing patterns should be checked with an NPV profile.
Should I accept a project just because IRR exceeds the hurdle rate?
Not by itself. IRR does not show dollar value created, can rank mutually exclusive projects poorly, and assumes reinvestment at the IRR. Use NPV at the cost of capital as the wealth test.