Internal Rate of Return: Calculate and Interpret IRR Correctly

Learn how IRR solves for a zero NPV, when periodic IRR differs from XIRR, why multiple roots and project rankings can mislead, and how to pair IRR with NPV.

For educational purposes only; not investment advice. Investing may result in loss.

Direct answer

Internal rate of return (IRR) is a discount rate r that makes the net present value of a specified cash-flow schedule equal to zero:

0 = NPV(r) = Σ[CF_t / (1 + r)^t]

For a conventional project with one initial outflow followed by inflows, IRR is a useful break-even return diagnostic. If its single IRR exceeds a project-appropriate hurdle rate on the same period, currency, inflation, tax, and cash-flow basis, the project also has positive NPV at that hurdle rate. The percentage is a model output, not an observed return, a guarantee, or a complete project ranking.

IRR can be ambiguous or misleading when cash flows change sign more than once, dates are irregular, projects are mutually exclusive, capital is constrained, or financing is mixed into operating cash flows. Review the NPV profile and dollar NPV rather than accepting one calculator result without reconciliation.

How it works

Build and test the calculation in this order:

Define the decision and cash-flow owner. Use incremental after-tax cash flow to the firm with a project cost of capital, or cash flow to equity after debt flows with a cost of equity. Do not calculate an equity IRR and compare it with WACC, or calculate a project IRR and compare it with cost of equity.
Construct the complete timeline. Set t = 0 at the valuation date and record capex, operating cash flows, taxes, changes in working capital, opportunity costs, cannibalization, terminal cleanup, salvage proceeds, and other incremental effects. Exclude sunk costs and avoid counting financing flows in an unlevered project schedule.
Choose periodic or dated discounting. Periodic IRR assumes equally spaced cash flows and returns one rate per period. For irregular dates, use a documented dated equation such as 0 = Σ[CF_i / (1 + r)^((date_i - date_0) / 365)]; spreadsheet XIRR uses a 365-day basis, while other systems may use different day-count or compounding conventions.
Solve, then verify. A numerical solver searches for r, often from a user or default guess. Confirm that recalculated NPV is near 0, scan a reasonable rate range, and graph the NPV profile. A different starting guess may find a different root or fail even when another root exists.
Interpret the number in matching units. A monthly IRR is a monthly rate. Under monthly compounding, its effective annual equivalent is (1 + monthly IRR)^12 - 1, not automatically 12 × monthly IRR. Keep nominal and real cash flows, currency, taxes, and hurdle-rate conventions aligned.
Apply the correct decision rule. For one independent conventional project, accept when NPV at the appropriate hurdle rate is positive; the equivalent single-root statement is IRR > hurdle rate. For mutually exclusive projects, choose the feasible alternative with the greatest positive NPV at the opportunity cost of capital, not necessarily the highest IRR. An incremental IRR or crossover rate can explain a ranking conflict but does not replace NPV.
Stress and reconcile. Vary prices, volume, margins, capex, working capital, taxes, timing, terminal cash flow, financing, and discount rate. Compare IRR with NPV, payback, scale, liquidity, capacity constraints, and scenario outcomes. MIRR can impose explicit finance and reinvestment rates, but its convention and terminal horizon must be stated and it is still not a substitute for dollar value creation.

A periodic IRR calculation ordinarily requires at least one negative and one positive cash flow. More than one sign change can create multiple real roots, but a sign change does not guarantee that every possible root is real, economically meaningful, or found by a specific solver. If NPV does not cross zero over the economically admissible rate range, report that no usable IRR exists rather than forcing a percentage.

Example

Use four separate checks rather than relying on one headline rate:

