What Is Internal Rate of Return (IRR)?

The Internal Rate of Return (IRR) is the discount rate that makes the net present value (NPV) of a project’s cash flows equal to zero. In other words, it is the rate at which the present value of future cash inflows equals the initial investment. IRR is a widely used investment evaluation technique that measures the expected annualized return of an investment.

IRR is a relative measure of return. Unlike NPV, which provides a dollar amount of value created, IRR provides a percentage return. This makes IRR easy to compare to the organization’s cost of capital or required rate of return.

IRR is one of the most popular capital budgeting techniques because it is intuitive and easy to communicate. However, IRR has limitations that must be understood for proper use.

The Purpose and Objectives of IRR

IRR serves several important purposes in investment evaluation.

Return Measurement is the primary purpose. IRR measures the expected annualized return of an investment. Return measurement supports comparison.

Decision-Making is a key purpose. IRR provides a clear decision rule for investment evaluation. Decision-making supports capital allocation.

Comparison is a key purpose. IRR allows comparison of projects with different sizes and durations. Comparison supports prioritization.

Performance Measurement is a key purpose. IRR provides a basis for measuring investment performance. Performance measurement supports accountability.

Stakeholder Communication is a key purpose. IRR communicates the expected return of an investment. Communication supports transparency.

The Calculation of IRR

IRR is calculated by finding the discount rate that makes NPV equal to zero.

Formula is: 0 = Σ(CFt / (1 + IRR)^t) – Initial Investment. Where CFt is the cash flow in period t.

Calculation Method is iterative. IRR cannot be solved directly; it must be found through trial and error or using financial calculators or spreadsheet functions.

Spreadsheet Function is IRR. Excel and other spreadsheet programs have an IRR function that calculates the IRR of a series of cash flows.

Manual Calculation involves trial and error. Try different discount rates until NPV is close to zero. Interpolate between rates to find the exact IRR.

Decision Rule

The decision rule for IRR is straightforward.

Accept the project if IRR is greater than the required rate of return (cost of capital). If IRR exceeds the cost of capital, the project creates value.

Reject the project if IRR is less than the required rate of return (cost of capital). If IRR is below the cost of capital, the project destroys value.

Indifferent if IRR equals the required rate of return. If IRR equals the cost of capital, the project neither creates nor destroys value.

Comparison to Cost of Capital

IRR is always compared to the cost of capital or required rate of return.

Cost of Capital is the weighted average cost of debt and equity. The cost of capital is the minimum required return.

Required Rate of Return is the minimum return required by investors. The required return reflects the risk of the investment.

Hurdle Rate is the minimum IRR required for acceptance. The hurdle rate is typically the cost of capital plus a risk premium.

Advantages of IRR

IRR has several advantages that make it a popular investment evaluation technique.

Intuitive Understanding is a significant advantage. IRR provides a percentage return that is easy to understand. Percentages are more intuitive than dollar amounts.

Easy Comparison is a significant advantage. IRR can be easily compared to the cost of capital. Comparison supports decision-making.

Considers Time Value of Money is a significant advantage. IRR accounts for the time value of money. Time value is essential for accurate evaluation.

Considers All Cash Flows is a significant advantage. IRR uses all cash flows of the project. All cash flows support comprehensive evaluation.

No Need for Discount Rate is a significant advantage. IRR does not require a discount rate for its calculation. The discount rate is only needed for comparison.

Widely Used and Understood is a significant advantage. IRR is widely used in business. Understanding supports communication.

Limitations of IRR

IRR has several limitations that must be understood for proper use.

Multiple IRRs

Multiple IRRs occur when a project has non-conventional cash flows, such as alternating positive and negative cash flows. When this happens, there can be multiple discount rates that make NPV equal to zero.

Non-Conventional Cash Flows are cash flows that change sign more than once. Non-conventional cash flows can result in multiple IRRs.

Interpretation Difficulty arises when multiple IRRs exist. It is unclear which IRR to use for decision-making.

Solution is to use the Modified Internal Rate of Return (MIRR) or NPV.

Mutually Exclusive Projects

IRR can give conflicting results for mutually exclusive projects.

Mutually Exclusive Projects are projects where only one can be selected. Mutually exclusive projects require careful evaluation.

Conflicting Rankings occur when IRR ranks projects differently than NPV. IRR ranks by percentage return; NPV ranks by dollar value created.

Solution is to use NPV as the primary criterion. NPV is more reliable for mutually exclusive projects.

Reinvestment Rate Assumption

IRR assumes that cash flows are reinvested at the IRR. This may not be realistic.

Reinvestment Rate is the rate at which intermediate cash flows are reinvested. IRR assumes reinvestment at the IRR.

