PrincessBunny
Junior Member
- Joined
- Jan 12, 2024
- Messages
- 27
- Reaction score
- 34
I beg to differ. Just giving some arbitrary prices (the same for both scenarios) for Stock ABC in the scenarios below.I think you must be feeling real old now!
For retail investors, there are two different scenarios:
1. Accumulation mode: Always adding money (or net addition), because haven't retired
XIRR (MWR) > TWR
Here, one can "cheat" for higher performance with XIRR by adding more borrowed money from outside and then cash out the same amount but leaving profits behind. So now the profits inflate the XIRR return ratio. TWR won't reflect this. Trading gurus who want to promote their track record do this to con their followers. They usually earn more from course fees, which get deposited into the portfolio.
2. Retirement mode: Always taking out money, because got no more high-paying job
TWR > XIRR (MWR)
Here, one "cheats" for higher performance by withdrawing money halfway to the make capital "smaller". The TWR calculates return with denominator that is smaller, so it always give higher number than XIRR return. Those participating in trading competitions with own accounts often do this withdrawal mid-way to boost ranking (The famous trader Mark Minervini did this in USIC).
If you haven't retired, then you'll be in the Mode 1. Mine is in Mode 2 (semi-retirement).
So my TWR is 40% YTD right now, but I have a withdrawal target rate of around 10% to 20% (varies, depends on whether I go for overseas holidays), so my net MWR returns is about 20% to 30% YTD.
So, it really depends on what you want to do with the return number. If you tell me yours is XIRR, that means you're still in Mode 1, which should match your younger age?
Scenario 1. Accumulation mode:
| Date | Qty | Price | Cashflow | Qty Total | NAV |
| 1/1/20 | 10,000 | $1.00 | $10,000.00 | 10,000 | $10,000.00 |
| 1/1/21 | 5,000 | $2.00 | $10,000.00 | 15,000 | $30,000.00 |
| 1/1/22 | 4,000 | $2.50 | $10,000.00 | 19,000 | $47,500.00 |
| 1/1/23 | 8,000 | $1.25 | $10,000.00 | 27,000 | $33,750.00 |
| 1/1/24 | 10,000 | $1.00 | $10,000.00 | 37,000 | $37,000.00 |
| 1/1/25 | -37,000 | $1.50 | -$55,500.00 | 0 | $0.00 |
TWRR: 50%; MWRR: 18.74%
Scenario 2. Retirement mode:
| Date | Qty | Price | Cashflow | Qty Total | NAV |
| 1/1/20 | 37,000 | $1.00 | $37,000.00 | 37,000 | $37,000.00 |
| 1/1/21 | -5,000 | $2.00 | -$10,000.00 | 32,000 | $64,000.00 |
| 1/1/22 | -4,000 | $2.50 | -$10,000.00 | 28,000 | $70,000.00 |
| 1/1/23 | -8,000 | $1.25 | -$10,000.00 | 20,000 | $25,000.00 |
| 1/1/24 | -10,000 | $1.00 | -$10,000.00 | 10,000 | $10,000.00 |
| 1/1/25 | -10,000 | $1.50 | -$15,000.00 | 0 | $0.00 |
TWRR: 146.67%; MWRR: 91.75%
TWRR is higher in both cases. I am not even speaking about cases of "cheating" the numbers. Just the raw calculations when comparing apple to apple, in most cases, will point to a higher TWRR.