How can there be a positive Dollar Gain (DG) and a negative Time Weighted Return (TWR)? Or vice versa? These “strange but true” returns occur more frequently than you might expect.
Dollar gain is straight addition, the actual number of dollars gained or lost over the time period.
If dollar gain is positive, then the ending value is greater than the beginning value. A negative dollar gain is the reverse.
Meanwhile, time weighted return is a percentage that measures the growth of the average dollar in a portfolio.
If time weighted return is positive, then your average dollar saw investment gain. A negative time weighted return is the reverse.
Thus, a positive dollar gain and a negative time weighted return means that although your investments lost money on average, your ending value was greater from a contribution. And a negative dollar gain and a positive time weighted return means that although your investments gained money on average, your ending value was lower from a withdrawal.
Consider this example: The portfolio starts with $100 and grows by $10. The client then withdraws $70. After the withdrawal, the portfolio loses $6.00.
Dollar Gain | Time Weighted Return |
$100 + $10 = $110 (+$10 gain) $110 – $70 = $40 (-$70 withdrawal) $40 – $6 = $34 (-$6 loss) which results in a +$4.00 DG (+10-6=4). |
$10 gain / $100 start value = +10% return $6 loss / $40 start value = -15% return which results in -6.5% TWR |
This results in a positive dollar gain of $4 and a negative time weighted return of -6.5%.
Now let’s reverse the gain & loss. The portfolio starts with $100 and loses $10. Then the client withdraws $70. After the withdrawal, the portfolio gains $6.00.
Dollar Gain | Time Weighted Return |
$100 – $10 = $90 (-$10 loss) $90 – $70 = $20 (-$70 withdrawal) $20 + $6 = $26 (+$6 gain) which results in a -$4.00 DG (-10+6 = -4) |
$10 loss / $100 start value = -10% return $6 gain /$20 start value = +30% return which results in a positive 17% TWR. |
This results in a negative dollar gain of -$4 and a positive time weighted return of 17%.
If we play the same game with the client adding money before/after a market gain/loss, we’ll see the same mixed combination of Dollar Gain and TWR.
When you see a strange combination Dollar Gain and TWR, look for money moving in or out of the portfolio, and then consider how well the portfolio did before and after the money moved.
This post first appeared on Krisan’s Backoffice, Inc and is reprinted here with permission.
Photo by Elizabeth Lies on Unsplash