What is XIRR?

XIRR

What is XIRR?

When we want to invest in a mutual fund first we check its returns of past 3 years, 5 year etc. These returns are point to point returns and are called Compounded Annual Growth Rate or CAGR.

For example, 3 year returns of 12% for a mutual fund X will mean that 10,000 Rs. invested 3 years ago have now become 14,049.28 Rs.

CAGR can be simply calculated by the formula

CAGR = (Ending Amount/Beginning Amount)(1/No. of years) – 1

Hence in the above example:

CAGR = (14,049.28/10,000)(1/3) – 1 = (1.4049)0.33 – 1 = 1.12 – 1 = 0.12 = 12%

XIRR

However, in real life the investments & redemptions happen over different period of time and CAGR won’t be applicable to calculate the returns. For example, you may invest 50,000 Rs. on 1st July 2017, then 20,000 Rs. on 20th September and then withdraw 15,000 Rs. on 1st December and the amount in your mutual fund account is 65,000 Rs. on 1st July 2018.  You cannot find the return on your investment in this case from CAGR.

For such cases XIRR is used to find the return.

XIRR is the short form of Extended Internal Rate of Return and is used to find the Return from investments done at different time periods.

Unlike CAGR, XIRR cannot be calculate by a formula and we have to use excel to calculate it.

XIRR formula in excel is

XIRR = XIRR(value,dates,guess)

Values are the transaction amounts, dates are the transaction dates and guess is the approximate return.

Let us calculate XIRR for above example:

XIRR

The invested amount and amount redeemed (or current value) should have opposite signs (positive or negative) for the purpose of calculation.

As, you can see from the above examples, XIRR is the right way to find out your investment returns in real life. CAGR is important to check for selection of a fund but XIRR is critical to evaluate the returns you got from your investments.

Start Investing in mutual funds on WealthTrust App.

New to Mutual Funds? Learn more about basics of mutual funds here.

Visit our website to know more about WealthTrust. Do read our blogs on Mutual funds.

 

 

5 Comments on “What is XIRR?”

    1. Hi Mr. Ali,

      We have already added XIRR and lot of new features in our next version which is set to release the coming week (2nd week of October). Feel free to WhatsApp us on +919879002229 in case of any further feedback or queries. Assuring you of 5* services.

      Thanks,
      Team WealthTrust

  1. “Unlike CAGR, XIRR cannot be calculate by a formula and we have to use excel to calculate it.” – How excel calculates it???? Send to guru to calculate???

Leave a Reply

Your email address will not be published. Required fields are marked *