Internal Rate of Return (IRR) Calculator
Cash Flows by Year
Enter positive cash inflows for each year
Step-by-Step Calculation
Enter your investment details and cash flows above to see a complete IRR analysis.
| Year | Cash Flow | Discount Factor | Present Value | Cumulative PV |
|---|
Your guide to internal rate of return
The Internal Rate of Return (IRR) is a key financial metric used to evaluate the profitability of an investment. It is the discount rate that makes the net present value of all cash flows equal to zero. In simple terms, IRR is the annualized rate of return that an investment is expected to generate. It helps investors compare different investment opportunities and make informed decisions.
What is internal rate of return?
The Internal Rate of Return is the rate at which an investment breaks even in terms of net present value. It is the annual return you expect to earn from an investment. A higher IRR means a more desirable investment. IRR is widely used in capital budgeting, real estate analysis, and private equity to evaluate the potential return of projects.
The IRR concept
The IRR is found by solving the equation:
Unlike NPV, which gives you a dollar value, IRR gives you a percentage return. This makes it easy to compare investments of different sizes and timeframes.
IRR decision rules
- IRR > Hurdle Rate: ✅ Accept the investment. It creates value above the required return.
- IRR = Hurdle Rate: ⚞ Neutral. The investment breaks even.
- IRR < Hurdle Rate: ❌ Reject the investment. It fails to meet the required return.
The hurdle rate is the minimum acceptable rate of return, often based on the cost of capital or risk level.
IRR comparison at different cash flow patterns
Here's how different cash flow patterns affect the IRR for a $50,000 investment:
| Scenario | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | IRR |
|---|---|---|---|---|---|---|
| Steady Cash Flows | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | 15.24% |
| Growing Cash Flows | $10,000 | $15,000 | $20,000 | $25,000 | $30,000 | 22.40% |
| Decreasing Cash Flows | $30,000 | $25,000 | $20,000 | $15,000 | $10,000 | 27.35% |
| Back-End Loaded | $5,000 | $10,000 | $15,000 | $20,000 | $50,000 | 19.31% |
Higher cash flows in earlier years generally lead to higher IRR, as money received sooner has more time to grow.
IRR vs NPV comparison
Here's a comparison of two investment options using both IRR and NPV (at 8% discount rate):
| Metric | Investment A | Investment B | Better Option |
|---|---|---|---|
| Initial Investment | $100,000 | $100,000 | — |
| Total Cash Inflows | $150,000 | $160,000 | B |
| IRR | 12.5% | 10.2% | A |
| NPV (at 8%) | $18,500 | $15,200 | A |
| Payback Period | 4.2 years | 3.8 years | B |
| Decision: Investment A has higher IRR and NPV | |||
In this example, Investment A is better because it has both higher IRR and higher NPV, meaning it creates more value and offers a better return.
How to use this calculator
- Set your currency: Type your preferred symbol (e.g., $, €, £, ₹).
- Enter initial investment: The amount you're investing (enter as negative value).
- Enter cash flows: Add the expected cash inflows for each year.
- Enter hurdle rate (optional): Your required minimum rate of return.
- Click calculate: See your IRR, NPV at IRR, PI, payback period, and decision.
Understanding your results
- IRR: The annualized rate of return your investment is expected to earn.
- NPV at IRR: Should be approximately zero (confirms the IRR calculation).
- Profitability Index: PV of positive cash flows divided by initial investment.
- Payback Period: How long it takes to recover the initial investment.
- Decision: Accept or reject based on the hurdle rate comparison.
- Yearly breakdown: Shows cash flows, discount factors, and present values.
Example: Evaluating a business investment
You are considering investing $50,000 in a small business. The projected annual cash flows are $15,000, $18,000, $20,000, $22,000, and $25,000 over 5 years. Your required rate of return (hurdle rate) is 8%.
- Initial Investment: -$50,000
- Cash Flows: $15k, $18k, $20k, $22k, $25k
- Hurdle Rate: 8%
IRR = 18.47%
NPV at IRR ≈ $0
PI = 1.27
Payback Period: ~3.1 years
Decision: ✅ Accept. The IRR of 18.47% exceeds the 8% hurdle rate, indicating this investment will create significant value.
When to use IRR
- Capital budgeting: Evaluating business projects and investments.
- Real estate: Analyzing rental property or development projects.
- Private equity: Assessing the return on private investments.
- Startup analysis: Evaluating new business ventures.
- Comparing investments: Choosing between multiple investment options.
Common mistakes to avoid
- Using IRR alone: Always consider NPV alongside IRR for a complete picture.
- Multiple IRRs: Unconventional cash flows can produce multiple IRRs.
- Ignoring scale: A high IRR on a small investment may be less valuable than a lower IRR on a larger investment.
- Comparing IRRs without considering timing: Early cash flows are more valuable than late cash flows.
- Not using a hurdle rate: Always compare IRR to a reasonable required return.
Final thoughts
The Internal Rate of Return is one of the most widely used metrics in investment analysis. It provides a clear, percentage-based measure of an investment's profitability, making it easy to compare different opportunities. By using this calculator, you can quickly evaluate investment opportunities and make smarter financial decisions. Remember, a high IRR combined with a positive NPV is the hallmark of a great investment.