Calculate Time-Weighted Rate of Return

Explanation

The time-weighted rate of return is the preferred method of return calculation in the investment management industry, primarily because this method is not sensitive to significant additions and withdrawals of funds from portfolios under examination. The calculation of the time-weighted rate of return involves three steps, which are illustrated as follows:

Step 1:

Price the portfolio immediately prior to any significant additions or withdrawals. Separate the portfolio into a series of subperiods based on the dates of cash inflows and outflows.

Step 2:

Calculate the holding period return for each subperiod.

Step 3:

Determine the annualized holding period return by linking or compounding the holding period return of each subperiod. If the investment is for more than one year, use the geometric mean of the annual returns as the time-weighted rate of return. If the investment is for less than one year, compound the subperiod returns to obtain an annualized measurement.

To begin the process of determining the time-weighted rate of return, we would break the portfolio up into the following series of cash flows. However, in this example, the cash flows are already aggregated for us and we can move on to the next step: determining the holding period return for each subperiod. This process is detailed as follows:

Quarter 1 holding period return = [($100,000 ending value - $95,000 invested) / $95,000 invested] = 5.263%

Quarter 2 holding period return = [($110,000 ending value - $90,000 invested) / $90,000 invested] = 22.22%

Quarter 3 holding period return = [($114,000 ending value - $100,000 invested) / $100,000 invested] = 14.00%

Quarter 4 holding period return = [($105,000 ending value - $114,000 invested) / $114,000 invested] = (7.895%)

Now that the holding period return for each subperiod has been determined, we must annualize the return measure by taking the product of all four quarterly returns. This process is illustrated below:

[(1 + .0526) * (1 + .2222) * (1 + .14) * (1 - .07895) - 1] = .3508 or 35.08 %. This is characterized by none of the answers provided.

When calculating the time-weighted rate of return, remember that the total amount invested is the relevant figure, not the beginning portfolio value. Notice that during the third quarter, the total amount invested does not equal the ending amount for the second quarter. This differential could be explained by numerous phenomena. Perhaps the difference is due to a cash withdrawal from the account. Maybe it was used to pay expenses or meet an outstanding margin call. What is important to note is the fact that this money (the difference between the ending value of quarter 2 and the amount invested in quarter 3) was not invested, and should not be included in the holding period return for the third quarter. So said, whenever possible you should use the total amount invested rather than the beginning portfolio value in the calculation of the subperiod holding period return.