We cover how to calculate the compound annual growth rate (CAGR) in Excel using daily figures. The compound annual growth rate calculates the rate of return over a period of time and it is often used to measure the past performance of investments or analyse business measures like sales or market value. In our example, we will calculate the compounded annual rate of growth a given company’s sales. We have the fictitious sales values for the 1st March 2010 to 7th March 2017. To deduce what the general trend in sales, we can calculate the CAGR. There are 2 methods to calculate this. Firstly, we can manually calculate the CAGR using a formula. Alternatively, we can use the RRI function.
Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation1
Please share this video with others that may find it useful:
https://youtu.be/Hdh63-CBnG4
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
The Excel Hub website: https://theexcelhub.com/
Instagram: https://www.instagram.com/theexcelhub/
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]Overview: (0:00)
Calculate CAGR Manually: (0:53)
Calculate CAGR Using RRI Function: (2:25)