What are we talking about? Internal rate of return is an indicator that allows you to evaluate the feasibility of investing in a new project in the long term. For this, the discounted cash flow approach is used.
How to apply? The indicator is calculated using a formula that includes the values of cash flow, net present value, discount rate, and weighted average cost of capital. The calculation is performed manually using Excel and Google Sheets.
In this article:
History of the creation of the internal rate of return indicator
What is Internal Rate of Return
When is Internal Rate of Return Used?
The difference 1000 phone data between internal rate of return and other financial ratios
Formula for calculating the internal rate of return
Calculating Internal Rate of Return in Excel and Google Sheets
The key rule for using the internal rate of return indicator
What is considered a good internal rate of return on investment?
Disadvantages and limitations of the internal rate of return method
Frequently Asked Questions About Internal Rate of Return
In-Depth Guide: How to Cut Your Ad Costs by 25% with Artificial Intelligence
Download for free
History of the creation of the internal rate of return indicator
Since the late 19th century, many people have been developing methods for applying discounted cash flows. Important contributions to this area were made by Eugen von Böhm-Bawerk and Irving Fisher. In his work entitled The Theory of Interest, Fisher proposed a formula for calculating the internal rate of return (IRR), although he did not use the term himself, considering it in the context of comparing two investment projects.
The term "internal rate of return" was first expounded in detail by Kenneth Boulding in his paper "The Theory of a Single Investment" (Boulding, KE "The Theory of a Single Investment." The Quarterly Journal of Economics 49, no. 3 (May 1, 1935): 475-94).
History of the creation of the internal rate of return indicator
Source: shutterstock.com
That same year, John Keynes mentioned this indicator in his work “The General Theory of Employment, Interest and Money”, describing it as the marginal efficiency of capital. This work had a significant impact on the development of economic theory and became the basis for references to the IRR method.
Over the next 20 years, IRR was used to analyze investment projects, although the term did not become widely used. In some publications, it was replaced by the term yield, which continues to be used in bond analysis. The familiar expression yield to maturity is actually the IRR calculated for bonds.
Since the 1960s, the term IRR has become established as the main one, displacing other names, which contributed to the formation of the modern understanding of this financial indicator.