Skip to content
Omnikalc

Time-weighted return calculator: remove the effect of deposits and withdrawals

Enter the starting value, the value before a cash flow, the cash flow, the ending value and the timing to get the time-weighted return, the annualized return and the money-weighted return.

Updated on
Your inputs
$

Value out of range

$

Value out of range

$

Value out of range

$

Value out of range

years

Value out of range

%

Value out of range

Results

Time-weighted return (total)

13.91%

Return before the cash flow
8.00%
Return after the cash flow
5.47%
Annualized time-weighted return
6.73%
Money-weighted return (Modified Dietz)
13.64%
Gap: time-weighted minus money-weighted (points)
0.27

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.

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.

Frequently asked questions

What is the time-weighted return?

The time-weighted return measures how well the investments performed, whatever the timing and the size of the deposits and the withdrawals. It splits the period at each cash flow, computes the return of each sub-period and multiplies them. It is the standard way to report the performance of a fund or a manager, since the manager does not control the cash flows.

How is it different from the money-weighted return?

The money-weighted return, or internal rate of return, gives more weight to the periods when you held more money. It measures your personal result, including the effect of your timing. If you add money before a rise, your money-weighted return is higher than the time-weighted return. If you add it before a fall, it is lower.

What is the Modified Dietz method?

The Modified Dietz method is a simple estimate of the money-weighted return. It divides the gain by the starting value plus each cash flow weighted by the time it stayed invested. It does not need an iterative calculation and it gives a close figure when the cash flows are small compared with the portfolio.

When should I use the time-weighted return?

Use it to compare a fund or a manager with an index, because it removes the effect of the cash flows. Use the money-weighted return to judge your own decisions on when to invest. If you made no deposits and no withdrawals, the two returns are the same.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.