Finance education, free and open.An independent learning project
THEFINANCE ARCHIVES
Finance foundationsEquitiesFixed incomeDerivativesEconomicsFinancial statementsPortfolio management
Home / Portfolio management / Time-Weighted Return (TWR) and How to Calculate It
Portfolio management

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.

\[ 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 timingPortfolio value (USD)What sets the value
Opening 31 December close$10,000.00Opening balance
30 June close, before deposit$10,800.00Opening balance grows by 8%
30 June close, after deposit$12,800.00Investor adds $2,000.00
Final 31 December close$12,160.00Post-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 returnSecond subperiod returnFull-year TWRInvestment 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?

Question 1 choices

B is correct

  • A. This adds the 5% and 10% subperiod returns.
  • B. The growth factors are 1.05 and 1.10. Their product is 1.155.
  • C. This divides the final balance by the initial balance and treats the withdrawal as a loss.

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?

Question 2 choices

A is correct

  • A. The next subperiod starts with the pre-flow balance plus the deposit.
  • B. This is the closing value of the subperiod before the deposit.
  • C. Subtracting the flow would fit a $700.00 withdrawal.

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?

Question 3 choices

C is correct

  • A. The proceeds stay within the measured portfolio.
  • B. The coupon is income earned within the portfolio.
  • C. Money leaves the boundary of the measured portfolio.

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?

Question 4 choices

B is correct

  • A. Benchmark performance cannot supply the portfolio’s own value at the split.
  • B. With the deposit known, a reliable value on one side lets you derive the other side.
  • C. An average balance does not establish what the portfolio was worth at the transfer.

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?

Question 5 choices

C is correct

  • A. Both portfolios earn the same post-flow percentage return, so there is no TWR gap.
  • B. The $4,800.00 is the surviving deposit after the loss, which still includes the investor’s capital.
  • C. The additional capital loses \(0.04\times \$5,000.00=\$200.00\).

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?

Question 6 choices

A is correct

  • A. A simple portfolio return needs a positive base and the account was unfunded.
  • B. A zero change in zero capital still gives an undefined value ratio.
  • C. The owner withdrew the capital. That movement belongs to the external-flow record.

Find a finance concept

Press Enter to see all matching chapters.