In MS Excel what formula can be used to calculate growth when CAGR for the period is already given

Question

This is what my Excel sheet looks like

I've been provided the $ figure for the year 2020 in cell B5 and the CAGR % is reflected in cell L5.

The $ figure for 2020 is 342.9 ( Cell B5) and the CAGR growth rate per year is 92.60% (Cell L5)

What formula can be used to calculate the $ figure for the years 2021 through 2028?

Answer 1

If those are true CAGR's, then just do =B5*(1+$L5) and drag down and across.

I hope this helps you.