Time-weighted return
From Chapter 3 of The Analyst's Handbook, by Matt Lang and Bree Lang
Imagine that a student fund is worth $10,000 at Tuesday's close, and that on Wednesday a generous alum wires in $2,000. By the end of Wednesday the account shows $12,120. If we divide the ending value by the starting value, we get $12,120 / $10,000 − 1 = 21.2%, which would be a remarkable day for a group of sophomores (and a suspicious one for anybody reading the report). Take a moment and ask yourself how much of that 21.2% came from the stocks the fund holds.
The account grew by $2,120 on the day, but $2,000 of that growth was the wire, which means that the holdings themselves added only $120. A return that treats the wire as a gain is grading the fund on its fundraising, and while raising money is a fine activity, it is not the one we are trying to measure. In order to grade the investing by itself, we need a return that deposits and withdrawals cannot move.
That measure is called the time-weighted return (TWR). The TWR counts money that arrived during the day as money the fund started the day with, so the arrival is never mistaken for a gain. In other words, the only thing that can change a TWR is what the holdings did. The daily version looks like this:
r = V(today) / (V(yesterday) + F) − 1
Here V is the value of the portfolio at the close, and F is any money that came in (positive) or went out (negative) during the day. For our fund, Wednesday's return is $12,120 / ($10,000 + $2,000) − 1 = 1.00%. This means that the stocks earned one percent on the day, and the remaining twenty points in our first calculation came from the wire.
For a period longer than a day, the daily returns are multiplied together and not added. A day of +10% followed by a day of −10% leaves a portfolio at 1.10 × 0.90 = 0.99 of where it began, which means that it is down 1% and not back to even. The second day's loss was taken on a larger base than the first day's gain, so it removed more dollars than the first day added.
The TWR does leave one question unanswered. A fund that received a large deposit right before a bad month lost more dollars than its TWR suggests, because the TWR ignores when the money showed up. The return that does count the timing is the money-weighted return (MWRR), and it will usually differ from the TWR for the same portfolio. Chapter 4 of the textbook covers the MWRR and when each one is the right number to quote.
Chapter 3 of The Analyst's Handbook works through a full ten-day example with a deposit in the middle, and the daily series is there to check by hand.
Read Chapter 3: Time-weighted return
Related topics: Time-weighted and money-weighted return · Maximum drawdown · All topics
The Analyst's Handbook is Sifter's free textbook for student investors, written by Matt Lang and Bree Lang. Sifter is free for students. This page as markdown.