A:

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).

RELATED FAQS
  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 better 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. Why is the Modified Internal Rate Of Return (MIRR) preferable to the regular internal ...

    See why the modified internal rate of return is often a superior metric to the classic internal rate of return for assessing ... Read Answer >>
  4. 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 >>
  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

    The internal rate of return can be used to measure an compare capital projects, stock buyback programs, and investments to determine which will yield the most favorable return.
  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. Small Business

    Calculating IRR with Excel

    Find out how to calculate the internal rate of return on investments using Microsoft Excel, as illustrated in different investment scenarios.
  4. Small Business

    Capital Budgeting: Which is Better, IRR or NPV?

    Using internal rate of return and net present value for capital budgeting evaluations often end in the same result. But there are times when using NPV to discount cash flows makes more sense.
  5. 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.
  6. Investing

    Guess Surges After Posting a Solid Fourth Quarter

    Shares of Guess (NYSE: GES) jumped 12% during after-hours trading Wednesday after the apparel retailer posted numbers for its fiscal 2018 fourth quarter that beat expectations on both the top ...
  7. Investing

    Market Indicators: InvestoTrivia

    Quiz: can you guess which of these indicators is not real?
  8. Investing

    Breaking Down the 'Fed Model'

    Learn what pundits mean when they say that stocks are undervalued according to the Fed model.
  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.
RELATED TERMS
  1. Internal Rate of Return - IRR

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

    The currency abbreviation or currency symbol for the Iranian ...
  3. Modified Internal Rate Of Return - MIRR

    While the internal rate of return (IRR) assumes the cash flows ...
  4. Pooled Internal Rate Of Return - PIRR

    Pooled internal rate of return is a method of calculating overall ...
  5. Conventional Cash Flow

    Conventional cash flow is a series of inward and outward cash ...
  6. Annuity Method of Depreciation

    The annuity method of depreciation is a process used to calculate ...
Trading Center