IRR Calculator
Determine the internal rate of return on any series of cash flows to find the true annualized yield of any investment, project, or business decision.
$
%
Enter your values above to see the results.
Tips & Notes
- ✓Compare IRR against your cost of capital or minimum hurdle rate, not against a fixed number — a 15% IRR is excellent if capital costs 8% and poor if capital costs 20%.
- ✓IRR weights early cash flows more than late ones — an investment returning cash quickly will show a higher IRR than one with the same total return spread over more years.
- ✓Use Modified IRR (MIRR) when cash flows change sign more than once — multiple sign changes can produce multiple mathematically valid IRR values that confuse decision-making.
- ✓IRR alone does not account for scale — a project with 25% IRR on $100,000 creates less value than a 15% IRR project on $10,000,000 when absolute returns matter.
- ✓For comparing mutually exclusive projects of different sizes, always combine IRR analysis with NPV analysis — they can point to opposite decisions when scales differ significantly.
- ✓Real estate investors should include terminal value (sale proceeds) as the final cash flow — IRR calculations without exit value significantly understate the true return.
Common Mistakes
- ✗Comparing IRR across projects without considering their scale — a 30% IRR on a $50,000 project creates less total value than a 20% IRR on a $5,000,000 project.
- ✗Using IRR as the sole decision criterion when projects have multiple sign changes in cash flows — this can produce multiple IRR values, making the result meaningless without MIRR.
- ✗Not including all cash outflows in the IRR calculation — ongoing capital expenditures, maintenance costs, and exit costs must all be modeled as negative cash flows.
- ✗Treating the IRR hurdle rate as fixed regardless of project risk — higher-risk investments require a higher IRR to compensate for uncertainty, not the same hurdle as low-risk projects.
- ✗Assuming IRR implies the same reinvestment rate for interim cash flows — IRR implicitly assumes reinvestment at the IRR itself, which overstates returns when the IRR is high.
- ✗Ignoring timing precision when building cash flow models — a cash flow received in month 3 versus month 9 produces a different IRR even if the annual totals are identical.
IRR Calculator Overview
The internal rate of return is the discount rate that makes the net present value of all cash flows from an investment equal to zero. In plain terms: it is the true annualized return of any investment that involves irregular cash flows over time — which describes almost every real business investment, real estate deal, or private equity transaction.
Unlike simple ROI, IRR accounts for the timing of every cash flow. Receiving $50,000 in year one is worth more than receiving $50,000 in year five — IRR captures this difference automatically.
What each field means:
- Initial Investment — the upfront cash outflow at time zero; entered as a negative number (money out)
- Cash Flows — the returns received in each subsequent period; positive for income, negative for additional costs
- Period — the time interval for each cash flow; typically annual but can be monthly or quarterly
What your results mean:
- IRR — the annualized rate of return that makes NPV equal zero; compare against your cost of capital or hurdle rate
- NPV at IRR — confirms the calculation is correct when it equals zero
- Payback Period — how many periods until cumulative cash flows recover the initial investment
Example — $50,000 invested, returns over 5 years:
Year 0: -$50,000 (initial investment) Year 1: +$8,000 Year 2: +$12,000 Year 3: +$15,000 Year 4: +$18,000 Year 5: +$22,000 (including terminal value) Total cash received: $75,000 Simple ROI: 50% over 5 years IRR: approximately 16.3% per year Why IRR differs from simple ROI: IRR weights earlier cash flows more heavily because they compound longer.
EX: Same total cash flows, different timing — how IRR changes Scenario A: receive most cash early ($20k, $18k, $15k, $12k, $10k) IRR: approximately 20.1% Scenario B: receive most cash late ($8k, $10k, $12k, $18k, $27k) IRR: approximately 13.8% Total cash received: identical ($75,000 in both cases) IRR rewards investments that return cash earlier — time value drives the difference.
IRR decision framework:
| IRR vs Hurdle Rate | Decision | Interpretation |
|---|---|---|
| IRR above hurdle rate | Accept | Investment creates value above cost of capital |
| IRR equals hurdle rate | Neutral | Investment breaks even on cost of capital |
| IRR below hurdle rate | Reject | Better to invest capital elsewhere |
Typical IRR benchmarks by investment type:
| Investment Type | Typical Target IRR | Minimum Acceptable |
|---|---|---|
| Large public company project | 15-20% | 8-12% |
| Private equity buyout | 20-25% | 15% |
| Venture capital | 30-40% | 20% |
| Real estate development | 18-25% | 12% |
IRR has one critical limitation: when cash flows change sign more than once (negative, then positive, then negative again), multiple valid IRR values can exist mathematically. In these cases, Modified IRR (MIRR) provides a more reliable single answer by assuming reinvestment of positive cash flows at the cost of capital rather than at the IRR itself.
Frequently Asked Questions
Internal Rate of Return is the discount rate that makes the net present value of all cash flows from an investment equal to zero. It cannot be solved with a direct formula — it requires iterative calculation, starting with a guess and adjusting until NPV reaches zero. Mathematically: 0 = CF0 + CF1/(1+r) + CF2/(1+r)^2 + ... + CFn/(1+r)^n, where r is the IRR. The IRR effectively answers: what annual return rate makes this investment break even in present value terms? Any return above this rate creates positive NPV and destroys value below it.
A good IRR is one that exceeds your cost of capital or hurdle rate by a meaningful margin. For corporate projects, companies typically require IRR of 15-20% for internal investments. Private equity funds target 20-25%. Venture capital targets 30-40% to compensate for the high failure rate of early-stage investments. Real estate development typically targets 18-25%. The absolute IRR number matters less than the spread above the cost of capital — a 12% IRR when capital costs 6% is as attractive as a 20% IRR when capital costs 14%.
NPV (Net Present Value) discounts all future cash flows to present value using a chosen discount rate and sums them. If NPV is positive, the investment creates value at that discount rate. IRR is the specific discount rate at which NPV equals exactly zero — it is the break-even rate. For accept-reject decisions on a single project, both methods give the same answer: if IRR exceeds the discount rate, NPV is positive and the project adds value. For comparing mutually exclusive projects of different sizes, NPV is more reliable because it measures absolute value creation rather than a percentage rate.
Yes — a negative IRR means the investment destroys value even before accounting for the time value of money. It occurs when total cash inflows are less than the initial investment, adjusted for timing. A project costing $100,000 that returns $30,000 per year for 3 years has a negative IRR because total returns of $90,000 fall short of the $100,000 investment. Negative IRR investments are straightforwardly bad — they lose money in absolute terms. The more common concern is a positive IRR that falls below the cost of capital, meaning the investment destroys value relative to alternatives even though it technically makes money.
Modified IRR (MIRR) addresses two weaknesses of standard IRR: it assumes interim positive cash flows are reinvested at the cost of capital rather than at the IRR itself, and it resolves the multiple IRR problem that occurs when cash flows change sign more than once. MIRR typically produces a lower, more conservative return estimate than IRR when the IRR is high, making it more realistic for projects with significant interim cash flows. Use MIRR when: cash flows change sign more than once, you want to avoid the reinvestment rate assumption embedded in standard IRR, or you are comparing projects across different organizations with different reinvestment opportunities.
Real estate investors use IRR to evaluate the total return on a property over a projected holding period, combining rental income, operating expenses, mortgage payments, and eventual sale proceeds. A typical IRR calculation models: initial equity invested (negative), annual net cash flow after debt service (positive or sometimes negative in early years), and projected sale proceeds minus remaining mortgage balance in the exit year (positive). A 15-20% IRR on a leveraged real estate investment is generally considered strong. IRR is particularly valuable in real estate because it incorporates the time value of money in a way that simple cap rate or cash-on-cash calculations do not.