Mar 16, 2019 · CAGR is the returns that you will get over regular and uniform time intervals. Suppose, your final sum is S and the initial amount is I and the total duration is T years, then you can calculate CAGR as: CAGR= ((S / I) ^ (1/ T)) – 1. Now, the calculation seems very simple, then why go for XIRR.

Video2x macInstructions for using the Online CAGR Calculator in MS Excel Enter the number in the appropriate periods (1). Note that in reality you only need to enter the first and last number,... Choose the period you want to go to (2) The CAGR will be shown (3)

3. Compounded Annual Growth Rate (CAGR): CAGR is a more effective way to calculate your returns if the duration of your SIP investment is more than a year. This method shows you the growth of your investment had it generated a constant return. Realistically though, returns may or may not be the same every year.