• Rates of Return

How to Calculate your Money-Weighted Rate of Return (MWRR)

Starting in July 2016, dealers and portfolio advisors will be required to report investment performance to their clients.  The money-weighted rate of return (MWRR) was chosen by the Canadian Securities Administrators (CSA) as the industry standard for these performance calculations.  Although the MWRR is arguably more relevant to the individual investor (as it can reward or penalize investors for the timing of their cash flows), it is considered by most advisors to be inadequate for benchmarking purposes.  This is because the timing of the investor’s cash flows (which most advisors have little to no control over) can cause the performance to be over or understated, relative to the time-weighted rate of return (TWRR).

The money-weighted rate of return can be thought of as the rate of return, r, which equates the right hand side of the following equation to the ending portfolio value, V1.

MWRR-Equation

Source:  CFA Institute

 

This method can be useful for calculating the rate of return when there have been only small external cash flows during the measurement period, relative to the size of the portfolio.  It may also be the only available option for investors who do not have access to daily or month-end portfolio values (I often come across investors who receive quarterly statements, as opposed to monthly).

As the MWRR assumes all cash flows receive the same rate of return while invested, its return can differ substantially from the time-weighted rate of return (TWRR) when large cash flows occur during periods of significantly fluctuating portfolio values.  This makes the MWRR less ideal for benchmarking portfolio managers or strategies than the TWRR.  For example:

  • When a large contribution is made prior to a period of relatively good (bad) performance, the money-weighted rate of return (MWRR) will overstate (understate) a portfolio’s performance, relative to the time-weighted rate of return (TWRR).
  • When a large withdrawal is made prior to a period of relatively good (bad) performance, the money-weighted rate of return (MWRR) will understate (overstate) a portfolio’s performance, relative to the time-weighted rate of return (TWRR).

Without the help of computers, the calculation is just a series of trials and errors.  Using the above equation and the values from our original example, Investor 1 would begin by plugging in return “guesses” for r until the right-hand side of the equation equals the ending portfolio value, V1.  They would eventually stumble across 8.98% as the plug return that equates the right-hand side of the equation to 298,082 (or as close as possible).

Example:  Manual MWRR calculation for Investor 1

MWRR-Example

r “guess” Right-hand side of the equation:
10.00%

300,708

9.00%

298,140

8.99%

298,114

8.98%

298,088

8.97%

298,063

An easier way for investors to calculate their MWRR would be to download the Money-Weighted Rate of Return Calculator, available in the Calculators section of the Canadian Portfolio Manager Blog.  This calculator requires minimal inputs and is fairly intuitive to use.  It also annualizes (averages) returns over periods longer than a year.

After downloading the Excel spreadsheet, select the start and end dates for your measurement period, entering the total portfolio value to the right of each date.  Next, enter the dates and amounts of any portfolio contributions (+) or withdrawals (-) during the measurement period.  I’ve included examples for both investors below.

Money-Weighted Rate of Return (MWRR):  Investor 1

MWRR-1

 

Money-Weighted Rate of Return (MWRR):  Investor 2

MWRR-2

The MWRR results are noticeably different than the TWRR results from our first example.  Investor 1 contributed $25,000 to their portfolio before a period of underperformance (-5.56% versus +16.25%) and ended up with a significantly lower MWRR of 8.98%.  On the other hand, Investor 2 withdrew $25,000 from their portfolio before a period of underperformance, which resulted in a significantly higher MWRR of 10.64%.  This makes intuitive sense; Investor 1 made a bad timing decision by adding funds right before the markets went down, while  Investor 2 made a good timing decision by withdrawing funds right before the markets went down.

Performance Results

Methodology Investor 1 Investor 2
Time-Weighted Rate of Return (TWRR) 9.79% 9.79%
Money-Weighted Rate of Return (MWRR) 8.98% 10.64%

Each investor’s cash flow decision resulted in a higher or lower MWRR, relative to the TWRR.  Their investment strategy was exactly the same in each case (i.e. to track the MSCI Canada IMI Index).  By comparing their MWRR to an index return, both investors may incorrectly conclude that their portfolio manager has underperformed or outperformed the benchmark (which is why a money-weighted rate of return should not be used for benchmarking purposes).

