Free calculators

Time-weighted return calculator

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.

Calculate

Results, updated as you type. The defaults reproduce the worked case.
ResultValue
Sub-periods4
Time-weighted return10.23%

Runs in your browser: nothing you type is sent anywhere.

Using this for a real deal?

The formula

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

How it works

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.

Embed this calculator

Free to embed on your website, blog or intranet, with no sign-up and no tracking. Copy the code below and paste it into any HTML block; the calculator resizes itself to fit.

Preview the embedded version

Questions people ask

How do you calculate time-weighted return?

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.

What is the difference between time-weighted and money-weighted return?

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.

Why do I need valuations on cash flow dates?

Because each sub-period starts and ends at a flow. Without a valuation on that day, the split is approximate.

The book behind this calculator

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 →

All free calculators → · Free Excel templates →