IRR stands for internal rate of return, and it’s the estimated annual growth rate an investment is expected to generate. More precisely, it’s the rate at which an investment breaks even in terms of present value: the point where the money you put in equals the value of the money you get back, after accounting for the time value of each cash flow. If a project has an IRR of 12%, that means the investment’s cash flows are equivalent to earning 12% per year on your money.
How IRR Works in Plain Terms
A dollar today is worth more than a dollar five years from now, because you could invest today’s dollar and earn a return in the meantime. IRR builds on this idea. It takes every cash flow an investment produces (the initial cost, the income it generates each year, and any final payout) and asks: at what annual percentage rate would all those future cash flows, discounted back to today, exactly equal what you originally paid?
That breakeven rate is the IRR. A higher IRR means the investment is generating more value relative to what you put in. A lower IRR means less. The calculation itself can’t be solved with simple algebra. Software like Excel uses an iterative process, testing different rates until it lands on one that’s accurate to within 0.00001%.
Why Businesses Use It
Companies evaluating a potential project typically compare the IRR to a “hurdle rate,” which is the minimum return the company needs to justify the investment. This hurdle rate is usually tied to the company’s cost of capital, meaning the blended cost of borrowing money and raising equity. If the IRR meets or exceeds the hurdle rate, the project gets a green light. If it falls short, the project is rejected.
This makes IRR especially useful for comparing projects of different sizes or durations on a level playing field. A $2 million warehouse renovation and a $500,000 equipment upgrade can both be expressed as a single percentage, making it easier to rank them against each other and against the company’s minimum threshold.
Where You’ll See IRR Most Often
IRR is the standard performance metric in private equity and commercial real estate. When a real estate investor evaluates a property, IRR estimates the annual return over the life of the investment, factoring in rental income, operating costs, and the eventual sale price. It captures the timing of those cash flows, not just the total profit, which matters because getting $100,000 back in year two is worth more than getting it in year ten.
Venture capital and private equity funds also report IRR to their investors as a way to communicate how fast the fund’s capital is growing. Any situation where money goes out the door at different times and comes back at different times is a natural fit for IRR.
IRR vs. Other Return Metrics
IRR is often compared to two simpler metrics: ROI (return on investment) and CAGR (compound annual growth rate). ROI tells you the total percentage gain on an investment but ignores timing entirely. If you invested $100,000 and got back $150,000, your ROI is 50%, whether that took two years or twenty.
CAGR improves on ROI by spreading the return across time, giving you a smoothed annual growth rate. But it only looks at the starting value and the ending value. It ignores everything that happens in between, like additional investments, withdrawals, or fluctuating income along the way. For a simple buy-and-hold investment like an index fund, CAGR works fine.
IRR handles the messy middle. It accounts for every cash flow at the time it actually occurs. If a rental property costs you $50,000 in renovations in year three and generates higher rent starting in year four, IRR captures that. CAGR would miss it entirely. For investments with multiple, irregular cash flows, IRR gives a more realistic picture.
The Reinvestment Problem
IRR has a well-known flaw: it assumes that every cash flow the investment generates gets reinvested at the IRR itself. If a project has an IRR of 25%, the math implicitly assumes you can take each year’s income and immediately reinvest it at 25%, which is rarely realistic. A more typical reinvestment rate might be 5% or 8%, depending on what’s available in the market.
This matters most when comparing two projects with very different IRRs or very different cash flow patterns. A project that returns most of its cash early will look better under IRR because the formula assumes all that early cash keeps compounding at the high rate. In reality, you’d probably reinvest it at something much lower.
When IRR Breaks Down
IRR can also produce multiple answers when cash flows switch between positive and negative more than once. A straightforward investment (you pay money upfront, then receive money over time) has one sign change and produces one IRR. But if a project requires a large additional investment midway through, creating a second negative cash flow, the math can spit out two or more valid IRRs. In one textbook example, a project with an initial outlay of $1,600, a $10,000 inflow in year one, and a $10,000 outflow in year two produces IRRs of both 25% and 400%, neither of which is meaningful on its own.
When cash flows change direction more than once, IRR simply isn’t reliable as a decision tool.
Modified IRR (MIRR)
The modified internal rate of return was developed to fix the reinvestment problem. Instead of assuming interim cash flows are reinvested at the IRR, MIRR lets you specify a more realistic reinvestment rate, typically the company’s actual cost of capital. It also handles the issue of multiple answers, always producing a single result.
MIRR is generally lower than IRR for the same project, because it uses a more conservative reinvestment assumption. Some analysts consider this a feature: it’s a more honest estimate of what you’ll actually earn. The tradeoff is that MIRR is less widely used, so when someone in private equity or real estate quotes a return figure, they almost always mean the standard IRR.
How to Calculate IRR in Excel
Excel has a built-in IRR function that makes the calculation straightforward. The syntax is IRR(values, [guess]). The “values” argument is a range of cells containing your cash flows in chronological order. Your initial investment should be entered as a negative number (money going out), and income should be positive (money coming in). The range needs at least one positive and one negative value.
The optional “guess” argument gives Excel a starting point for its iterative calculation. In most cases you can leave it blank and Excel will default to 10%. If the function returns a #NUM! error, it means Excel couldn’t converge on an answer in 20 attempts. Trying a different guess value (say, 0.5 or -0.1) usually resolves it. This error is more common with unconventional cash flow patterns or when the true IRR is far from 10%.
For a quick example: if cell A1 contains -100000 (your initial investment), A2 through A6 contain annual cash flows of 25000, 30000, 35000, 20000, and 40000, then =IRR(A1:A6) returns the annualized rate of return across that five-year period.