The internal rate of return is the annualized discount rate at which an investment’s projected cash flows, inflows and outflows combined, net out to zero in present-value terms. Put another way, it is the break-even compound growth rate baked into a project’s own numbers. Finance teams use it to judge whether a project earns enough to justify the capital it will tie up, and investors use it to compare opportunities on a single percentage scale.
What IRR Actually Tells You
If you put $100,000 into a project and receive cash back over the next five years, the IRR is the annual rate at which those future dollars, discounted to today, exactly equal the $100,000 you started with. At that rate, you have neither gained nor lost present value.
The calculation relies only on the cash flows attached to the project itself. It ignores inflation, prevailing interest rates, and whatever else you might do with the money. That narrow focus is both the strength and the weakness of the metric. You get a clean read on the project’s internal efficiency, but you learn nothing about whether that efficiency is good enough. The comparison has to come from somewhere else, usually a hurdle rate.
Because IRR is expressed as a percentage, it lets you line up projects of radically different sizes on the same scale. A $50,000 proposal and a $5 million proposal can both be reduced to a single annualized number, which is why analysts reach for it when evaluating ideas from across departments or asset classes.
How the Calculation Works
The underlying equation sets the net present value of all cash flows equal to zero, with the discount rate as the unknown. Each future cash flow is divided by one plus the unknown rate raised to the period number, and the sum is forced to zero. The rate that satisfies the equation is the IRR.
For anything beyond trivial cash flow patterns, there is no clean algebraic solution. The practical method is iterative: guess a rate, compute the NPV, adjust the guess, repeat. Spreadsheets automate this. In Excel, the IRR function handles evenly spaced cash flows (annual, quarterly, monthly), and XIRR handles irregular dates and always returns an annualized number. When cash flows don’t fall on a tidy schedule, XIRR is the more accurate tool.
A quick example. You invest $500,000 in equipment that generates $160,000 in additional annual profit for four years and is then sold for $50,000 in year five. Dropping those cash flows into a spreadsheet’s IRR function returns roughly 13%. Discounted at 13% per year, the future cash flows exactly offset the $500,000 you spent.
Inputs That Shape the Answer
You need the initial outlay (the year-zero outflow) and projected net cash flows for every future period, each tied to a specific date or period. Timing matters as much as amount. A dollar in year one is worth far more than a dollar in year ten.
Depreciation needs attention even though it is a non-cash expense. No money leaves the business, but depreciation reduces taxable income and therefore reduces the actual tax paid. That tax savings, sometimes called the depreciation tax shield, is real cash flow and belongs in the model. Faster depreciation shifts more of the benefit into early years, which lifts after-tax cash flows up front and pushes the IRR higher. Leave depreciation effects out of the projections and the IRR will not reflect reality.
Errors in the inputs flow through the entire analysis, so most firms treat cash flow projection as a serious exercise rather than a quick estimate.
Deciding Whether to Fund a Project
Once you have an IRR, the rule is straightforward. Compare it to the firm’s hurdle rate, which is the minimum return required before capital is committed. Most companies derive the hurdle rate from their weighted average cost of capital, blending the cost of debt and the cost of equity into one figure. Some add a risk premium for projects that carry unusual uncertainty.
If the IRR beats the hurdle rate, the project produces value above the firm’s cost of capital and is generally worth doing. If it falls below, the project does not earn enough to justify the risk and the capital it absorbs. The appeal of this framework is that it gives management a defensible, numbers-driven standard for approving or rejecting proposals. A department head may be enthusiastic about a new initiative, but if the IRR lands below the hurdle rate, the numbers make the case for sending that money elsewhere. Corporate officers owe fiduciary duties to investors, and a documented capital-allocation process tied to quantifiable returns is one of the clearest ways to show due diligence.
Ranking Projects, and Where IRR Misleads
When a company has several candidate projects but limited capital, ranking by IRR is the usual starting point. The highest IRR goes first, then the next, until the budget runs out. That works when the projects are roughly similar in size and duration. It stops working in two situations.
Scale is the first. A small project might show a 40% IRR on $50,000 while a large project shows 15% on $2 million. The percentage flatters the small project, but the large one may add far more total value to the firm. IRR is blind to scale.
Duration is the second. A two-year project returning 25% annually looks better than a ten-year project returning 12% annually, but the longer project can generate far more cumulative wealth. Short-duration, high-IRR deals are sometimes called “manufactured wealth” in real estate because they look impressive on paper and produce modest actual returns. A 30% IRR earned over three months delivers only 7.5% on your money.
When IRR rankings conflict with what seems intuitively right, the standard move is to fall back on net present value. NPV measures total dollar value created rather than percentage efficiency, so it naturally accounts for differences in scale and duration. For a single project in isolation, NPV and IRR always agree: a positive NPV and an IRR above the hurdle rate both say accept. For two mutually exclusive projects, they can disagree, and NPV is the more reliable guide because it reflects actual value creation at the firm’s specific cost of capital. Professional analysts run both.
Where IRR Falls Short
A single percentage feels concrete and easy to compare, which is part of why IRR is popular. But the metric has structural flaws that can lead to genuinely bad decisions if you trust it uncritically. Three come up most often.
The Reinvestment Assumption
IRR implicitly assumes every interim cash flow is reinvested at the same rate as the IRR itself. If a project shows a 25% IRR and throws off $100,000 in year two, the math assumes that $100,000 immediately goes back to work at 25%. For modest returns near a firm’s cost of capital, that assumption is harmless. For high-return projects, it is wildly optimistic. Few companies have a limitless pipeline of 25% opportunities waiting to absorb each distribution, so IRR overstates the actual annual-equivalent return for high-IRR projects, sometimes by a lot.
Multiple IRR Solutions
The standard IRR equation produces a unique answer only when cash flows follow a conventional pattern: an initial outflow followed by inflows. When cash flows change sign more than once (an outflow, then inflows, then another outflow for cleanup or decommissioning) the equation can produce more than one mathematically valid IRR. A project might show both an 8% and a 42% IRR, and neither is wrong in a strict mathematical sense. The result is that IRR is essentially unusable for projects with non-conventional cash flow patterns, which are common in mining, energy, and any industry with meaningful end-of-life costs.
IRR Can Be Manipulated
Because IRR reacts to the timing of cash flows rather than their total size, it can be inflated without any new value being created. The most common trick in private equity involves subscription credit lines. Instead of calling capital from investors when a deal closes, the fund borrows against the subscription line and delays the capital call for months or years. The investment’s actual performance does not change, but the investor’s IRR clock only starts when cash leaves their account. Investing $100,000 in year one and receiving $130,000 in year four produces roughly a 9% IRR. Use a subscription line to delay the capital call until year three, and the same $100,000 in and $130,000 out produces a 30% IRR. The manager may even earn higher incentive fees on the inflated figure.
Modified Internal Rate of Return
MIRR was designed specifically to fix the reinvestment problem. Instead of assuming interim cash flows are reinvested at the project’s own IRR, MIRR takes two separate rates as inputs: a reinvestment rate for positive cash flows (often the firm’s cost of capital or another realistic figure) and a finance rate for negative cash flows (typically the firm’s borrowing cost).
The calculation compounds positive cash flows forward to the end of the project at the reinvestment rate, discounts negative cash flows back to today at the finance rate, and finds the single rate that equates those two values over the project’s life. Excel’s MIRR function takes the cash flow series plus the two rates. MIRR also eliminates the multiple-solution problem, producing one answer no matter how many times the cash flows switch direction. The trade-off is that you have to choose the two rates up front, which introduces judgment that standard IRR avoids. Most analysts take that trade willingly: a metric that forces you to state a realistic reinvestment assumption is more honest than one that silently assumes an unrealistic one.
IRR in Private Equity and Real Estate
IRR is the dominant performance metric in private equity and commercial real estate, which makes its limitations particularly important in those contexts.
Gross vs. Net IRR
Private equity funds report both a gross IRR and a net IRR, and the gap between them can be large. Gross IRR reflects the underlying investments before fees. Net IRR is what investors actually see after deducting management fees (typically 1.5% to 2.5% of committed capital annually), carried interest (the manager’s share of profits, usually 20%), and fund-level expenses like legal and audit costs. A fund reporting a 40% gross IRR might deliver only 25% net. Focusing on gross returns can lead investors to overestimate what they will actually earn.
The Equity Multiple
Real estate investors rarely rely on IRR alone. The equity multiple, total cash returned divided by total cash invested, captures something IRR misses: the absolute size of the return. A 70% IRR that lasts a month and returns 1.05 times your money is impressive on a percentage basis and has barely moved your wealth. A deal that doubles your money over seven years may show a modest IRR but produce real value. The two metrics together give the complete picture, time-weighted efficiency and total impact.
Adjusting for Inflation and Taxes
A raw IRR ignores both inflation and taxes, so the number on screen can overstate the actual gain in purchasing power.
Converting a nominal IRR to a real (inflation-adjusted) IRR takes one step. If the nominal IRR is 10% and inflation runs at 2%, the real return is not 8%. Divide one plus the nominal rate by one plus the inflation rate and subtract one. Here, 1.10 divided by 1.02 is roughly 1.078, so the real IRR is about 7.8%. The gap from simple subtraction is small at low rates and widens as rates climb.
For after-tax IRR, adjust the cash flows rather than the rate. Start with the before-tax cash flow, subtract depreciation to get taxable income, apply the tax rate to that taxable income, and subtract the tax from the before-tax cash flow to produce the after-tax figure. Run the IRR calculation on those adjusted numbers. A common shortcut that multiplies pre-tax IRR by one minus the tax rate is unreliable for investments involving depreciable assets and should be avoided in serious analysis.
IRR in Public Company Disclosures
Public companies that include financial projections in SEC filings face specific rules meant to keep investors from being misled. The SEC encourages management to present good-faith projections of future performance, but those projections must have a reasonable basis and cannot be presented in a format that selectively highlights only favorable outcomes. Revenue projections, for instance, should generally be accompanied by income projections so that contradictory trends are not buried.1eCFR. 17 CFR 229.10 – (Item 10) General
Willfully making false or misleading statements in required filings is a criminal offense under the Securities Exchange Act. An individual convicted of such a violation faces fines up to $5 million, up to 20 years in prison, or both. For companies, the maximum fine reaches $25 million.2Office of the Law Revision Counsel. 15 US Code 78ff – Penalties Those penalties apply broadly to material misstatements in any required filing, which means presenting manipulated or unreasonably optimistic IRR projections to investors is not merely poor analysis. Companies that put IRR-based projections into offering materials or earnings presentations should make sure the underlying cash flow assumptions are documented and defensible.