The time-weighted return (TWR) measures the performance of an investment while removing the effect of the deposits and withdrawals. The time-weighted return calculator gives the TWR, the sub-period returns, the annualized return, the money-weighted return by the Modified Dietz method and the gap between them.
How the calculation works
- Enter the starting value of the portfolio and its value just before a deposit or a withdrawal.
- Enter the cash flow: a positive number for a deposit, a negative number for a withdrawal. Then enter the ending value of the portfolio.
- Enter the total length of the period in years and the share of the period that had elapsed when the cash flow happened.
- The calculator links the two sub-period returns to give the time-weighted return, annualizes it and compares it with the money-weighted return estimated with the Modified Dietz method.
Example
A portfolio starts at $100,000 and grows to $108,000 before you add $20,000. The first sub-period returned 8.00 %. The portfolio then holds $128,000 and ends at $135,000, a return of 5.47 %. The time-weighted return is 1.08 × 1.0547 − 1 = 13.91 % over 2 years, or 6.73 % a year. The Modified Dietz return, which counts the money added half-way, is 15,000 / 110,000 = 13.64 %, so the gap is 0.27 point.
Why it matters
The calculator helps investors and students to separate the skill of a manager from the luck of the timing of cash flows, to compare a portfolio with an index and to see how much their own deposits helped or hurt their result. The gap between the two returns shows the effect of the timing.
Good to know
The exact TWR needs a valuation at each cash flow. With several flows, split the period into more sub-periods and multiply the returns. The calculator handles one flow, which is enough to see the effect. Fees and taxes change the result, so state if the return is gross or net. Past returns do not predict future returns.
Related tools
The holding period return calculator measures the total gain of one investment, the CAGR calculator turns a total return into an annual rate, the real return calculator removes inflation, and the portfolio risk calculator shows the volatility behind a return.