- This topic has 3 replies, 2 voices, and was last updated 7 years, 3 months ago by
.
- Posts
-
Calculation problem that I will illustrate with Nestlé and Implenia:
Nestlé earned 1972% in 29 years (excluding dividends). So we say that the average annual return was 1972 / 29 = 68% per year.
For Implenia, the average return over the last 11 years (listed on the stock exchange only since 2006) was 167 / 11 = 15.2% per year.
We realize that this calculation is absurd because the result is very strongly impacted by a long duration, because of the ever-increasing influence of the compound effect over the long term.
In reality, Nestle's annual return should be around 10-15% per year without taking into account the compound effect. And this figure is in my opinion much more "true" than the 68%, because it shows what annual gain a NEW investor can expect to obtain.
Hence my question: is there a formula for calculating the annualized return excluding the compound effect?
Yes it's easy it's the CAGR or average annual growth rate in French
https://www.investopedia.com/terms/c/cagr.asp
A simple way to calculate it:
Personally, I prefer to use Excel:
Fantastic, thank you!
If I calculated correctly, this gives us a CAGR of 11.02% for Nestlé and 9.34% for Implenia.
- You must be logged in to reply to this topic.