# 5.2 Internal Rate of Return

## Learning Objectives

• Calculate the internal rate of return of an investment
• Evaluate and compare investment decisions using the internal rate of return

## Formula & Symbol Hub

#### Symbols Used

• $NPV$ = net present value
• $IRR$ = internal rate of return

#### Formulas Used

• ##### Formula 5.1 – Net Present Value

$NPV = \text{(Sum of}\;PV\;\text{of All Future Cash Flows)} − \text{(Initial Investment)}$

or

$NPV = \text{(Sum of }\;PV\;\text{of Cash Inflows)} − \text{(Sum of}\;PV\;\text{of Cash Outflows)}$

## Introduction

The net present value presented in the previous section provides an exact monetary magnitude of a project. However, the common mindset in business focuses on profitability as a percentage and not as a dollar amount. Thus, decisions are based on the internal rate of return for a project, or $IRR$ for short. The $IRR$ is the annual percentage rate of return on the investment so that the present value of all cash inflows equals the present value of all cash outflows. That is, the $IRR$ is the rate of return required to make $NPV=0$.

To interpret the $IRR$ and how the $IRR$ can be used to make a decision about a project, consider the relationship between the value of $NPV$ and the $IRR$.

• $NPV=0$. By definition, the cost of capital and the $IRR$ are the same value.
• $NPV>0$.Because the $IRR$ is the rate of return that makes $NPV=0$, this means that a higher rate of return must be used in order for the $NPV>0$. In other words, the $IRR$ is greater than the cost of capital.
• $NPV<0$. Because the $IRR$ is the rate of return that makes $NPV=0$, this means that a lower rate of return must must be used in order for the $NPV<0$. In other words, the $IRR$ is less than the cost of capital.

In summary, here is how to interpret the $IRR$ and use it to make a decision about the viability of a project.

• $IRR=\mbox{cost of capital}$. The project breaks even. This is the minimum financial condition to pursue the project. The business should accept the project.
• $IRR>\mbox{cost of capital}$.The project is profitable because the project makes enough money to cover the costs. The business should accept the project.
• $IRR<\mbox{cost of capital}$. The project is not profitable because the project does not make enough money to cover the costs. The business should reject the project.

Solving for the internal rate of return is difficult without the use of a financial calculator or other technology. Similar to calculating the $NPV$ in the previous section, the $IRR$ can be calculated by using the cash flow worksheet on the financial calculator and a built-in function to calculate the internal rate of return.

## Using the TI BAII Plus Cash Flow Worksheet to Calculate the Internal Rate of Return

Enter the cash flow data into the cash flow worksheet, as discussed in the previous section. Once you have entered all cash flows, you must access other functions to generate the output. For internal rate of return, press $IRR$ on the keypad, as illustrated in the photo, followed by the $CPT$ button to perform the calculation. The output is a percentage in percent format. To exit the window, press 2nd QUIT.

Video: Cash Flows 1: Net Present Value (NPV) and IRR Calculations by Joshua Emmanuel [2:52] Transcript Available.

### Key Takeaways

Create a table to record the cash flows for each time period. The table should record the cash inflows, the cash outflows, and the net cash flow for each time period. Alternatively, use a timeline to illustrate the cash flows for each time period.

Because cash flows can be inflows or outflows, write all numbers with their cash flow sign conventions in the table to avoid confusion. That is, cash inflows are recorded as positive and cash outflows are recorded as negative. This helps you keep track of the different flows and minimizes the possibility of incorrectly netting out all present values.

For each period, only one cash flow can be entered in the financial calculator. If more than one cash flow exists for a certain period, enter the NET cash flow for that period. The net cash flow for a period is the sum of the cash inflows minus the sum of the cash outflows.

When using the cash flow worksheet on a financial calculator, you must enter a cash flow for EVERY period. If there is no cash flow for a certain period, a $0$ is recorded as the net cash flow for that period. Enter $0$ for $C0$ on the calculator for that period and $1$ for F$0$.

### Example 5.2.1

Tim Hortons has purchased the lease on a three-year onsite concession space in the cafeteria at a local college for $\750,000$. The franchise is expected to earn $\400,000$, $\500,000$, and $\600,000$ in profits per year for the first three years, respectively.

