In annual reports to core clients, management often wants to use "cumulative growth rate" to quantify the value of long-term cooperation. However, how to define and calculate a cumulative metric that is both rigorous and easy to understand often troubles the analytics team. Below is a real confusion raised by a practitioner, along with a professional breakdown of the issue.

Background of the original question

An employee at a company wrote on an internal forum: "Our CEO wants to make a presentation to our largest client showing the cumulative growth rate of our cooperation with this client over the past three years. I have proposed metrics such as average quarter-over-quarter growth, three-year compound annual growth rate (CAGR), and year-over-year growth, but I still cannot find a way to reflect 'cumulative' in a meaningful manner. I sincerely ask for suggestions. Thank you."

Applicability analysis of common growth rate metrics

To address the above need, let us first clarify the definitions and applicable scenarios of several common metrics:

  • Average quarter-over-quarter growth: Reflects the average rate of change between adjacent quarters, suitable for observing short-term fluctuations, but cannot be directly accumulated into a multi-year total.
  • Three-year compound annual growth rate (3-Year CAGR): Takes the nth root of the ratio of ending value to beginning value over the number of years to obtain the average annual growth rate, suitable for measuring long-term trends, but it is not a "cumulative" concept.
  • Year-over-year growth: Compares the change in the same period (e.g., a quarter or year) with the same period in the previous year, which can eliminate seasonal effects, but it also does not directly reflect "cumulative".

Feasible approaches to constructing a "cumulative growth rate"

To present the "cumulative growth rate over the past three years," it is recommended to approach it from the following angles:

  1. Define the cumulative basis: Clarify whether it is "cumulative revenue growth rate" (i.e., the increase in total revenue over three years compared to the base year's revenue) or "cumulative customer value growth rate" (e.g., order volume, profit contribution). This needs to be confirmed with the CEO and the finance department.
  2. Use "cumulative growth multiple" or "cumulative growth percentage": For example, set the first year as a baseline of 100%, calculate how many times the total value after three years is of the baseline, or directly calculate (ending cumulative value - beginning value) / beginning value. This is more intuitive than average quarter-over-quarter growth.
  3. Supplement with CAGR: While presenting the cumulative growth rate, also include the three-year CAGR as an annual average reference, making it easier for clients to understand the long-term trend.
  4. Visualization aids: Use line charts or bar charts to show the change in cumulative values each year, marking key milestones, so that the "cumulative" process is clear at a glance.

Notes and uncertainties

It should be particularly noted that the original question did not provide specific data or industry background, so the above suggestions are only a methodological framework. In actual calculation, ensure consistency in data definitions (e.g., whether taxes are included, whether one-time items are included), and consider the client's business cycle (e.g., in industries with obvious seasonality, quarter-over-quarter changes may be distorted). In addition, if there are contract changes or price adjustments during the cooperation, they should be noted in the presentation to avoid misleading.

Professional tip: When presenting growth rates to external clients, it is recommended to provide both absolute values and relative ratios, and clearly state the calculation basis and exclusions to enhance credibility.

In summary, there is no "one-size-fits-all" formula for cumulative growth rate; the key is to choose the most appropriate combination of metrics based on the purpose of the presentation and the characteristics of the data. If the CEO wants to emphasize the total growth brought by long-term cooperation, it is recommended to use "cumulative growth rate (based on the base period)" as the primary metric, supplemented by CAGR; if more attention is paid to recent momentum, year-over-year growth can be emphasized. The final plan should be validated with the finance team.