Money-weighted Returns
We learned about arithmetic returns and geometric returns. However, the problem with these measures is that they do not consider the amount of investment made in each period. For example, in the first year, we may have an investment of USD 5,000 while in the second year the investment may only be $2,000. So, the returns when looked at along with how much money was invested will make a huge difference to our actual return on investment. This is called money-weighted return or internal rate of return.
Let’s say we had the following investments and returns in the past 3 years:
In the first year, we made an investment of $1000, and we had a 100% return in the first year. By the end of the year, our investment has grown to $2,000. Then at the beginning of the second year we invested $2000 more making a total investment of $4000. The returns in the second year were -50%, and our investment value reduced to $2000. Then assume we withdrew $500 from the investment fund, leaving only $1500 invested. In the third year there was no new investment, and our returns were 35%, making our investment grow to $2025. The cash flows are shown in the table below.
The money-weighted returns can be calculated using the same formula as that of the Internal rate of Return (IRR).
Our cash flows are as follows:
CF0 = -$1,000
CF1 = -$2,000
CF2 = +$500
CF4 = $2,025
Applying the above formula and solving for IRR we get:
This tells the investor about what she actually earned on the money invested for the entire three year period. Note that this return is negative because a significantly large amount of money was invested in the year of negative returns compared to other years.
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 $29 (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.