# Time-weighted and money-weighted return

*From Chapter 4 of The Analyst's Handbook, Sifter's free textbook for student investors · By Matt Lang and Bree Lang · https://sifter.finance/textbook/topics/time-weighted-and-money-weighted-return*

Suppose that an alum wired a student fund $50,000 in March, and that in November the alum calls to ask how the gift is doing. The fund's headline number is a time-weighted return (TWR), which was built to ignore the dates on which money arrives, so it cannot answer a question that is entirely about one of those dates. The return that can answer is called the money-weighted return (MWRR).

The MWRR weights every dollar by how long that dollar was in the portfolio. In other words, where the TWR takes deposits and withdrawals out of the calculation, the MWRR is built around them. This means that the same portfolio reports two returns, and both of them are correct, because they answer different questions. The TWR grades the investing, and the MWRR grades the experience of the dollars that paid for it.

The MWRR is unusual in that it has no formula we can solve directly. It is defined as the rate r that makes the following sum come out to zero:

```
Σ CF / (1 + r)^t = 0
```

Here each CF is a dated cash flow (money put in is negative, and money taken out is positive, with the ending value counted as taken out), and t is the time in years since the first flow. The rate has to be found by guessing, checking the sign of the sum and guessing again. This is the search that a spreadsheet's XIRR function runs for us.

Imagine a fund that began with $10,000 on January 2, received a $1,000 wire on January 12 and was worth $11,352.33 on January 16. A guess of 100% a year leaves the sum at about +73.5, and a guess of 200% leaves it at about −86.2, so the rate we want is somewhere between the two. The search settles at 140.84% a year, which works out to 3.4265% over the fourteen days. (An annualized rate from a two-week window assumes that every fortnight for the rest of the year goes just as well, so the 3.4265% is the figure to quote.)

The fund's TWR over the same days was 3.3373%. This means that the dollars did slightly better than the strategy that managed them, and the reason is the timing of the wire. It arrived just ahead of the fund's best stretch, so the new money was present for the good days and missed the earlier losses. Had the alum picked a worse week to be generous, the two numbers would be in the opposite order.

A fund whose MWRR trails its TWR is not necessarily picking bad stocks, because the shortfall can come entirely from money arriving at unlucky moments. The performance standard for investment managers (GIPS) asks for time-weighted returns in general for the same reason, which is that nobody should be graded on timing they did not choose. Chapter 4 of the textbook runs the full search by hand.

The full chapter: https://sifter.finance/textbook/ch04-mwrr.md
