Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Calculate Compound Annual Growth Rate. CAGR Formula Ending value Beginning value 1No. 1000 1 - -7948 92052 92052 1 - -7948 84736 84736 1 - -7948 78001.
For example lets derive the compound annual growth rate of a companys sales. CAGR is the measure of an investments growth over time. Here is the formula that will calculate the CAGR.
The 116 CAGR means that this investment has grown at a rate of 116 every year.
CAGR 30001000 13 -1 4422 Over three years Rebeccas investment showed a Compound Annual Growth Rate of approximately 44. How To Calculate CAGR Using Our Online Calculator. Interest rate variance range. Calculate Compound Annual Growth Rate in Excel.