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: [ Ссылка ]
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
If you like this video, you might like the following:
Analyze ROI and CAGR in Excel
[ Ссылка ]
#financialanalysis #excel #exceltips #excelformula #financialanalysis #financialformulas #excel #exceltutorial #exceltricks #exceldataanalysis #finance #financialeducation #investing #financeinexcel #dataanalysis
Ещё видео!