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
Finance Train Premium
Accelerate your finance career with cutting-edge data skills.
Join Finance Train Premium for unlimited access to a growing library of ebooks, projects and code examples covering financial modeling, data analysis, data science, machine learning, algorithmic trading strategies, and more applied to real-world finance scenarios.
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

Accelerate your finance career with cutting-edge data skills.

Join Finance Train Premium for unlimited access to a growing library of ebooks, projects and code examples covering financial modeling, data analysis, data science, machine learning, algorithmic trading strategies, and more applied to real-world finance scenarios.