Geometric mean can be used to calculate average rate of return with variable rates.
RRI Function
The Excel RRI function returns an equivalent interest rate for the growth of an investment. You can use RRI to calculate Compound Annual Growth Rate (CAGR) in Excel.
