HOW TO CALCULATE CAGR?

[Pradeep Pradhan]

I have attached the file. The file shows sales Qty in nos from 06-07 to 15-16.

I want to find CAGR %. I have applied one formula but not satisfied.

Can any body help?

Regards
PK

 

[vletm]

Have You tested function XIRR:
https://support.office.com/en-us/ar...ate-CAGR-3ccb7cd3-39b3-49ee-8b38-c19972607dfa

 

[PaulM4135]

I have attached the file. The file shows sales Qty in nos from 06-07 to 15-16.

I want to find CAGR %. I have applied one formula but not satisfied.

Can any body help?

Regards
PK

Hi PK,

Your formula is correct - the only change is i believe it should read
=((B11/B2)^(1/10))-1

"1/10" instead of "1/9" as you have 10 years of data.