Calculate CAGR in Excel ➡️ READ DESCRIPTION FOR ASSUMPTIONS
The investment was made on January 1, 2015 ($100,000) and we are calculating the ending investment on December 31, 2022 ($315,000). In other words, 8 full years.
A longer and more detailed example can be found here on how to calculate CAGR: • Calculate CAGR in Excel (Compound Annual G...
Formula: CAGR = ( End Value / Beginning Value )^(1/n)-1
Beginning Value = the date of purchase
End Value = Value at the date of sale or measurement
n = number of years or periods
Watch this next:
Analyze ROI and CAGR in Excel
• Calculate Return on Investment and Compoun...
#financialanalysis #excel #exceltips #excelformula #financialanalysis #financialformula #exceldataanalysis #finance #financialeducation #financeinexcel