Are social security monthly benefits really this low? Trying to calculate the monthly SS benefit of a hypothetical worker who earned $100k every year from 1983 to 2017.

Sharing is Caring!

by I_need_one_dollar

  • Found this link on the website:
  • There are step by step instructions on Page 2 ( I followed all of the steps. Created an Excel spreadsheet with the following columns: Year, Maximum Earnings, Actual Earnings, Index Factor, and Indexed Earnings.
  • I copied and pasted the Year, Maximum Earnings, and Index Factors from 1983-2017 from the website into my Excel spreadsheet.
  • I put 100,000 into the Actual Earnings column every year from 1983 to 2017 (35 years of earnings). For years where 100,000 was greater than the Social Security Maximum Earnings (1983-2007), I used Maximum Earnings as Actual Earnings. Screenshot of Excel spreadsheet here:
  • Calculated Monthly Benefit based on the rest of the steps from the pdf, screenshot here:
  • Got a total monthly benefit of $2,364.70. Is this accurate or did I do something wrong? Seems low for someone who earned $100k a year for 35 years.
READ  You Won’t BELIEVE How Chris Cuomo is Trying to Spin the Cyberattack Narrative on US Companies
READ  The FBI is using security camera footage from the Capitol to investigate and arrest people, but deploying a weasely loophole where it remains property of the Capitol Police so that the public can never FOIA it.

EDIT: Should be $2,879.95, instead of $2,364.70. Turns out I added up Actual Earnings instead of Indexed Earnings in my original calculations. Updated screenshot here:


Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.