IRR Calculator
Compute Internal Rate of Return (IRR), hurdle rate spreads, and NPV sensitivity curves for multi-year cash flows.
Client-Side Execution & Privacy Guarantee
Calculations run locally in your web browser. The amounts, rates, and other figures you enter are not sent to our servers. This calculator is for educational estimates only and is not personalized financial advice.
The Internal Rate of Return (IRR) Calculator is a vital financial modeling tool used to estimate the profitability of potential investments. IRR is the annualized effective compounded return rate that makes the net present value (NPV) of all cash flows (both positive and negative) from a particular investment equal to zero. It provides a single percentage figure to evaluate an investment's yield.
Please note that Codepackr Finance offers this calculator for educational and preliminary analysis purposes. While IRR is a powerful metric, it has limitations, particularly with non-conventional cash flows. The results are estimates based on your inputs and should not replace professional financial advice or comprehensive investment due diligence. This content is for informational purposes only and is not financial advice.
What is the Internal Rate of Return?
The Internal Rate of Return (IRR) is a metric used in capital budgeting to estimate the profitability of potential investments. It is a discount rate that makes the net present value (NPV) of all cash flows equal to zero. In simpler terms, it's the expected compound annual rate of return that will be earned on a project or investment.
When analyzing a project, if the calculated IRR exceeds the company's required rate of return (often called the hurdle rate or cost of capital), the project is generally considered acceptable. If it falls below the hurdle rate, the project is typically rejected.
Comparing IRR and Hurdle Rates
The hurdle rate is the minimum acceptable return on an investment. The spread between the IRR and the hurdle rate indicates the safety margin of the project. A wider spread suggests a more robust investment that can withstand variations in actual cash flows compared to projections.
It is important to remember that IRR assumes that all intermediate cash flows are reinvested at the IRR itself. This assumption can sometimes be unrealistic, especially for projects with exceptionally high IRRs, as it may be difficult to find other investments offering that same high rate of return.
Limitations of IRR
While IRR is popular because a percentage return is easy to understand, it has significant limitations. It does not account for project size. A small project might have a higher IRR than a large project, but the large project might generate more absolute wealth (higher NPV).
Furthermore, if a project has alternating positive and negative cash flows (non-conventional cash flows), the calculation can result in multiple IRRs or no IRR at all. In such cases, relying solely on IRR can lead to incorrect investment decisions, and Modified Internal Rate of Return (MIRR) or NPV should be used instead.
When to use this calculator
- Comparing the relative profitability of different investment opportunities.
- Evaluating private equity or venture capital returns.
- Assessing the yield of a real estate investment property over time.
- Determining if a new business project meets a company's required hurdle rate.
- Analyzing the return on a bond held to maturity.
How to use the IRR Calculator
- Enter the initial investment amount as a negative number in Period 0.
- Input the projected cash flows for each subsequent period (years or months).
- Ensure you use positive numbers for cash inflows (revenue, dividends) and negative numbers for outflows (additional investments).
- Optionally, input a hurdle rate or cost of capital to compare against the calculated IRR.
- Review the calculated Internal Rate of Return.
- Analyze the hurdle rate spread if a hurdle rate was provided.
- Check the NPV sensitivity curve to see how the project's value changes at different discount rates.
Worked examples
Standard Capital Project
Input
Initial Outlay: -₹2,00,000, Year 1: ₹50,000, Year 2: ₹70,000, Year 3: ₹1,00,000, Year 4: ₹60,000
Output
IRR: 14.17%.
The annualized internal rate of return on −₹2,00,000, then ₹50,000, ₹70,000, ₹1,00,000 and ₹60,000, is about 14.17%. Compare that rate with a project’s cost of capital only as an educational screen, not as investment advice.
Real Estate Flip
Input
Purchase & Rehab: -₹50,00,000, Year 1 Rental Income: ₹2,00,000, Year 2 Sale Net Proceeds: ₹60,00,000
Output
IRR: 11.56%.
Combining ₹2,00,000 of year-1 rent with a ₹60,00,000 year-2 net sale against a ₹50,00,000 outlay produces an IRR of about 11.56%. Property costs, taxes, and vacancy can change the result.
Common mistakes and tips
- Always use a negative value for the initial investment.
- Do not use IRR to compare mutually exclusive projects of vastly different sizes; use NPV instead.
- Be cautious if your cash flows switch between positive and negative multiple times, as this can produce multiple IRRs.
- Remember the reinvestment assumption: IRR assumes interim cash flows earn the same high rate, which may not be realistic.
- These figures are educational estimates; consult a financial advisor for official investment analysis.
Frequently asked questions
What is a 'good' IRR?
A 'good' IRR depends entirely on the risk of the investment and the investor's required rate of return (hurdle rate). It must be higher than the cost of capital. An IRR of 8% might be excellent for a low-risk bond but terrible for a high-risk venture capital investment.
Why did the calculator return an error or multiple IRRs?
If cash flows alternate between positive and negative (e.g., you invest, get returns, then have to invest more capital later), the mathematical polynomial can have multiple roots, meaning there are multiple valid IRRs. In these cases, IRR is not a reliable metric.
Should I rely on IRR or NPV?
While IRR is useful for understanding the percentage return, NPV is generally considered the superior metric because it measures the absolute increase in wealth and does not rely on unrealistic reinvestment rate assumptions.
Can IRR be negative?
Yes. If the total sum of the cash inflows is less than the total cash outflows over the life of the investment, the IRR will be negative, indicating a loss.
How does the hurdle rate work with IRR?
The hurdle rate is your benchmark. If the IRR is greater than the hurdle rate, the investment is theoretically sound. If the IRR is less than the hurdle rate, the investment destroys value and should be rejected.
Related Business Finance Calculators
- NPV Calculator — Calculate Net Present Value (NPV), Profitability Index (PI), and discounted cash flow paybacks for capital investments.
- Break-Even Calculator — Determine unit and revenue break-even thresholds, contribution margin ratios, and margin of safety buffers.
- Business Valuation Calculator — Estimate enterprise and equity fair market values across conservative, base, and optimistic multiples for Revenue, EBITDA, and SDE.
- DCF Valuation Calculator — Model discounted cash flows (DCF), forecast free cash flows, terminal values via Gordon Growth and exit multiples, and equity value per share.
- WACC Calculator (Cost of Capital) — Calculate Weighted Average Cost of Capital (WACC), CAPM cost of equity, after-tax cost of debt, and interest tax shield benefits.
- Startup Valuation Calculator — Triangulate pre-revenue and seed-stage startup valuations using Dave Berkus, Payne Scorecard, and Venture Capital (VC) methods.
- Burn Rate & Runway Calculator — Calculate gross burn, net burn, cash runway in months, zero cash dates, and Paul Graham Default Alive status for startups.