IRR Calculator
Professional investment analysis calculator for calculating internal rate of return (IRR) and net present value (NPV). Analyze investment cash flows, calculate profitability metrics, and make informed investment decisions. Perfect for evaluating business investments, real estate projects, and any investment with multiple cash flows. Features detailed cash flow analysis, profitability metrics, and investment decision criteria. Includes explanations of IRR concepts, NPV calculations, and investment analysis methods. Essential tool for investors, business analysts, and anyone evaluating investment opportunities.
IRR Calculator
Cash Flows
Investment Analysis
How it works: IRR (Internal Rate of Return) is the discount rate that makes the NPV of all cash flows equal to zero. It's used to evaluate the profitability of investments. If IRR > discount rate, the investment is acceptable. NPV (Net Present Value) calculates the present value of future cash flows using a discount rate. The payback period shows how long it takes to recover the initial investment.
What Is an IRR Calculator?
An IRR calculator finds the internal rate of return — the discount rate at which the net present value (NPV) of all cash flows from an investment equals zero. IRR is the single most widely used metric in corporate capital budgeting and private equity because it expresses investment performance as a percentage you can compare directly to a hurdle rate or cost of capital. If your company requires a 15% return on new projects and a proposed investment yields an IRR of 22%, the project clears the bar. If IRR is 11%, it destroys value. This calculator solves IRR iteratively from the cash flow schedule you provide.
How to Use This IRR Calculator
- Enter the initial investment as a negative number (cash outflow) in period 0.
- Add each subsequent cash flow — positive for inflows, negative for additional outflows.
- Include the terminal cash flow in the final period (sale proceeds, salvage value, or final revenue).
- Click Calculate. The calculator returns IRR and optionally NPV at your specified discount rate.
- Compare IRR to your hurdle rate (cost of capital). IRR above the hurdle rate signals a value-creating investment.
Worked Example: $10,000 Equipment Investment
A small business buys equipment for $10,000. It generates cash flows of $3,000, $4,000, $4,000, and $3,500 over years 1–4.
IRR ≈ 20.6%
Total cash returned: $14,500 on $10,000 invested over 4 years
At a 12% hurdle rate this project adds value — NPV at 12% = +$1,432
If the business's cost of capital is 25%, this project would not clear the hurdle (IRR 20.6% < 25%).
IRR vs NPV vs Payback — Decision Metrics Compared
| Metric | What It Measures | Decision Signal | Limitation |
|---|---|---|---|
| IRR | Break-even discount rate | IRR > hurdle rate → invest | Can give multiple solutions with non-normal cash flows |
| NPV | Dollar value added today | NPV > 0 → invest | Requires a specific discount rate assumption |
| Payback | Years to recover investment | Shorter → less risk | Ignores time value of money and cash flows after payback |
| MIRR | Modified IRR (reinvestment rate) | MIRR > hurdle rate → invest | More realistic; assumes explicit reinvestment rate |
Key IRR Concepts and the Math Behind It
IRR is the rate r that solves: 0 = CF₀ + CF₁/(1+r) + CF₂/(1+r)² + … + CFₙ/(1+r)ⁿ. There is no closed-form solution — calculators find IRR iteratively using Newton-Raphson or bisection methods, converging on the rate where NPV = 0.
Hurdle rate (required rate of return) is the minimum acceptable IRR. Most corporations set it at their weighted average cost of capital (WACC) plus a risk premium. A company with 8% WACC might require 12% IRR on expansion projects and 18% on new ventures.
Multiple IRRs occur when a cash flow series changes sign more than once (e.g., large outflows mid-project like a cleanup cost). In these cases, use MIRR instead — it assumes a specific reinvestment rate and produces a single unambiguous result.
Common IRR Mistakes to Avoid
Ignoring the reinvestment assumption. IRR implicitly assumes all interim cash flows are reinvested at the IRR itself. If your IRR is 25% but you can only reinvest at 10%, MIRR is a more honest metric. For most real-world projects, MIRR is lower than IRR.
Using IRR alone to rank mutually exclusive projects. IRR measures rate, not magnitude. A $1,000 investment with 50% IRR returns $1,500. A $100,000 investment with 20% IRR returns $120,000. NPV captures magnitude — always use both metrics together when choosing between large and small projects.
Forgetting terminal value. In real estate and PE, the largest cash flow is often the exit proceeds in the final period. Omitting or underestimating terminal value dramatically understates IRR. Include a realistic sale price or salvage value in your last period.
Frequently Asked Questions About IRR
What is a good IRR?
It depends entirely on the investment type and risk. Publicly traded equities historically return 8–10%. Private equity targets 20–30%. Real estate deals typically target 12–18%. A good IRR is any rate that exceeds your cost of capital by a margin that compensates for the risk and illiquidity of the specific investment.
What is the difference between IRR and ROI?
ROI (return on investment) is a simple ratio: (Gain − Cost) ÷ Cost. It ignores the time value of money and when cash flows occur. IRR accounts for timing — a $10,000 gain in year 1 is worth more than the same gain in year 10. For multi-year investments, IRR is a more accurate performance measure.
Can IRR be negative?
Yes. A negative IRR means the investment loses money in present value terms — the total discounted cash outflows exceed the discounted inflows. Any investment with a negative IRR destroys value.
What is the difference between IRR and XIRR?
IRR assumes cash flows occur at equal intervals (annually, quarterly). XIRR handles irregular-dated cash flows — you provide both amounts and exact dates. XIRR is essential for real estate transactions, venture investments, and any deal where cash flows don't follow a neat schedule.
How is IRR used in private equity?
PE firms calculate IRR on the full fund or deal level using all cash flows: capital calls (negative), distributions (positive), and the final exit or NAV. A top-quartile PE fund targets 20%+ IRR net of fees. IRR is usually reported alongside MOIC (multiple on invested capital) because IRR alone doesn't capture the size of absolute returns.
What is a hurdle rate?
A hurdle rate is the minimum acceptable rate of return for an investment. It typically equals the weighted average cost of capital (WACC) plus a risk premium. If a project's IRR exceeds the hurdle rate, it is expected to create shareholder value. If it falls below, it destroys value.
Why do IRR and NPV sometimes conflict?
IRR and NPV can give conflicting rankings when projects differ in scale or timing. For mutually exclusive projects, always follow the NPV decision — it measures absolute value creation in dollars. IRR measures the rate of return percentage but can favor a smaller, faster project over a larger, more valuable one.
What is Modified IRR (MIRR)?
MIRR addresses IRR's reinvestment rate assumption. It calculates the future value of all positive cash flows at a specified reinvestment rate and the present value of all negative flows at a financing rate, then computes the rate that equates those two values. MIRR is always more conservative than IRR and produces a single unambiguous result even for non-normal cash flows.
Related Calculators
ROI Calculator
Calculate simple return on investment for any project
Payback Period Calculator
Find how many years to recover an investment
Investment Calculator
Project investment growth with regular contributions
Present Value Calculator
Discount future cash flows to today's dollars
Future Value Calculator
Project the value of an investment over time
Compound Interest Calculator
Model compounding growth on any principal