How to Use the Time-Weighted Rate of Return (TWR) Formula (2024)

What is Time-Weighted Rate of Return– TWR?

The time-weighted rate of return (TWR) is a measure of the compound rate of growth in a portfolio. The TWR measure is often used to compare the returns of investment managers because it eliminates the distorting effects on growth rates created by inflows and outflows of money. The time-weighted return breaks up the return on an investment portfolio into separate intervals based on whether money was added or withdrawn from the fund.

The time-weighted return measure is also called the geometric mean return, which is a complicated way of stating that the returns for each sub-period are multiplied by each other.

Formula for TWR

Use this formula to determine the compounded rate of growth of your portfolio holdings.

TWR=[(1+HP1)×(1+HP2)××(1+HPn)]1where:TWR=Time-weightedreturnn=Numberofsub-periodsHP=EndValue(InitialValue+CashFlow)(InitialValue+CashFlow)HPn=Returnforsub-periodn\begin{aligned}&TWR = \left [(1 + HP_{1})\times(1 + HP_{2})\times\dots\times(1 + HP_{n}) \right ] - 1\\&\textbf{where:}\\&TWR = \text{ Time-weighted return}\\&n = \text{ Number of sub-periods}\\&HP =\ \dfrac{\text{End Value} - (\text{Initial Value} + \text{Cash Flow})}{(\text{Initial Value} + \text{Cash Flow})}\\&HP_{n} = \text{ Return for sub-period }n\end{aligned}TWR=[(1+HP1)×(1+HP2)××(1+HPn)]1where:TWR=Time-weightedreturnn=Numberofsub-periodsHP=(InitialValue+CashFlow)EndValue(InitialValue+CashFlow)HPn=Returnforsub-periodn

How to Use the Time-Weighted Rate of Return (TWR) Formula (1)

How to Calculate TWR

  1. Calculate the rate of return for each sub-period by subtracting the beginning balance of the period from the ending balance of the period and divide the result by the beginning balance of the period.
  2. Create a new sub-period for each period in which there is a change in cash flow, whether it's a withdrawal or deposit. You'll be left with multiple periods, each with a rate of return.
  3. Add 1 to each rate of return (this simplifies handling negative returns).
  4. Multiply each sub-period's rate of return together. This step is crucial to ensure the returns across different periods are compounded.
  5. Subtract 1 from the result to calculate the TWR.

What Does TWR Tell You?

It can be difficult to determine how much money was earned on a portfolio when there are multiple deposits and withdrawals made over time. Investors can't simply subtract the beginning balance, after the initial deposit, from the ending balance since the ending balance reflects both the rate of return on the investments and any deposits or withdrawals during the time invested in the fund. In other words, deposits and withdrawals distort the value of the return on the portfolio.

The time-weighted return breaks up the return on an investment portfolio into separate intervals based on whether money was added or withdrawn from the fund. The TWR provides the rate of return for each sub-period or interval that had cash flow changes. By isolating the returns that had cash flow changes, the result is more accurate than simply taking the beginning balance and ending balance of the time invested in a fund. The time-weighted return multiplies the returns for each sub-period or holding-period, which links them together showing how the returns are compounded over time.

When calculating the time-weighted rate of return, it is assumed that all cash distributions are reinvested in the portfolio. Daily portfolio valuations are needed whenever there is external cash flow, such as a deposit or a withdrawal, which would denote the start of a new sub-period. In addition,sub-periods must be the same to compare the returns of different portfolios or investments. These periods are then geometrically linked to determine the time-weighted rate of return.

Because investment managers that deal inpublicly traded securities do not typically have control over fund investors' cash flows, the time-weighted rate of return is a popular performance measure for these types of funds as opposed tothe internal rate of return (IRR), which is more sensitive to cash-flow movements.

Key Takeaways

  • The time-weighted return (TWR) multiplies the returns for each sub-period or holding-period, which links them together showing how the returns are compounded over time.
  • The time-weighted return (TWR) helps eliminate the distorting effects on growth rates created by inflows and outflows of money.

Examples of Using the TWR

As noted, the time-weighted return eliminates the effects of portfolio cash flows on returns. To see this how it works, consider the following two investor scenarios:

Scenario 1

Investor 1 invests $1 million into Mutual Fund A on December 31. On August 15 of the following year, their portfolio is valued at $1,162,484. At that point (August 15), they add $100,000 to Mutual Fund A, bringing the total value to $1,262,484.

By the end of the year, the portfolio has decreased in value to $1,192,328. The holding-period return for the first period, from December 31 to August 15, would be calculated as:

  • Return = ($1,162,484 - $1,000,000) / $1,000,000 = 16.25%

The holding-period return for the second period, from August 15 to December 31, would be calculated as:

  • Return = ($1,192,328 - ($1,162,484 + $100,000)) / ($1,162,484 + $100,000) = -5.56%

The second sub-period is created following the $100,000 deposit so that the rate of return is calculated reflecting that deposit with its new starting balance of $1,262,484 or ($1,162,484 + $100,000).

