You need the beginning value interest rate and number of periods in years. This formula is applicable if the investment is getting compounded annually means that we are reinvesting the money on an annual basis. To reach the formula for compound interest you algebraically rearrange the formula for CAGR.
Gross figure x 1 interest rate per period.
You need the beginning value interest rate and number of periods in years. In our example the formula is A2 1B2 where A2 is your initial deposit and B2 is the annual interest rate. Wanted to have an Excel function to do it for you. In the example shown the formula in C10 is.