Jun 7, 2005 · How can you calculate the CAGR (Compounded Annual Growth Rate)? Say I have 2 numbers and corresponding dates as follows; 1999 - $10000 2003 - $25000 How can I …

Jul 21, 2015 · Join Date 06-04-2015 Location India MS-Off Ver 2007,2013 Posts 63

Join Date 07-06-2020 Location zimbabwe MS-Off Ver Excel 365 Posts 567

Jan 6, 2006 · Values are -8580, 2004, 619, 464 and the result is 46.82% Using CAGR calculation in Investopedia.com I get 10.78% What am I doing wrong in ExceL? How to calculate CAGR …

May 11, 2015 · Hi, I am trying to calculate CAGR - compound annual growth rate - for an investing idea: My final investment figure is $10,000 I started with zero, but put in £5,500 over 5 years.

Dec 7, 2017 · Hi, Is there a function in excel 2007 to calculate CAGR, the Compound Annual Growth Rate? I know the formula to calculate it, and I can do it, but in my case it's messy. I …

Jul 17, 2014 · Usually, that is not what we mean by CAGR if we are given the actual values for years 0 through 3. Instead, usually we want the CAGR that results in 15 (actual cash flow) in …

Jun 18, 2015 · Join Date 06-26-2010 Location Austin, TX MS-Off Ver Excel 2010 Posts 1,673

Sep 6, 2005 · Is there an excel function to calc >> compound rates? I remember coming across this some time ago but cannot > seem >> to find it in the help now... >> >> "Duke Carey" …

Sep 6, 2005 · CAGR. In your case, assuming that both the amounts are beginning of period, the formula would be =25000/19000^(1/4) - 1 "Bruce" <[email protected]> wrote in message …