Your Progress 0%

📊 What is IRR (Internal Rate of Return)?

IRR is the discount rate that makes the Net Present Value (NPV) of a project equal to zero. In simpler terms, it's the percentage return you're earning on an investment, accounting for the timing of all cash flows.

Key Point: IRR answers: "What average annual return am I getting on this investment?" It's expressed as a percentage (like 15% or 22%), making it easy to compare different investments or projects. If IRR exceeds your required rate of return, the project is worth pursuing.

The IRR Concept

IRR is the rate at which:

NPV = 0
Or expanded:
Initial Investment = Present Value of Future Cash Flows

Simple Example

You invest $10,000 in a project. It generates $4,000 in Year 1, $5,000 in Year 2, and $4,000 in Year 3.

Year 0: -$10,000 (investment)
Year 1: +$4,000
Year 2: +$5,000
Year 3: +$4,000
IRR = 13.7%

Interpretation: This investment returns 13.7% annually. If your required return is 10%, this is a good investment (IRR > required return). If you need 15%, it's not attractive enough.

Why IRR Matters

  • Compare investments: "Project A returns 18%, Project B returns 12%"
  • Benchmark against alternatives: Compare to stock market, bonds, other investments
  • Capital budgeting: Decide which projects to fund with limited capital
  • Performance measurement: Evaluate actual vs expected returns
  • Simple communication: Percentage returns are universally understood

IRR Decision Rule

Comparison Decision Reasoning
IRR > Required Return Accept project Generates excess returns
IRR = Required Return Neutral (indifferent) Meets minimum threshold
IRR < Required Return Reject project Returns insufficient for risk
💡 Required Rate of Return

Also called "hurdle rate" or "cost of capital." This is the minimum return you need to justify the investment. It reflects: opportunity cost (what else you could earn), risk (higher risk needs higher return), and financing costs (if borrowing money). Typical hurdle rates: 8-12% for low risk, 15-20% for high risk.

IRR vs NPV: What's the Difference?

Metric What It Tells You Result Format
IRR Percentage return on investment 15.5% annual return
NPV Dollar value added by investment $45,000 value created

Both are related. If IRR > discount rate, then NPV > 0. Use both together for best decision making.

Common Applications

Business Investment Decisions:

Should we buy new equipment? Open a new location? Launch a new product line?

Real Estate:

What return am I getting on this rental property or development project?

Private Equity:

What's the return on acquiring and improving a company over 5 years?

Personal Investments:

Did my stock portfolio beat the market? What return did I earn on that business venture?

⚠️ IRR Limitations

1. Assumes reinvestment at IRR: Unrealistic if IRR is very high
2. Multiple IRRs possible: With unconventional cash flows
3. Doesn't show project size: 50% IRR on $1,000 vs 15% on $1M
4. Can't handle different duration projects well: 30% for 1 year vs 15% for 10 years
Use IRR alongside NPV and payback period for complete picture.

🔢 How to Calculate IRR

The Challenge

Unlike most financial calculations, IRR can't be solved with simple algebra. You must use trial and error, financial calculators, or Excel.

Example: Equipment Purchase

Machine A costs $150,000

Cash Flows:

Year Cash Flow
0 (now) -$150,000
1 $30,000
2 $35,000
3 $45,000
4 $60,000
5 $85,000

Finding IRR by Trial and Error:

Try 10%:

NPV = -$150,000 + $30,000/1.10 + $35,000/1.10² + ... + $85,000/1.10⁵
NPV = -$150,000 + $27,273 + $28,926 + $33,808 + $40,980 + $52,775
NPV = $33,762 (positive, so IRR > 10%)

Try 18%:

NPV = -$150,000 + $30,000/1.18 + $35,000/1.18² + ... + $85,000/1.18⁵
NPV = -$1,458 (slightly negative, so IRR < 18%)

Try 17%:

NPV = $1,031 (close to zero!)
IRR ≈ 17%

Using Excel (Much Easier)

In Excel, list cash flows in column A (A1 to A6)
A1: -150000
A2: 30000
A3: 35000
A4: 45000
A5: 60000
A6: 85000
In cell B1, enter: =IRR(A1:A6)
Result: 17.02%

Comparing Multiple Projects

Machine B costs $250,000

Year Machine A Machine B
0 -$150,000 -$250,000
1 $30,000 $55,000
2 $35,000 $65,000
3 $45,000 $77,000
4 $60,000 $99,000
5 $85,000 $105,000
IRR 17.02% 15.96%

Decision:

Machine A has higher IRR (17.02% vs 15.96%). If hurdle rate is 12%, both are acceptable, but A is better on percentage return basis. However, Machine B generates more absolute dollars. This shows IRR's limitation when comparing different-sized projects.

Interpreting IRR Results

Example Results:

Project IRR Hurdle Rate Decision
Retail expansion 24% 15% Accept (24% > 15%)
New product line 11% 15% Reject (11% < 15%)
Equipment upgrade 15.2% 15% Accept (marginally)

Modified IRR (MIRR)

MIRR addresses IRR's reinvestment assumption by using two different rates:

  • Finance rate: Cost of capital for negative cash flows
  • Reinvestment rate: Rate you can actually reinvest at (usually more realistic than IRR)

MIRR is typically lower than IRR and more realistic, but IRR remains more commonly used.

Best Practice: Use IRR as initial screening tool. Projects with IRR well above hurdle rate (e.g., 20% vs 12% hurdle) are clearly good. Projects close to hurdle rate need deeper analysis with NPV and other metrics.

🌍 Real-World IRR Applications

1
Restaurant Expansion Decision

Scenario: Restaurant owner considering second location.

Investment Details:

