zerodha open demat account wide banner

What is the Internal Rate of Return (IRR)? And How Does it Works: Hi readers. A lot has been covered in our blog since its inception, we have written articles ranging from the basics of financial statements to concepts of valuation. A reader who has followed our blog from the beginning should now be able to perform a detailed analysis of a company and arrive at a valuation for investment.

To our ever growing list of posts, today we shall add one that seeks to provide a method for calculating the rate of return of a portfolio. This method is called the Internal Rate of Return (IRR).

The IRR method to measure portfolio performance has become a lot popular in recent days because of its effectiveness over CAGR measurements. That’s why you need to get acquainted with what actually is IRR and how to quickly calculate

It’s going to be a very informative post. So, let’s get started.

1. What is the Internal Rate of Return (IRR)?

Theoretically speaking, IRR is the rate at which the net cash flows (both inflow as well as outflow) from an investment would be equal to zero. Better said, it is the rate of return to be achieved by all the money invested to give back all the cash received.

2. How is IRR different from CAGR and how is it more useful for investors?

Although CAGR is a classic investment metric for calculating investment returns and makes a better representation of performance than average returns since it assumes the investment capital to be compounded over time.

kotak securities banner 500X500

But it makes a couple of assumptions that may hinder its practical use. Firstly, it assumes that the compounding process is a smooth one over time with steady returns being made every year. Secondly, it assumes that a portfolio incurs cash flow only two times during its lifetime. One is at the very beginning when an investment is made and the second when the investment is sold and cash is returned to the investor.

In practice rarely do we come across such scenarios where an investment is made only once, most of us happen to make regular investments over time and hence the overall return may actually be different than what the CAGR method of calculation may usually project to be.

In such cases of multiple or uneven investment periods and cash flows, the CAGR method of calculation becomes futile and using the Internal Rate of Return method would better serve the purpose. Mathematically, the IRR calculation is represented by the following expression.

Where P0, P1, . . . Pn equals the cash flows in periods 1, 2, . . . n, respectively; And, IRR equals the investment’s internal rate of return.

QUICK READ: How to perform the Relative Valuation of stocks?

3. Application of IRR method of return calculation with an example.

Assume we bought a stock of ₹3,00,000. Also, assume that we bought an additional ₹1,00,000 worth of stock one year later and another ₹50,000 two years later.

Let us make one more assumption that we hold the stock for 2 more years before selling the stock for a total cash return of ₹7,50,000

Here is how the IRR equation looks in this scenario:

Internal Rate of Return example

Mathematically speaking IRR cannot be computed analytically, but thanks to calculators and spreadsheets today this task can be done fairly easily.

Using the XIRR function in excel we get the IRR for this scenario as 11.80%, which is the rate that makes the present value of the investment’s cash flows equal to zero.

If we were to calculate the CAGR for the example for an initial investment of ₹4,50,000 and final cash return of ₹7,50,000 over a period of 5 years we would get a but the incorrect return of 10.8%.

zerodha open demat account wide banner

ALSO READ

Closing Thoughts

Although initially, the IRR method found applications in the capital budgeting projects of companies, recently it has become a favoured method among investors to calculate the capital allocation efficiency of their portfolio.

You can also try our stock screener – Trade Brains Portal which helps investors make efficient stock research and analysis by providing quality fundamental data with insightful visuals.

We advise our readers to add this to their ever-growing investing toolkit. Happy Investing.

tradebrains portal app download