How to Calculate Cumulative Growth

Опубликовал Admin
12-11-2016, 11:36
40 695
0
Expert Reviewed Cumulative growth is a term used to describe a percentage of increase over a set period of time. Cumulative growth can be used to measure growth in the past and, thereby, to plan for population growth, estimate organic cell growth, measure sales growth, and so on. It is a useful descriptive tool in figuring out how growth has developed over time or how growth will continue to develop. Investors, marketers, and business planners need to know how to calculate cumulative growth, often expressed as CAGR (cumulative average growth rate), because it appears frequently in the financial sections of companies' annual reports. The following article discusses several ways to go about finding and using CAGR.

Calculating CAGR Manually

  1. Identify the values needed to calculate CAGR. In order to calculate CAGR, you will need a few essential values. This includes the starting value, ending or finishing value, and the period of time over which you wish to measure growth.
    • Determine the starting value (SV) of an asset, for example, the price paid for a share of stock.
    • Determine the ending value (EV) or current market value of that asset.
    • Determine the period of time (T) you want to study, for example, the number of years, months, quarters, etc.
  2. Input these values in the CAGR formula. After you've gotten your information together, input your variables into the CAGR equation. The equation is as follows: CAGR=((EV/SV)^ 1/T)) -1.
  3. Solve for CAGR. After your values have been inputted in the CAGR equation, simply solve for CAGR using the proper order of operations. That is, be sure to calculate the (1/T) first, because it is an exponent, then solve for EV/SV and raise that number to the power found in the first step. Finally, subtract 1 from the number you just found. The result will be your CAGR.
    • For example, if a portfolio of investments had an initial value of $10,000 that grew to $19,500 over 3 years, you would start with CAGR=(($19,500/$10,000)^(1/3))-1 and simplify to CAGR=((1.95)^(0.333))-1 and CAGR=1.249-1. Your final result would be CAGR=0.249, or 24.9%.

Calculating CAGR Using a Computer

  1. Calculate CAGR using an online calculator. Perhaps the simplest way to calculate CAGR is to use an online CAGR calculator. These programs allow you to simply input your values for SV, EV, and T and will do the rest of the work for you. In order to find one of these calculators, try searching on a search engine for "CAGR calculator."
  2. Calculate CAGR using Microsoft Excel. Another simple way to calculate CAGR is to used Microsoft Excel. Other spreadsheet programs will likely perform this function just as well, but may require different formula structures. See help guides for these programs to learn how to perform these functions. In any case, start by inputting your values (SV, EV, and T) into cells in a new spreadsheet. For example, put SV into A1, EV into B1, and T into C1.
    • The easiest way to calculate CAGR in Excel is to simply enter the CAGR formula into a fourth cell. This requires entering the following into D1 (or any other cell you see fit): =((B1/A1)^(1/C1))-1. Excel will complete the calculations for you and the result will be presented in whichever cell you choose for the equation.
    • An alternate method of calculating CAGR in excel uses the POWER function, which calculates equations using exponents. For this calculation, create a cell for the formula and enter: =POWER(B1/A1,(1/C1))-1. Again, the answer should appear in this cell after you press enter.
    • Additionally, Excel can calculate CAGR by using the RATE function. Input this formula into a new cell by entering the following: =RATE(C1,-A1,B1). Press enter and Excel will display the answer.

Using CAGR to Predict Cumulative Growth

  1. Identify the values needed to calculate CAGR. CAGR can also be used to predict future growth based upon a historical CAGR. This is done similarly to calculating a historical CAGR. In order to calculate future value, you will need a few essential values. This includes the starting value, ending or finishing value, and the period of time over which you wish to measure growth.
    • Determine the starting value (SV) of an asset, for example, the price paid for a share of stock or the current revenues of a company.
    • Determine the period of time (T) you want to study, for example, the number of years, months, quarters, etc.
    • Enter the CAGR percentage as a decimal. For example, the CAGR percentage of 24.9% calculated in method one would be entered here at 0.249.
  2. Calculate future value using CAGR. Future values can be calculated using the following formula: FV = SV(1 + CAGR)^T. Simply input the values you have decided on and calculate the future value in a similar way to calculating CAGR. You can either calculate this value by calculator or using a computer.
    • To calculate this on a computer, use a spreadsheet program and enter the program into an empty cell. For example, a potential calculation in Excel would start with SV in cell A1, CAGR in cell D1, and T in cell C1. To calculate FV, enter the following into an empty cell: =A1(1+D1)^C1 and press enter.
  3. Analyze your result. When using your CAGR to predict future values, keep in mind that no historical data can accurately predict the future. However, using a CAGR can serve as a somewhat reliable estimate of future growth. Keep in mind also that this CAGR represents an average of the growth of the represented values and will likely be lower or higher within the given year or period of time that you are trying to estimate.

Tips

  • Even though CAGR, as it relates to business, is the primary measure of compound growth discussed here, the calculations also work for a number of other applications in the sciences. The same equation can be used for finding compound growth between any two values over a variety of different time frames.
  • Understand that this CAGR is a "smoothed" or "rounded" rate; that is, it has been consistent only if you assume there has been a more or less consistent economic history.
Теги:
Information
Users of Guests are not allowed to comment this publication.