Internal Rate of Return is one of the most widely cited metrics in investment analysis and one of the most frequently misapplied. In corporate finance, private equity, real estate, and infrastructure investing, IRR drives capital allocation decisions worth billions. Yet the metric has fundamental mathematical properties that cause it to give the wrong answer in specific — and common — situations.
Understanding IRR properly means understanding not just how to calculate it, but where the reinvestment assumption comes from, what Modified IRR corrects, how private equity firms use and sometimes manipulate it, and precisely when NPV is the more reliable guide.
👉 Calculate IRR instantly with the free NPV & IRR Calculator
IRR is the discount rate at which the Net Present Value of all cash flows from an investment equals zero. In equation form:
0 = −C₀ + CF₁/(1+IRR)¹ + CF₂/(1+IRR)² + … + CFₙ/(1+IRR)ⁿ
There is no algebraic solution to this equation for most cash flow series. IRR cannot be calculated by rearranging the formula and solving directly. Instead it requires iterative numerical methods — the algorithm starts with a guess, evaluates the NPV at that rate, adjusts the guess based on whether NPV is positive or negative, and repeats until it converges on the rate that produces NPV = 0.
This iterative nature has a practical consequence that most introductory explanations skip: IRR is not a formula you apply. It is a rate you solve for. Spreadsheet functions like =IRR() and =XIRR() and calculators like the one on this site do the numerical solving automatically, but the underlying process is trial and error guided by Newton-Raphson or bisection methods, not algebra.
This matters because it explains why IRR sometimes fails — certain cash flow patterns produce equations with multiple solutions, or no solution at all.
IRR implicitly assumes that every cash flow generated by the investment during its life is immediately reinvested at the same rate as the IRR itself.
This assumption is embedded in the mathematics. When you discount all future cash flows at the IRR to make NPV equal zero, you are implicitly assuming that each interim cash flow compounds forward at the IRR until the end of the project. If the IRR is 22%, you are assuming that the cash received in year 2 can be invested at 22% for the remaining life of the project.
For most investments, this is unrealistic. A project generating 22% returns is exceptional. Expecting to reinvest its interim cash flows at 22% continuously assumes you have a pipeline of equally exceptional projects waiting. In practice, reinvestment typically happens at a rate closer to the company’s cost of capital or the market rate available at the time — substantially lower.
The reinvestment assumption creates systematic upward bias for projects with high IRRs. The higher the IRR, the more inflated the metric becomes relative to the return the investor will actually earn when realistic reinvestment rates are applied.
Consider two projects, each requiring a $100,000 investment:
Project A: Generates $30,000 per year for 5 years. IRR = 15.2% Project B: Generates $3,000 in years 1–4, then $180,000 in year 5. IRR = 15.8%
IRR says Project B is better. But Project A generates substantial cash in years 1–4 that can be reinvested. If that reinvestment earns even 8%, Project A’s effective return exceeds Project B’s over the full period. IRR ignores this — it assumes Project A’s interim cash flows compound at 15.2%, which inflates its apparent return.
The correct comparison requires either NPV (which captures total value creation directly) or Modified IRR, which uses an explicit reinvestment rate assumption.
Modified Internal Rate of Return was developed specifically to address the reinvestment assumption problem. It uses two rates:
The MIRR formula calculates the future value of all positive cash flows compounded at the reinvestment rate to the end of the project, and the present value of all negative cash flows discounted at the finance rate to the beginning. It then solves for the single rate that equates the two.
MIRR = (FV of positive cash flows / PV of negative cash flows)^(1/n) − 1
Using MIRR with a reinvestment rate equal to the cost of capital produces a more conservative and realistic estimate of return. For most corporate projects, MIRR will be lower than IRR — sometimes materially so for high-IRR investments.
MIRR also solves the multiple IRR problem (covered below), always producing a single value regardless of cash flow sign changes. In Excel, =MIRR(cash flows, finance rate, reinvestment rate) calculates it directly.
Despite its theoretical superiority, MIRR is less widely used in practice than IRR, primarily because it requires two additional input assumptions (the finance and reinvestment rates) that introduce their own uncertainty. IRR’s simplicity — one number derived entirely from the project’s own cash flows — makes it easier to communicate and compare. Understanding the reinvestment assumption allows a user to interpret IRR intelligently rather than needing to replace it with MIRR in every situation.
Descartes’ rule of signs states that the maximum number of positive real roots of a polynomial equals the number of sign changes in its coefficients. A cash flow series is a polynomial in (1+IRR). Every time the cash flows change sign — from negative to positive, or positive to negative — an additional IRR solution may exist.
Most conventional projects have one sign change: negative initial investment, then positive cash flows. These have at most one positive IRR, and the standard calculation is reliable.
Non-conventional cash flows produce multiple sign changes and therefore potentially multiple IRR values:
Example: A mining project requires a $500,000 initial investment (negative), generates positive cash flows for 8 years, then requires a $300,000 environmental remediation payment in year 9 (negative), followed by a positive terminal land sale in year 10.
Sign changes: negative → positive → negative → positive = three changes = potentially three IRR solutions. A solver may find 6%, 14% or 22% depending on the starting point — all three are mathematically valid solutions to the IRR equation. None of them is the definitive “return” of the project.
When this situation arises, IRR is not just imprecise — it is meaningless. NPV at the relevant discount rate is the correct analytical tool. The NPV is always a single, interpretable number regardless of cash flow complexity.
Private equity funds use IRR as their primary performance metric almost universally. Understanding why requires understanding the specific context of PE investing, and understanding the limitations requires knowing how the metric can be presented favourably without technically misrepresenting it.
Private equity funds invest capital over time — initial investment, follow-on investments, and eventual exit over a 5–10 year horizon. Cash flows are highly irregular: large outflows when investments are made, large inflows when companies are sold. IRR captures the time-weighted value of these irregular cash flows in a way that simple return metrics cannot.
More practically, IRR allows fund managers to communicate returns in a format comparable to other asset classes — “our fund generated a 22% IRR” is immediately understandable to an allocator who evaluates bonds at 5% or equity at 12%.
Private equity professionals use IRR alongside MOIC — Multiple on Invested Capital — which simply measures the total return as a multiple: if you invested $10 million and received $25 million back, MOIC = 2.5x.
The tension between IRR and MOIC reveals something important about time. A 2.5x MOIC in 3 years represents an IRR of approximately 36%. The same 2.5x MOIC in 7 years represents an IRR of only 14%. IRR rewards speed of return. MOIC rewards absolute magnitude.
A fund that returns modest multiples quickly can show a high IRR. A fund that builds substantial value over a longer period shows a lower IRR despite potentially greater wealth creation. Neither metric alone is sufficient. Sophisticated investors evaluate both.
Several legitimate practices improve reported IRR metrics without changing the actual performance of underlying investments:
Subscription credit facilities. Instead of calling capital from investors when an acquisition closes, the fund borrows through a credit facility and delays the capital call. The investment starts generating returns before investor capital is deployed. This reduces the effective holding period in the IRR calculation and raises the reported IRR — sometimes by several percentage points — without changing the underlying return on the business.
Vintage year timing. IRR is highly sensitive to when the initial cash outflow occurs. Funds that invested at the trough of a cycle report substantially higher IRRs than funds with identical underlying performance that invested at the peak, purely because of the timing difference.
Distribution timing. Returning capital early in the fund’s life maximises IRR regardless of whether the exits were at optimal valuations. A fund that sells its best companies early to boost IRR may be sacrificing MOIC and long-term value creation.
Recognising these dynamics does not imply misconduct. They are features of how IRR interacts with timing. But an investor evaluating PE fund performance using IRR alone is missing the full picture that MOIC and investment holding period analysis would provide.
Real estate investment analysis uses IRR extensively, but introduces a distinction that is critical to interpretation: levered IRR vs unlevered IRR.
Unlevered IRR treats the property as if purchased entirely with equity — no mortgage, no debt. Cash flows include rental income, operating expenses, capital expenditure and eventual sale proceeds. The initial investment is the full purchase price.
Unlevered IRR measures the return the property itself generates, independent of how it is financed. It allows properties to be compared on an equal footing regardless of capital structure.
Levered IRR uses only the equity invested — the down payment plus any additional equity contributions — as the initial investment. Cash flows are reduced by debt service (mortgage payments), and the final sale proceeds are reduced by the outstanding loan balance.
Leverage amplifies returns when the property generates more than the cost of the debt. A property with a 7% unlevered IRR financed at 60% LTV with a 4% mortgage rate might generate a 12–14% levered IRR, because the equity portion benefits from the spread between the property’s return and the financing cost.
Leverage also amplifies losses. The same property in a down scenario could produce a deeply negative levered IRR even if the unlevered IRR is modestly negative.
Like PE, real estate analysis uses a return multiple — the equity multiple or equity on equity — alongside IRR to capture both efficiency and magnitude of return. A 15% levered IRR on a 2-year hold and a 15% levered IRR on a 7-year hold are different outcomes entirely from a wealth-creation perspective.
Standard IRR assumes equally spaced cash flow periods — annual, quarterly or monthly intervals of identical length. Real investments rarely match this assumption. An acquisition closes on a specific date, rental income arrives mid-month, a property sells at an irregular interval.
XIRR extends IRR to handle cash flows with actual calendar dates. Rather than assuming equal periods, XIRR discounts each cash flow based on its exact time distance from the initial investment date, measured in days.
In Excel, XIRR requires two arrays: the cash flow values and their corresponding dates. The result is an annualised rate equivalent to IRR, but calculated from actual elapsed time rather than assumed equal periods.
XIRR is the correct function to use for real estate analysis, PE fund returns, and any investment where cash flows occur on specific dates rather than at regular intervals. Using standard IRR for irregular cash flows introduces timing errors that can meaningfully distort the result.
Infrastructure projects — toll roads, power plants, pipelines, water utilities — are evaluated almost exclusively using IRR, specifically the project IRR and equity IRR.
The structure differs from typical corporate investments. A project finance structure creates a special purpose vehicle that borrows against the project’s own cash flows, with no recourse to the sponsor’s balance sheet. The project IRR measures the return on the total capital invested (debt plus equity). The equity IRR measures the return to equity investors after debt service.
Infrastructure projects often operate under long-term concession agreements — 25 to 40 years — with regulated or contracted revenue streams. The equity IRR target for these projects is typically in the range of 8–12% for developed-market infrastructure with stable cash flows, reflecting the low operational risk and long-duration nature of the assets.
The concession period matters for IRR in exactly the way it matters for PE: returns generated earlier in the project’s life count more heavily. Infrastructure projects with back-loaded cash flows — where revenue ramps up over time — will show lower IRRs than projects with steady immediate returns, even if total cash flow generation is similar.
In fund structures — PE, real estate, infrastructure — IRR is not just a reporting metric. It is a contractual trigger. The fund agreement specifies an IRR hurdle rate: the return that must be delivered to investors before the fund manager receives carried interest (a share of profits, typically 20%).
A typical waterfall structure works as follows:
The IRR hurdle means the manager earns no carry until investors achieve 8% annualised return. The catch-up provision means that once the hurdle is cleared, the manager rapidly receives their share of accumulated profits before the standard split resumes.
Understanding this structure explains why fund managers care intensely about IRR — not just as a marketing metric but as the direct determinant of their own compensation.
Both IRR and NPV are derived from the same cash flows and are mathematically related. But they are not interchangeable. Using the wrong metric for the wrong decision type produces incorrect conclusions.
Comparing returns across investments of similar scale and timing. IRR expresses return as a percentage, making it directly comparable across different currencies, geographies and investment types. A portfolio manager comparing a 12% IRR equity investment against a 6% government bond yield can make that comparison immediately.
Evaluating against a hurdle rate. When the question is “does this investment clear the required return threshold?” IRR gives a direct answer. If IRR > hurdle rate, the investment qualifies. NPV requires choosing the right discount rate first.
Communicating with non-technical stakeholders. A percentage return is universally understood. An NPV in dollar terms requires context about scale and discount rate assumptions to be meaningful to most audiences.
Private equity, real estate and infrastructure analysis. These industries use IRR as their standard metric, and results are benchmarked against IRR distributions. Reporting NPV in these contexts would be non-standard and difficult to benchmark.
Choosing between mutually exclusive projects. When you can invest in one project or another but not both, NPV directly measures which creates more total value. IRR can rank them incorrectly when projects differ in scale or cash flow timing.
Cash flows change sign more than once. NPV is always a single, interpretable number. IRR may produce multiple values or fail to converge.
The reinvestment rate is known and differs substantially from the IRR. If you can estimate a realistic reinvestment rate, MIRR or NPV provides a more accurate return estimate than standard IRR.
The decision is about value creation, not return efficiency. A smaller project with a high IRR may create less total wealth than a larger project with a lower IRR. NPV captures this directly. IRR does not.
IRR benchmarks vary significantly by sector, risk profile and investment horizon. These ranges reflect typical targets in each category as of early 2026 and are approximations only:
| Sector | Typical equity IRR target |
|---|---|
| Core infrastructure (regulated utilities, toll roads) | 8–10% |
| Core-plus real estate (stabilised, major markets) | 10–13% |
| Value-add real estate | 13–18% |
| Opportunistic real estate | 18–25%+ |
| Buyout private equity (large cap) | 15–20% |
| Growth equity | 20–30% |
| Venture capital | 25–35%+ (target; actual highly variable) |
| Corporate capital budgeting (WACC + margin) | Varies by WACC |
These are target ranges used in investment screening, not guaranteed outcomes. Actual IRRs vary substantially based on entry valuation, execution and exit conditions. They are useful for calibrating whether an IRR is plausible for a given asset class, not for predicting returns.
IRR is the annual rate of return an investment generates over its life. It is the specific discount rate at which the present value of all future cash flows exactly equals the initial investment — where NPV equals zero. If a project has an IRR of 14%, it is generating the equivalent of 14% per year on the capital employed, accounting for the timing of all cash flows.
It depends entirely on the asset class, risk level and required return. For a corporate project, a good IRR is one that exceeds the company’s WACC. For a real estate investment, it depends on strategy — 10% might be strong for core assets, inadequate for value-add. Always compare IRR against the opportunity cost of capital for investments of similar risk.
Three situations: when comparing projects of different scale (IRR favours smaller, higher-percentage projects over larger, higher-value ones); when cash flows change sign multiple times (potentially multiple IRR solutions); and when the actual reinvestment rate is much lower than the IRR (overstating the realistic return). In these situations, use NPV or MIRR instead.
Modified IRR uses an explicit reinvestment rate instead of assuming reinvestment at the IRR. It produces a single, more conservative return estimate that better reflects realistic reinvestment opportunities. Use MIRR when your project has a high IRR and you want to model returns at a realistic reinvestment rate, or when non-conventional cash flows make standard IRR unreliable.
Standard IRR assumes equal time periods between cash flows. XIRR uses actual calendar dates, calculating return based on the precise number of days between each cash flow. For investments where cash flows occur on specific dates rather than regular intervals — which includes most real-world investments — XIRR produces a more accurate result.
PE funds typically report gross IRR (before management fees and carried interest) and net IRR (after fees and carry) to limited partners. Net IRR is the return actually received by investors. Gross IRR reflects the fund’s investment performance independent of fee structure. The difference between gross and net IRR — typically 3–5 percentage points — represents the cost of the fund structure to the investor.
Yes. A negative IRR means the investment returns less than the initial capital invested in present value terms. It is possible for total cash receipts to exceed the initial investment but IRR to be negative if those receipts are heavily back-loaded and the discount effect outweighs the nominal gain.
The hurdle rate is the minimum required return an investment must achieve for approval — typically set at or above the company’s cost of capital, or contractually defined in fund agreements. IRR is the investment’s actual return. If IRR exceeds the hurdle rate, the investment creates value above the required threshold. If it falls below, it does not justify the capital committed.
👉 Use the free NPV & IRR Calculator — enter your cash flows and discount rate to calculate both NPV and IRR simultaneously for any investment or project.
Net Present Value (NPV) Explained — the companion metric to IRR: how NPV is calculated, discount rate selection, and when NPV gives a different answer to IRR
Sharpe Ratio Explained — measuring risk-adjusted return for portfolio investments, where return efficiency is evaluated differently from IRR
Sortino Ratio Calculator — downside risk-adjusted return for investment strategies
Bonds and Fixed Income Fundamentals — yield to maturity on bonds is mathematically equivalent to IRR applied to the bond’s cash flow structure