Math & Statistics icon

Math & Statistics

Calculate safe allowlisted math and statistics operations for finance datasets.

Actions8

Finance Math → CAGR

AI-generated

Summary

Calculate the Compound Annual Growth Rate (CAGR) for each row based on specified start and end value columns over a given number of periods.

Inputs

  • CAGR Start Value Column (required) — Name of the column that contains the initial values to use for the CAGR calculation.
  • CAGR End Value Column (required) — Name of the column that contains the final values to use for the CAGR calculation.
  • CAGR Periods (required) — Number of periods (e.g., years) over which the growth is measured; must be a positive number.

Output shape

an object containing detailed results for each data row, including the original start and end values, the number of periods, the calculated CAGR as a decimal fraction, and the CAGR percentage, along with counts of valid and ignored rows and any warnings about non-positive initial values.

Input must be an array of JSON objects representing rows. Rows with non-numeric or missing start/end values are ignored. Rows with start values less than or equal to zero or negative end values yield null for CAGR. Warnings are provided if non-positive initial values are found. The output includes a list of all rows with calculated CAGR values or nulls where calculation isn't possible.

Links

Discussion