Skip to main content

IRR for Beginners

When you invest $10,000 today and withdraw $3,000 each year for five years, what's your return? The answer isn't CAGR—CAGR assumes a single starting and ending value, but here you have intermediate cash flows. This is where IRR (Internal Rate of Return) enters the picture.

IRR is the discount rate that makes the present value of all future cash flows equal to zero. It's the annual return you're earning when you account for the timing, direction, and size of every dollar that moves in and out of an investment. For complex investments with irregular cash flows—rental properties, dividend-paying stocks, private equity, pension plans—IRR is the correct return metric. This article demystifies IRR, shows you how it's calculated, and reveals why it matters.

Quick definition: IRR (Internal Rate of Return) is the annual discount rate that makes the net present value of all cash flows equal to zero. It accounts for the timing and amount of each cash flow, making it ideal for investments with multiple cash movements.

Key Takeaways​

  • IRR accounts for cash flow timing; CAGR doesn't
  • IRR is found by solving the equation: NPV = 0, which has no simple algebraic solution
  • Iterative methods or spreadsheets are practical tools for calculating IRR
  • IRR can be misleading with unusual cash flow patterns or when comparing projects of different sizes
  • For real-world investing (real estate, dividends, private businesses), IRR is essential

From CAGR to IRR: The Gap​

CAGR assumes your investment sits untouched from start to finish. But what if you:

  • Invest $100,000, then add $5,000 annually?
  • Buy a rental property, collect monthly rents, and sell it after 10 years?
  • Hold a dividend stock, receiving payments and reinvesting them?
  • Make an initial investment in a fund, withdraw money midway, and add more later?

In all these cases, CAGR isn't applicable. CAGR requires a single known beginning value and a single known ending value with no intermediate movements. The moment you introduce cash flows during the holding period, you need IRR.

The Core Concept: Net Present Value​

Before calculating IRR, understand Net Present Value (NPV). NPV is the value of all future cash flows, discounted to today's dollars using a discount rate.

Example: You're considering an investment that requires $1,000 today and will pay $600 in one year. If your required return is 10%, what's the NPV?

NPV = -1000 + (600 / 1.10)
NPV = -1000 + 545.45
NPV = -454.55

The NPV is negative, meaning you're not earning your required 10% return. You'd be losing purchasing power in today's dollars.

Now change the example: the investment pays $1,200 in one year.

NPV = -1000 + (1200 / 1.10)
NPV = -1000 + 1090.91
NPV = 90.91

Positive NPV means you're earning more than your 10% required return.

The question behind IRR is: "What discount rate makes NPV exactly zero?" That rate is the IRR.

The IRR Formula and Why It's Hard​

The general formula for NPV with cash flows occurring at different times is:

NPV = CF₀ + CF₁/(1+r) + CF₂/(1+r)² + CF₃/(1+r)³ + ... + CFₙ/(1+r)ⁿ

where:

  • CF₀, CF₁, etc. are cash flows at time 0, 1, 2, etc.
  • r is the discount rate
  • n is the number of periods

Setting NPV = 0 to solve for r (the IRR):

0 = CF₀ + CF₁/(1+r) + CF₂/(1+r)² + CF₃/(1+r)³ + ... + CFₙ/(1+r)ⁿ

For a 5-year investment, this becomes a 5th-degree polynomial equation. There's no clean algebraic solution. You must solve it iteratively (trying values until NPV = 0) or use a spreadsheet.

Example 1: A Simple Two-Year Project​

You invest $1,000 today. Year 1 yields $400; Year 2 yields $800.

Setup:

0 = -1000 + 400/(1+r) + 800/(1+r)²

We need to find r such that this equals zero. Let's try some values:

Try r = 0.10 (10%):

NPV = -1000 + 400/1.10 + 800/1.21
NPV = -1000 + 363.64 + 661.16
NPV = 24.80 (positive, so 10% is too low)

Try r = 0.15 (15%):

NPV = -1000 + 400/1.15 + 800/1.3225
NPV = -1000 + 347.83 + 605.01
NPV = -47.16 (negative, so 15% is too high)

Try r = 0.12 (12%):

NPV = -1000 + 400/1.12 + 800/1.2544
NPV = -1000 + 357.14 + 637.67
NPV = -5.19 (very close to zero)

The IRR is approximately 12% (slightly higher to hit exactly zero, maybe 12.1%).

In Excel, you'd use =IRR({-1000, 400, 800}) and get the answer instantly: approximately 12.02%.

Example 2: A Rental Property​

You buy a property for $200,000 (year 0). You collect net rental income of $15,000 annually for 10 years. You sell the property at the end of year 10 for $280,000.

