About 2 years ago, I published an article here at TAH on the above subject. That article dealt with how we might have privatized Social Security in the early 1980s (the proposal was seriously discussed). It also included a downloadble Excel spreadsheet to calculate what benefits a hypothetical “Super IRA” based on individual contributions with mandatory employer matching in the same amounts as your Social Security taxes (the OASD part) would have provided. The assumption was that this “Super IRA” was invested in a hypothetical investment fund tracked the Dow Jones Industrial Average (DJIA), much like many mutual funds do today.
The subject came up again yesterday in the comments to this article. So I decided to update the previous spreadsheet with new data. It’s now current through July 2014. File format is Excel 97-2003.
Use it by filling in your own data, then using the links in the prior article on the subject to get an estimate of your possible future Social Security benefits. (If Congress doesn’t reduce or eliminate them before you become eligible for them, of course.) Embedded comments in the spreadsheet should answer most questions.
Be forewarned – if you choose to use the spreadsheet, there’s a good chance you’ll probably be rather . . . . disappointed. Or disgusted.






