Time-Weighted Return (TWR) and How to Calculate It
In this chapter
Intermediate
You add $2,000.00 to an account and its balance jumps by $2,000.00. What did your investments earn at that moment? Zero. Time-weighted return (TWR) keeps a deposit or withdrawal from showing up as investment performance. It measures the return of a dollar that stayed invested through the whole sequence.
The trick is to split the account’s history at each transfer. Measure the growth on each side of the transfer, then link the growth factors.
Which movements split the timeline?
An external cash flow crosses the boundary of the account you are measuring. Money you deposit is an inflow to the portfolio. Money you take out is an outflow. Selling shares and leaving the proceeds in the same portfolio is an internal trade. A dividend that stays as cash in the account is also internal. If you later take that cash out, record the withdrawal when it leaves. Define the portfolio first. A transfer between two sleeves is external to either sleeve on its own and internal to the combined account.
At a transfer, the value just before the flow closes one subperiod. The value just after it opens the next. Record both on the same valuation basis. If a $2,000.00 deposit is the only movement at that instant, add exactly $2,000.00 to the pre-flow value. For a withdrawal, subtract the amount removed. Keep any price change on the side of the flow when it occurred. The same deposit can fund cash flow rebalancing once the performance measurement treats it as an external flow.
Calculate each return and link the growth factors
\[ r_j=\frac{V_{j,\mathrm{end}}}{V_{j,\mathrm{start}}}-1 \]
Here \(r_j\) is the simple return in subperiod \(j\), \(V_{j,\mathrm{start}}\) is its positive opening value after any flow at that boundary, and \(V_{j,\mathrm{end}}\) is its closing value before any flow at that boundary. Use the measurement window’s opening and closing values at the outer boundaries, on the appropriate side of any transfer.
\[ R_{\mathrm{TWR}}=\prod_{j=1}^{n}(1+r_j)-1 \]
\(n\) is the number of subperiods and the product symbol means multiply all \(n\) growth factors. This is the same linking used for cumulative return. You could split one subperiod into smaller pieces even when there is no flow. The intermediate value would cancel when the adjacent value ratios are multiplied. A transfer changes the value at the boundary, so a fresh base matters.
Worked case 1. Value an account on both sides of a deposit
Start on 31 December with $10,000.00. The two subperiods end at the 30 June and 31 December closes. In this and the next case, values are hypothetical USD, income stays invested, and all gains and losses are before fees and taxes. The account holds a fully invested strategy. It immediately puts any deposit into the same strategy at the existing weights. It earns 8% before the deposit and loses 5% afterward.
| Date and timing | Portfolio value (USD) | What sets the value |
|---|---|---|
| Opening 31 December close | $10,000.00 | Opening balance |
| 30 June close, before deposit | $10,800.00 | Opening balance grows by 8% |
| 30 June close, after deposit | $12,800.00 | Investor adds $2,000.00 |
| Final 31 December close | $12,160.00 | Post-deposit balance falls by 5% |
Divide $10,800.00 by $10,000.00 for the first growth factor. Divide $12,160.00 by $12,800.00 for the second. The deposit itself sits between those fractions.
\[ R_{\mathrm{TWR}}=(1.08)(0.95)-1=2.60\% \]
The strategy earned 2.60% over the entire year. Adding 8% and −5% gives 3%. That misses the fact that the second return applies to wealth already changed by the first return. The account made $160.00 from investing, calculated by taking the closing balance and subtracting the opening balance and the deposit.
Worked case 2. Increase the deposit while the strategy follows the same path
Keep the starting value, timing and strategy returns. This time the investor deposits $12,000.00 at the June close. The $10,800.00 pre-flow value becomes $22,800.00. The 5% loss then costs $1,140.00, leaving $21,660.00. Subtract both the opening $10,000.00 and the deposit. The account has lost $340.00 from investing.
| June deposit (USD) | First subperiod return | Second subperiod return | Full-year TWR | Investment gain or loss (USD) |
|---|---|---|---|---|
| $2,000.00 | +8.00% | −5.00% | +2.60% | +$160.00 |
| $12,000.00 | +8.00% | −5.00% | +2.60% | −$340.00 |
The larger deposit puts an extra $10,000.00 through the 5% loss. That costs an additional $500.00. Both growth factors stay the same because the new cash follows the existing strategy. If it sits idle or forces a costly trade, the post-flow investment return itself can change. TWR removes the transfer from measured growth and still reflects what the portfolio earns once it holds the money.
Where the calculation needs a judgment
With a small flow you might see an estimated return computed from opening and closing balances plus dated transactions. To calculate exact TWR, you need valuations at the relevant flow boundaries. Closing values alone usually leave the gains on each side of an intraperiod deposit unknown. If a withdrawal empties the account, any subsequent interval with zero opening capital has no portfolio return to link. A fresh deposit starts a new funded interval.
For comparing strategies, use the same dates, currency, income treatment and clearly labelled fee bases. TWR can be reported after portfolio expenses if the values reflect those expenses. A money-weighted return answers the account holder’s separate question about the rate earned on their dated cash flows.
Practice questions
Choose one answer per question. Use the lesson’s conventions unless the question specifies a change. Round only the final result.
1. Close the first subperiod
An account rises from $6,000.00 to $6,300.00 by the June close. The investor immediately withdraws $1,300.00, leaving $5,000.00. It ends December at $5,500.00. What is the full-window TWR?
2. Locate the boundary
The account is worth $8,800.00 just before an end-of-day deposit of $700.00. Which value opens the next subperiod?
3. Identify an external flow
Which event creates an external flow for a portfolio made up of an equity sleeve and a bond sleeve in the same account?
4. Handle missing values
You have quarter-opening and quarter-closing values and the exact date and size of a mid-quarter deposit. What else do you need to determine exact TWR?
5. Read the dollar effect
Two identical accounts earn the same subperiod returns. Just before a 4% loss, one account receives an extra $5,000.00 and invests it at the same weights. How does that extra deposit change the result?
6. Deal with a zero capital base
An investor withdraws the entire balance on Friday and funds the account again on Tuesday. What return should be assigned to the unfunded interval?