Internal rate of return (IRR)

[Lorenzo Incarnato s220426]

- references - pictures

Abstract

The Internal Rate of Return (IRR) is a powerful discounted cash flow method used in capital budgeting and corporate finance to estimate and evaluate the profitability of potential investments. Keeping in mind the formula for the Net present value (NPV), the IRR is defined as the discount rate that makes the present value of the costs (negative cash flows) of an investment equal to the present value of the benefits (positive cash flows). In other words, the IRR is the discount rate that gives a net present value of zero when applied to the expected cash flow of a project. This rate of return is called internal because the formula predicts a rate that depends only on the project, more precisely on the project's cash flows, and does not depend on external factors such as market interest rates or inflation. One of the main advantages in using the internal rate of return to evaluate project investments, compared to other methods such as the Payback period or the Benefit-cost ratio, is that IRR considers the time value of money. In general, due to the relationship between NPV and IRR, the higher the Internal Rate of Return of a project, the more desirable the investment to be made. This article shows also the limitations of the internal rate of return; however, when the IRR is unique, it provides relevant information about the return on investment and is also used as a measure of investment efficiency. In fact, according to academic research, three-quarters of Chief Financial Officers use the IRR method to evaluate capital projects.

Time value of money

It would be wrong to compare cash flows available in the future to cash flows available in the present because if we did so we would not take into account the monetary value of the time. To compare the cash flows available at different times, we must therefore include the time value of money (as if they were different units of measure otherwise). In short, the time value of money states that there is a difference between the future value of the payment and the present value of the payment itself .

So, to know the discounted cash flows of the project, therefore, it is necessary to discount the future cash flows through the discounting process. The reverse process, in order to be able to add cash flows into the future, is called compounding.

For example, if you spend $ 100 today on machinery that will generate $ 200 next year, will you have made $ 100? This introductory paragraph aims to focus on the time value of money in investment decisions. At the end of this paragraph, it will be clear.

The monetary value of project investment is the value of the project's future cash flows (or net benefits) less the required investments (or initial costs). A key consideration regarding discounted cash flow methods is the Time Value of Money (TVM). In finance, an amount of money available today or in the future has a different value because we have to consider that also time has a monetary value. In other words, $ 100 today is not $ 100 tomorrow.

$ 100,000 today or a year from now? The quick answer is today. The reason is that today you have the opportunity to invest money and thus grow, according to the time horizon and the interest rate. So, investing $ 100 today at an annual interest rate of 5% enables you to have $ 105 the next year, which is higher than $ 100. Another reason for the time value of money is the purchasing power of money which changes over time due to inflation or deflation.

Hence, the time has a monetary value and we have to consider it if we want to compare money available in different moments . It is, therefore, necessary to briefly underline three fundamental terms about investments to clearly understand the time value of money:

• The Present value PV: the sum of money available today that can be invested [$];
• The Interest rate (or opportunity cost if we decide not to invest) r: the amount of interest due per period, as a proportion of the amount deposited or borrowed [%]
• The Future value FV: is the value of a current asset (present value) at a future date based on an assumed rate of growth (interest rate) [$].

Present to Future	$FV = PV (1 + r)^n$
Future to Present	$PV = FV / (1 + r)^n$

Example 1: Would you rather have $ 100,000 today or the same amount in 1 year from now? To calculate how much money will be $ 100,000 in a year from now, supposing an interest rate r = 3%, we can apply the formula for the future value:

$FV = PV * (1 + r)^n = $ 100,000 * (1 + 0.03)^1 = $ 103,000$

So having $ 100,000 now is equivalent to having $ 103,000 in the future considering an interest rate of 3%. If we agreed to receive $ 100,000 in one year instead of now, we would be $ 3,000 less. As shown, the present value and the future value differ by a factor of $(1+r)^n$; this difference represents the time value of money. It can be concluded that to compare the money available in two different moments it is necessary to consider the time value of money, which allows us to discount money available in the future and consider it in the present or vice versa; only then can we compare the two amounts.

Example 2: Considering an interest rate of 9%, is it better to receive $ 150,000 today or $ 180,000 in three years? What amount of money do you have indifference of choice? If we invest the present value at an interest rate of 9%, in three years we will have a future value of:

$FV = PV * (1 + r)^n = $ 150,000 * (1 + 0.09)^3 = $ 194,254$

It is better to have $ 150,000 today because by investing it we will have $ 194,254 over three years, which is $ 14,254 more than $ 180,000. To be indifferent, therefore, the amount of money available in three years would have to be $ 194,254.

Example 3: After an initial investment of $ 100,000 for machinery, we expect future cash flows of $ 40 000 annually, for the next 4 years thinking to gain $ 60 000 at the end of the period. Is it true? In finance, to calculate the profitability of a project considering future cash flows, it is needed to consider an alternative investment with almost the same risk in order to know the interest rate of the other investment. Considering an interest rate r = 7%, we can now calculate the time value of money because we have the interest rate. So,

	cash flow (0)	cash flow (1)	cash flow (2)	cash flow (3)	cash flow (4)
Today	- 100,000
1st year		+ 40,000
2nd year			+ 40,000
3rd year				+ 40,000
4th year					+ 40,000

Discounting all the cash flows with the PV formula:

cash flow (0) : $PV = - $ 100,000 / (1 + 0.07)^0 = - $ 100,000$ (it is already in the present)

cash flow (1) : $PV = $ 40,000 / (1 + 0.07)^1 = $ 37,383$

cash flow (2) : $PV = $ 40,000 / (1 + 0.07)^2 = $ 34,938$

cash flow (3) : $PV = $ 40,000 / (1 + 0.07)^3 = $ 32,652$

cash flow (3) : $PV = $ 40,000 / (1 + 0.07)^4 = $ 30,515$

Now we can compare all the cash flows because we have considered the time value of money for each of them. At the end, the company has gained:

	cash flow (0)	cash flow (1)	cash flow (2)	cash flow (3)	cash flow (4)
Today	- 100,000
1st year	+ 37,383	+ 40,000
2nd year	34,938		+ 40,000
3rd year	32,652			+ 40,000
4th year	30,515				+ 40,000
Total cash flow (0)	$ 35,488

$N P V = - 100,000 + 37,383 + 34,938 + 32,652 + 30,515 = $ 35,488$

So, the investment is profitable but the final gain is equivalent to $ 35,488 and not to $ 60,000 because of the time value of money.

From this example, it can be seen that the discounting effect on future cash flow is greater as time and interest rate increase. The difference in value between future and present cash flows is directly proportional to time and to the interest rate. This means that the more a cash flow is in the future, the more its value will decrease if it is to be carried over into the present

IRR: definition and formula

To truly understand the essence of the internal rate of return method, a good understanding of the methodological basis of net present value is required as IRR is closely related to it and allows management to add valuable information on decision criteria rather than just look at NPV.

What is the NPV?

Why is useful to know when NPV = 0 (irr)?

$N P V (irr) =\sum_{n=0}^{N} \frac{\left(C F_{n}\right)}{(1+irr)^{n}}$