IRR Calculator - Internal Rate of Return
This Internal Rate of Return calculator (or the IRR calculator for short) is a helpful tool for determining whether a future investment is going to be profitable for you. As this metric is not always easy to understand and apply correctly, we prepared this handy guide to explain in detail how to calculate the IRR. We will also provide you with an IRR formula that better illustrates the underlying principles.
What is the Internal Rate of Return?
By definition, an Internal Rate of Return (IRR) is the interest rate at which all cash flows, associated with a certain investment, have a Net Present Value equal to zero. In other words, a project's IRR is the discount rate that makes the Present Value of the expected future cash flows to be equal to the initial investment.
Practically, such an interest rate guarantees that the money you would invest in such a project today will earn you precisely $0. You will neither win nor lose if you chose this investment - the only consequence will be your money has remained constant.
Why can estimating this particular value be helpful for a person dealing with finances? The reason is that the IRR corresponds to the project's rate of return. If this return exceeds the cost of the funds (for example cost of a loan or APR) employed to finance the project, then the difference might be a useful approximation for the profitability. On the other hand, if the IRR is lower than the cost of capital, the project is possibly unproductive.
The same concept applies to the yield to maturity (YMT), where the discount rate forces the present value of the cash inflow to equal the price of the bond if you hold the bond to maturity. In both cases, the analysis of what is time value of money constitutes the bottom line for the calculation.
The IRR formula is based on the equation used to calculate the Net Present Value. As you may remember:
NPV = -C₀ + ∑ [Cᵢ / (1 + r)ⁱ], where
i = 1...n
- NPV stands for the net present value of the investment.
- The first cash flow
C₀- your Initial Investment
- Every other cash flow
Cᵢwill be either positive (income) or negative (expenses). Each year, you have to increase the i value by 1.
- n is the number of periods (typically years) between now and the moment when you will receive your money.
- r is the discount rate (interest rate used in cash flow analysis).
As mentioned earlier, IRR is a discount rate for NPV equal to zero. Hence, we need to use the following formula:
0 = -C₀ + ∑ [Cᵢ / (1 + IRR)ⁱ], where
i = 1...n
Or, if you don't want to use the summation notation,
0 = -C₀ + C₁ / (1 + IRR) + C₂ / (1 + IRR)² + C₃ / (1 + IRR)³ + ... + Cn / (1 + IRR)ⁿ
As you probably noticed, there is no direct IRR formula: you can find this value either by trial-and-error (guessing the value of IRR and adjusting it after each result) or by using an automated tool, such as this IRR calculator.
How to calculate IRR: an example
As the idea of IRR is hard to grasp at first glance, we have prepared an example to illustrate how you may use it.
Let's say that a hairdresser wants to include perm maintenance in her hair salon. She estimates that the equipment will cost $6,000. She estimates that each year, she will earn $2,000 more than if she didn't purchase this equipment. After five years, the machine will be too old to use, so she will sell it for $1,000.
The hairdresser wonders whether it will be more profitable to buy all of that equipment or use her money to invest in her friend's coffee shop with an expected return of 12%.
To calculate the IRR, she needs to solve the following problem:
0 = -6000 + 2000 / (1 + IRR) + 2000 / (1 + IRR)² + 2000 / (1 + IRR)³ + 2000 / (1 + IRR)⁴ + 2000 / (1 + IRR)⁵ + 1000 / (1 + IRR)⁶
You can use this IRR calculator to confirm that the IRR metric in this case is 22.22%. It is substantially higher than her other investment option, which makes buying additional equipment the preferable choice.
How to use the IRR calculator
You can quickly resolve the previously discussed mathematical problem by placing the values from the question into our calculator.
The initial investment is your expenses at time zero (with a positive sign) that precedes the yearly cash flows.
The default number of years in our IRR calculator is three, but in case you would like to analyze a more extended period, the additional lines will pop up automatically. Also, you will simultaneously see the estimated Internal Rate of Return (IRR) as you input each year.
IRR vs. MIRR: what is the difference?
Apart from the IRR metric, you can also determine the profitability of an investment with MIRR - the Modified Internal Rate of Return. The main difference between these two metrics lies in the approach to the cash inflows: in MIRR, we assume that each cash inflow is reinvested at a steady rate, called the reinvestment rate. This way, the profit you receive on your investment is used to generate additional income throughout your project.