:max_bytes(150000):strip_icc()/thinkstockphotos_80410231-5bfc2b97c9e77c0026b4fb20.jpg "How to Calculate Internal Rate of Return (IRR) for Investments")
Key Takeaways
- Internal rate of return (IRR) involves guesswork and trial and error in calculations.
- IRR is the discount rate that makes the net present value (NPV) of cash flows zero.
- Unlike return on investment (ROI), IRR considers the time value of money in investment analysis.
- The IRR formula requires estimating random discount rates and their NPVs.
- IRR has limitations, such as not accounting for the cost of capital or reinvestment rate assumptions.
Internal rate of return (IRR) is the discounted interest rate that will bring the net present value (NPV) of a series of cash flows to zero.
IRR is important in assessing investment opportunities and project profitability.
IRR has challenges, such as not considering the cost of capital and assuming that cash inflows earned during a project’s life are reinvested at the same rate as IRR. Nonetheless, internal rate of return plays a critical role in investment analysis.
Practical uses of IRR include mortgage analysis and return on stocks.
Net present value, which measures whether a project or investment will be profitable by comparing today’s value of future cash inflows to its costs, factors into the IRR formula. Learn more below about calculating internal rate of return, an important concept in determining the relative attractiveness of different investments.
Understanding the Role of Internal Rate of Return in Investments
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.
Important
Computing the internal rate of return 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.
Calculating Internal Rate of Return: An Overview of the Formula
One possible algebraic formula for IRR is:
IRR = R1 + (NPV1 × (R2 – R1)) ÷ (NPV1 – NPV2)
Where:
R1 and R2 = randomly selected discount rates
NPV1 = higher net present value
NPV2 = lower net present value
Applications and Constraints of Using Internal Rate of Return
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 the 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).
The Bottom Line
IRR, the discount rate that makes the net present value (NPV) of cash flows zero, helps to evaluate investment opportunities.
Trial and error go into calculating IRR. The formula can include randomly selected discounted rates and higher and lower NPVs. If the first two random guesses are rejected, new guesses are required.
IRR differs from return on investment (ROI) in that the latter ignores the time value of money.
IRR assesses not only investment attractiveness but also project profitability. However, it has limitations, including assumptions about reinvestment rates and not taking the cost of capital into consideration.
