• 08/04/2016
    What is CAGR? Making Sense of a Commonly Used Metric

    Context: I recently received a message from a subscriber asking if I could explain the CAGR formula. He said that he had used it in one of his models, and when he looked it up online there was no explanation for the math. His response: “Welp, if you say so formula…” So I thought I would take a moment to explain the formula.

    Q: Do you have an explanation for the CAGR formula?


    CAGR Formula


    A: First, for the unfamiliar, let’s define the Compound Annual Growth Rate (CAGR). CAGR is a simple metric that measures the average rate of growth of a sum, be that a figure like sales or an investment, over any number of periods. It’s easy to picture visually:

     

    CAGR Growth Comparison

     

    In Example 1 above, a $1.00 investment grows by 20% for three years to a value of $1.73. The CAGR is 20%. Now, as you can see in Example 2, even if the growth each year is uneven, because the CAGR formula uses only the ending and beginning values to calculate average growth, the result will be the same. 

    With the definition out of the way we can move on to understanding the formula, and for that purpose I have developed the visual that follows:

     

    CAGR Formula Explained

    Click here to download the Excel file