Chain-link the return of each sub-period between external cash flows into a time-weighted return, the measure that judges a manager independently of when clients add or withdraw money. Free, in the browser, no sign-up.
The time-weighted return values the portfolio just before every external cash flow, computes the return of each sub-period, and chain-links them: multiply (1 + each sub-period return) together and subtract 1. With the defaults below, quarterly returns of 4.0, −2.0, 5.0 and 3.0 per cent give a time-weighted return of 10.23 per cent, whatever the size or timing of the flows between them.
| Result | Value |
|---|---|
| Sub-periods | 4 |
| Time-weighted return | 10.23% |
Runs in your browser: nothing you type is sent anywhere.
TWR = (1 + r1) × (1 + r2) × … × (1 + rn) − 1
Sub-period return = value before the next flow / value after the previous flow − 1. In Excel: =PRODUCT(1+B2:B5)-1
A manager does not decide when the client adds or withdraws money, so the return used to judge the manager must not depend on it. Every external flow breaks the period in two and each piece is measured separately. The price is data: the portfolio must be valued on the day of each flow; where it is not, Modified Dietz approximates inside each period.
The investor’s own experience is the money-weighted return, which does depend on the flows: 9.05 per cent on the same year in the worked example.
Go further with the worked example, step by step and the companion files for Asset Management.
Compute the return of each sub-period between external cash flows, add 1 to each, multiply them together and subtract 1. 1.04 × 0.98 × 1.05 × 1.03 − 1 = 10.23 per cent.
Time-weighted return removes the effect of the size and timing of cash flows and measures the manager. Money-weighted return, an IRR, includes them and measures the investor’s result.
Because each sub-period starts and ends at a flow. Without a valuation on that day, the split is approximate.
This calculator comes from Asset Management by Julian R. Sterling, which works the same case in full, with every figure in a free workbook.
Get the book on Amazon → DRM-free PDF edition, $19.99
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review.
Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →