IRR Calculator
Calculate the Internal Rate of Return for an investment using Newton-Raphson iteration.
| Discount Rate | NPV | Decision |
|---|
Calculate the Internal Rate of Return for a series of cash flows using Newton-Raphson iteration, along with payback period and NPV at several discount rates.
How IRR Calculator Works
IRR is the discount rate at which the Net Present Value (NPV) of a series of cash flows equals exactly zero. Since there's no direct algebraic formula to solve for it, the calculator uses Newton-Raphson iteration — starting from an initial guess, repeatedly refining the rate based on how far NPV is from zero and how sensitive NPV is to a rate change, until it converges on the answer.
Your initial investment is treated as a negative cash flow at time zero, and each subsequent year's cash flow is discounted back using NPV = Σ CFₜ ÷ (1+r)ᵗ. The IRR that satisfies this equation represents the annualized rate of return the investment actually generates, accounting for both the timing and size of each cash flow.
The NPV table shows how the same cash flow series performs at several common discount rates (5% to 15%) — a positive NPV at your required rate of return signals the investment clears your hurdle rate, while a negative NPV signals it falls short, which is often used alongside IRR as a second decision check.
See It In Action
Who Uses IRR Calculator and Why
- Evaluating a business investment or project with an upfront cost and a series of expected future cash inflows.
- Comparing a calculated IRR against your required rate of return (hurdle rate) to decide whether an investment clears the bar.
- Checking NPV at several common discount rates to see how sensitive an investment\'s attractiveness is to your assumed rate.
- Comparing the payback period alongside IRR to weigh both how profitable and how quickly capital-recovering an investment is.
Mistakes to Avoid
- Treating IRR as a simple average return — it explicitly accounts for the timing of each cash flow, not just the total, so two investments with the same total return but different cash flow timing can have meaningfully different IRRs.
- Comparing IRR across investments without also considering risk — a higher IRR doesn\'t automatically mean a better investment if it comes with substantially higher risk; the hurdle rate you compare against should reflect that risk.
- Forgetting the initial investment is treated as a negative cash flow at time zero — leaving it out, or entering it as a positive number, will produce a meaningless or wildly incorrect IRR result.
Tips for Best Results
- Use the NPV table at several discount rates as a second check alongside IRR, especially for cash flow series where IRR alone might be less intuitive to interpret.
- If two projects have similar IRRs, the payback period shown alongside it can help distinguish which one returns your capital faster, which matters if liquidity or risk timing is a concern.
Fixing Common Problems
My IRR result seems too high or unrealistic. — Double check that your initial investment is entered as a negative value and that every cash flow is in the correct year and sign — a sign or ordering error in the cash flow series is the most common cause of an IRR result that looks off.
Terms Explained
IRR (Internal Rate of Return): The discount rate at which the Net Present Value of a series of cash flows equals exactly zero.
Hurdle rate: Your required minimum rate of return for an investment to be considered worthwhile — compared against the calculated IRR to judge whether a project clears the bar.