...
time-weighted return twr twr performance performance twr twrr return meaning

What is the time-weighted rate of return (TWR) and how do you calculate it?

The time-weighted return is a valuable tool for determining the Compare the performance of different investment portfolios. In this article you will learn what time-weighted returns are, how to calculate them, when they are useful and what their advantages and disadvantages are.

You will also learn how the time-weighted return differs from other return calculations such as the simple or money-weighted return.

Ready to take your knowledge to the next level? Let's go!

Table of contents

What is the time-weighted rate of return (TWR)?

The Time-weighted return (TWR) is a method for calculating the return on an investment. It Measures the success of an investment strategy, regardless of when and how much money in a specific period invests was. Therefore, it is particularly useful when there are multiple cash flows, for example, when you pay money in or out frequently.

The time-weighted return gives you a Clear picture of how your portfolio has developedwithout the results being distorted by further payments in or out.

How can I calculate the time-weighted return?

To calculate the time-weighted return for your portfolio, follow the steps below. If after the Step-by-step guide If you have problems with the calculation, you will find a practical example with a calculation example below.

  1. Identify the cash flows and time periods: You must first identify the cash flows (inflows and outflows) and the period for each cash flow. This is the basic data you need for the calculation.
  2. Calculate the simple rate of return for each time step: For each time step you calculate the simple return. You have to take the final value minus the initial value and divide the result by the initial value. Add 1 to this value.
  3. Multiply the calculated returns: Multiply the simple returns of all time steps together and subtract 1 from the result. This gives you the time-weighted return (TWR) for the entire period.

If you would like to calculate the TWR and other key figures easily and conveniently at the click of a mouse, you should take a look at the free tool Portfolio Performance View

Otherwise, here is a practical example for calculating the TWR performance

Say, you invest CHF 1,000 in a portfolio and after one month it has a value of CHF 1,050. Now you invest another CHF 2,000 and at the end of the next month the entire portfolio is worth CHF 3,150. The Calculation of the time-weighted return would look like this:

For the first month the simple return would be (CHF 1,050 / CHF 1,000) = 1.05 or 105 %. Since you are calculating the final value of the first month, you subtract 1 and get 0.05 or 5 %.

In the second month you invest another CHF 2'000, which brings your total investment to CHF 3'050. At the end of this month, the value of your portfolio is CHF 3'150. Therefore, the simple return for the second month is (CHF 3'150 / CHF 3'050) = 1.0328 or 103.28 %. Again, you subtract 1 to get 0.0328 or 3.28 %.

To get the TWR, you now multiply the values of the simple returns for each month and subtract 1: (1.05 × 1.0328) - 1 = 0.083 or 8.3 %. You can also simply add the percentages: 5 % + 3.28 % = 8.3 %.

Your time-weighted return over this two-month period is 8.3 %.

Financial Insider 2024

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

When and why the TWR is used

The TWR is particularly practical for Evaluate the performance of an asset manager or fund manager. Since the TWR takes into account the times when receipts and payments occur, you can assess how well the manager has managed the funds regardless of the cash flows.

Furthermore, the TWR is useful for Evaluation of your own investment performance. You may want to compare different strategies or see how your portfolio has developed over time. With the TWR you can do just that.

Advantages and disadvantages of the time-weighted return

The time-weighted return has many Advantages.

  • It enables a Fair and accurate valuation of the system output.
  • She is independent of the cash flows.
  • It is a good tool to help the Compare the success of different investment strategies.

The TWR allows you to directly compare the performance of different investments, managers or strategies. This is especially important if you are looking for ways to improve your investment strategy.

Despite these advantages, the TWR also has some Disadvantages.

  • You Does not take into account the size of the individual cash flows. This means that it cannot fully reflect an investor's individual investment experience. For example, a large deposit at an inopportune time could have a significant impact on the actual return but not be fully reflected in the TWR.
  • Another disadvantage is the Complexity of the calculation, especially if there are many deposits and withdrawals. Here, therefore, is another reference to tools such as Portfolio Performance and Co.

Comparison with simple yield and money-weighted yield

In the calculation of the fair value return, the simple rate of return (ER) a fundamental component. In addition to the simple return, there is also the money-weighted return. All three types of calculation have their specific use cases and can be useful in different situations.

In the above example, the initial value is CHF 1,000 and the final value is CHF 3,150. Therefore, the simple return: (CHF 3'150 / (CHF 1'000 + CHF 2'000)) = 1.05 or 5 %.

When you have money-weighted yield (GWR) it gets complicated, because you have to relate the net cash flow for each period to the return you are looking for. For the return, you have to solve this equation:

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

To solve this equation you need Financial functions such as the IRR (Internal Rate of Return) in a spreadsheet programme. For illustration, you can use the GWR in Google Sheets with the IRR function and use the returns of the other calculation types as a comparison:

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

So you can see that the different methods of calculating returns give very different results. 

Why is that important for you? If a financial service provider advertises its rate of return, you should know how it was calculated and whether figures have been glossed over. In order to give meaning to the yield claim, the method must be clearly declared.

What is the simple return?

The simple return is the profit (or loss) divided by the initial investment amount. It indicates in relation to the initial value, how much your investment has changed in absolute terms. The simple return is suitable for simple investments with only one deposit and withdrawal.

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

The money-weighted return (money-weighted return, MWR) captures the individual investment experience of an investor. The MWR takes into account when and how much money flows into an investment. If you have invested a large sum of money at a favourable time, this is taken into account more in the MWR than in the TWR.

Differences and similarities

The TWR, simple yield and MWR have differences that are reflected in their Strengths and weaknesses show:

  • TWR is suitable for the Investment comparisonHowever, it cannot fully reflect the individual investment experience of an investor.
  • The simple rate of return is easy to calculate, but it is less useful when there are multiple cash flows.
  • MWR on the other hand takes into account your timing decisionsbut can lead to distorted results depending on the situation.
 
In the context of TWR, the terms True Weighted Return or TTWR for True Time Weighted Return, as well as TWRR for Time Weighted Rate of Return, are often used.

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 time-weighted rate of return

In this article you have learned a lot about time-weighted returns and other ways of calculating the performance of your investment strategy. You now know, How to calculate the time-weighted rate of return and where it has its strengths and weaknesses.

However, as with everything in finance, there is no "one-size-fits-all" tool. The time-weighted return, simple return and money-weighted return all have their specific use cases and offer Different insights into the performance of your investments.

Do not blindly trust other people's calculations! Financial service providers are very familiar with different calculation methods and therefore know exactly which method can put their performance in a better light. Therefore, pay attention to the method used to calculate returns when someone advertises their returns.

Feel free to share your thoughts and questions in the comments section!

Leave a Reply

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

Get your free
Investment Guidebook
receive!