$29,078.68
1.291
x
3.96
years
$175,000.00
$75,000.00
$29,078.68
1.291
x
3.96
years
$175,000.00
$75,000.00
The IRR Calculator (Internal Rate of Return) finds the discount rate at which the Net Present Value (NPV) of an investment equals zero. In other words, IRR is the break-even rate of return — the annual percentage return an investment is expected to generate over its lifetime.
IRR is one of the most widely used metrics in capital budgeting, private equity, real estate, and venture capital. The decision rule is straightforward: if IRR > hurdle rate (cost of capital), accept the project; if IRR < hurdle rate, reject it. The hurdle rate represents the minimum acceptable return, typically equal to the company's WACC or an investor's required return.
Unlike NPV, which gives a dollar amount, IRR gives a percentage return that is intuitive and easy to compare across investments of different sizes. A real estate project with an IRR of 18% is directly comparable to a stock investment yielding 12% or a bond paying 5%. This makes IRR the preferred metric for many investors, particularly in private equity where IRR is the standard performance benchmark.
Mathematically, IRR is found by solving the equation: 0 = -Investment + CF1/(1+IRR) + CF2/(1+IRR)^2 + ... + CFn/(1+IRR)^n. This equation generally cannot be solved algebraically and requires iterative numerical methods. Our calculator uses a bisection method that converges to the correct IRR within 100 iterations, providing accuracy to several decimal places.
While IRR is powerful and intuitive, it has important limitations. Projects with non-conventional cash flows (alternating positive and negative) can produce multiple IRRs, making interpretation ambiguous. IRR also implicitly assumes that intermediate cash flows are reinvested at the IRR itself, which may be unrealistic for very high IRR projects. For these reasons, many finance professionals prefer Modified IRR (MIRR) or use IRR alongside NPV for investment decisions.
Private equity firms typically target gross IRRs of 20-30% on their investments, with net IRRs (after fees) of 15-20%. Real estate investments target 10-15% IRR, while venture capital aims for 25-40%+ given the higher risk profile.
IRR is the rate r that satisfies: 0 = -Initial Investment + CF1/(1+r) + CF2/(1+r)^2 + ... + CF5/(1+r)^5
This calculator uses the bisection method: it iteratively narrows the range between low and high rate guesses until the NPV at the midpoint is sufficiently close to zero.
Decision: If IRR > Hurdle Rate, the investment exceeds the required return (Accept). If IRR < Hurdle Rate, it falls short (Reject).
An IRR above your hurdle rate indicates the investment generates returns exceeding your cost of capital — it should be accepted. The higher the IRR above the hurdle, the greater the margin of safety. The NPV at the hurdle rate shows the dollar value created. Decision output: 1 = Accept, 0 = Reject.
Inputs
Results
IRR of 17.34% > 10% hurdle = Accept
Inputs
Results
IRR of 7.92% < 12% hurdle = Reject
It depends on the investment type. Public equities average 8-10%, real estate targets 10-15%, private equity aims for 20-30%, and venture capital targets 25-40%+. The IRR should exceed the investor's hurdle rate (opportunity cost of capital).
ROI is a simple total return percentage that ignores timing. IRR is an annualized return that accounts for when cash flows occur. A project returning 50% over 5 years has a 50% ROI but only about 8.5% IRR.
Yes. A negative IRR means the investment returns less than the initial cost — it destroys value. For example, investing $100,000 and recovering only $80,000 over 5 years would produce a negative IRR.
IRR assumes intermediate cash flows are reinvested at the IRR itself. If the IRR is 25%, it assumes all cash flows can be reinvested at 25%, which may be unrealistic. MIRR addresses this by using a more realistic reinvestment rate.
When cash flows change signs more than once (e.g., initial outflow, inflows, then another outflow), the NPV equation can have multiple solutions. This occurs in projects with significant decommissioning costs or deferred capital expenditures.
NPV is theoretically superior because it directly measures value creation and handles scale differences correctly. However, IRR is more intuitive and widely used. Best practice: use both together, and rely on NPV when they conflict.
The hurdle rate is the minimum acceptable rate of return for an investment, typically set at the company's WACC or the investor's opportunity cost. Projects must exceed the hurdle rate to be approved. PE firms often use 8% as a preferred return hurdle.
Use the =IRR(values) function where values is the range of cash flows starting with the negative initial investment. For example: =IRR({-100000, 25000, 30000, 35000, 40000, 45000}).
Unlevered IRR measures project returns without debt financing (using total capital). Levered IRR measures returns to equity investors after debt service. Levered IRR is higher because leverage amplifies returns (and losses).
Real estate investors use IRR to compare properties accounting for purchase price, rental income, operating expenses, capital improvements, and eventual sale. A typical target IRR for commercial real estate is 12-18%.
Roboculator Team
The Roboculator Team explains calculations, planning tools, and practical formulas in clear language for real-life situations.
How helpful was this calculator?
Be the first to rate!
Business Valuation Calculator
Business & Corporate Finance Calculators
Startup Valuation Calculator
Business & Corporate Finance Calculators
DCF Calculator (Discounted Cash Flow)
Business & Corporate Finance Calculators
NPV Calculator (Net Present Value)
Business & Corporate Finance Calculators
MIRR Calculator
Business & Corporate Finance Calculators
Payback Period Calculator
Business & Corporate Finance Calculators
