Why arithmetic averages overstate real returns and how CAGR corrects it
A common error in financial reports and investment scripts is using the simple arithmetic mean of annual returns instead of the compound annual growth rate (CAGR). The article illustrates this with a R$ 10,000 portfolio that gains 50% in year one and loses 50% in year two, where the arithmetic average suggests 0% but the real outcome is a R$ 2,500 loss. The CAGR formula gives the equivalent geometric rate, about -13.40% per year, that actually converts the starting value into the ending value. The piece notes that the arithmetic mean always meets or exceeds the geometric mean, with the gap growing with the square of annual volatility. It also gives coding guidance for fractional periods and for handling zero or negative values, and is presented for educational purposes only, not as investment advice.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in