Mutual Funds: A Note on Tracking Returns Using CAGR, XIRR

Mutual funds remain an important investment tool for generating wealth over a period. In any mutual funds investment, tracking of returns is essential. This can be undertaken using compound annual growth rate (CAGR) and extended internal rate of return (XIRR). 

Here’s the lowdown on understanding how mutual funds investments can be suitably tracked using CAGR and XIRR.

CAGR highlights the annual growth rate of an investment over a particular period. 

The formula to calculate CAGR is: CAGR=(EV/BV)^ (1/n)-1

In this, EV refers to the ending value of the investment, while BV relates to the beginning value of the investment, and n signifies the number of years the investment spans. 

At the same time, XIRR is a comparatively complex metric that takes into account the timings of the investment. However, it provides a more accurate return rate. 

In the case of a systematic investment plan (SIP), where an investor makes periodic investments, the timing of these investments tends to have an influence on the returns of the portfolio. 

In this regard, XIRR comes across as a more accurate metric when it comes to assessing returns and assessing performance. 

The formula for calculating XIRR is: XIRR(values, dates, [guess])

In this case, values relate to the amount an investor has invested. This investment amount is to be mentioned in negative, considering it is an outflow. 

Dates relate to dates of investment and redemption in case any, while guess relates to an optional guess of the IRR, which is generally left blank. 

Normally, an XIRR of about 12% is considered good for equity mutual funds, while in the case of debt funds, it stands at 7.5%.

Typically, CAGR is used in the case of calculating the returns of a lump sum investment, while XIRR is useful in the case of investment in SIP mode.

You May Also Like
Gold Jewellery

24K Gold Rate in India for October 2019: Week 3

The week commenced with the gold rate in India holding at Rs.38,300…
Gold rate

24K Gold Rate in India for February 2020: Week 4

When trading opened for the week, 24K gold rate in India was…

Is income tax applicable on Bonus Income?

Did you know that tax deductions don’t apply for the incentives and…

Gold Price Trend Analysis: November 2020

The onset of the COVID-19 pandemic in the early parts of the…