Yes, you can have a negative internal rate of return, and it is not a math error or a spreadsheet glitch. A negative IRR means the total cash flowing back from an investment is less than what you put in, so the project is destroying capital on a nominal basis before you even account for inflation or opportunity cost. It shows up regularly in early-stage venture funds, failed product launches, and real estate deals that never stabilize.
What a Negative IRR Actually Means
A negative IRR sits on the opposite side of a hard line from a low positive one. A 1% return is disappointing but recoverable. A -5% return means that for every $100,000 invested, roughly $5,000 a year is gone and the remaining capital is shrinking. You are not underperforming a benchmark. You are losing principal dollar for dollar.
Financial analysts treat a negative IRR as a signal to restructure the project or stop funding it. Continuing to pour money into a venture with a clearly negative trajectory is where sunk-cost thinking does the most damage.
There is a downstream consequence that is easy to miss when you are staring at the IRR itself. Loan agreements often carry financial covenants that require the borrower to maintain minimum ratios like debt service coverage. A project generating negative returns will almost certainly push those ratios below the required thresholds, putting the borrower in technical default and triggering renegotiation or accelerated repayment.
Cash Flow Patterns That Produce a Negative IRR
The arithmetic is simple. If total undiscounted cash coming back is less than the initial outlay, the IRR is negative. A retail buildout that costs $500,000 and generates only $400,000 in total revenue before the location closes will produce a negative IRR no matter when those revenues arrive. Timing changes the magnitude. It does not change the sign.
Research and development is a frequent culprit. A pharmaceutical company might spend $10 million on a drug candidate that never reaches commercialization, with lab equipment and partial data worth maybe $500,000 at salvage. Ninety-five percent of the capital is unrecoverable, and the IRR reflects that. Canceled infrastructure projects, failed software launches, and commercial real estate that never reaches stabilized occupancy follow the same pattern.
A subtler version shows up when a project technically generates positive operating cash flow but not enough to cover ongoing capital calls or maintenance. A rental property producing $50,000 a year in net operating income while requiring $70,000 a year in debt service and capital expenditures is draining cash from the investor every year. The IRR captures that drain even when the income statement looks superficially healthy.
When a Negative IRR Is Normal: The J-Curve
Not every negative IRR is a red flag. Private equity and venture capital funds almost always report a negative IRR in their first few years, a pattern called the J-curve. During the initial capital call period, managers draw down committed capital to make investments while charging management fees on the total commitment. Legal, due diligence, and administrative costs are front-loaded. The fund is spending before any portfolio companies have had time to grow.
This early negative phase typically runs through years one to three. By years four to six, successful portfolio companies start generating returns that pull the fund’s IRR upward. From roughly year seven onward, exits and distributions drive the final IRR into positive territory for funds that perform well. A fund reporting a -15% IRR in year two is not necessarily in trouble. It may be following the exact trajectory its limited partners expected when they committed.
Context decides everything. A negative IRR on a ten-year-old operating business is a fundamentally different signal than a negative IRR on a two-year-old venture fund. Comparing a young fund’s interim IRR to a mature fund’s final IRR is one of the most common appraisal mistakes in private markets. For a fund in its early years, look at the underlying portfolio quality and the pace of capital deployment rather than fixating on the interim number.
Negative IRR and Net Present Value
Net Present Value discounts all future cash flows back to today using a chosen rate, then subtracts the initial investment. The IRR is the specific rate where that calculation equals zero. Plot NPV against a range of discount rates and you get a curve; the point where it crosses zero is the IRR.
If the IRR is negative, the NPV curve crosses zero at a negative discount rate, which means the project’s NPV is negative even at a 0% discount rate. That is the worst possible result. A 0% rate ignores both inflation and opportunity cost. You are saying that in a world where money has no time value at all, the project still loses money. No discount rate can rescue it.
Most practitioners prefer NPV over IRR as the primary decision tool. NPV tells you how much value a project creates or destroys in dollar terms, which is directly actionable. IRR gives you a percentage, useful for comparing projects of different sizes but prone to mislead when cash flow timing varies. The standard decision rules point to the same conclusion when IRR is negative: accept projects with positive NPV, and reject projects where IRR falls below your cost of capital.
When the IRR Number Itself Breaks Down
The IRR calculation carries an implicit assumption that all interim cash flows get reinvested at the IRR itself. For a 25% IRR project, the math assumes you can park incoming cash in other 25% investments. That is rarely realistic, and it becomes absurd at very high or very low rates. When IRR is negative, the formula implicitly assumes you reinvest interim cash flows at a negative rate, which makes no practical sense. The sign is right. The magnitude may be off.
Modified Internal Rate of Return fixes this by letting you specify two separate rates: the cost of financing the investment and the rate at which you can realistically reinvest interim cash. MIRR produces a single, unambiguous return that avoids the reinvestment distortion. For projects where standard IRR is negative, MIRR typically confirms the negative result but gives a more accurate read on how negative. If you are ranking several underperforming projects to decide which to shut down first, MIRR is the more reliable tool.
Standard IRR can also break down when cash flows switch sign more than once. A conventional investment has one large outflow followed by inflows. But a mine that requires both construction spending and end-of-life cleanup might show a pattern of negative, positive, positive, negative. Each sign change can introduce another mathematically valid IRR solution. A project with two sign changes might have two IRRs, say 8% and 42%. Neither is “the” IRR. Spreadsheet software returns whichever root it finds first based on its starting guess, so two analysts running the same cash flows can get different answers. When cash flows are non-conventional, abandon IRR and rely on NPV at your actual cost of capital, or use MIRR, which collapses the cash flows into a single outflow and single inflow before computing the return.
Calculating a Negative IRR in a Spreadsheet
Excel and Google Sheets both have a built-in IRR function that returns negative values when the cash flows warrant them. The function needs at least one positive and one negative cash flow. Enter the initial investment as a negative number and subsequent cash flows with the appropriate sign. Invest $100,000, receive $20,000 back each year for four years, and the function returns a negative IRR because total inflows of $80,000 fall short of the $100,000 outlay.
The most common error is #NUM!, which means the function failed to converge after 20 iterations. That does not necessarily mean no IRR exists. The fix is to supply a “guess” argument, a starting estimate that helps the algorithm find the root. If you suspect the IRR is deeply negative, try a guess of -0.5 or -0.9. If the cash flows genuinely produce no valid solution or multiple solutions, even different guesses will not yield a stable answer, and you should switch to NPV or MIRR.
One trap worth knowing: IRR assumes equal time periods between cash flows. For irregularly spaced flows, use XIRR, which lets you assign specific dates to each flow. Using the wrong function on unevenly timed cash flows produces a number that looks reasonable but is quietly wrong.
What a Negative IRR Means for Your Taxes
A project with a negative IRR eventually produces a realized loss when you sell, close, or abandon the investment. For individual taxpayers, that loss is deductible if the investment was entered into for profit, even if it was not connected to a trade or business.1Office of the Law Revision Counsel. 26 USC 165 – Losses The key constraint is that you generally must dispose of or abandon the investment to claim the deduction. Unrealized losses on a project you are still holding do not create a current-year tax benefit.
If the loss is a capital loss, the deduction against ordinary income is capped at $3,000 per year, or $1,500 if you are married filing separately.2Internal Revenue Service. Topic No. 409, Capital Gains and Losses Any excess carries forward to future tax years indefinitely for individual taxpayers, keeping its short-term or long-term character.3Office of the Law Revision Counsel. 26 USC 1212 – Capital Loss Carrybacks and Carryovers A $50,000 capital loss on a failed project would take more than 15 years to fully deduct against ordinary income at $3,000 per year, assuming no offsetting capital gains along the way.
Passive activities face another layer. Passive activity losses generally cannot offset wages, portfolio income, or other non-passive income. They are suspended and carried forward until you generate passive income to absorb them or dispose of your entire interest in the activity.4Office of the Law Revision Counsel. 26 USC 469 – Passive Activity Losses and Credits Limited Rental real estate gets a partial exception: if you actively participated, you can deduct up to $25,000 in passive rental losses against non-passive income, with the allowance phasing out between $100,000 and $150,000 of modified adjusted gross income.5Internal Revenue Service. Publication 925, Passive Activity and At-Risk Rules When you sell the entire interest at a loss, any remaining suspended passive losses become fully deductible that year.
Negative IRR on a Company’s Books: Impairment
If the investment sits on a business’s balance sheet as a long-lived asset, a pattern of negative returns is one of the clearest triggers for impairment testing under generally accepted accounting principles. When an asset or group of assets is generating continuing operating losses, management must test whether the carrying value is still recoverable.
The test compares the carrying amount to the total undiscounted future cash flows expected from using and eventually disposing of the asset. If those flows exceed the carrying amount, the asset passes. If they fall short, the asset is impaired and must be written down to fair value, with the difference running through the income statement as a loss in the period it is recognized.
A negative IRR practically guarantees that future cash flows will fall short of invested capital, which maps directly onto the recoverability threshold. The write-down reduces reported earnings, can trip loan covenants, and tells investors that management has acknowledged the asset will not perform as projected. Delaying the test when the indicators are obvious can expose directors to claims of inadequate oversight.