Calculate Internal Rate of Return (IRR). Find the discount rate that makes NPV equal to zero.
Three years ago, a friend pitched me on a vacation rental property in the Smoky Mountains. Beautiful cabin, mountain views, walking distance to downtown Gatlinburg. The asking price was $285,000, and the listing showed $38,000 in annual rental income. On paper, it looked like a no-brainer.
I almost wired the down payment that weekend. But something nagged at me, so I fired up a spreadsheet and modeled the actual cash flows: the $57,000 down payment, monthly mortgage at 6.75%, property management fees at 20% of revenue, seasonal cleaning costs, the $4,200 annual insurance premium that nobody mentioned during the pitch, and a conservative 5% annual appreciation on resale after seven years.
Then I calculated the IRR.
It came out to 7.2%. Seven point two percent. I could get roughly the same return buying a Treasury bond, with zero management headaches, zero risk of a guest flooding the bathroom, and zero 2 AM phone calls about a broken hot tub. The deal wasn't terrible — it just wasn't good enough to justify tying up fifty-seven grand and hundreds of hours of my life.
I passed. My friend bought it. Two years later, he told me his actual return after all the expenses the listing conveniently left out? About 6.8%. The IRR math was right.
That experience taught me something I now believe in my bones: IRR is the single most honest number in investing. Not because it's perfect — it has real flaws, which I'll get into. But because it forces you to think about when money moves, not just how much. A dollar today and a dollar in five years are not the same thing, and IRR is the metric that actually respects that difference.
The calculator above does the heavy lifting for you. Punch in your cash flows and it'll find the rate that makes the whole thing break even in present-value terms. Below, I'm going to walk you through everything I've learned about IRR since that weekend — what it means, when it breaks down, how to use it properly, and the traps that catch even experienced investors.
IRR stands for Internal Rate of Return. Strip away the jargon and here's what it means: it's the annualized percentage return an investment delivers, accounting for the timing of every cash flow.
More precisely, IRR is the discount rate that makes the Net Present Value of all your cash flows equal to zero. If that sentence made your eyes glaze over, let me translate with a concrete example.
Say you invest $10,000 today and receive $3,000, $4,000, $5,000, and $6,000 over the next four years. The IRR is 18.36%. That means if you could borrow money at exactly 18.36% and used the investment's cash flows to pay off the loan, you'd break even to the penny by year four. It's the break-even cost of capital.
If your actual cost of capital is lower than 18.36% — say, 8% — then this investment creates value. The spread between IRR and your cost of capital is your economic profit. If your cost of capital is higher than the IRR, the investment destroys value even if the raw numbers look profitable.
IRR and NPV are two sides of the same coin. NPV tells you how much value an investment creates in dollar terms, at a specific discount rate. IRR tells you the rate at which that value creation drops to zero. If you discount the cash flows at the IRR, NPV equals zero. Discount below the IRR, and NPV is positive (good investment). Discount above it, and NPV goes negative (bad investment).
The formula underneath is straightforward, even if solving it isn't:
There's no algebraic shortcut for most real cash flow patterns. The calculator above uses Newton-Raphson iteration — it starts with a guess and refines it until the NPV is effectively zero. Same approach Excel's IRR function uses under the hood.
I see people misuse these three metrics all the time, so let me be clear about what each one does and when to deploy it.
CAGR tells you the constant annual growth rate that takes you from a starting value to an ending value. If you invest $10,000 and it's worth $15,000 after 3 years, the CAGR is 14.47%. Clean, simple, easy to communicate.
The problem? CAGR pretends the path between start and finish doesn't matter. It doesn't know you had to inject another $5,000 in year 2. It doesn't know the investment dropped 30% in year 1 before recovering. CAGR is a headline number — useful for comparing index fund returns over ten years, dangerous for evaluating lumpy, irregular investments.
Net Present Value discounts every cash flow at your actual cost of capital and adds them up. If NPV is positive, the investment creates value. If negative, it doesn't. No ambiguity, no multiple-solution problems, no hidden assumptions about reinvestment rates.
NPV's weakness is communication. Telling a potential partner "this deal has an NPV of $12,847 at a 10% discount rate" means nothing to most people. They want a percentage. That's why IRR exists as a companion metric.
IRR gives you a percentage return that accounts for the timing and size of every cash flow. "This project returns 18% annually" is something anyone can understand and compare to their hurdle rate.
But IRR carries baggage. It implicitly assumes you can reinvest interim cash flows at the IRR itself — a dubious assumption when your IRR is 25% and money market rates are 5%. And when cash flows change sign more than once, IRR can give you multiple answers, which is mathematically correct but practically useless.
| IRR | NPV | CAGR | |
|---|---|---|---|
| What it gives you | Annualized % return | Dollar value created | Average annual growth % |
| Handles irregular cash flows | Yes | Yes | No |
| Accounts for timing | Yes | Yes | No |
| Needs a discount rate input | No (it solves for it) | Yes | No |
| Multiple-solution problem | Yes, with non-standard cash flows | No | No |
| Reinvestment assumption | At IRR (often unrealistic) | At discount rate (more realistic) | None |
| Best use case | Communicating returns, quick screening | Final investment decision | Comparing smooth, long-term returns |
My rule of thumb: use CAGR for comparing passive investments like index funds. Use ROI for quick back-of-napkin math. Use IRR for screening real estate deals, equipment purchases, and private investments. Use NPV for the final yes-or-no decision when real money is on the line.
Here's something most IRR tutorials skip: a project can have more than one IRR. Not approximately. Exactly. Two different discount rates, both making NPV zero.
This happens when your cash flow sequence changes sign more than once. A classic example is a mining project: you invest upfront (negative), earn revenue for a few years (positive), then face a massive environmental remediation bill at the end (negative again). The sign pattern goes -/+/-, and mathematically, that can produce two valid IRRs.
I ran into this with a client's oil well investment. The projected cash flows were: -$200K initial drilling, +$80K/year for years 1-3, then -$50K in year 4 for plugging and abandonment. The IRR calculator returned 9.4% and 24.1%. Both correct. Both useless in isolation, because which one do you compare to your hurdle rate?
When this happens — and it happens more often than people admit — you have three options:
First, switch to NPV. Discount the cash flows at your actual cost of capital. If NPV is positive, the project creates value. Done. No ambiguity.
Second, use Modified IRR (MIRR). MIRR separates the finance rate (what you pay to fund negative cash flows) from the reinvestment rate (what you earn on positive cash flows). It always produces a single answer. I'll cover MIRR in detail below.
Third, restructure the project. Sometimes multiple IRRs are a signal that your cash flow projections are unrealistic. If you're showing massive year-4 costs, ask whether you can spread them out or finance them differently. Changing the timing of cash flows can eliminate the multiple-IRR problem entirely.
My honest take: if your cash flows change sign more than twice and you're still relying on IRR alone, you're asking for trouble. Pull up the NPV calculator and cross-check. Every time.
Standard IRR has two dirty secrets. First, it assumes you reinvest interim cash flows at the IRR itself — so if a project has a 30% IRR, the math assumes every dollar you get back along the way earns 30% elsewhere. In what universe?
Second, it assumes you finance all negative cash flows at the same IRR. Again, unrealistic. Your cost of capital and your reinvestment rate are rarely the same number.
MIRR fixes both. You specify two rates: a finance rate (what it costs you to fund the investment, typically your WACC or loan rate) and a reinvestment rate (what you can actually earn on interim cash flows, often something close to your savings account rate or a reasonable market return).
The formula compounds all negative cash flows forward at the finance rate and all positive cash flows forward at the reinvestment rate, then finds the single rate that equates them. One answer. Always.
Practical example: that $10,000 equipment investment returning $3K/$4K/$5K/$6K? Standard IRR says 18.36%. But if your reinvestment rate is 6% (a realistic market return) and your finance rate is 8% (your loan cost), MIRR comes out to roughly 13.2%. That's a five-point haircut from the headline IRR number — and it's a lot closer to the truth.
I always calculate both. If IRR and MIRR are close (within 2-3 points), the standard IRR is reliable enough. If they diverge significantly, trust MIRR. It means the reinvestment assumption is driving a big chunk of the apparent return, and that return might not be achievable.
Real estate is where I do most of my IRR work, and it's where the metric shines — but also where people manipulate it most aggressively.
A typical rental property cash flow looks like this: you put money down at closing (negative), collect monthly rent (positive), pay for repairs and vacancies (negative intermittently), and eventually sell the property (large positive, hopefully). The IRR captures all of it — the timing, the magnitude, and the big pop at resale.
Here are my benchmarks, built from watching dozens of deals over the past few years:
Below 8%: Not worth the illiquidity and management burden. Put your money in stocks instead. The S&P 500 has returned roughly 10% annually over long periods with zero effort.
8-12%: Decent for a turnkey property in a stable market with professional management. You're earning a modest premium over passive investing for taking on property-specific risk.
12-18%: Strong. This usually involves some combination of value-add (renovating, raising rents) or buying in an appreciating market. Most serious real estate investors target this range.
18-25%: Aggressive value-add or development deals. The returns are real but the risk is substantial. Budget overruns, permitting delays, and market downturns can turn a projected 22% IRR into a 3% mess.
Above 25%: Either you're looking at a highly leveraged deal with significant downside risk, or the projections are aspirational fiction. Proceed with extreme skepticism.
I've seen sponsors massage IRR in a handful of predictable ways. Watch for these red flags:
Unrealistic appreciation assumptions. Projecting 6-8% annual appreciation in a market that's historically delivered 3% is the easiest way to inflate IRR. The resale value at the end often drives a huge portion of the total return, so even a small change in the assumed growth rate dramatically shifts IRR.
Ignoring capital expenditures. Showing smooth, increasing rental income without budgeting for a new roof, HVAC replacement, or major renovation is dishonest. I always add at least $2,000-3,000/year in CapEx reserves for properties over 15 years old.
Understating vacancy. Using 3% vacancy in a market with 8% historical vacancy is a favorite trick. Check actual market data, not the sponsor's optimistic guess.
Short hold periods. IRR is an annualized metric, so compressing the timeline artificially boosts the number. A deal that returns 2x in 3 years shows a 26% IRR. The same 2x return over 7 years is only 10.4%. Sponsors sometimes project unrealistically quick exits to pump up the IRR.
Always run your own numbers. Use the investment return calculator for a gut check, then model the full cash flow series here for the real IRR.
If you ever invest in a private equity fund, you'll encounter IRR in a very specific context — and you need to understand the J-curve or you'll panic in year two.
PE funds work like this: you commit capital, the fund calls it over 3-5 years (the investment period), the portfolio companies grow and eventually get sold (exits), and you receive distributions. The whole cycle typically runs 7-12 years.
Here's what the IRR looks like over time: it starts negative (you've committed money but the fund hasn't generated returns yet), gets more negative as more capital is called, then slowly climbs as distributions begin. The shape on a chart looks like the letter J — a dip followed by a steep rise. Hence the name.
A fund showing -15% IRR in year two isn't necessarily a disaster. That's normal. The fund has deployed capital but hasn't started exiting investments yet. The same fund might show 22% IRR by year six as exits accelerate.
Top-quartile PE funds typically target 20-25% gross IRR (before fees) or 15-20% net IRR (after the 2% management fee and 20% carried interest). Median performance is considerably lower — the gap between top-quartile and median PE returns is much wider than in public markets, which is why fund selection matters enormously.
PE professionals track two metrics religiously: IRR and Multiple of Invested Capital (MOIC, also called TVPI — Total Value to Paid-In). MOIC tells you how many dollars you get back per dollar invested. A 2.5x MOIC means you turned $1 into $2.50.
The key insight: IRR is sensitive to timing, MOIC isn't. A deal that returns 2.5x in 3 years has a much higher IRR (35.7%) than a deal that returns 2.5x in 7 years (14.4%). Same multiple, very different annualized returns. PE managers know this, which is why some funds use subscription lines of credit to delay calling investor capital — it artificially boosts early-year IRR without changing the actual economics. Clever, but somewhat misleading.
If you're evaluating PE funds, look at both metrics. A fund with consistently high MOIC but lower IRR might just be patient. A fund with high IRR but lower MOIC might be churning quick flips at the expense of larger, longer-term gains.
I've been praising IRR for a few thousand words, so let me balance the scales. IRR has genuine limitations that can lead to bad decisions if you're not aware of them.
I covered this in the MIRR section, but it bears repeating: IRR assumes interim cash flows get reinvested at the IRR itself. When a project shows 25% IRR, the math assumes every dollar you get back earns 25% somewhere else. In reality, your reinvestment options are usually much more modest. This is why IRR tends to overstate returns compared to MIRR, especially for high-return projects.
IRR doesn't care about scale. A project that turns $1,000 into $2,000 in one year has a 100% IRR. A project that turns $1,000,000 into $1,800,000 in one year has an 80% IRR. If you can only pick one, IRR says pick the first. But the second creates $800,000 in actual wealth versus $1,000. That's insane. When comparing projects of vastly different sizes, always look at NPV alongside IRR.
Because IRR is annualized, it rewards early returns disproportionately. Two projects with identical total cash flows but different timing can show dramatically different IRRs. This isn't necessarily wrong — early cash flows are more valuable — but it can bias you toward short-term projects at the expense of long-term wealth creation.
People often ask "what IRR should I target?" and the honest answer is: it depends on your alternatives. If your next-best option is a savings account paying 4%, any project with an IRR above 4% creates value. If your next-best option is a stock portfolio returning 10% after inflation — which you can check with our inflation calculator — then your hurdle rate is 10%, and you need IRR above that to justify the additional risk and illiquidity.
The right hurdle rate isn't some arbitrary industry benchmark. It's your actual opportunity cost — what you'd earn with the next-best use of the same capital.
Here's the process I actually use when evaluating a real investment. Not theoretical — this is what I do before writing a check.
A 15% IRR over five years doesn't mean you made 75% total return. The compounding works differently because of the irregular cash flows. Use the compound interest calculator to see how a steady 15% annual return compounds over time — it's a useful sanity check against your IRR result.
If you already spent $50K on a project and are deciding whether to invest another $20K, the IRR should only consider future cash flows from this point forward. The $50K is gone. Don't include it in your IRR calculation for the go-forward decision. This is called marginal IRR, and it's the only number that matters for incremental decisions.
Comparing the IRR of a 6-month flip to the IRR of a 10-year buy-and-hold is comparing apples to cinder blocks. Different time horizons, different risk profiles, different capital commitments. Only compare IRRs within similar asset classes and timeframes.
If the absolute dollar return is tiny, a high IRR just means you efficiently turned a small amount of money into a slightly larger amount. $100 turning into $200 in one year is a 100% IRR, but you only made $100. Congrats, you can buy a nice dinner. Scale matters.
A 15% IRR from a government bond and a 15% IRR from a speculative startup are not the same thing. The bond is near-certain. The startup might have a 30% chance of returning anything at all. Always adjust your hurdle rate for risk. I add 5-10 points to my hurdle rate for speculative investments, which means a startup needs to project 20-25% IRR before I'm interested.
1. Enter your initial investment as a negative number. This is the money going out. Example: -10000 for a $10,000 investment.
2. Add subsequent cash flows separated by commas. Each number represents one period (usually one year). Positive for income, negative for additional costs. Example: -10000,3000,4000,5000,6000
3. Click Calculate. The calculator iterates to find the discount rate where NPV equals zero — that's your IRR.
4. Compare to your hurdle rate. If IRR exceeds what you could earn elsewhere at similar risk, the investment may be worth pursuing. Cross-check with NPV for the final call.
IRR is the discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero. It represents the annualized percentage return of an investment, accounting for the timing of every cash flow. There's no closed-form formula for most real-world scenarios — the calculator uses Newton-Raphson iteration, starting with an initial guess and refining until the NPV converges to zero. This is the same algorithm Excel's IRR() function uses.
NPV gives you a dollar amount — the total value an investment creates in today's money at a specific discount rate. IRR gives you a percentage — the annualized return rate where NPV crosses zero. NPV is better for comparing investments of different sizes (it accounts for scale), while IRR is better for communicating returns to stakeholders. When IRR and NPV give conflicting signals — which can happen with mutually exclusive projects of different sizes — trust NPV. It's the mathematically correct decision criterion.
For residential rental properties, 12-18% IRR is strong. Commercial real estate typically targets 10-15%. Value-add projects (buying distressed, renovating, and selling) often project 18-25%. Anything below 8% in real estate is usually not worth the illiquidity and management burden compared to passive stock market investing, which has historically returned around 10% annually. But always adjust for your specific market, risk tolerance, and opportunity cost.
Yes. A negative IRR means you lost money on an annualized basis. If you invest $10,000 and get back a total of $8,000 over three years, the IRR is negative. This is mathematically valid — it just tells you the investment destroyed value. A negative IRR is your signal to not make that investment, or to exit if you're already in it and can cut your losses.
When cash flows change sign more than once (for example: invest, earn income, then face a large closing cost), the NPV curve can cross zero at multiple discount rates. Each crossing is a mathematically valid IRR. This is called the multiple IRR problem. The practical solution is to switch to NPV for your decision (it always gives one answer) or use Modified IRR (MIRR), which uses separate finance and reinvestment rates to produce a single result.
Use MIRR when your project has non-conventional cash flows (sign changes more than once) or when the standard IRR's reinvestment assumption is unrealistic. Standard IRR assumes you reinvest interim cash flows at the IRR itself — if your project shows 30% IRR, it assumes you can earn 30% on every dollar received along the way. MIRR lets you specify realistic finance and reinvestment rates. The result is usually lower than standard IRR but more defensible. If IRR and MIRR are within 2-3 points of each other, either is fine. If they diverge significantly, trust MIRR.
Private equity funds typically show negative IRR in early years (the J-curve effect) because capital is deployed but returns haven't materialized. As the fund matures and portfolio companies are sold, IRR accelerates. Top-quartile PE funds target 20-25% gross IRR over a 10-year fund life, or roughly 15-20% net of fees. LPs evaluate PE funds using both IRR and MOIC (Multiple of Invested Capital), because IRR alone can be misleading — it's sensitive to the timing of capital calls and distributions, which fund managers can manipulate.
Venture capitalists typically target 30-50%+ IRR on individual startup investments, knowing most will fail. The math works because one big winner can return the entire fund. Angel investors often look for 10x return potential over 5-7 years, which implies roughly 60-80% IRR on successful investments. But remember that startup investing follows a power-law distribution — your average return across all investments will likely be much lower than the IRR on the winners.