Conventional project: cash flows of -$10.0000m at t = 0, then $4.0000m, $4.5000m, and $5.0000m at three annual period ends produce IRR = 15.9753%. At a 10.0000% annual hurdle, NPV = -$10m + $4m / 1.10 + $4.5m / 1.10^2 + $5m / 1.10^3 = $1.1119m. The positive NPV and above-hurdle IRR agree because this is a conventional schedule.
Scale conflict: Project B pays -$1.0000m now and $1.3000m in one year, so its IRR is 30.0000% and its NPV at 10.0000% is $0.1818m. Mutually exclusive Project C pays -$10.0000m now and $12.0000m in one year, so its lower IRR is 20.0000% but its higher NPV is $0.9091m. If both are equally feasible and appropriately risk-adjusted, Project C creates more modeled dollar value.
Multiple roots: the nonconventional schedule -$100.0000, +$230.0000, -$132.0000 has two IRRs, 10.0000% and 20.0000%. Its NPV at 15.0000% is about $0.1890, so neither a rule based on one returned root nor the phrase “IRR above the hurdle” describes the profile reliably. Inspect the full NPV curve.
Irregular dates: dated cash flows of -$1,000.0000 on 2026-01-01, +$300.0000 on 2026-07-01, +$400.0000 on 2027-04-01, and +$500.0000 on 2028-01-01 produce a 365-day-basis XIRR of about 14.4803%. At 10.0000%, dated XNPV is about $54.5641. Treating these four dates as equally spaced annual periods answers a different question.

Risks

State whether the schedule measures project, firm, or equity cash flow and use the matching hurdle rate.
Use incremental cash flows; exclude sunk costs but include opportunity costs and cannibalization.
Include capex, working capital, taxes, fees, terminal cleanup, salvage, and abandonment effects on their actual dates.
Keep nominal cash flows with nominal rates and real cash flows with real rates in the same currency.
Record whether each cash flow occurs at period beginning, period end, or a specific date.
Use periodic IRR only for equally spaced periods and label whether the result is monthly, quarterly, or annual.
Convert a period rate to an effective annual rate by compounding, not by automatic multiplication.
For irregular dates, state the date system, day-count basis, compounding convention, and software used.
Require at least one negative and one positive cash flow before expecting a standard periodic or dated IRR.
Count cash-flow sign changes and inspect the NPV profile for multiple, missing, or economically inadmissible roots.
Test more than one solver guess and independently verify that each reported root makes NPV approximately zero.
Do not interpret a solver error as proof that no mathematical root exists, or one returned root as proof that it is unique.
Apply the simple IRR > hurdle rate rule only to an independent conventional project with a unique relevant root.
Rank mutually exclusive projects by NPV at the appropriate opportunity cost of capital, with feasibility and risk held consistent.
Use incremental analysis to investigate timing or scale conflicts, while retaining NPV as the value criterion.
State the finance rate, reinvestment rate, horizon, and tool convention when reporting MIRR.
Do not treat reinvestment at IRR, MIRR, or the hurdle rate as a realized outcome without actual matching opportunities.
Separate an equity IRR boosted by borrowing from an improvement in underlying project economics.
Under capital rationing, model the feasible portfolio and constraints; IRR alone may not maximize total NPV.
Preserve full precision, reconcile calculator outputs, and stress uncertain cash flows instead of presenting one precise percentage as certain.

Common misconceptions

“IRR is the annual return investors will earn.” It is a root of a specified forecast; its frequency, dates, cash-flow basis, and assumptions determine what the percentage means.
“The project with the highest IRR creates the most value.” IRR ignores dollar scale and can conflict with NPV for mutually exclusive projects with different size or timing.
“Every cash-flow schedule has one IRR.” A schedule may have one root, multiple roots, no usable root, or a solver-dependent reported result.
“XIRR is just a more precise display of periodic IRR.” XIRR discounts actual dates under a stated day-count convention, so it models a different timeline when spacing is irregular.
“MIRR fixes every IRR problem.” It makes financing and reinvestment assumptions explicit under one convention, but inputs, scale, project risk, and NPV still require separate judgment.

Sources

OpenStax: Internal Rate of Return (IRR) Method.
OpenStax: Choosing between Projects.
Microsoft Support: Go with the cash flow - Calculate NPV and IRR in Excel.
Microsoft Support: XIRR function.
Microsoft Support: MIRR function.
NYU Stern / Aswath Damodaran: Corporate Finance materials and investment-analysis resources.