It’s that time of the year again — people are going to be receiving statements from their retirement plans (including the Thrift Savings Plan) showing how much money they have made (or lost) within the past year.
The confusing part is that, even if you had stayed within a particular fund for the entire year, the return shown on the statement will likely be different than the return of the fund. This happens because people add money to their retirement accounts throughout the year. Every time you add money, you buy a little bit more of the fund at the then current price. This is known as dollar cost averaging or DCA.
What’s more, even if two people were in the exact same fund for the whole year, the returns shown on their statements will likely be different from each other. This is because the return depends on several factors, such as:
- the amount of money in the account at the beginning of the year;
- the amount of regular contributions; and
- the timing of the regular contributions.
Since these three factors are likely to be different for different people, the returns they see on their statements will also be different. Because of this, the return is often called the personal rate of return (PRR) or the personal investment performance (PIP).
Below, I discuss two formulas for calculating this personal return. The first formula, which I call the personal rate of return, is relatively easy to use and to interpret, though it is an approximation. The second formula is the one used by the TSP and other retirement plans. The formula is commonly called the modified Dietz method, while the TSP simply calls it the personal investment performance. Though the formula is exact, I think it is more difficult to use and interpret.
Personal rate of return. The personal rate of return (PRR) is calculated as the weighted average of two other returns, the lump sum total return (LSTR) and the dollar cost averaging total return (DCATR). These are explained below.
Let
- MB be the money in the account at the beginning of the year; and
- let MC be the total amount of money contributed throughout the year (that is, it’s the amount contributed per pay period multiplied by the number of pay periods).
Then,
PRR = (MB x LSTR + MC x DCATR) / (MB + MC) – 1
For example, suppose that,
- at the beginning of the year, you had $50,000 in your retirement account;
- you contributed $500 per pay periods for 26 pay periods (1 pay period every two weeks);
- the lump sum total return (discussed below) was 1.2; and
- the dollar cost averaging total return (discussed below) was 1.1.
Then, the calculation is as follows:
- MB = $50,000
- MC = $500 x 26 = $13,000
- PRR = ($50,000 x 1.2 + $13,000 x 1.1) / ($50,000 + $13,000) – 1 = 17.94%
Now, let’s discuss LSTR and DCATR.
Lump sum total return. “Total return” means 1 plus the return. For example, a return of 20% corresponds to a total return of 1.20. “Lump sum” means the total return on the money that you had in your account at the beginning of the year. For a fund, LSTR is equal to the price on the last day of the year divided by the price on the last day of the previous year.
Dollar cost averaging total return. This is the total return on the money contributed throughout the year. The formula is similar to that for LSTR. It is the price on the last day of the year divided by the effective purchase price. The effective purchase price is the harmonic mean of all the fund prices throughout the year. For details, see a more thorough explanation with graphs and examples.
Personal investment performance. We now come to the formula used by the TSP, called either the modified Dietz method or the personal investment performance (PIP).
Let
- EMV be the market value of your account at the end of the year;
- BMV be the market value at the beginning of the year (this is the same as MB above);
- CF be the total cash flow or contribution into the account (this is the same as MC above);
- i be the index on specific contributions to the account;
- CFi be the amount of the i-th contribution (in other words, CF = sum CFi); and
- Wi be the number of calendar days from the i-th contribution until the end of the year divided by the number of calendar days in the year.
Then,
PIP = (EMV – BMV – CF) / (BMV + sum (Wi x CFi) )
… And that’s how the personal returns are calculated and why they are different for each person.