Internal Rate of Return

IRR is the case of a discount rate that equalizes the present value of cash inflows with present value of cash outflows. Within the context of a net present value analysis, when the cash inflows and outflows are known, IRR will be the rate that causes the NPV to equal zero.

The formula for IRR is as follows:

In our example, the IRR will be calculated as follows:

Solving the above equation, we get IRR = 13.663%.

This is solved by trial and error method. In Excel, you can use Goal Seek to solve for IRR.

Calculator Usage
We can solve the IRR problems using the official BA II Plus calculator as follows:
Step 1: Enter Cash Flows
Before you enter the new cash flows, clear the previous work by pressing the keys CF, 2ND, CLR WORK. Now you are ready to enter the cash flows. You should see CF0 on screen. Enter the cash flows as follows:
Initial investment         100[+/-][ENTER]         CF0 = -100
Period 1 Cash Flow    [↓][30]                          CF1 = 30
Period 2 Cash Flow    [↓][↓] [30]                     CF2 = 30
Period 3 Cash Flow    [↓][↓] [30]                  CF3 = 30
Period 4 Cash Flow    [↓][↓] [30]                  CF4 = 50
Step 2: Compute IRR
Compute IRR              [IRR][CPT]                             NPV = 13.663
Membership
Learn the skills required to excel in data science and data analytics covering R, Python, machine learning, and AI.
I WANT TO JOIN
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Saylient AI Logo

Take the Next Step in Your Data Career

Join our membership for lifetime unlimited access to all our data analytics and data science learning content and resources.