sales projection

Hi
I have data for past 6 FY of export , how to project exports for next 5 years.Find the excel sheet in attachment in that second excel data is given for the FY wise. Can we use the CAGR to calculate the projected value.

excell guru help in this regard . It would be kind if you reply asap.

Originally Posted by ANSARI102

Hi
I have data for past 6 FY of export , how to project exports for next 5 years.Find the excel sheet in attachment in that second excel data is given for the FY wise. Can we use the CAGR to calculate the projected value.