Get awesome investing ideas, news and information from investors and experts – Join the coolest money network 😎

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 = (Ending Amount/Beginning Amount)(1/No. of years) 1

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

However, in real life the investments & redemptions happen over different period of time and CAGR wont be applicable to calculate the returns. For example, you may invest 50,000 Rs. on 1stJuly 2017, then 20,000 Rs. on 20thSeptember and then withdraw 15,000 Rs. on 1stDecember and the amount in your mutual fund account is 65,000 Rs. on 1stJuly 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.

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

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 onWealthTrust App.

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

Visit ourwebsiteto know more about WealthTrust. Do read ourblogson Mutual funds.

Unlike my CAMS app we very much miss the XIRR in Wealth Trust app. Please try to add it in next version.

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 +9 in case of any further feedback or queries. Assuring you of 5* services.

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???

Sir there is a scientific formula which uses Newton Raphson method for calculation of XIRR.

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

बेस्ट बैलेंस्ड फंड्स( 2018-2019 )- Best Balanced Funds

बेस्ट ELSS फंड्स (2018-2019) Best ELSS Fund 2018

ग्रोथ या डिविडेंड Growth vs Dividend option in Hindi

म्यूचुअल फंड के प्रकार- Mutual fund types in hindi

म्यूचुअल फंड कैसे काम करता है? How mutual funds work in Hindi

If you want to subscribe to our monthly newsletter, please submit the form below.

If you want to subscribe to our monthly newsletter, please submit the form below.