Internal Rate of Return

What IRR represents

Internal rate of return is the discount rate that makes the net present value of a cash-flow stream equal zero. The rate is “internal” to the cash flows: it is calculated from the investment’s outflows and inflows rather than supplied as the required return. If a project costs $1,000 now and pays $1,100 one year later, its IRR is 10%, because -$1,000 + $1,100/(1 + 0.10) = 0.

For a conventional project with one initial outflow followed by positive inflows, a higher IRR can indicate a higher percentage return. A decision rule often compares IRR with a required return or hurdle rate. If IRR exceeds the required return, the project may create value under the assumptions; if it is below, it may fail to compensate for the opportunity cost. The required rate must fit the project’s risk and cash-flow basis.

IRR does not tell you how many dollars of value the project creates. A 30% return on a $100 project may add less value than a 12% return on a $1 million project. Net present value expresses value in currency units and is often clearer for mutually exclusive projects. Use the metric that matches the decision rather than treating the largest percentage as automatically best.

The rate and cash-flow periods must match. If cash flows are annual, the calculated IRR is an annual periodic rate under the timeline convention. If cash flows are monthly, a monthly IRR may need conversion to an effective annual rate. Do not report an annual percentage without stating how the periodic result was annualized.

Find IRR by setting NPV to zero

The equation for IRR is 0 = Σ[CFt ÷ (1 + IRR)^t], including the initial cash flow at time zero. For a single outflow followed by multiple inflows, the equation is usually solved iteratively rather than by a simple rearrangement. A financial calculator or spreadsheet can find a numerical solution, but the result should be checked against the cash-flow timeline and a calculated NPV.

Consider an investment costing $1,000 today and returning $600 at the end of each of the next two years. IRR solves 0 = -1,000 + 600/(1 + r) + 600/(1 + r)^2. At 13%, the present value of inflows is about $530.97 + $469.89 = $1,000.86, so NPV is slightly positive. The IRR is just over 13%, approximately 13.07%.

A useful check is to calculate NPV at a rate below and above the estimated IRR. At 10%, the inflows total about $1,041.32, so NPV is positive $41.32. At 15%, they total about $975.33, so NPV is negative $24.67. The IRR lies between those rates because NPV falls as the discount rate rises for this conventional cash-flow pattern.

Linear interpolation can approximate an IRR between two test rates. If NPV is +$41.32 at 10% and -$24.67 at 15%, a rough estimate is 10% + [41.32/(41.32 + 24.67)] × 5%, or about 13.13%. The exact result differs slightly because NPV is not a straight line in the discount rate. Interpolation is a starting estimate, not a precise solution.

Conventional and nonconventional cash flows

Conventional cash flows have one sign change: an initial investment outflow followed by positive inflows. In many such cases, there is one economically relevant IRR. Nonconventional cash flows change sign more than once, such as an initial outlay, interim positive cash flows, and a large cleanup cost at the end. This pattern can produce more than one IRR or no real IRR, so a single percentage may not summarize the project.

Suppose a project has cash flows of -$100 at time zero, +$230 at year one, and -$132 at year two. The sign changes twice. The NPV equation is -100 + 230/(1 + r) - 132/(1 + r)^2 = 0. Multiplying through gives a quadratic that has two roots, 10% and 20%. Which IRR should determine acceptance? The cash-flow sequence does not provide a unique answer.

When multiple IRRs exist, use NPV at the appropriate required return to evaluate the project. NPV produces one value for a given rate and cash-flow set, even when the stream has multiple IRRs. A candidate should not choose whichever IRR makes the project look attractive. Explain the sign changes and use the metric that answers the investment decision.

Some cash-flow patterns may have no discount rate that makes NPV exactly zero within the relevant range. Numerical software may return an error or a root that depends on the starting guess. Check the NPV profile across plausible rates and use NPV for the required return. A failed calculator result does not mean the cash flows are invalid; it can indicate that IRR is not a useful summary for that pattern.

IRR and NPV can rank projects differently

Mutually exclusive projects can have different scales and timing. IRR measures a percentage, while NPV measures value added. Project A might cost $10,000 and generate a 25% IRR, while Project B costs $1 million and generates a 15% IRR. If the projects are comparable in risk and the company can choose only one, Project B may create more total value despite its lower rate.

Timing can also create a ranking conflict. One project may return cash earlier, producing a higher IRR, while another pays more later and has a higher NPV at the required rate. The reinvestment assumptions behind IRR can further affect interpretation. For mutually exclusive choices, calculate NPV at the appropriate rate and compare incremental cash flows when useful.

The crossover rate is the discount rate at which two projects have equal NPV. Below or above that rate, their NPV ranking can change. To find it, calculate the difference in the projects’ cash flows and solve for the IRR of that incremental stream. This method can explain why rankings change across required returns, but it still depends on project risk and the decision context.