Unrealistic Assumption may overstate the return. The actual reinvestment rate may be lower.

Solution is to use MIRR, which assumes reinvestment at the cost of capital.

Scale Issue

IRR does not consider the scale of the investment. A small project with a high IRR may create less value than a large project with a lower IRR.

Small Project may have a high IRR but create little value. IRR does not consider the dollar amount of value created.

Large Project may have a lower IRR but create more value. IRR does not consider the dollar amount of value created.

Solution is to use NPV as the primary criterion. NPV considers both return and scale.

Timing of Cash Flows

IRR does not fully capture the timing of cash flows beyond the discounting effect. However, the reinvestment rate assumption affects the implied timing.

Early Cash Flows are assumed to be reinvested at the IRR. This may be unrealistic.

Late Cash Flows are discounted at the IRR. This may not reflect the risk.

IRR vs. NPV

Understanding the relationship between IRR and NPV is essential for proper use.

IRR is the discount rate that makes NPV equal to zero. IRR is a relative measure of return.

NPV is the present value of future cash flows minus the initial investment. NPV is an absolute measure of value creation.

Consistency generally holds. For conventional projects (one sign change), IRR and NPV lead to the same accept/reject decision.

Conflicts can arise for mutually exclusive projects. Conflicts occur when projects have different scales, timing, or cash flow patterns.

Primary Criterion is NPV. NPV is the preferred criterion because it directly measures value creation.

Modified Internal Rate of Return (MIRR)

MIRR is a variation of IRR that addresses some of its limitations.

MIRR assumes that intermediate cash flows are reinvested at the cost of capital. MIRR provides a more realistic measure of return.

Calculation involves three steps: calculate the terminal value of cash inflows using the reinvestment rate, find the discount rate that equates the initial investment to the terminal value, and the result is MIRR.

Advantages include a more realistic reinvestment rate assumption, a single solution, and consistency with NPV.

Disadvantages include complexity and the need to determine the reinvestment rate.

IRR in Practice

IRR is used in a variety of investment contexts.

Capital Budgeting uses IRR for project evaluation. IRR supports project selection.

Private Equity uses IRR for investment evaluation. IRR is a key metric for private equity returns.

Real Estate uses IRR for property evaluation. IRR supports real estate investment decisions.

Project Finance uses IRR for project feasibility. IRR supports project financing decisions.

Common IRR Mistakes

Awareness of common IRR mistakes supports proper use.

Ignoring Multiple IRRs is a common mistake. Non-conventional cash flows can produce multiple IRRs. MIRR or NPV should be used.

Using IRR for Mutually Exclusive Projects is a common mistake. IRR can give conflicting rankings. NPV should be used as the primary criterion.

Ignoring Scale is a common mistake. IRR does not consider the scale of the investment. NPV considers both return and scale.

Comparing IRR to Wrong Rate is a common mistake. IRR should be compared to the cost of capital. The cost of capital is the minimum required return.

Using IRR in Isolation is a common mistake. IRR should be used with other evaluation techniques. Multiple techniques provide a more complete picture.

Connecting IRR to the COSO Framework

IRR is aligned with the COSO internal control framework.

Control Environment supports IRR use. A strong control environment includes commitment to financial rigor. Tone at the top is essential.

Risk Assessment identifies risks to IRR analysis. Risk assessment supports reliable decisions.

Control Activities include controls over IRR processes. Controls support integrity and accountability.

Information and Communication support IRR. Accurate information and clear communication are essential.

Monitoring ensures IRR is used properly. Monitoring supports continuous improvement.

The Bottom Line on Internal Rate of Return

IRR is the discount rate that makes the net present value of a project’s cash flows equal to zero. It measures the expected annualized return of an investment. The decision rule is to accept projects with IRR greater than the cost of capital.

Advantages include intuitive understanding, easy comparison, consideration of the time value of money, consideration of all cash flows, and no need for a discount rate in calculation. Limitations include multiple IRRs, conflicting results for mutually exclusive projects, unrealistic reinvestment rate assumption, scale issue, and timing of cash flows.

IRR should be compared to NPV for investment decisions. NPV is the preferred criterion because it directly measures value creation. MIRR addresses some of the limitations of IRR.

IRR is widely used in capital budgeting, private equity, real estate, and project finance. Common mistakes include ignoring multiple IRRs, using IRR for mutually exclusive projects, ignoring scale, comparing IRR to the wrong rate, and using IRR in isolation.

Organizations that properly use IRR are better able to evaluate investments, allocate capital, and create value. IRR is a core competence of well-managed organizations. Never underestimate the importance of understanding Internal Rate of Return.