How to Annualize Monthly Returns – Example
It is important for an investor to know how to calculate the annualized returns on his investments. Most brokerage firms and mutual and companies will provide you your investment summary and performance summary on a monthly basis, and the returns mentioned in them will most likely be monthly returns, not annual returns. Unless you annualize the returns, you will not have a clear idea of how your investment has performed, especially when there are some good months and some bad months.
So, let’s look at how you can annualize your monthly returns.
If you know the monthly rate, which is the same in all months, all you need to do is calculate the annualized returns using the following formula: APY = (1 + R)^12-1
So, if the monthly rate is 2% for all months, the annualized rate is:
\= (1+2%)^12 – 1
\= 1.02^12-1 = 0.2682 or 26.82%
If, on the other hand, you have monthly returns for separate months, then you will annualize the returns using the following formula:
APY = (1+r1)*(1+r2) *(1+r3) *(1+r4) *(1+r5) *(1+r6) *(1+r7) *(1+r8) *(1+r9) *(1+r10) *(1+r11) *(1+r12) – 1
Let’s say the twelve monthly returns are 2%, 2.2%, 2.1%, -1.5%, 2%, 2.4%, 1%, -1.2%, -0.5%, 0.7%, 1%, and 1.5%.
Using the above monthly returns, we can calculate the annualized returns as follows:
APY = (1.02)(1.022)(1.021)(0.985)(1.02)(1.024)(1.01)(0.988)(0.995)(1.007)(1.01)(1.015) - 1
Annualized return = 0.1223 or 12.23%
Note that when the monthly return is positive (such as 2%), it is express as (1+2%) or (1+0.02) or (1.02). When the monthly return is negative (such as -1.5%), it is expressed as (1-1.5%) or (1-0.15) or (0.985).
Data Science in Finance: 9-Book Bundle
Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.
What's Included:
- Getting Started with R
- R Programming for Data Science
- Data Visualization with R
- Financial Time Series Analysis with R
- Quantitative Trading Strategies with R
- Derivatives with R
- Credit Risk Modelling With R
- Python for Data Science
- Machine Learning in Finance using Python
Each book includes PDFs, explanations, instructions, data files, and R code for all examples.
Get the Bundle for $39 (Regular $57)Free Guides - Getting Started with R and Python
Enter your name and email address below and we will email you the guides for R programming and Python.