Cash flows:

  • Year 0: -$200,000
  • Years 1–10: +$15,000 each
  • Year 10: +$280,000 (sale proceeds, added to the final year's rental income)

Adjusted:

  • Year 0: -$200,000
  • Years 1–9: +$15,000 each
  • Year 10: +$15,000 + $280,000 = +$295,000

The IRR equation becomes:

0 = -200,000 + 15,000/(1+r) + 15,000/(1+r)² + ... + 15,000/(1+r)⁹ + 295,000/(1+r)¹⁰

Using a spreadsheet function =IRR({-200000, 15000, 15000, 15000, 15000, 15000, 15000, 15000, 15000, 15000, 295000}) yields an IRR of approximately 10.7%.

Interpretation: This rental property generates a 10.7% annual return, accounting for the timing of rental income, the sale price, and the initial investment. This is the true return, inclusive of all cash movements.

IRR vs. CAGR: When They Differ​

Consider an investment with irregular cash flows:

  • Year 0: Invest $100,000
  • Year 1: Receive $80,000
  • Year 2: Receive $100,000

CAGR approach (doesn't apply cleanly): If you treat this as $100,000 → $180,000 over 2 years:

CAGR = (180,000 / 100,000)^(1/2) – 1 = 1.8^0.5 – 1 ≈ 0.3416 or 34.16%

But this ignores that you got $80,000 back in year 1, which you could have reinvested elsewhere.

IRR approach:

0 = -100,000 + 80,000/(1+r) + 100,000/(1+r)²

Solving (try r = 0.10):

NPV = -100,000 + 80,000/1.10 + 100,000/1.21
NPV = -100,000 + 72,727 + 82,645
NPV = 55,372 (too high)

Try r = 0.30:

NPV = -100,000 + 80,000/1.30 + 100,000/1.69
NPV = -100,000 + 61,538 + 59,172
NPV = 20,710 (still too high)

Try r = 0.50:

NPV = -100,000 + 80,000/1.50 + 100,000/2.25
NPV = -100,000 + 53,333 + 44,444
NPV = -2,223 (close)

IRR is approximately 48%. (Using spreadsheet: 48.3%.)

Notice: The "apparent" CAGR (34.16%) vastly understates the actual IRR (48%) because CAGR doesn't account for the $80,000 inflow at year 1, which gets reinvested. IRR is far more accurate here.

Flows​

Every cash outflow is shown above the timeline; inflows below. The IRR is the rate that makes the present value of all inflows equal the present value of all outflows.

Calculating IRR: Practical Methods​

Method 1: Spreadsheet Formula

In Excel: =IRR(range) In Google Sheets: =IRR(range)

The range includes all cash flows in chronological order, starting with the initial investment.

Example (in Excel column A):

A1: -100000
A2: 15000
A3: 15000
A4: 15000
A5: 295000
=IRR(A1:A5)  → Result: 10.7%

Method 2: Financial Calculator

Scientific calculators designed for finance (HP 12C, Texas Instruments BA II+) have an IRR button. You input cash flows in order, then press IRR.

Method 3: Manual Iteration

Guess and check (as shown in earlier examples). Try different discount rates, calculate NPV, adjust. This is tedious but illustrates the concept.

Method 4: Goal Seek (Excel)

Set up the NPV formula, then use Excel's Goal Seek feature to find the rate that makes NPV = 0.

For most practical purposes, use Method 1 (spreadsheet). It's fast, accurate, and ubiquitous.

Multiple Cash Flows Increase Complexity​

With many cash flows over years, calculating IRR by hand is impractical. But the concept remains: IRR is the rate that makes NPV zero.

Real-world example: A dividend stock

  • Year 0: Buy 100 shares at $50 = -$5,000
  • Year 1: Dividend of $2/share = +$200
  • Year 2: Dividend of $2.50/share = +$250
  • Year 3: Dividend of $2.50/share = +$250
  • Year 4: Dividend of $3/share = +$300, sell at $65/share = +$6,500

Total Year 4 cash flow: $300 + $6,500 = $6,800

Using a spreadsheet:

IRR({-5000, 200, 250, 250, 6800}) ≈ 8.3%

The stock yielded an 8.3% IRR, accounting for dividends and the sale price. If dividends are reinvested, the calculation adjusts accordingly (you'd add the reinvested amount to the next year's cash flow).

Why IRR Can Mislead​

IRR is powerful but has pitfalls:

Pitfall 1: Unusual Cash Flow Patterns

If cash flows change direction (outflow to inflow to outflow), there can be multiple IRRs or no real IRR. For example:

  • Year 0: -$1,000
  • Year 1: +$2,500
  • Year 2: -$1,600

This has two solutions (two different discount rates that make NPV = 0). A spreadsheet might return one; finding the other requires deeper analysis. This is rare but important to know.

Pitfall 2: Reinvestment Assumption

IRR assumes all intermediate cash flows are reinvested at the IRR rate itself. If you receive $10,000 in year 1, IRR assumes you reinvest it at the IRR (say, 12%). But you might only earn 5% reinvesting. This overestimates long-term wealth.

Pitfall 3: Comparing Projects of Different Sizes

A small project with 20% IRR doesn't beat a large project with 15% IRR if the larger project generates more total wealth. IRR is a rate, not an absolute return.

Example:

  • Small project: Invest $1,000, earn 20% IRR → $1,200 profit
  • Large project: Invest $100,000, earn 15% IRR → $115,000 profit

The large project is better in absolute terms ($115,000 > $1,200), but IRR alone doesn't show this.

Pitfall 4: Time Horizon Matters

A project with 20% IRR over 2 years isn't comparable to one with 20% IRR over 10 years—different risks and opportunities. Always specify the time horizon.

Common Mistakes with IRR​

Mistake 1: Confusing IRR with Interest Rate IRR is the rate of return, not the interest rate you're paying or receiving. It's the discounting rate that makes NPV zero, encompassing all cash flows' timing and size.

Mistake 2: Assuming IRR and CAGR Are Interchangeable They're not. CAGR applies to a single starting and ending value. IRR applies to multiple cash flows. Use each for its intended purpose.

Mistake 3: Forgetting to Include All Cash Flows If you buy a property and collect rent but forget to include the sale price, your IRR will be understated. Every cash flow (inflows and outflows) must be included.

Mistake 4: Using IRR to Compare Investments Without Context A higher IRR isn't always better. Consider risk, time horizon, and absolute returns. A 15% IRR on a highly risky venture may not beat a 10% IRR on a stable investment.

Mistake 5: Assuming IRR Is the Realized Return if Reinvestment Rates Differ IRR assumes reinvestment at the IRR rate. If actual reinvestment rates are lower, your realized return is less than IRR. Always note this assumption.

Real-World Examples​

Example 1: Private Equity Investment

You invest $500,000 in a startup fund:

  • Year 0: -$500,000
  • Year 1: $0 (fund is building)
  • Year 2: $0
  • Year 3: $0
  • Year 4: $50,000 (partial liquidation)
  • Year 5: $800,000 (full exit)
IRR({-500000, 0, 0, 0, 50000, 800000}) ≈ 11.8%

Despite waiting 5 years and seeing zero income for 3 years, the IRR is 11.8%—solid for private equity, where illiquidity commands a premium return.

Example 2: Bond with Coupons and Principal

A bond costs $950, pays $50 annually for 10 years, and returns $1,000 principal at maturity.

IRR({-950, 50, 50, 50, 50, 50, 50, 50, 50, 50, 1050}) ≈ 5.6%

The IRR is 5.6%, known as the bond's "yield to maturity" (YTM). This is the standard way bond returns are quoted. The U.S. Treasury and Federal Reserve use IRR/YTM to report bond performance, making it essential knowledge for fixed-income investors.

Example 3: Retirement Account with Contributions

  • Year 0: Contribute $5,000, account starts at $0
  • Year 1: Contribute $5,000, account at $5,500 (earned $500)
  • Year 2: Contribute $5,000, account at $11,550 (earned $550 + $550)
  • Year 3: Contribute $5,000, account at $18,161 (earned $611)
  • Year 4: Withdraw $50,000

This is complex to model, but using IRR with the cash flows (contributions as negative, withdrawals as positive, ending balance as a return) yields a return percentage that accounts for your contribution timing and the account's growth.

FAQ​

Q: How does IRR differ from yield? A: IRR and yield are often used interchangeably, but yield typically refers to income (dividends, interest) as a percentage of price, while IRR accounts for all cash flows including appreciation and sale. For a bond, yield to maturity (YTM) is the IRR.

Q: Can I calculate IRR without a spreadsheet? A: Yes, using iterative methods (try values until NPV = 0) or Newton's method (calculus-based). But these are tedious. For any real investment, use a spreadsheet.

Q: What if IRR returns an error in Excel? A: The most common cause is unusual cash flow patterns (multiple direction changes). Ensure cash flows are in chronological order. Sometimes you need to adjust the range or provide a guess value using =IRR(range, guess).

Q: How does IRR handle negative returns? A: If all cash flows point downward (you invest but receive nothing), IRR is negative, indicating a loss. The formula still applies; you're finding the (negative) discount rate where NPV = 0.

Q: Is IRR better for rental properties or real estate? A: Yes. Real estate has ongoing rental income, maintenance costs, taxes, and eventually a sale. IRR captures all these cash flows and their timing, making it ideal for real estate analysis.

Q: What's the relationship between IRR and the term "return on investment" (ROI)? A: ROI is a broad term; IRR is one specific type. ROI might be stated as a simple percentage gain. IRR is the compound annual rate accounting for timing. IRR is more precise.

Summary​

IRR (Internal Rate of Return) is the annual discount rate that makes the net present value of all cash flows equal to zero. Unlike CAGR, which assumes a single starting and ending value, IRR handles investments with multiple cash flows at different times. For rental properties, dividend stocks, private equity, bonds, and any investment with intermediate cash movements, IRR is the correct return metric for analyzing true performance. It's calculated iteratively (by solving an equation where IRR makes NPV = 0), making spreadsheets essential for practical use. However, IRR assumes reinvestment at the IRR rate itself, which may not reflect reality, and it can mislead when comparing projects of different sizes or with unusual cash flow patterns. Understanding IRR separates sophisticated investors from casual ones—it's the language of real estate professionals, bond traders, and private equity analysts. Master IRR, and you have a tool for evaluating the true return of any investment, no matter how complex its cash flows.

Next​

Time-weighted vs Money-weighted Return