Questions specific to CAGR and multi-period growth, which is where most confusion with simple growth rates tends to start, particularly when comparing investments held for different lengths of time.
What's the difference between growth rate and CAGR?
Simple growth rate compares only the start and end values, ignoring how long it took. CAGR spreads that same total growth evenly across the number of periods, answering "what steady rate per period produces this result."
Why is CAGR always lower than the total simple growth rate whenever more than one period is involved?
Because CAGR compounds, each period's growth is calculated on the already-grown value from the previous period, so a smaller per-period rate, applied repeatedly, still adds up to the same large total.
Can growth rate be negative?
Yes, a negative growth rate means the ending value is smaller than the starting value, which is the same calculation as a percentage decrease read from the growth side.
How many periods should I use for a meaningful CAGR?
At least two, and ideally enough to smooth over short-term noise, a CAGR calculated over a single volatile year can be misleading compared to one calculated over three to five years.
Is CAGR the same as the average of each year's individual growth rate?
No, and this is a common mistake. CAGR is a compound (multiplicative) average, not a simple arithmetic average of yearly rates: a year of +50% followed by a year of −50% averages to 0% arithmetically, but the actual CAGR is negative, since the value never fully recovers.
How do I calculate a growth rate for irregular time periods?
Convert the irregular span into a fractional number of periods, 18 months is 1.5 years, and use that fractional value in the periods field to get an accurate annualized rate.
What does a CAGR of 0% mean?
The ending value equals the starting value, no net growth over the entire span, even if the value fluctuated up and down in between.
How is CAGR used to compare two different investments?
It reduces two investments with different time horizons and different total returns to the same comparable measure, an annual rate, making it possible to say which one performed better per year rather than just which one made more money in total.
Can I use months instead of years for the periods field?
Yes, the calculation doesn't care what unit the periods represent, as long as you're consistent; using months instead of years simply produces a compound monthly growth rate instead of an annual one.
Why does a high simple growth rate sometimes correspond to an unimpressive CAGR?
Because the same total growth spread over many periods implies a much smaller rate per period, 74% total growth over three periods is only about 20% per period, which is respectable but far less dramatic-sounding than "74% growth."