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.

Membership
Learn the skills required to excel in data science and data analytics covering R, Python, machine learning, and AI.
I WANT TO JOIN
JOIN 30,000 DATA PROFESSIONALS

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.

Saylient AI Logo

Take the Next Step in Your Data Career

Join our membership for lifetime unlimited access to all our data analytics and data science learning content and resources.