3] Choose the cell where you want to calculate the CAGR data. This is the location where you’ll enter the RRI function, so keep that in mind. Type =RRI(A7,B2,B7) as the function, for example.

To calculate the CAGR in mutual funds using excel sheet, here is an example of CAGR calculation. When you see that a mutual fund scheme has generated 10 or 12 or 15 per cent returns over 2-years ...

The CAGR enables an investor to understand the historical growth trend of a particular investment over time, which further helps in financial planning. Additionally, it can be used for the ...