Calculate a Compounded Annual Growth Rate (CAGR)



Why choose wikiHow?
When you see the green expert checkmark on a wikiHow article, you know that the article has received careful review by a qualified expert. If you are on a medical article, that means that an actual doctor, nurse or other medical professional from our medical review board reviewed and approved it. Similarly, veterinarians review our pet articles, lawyers review our legal articles, and other experts review articles based on their specific areas of expertise.

How to Calculate Cumulative Growth

Three Methods:

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.

Steps

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.
  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 ,000 that grew to ,500 over 3 years, you would start with CAGR=((,500/,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.
  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.

Community Q&A

Search
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.

Video

  • 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.

Related wikiHows

Sources and Citations

Article Info

Categories:

In other languages:

Русский: , Italiano: , Español: , Português: , Bahasa Indonesia: 

Thanks to all authors for creating a page that has been read 136,669 times.





Video: Understanding CAGR - Compounded Annual Growth Rate [#khanacademytalentsearch]

How to Calculate Cumulative Growth
How to Calculate Cumulative Growth images

2019 year
2019 year - How to Calculate Cumulative Growth pictures

How to Calculate Cumulative Growth recommendations
How to Calculate Cumulative Growth forecasting photo

How to Calculate Cumulative Growth picture
How to Calculate Cumulative Growth photo

How to Calculate Cumulative Growth How to Calculate Cumulative Growth new foto
How to Calculate Cumulative Growth new photo

photo How to Calculate Cumulative Growth
foto How to Calculate Cumulative Growth

Watch How to Calculate Cumulative Growth video
Watch How to Calculate Cumulative Growth video

Discussion on this topic: How to Calculate Cumulative Growth, how-to-calculate-cumulative-growth/
Discussion on this topic: How to Calculate Cumulative Growth, how-to-calculate-cumulative-growth/ , how-to-calculate-cumulative-growth/

Related News


How to Decoupage a Bowl with Lace
How to Choose Eco Friendly School Supplies
Were Certain These Are the Best Bomber Jackets to Buy in 2019
Blunt, Long Hairstyles Trends: Prom Hair Styles
Need Help Fitting in Fitness
Im in love with an alcoholic
How to Give a Girl Space
DIY Honey Facial Masks
3 Ways to Hem Jeans
Tom Ford Menswear: SS13



Date: 01.12.2018, 11:08 / Views: 43243