Compound annual growth rate
From Wikipedia, the free encyclopedia
 |
This article may require cleanup to meet Wikipedia's quality standards. Please improve this article if you can. (May 2008) |
Compound Annual Growth Rate (CAGR) is a business and investing specific term for the geometric mean growth rate on an annualized basis.
Where,
V(t_0) = start value,
V(t_n) = finish value, and
t_n - t_0 = number of years.
Note (1): The actual values may be used for calculation, or normalized values that retain the same mathematical proportion. Note (2): You can use the following formula to calculate CAGR in Excel:
- XIRR function
- "=((lastnumber/firstnumber)^(1/numberofyears))-1"
CAGR is used to describe the growth over a period of time of some element of the business, usually revenue, although other measures may be used (such as the number of units delivered, registered users, etc.). CAGR is not an accounting term, but remains widely used, particularly in growth industries or to compare the growth rates of two investments because CAGR dampens the effect of volatility of periodic returns that can render arithmetic means irrelevant.
[edit] Example
Where:
V(t_0) = 100,
V(t_1) = 95,
V(t_2) = 115,
V(t_3) = 150,
V(t_4) = 200, and
t_n - t_0 = 4;
Whereas,
The Arithmetic Mean Return would be the sum of annual returns divided by number of years or:
Whereas,
The Arithmetic Return or simple return would be the ending value - beginning value divided by the beginning value:
