Calculating CAGR in Excel The math formula is the same as above: You need ending values, beginning values, and a length measured in years. Excel has a built-in formula, but it’s far from ideal.

Calculating CAGR or Compound Annual Growth Rate in Microsoft Excel is super easy. You will have to use the RRI function to get the job done.