((FV/PV)^(1/n)) – 1. 
The CAGR formula can be recreated in Excel. The formula to use is: = ((FV/PV)^(1/n)) – 1. Where FV is the investment’s ending value, PV is its ending value, and n is the # of years. The XIRR function in Excel also calculates an internal rate of return (IRR) that can also be used to calculate the CAGR. The XIRR function is: Excel CAGR formula. In this example we have the sales figures for a five year period, and what we want to know is what constant growth rate, results in the sales figure going from about 8700 to 18700. In this lesson you can learn how to calculate CAGR in Excel. CAGR (Compound Annual Growth Rate) is year-of-year average growth rate over a period of time. Calculating CAGR you can check how much do you earn annualy with your investments. To calculate CAGR you can use that formula: = ((FV/PV)^(1/n)) - 1. 1  FV stands for Future Value. 2  PV stands for Present Value. A: The compound annual growth rate, or CAGR for short, measures the return on an investment over a certain period of time. Below is an overview of how to calculate it by hand, and in Excel. Check out our full list of FAQs on calculating key financial measures in Microsoft Excel.
http://www.investopedia.com/ask/answers/071014/what-formula-calculating-compound-annual-growth-rate-cagr-excel.asp http://www.auditexcel.co.za/video-tutorial/excel-cagr-formula/ http://best-excel-tutorial.com/55-advanced/108-cagr http://www.investopedia.com/ask/answers/071014/what-formula-calculating-compound-annual-growth-rate-cagr-excel.asp
excel formula to calculate CAGR