1. Calculate the internal rate of return for this investment.
2. If the cost of capital is $20\%$, did Tim Hortons make a smart financial decision?
Solution

Step 1: Record the cash flows in a table.

 Year Cash Inflows Cash Outflows Net Cash Flows $0$ $0$ $-750,000$ $-750,000$ $1$ $400,000$ $400,000$ $400,000$ $2$ $500,000$ $500,000$ $500,000$ $3$ $600,000$ $600,000$ $600,000$

Step 2: Calculate the $IRR$.

 $IRR$ $40.92\%$
1. Press $IRR$.
2. At the $IRR$ screen, press $CPT$.

Step 3: Write as a statement.

Because the $IRR=40.92\% > 20\%$, this was a smart decision.

### Try It

1) A research project requires an investment of $\350,000$ today and another investment of $\200,000$ one year from today. Starting from the third year, the project will reduce costs by $\250,000$ every year for three years.

1. Calculate the internal rate of return for the project.
2. If the cost of capital is $12\%$, is the project financially viable?
Solution
 Year Cash Inflows Cash Outflows Net Cash Flows $0$ $0$ $-350,000$ $-350,000$ $1$ $0$ $-200,000$ $-200,000$ $2$ $0$ $0$ $0$ $3$ $250,000$ $0$ $250,000$ $4$ $250,000$ $0$ $250,000$ $5$ $250,000$ $0$ $250,000$
 $IRR$ $8.95\%$

Because the $IRR=8.95\% < 12\%$, the project is not financially viable.

Like the net present value, the internal rate of return can be used to choose one project from several different projects. Relative to their initial investment, projects with higher $IRR$s are more profitable. Consequently, $IRR$ can be used to rank projects. When making a choice from several options, the option with the highest $IRR$ should be accepted because it will be the most profitable.

### Example 5.2.3

A company is consider two different investments.

• Investment A requires an initial investment of $\300,000$ today and will provide returns of $\100,000$ in year two, $\150,000$ in year three, and $\400,000$ in year five.
• Investment B requires an initial investment of $\500,000$ today and will provide returns of $\350,000$ in year one, $\200,000$ in year four, and $\75,000$ in year five.

Calculate the internal rate of return for each investment. Which investment should the company select?

Solution

Step 1: Calculate the $IRR$ for Investment A.

 Year Cash Inflows Cash Outflows Net Cash Flows $0$ $0$ $-300,000$ $-300,000$ $1$ $0$ $0$ $0$ $2$ $100,000$ $0$ $100,000$ $3$ $150,000$ $0$ $150,000$ $4$ $0$ $0$ $0$ $5$ $400,000$ $0$ $400,000$
 $IRR$ $21.76\%$

Step 2: Calculate the $IRR$ for Investment B.

 Year Cash Inflows Cash Outflows Net Cash Flows $0$ $0$ $-500,000$ $-500,000$ $1$ $350,000$ $0$ $350,000$ $2$ $0$ $0$ $0$ $3$ $0$ $0$ $0$ $4$ $200,000$ $0$ $200,000$ $5$ $75,000$ $0$ $75,000$
 $IRR$ $10.14\%$

Step 3: Write as a statement.

The company should select Investment A because it has the higher $IRR$.

### Try It

2) A company is considering two different projects to deal with an equipment issue. The company can either upgrade the equipment (Project A) or they can retrofit the equipment (Project B).

• Project A requires an initial investment of $\300,000$ in new equipment that will result in increased revenue of $\90,000$ each year for five years.
• Project B requires an initial investment of $\125,000$ to retrofit existing equipment that will result in increased revenue of $\30,000$ each year for five years.

Calculate the internal rate of return for each project. Which project should the company select?

Solution

Project A:

 Year Cash Inflows Cash Outflows Net Cash Flows $0$ $0$ $-300,000$ $-300,000$ $1$ $90,000$ $0$ $90,000$ $2$ $90,000$ $0$ $90,000$ $3$ $90,000$ $0$ $90,000$ $4$ $90,000$ $0$ $90,000$ $5$ $90,000$ $0$ $90,000$
 $IRR$ $15.24\%$

