Forum Discussion
Using CAGR to project sales
I am trying to project sales and market size using a set CAGR. I have the first year data and want to project sales 5 years out.
For quicker dispositive answers, provide concrete examples.
If first year data are in B2 and C2, and the expected annual growth rate (CAGR) is D2, the following demonstrates how to forecast the next 5 years.
Formulas:
B3: =B2*(1+$D$2)
C3: =C2*(1+$D$2)
Copy B3:C3 into B4:C7