IRR Calculator
Calculate Internal Rate of Return (IRR) for investment analysis. Enter your initial investment and expected cash flows to determine annualized returns.
Amount invested at Year 0
Internal Rate of Return
20.53%
ExcellentNet Profit
$80,000
Cash Flow Timeline
IRR
20.5%
Simple ROI
80.0%
NPV @10%
$32,183
Payback
3.3 yrs
Interpreting Your IRR:
- vs. Required Return: IRR should exceed your cost of capital
- vs. Alternatives: Compare with other investment options
- NPV Check: Positive NPV @10% confirms profitability
Strong Investment Potential
An IRR of 20.5% exceeds most hurdle rates. Consider risk factors and alternative uses of capital.
Typical IRR by Investment Type
Real Estate
8-15%
Property investments
Private Equity
15-25%
Buyouts, growth equity
Venture Capital
20-30%+
Startup investments
Corporate Projects
10-15%
Capex decisions
Key Formulas
IRR Definition
NPV = 0 = Σ CFt / (1+IRR)^t
IRR is the rate where net present value equals zero.
NPV Formula
NPV = Σ CFt / (1+r)^t
Sum of discounted cash flows at rate r.
Decision Rule
Accept if IRR > Hurdle Rate
Investment is attractive if IRR exceeds required return.
Frequently Asked Questions
How IRR Is Calculated: The Rate Where NPV Equals Zero
Internal Rate of Return (IRR) is the discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero. Mathematically: 0 = CF₀ + CF₁/(1+IRR) + CF₂/(1+IRR)² + ... + CFₙ/(1+IRR)ⁿ. There is no direct algebraic solution — IRR must be solved iteratively using methods like Newton-Raphson or trial-and-error. Financial calculators and spreadsheet functions (Excel's =IRR()) automate this process.
Consider a $100,000 investment returning $25,000, $30,000, $35,000, $40,000, and $50,000 over 5 years. The IRR is approximately 17.1%. This means the project generates the equivalent of a 17.1% annual compound return on the invested capital. If your company's hurdle rate (minimum acceptable return) is 12%, the project exceeds it by 5.1 percentage points and should be accepted.
| Year | Cash Flow | Cumulative Cash Flow |
|---|---|---|
| 0 | -$100,000 | -$100,000 |
| 1 | +$25,000 | -$75,000 |
| 2 | +$30,000 | -$45,000 |
| 3 | +$35,000 | -$10,000 |
| 4 | +$40,000 | +$30,000 |
| 5 | +$50,000 | +$80,000 |
The payback period in this example is approximately 3.3 years (the point where cumulative cash flows turn positive). Simple ROI is 80% over 5 years. But IRR (17.1%) provides the most meaningful comparison because it accounts for the timing of each cash flow.
MIRR (Modified IRR) and the Multiple IRR Problem
Standard IRR has a significant flaw: it assumes all interim cash flows are reinvested at the IRR rate itself, which is often unrealistic. A project with a 25% IRR assumes you can reinvest every dollar at 25% — rarely possible. Modified Internal Rate of Return (MIRR) solves this by using a separate finance rate (cost of borrowing) for negative cash flows and a reinvestment rate (typically the company's cost of capital or a market return) for positive cash flows.
The multiple IRR problem occurs when cash flows change sign more than once (e.g., initial investment, years of income, then a large decommissioning cost). Mathematically, the IRR equation can have as many solutions as there are sign changes. A project with cash flows of -$100K, +$230K, -$132K has two IRRs: 10% and 20%. In such cases, use MIRR or NPV instead, which always produce a single, unambiguous answer.
Excel's =MIRR(values, finance_rate, reinvestment_rate) function calculates MIRR directly. For the original $100,000 example with a 10% reinvestment rate and 8% finance rate, the MIRR is approximately 14.8% — lower than the 17.1% IRR because the reinvestment assumption is more conservative. MIRR is increasingly preferred in corporate finance and private equity for evaluating fund-level returns.
IRR vs NPV: When to Use Each for Investment Decisions
The IRR decision rule is: accept if IRR exceeds the hurdle rate; reject if it falls below. The NPV decision rule is: accept if NPV is positive; reject if negative. For a single independent project, both methods always agree. The conflict arises when ranking mutually exclusive projects of different sizes or durations.
| Metric | Best For | Limitation |
|---|---|---|
| IRR | Comparing returns across projects | Assumes reinvestment at IRR; multiple IRRs possible |
| NPV | Absolute value creation; accept/reject decisions | Requires choosing a discount rate |
| MIRR | More realistic return estimate | Requires specifying reinvestment rate |
| Payback Period | Liquidity risk assessment | Ignores time value of money; ignores cash flows after payback |
A $1M project with 15% IRR creates $150K in annual returns. A $100K project with 25% IRR creates $25K in annual returns. NPV at 10% discount rate: the $1M project generates $379,000 in NPV while the $100K project generates $61,000. Despite the lower IRR, the larger project creates 6x more value. This is why most finance textbooks recommend NPV as the primary decision tool and IRR as a supplementary metric.
Related Calculators
Official References
Learn more about IRR and investment analysis:
- Understanding Internal Rate of Return
Comprehensive guide to IRR calculations and applications
- CFI: IRR in Corporate Finance
Professional guide to using IRR for investment decisions
This calculator provides estimates. Actual investment returns depend on many factors including timing, risk, and market conditions.