The time-weighted return for the two time periods is calculated by multiplying each subperiod's rate of return by each other. The first period is the period leading up to the deposit, and the second period is after the $100,000 deposit.

  • Time-weighted return = (1 + 16.25%) x (1 + (-5.56%)) - 1 = 9.79%

Scenario 2

Investor 2 invests $1 million into Mutual Fund A on December 31. On August 15 of the following year, their portfolio is valued at $1,162,484. At that point (August 15), they withdraw $100,000 from Mutual Fund A, bringing the total value down to $1,062,484.

By the end of the year, the portfolio has decreased in value to $1,003,440. The holding-period return for the first period, from December 31 to August 15, would be calculated as:

  • Return = ($1,162,484 - $1,000,000) / $1,000,000 = 16.25%

The holding-period return for the second period, from August 15 to December 31, would be calculated as:

  • Return = ($1,003,440 - ($1,162,484 - $100,000)) / ($1,162,484 - $100,000) = -5.56%

The time-weighted returnover the two time periods is calculated by multiplying or geometrically linking these two returns:

  • Time-weighted return = (1 + 16.25%) x (1 + (-5.56%)) - 1 = 9.79%

As expected, both investors received the same 9.79% time-weighted return, even though one added money and the other withdrew money. Eliminating the cash flow effects is precisely why time-weighted return is an important concept that allows investors to compare the investment returns of their portfolios and any financial product.

Difference Between TWR and ROR

A rate of return (ROR) is the net gain or loss on an investment over a specified time period, expressed as a percentage of the investment’s initial cost. Gains on investments are defined as income received plus anycapital gainsrealized on the sale of the investment.

However, the rate of return calculation does not account for the cash flow differences in the portfolio, whereas the TWR accounts for all deposits and withdrawals in determining the rate of return.

Limitations of the TWR

Due to changing cash flows in and out of funds on a daily basis, the TWR can be an extremely cumbersome way to calculate and keep track of the cash flows. It's best to use an online calculator or computational software. Another often-used rate of return calculation is the money-weighted rate of return.

How to Use the Time-Weighted Rate of Return (TWR) Formula (2024)
Top Articles
How Safe is Bank-Level Encryption?
Who Owns the Most Bitcoin in 2023? | River Learn - Bitcoin Basics
Coindraw App
Nwi Police Blotter
Think Of As Similar Crossword
Irving Hac
Mlifeinsider Okta
Kagtwt
414-290-5379
Otr Cross Reference
Why Is Stemtox So Expensive
Shariraye Update
Dusk
7 Fly Traps For Effective Pest Control
How Much Is Tay Ks Bail
3S Bivy Cover 2D Gen
Kp Nurse Scholars
Army Oubs
Ally Joann
FDA Approves Arcutis’ ZORYVE® (roflumilast) Topical Foam, 0.3% for the Treatment of Seborrheic Dermatitis in Individuals Aged 9 Years and Older - Arcutis Biotherapeutics
north jersey garage & moving sales - craigslist
Orange Pill 44 291
Universal Stone Llc - Slab Warehouse & Fabrication
LCS Saturday: Both Phillies and Astros one game from World Series
Weldmotor Vehicle.com
Deshuesadero El Pulpo
Sienna
Violent Night Showtimes Near Amc Dine-In Menlo Park 12
Narragansett Bay Cruising - A Complete Guide: Explore Newport, Providence & More
Duke University Transcript Request
Lesson 1.1 Practice B Geometry Answers
Till The End Of The Moon Ep 13 Eng Sub
Craig Woolard Net Worth
Miss America Voy Board
Baddies Only .Tv
Craigslist Central Il
Überblick zum Barotrauma - Überblick zum Barotrauma - MSD Manual Profi-Ausgabe
craigslist | michigan
877-292-0545
manhattan cars & trucks - by owner - craigslist
Vintage Stock Edmond Ok
Coffee County Tag Office Douglas Ga
Login
Ferhnvi
New Starfield Deep-Dive Reveals How Shattered Space DLC Will Finally Fix The Game's Biggest Combat Flaw
Here’s What Goes on at a Gentlemen’s Club – Crafternoon Cabaret Club
Tanger Outlets Sevierville Directory Map
Mike De Beer Twitter
8663831604
Bomgas Cams
Saw X (2023) | Film, Trailer, Kritik
Obituaries in Westchester, NY | The Journal News
Latest Posts
Article information

Author: Nathanael Baumbach

Last Updated:

Views: 5848

Rating: 4.4 / 5 (55 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Nathanael Baumbach

Birthday: 1998-12-02

Address: Apt. 829 751 Glover View, West Orlando, IN 22436

Phone: +901025288581

Job: Internal IT Coordinator

Hobby: Gunsmithing, Motor sports, Flying, Skiing, Hooping, Lego building, Ice skating

Introduction: My name is Nathanael Baumbach, I am a fantastic, nice, victorious, brave, healthy, cute, glorious person who loves writing and wants to share my knowledge and understanding with you.