Internal Rate of Return (IRR) Calculator

What is Internal Rate of Return — The PE Gold Standard?

The Internal Rate of Return (IRR) is the discount rate that forces the Net Present Value (NPV) of a project's entire cash flow timeline to exactly zero. It represents the annualized compounding yield of an investment that produces uneven, irregular cash flows over multiple periods. IRR is the primary metric used in Private Equity, Venture Capital, and corporate capital budgeting to rank competing investment opportunities.

Mathematical Foundation

0 = CF_0 + \frac{CF_1}{(1+IRR)^1} + \frac{CF_2}{(1+IRR)^2} + \cdots + \frac{CF_n}{(1+IRR)^n}

CF_0

= The initial capital outlay (entered as a negative number — cash leaving your account).

CF_n

= The net cash received in period n (positive for inflows, negative for additional capital calls).

IRR

= The unknown rate solved iteratively — the discount rate that balances all cash flows to NPV = 0.

Laws & Principles

The Hurdle Rate Gate: Calculating IRR alone is insufficient. You must compare it to the Hurdle Rate (usually WACC). If IRR > Hurdle Rate, the project creates value. If IRR < Hurdle Rate, the project destroys value. The IRR tells you the yield; the hurdle rate tells you if that yield is worth the risk.
The Sign-Change Requirement: IRR requires at least one negative cash flow and at least one positive cash flow. Without opposing cash directions, the polynomial equation has no real root — the calculator cannot find a breakeven discount rate.
The Reinvestment Assumption Flaw: Standard IRR assumes every interim cash flow is reinvested at the IRR rate itself. If your project yields 40% IRR but you reinvest interim cash at 4% in a savings account, the realized return is significantly lower than IRR suggests. Use MIRR to correct this.

Step-by-Step Example Walkthrough

" A real estate developer buys a lot for $100,000 (Year 0). The property generates $10k, $20k, $30k, $40k in Years 1–4, and is sold for $50k in Year 5. "

Total raw cash out: -$100,000.
Total raw cash in: $10k + $20k + $30k + $40k + $50k = $150,000.
The algorithm tests discount rates: 5% leaves NPV positive, 15% pulls NPV negative.
Newton-Raphson converges on 12.01% — the rate where NPV = $0.00.

Final Result: The project's IRR is 12.01%. Despite uneven, back-weighted cash flows, the developer earned the equivalent of a 12.01% annualized compounding return on their capital over 5 years.

Quick Answer: What does the IRR Calculator do?

The IRR Calculator processes an uneven timeline of capital investments and cash returns, then algorithmically solves for the single annualized percentage yield (IRR) that makes the project's Net Present Value equal zero. It tells you the compounding return you're earning on cash deployed across multiple years with irregular payouts.

The IRR Equation

Net Present Value Equilibrium

NPV = 0 = CF₀ + CF₁/(1+IRR)¹ + CF₂/(1+IRR)² + ... + CFₙ/(1+IRR)ⁿ

⚠ Polynomial Root — No Closed-Form Solution

Because IRR appears in every denominator raised to a different power, the equation is a polynomial that cannot be solved with algebra alone. The calculator uses Newton-Raphson iteration — guessing, checking, and refining until NPV converges to zero within a tolerance of $0.01.

Velocity vs Duration

✓ The Early Exit Win

Time Efficiency | Massive Yield

Deploy: Buy a niche tech company for $1M (Year 0: -$1,000,000).
Year 1: Operational optimization generates $100k free cash flow.
Year 2: Sell the company for $1.4M plus the $100k operating cash (Total Year 2: $1,500,000).

→ Raw profit: $600k. But getting your capital back in just 2 years creates a 30.6% IRR. The speed of return is what drives the extraordinary yield.

✗ The 20-Year Grind

Maximum Total Profit | Sluggish Annualized Yield

Deploy: Buy a commercial pipeline for $1M (Year 0: -$1,000,000).
Years 1–19: Steady $75k annual cash flow.
Year 20: Sell the aging pipeline for $800k, plus final $75k distribution.

→ Raw profit: $1.3M (more than double the tech exit). But spreading returns across 20 years yields only a 7.1% IRR. Duration dilutes compounding power.

IRR Benchmarks by Asset Class

Asset Class	Typical IRR Target	Risk Profile
Core Real Estate	6% – 10%	Stable occupancy, low leverage, predictable cash flows.
Value-Add Real Estate	12% – 18%	Renovation, lease-up risk, moderate leverage.
Private Equity Buyout	18% – 25%	Operational turnaround, high leverage, 5–7 year holds.
Venture Capital	25% – 40%+	High failure rate offset by outsized winners (power law).

Capital Allocation Best Practices

Do This

✓Include the terminal exit value. In private equity, the final-year cash flow combines operating cash plus the full sale proceeds. If you omit the exit, you're modeling an income stream without the capital return — dramatically understating IRR.
✓Use IRR alongside NPV. IRR tells you the percentage yield; NPV tells you the dollar value created. A project with 100% IRR on a $1,000 investment creates $1,000 of value. A 12% IRR on a $10M investment creates $1.2M. Always consider both metrics together.

Avoid This

✗Ignoring the multiple-IRR problem. If cash flows change signs more than once (e.g., invest, earn, spend again, earn again), the polynomial has multiple valid roots. Standard IRR picks one, but it may not reflect economic reality. Switch to MIRR for non-conventional cash flows.
✗Comparing IRR without considering scale. A teenager who flips a $10 purchase into $20 earns a 100% IRR. A fund that turns $100M into $140M over 7 years earns only 4.9% IRR. The percentage alone ignores position size — always review total dollar profit alongside IRR.

Frequently Asked Questions

What is the difference between IRR and ROI?

ROI measures total return as a simple percentage: (Gain − Cost) / Cost. It ignores time entirely — doubling your money shows as 100% ROI whether it took 1 year or 50 years. IRR factors in the time value of money, giving you an annualized compounding rate. A 100% ROI over 50 years translates to roughly 1.4% IRR; the same 100% over 6 months is an extraordinary 300%+ annualized IRR.

Why must the initial investment be entered as a negative number?

IRR models the directional flow of capital. Negative numbers represent cash leaving your account (investments). Positive numbers represent cash coming back (returns). The formula needs at least one outflow and one inflow to create opposing forces that can balance at a specific discount rate. Without both directions, there is no breakeven point to solve for.

When should I use MIRR instead of standard IRR?

Use Modified IRR (MIRR) in two situations: (1) when your cash flow timeline has multiple sign changes (e.g., invest in Year 0, earn in Years 1–3, spend again in Year 4, earn in Year 5), which can produce multiple valid IRR solutions; (2) when you want a more realistic return estimate by specifying the actual reinvestment rate for interim cash flows instead of assuming they compound at the IRR itself.

How do I compare two projects with different timelines using IRR?

IRR is already annualized, so a 15% IRR over 3 years is directly comparable to a 12% IRR over 10 years from a yield perspective. However, IRR alone does not capture total value creation. The 10-year project may generate far more absolute profit. Use IRR for ranking yield efficiency, and pair it with NPV to measure total dollar value created by each project.

Internal Rate of Return (IRR) Calculator

Internal Rate of Return (IRR) Calculator

Capital Allocation Timeline

Future Cash Flows (Inflows)