0

I have a 401k through Fidelity and have recently started being more active in the market. I was haphazardly selecting funds that seemed to do well but apparently wasn't the most advantageous due to their expense ratios. So I decided to rebalance and from here do a lookback each year on performance.

To make sure I understand the RoR calculation, I looked at my statement from 31 Dec 2019 to 31 Dec 2020:

 - Beginning balance:          $27,222.92
 - Employee Contributions:    +$6,853.54
 - Employer Contributions:    +$3,909.74
 - Exchange In:                $34,661.77
 - Exchange Out:              -$34,661.77
 - Fees/Credits:              -$11.83
 - Change in Market Value:    +$8,334.29
 - Ending Balance:             $46,308.66
 - Vested Balance:             $46,308.66
 - Dividends/Interest:         $1,189.54

Below that is a block that says my Personal RoR was 22.7%, however I cannot come up with that RoR on my own.

As I understood it, to compute the RoR I would use the following formula:

(((End Balance - Total Contributions) / Start Balance) - 1) * 100
(((46,308.66 - 10,763.28) / 27,222.92) - 1) * 100 = 30.57%

What am I doing wrong in my calculation? According to Fidelity, its computed like this.

3

What am I doing wrong in my calculation?

You're not considering the timing of all of those activities. If your contributions all happened at the beginning of the year, then you'd need a lower return to get a change in market value of $8,334 than if they all happened at the end of the year.

Your calculation basically calculates the return of the initial balance, which is similar to saying that the contributions were all made at the end of the year. Since some of your contributions happened earlier, they contributed more to the net return, so your actual rate of return is lower.

I have no idea how your broker calculates it, but one way to calculate the performance of an underlying investment with varying cashflows is to use time-weighted return. Essentially you take the relative change (e.g. 1.02 for a 2% gain) of all periods in between cash flows, multiplying them to get the overall change (subtracting 1 to get return).

Another way is Money-weighted return, which is essentially just taking the IRR of all cashflows over the year.

Neither of those is an easy calculation to do by hand, but if you line up the inflows/outflows and beginning/end values for each period in excel then the calculations are much easier.

7
  • So when a Google search says "the average 401K RoR is 5-8%", which RoR is that and how is it computed? I'm trying to ensure my portfolio is performing well enough to match calculators. I start with $27,222.92 and set contributions to $10,000.00 with a 7% return over 30 years for a total of $1,151,835.67 – datta Feb 12 at 15:50
  • I have no idea, but they should be pretty close except when there are cashflows before or after large market movements (e.g. investing right before a large drop vs right after). Since there's no way to know all of the cashflows of an "average 401k" it may be an even simpler calculation. Also that "average" can be very different year to year, so I wouldn't necessarily say that your portfolio is 3-4X "better" - you'd have to look at other benchmarks like the S&P 500 (over the same time period) if you have a heavily equity-weighted portfolio (not many bond funds) – D Stanley Feb 12 at 15:56
  • 1
    In other words, that same portfolio might drop 10% next year just because the market dropped - so you "average" needs to consider a long time horizon. – D Stanley Feb 12 at 15:57
  • From what I can find, the articles all use the formula I've placed in my OP to compute the RoR. The calculator I linked also puts the same value (starting + market change) if using 30.6% for 1 year with my starting balance. Im aware it could shift due to market flux, I was just curious (under ideal conditions) if the market only ever went up at a rate of say 7%, how would that RoR be calculated. – datta Feb 12 at 16:31
  • When you're calculating "the market" then that simple formula is OK to use as a benchmark. Use that formula to see the performance of the S&P 500 index over the same time period and see how you compare. – D Stanley Feb 12 at 16:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.