Project B:

 Year Cash Inflows Cash Outflows Net Cash Flows $0$ $0$ $-125,000$ $-125,000$ $1$ $30,000$ $0$ $30,000$ $2$ $30,000$ $0$ $30,000$ $3$ $30,000$ $0$ $30,000$ $4$ $30,000$ $0$ $30,000$ $5$ $30,000$ $0$ $30,000$
 $IRR$ $6.40\%$

The company should select Project A because it has the higher $IRR$.

## Paths to Success

As mentioned above, the internal rate of return can be used to rank projects. However, a couple of things need to be considered about using the internal rate of return in this way.

1. The Cost of Capital is Ignored. The internal rate of return does not factor in the cost of capital in its computations. Recall that the fundamental concept of time value of money requires all money to be on the same date using an appropriate rate of interest—the cost of capital—before any decision can be made. Therefore, if you have not factored in the cost of capital, then your analysis is incomplete.
2. The Magnitude of the Decision is Ignored. It can easily happen that an alternative has a high $IRR$ but a low $NPV$. For example, using a cost of capital of $10\%$ consider two alternatives. Alternative A invests $\1$ and one year later returns $\1.50$. The $IRR$ is $50\%$, while the $NPV$ is $\0.36$. Alternative B invests $\1,000$ and one year later returns $\1,250$. The $IRR$ is $25\%$, while the $NPV$ is $\136.36$. If choosing between these two options based on the $IRR$, you select Alternative A, resulting in a net present value that is $\136$ lower than for Alternative B.

## Section 5.2 Exercises

1. A project requires an investment of $\225,000$ today and is projected to have annual profits of $\34,000$ for nine years. The capital assets can be sold at the end of the ninth year for $\23,500$. Calculate the IRR for this project. If capital could be acquired at a cost of $12\%$, should the project be pursued?
Solution

$IRR=7.91\%$; do not pursue project

2. A new diamond deposit has been found in northern Alberta. Your researchers have determined that it will cost $\4.5$ million to purchase the land and prepare it for mining. Starting in the second year, the lode is expected to earn net profits of $\3$ million, which will be sustained for three years before the deposit is depleted. Calculate the IRR on the diamond mine. If the cost of capital is $21\%$, should the deposit be acquired?
Solution

$IRR=26.78\%$; pursue project

3. Schick is considering launching only one of two new products to compete with the Gillette Fusion ProGlide Power razor.
• Product A requires a $\10$ million research and development investment with forecasted profits are expected to be $\3$ million in years two to four, $\1.5$ million in years five to seven, and $\0.5$ million in years eight to ten.
• Product B requires a $\6.5$ million research and development investment with forecasted profits of $\2.75$ million in years one to two, $\1$ million in years three to five, and $\0.35$ million in years six to ten.

Calculate the IRR for each product. Which product should Schick launch?

Solution

$IRR\;\text{of Product A}=10.59\%$; $IRR\;\text{of Product B}=16.89\%$; launch Product B

4. The Dragons (from CBC’s Dragon’s Den) are considering a venture from an Albertan entrepreneur. His proposal requires the Dragons to invest $\500,000$ immediately. Based on market conditions, the product is estimated to have year-end profits of $\100,000, \200,000, \300,000, \200,000$, and finally $\100,000$. The Dragons will invest only if the internal rate of return exceeds their cost of capital of $20\%$. Should they invest?
Solution

$IRR=22.78\%$; pursue project

5. A Western Canadian producer is considering purchasing a five-year product licence from Sunkist Growers Inc. The product licence will cost $\1,500,000$, and the required equipment will cost $\1$ million. Equipment upgrades will be $\100,000$ at the end of the second and fourth years. Expected profits are $\1$ million in each of the first three years and $\750,000$ in the last two years. The producer will purchase product licences only if the IRR is greater than $25\%$. Should the product licence be purchased?
Solution

$IRR=22.91\%$; do not pursue project

6. Consider the following two projects, of which only one can be selected:
• Project A. Immediate investment of $\225,000$, profits in years four to six of $\160,000$.
• Project B. Immediate investment of $\112,500$, profits in years one to three of $\55,000$ followed by profits of $\20,000$ in years four to six.

Calculate the IRR for each project. Which project should be selected?

Solution

$IRR\;\text{of Project A}=16.54\%$; $IRR\;\text{of Project B}=32\%$; select Project B