IRR calculator

IRR Calculator | Internal Rate of Return Calculator

IRR Calculator: Evaluate Real Estate, Business & Investment Returns

Internal Rate of Return is the single discount rate that makes an investment’s net present value equal zero — the true compound return on a project with uneven cash flows over time. Use this calculator for real estate deals, business acquisitions, private equity, or any project where the cash you put in and what you get back happen at different times. Then review the hurdle-rate ranges and metric-comparison tables below to interpret your result like a professional.

Quick IRR Estimator

Enter your initial investment as a positive number — it’s treated as the outflow at Year 0. Add or remove cash flow years as needed. The result updates as you type.

Internal Rate of Return: — Enter cash flows to compute IRR

I. Typical IRR Hurdle Rates by Asset Class

A “good” IRR depends entirely on the risk and asset class of the deal. Use these benchmarks as the bar your project should clear before you commit capital.

Asset Class Typical IRR Range Risk Profile Notes
10-Year Treasury ~4% – 5% Risk-free baseline The minimum any risky project must beat
Investment-Grade Corporate Bonds ~5% – 6% Low Slight credit-spread premium over Treasuries
S&P 500 Long-Run ~9% – 10% Moderate (broad equity) Common public-market hurdle for any private deal
Stabilized Rental Real Estate ~10% – 15% Moderate / illiquid Single-family rentals, stabilized multifamily
Value-Add Commercial Real Estate ~15% – 20% High / illiquid Reposition / heavy renovation projects
Venture Capital Target ~25% – 30%+ Very high / power-law Compensates for high portfolio failure rate

II. IRR vs Other Return Metrics

IRR is powerful but not always the right answer. Knowing when to use NPV, ROI, CAGR, or MIRR instead is what separates sophisticated analysis from headline numbers.

Metric What It Measures Use When Key Caveat
IRR Annualized return rate that zeroes NPV Comparing deals with uneven cash flows Assumes reinvestment at IRR — often unrealistic
NPV Dollar value created at a chosen discount rate Choosing between mutually exclusive projects Requires you to pick the discount rate
ROI Total profit ÷ initial cost Quick gut-check, single-period deals Ignores time — $1.5× over 1yr ≠ $1.5× over 10yr
CAGR Pure compound annual growth rate, start to end Single in / single out (stocks, simple savings) Ignores any cash flows in between
MIRR IRR with an explicit reinvestment rate Sanity-checking high IRRs (> 20%) More conservative — usually 2–5% lower than IRR

Expert Tips for Professional IRR Analysis

  • Set Realistic Hurdle Rates: Compare your computed IRR to the right benchmark for the asset class — a 9% IRR is extraordinary for a Treasury and below market for value-add real estate. Always tie the hurdle rate to the deal’s risk profile, not the headline number.
  • Include Every Cash Flow: Capex, taxes, vacancy, transaction costs, management fees, and the final sale / exit must all appear in the cash-flow series. Missing capex alone routinely overstates real-estate IRRs by 200–400 bps.
  • Beware Multiple IRRs: Cash flows that flip sign more than once (outflow → inflow → outflow → inflow) can mathematically yield several valid IRRs. When a project has multiple sign changes, fall back to NPV at a fixed discount rate.
  • Watch the Reinvestment Assumption: IRR implicitly assumes interim cash flows can be reinvested at the IRR itself. For projects pencilling above ~20% IRR, this is rarely realistic — compute MIRR with a sensible reinvestment rate (e.g., the S&P 500 average) for a more honest read.
  • Run Sensitivity Analysis: Compute IRR for best-case, base-case, and worst-case scenarios — vary exit price, vacancy, and capex assumptions. If the deal still clears your hurdle in the worst case, your margin of safety is real.
  • Compare Like-for-Like Risk: A 14% IRR on a triple-net leased medical office is not the same as a 14% IRR on a ground-up condo development. Always normalize for risk profile and time horizon before declaring one deal “better.”

Methodology: IRR is computed by Newton-Raphson iteration on the standard NPV root Σ CFt / (1 + r)t = 0 for t = 0..n, with an initial guess of 10% and convergence tolerance of 1e-7. The solver bails out if cash flows are all the same sign (no IRR exists) or if the iteration diverges past ±1000%. Net Profit is the simple sum of all cash flows; Multiple of Money is total inflows ÷ initial outflow. This calculator does not adjust for risk, inflation, or reinvestment-rate realism — for the latter, prefer MIRR with an explicit reinvestment assumption.

Keep planning View All Financial Tools