...
Money weighted return MWR money weighted return net return calculate return money investment calculate money weighted return

What is the money-weighted rate of return (MWR) and how can you calculate it?

The money-weighted return is a useful tool to track your personal investment performance. In this article you will learn what the money-weighted return means in detail, how you can determine themwhen it applies and which advantages and disadvantages it holds.

You'll also learn how money-weighted returns differ from other measures of return, such as simple and time-weighted returns. Are you ready to deepen your financial knowledge? Then let's get started!

Table of contents

What is the money-weighted rate of return (MWR)?

The money weighted return (MWR) is a method of calculating the return on an investment. It measures your investment experience as an investorby taking into account when and how much money you invested and at what point in time. Therefore, MWR is particularly useful when there are multiple cash flows and you are regularly depositing or withdrawing money.

sThe money-weighted return gives you a detailed picture of this, how good your personal investment decisions wereby including deposits and withdrawals and their timing in the calculation.

How can I calculate the money-weighted return?

Calculating the money-weighted return can seem complicated at first, especially when there are many cash flows. In this section you will learn a Step-by-step instructions for calculating the MWR which turns the complexity into a simple calculation. After the tutorial, you can experience the theory in practice with an example. Here is the guide to the Calculation of the money-weighted return in three steps:

  1. Identify the cash flows and time periods: First you need to define the cash flows (inflows and outflows) and the time period for each cash flow.
  2. Calculate the individual returns for each cash flow: In this step you have to calculate the individual return for each cash flow. You divide the final value of the investment by the initial value and subtract 1 from the result.
  3. Find the return that sets the net cash flow to zero: Now you need to find the rate of return that sets the net cash flow to zero over all periods. You can use the internal rate of return (IRR) function in a spreadsheet program. You can also use a calculator, but it is unnecessarily complicated, error-prone and inflexible.

 

If this seems too complicated or if you would rather save your time, you can use a Free tool like Portfolio Performance do this work for you.

Here is the practical calculation example:

You invest CHF 1,000 in a portfolio and after one month it is worth CHF 1,050. You decide to invest another CHF 2,000 and at the end of the next month the whole portfolio is worth CHF 3,150. The calculation of the money-weighted return looks like this:

You have been in the first month CHF 1'000 invested and at the end of the month it was CHF 1'050. The cash flow for the first month would therefore be CHF -1'000 (your investment is a payout) and for the second month CHF 1'050 (your portfolio is a deposit).

At second month you invest an additional CHF 2'000 and at the end of the month the value of your portfolio is CHF 3'150. Therefore the cash flow for the second month is CHF -2'000 and for the third month CHF 3'150.

To find the money-weighted return, you need to solve the following equation:

  • 1'000 / (1 + r) + -2'000 / ((1 + r)^2) = -3'150

Through Applying the IRR function in a spreadsheet programme you get a MWR of 4 % for this two-month period.

Financial Insider 2024

Your key to success! Discover our top recommendations from real testimonials.

When is the money-weighted return useful?

Although the money-weighted return is more complex to calculate, it gives you a sA personalised view of your investments. Therefore, MWR is particularly useful in the following scenarios:

  1. Individual investment performance: If you invest or withdraw money at irregular intervals and in variable amounts, the money-weighted return is an excellent measure of the individual performance of your investments. It takes into account the timing and size of your cash flows and therefore gives you a clearer picture of the return on your individual investment behaviour.
  2. Comparison with benchmarks: You can also use MWR to evaluate your investment strategy against benchmarks. If your return is higher than that of a benchmark, it means that your investment strategy is better at the time of calculation. However, if your return is lower, you might want to rethink your investment strategy or make adjustments.
  3. Advice and financial planning: For financial advisors, the money-weighted return is an important indicator of the performance of their client portfolios. It helps to better understand and optimise clients' individual investment styles.
  4. Performance of funds: In fund management, MWR helps to assess the impact of inflows and outflows on a fund's performance.

 

Although the money-weighted return is useful, it also has its limitations, which you will learn about in the next section.

Advantages and disadvantages of the money-weighted return

The money-weighted return provides a Variety of advantagesHowever, it also brings Challenges with. Here are the main advantages and disadvantages:

Advantages:
  • Personalised performanceThe MWR is an excellent way to measure the individual performance of your portfolio. It takes into account not only the amount but also the timing of your investments.
  • Fund valuation: The money-weighted return is a useful metric to assess the success of a fund manager.
  • ComparabilityWith the MWR you can compare different investment strategies or asset managers.
 
Disadvantages:
  • ComplexityThe difficulty of calculating the MWR increases with the number of transactions. A suitable software can quickly fix this problem.
  • DistortionsA large deposit or withdrawal can create distortions. For example, if you invest a large amount of money at a time when market prices are high and pay out later when prices are low.

 

Now that you have learned about the advantages and disadvantages, you can see a direct comparison with other methods of calculating returns.

Comparison between money-weighted yield and other yield calculations

As already mentioned, the return on your portfolio is an important indicator of the success of your investment. In addition to the money-weighted return, there are other ways of calculating returns. Each method has its advantages and disadvantages. The two most common other calculation methods are the simple and the time-weighted return.

  • Money-weighted return vs. simple return (ER): The simple return, also called absolute return, is the easiest return metric to calculate. It is simply calculated as (final value - initial value) / initial value. However, the simple return does not take into account the timing and size of your deposits and withdrawals.

 

In the calculation example, the initial value is CHF 1,000 and the final value is CHF 3,150. The simple return in this case would be 5 % (CHF 3,150 / (CHF 1,000 + CHF 2,000)) = 1.05 or 5 %).

  • Money-weighted return vs. Time-weighted return (TWR): Unlike the MWR, the time-weighted return measures the pure performance of the portfolio over time, regardless of when and how much you invested. The time-weighted return is therefore a better indicator of the fund manager's performance, whereas the money-weighted return is more a reflection of your personal investment performance.

 

For direct comparison, here is the calculation of the time-weighted return using the example from the text. The simple return for the first month is 5 % (CHF 1'050 / CHF 1'000) = 1.05). The simple return for the second month is (CHF 3'150 / CHF 3'050) = 1.0328 or 3.28 %.

To get the time-weighted return, you just have to add both calculated values: 5 % + 3.28 % = 8.3 %.

Comparison of the results of all three yield calculation methods:

Cash flowDateMWRERTWR
CHF - 1'00001.01.20234 %5 %8,28 %
CHF - 2'00001.02.2023
CHF 3'15001.03.2023

Our financial tips 2024

"Intelligent people learn from the mistakes of others".

We have compiled our top selection for you from all our tests and experience reports:

Conclusion on the calculation and application of the money-weighted return

The Money-weighted return is a useful tool to measure the performance of your investments and calculate the net return.. However, it is important to use them in combination with other metrics and information to get the full picture.

After reading this article, you will have a better understanding of money-weighted returns and how to use them in your investment process. Investing requires patience, discipline and continuous learning, but with the right tools and information you can start on the path to financial success.

Do you have any other questions about the topic or are there any other financial topics you would like to discuss? Feel free to use the comment function!

Leave a Reply

Your email address will not be published. Required fields are marked *

Get your free
Investment Guidebook
receive!