IRR Guide - Internal Rate of Return
📊 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.
The IRR Concept
IRR is the rate at which:
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.
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 |
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?
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%:
Try 18%:
Try 17%:
Using Excel (Much Easier)
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.
🌍 Real-World IRR Applications
Scenario: Restaurant owner considering second location.
Investment Details:
IRR Calculation:
Decision:
The 21.3% return justifies the risk and beats alternative investments. Owner proceeds with confidence.
Scenario: Evaluating rental property purchase.
Purchase Details:
Cash Flows:
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.
Scenario: PE firm acquires manufacturing company.
Investment Structure:
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):
IRR Calculation:
PE firm targets 20-25% IRR. At 32.1%, this is an excellent investment if projections hold.
Scenario: Comparing two mutually exclusive projects.
Project Alpha:
Project Beta:
The Dilemma:
| Metric | Alpha | Beta |
|---|---|---|
| IRR | 30% (winner) | 18% |
| NPV | $1,818 | $18,882 (winner) |
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
Situations like yours. The 4 situations worked through above sit alongside 54 more about saving and investing, each with the sums shown.