Sponsored Links
-->

Friday, September 28, 2018

Calculate a Compounded Annual Growth Rate (CAGR) - YouTube
src: i.ytimg.com

Compound annual growth rate (CAGR) is a business and investing specific term for the geometric progression ratio that provides a constant rate of return over the time period. CAGR is not an accounting term, but it is often used to describe some element of the business, for example revenue, units delivered, registered users, etc. CAGR dampens the effect of volatility of periodic returns that can render arithmetic means irrelevant. It is particularly useful to compare growth rates from various data sets of common domain such as revenue growth of companies in the same industry.

CAGR is equivalent to the more generic exponential growth rate when the exponential growth interval is one year.


Video Compound annual growth rate



Formula

C A G R ( t 0 , t n ) = ( V ( t n ) V ( t 0 ) ) 1 t n - t 0 - 1 {\displaystyle \mathrm {CAGR} (t_{0},t_{n})=\left({\frac {V(t_{n})}{V(t_{0})}}\right)^{\frac {1}{t_{n}-t_{0}}}-1}
  • V ( t 0 ) {\displaystyle V(t_{0})}  : start value, V ( t n ) {\displaystyle V(t_{n})}  : finish value, t n - t 0 {\displaystyle t_{n}-t_{0}}  : number of years.
  • Actual or normalized values may be used for calculation as long as they retain the same mathematical proportion.

Maps Compound annual growth rate



Example

In this example, we will compute the CAGR over three periods. Assume that the year-end revenues of a business for four years, V(t) in above formula, have been:

t n - t 0 {\displaystyle {t_{n}-t_{0}}} = 2007 - 2004 = 3

Therefore, to calculate the CAGR of the revenues over the three-year period spanning the "end" of 2004 to the "end" of 2007 is:

C A G R ( 0 , 3 ) = ( 13000 9000 ) 1 3 - 1 = 0.13 = 13 % {\displaystyle {\rm {CAGR}}(0,3)=\left({\frac {13000}{9000}}\right)^{\frac {1}{3}}-1=0.13=13\%} - it's a smoothed growth rate per year. This rate of growth would take you to the ending value, from the starting value, in the number of years given, if growth had been at the same rate every year. (In reality, growth is seldom constant.)

Verification:

Multiply the initial value (2004 year-end revenue) by (1 + CAGR) three times (because we calculated for 3 years). The product will equal the year-end revenue for 2007. This shows the compound growth rate:

V ( t n ) = V ( t 0 ) × ( 1 + C A G R ) n {\displaystyle V(t_{n})=V(t_{0})\times (1+{\rm {CAGR}})^{n}}

For n = 3:

= V ( t 0 ) × ( 1 + C A G R ) × ( 1 + C A G R ) × ( 1 + C A G R ) {\displaystyle =V(t_{0})\times (1+{\rm {CAGR}})\times (1+{\rm {CAGR}})\times (1+{\rm {CAGR}})}
= 9000 × 1.1304 × 1.1304 × 1.1304 = 13000 {\displaystyle =9000\times 1.1304\times 1.1304\times 1.1304=13000}

For comparison:

  • the Arithmetic Mean Return (AMR) would be the sum of annual revenue changes (compared with the previous year) divided by number of years, or:
AMR = x ¯ = 1 n ? i = 1 n x i = 1 n ( x 1 + ? + x n ) = 11.11 % + 10 % + 8.33 % 3 = 9.81 % . {\displaystyle {\text{AMR}}={\bar {x}}={\frac {1}{n}}\sum _{i=1}^{n}x_{i}={\frac {1}{n}}(x_{1}+\cdots +x_{n})={\frac {11.11\%+10\%+8.33\%}{3}}=9.81\%.}

In contrast to CAGR, you cannot obtain V ( t n ) {\displaystyle V(t_{n})} by multiplying the initial value, V ( t 0 ) {\displaystyle V(t_{0})} , three times by (1 + AMR) (unless all annual growth rates are the same).

  • the Arithmetic Return (AR) or simple return would be the ending value minus beginning value divided by the beginning value:
AR = V f - V i V i = 13000 - 9000 9000 = 44.44 % . {\displaystyle {\text{AR}}={\frac {V_{f}-V_{i}}{V_{i}}}={\frac {13000-9000}{9000}}=44.44\%.}

Roundup Of Internet Of Things Forecasts And Market Estimates, 2018 ...
src: mk0enterpriseirdbne0.kinstacdn.com


Applications

These are some of the common CAGR applications:

  • Calculating and communicating the average returns of investment funds
  • Demonstrating and comparing the performance of investment advisors
  • Comparing the historical returns of stocks with bonds or with a savings account
  • Forecasting future values based on the CAGR of a data series (you find future values by multiplying the last datum of the series by (1 + CAGR) as many times as years required). As every forecasting method, this method has a calculation error associated.
  • Analyzing and communicating the behavior, over a series of years, of different business measures such as sales, market share, costs, customer satisfaction, and performance.

How to calculate a CAGR in Excel - YouTube
src: i.ytimg.com


See also

  • Annual growth %
  • Arithmetic mean
  • Average annual return
  • Continuous compounding
  • Geometric mean
  • Exponential growth

Infonetics: Cable's Share of Pay-TV Market Continues to Shrink as ...
src: mms.businesswire.com


References

Source of article : Wikipedia