IRR Calculator
Find the internal rate of return for your investment.
For educational purposes only. This calculator does not provide investment advice.
π Visual Analysis
What This Calculator Does
The IRR Calculator computes the Internal Rate of Return β the discount rate at which the net present value of all cash flows equals zero. Enter the initial investment and projected annual cash flows to find the IRR. This metric helps evaluate whether an investment's return meets your requirements.
Formula
Where:
- r = Internal Rate of Return (the unknown being solved for)
- I = Initial investment
- CFt = Cash flow in year t
- t = Year number (1, 2, 3, ...)
Unlike NPV where you provide the discount rate, IRR solves for the rate itself. There is no closed-form algebraic solution β the calculator finds it numerically through iteration.
Input Fields Explained
Initial Investment ($)
The upfront cost of the investment. This is the cash outflow at time zero (today). Enter the total amount you need to spend to start the project.
Annual Cash Flows (comma-separated)
The projected cash inflows for each year, separated by commas. For example, "30000,35000,40000,45000,50000" represents five years of cash flows. Enter net cash flows (inflows minus outflows) for each period.
Example Calculation
You invest $100,000 in a project. Projected cash flows: $30,000, $35,000, $40,000, $45,000, $50,000 over 5 years.
IRR = the rate r where NPV = 0
Solving numerically: IRR ≈ 19.44%
Interpretation: The project's internal rate of return is approximately 19.44%. Whether this is acceptable depends on your required return. If your cost of capital is 10%, the project's IRR exceeds it by a comfortable margin. However, IRR alone does not tell you the dollar value created β for that, see the NPV.
How to Read the Result
The annualized percentage return of the investment based on the cash flow timing and amounts. Compare this to your required return or cost of capital β if IRR is higher, the investment may be worth pursuing. If lower, it does not meet your return threshold.
IRR answers “what return rate clears NPV to zero?” Run the same cash flows in the NPV Calculator at your hurdle rate to see dollar value created. Both metrics together reduce scale and reinvestment blind spots.
Common Mistakes
- Ignoring the multiple-IRR problem. When cash flows change sign more than once (e.g., additional capital required mid-project), there may be multiple IRR solutions or no real solution. In such cases, use NPV or Modified IRR (MIRR) instead.
- Comparing IRR across projects of different sizes. A high IRR on a small investment may create less total value than a moderate IRR on a large investment. Always consider the absolute dollar NPV alongside IRR.
- Assuming reinvestment at the IRR rate. The standard IRR calculation implicitly assumes interim cash flows are reinvested at the IRR rate. For high-IRR projects, this assumption is often unrealistic. MIRR addresses this by using a separate reinvestment rate.
- Overestimating cash flow projections. IRR is only as good as the cash flow estimates. Small changes in later cash flows can significantly change the IRR. Use conservative estimates and run sensitivity analysis.
- Treating IRR as a guaranteed return. IRR is a mathematical calculation based on assumptions. It does not guarantee actual future performance.
When This Calculator Is Useful
- Evaluating the return of a capital investment project
- Comparing the percentage returns of different investment opportunities
- Determining whether a project meets a required return threshold
- Assessing private equity or venture capital deal returns
Limitations
- May produce multiple or no real solutions for non-conventional cash flows
- Does not reflect the absolute dollar value created β use NPV for that
- Assumes reinvestment of interim cash flows at the IRR rate
- Cannot reliably rank mutually exclusive projects of different scales
- Sensitive to small changes in cash flow estimates, especially in later years
- This calculator is for educational purposes only and does not constitute investment advice
Frequently Asked Questions
What is IRR?
IRR (Internal Rate of Return) is the discount rate that makes the Net Present Value (NPV) of all future cash flows equal to zero. It represents the annualized percentage return of an investment based on the timing and magnitude of its cash flows. If the IRR exceeds your required rate of return or cost of capital, the investment may be worth considering.
What is a good IRR?
There is no single good IRR β what counts as acceptable depends on the risk of the investment, the available alternatives, and your own required return. A project with higher risk should have a higher IRR to justify that risk. Always compare the IRR to your specific hurdle rate or cost of capital rather than relying on industry rules of thumb.
Can IRR be negative?
Yes. A negative IRR means the investment loses money on an annualized basis β the total cash flows received are less than the initial investment. This indicates the project does not recover the invested capital.
What is the difference between IRR and NPV?
NPV gives you an absolute dollar amount of value created at a specific discount rate. IRR gives you the percentage return at which the NPV equals zero. NPV is generally preferred for comparing projects of different sizes because it accounts for scale, while IRR can be misleading when cash flows are non-conventional (e.g., negative cash flows in the middle of a project).
Can IRR be misleading?
Yes. IRR can produce multiple solutions when cash flows change sign more than once (for example, a project that requires additional investment midway). It also assumes that interim cash flows are reinvested at the IRR rate, which may be unrealistic. Additionally, IRR does not account for project scale β a 50% IRR on $100 is less valuable than a 20% IRR on $1,000,000.
π§ Related Calculators
Educational Disclaimer
This calculator is for educational and informational purposes only. It does not provide investment, financial, tax, or legal advice. The results are based on the inputs and assumptions you provide and may not reflect real market conditions, fees, taxes, or risks. Always do your own research or consult a qualified professional before making financial decisions.