scrabbler1
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
- Joined
- Nov 20, 2009
- Messages
- 6,699
It looks like we don't have a clear answer yet.
Multiple people who post here have built their own worksheets that match the SS retirement benefit calculation. The SSA has a nice example here
https://www.ssa.gov/oact/progdata/retirebenefit1.html
which is easy to translate into an Excel worksheet.
My experience with this was that I came within a couple dollars of the SS numbers. Maybe that's the best option for the original poster.
I am one of those who have developed a spreadsheet which mimics the SS benefit calculation. It took some time, but when I was eventually able to download the AnyPIA calculator from the SSA website and run it successfully, the result was less tan $1 different from my own spreadsheet. And that included two years of working before I turned 22. True, my earnings in those two summers while in college were very small. Just for kicks, when I zero out those two earnings years, my projected SS benefit dropped by $2 a month, or just over 0.1%.
Every so often, I go to the SS website to cut and paste any updated set of wage indexing factors I see out there. That moves my projected SS benefit very slightly, if at all. I have not worked since 2008 so my earnings history has been frozen for the last 8 years.