The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Retirement Investing

URL:  http://boards.fool.com/madbrain-quotquicken-is-utterly-useless-at-28985347.aspx

Subject:  Re: Poll: Did your 401k recover from the 2008 de Date:  12/27/2010  5:53 PM
Author:  JAFO31 Number:  67961 of 75383

madbrain: "Quicken is utterly useless at keeping tracking of gains because of all sorts of problems with employer plan changes, improper characterization of contributions, etc. So I keep track of everything in an Openoffice spreadsheet.

Year 2008 was particularly brutal for me :

Beginning balance 218277.76

Contributions 15500
Employer match 6238.7
Earnings -93392.74

Ending balance 146623.72

Rate of return -40.76"


I am not following your math in terms of Rate of return.

Also, how are you accounting for ongoing contributions by you and timing of employer match?

-----------------------------------------------
"2009 was much better, but not a full recovery.
Beginning balance 146623.72

Contributions 12575.73
Employer match 4657.27

Earnings 54405.46

Ending balance 218262.18

Rate of return +35.05"


Ditto. Plus how are you separating out earnings on 2008 contributions and employer match?

-----------------------------------------------
"2010 is not as good as 2009, also. . . . I realize there is still a week to go in 2010 and things can change, but hopefully not too much.

Beginning balance 218262.18

Contributions 16500
After-tax contributions 17422.33
Employer match 6318.9

Earnings 37506.22

Ending balance 296009.63

Rate of return +16.33

To summarize
2008 : -93392.74
2009 : +54405.46
2010 : +37506.22

So I still have $1481.06 to recover, ie. I recovered 98.4% of the losses, not accounting for inflation."


How are you separating out earnings on 2008 & 2009 contributions and employer match?

If you are not, then I strongly suspect that you have overestimated your recovery. (:<)

Subsequent earnings on contributions and employer match need to be separated how to accurately calculate recovery.

Regards, JAFO
Copyright 1996-2014 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us