IRR Explained: How Internal Rate of Return Actually Works
The internal rate of return is the discount rate that makes a project's net present value equal to zero — the rate at which its future cash flows exactly recover the upfront investment. It is the most-quoted single number in capital budgeting and one of the most misread. This guide walks through the formula, shows how the calculator solves it numerically, runs a full five-year worked example, and explains the multiple-IRR and reinvestment-rate problems that catch first-year MBA students every September.
What IRR actually measures
The internal rate of return is the discount rate at which the present value of a project's future cash inflows exactly equals its upfront cost. Run the IRR calculator on a $10,000 investment that pays $3,000 a year for five years and the answer comes back at roughly 15.24%. That is the rate at which you can discount the five $3,000 cash flows so they sum to exactly $10,000 in today's money. Below 15.24%, the inflows are worth more than the outlay and the project creates value. Above 15.24%, the inflows are worth less and the project destroys value. The IRR is the break-even discount rate — the highest cost of capital the project can absorb before it stops paying.
That single number is why IRR became the default capital budgeting metric in corporate finance and private equity. A single percentage is intuitively comparable across projects of wildly different sizes — a $50,000 equipment upgrade and a $50,000,000 factory build can both report a 14% IRR, and the comparison is fair on a per-dollar-deployed basis. NPV, the other heavyweight metric, expresses value in absolute dollars and so cannot be compared cleanly across project sizes. The cost of that intuition, as the rest of this guide unpacks, is that IRR makes several silent assumptions that misfire on anything other than vanilla one-outflow-then-inflows cash profiles.
The IRR formula
IRR is defined by the equation that sets net present value to zero:
NPV(r) = -C0 + Σ CF_t / (1 + r)^t = 0
Where C0 is the initial investment, CF_t is the cash flow in period t, and r is the rate to solve for. For a constant annual cash flow over n years the sum collapses to the standard annuity form:
-C0 + CF × (1 − (1 + r)^(-n)) / r = 0
That second equation is what the IRR calculator on this site solves. The structure has no algebraic solution beyond n = 4 — the polynomial degree gets too high for closed-form roots — so the calculator solves it numerically. Newton-Raphson iteration starting at r = 10% converges quadratically for well-behaved cash flows and typically lands inside five to ten iterations. If the iterate runs away (the derivative goes flat near a turning point, or the rate leaves a sensible range) the calculator falls back to bisection between -99% and 1000%, which is slower but cannot diverge as long as a root exists. Excel's IRR function uses the same general algorithmic approach.
Worked example: a five-year factory upgrade
A manufacturer is considering a $10,000 investment in a production-line upgrade that is expected to save $3,000 per year in operating costs for five years. The company's hurdle rate is 10%. Should the project go ahead?
Step one is to write down the cash-flow series. Year 0 is the outflow of $10,000. Years 1 through 5 are inflows of $3,000 each. Step two is to set up the NPV equation and solve for r:
-10,000 + 3,000 × (1 − (1 + r)^(-5)) / r = 0
At r = 10% the right-hand side comes out to about $1,372 of positive NPV — the project clears the hurdle, but by how much in rate terms? Pushing r higher reduces NPV; at r = 15% NPV is roughly $56, and at r = 16% NPV is roughly -$179. The IRR sits between 15% and 16%. The numerical solver narrows in on r = 15.2382%, which makes the equation hold to four decimals. At that rate, each of the five $3,000 cash flows discounts to a value such that the five present values sum to exactly $10,000.
The decision is then trivial: the IRR of 15.24% exceeds the hurdle rate of 10%, so the project creates value at the firm's cost of capital and should be accepted. The cushion is comfortable — there is about 524 basis points of safety margin before the hurdle would be missed.
Change one input and the answer shifts sharply. Cut the project life to four years instead of five and the IRR drops to about 7.71%, which fails the same 10% hurdle and the project is rejected. Run the same exercise on a different scenario yourself with the internal rate of return calculator — the sensitivity to the project horizon is the single most common reason IRR projects move from green to red between an initial pitch and a final business case.
How IRR relates to NPV
Net present value and IRR are two views of the same discounted-cash-flow model. NPV asks "at our cost of capital, what dollar value does this project add?"; IRR asks "what is the highest cost of capital this project can absorb before it adds nothing?" Both use the same cash flows; both rely on the same time-value-of-money mechanics. The NPV calculator produces a dollar figure at a chosen discount rate, while the IRR calculator produces the rate at which that NPV is zero.
For independent projects — accept or reject each on its own merits — IRR and NPV give the same answer. A project with positive NPV at the cost of capital has, by definition, an IRR above the cost of capital, and the two metrics agree.
For mutually exclusive projects — choosing between A and B — they can disagree. Project A might have a 35% IRR but only $50,000 of NPV because it is small; project B might have a 12% IRR but $500,000 of NPV because it is large. IRR prefers A, NPV prefers B. Corporate finance textbooks side with NPV in this scenario because dollars of value created are what shareholders ultimately care about, but in practice capital-constrained firms often follow IRR because they cannot deploy the full $500,000 anyway. This is the classic NPV-vs-IRR ranking conflict.
The multiple-IRR problem
Descartes' rule of signs says a polynomial can have as many positive real roots as sign changes in its coefficients. A conventional project — one outflow followed by all inflows — has exactly one sign change in its cash-flow series and therefore exactly one IRR. Most projects are conventional, which is why most of the time the metric behaves itself.
Some projects are not conventional. A mining project may have a large up-front capex, then a decade of operating cash flows, then a large negative cash flow in the final year for site restoration and decommissioning. That cash-flow series has two sign changes (outflow → inflows → outflow) and can produce two IRRs, both of which mathematically satisfy NPV(r) = 0 but neither of which is a meaningful hurdle. The same shape appears in oil and gas projects with plug-and-abandonment liabilities, in nuclear power, in some real estate projects with major mid-life refurbishment capex, and in any project with a final-year working-capital return that exceeds the final-year operating cash flow.
When the cash-flow series is non-conventional, fall back to NPV at the cost of capital, or use Modified IRR (MIRR). MIRR addresses both the multiple-IRR problem and the reinvestment-rate problem (covered below) by compounding every intermediate cash flow forward at the firm's reinvestment rate, then solving for the single rate that equates the present value of outflows with the future value of inflows.
The reinvestment-rate assumption
The most subtle structural problem with IRR is the reinvestment-rate assumption. The formula implicitly assumes that every intermediate cash flow gets reinvested at the IRR itself. For a project with a 10% IRR this is usually fine — a firm earning 10% on its core business can plausibly redeploy intermediate cash flows at similar rates. For a project with a 40% IRR it is rarely realistic. The firm almost certainly cannot find a queue of equally good 40% projects to absorb each year's free cash; the realistic reinvestment rate is probably the firm's WACC.
The consequence is that headline IRR overstates the effective return for high-IRR projects, sometimes dramatically. A project showing a 35% IRR over ten years may have an effective return closer to 15% once intermediate cash flows are realistically reinvested at the firm's 8% cost of capital. MIRR makes this explicit by separating the finance rate (the rate at which outflows are funded) from the reinvestment rate (the rate at which inflows are compounded forward). Whenever you see a private-equity or infrastructure pitch quoting a 25%+ IRR, the right follow-up question is "what does the MIRR look like at our cost of capital?" — the answer is usually a humbling ten-point gap.
What the IRR calculator does not do
The IRR calculator on this site is designed for the most common case — a constant annual cash flow over a finite project horizon. That covers equipment-leasing decisions, real estate cash flows normalised to a flat rent, simple bond-like instruments, and the back-of-envelope appraisal of any project that has been pre-summarised into a single representative annual figure. For lumpy real-world cash flows with ramp-up periods, terminal values, irregular distributions, or mid-life capex, lay the series out year by year in a spreadsheet and use Excel's IRR or XIRR functions, both of which accept an arbitrary cash-flow array. The underlying mathematics is identical; only the polynomial degree changes.
The calculator also cannot tell you what cash flow to put in. That is the modelling job — and it is where most IRR errors actually live. A 17% IRR on cash flows you cannot defend is worth less than a 9% IRR on cash flows you can. Sensitivity analysis (what does the IRR look like if the cash flow comes in 20% below plan?) is at least as useful as the headline number.
Common mistakes when interpreting IRR
Comparing IRR without normalising for project horizon
A two-year project with a 30% IRR is not directly comparable with a ten-year project at 18%. The two-year project requires you to find another project to deploy the capital into for the remaining eight years. If the reinvestment rate is your cost of capital rather than 30%, the longer project may produce more value despite the lower rate. This is the reinvestment-rate problem in disguise.
Treating IRR as a profit number
IRR is a rate, not a dollar figure. A 50% IRR on a $10 project does not pay the rent. Use IRR alongside the NPV calculator to get both rate and scale before deciding which projects to fund.
Ignoring the multiple-IRR warning
If your cash flows change sign more than once, the headline IRR returned by any tool is one of several mathematically valid roots. Switch to NPV or MIRR before using the figure in a decision.
Using a single firm-wide hurdle for every project
High-risk and low-risk projects should be appraised against different hurdles. Forcing a 12% hurdle on a low-risk contracted-cash-flow project rejects value; forcing the same hurdle on a high-risk speculative project accepts value-destroying bets. Risk-adjust the hurdle to the project's cash-flow risk, not the firm's overall risk.
How IRR fits with payback and other metrics
A practical capital-budgeting workflow uses three or four metrics in concert, not IRR alone. Start with the payback period calculator as a fast liquidity screen — would the project return its capital inside a sensible window for this industry? Then use the IRR calculator to confirm the rate of return clears the risk-adjusted hurdle. Finally, use the NPV calculator to confirm the absolute dollar value created at the firm's cost of capital and to break ties between mutually exclusive projects. For shorter-horizon or single-period decisions, the ROI calculator gives the simple percentage gain without any discount-rate machinery.
Each metric answers a different question. Payback measures capital exposure. IRR measures break-even cost of capital. NPV measures absolute value creation. ROI measures simple proportional return. No single number captures all four, and no responsible appraisal stops at one.
When to seek professional advice
The maths of IRR is universal — the same calculator works for a private real estate deal, a small-business equipment upgrade, a corporate capex project, or a private equity fund return. The judgement calls are not universal: the right hurdle rate, the right cash-flow forecast, the right treatment of tax and inflation, the right reinvestment assumption. For large capital commitments, regulated investment products, or anything where the cash flows depend on tax treatment, get a finance or accounting professional to validate the inputs before relying on the output. The calculator is built for back-of-envelope work and educational use, not as a substitute for professional capital-budgeting advice on material commitments.
Try the IRR calculator
Run your own numbers through the IRR calculator to see how sensitive the rate of return is to the project horizon and the size of the annual cash flow. Pair it with the NPV calculator at your cost of capital and the payback period calculator as a liquidity check for the kind of three-metric appraisal that quietly rejects most of the bad projects before they get to the board.
Frequently asked questions
What is a good IRR?
Good is anything comfortably above your hurdle rate, which in turn should reflect the risk of the project. For a stable corporate appraising an internal capex project, a hurdle of 8–12% (the weighted average cost of capital for typical listed companies) is normal, so an IRR above ~15% is considered attractive. Venture-style projects with high risk and illiquidity demand 20–30%+ IRRs to justify the risk premium. Private real estate often clears at 10–15% IRR. The number alone is meaningless without the hurdle rate next to it — a 12% IRR is excellent for a Treasury-grade cash flow and terrible for a startup.
What is the difference between IRR and NPV?
NPV is the dollar amount of value a project creates at a chosen discount rate; IRR is the discount rate at which that NPV becomes zero. They answer different questions. NPV tells you "how much value does this project add?" — a scale measure. IRR tells you "what rate of return does this project earn?" — a rate measure comparable across projects of different sizes. For ranking mutually exclusive projects, NPV is the textbook-correct tool because it captures absolute value. For screening a portfolio of independent projects by capital efficiency, IRR is more intuitive. In practice good appraisers compute both.
Can a project have more than one IRR?
Yes. Descartes' rule of signs says a polynomial can have as many positive real roots as sign changes in its coefficients. A conventional project (one upfront outflow followed by all inflows) has exactly one sign change and exactly one IRR. A project with cash flows that flip sign more than once — mining projects with large decommissioning costs at the end, oil and gas projects with late-life environmental clean-up, real estate projects with mid-life refurbishment capex — can produce two or even three IRR values, none of which is a sensible hurdle. For non-conventional cash flows fall back to NPV at the cost of capital, or use Modified IRR (MIRR), which assumes reinvestment at the cost of capital and produces a unique solution.
Why might no IRR exist?
IRR is the rate that makes NPV zero, so it only exists when the cash-flow series can cross zero NPV. If every cash flow is positive (somebody just hands you money for nothing, no upfront cost) or every cash flow is negative (a money-pit project that never returns anything), NPV never crosses zero and IRR is undefined. The calculator returns "no IRR" in that case rather than guessing. Practically you should check that your initial investment is entered as a positive number, your annual cash flow is positive, and the total of all cash inflows over the project horizon exceeds the initial investment. If undiscounted inflows do not even sum to the outlay, no positive IRR can exist.
How does IRR compare with the payback period?
They are different lenses on the same project. The payback period asks "how long until I recover my capital?" — IRR asks "what rate of return does the whole stream earn?" A project with a short payback often has a high IRR, but the relationship is not tight: a project that pays back fast and then dies earns less than a slower-payback project with a long tail of cash flows. Payback also ignores the time value of money entirely (unless you use discounted payback), while IRR uses every cash flow over the project's life. Best practice is to use the payback period as a liquidity and risk screen, then rank surviving projects on IRR and NPV.
What hurdle rate should I use?
Your required rate of return — the return you could earn on an investment of equivalent risk. For a listed company this is typically the weighted average cost of capital, usually 7–12% for stable industries. For a personal investment, use opportunity cost: maybe 10–15% if you are choosing between this project and running a small business, 6–8% if the alternative is a defensive real estate hold, 4–5% if the alternative is a Treasury bond. The hurdle should reflect the risk of the project's cash flows, not the risk of your other holdings. A higher-risk project demands a higher hurdle; using a single firm-wide WACC for every project regardless of risk is the most common practical error in capital budgeting.
What is the reinvestment-rate assumption in IRR?
IRR implicitly assumes that every intermediate cash flow gets reinvested at the IRR itself. For a project with a 25% IRR this is often unrealistic — the firm cannot necessarily redeploy those year-by-year cash flows at 25%. Modified IRR (MIRR) corrects this by separating the reinvestment rate from the project's own IRR. It compounds intermediate cash flows forward at the firm's cost of capital, then solves for the rate that equates the present value of outflows with the future value of inflows. MIRR is always closer to the cost of capital than IRR, and gives a more realistic picture of effective return for projects where IRR is much higher than the firm's reinvestment opportunities.
How does the calculator solve for IRR?
There is no closed-form algebraic solution for IRR when the project horizon exceeds four years — the equation is a polynomial of degree n and has no general formula. The calculator uses Newton-Raphson iteration starting at r = 10%, which converges quadratically for well-behaved conventional cash flows and typically lands inside 5–10 iterations. If Newton-Raphson fails (the derivative goes to zero or the iterate leaves a sensible range) the calculator falls back to bisection between -99% and 1000%, which is slower but guaranteed to converge as long as a root exists in that interval. The same algorithmic approach is what Excel's IRR function uses under the hood.
Informational only. Not personalised financial, legal, or tax advice.