Initial investment: $400,000 (buildout, equipment, inventory)
Year 1 net cash flow: $60,000
Year 2: $85,000 (growing reputation)
Year 3: $110,000
Year 4: $125,000
Year 5: $140,000
Residual value Year 5: $200,000 (sell or refinance)

IRR Calculation:

Year 0: -$400,000
Year 1-4: Cash flows as above
Year 5: $140,000 + $200,000 = $340,000
IRR = 21.3%

Decision:

Owner's hurdle rate: 18% (reflects risk and opportunity cost)
IRR of 21.3% exceeds 18%
Decision: Proceed with expansion

The 21.3% return justifies the risk and beats alternative investments. Owner proceeds with confidence.

2
Rental Property Investment

Scenario: Evaluating rental property purchase.

Purchase Details:

Purchase price: $550,000
Down payment (20%): $110,000
Annual net rental income (after mortgage): $8,500
Hold for 10 years
Expected appreciation: 3% annually
Selling price Year 10: $739,000
Less loan balance: -$310,000
Less selling costs (6%): -$44,000
Net proceeds: $385,000

Cash Flows:

Year 0: -$110,000 (down payment)
Years 1-10: $8,500 annually
Year 10 additional: $385,000 (sale proceeds)
Total Year 10: $393,500
IRR = 11.8%

Evaluation:

Compare to alternatives:

  • Stock market historical: ~10% annually
  • Bonds: ~5% currently
  • Savings: ~3%

At 11.8% IRR, property beats bonds and savings but is close to stocks. Given hassle of being a landlord, investor might prefer stocks unless they enjoy property management.

3
Private Equity Buyout

Scenario: PE firm acquires manufacturing company.

Investment Structure:

Purchase price: $50M
Equity invested: $15M (30%)
Debt: $35M (70%)
Hold period: 5 years

Annual Cash Flows (to equity):

Year EBITDA Debt Service Cash to Equity
1 $8M $4M $1M
2 $9M $4M $1.5M
3 $10M $4M $2M
4 $11M $4M $2.5M
5 $12M $4M $3M

Exit (Year 5):

EBITDA: $12M
Exit multiple: 7x EBITDA
Enterprise value: $84M
Less debt: -$28M (paid down from $35M)
Equity value: $56M

IRR Calculation:

Year 0: -$15M
Year 1-5: Annual cash flows as above
Year 5 exit: $56M + $3M cash flow = $59M
IRR = 32.1%

PE firm targets 20-25% IRR. At 32.1%, this is an excellent investment if projections hold.

4
When IRR Misleads

Scenario: Comparing two mutually exclusive projects.

Project Alpha:

Investment: $10,000
Year 1 return: $13,000
IRR = 30%
NPV at 10% = $1,818

Project Beta:

Investment: $100,000
Year 1: $30,000
Year 2: $50,000
Year 3: $60,000
IRR = 18%
NPV at 10% = $18,882

The Dilemma:

Metric Alpha Beta
IRR 30% (winner) 18%
NPV $1,818 $18,882 (winner)
⚠️ IRR vs NPV Conflict

Alpha has higher IRR but Beta creates more value ($18,882 vs $1,818). When IRR and NPV conflict, choose NPV. You'd rather have $18,882 in value than a higher percentage on a tiny project. This shows why IRR alone isn't enough for decisions.

🎯 Test Your Knowledge

Complete this 10-question quiz to check your understanding of IRR

1. What does IRR stand for?
Investment Risk Ratio
Internal Rate of Return
Interest Rate Reduction
Income Reinvestment Rate
2. IRR is the discount rate that makes NPV equal to:
100
Zero
The initial investment
Infinity
3. If IRR is 22% and your hurdle rate is 15%, you should:
Accept the project
Reject the project
Recalculate NPV first
Wait for better opportunities
4. What is the main advantage of IRR over NPV?
More accurate
Expressed as a percentage, easy to understand and compare
Doesn't require discount rate
Always gives the right answer
5. IRR assumes that cash flows are reinvested at:
The IRR itself
The hurdle rate
Zero percent
The risk-free rate
6. What's the easiest way to calculate IRR?
By hand using algebra
Using Excel's IRR function or financial calculator
Guessing different percentages
Using the NPV formula backwards
7. When IRR and NPV give conflicting rankings between two projects:
Always choose the higher IRR
Choose the higher NPV (more value created)
Reject both projects
Calculate MIRR instead
8. Project A has 35% IRR on $10k investment. Project B has 18% IRR on $500k investment. Which creates more value?
Project A (higher IRR)
Likely Project B (much larger scale)
They create equal value
Cannot determine without more info
9. What is Modified IRR (MIRR) designed to address?
Make IRR calculation easier
Use more realistic reinvestment rate assumptions
Remove the need for discount rates
Calculate NPV faster
10. A typical private equity firm targets an IRR of:
5-10%
10-15%
20-25%
40-50%

🧮 Try IRR Calculator

If you've found a bug, or would like to contact us please click here.

Calculate.co.nz is partnered with Interest.co.nz for New Zealand's highest quality calculators and financial analysis.

© 2019–2025 Calculate.co.nz. All rights reserved.
All content on this website, including calculators, tools, source code, and design, is protected under the Copyright Act 1994 (New Zealand). No part of this site may be reproduced, copied, distributed, stored, or used in any form without prior written permission from the owner.
All calculators and tools are provided for educational and indicative purposes only and do not constitute financial advice.
Calculate.co.nz is part of the realtor.co.nz, GST Calculator, GST.co.nz, and PAYE Calculator group.
Calculate.co.nz is also partnered with Health Based Building and Premium Homes to promote informed choices that lead to better long-term outcomes for Kiwi households.