# 8.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.

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.

### NOTES

1. 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.
2. 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.
3. 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.
4. 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 F0.

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

## EXAMPLE

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.

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

## 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? Click to see Answer 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? Click to see Answer 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? Click to see Answer IRR of Product A=10.59%; IRR 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? Click to see Answer 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?

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?