A project with a high IRR but short duration may be attractive for a constrained investor, while a lower IRR long-term project may fit a different strategy. Compare liquidity, scale, uncertainty, capital rationing, and alternative uses of funds. IRR is not a substitute for understanding the cash-flow pattern.

Reinvestment assumptions and modified IRR

Traditional IRR is often interpreted as if interim cash inflows can be reinvested at the IRR until the project ends. That may be unrealistic when the IRR is unusually high. The actual reinvestment rate may be closer to the firm’s cost of capital or another available return. NPV assumes interim cash flows are discounted at the required rate, which can be more practical for value comparisons.

Modified internal rate of return (MIRR) changes the reinvestment and financing assumptions by using specified rates for positive and negative cash flows. It can produce one rate for cash flows with multiple sign changes under its convention. But MIRR requires choices about finance and reinvestment rates, and it is not a universal replacement for NPV. State the assumptions and compare results with the project’s required return.

The reinvestment limitation does not make IRR useless. It remains intuitive for conventional cash flows and can help communicate a project’s implied percentage return. Use it with NPV, scale, duration, and a realistic financing plan. Never promise that a project compounds at its IRR unless the cash flows can actually be reinvested at that rate.

Worked case: comparing scale and value

Project A costs $50,000 and pays $30,000 at each of the next two year-ends. Project B costs $500,000 and pays $290,000 at each year-end for two years. Both may produce similar percentage returns, but Project B is ten times larger. At a 10% required return, A’s NPV is -50,000 + 30,000/1.10 + 30,000/1.10^2, about $2,066. Project B’s NPV is about $20,661, ten times as large if all flows scale exactly.

If a company has only $100,000 to invest, it cannot choose all of Project B. Capital constraints change the problem. It may choose A and invest remaining funds elsewhere, or scale a project if cash flows scale proportionally. The analyst should compare feasible combinations, not simply choose the highest IRR. The assumption that a project can be scaled without changing risk or return must be tested.

Suppose A’s IRR is 13% and B’s is 11%. The higher rate alone favors A, but if the company can finance B and its NPV at the required return is much larger, B may contribute more value. If financing is constrained or B adds concentration and execution risk, A may fit better. The decision requires both the model and the company’s capital context.

IRR for bonds and client investments

A bond’s yield to maturity is an internal rate of return on its promised cash flows, under assumptions about payment, holding to maturity, and reinvestment. Yield to call uses a different redemption date and price. These yield measures do not guarantee the investor’s realized return if the issuer defaults, the bond is sold early, or coupons are reinvested at different rates.

For a client investing in a private project, an advertised IRR may rely on projected cash flows, leverage, a sale value, or assumptions about when distributions occur. Ask whether the figure is gross or net of fees, realized or projected, before or after taxes, and whether it includes return of principal. Compare cash-flow timing, downside scenarios, liquidity restrictions, and the client’s capacity for loss.

A fund may report time-weighted returns, money-weighted returns, or IRR depending on the investment and reporting context. Money-weighted results reflect the timing and size of investor cash flows; time-weighted performance removes the effect of external cash-flow timing to evaluate the manager’s investment performance. The terms are related but answer different questions. Read the method used before comparing reported percentages.

Common IRR mistakes

Do not say IRR is the cash flow or the total dollar profit. It is a rate that sets NPV to zero for a specified cash-flow stream.

Do not assume there is only one IRR. Multiple sign changes can produce multiple solutions or no useful real solution. Check the cash-flow signs and use NPV when needed.

Do not rank mutually exclusive projects by IRR alone. Scale and timing can make the higher percentage project add less total value. Compare NPV at a risk-appropriate required return.

Do not confuse an IRR with a guaranteed realized return. Reinvestment, default, timing, fees, and forecast errors affect actual results.

Do not report monthly IRR as annual without conversion. Match rate frequency and cash-flow intervals; state the convention.

A practical IRR workflow

Write the cash flows in date order, with the initial investment at time zero. Count sign changes. Confirm whether periods are annual, quarterly, or monthly. Solve the NPV-equals-zero equation with a calculator or spreadsheet, then test the result by computing NPV at that rate. If NPV is not close to zero, check signs, timing, and the calculator’s cash-flow settings.

Compare IRR with the required return only when the cash flows and risk basis match. For mutually exclusive projects, calculate NPV and consider incremental cash flows. For nonconventional flows, inspect the NPV profile and avoid choosing one root arbitrarily. State the reinvestment and financing assumptions if using MIRR.

For client advice, treat an IRR as a summary of modeled cash flows. Check fees, liquidity, tax, credit, exit assumptions, and downside outcomes. The client’s goal, horizon, diversification, and risk capacity determine whether the investment fits. A percentage alone cannot answer suitability.

Sources

CFA Institute Research Foundation, Net Present Value and Internal Rate of Return; NASAA Series 65 Test Specifications; OpenStax Principles of Finance, TVM and project valuation formulas.