Internal Rate of Return (IRR) Rule: Formula and Benefits

Search Fintrev

Search our guides, reviews and glossary.

The internal rate of return (IRR) rule is a capital budgeting guideline: accept a project or investment when its IRR is higher than the minimum required rate of return (the hurdle rate, often the cost of capital), and reject it when the IRR is lower. The IRR itself is the discount rate at which the net present value (NPV) of all the project’s cash flows, including the initial outlay, equals exactly zero.

What the IRR Rule Says

The rule compares two percentages. The first is the project’s IRR, which is the annualized return implied by its projected cash flows. The second is the hurdle rate, which is the return the company or investor requires before committing capital. Many firms set the hurdle at their weighted average cost of capital (WACC), sometimes with a premium added for riskier projects.

The decision logic is short:

• IRR above the hurdle rate: the project is expected to earn more than its capital costs, so the rule says accept.
• IRR below the hurdle rate: the project is expected to earn less than its capital costs, so the rule says reject.
• IRR equal to the hurdle rate: the project is expected to just cover its cost of capital; NPV at the hurdle rate is zero, and the decision rests on other factors.

The rule is purely financial. It says whether projected cash flows clear a return threshold. It does not weigh strategic value, competitive effects or the risk that the projections themselves are wrong.

The IRR Formula

IRR is defined by setting NPV to zero and solving for the rate:

0 = CF₀ + CF₁ ÷ (1 + IRR)¹ + CF₂ ÷ (1 + IRR)² + … + CFₙ ÷ (1 + IRR)ⁿ

Where:

• CF₀ is the initial outlay at period 0, entered as a negative number because cash leaves the business
• CF₁ to CFₙ are the net cash flows in each later period
• t is the period, from 0 to the final period n
• IRR is the unknown rate

In summation form, this is 0 = Σ CFₜ ÷ (1 + IRR)ᵗ.

There is no algebraic shortcut for solving this equation once a project runs longer than a few periods. You test a rate, see whether NPV comes out positive or negative, and adjust. If NPV is positive, the trial rate is too low; if negative, it is too high. Software runs this iteration automatically. Because the formula measures return as an annual rate on capital still invested, IRR is closely tied to the net present value calculation: NPV asks “how many dollars at a given rate?” while IRR asks “at what rate do the dollars net to zero?”

Worked Example: Applying the IRR Rule

Hypothetical example. A company with a 10% hurdle rate is considering a $10,000 equipment upgrade expected to produce these net cash flows:

Solving by trial and error, discount every cash flow at a test rate and add the results:

NPV crosses zero between 14% and 15%. Interpolating gives an IRR of roughly 14.9%. Since 14.9% exceeds the 10% hurdle, the IRR rule says accept. The NPV result agrees: at 10%, the project adds about $1,087 in present-value terms.

The same logic works in reverse. Had the hurdle rate been 16%, the IRR would fall short and the rule would point to rejection, with NPV at 16% turning negative.

Calculating IRR in a Spreadsheet

Excel and Google Sheets handle the iteration with a built-in function:

1. Collect the initial outlay and each period’s net cash flow.
2. Enter the values in consecutive cells in one column, starting with the outlay as a negative number (for example, cells A1 to A5).
3. In an empty cell, type =IRR(A1:A5). An optional second argument lets you supply a starting guess, such as =IRR(A1:A5, 0.1).
4. Format the result as a percentage and compare it with your hurdle rate.
5. If cash flows arrive on irregular dates rather than evenly spaced periods, use =XIRR(values, dates) instead, which annualizes based on the actual dates.

For the example above, =IRR returns approximately 14.9%. The function assumes each cell is one equal period apart, so monthly cash flows produce a monthly IRR that must be annualized before comparing it with an annual hurdle rate.

Why IRR Is Useful

IRR remains popular in corporate finance, private equity and real estate for a few practical reasons.

• It is intuitive. A single percentage is easy to compare with a borrowing cost, a target return or another project’s IRR, without needing to agree on a discount rate first.
• It reflects the time value of money. A dollar received today is worth more than a dollar received in five years, and IRR discounts later cash flows accordingly. Simple payback or total-return measures ignore this.
• It allows comparison across projects of different sizes. Because IRR is a rate, a $50,000 project and a $5 million project can be ranked on the same scale (with the caveats below).
• It shows a margin of safety. The gap between IRR and the hurdle rate indicates how much the actual return can underperform projections before the project stops covering its cost of capital.

Limitations of the IRR Rule