Next up, we will examine the Modified Dietz Rate of Return.

By |2017-01-17T15:02:16+00:00June 4th, 2015|Categories: Rates of Return|17 Comments

17 Comments

  1. Tim October 4, 2018 at 4:51 pm - Reply

    Further to my comment, if the start value of the portfolio is 0, then you get ARR of 0.0% It seems to me that this should be accepted and then in the cash flow sections you build up the portfolio with contributions and withdrawals.
    But since the sheet is locked down, one cannot fix the issue.

    Can you please help out Justin?

    • Justin October 4, 2018 at 7:53 pm - Reply

      @Tim: Just enter your first contribution amount/date as the start value/date.

  2. Tim October 4, 2018 at 4:48 pm - Reply

    Sorry, but this calculator does not appear to work. I get 0.0% after entering information.

  3. Lawrence May 28, 2018 at 7:18 pm - Reply

    Is there any way to add additional lines to the calculator if I want to track over several years and have monthly contributions?

  4. Amanda Bishop March 18, 2018 at 4:00 pm - Reply

    I am getting a 0.00 value in the average rate of return.
    Are you able t o send me an updated copy of the spreadsheet?

    • Justin March 18, 2018 at 8:52 pm - Reply

      @Amanda Bishop: It should be working fine – please feel free to send your completed spreadsheet and I’ll take a quick look: jbender@pwlcapital.com

  5. Chuong January 5, 2018 at 2:42 am - Reply

    Hi,
    I tried to use XIRR function but I got a different result than your provided excel calculator. This is what I enter in column A for the date (using DATE function) and amount on column B:
    DATE(2017,4,12) 500
    DATE(2017,12,11) 17.7
    DATE(2017,12,18) 17.7
    DATE(2017,12,25) 17.7
    DATE(2018,1,1) 22.5
    DATE(2018,1,4) -592.22

    on column C1, I put this as formula: =XIRR(B4:B9,A4:A9) and I got 4.5 and your calculator return 3.3.
    Just wondering what did I do wrong here?
    Thanks

    • Justin January 5, 2018 at 3:37 am - Reply

      @Chuong: As your measurement period is less than 1 year, your manual calculation of 4.54% is annualizing the return (which is arguably not accurate). My calculator’s 3.30% is the “year-to-date” performance, so it is measuring only what has actually occurred.

  6. Jordi Chavanel October 19, 2017 at 8:33 am - Reply

    Hi Justin,
    I use your MWRR calculator very often.
    It would be possible learn that formulation to work in my private Excel document?
    I would like to use the MWRR formule in it.
    Thank you and congratulations. I think it is a good and easy to use tool.

  7. James September 15, 2017 at 10:11 pm - Reply

    I had the same error with trying to the MWRR. It wouldn’t be anything except 0.00%

    • Justin September 18, 2017 at 12:44 pm - Reply

      @James: Have you tried the calculator recently? (I had updated it over the past month as there was an error in one of the cells).

      If you’re still receiving a 0% output, please feel free to email your spreadsheet and I’ll take a look.

  8. Robert M August 16, 2017 at 4:56 pm - Reply

    I downloaded the spreadsheet, but the average rate of return cell appears to have no formula — in other words, the return always stays at 0.0%. What am I missing? Thanks!

    • Justin August 16, 2017 at 7:37 pm - Reply

      @Robert M: Very strange – I’ll update the spreadsheet and email you a copy. Please let me know if the updated version works.

  9. Janet August 3, 2017 at 3:46 am - Reply

    Question for this, let say there’s a dividend payout. How should we calculate ? thanks

    • Justin August 3, 2017 at 12:51 pm - Reply

      @Janet: There’s no need to include dividend payouts – these are included in the market value of the portfolio.

  10. Justin April 21, 2017 at 5:07 pm - Reply

    @Chis: Purchases and sales of securities do not need to be entered into the calculator.

Leave A Comment