Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts


Compound Annual Growth Rate CAGR formula examples in Excel

To calculate Compound Annual Growth Rate (CAGR) in Excel, the average rate of return for an investment over a period of time, you can use several approaches. Formula =(end/start)^(1/periods)-1 Note that unlike most other financial functions in Excel, future value (FV) does not need to be entered as a negative number. Explanation In the example shown, the formula in H7…