The rule’s simplicity hides several weaknesses. Most of them come from compressing a whole stream of cash flows into one rate.

The Reinvestment Assumption

IRR implicitly assumes that every interim cash inflow is reinvested at the IRR itself. For a project with a 30% IRR, that means assuming the company can keep finding 30% opportunities for the cash it receives along the way, which may be unrealistic. The result can overstate the return of high-IRR projects with large early inflows.

The modified internal rate of return (MIRR) addresses this by assuming inflows are reinvested at a rate you choose, commonly the firm’s cost of capital. In the example above, compounding the inflows at 10% to year 4 gives about $16,233. MIRR is then (16,233 ÷ 10,000)^(1/4) − 1, or roughly 12.9%, compared with the 14.9% IRR. In a spreadsheet, =MIRR(values, finance_rate, reinvest_rate) performs this calculation.

IRR Ignores Dollar Size

A rate says nothing about how much value a project creates. Hypothetical example, with a 10% hurdle rate and two mutually exclusive four-year projects:

Both clear the hurdle. If the company can pick only one, the IRR rule favors Project S, but Project L adds more present value in dollars. When ranking mutually exclusive projects, NPV is the standard tiebreaker because it measures the wealth a project adds rather than its percentage return. Differences in timing, where one project pays early and another pays late, can produce the same kind of conflict.

Unconventional Cash Flows: Multiple IRRs or None

The IRR equation has a single meaningful answer when cash flows follow a conventional pattern: one outflow (or a series of outflows) followed only by inflows. When the sign changes more than once, as with a mine that requires a large cleanup cost at the end, the equation can have several solutions.

Hypothetical example: cash flows of −$100, +$230 and −$132 produce an NPV of zero at both 10% and 20%. Neither rate can be compared cleanly with a hurdle rate, so the IRR rule gives no clear signal. NPV at the hurdle rate, or MIRR, is the better tool here.

Some cash flow streams have no IRR at all. If every cash flow is negative, no discount rate can bring the NPV to zero, so the IRR is undefined; a spreadsheet returns an error such as #NUM!. The same happens when all flows are positive.

Projections Drive Everything

IRR is only as reliable as the cash flow forecasts behind it. Small changes to the final year’s value or the timing of inflows can shift IRR noticeably, and the precise-looking percentage can make an uncertain estimate seem more solid than it is. Running the calculation under several scenarios shows how sensitive the decision is.

IRR Rule vs. Related Measures

IRR vs. NPV

Both come from the same discounted cash flow math. NPV discounts cash flows at a chosen rate and reports dollars; IRR finds the rate where NPV is zero. For a single conventional project, the two give the same accept-or-reject answer: if IRR exceeds the hurdle rate, NPV at the hurdle rate is positive. They can disagree when ranking mutually exclusive projects of different size or timing, as in the Project S and Project L table.

IRR vs. ROI

Return on investment measures total gain relative to cost over the whole holding period, while IRR is an annualized, time-weighted rate. Over exactly one year with a single inflow at the end, the two coincide. Over longer periods they diverge sharply. An investment that grows tenfold in five years has an ROI of 900%, but its IRR is 10^(1/5) − 1, or about 58.5% a year. ROI is simpler to calculate and more widely quoted; IRR is more informative when timing matters.

IRR and the DCF Method

The IRR rule is one application of discounted cash flow (DCF) analysis. A DCF model discounts projected cash flows to present value; NPV and IRR are two ways of reading the result. Using IRR means solving the DCF equation for the rate rather than for the value. For a fuller treatment of the metric itself, including annualization and variants, see internal rate of return (IRR).

Do Companies Always Follow the IRR Rule?

No. The rule is a screening guideline, not a binding policy. A company may accept a project with a lower IRR than an alternative, provided it still clears the cost of capital, because it supports a broader strategy, strengthens a competitive position or generates more total cash. A firm may also reject a project with an IRR above the hurdle if the forecasts are highly uncertain, if capital is limited and better uses exist, or if the project carries risks the hurdle rate does not capture. In practice, IRR is usually reviewed alongside NPV, payback period and qualitative factors rather than in isolation.

FAQs

The Bottom Line

Managers and investors screening capital projects can use the IRR rule as a quick first test of whether projected cash flows clear the cost of capital. Because IRR ignores dollar size, assumes reinvestment at the IRR and can fail with unconventional cash flows, it works best alongside NPV, MIRR and scenario testing. When mutually exclusive projects conflict, NPV is the standard tiebreaker.