Computing the internal rate of return (IRR) for a possible investment is time-consuming and inexact. IRR calculations must be performed via guesses, assumptions, and trial and error. Essentially, an IRR calculation begins with two random guesses at possible values and ends with either a validation or rejection. If rejected, new guesses are necessary.

Purpose of Internal Rate of Return

The IRR is the discount rate at which the net present value (NPV) of future cash flows from an investment is equal to zero. Functionally, the IRR is used by investors and businesses to find out if an investment is a good use of their money. An economist might say that it helps identify investment opportunity costs. A financial statistician would say that it links the present value of money and the future value of money for a given investment.

This shouldn't be confused with the return on investment (ROI). Return on investment ignores the time value of money, essentially making it a nominal number rather than a real number. The ROI might tell an investor the actual growth rate from start to finish, but it takes the IRR to show the return necessary to take out all cash flows and receive all of the value back from the investment.

Formula for Internal Rate of Return

One possible algebraic formula for IRR is: IRR = R1 + ((NPV1 x (R2 - R1)) / (NPV1 - NPV2)); where R1 and R2 are the randomly selected discount rates, and NPV1 and NPV2 are the higher and lower net present values, respectively.

There are several important variables in play here: the amount of investment, the timing of the total investment and the associated cash flows taken from the investment. More complicated formulas are necessary to distinguish between net cash inflow periods.

The first step is to make guesses at the possible values for R1 and R2 to determine the net present values. Most experienced financial analysts have a feel for what the guesses should be.

If the estimated NPV1 is close to zero, then the IRR is equal to R1. The entire equation is set up with the knowledge that, at IRR, NPV is equal to zero. This relationship is critical to understanding the IRR.

There are other methods for estimating IRR. The same basic process is followed for each, however: generate guesses about discounted values and, if NPV is too materially distant from zero, take another guess and try again.

Possible Uses and Limitations

IRR can be calculated and used for purposes that include mortgage analysis, private equity investments, lending decisions, expected return on stocks or finding yield to maturity on bonds.

IRR models do not take cost of capital into consideration. They also assume that all cash inflows earned during the project life are reinvested at the same rate as IRR. These two issues are accounted for in the modified internal rate of return (MIRR).

  1. How do you calculate IRR in Excel?

    Understand how to calculate the internal rate of return (IRR) in Excel and how it's used to determine anticipated yield per ... Read Answer >>
  2. Which is a better measure for capital budgeting, IRR or NPV?

    All other things being equal, using IRR and NPV measurements to evaluate projects often results in the same findings. However, ... Read Answer >>
  3. How do I use Excel to get discount rate over time?

    Learn how to calculate discount rate in Microsoft Excel and how to find the discount factor over a specified number of years. Read Answer >>
  4. What's the difference between net present value and internal rate of return? How ...

    Learn how net present value and internal rate of return are primarily used in capital budgeting to determine the potential ... Read Answer >>
  5. How do you use discounted cash flow to calculate a capital budget?

    Learn how discounted cash flows are used in creating capital budgets as a part of the net present value and internal rate ... Read Answer >>
Related Articles
  1. Investing

    Internal Rate of Return: An Inside Look

    Use this method to choose which project or investment is right for you.
  2. Investing

    Return on investment versus internal rate of return

    Read about the similarities and differences between an investment's internal rate of return (IRR) and its return on investment (ROI).
  3. Financial Advisor

    Understanding Internal Rate Of Return

    Internal rate of return, or IRR, is one of the most popular methods of evaluating potential projects. Learn more about this important metric.
  4. Investing

    Private Equity on Steroids: How Debt Fuels Outsized Returns

    Hot Air: Many private equity firms use a legal technique that can boost returns by 25% or more, Bloomberg says
  5. Investing

    Guess Drops to a Multi-Year Low on Downgrade

    Shares of Guess (NYSE: GES) dropped 5% to a multi-year low after Mizuho Securities downgraded the apparel retailer from neutral to underperform, and slashed its price target from $14 to $10. ...
  6. Financial Advisor

    A Guide on the Risk-Adjusted Discount Rate

    When a project or investment faces higher amounts of risk or uncertainty, it may be appropriate to utilize the risk-adjusted discount rate.
  7. Trading

    U.S. Markets Largely Unchanged Before Holidays

    Weekly technical summary of the major U.S. indexes.
  8. Investing

    Gauge Portfolio Performance By Measuring Returns

    Calculate returns frequently and accurately to ensure that you're meeting your investing goals.
  9. Investing

    4 Basic Things to Know About Bonds

    Learn the basic lingo of bonds to unveil familiar market dynamics and open to the door to becoming a competent bond investor.
  1. Internal Rate of Return - IRR

    Internal Rate of Return (IRR) is a metric used in capital budgeting ...
  2. Pooled Internal Rate Of Return - PIRR

    A method of calculating the overall internal rate of return (IRR) ...
  3. Unconventional Cash Flow

    An unconventional cash flow is a series of inward and outward ...
  4. Annuity Method of Depreciation

    The annuity method of depreciation is a method used to calculate ...
  5. Present Value - PV

    The current worth of a future sum of money or stream of cash ...
  6. Hurdle Rate

    The minimum rate of return on a project or investment required ...
Hot Definitions
  1. Perfect Competition

    Pure or perfect competition is a theoretical market structure in which a number of criteria such as perfect information and ...
  2. Compound Interest

    Compound Interest is interest calculated on the initial principal and also on the accumulated interest of previous periods ...
  3. Income Statement

    A financial statement that measures a company's financial performance over a specific accounting period. Financial performance ...
  4. Leverage Ratio

    A leverage ratio is any one of several financial measurements that look at how much capital comes in the form of debt, or ...
  5. Annuity

    An annuity is a financial product that pays out a fixed stream of payments to an individual, primarily used as an income ...
  6. Restricted Stock Unit - RSU

    A restricted stock unit is a compensation issued by an employer to an employee in the form of company stock.
Trading Center