Besides the original table enter the below formula into the blank Cell C3 and and then drag the Fill Handle to the. Drag the fill handle from cell C3 to cell C8 to copy the formula to the cells below. It is very easy to use.
Excel offers us multiple configuration options.
End of year 3 value 160000. The tool automatically calculates the average return per year or period as a geometric mean. Calculating Average Annual Growth Rate AAGR in Excel. Besides the original table enter the below formula into the blank Cell C3 and and then drag the Fill Handle to the.