Wish to calculate CAGR of each client for the last 5 Years, 've a data set in the below format(Sample), The data starts from Fy14 till YTD. Please advise the process and formulas to calculate the same.
Date FY Revenue client
11/01/2018 FY19 $600 A
12/01/2018 FY19 $12514 B
01/01/2018 FY19 $51214 C
02/01/2019 FY19 $545415 D
What does "CAGR" mean? Are you trying to achieve YTD or other results? Could you post calculate logic and the expected result?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.