Nearly 1 million free-resource-downloads and-counting
How to Calculate Money-Weighted and Time-Weighted Rates of Return

How to Calculate Money-Weighted and Time-Weighted Rates of Return

Anyone sitting one of the CII investment exams will need to be familiar with measuring returns. In this article, we look at the money-weighted rate of return (MWR) and the time-weighted rate of return (TWR) – both of which are examined in R02 as well as in J10, J12, and AF4.

In particular, in AF4, students may need to actually do the calculations; whereas, in R02, it will be more about understanding the theory.

  • The time-weighted return shows the performance regardless of the timing of new monies.
  • The money-weighted return takes account of the timing of additions and withdrawals.

Let’s look at a typical exam question:

Calculate the money-weighted rate of return for the following investment:

Value at 1 January
Money invested 31 March
Income received 30 June
Value at 31 December
£100,000
£20,000
£2,000
£119,000

The MWR formula is:

(D+V1-V0-C) divided by (V0+(C x N/12))

Where:

  • D = income received during the year i.e. £2,000
  • V1= the value at the end of the period i.e. £119,000
  • V0= the value at the start of the period i.e. £100,000
  • C = the new money introduced during the year i.e. £20,000
  • n = the number of months remaining in the year i.e. 31 March until the 31 December

If we input the figures into the formula:

£2,000 + £119,000 – £100,000 – £20,000 /£100,000 + (£20,000 x 9/12)

Therefore:

£1,000 / £115,000 x 100 = MWR of 0.87 or 0.87%

The MWR is influenced by the timing of cash flows, which are, of course, outside the fund manager’s control.

Learn how to calculate money-weighted and time-weighted rates of return. Click To Tweet

 

The TWR aims to eliminate this problem by measuring compound growth irrespective of money flows.  To calculate TWR, we need to know when and how much new money is invested, when and how much of a withdrawal is made, and what the portfolio value was at the time.  Returns are then calculated for each period between these contributions or withdrawals, and then the periods are all multiplied together.

Let’s look at an example of this:

1 January
1 April
30 June
Value = £1,000
Value = £1,200
Value = £2,400
Further investment = £1,000

What is the TWR?

Period 1 = This is the first three months when the fund went from £1,000 to £1,200.

Period 2 = This is the next three months when £1,200 plus the additional investment of £1,000 grew to £2,400.

The return for each period is calculated by dividing the end value by the value at the beginning.

Period 1 = (£1,200)/£1,000 = 1.2

Period 2 = (£2,400 /£2,200 = 1.0909

So now we know that in the first 3 months, a gain of 20% was made, and in the second 3 months, a gain of 9.09% was made.  To find the TWR we need to multiply the two periods together:

(1.2) x (1.0909) – 1 x 100 = 30.91%

In conclusion, both the MWR and the TWR are useful when evaluating the performance of an investment portfolio over a given time period.  However, TWR focuses just on performance and is, therefore, more suitable when comparing different portfolio returns.

Grab the resources you need!

If you’re studying for your CII AF4 exam, and you’re wanting some extra practice, grab our free taster to try out one of Brand Financial Training’s resources for yourself.  Click the link to download the AF4 mock paper taster now!

Click here to download our free taster mock paper for CII AF4

Alternatively, you can download taster resources for J10 or R02 if one of those exams is of concern to you.

This article was originally published on Professional Paraplanner