how do I calculate my 401K return?
October 10, 2006 11:20 AM Subscribe
I've been scratching my head this whole morning, trying to figure out how my 401K is doing, my own account per se. The personalized rate of return
on my statement takes into consideration other factors that don't really apply to me, and thus I think it's not a true indicator of my account performance.
I tried to find an MS Excel function to do this; so far, I have not had any luck. What I want to find out is the average return per week or per quarter given these known numbers on my statement:
1. a beginning balance in dollars (B)
2. an ending balance (E)
3. number of weeks contributed in this quarter (N)
4. weekly contribution amount (W)
5. total quarterly investment additions (W x N)
FYI, the contribution is made on a weekly basis for a same amount. It's 100% vested and is invested in one plan. What is the formula to calculate this weekly return? Thanks a lot.
posted by dy to Work & Money (4 answers total) 4 users marked this as a favorite