Time-Weighted Return Calculator

Calculate portfolio performance excluding the impact of cash flows using time-weighted methodology

About the Time-Weighted Return Calculator

The Time-Weighted Return (TWR) calculator is a specialized tool used by investors and portfolio managers to measure the compound rate of growth in a portfolio. Unlike simple return metrics, TWR eliminates the distorting effects on growth rates created by the inflow and outflow of money. This makes it the gold standard for comparing the performance of investment managers or individual strategies against market benchmarks, as it focuses strictly on the price appreciation and yield of the underlying assets rather than the timing of the investor's deposits or withdrawals.

Financial professionals use this method to isolate the 'investment decisions' from 'cash flow decisions.' For example, if an investor deposits a large sum of money right before a market surge, a simple return calculation might make the manager look more skilled than they actually are. By breaking the investment horizon into sub-periods based on the timing of each transaction, the TWR provides a clean, unbiased look at how the capital actually performed over time, regardless of when additional funds were added or removed from the account.

Formula

TWR = [(1 + R1) × (1 + R2) × ... × (1 + Rn)] - 1

In this formula, 'R' represents the sub-period return for each interval between cash flows. The sub-period return is calculated as (Ending Value - Net Cash Flow - Beginning Value) / Beginning Value. Once each sub-period return is determined, they are converted into growth factors by adding 1, multiplied together (geometric linking), and then 1 is subtracted from the final product to find the total percentage return. To annualize the result for periods longer than a year, the geometric mean is applied using the number of years.

Worked examples

Example 1: An investor starts with $10,000. After 6 months, the portfolio is worth $11,000. They deposit $5,000, bringing the total to $16,000. At the end of the year, the portfolio is worth $16,320.

Sub-period 1: ($11,000 / $10,000) - 1 = 0.10 (10%)\nSub-period 2: ($16,320 / $16,000) - 1 = 0.02 (2%)\nGeometric Link: (1 + 0.10) * (1 + 0.02) - 1 = 1.122 - 1 = 0.122

Result: 12.2% total return. This indicates the portfolio grew by 12.2% regardless of the $5,000 deposit mid-month.

Example 2: A portfolio begins at $50,000. It grows to $54,000, then the investor withdraws $20,000. The remaining $34,000 grows to $33,320.

Sub-period 1: ($54,000 / $50,000) - 1 = 0.08 (8%)\nSub-period 2: ($33,320 / $34,000) - 1 = -0.02 (-2%)\nGeometric Link: (1 + 0.08) * (1 - 0.02) - 1 = 1.0584 - 1 = 0.0584 (5.84%)

Result: 5.6% total return. Even though the balance dropped significantly due to the withdrawal, the underlying assets performed positively.

Common use cases

Comparing a private equity portfolio's performance against a public market index like the NASDAQ.
Evaluating the performance of a mutual fund manager who deals with daily investor subscriptions and redemptions.
Calculating the true annual growth of a personal brokerage account where monthly deposits are made.
Reporting investment performance to clients in compliance with GIPS (Global Investment Performance Standards).

Pitfalls and limitations

Failing to break the period at the exact date of a cash flow leads to significant inaccuracies.
TWR can be misleading for individual investors who have high control over cash flow timing and want to know their actual dollar-weighted gains.
Ignoring taxes or transaction fees within the sub-period valuations will result in an overstated performance figure.
Applying TWR to very short, volatile periods may not provide a meaningful representation of long-term strategy efficacy.

Frequently asked questions

Is time-weighted return better than money-weighted return?

The money-weighted return (MWR) is sensitive to when you deposit or withdraw cash, whereas the time-weighted return (TWR) removes these 'timing' effects. TWR is better for evaluating a fund manager's skill, while MWR is better for seeing your actual personal wealth growth.

Does time-weighted return include dividends?

No, TWR does not account for dividends unless you explicitly include them as part of the ending value of a specific period or treat them as a cash flow if they are withdrawn from the portfolio.

Why do investment managers use TWR instead of simple ROI?

TWR is the industry standard for investment performance because it prevents large deposits or withdrawals from distorting the percentage return, allowing for a fair comparison against benchmarks like the S&P 500.

How often should I calculate time-weighted return for my portfolio?

While you can estimate TWR monthly, the Global Investment Performance Standards (GIPS) generally recommend calculating it daily or whenever a significant external cash flow occurs to ensure the highest accuracy.

Can TWR be the same as simple return?

If you have zero cash flows during the entire period, the time-weighted return will be identical to the simple percentage return (Ending Value / Beginning Value - 1).