How To Calculate Cagr In Excel. CAGR Ending value Beginning value 1n - 1 Now lets see how to calculate CAGR in Excel. RRIB11 C6 C11 where C11 is the ending value in year 5 C6 is the starting value initial investment and B11 is the total number of periods.
CAGR Ending value Beginning value 1n - 1 Now lets see how to calculate CAGR in Excel. In Excel 2013 and later you can use the RRI function to calculate CAGR with a simple formula. Here is the formula that will calculate the CAGR.
N Time months years etc Lets see how to use the above formula in excel.
Here is the formula that will calculate the CAGR. Select a blank cell for example Cell E3 enter the below formula into it and press the Enter key. Say if we want to calculate the CAGR in terms of the year the exponential form will be 1 NY. The CAGR is also called a smoothed rate of return because it measures the growth of an investment as if it had grown at a steady rate on an annually compounded basis.