2024 Social Security Benefits Calculator (Excel based)

Description
*UPDATED FOR 2024*
Description for old tool (2021):
https://www.eloquens.com/tool/wV2dSndz/laurencelau/2021-social-security-benefits-calculator-excel-based


2024 Updates:
-Updated CPI and OASDI data


Objective / Features remain the same as before - This file allows you to:
1) Estimate monthly Social Security benefits at retirement.
2) Perform scenario analysis including (but not limited to):
-"What would my benefits be if I filed today?" At 67 (normal retirement age)? Earlier than 67? At 67 and 4 months?"
-"How would my benefits change if inflation was 3% per year? 5% per year? 3% per year and the average wage grew by 2% per year?"
-"How would my benefits change if I worked for 3 more years?"
-"How would my benefits change if I took a better paying job?"
-etc
Directions (as seen in the screenshots):
1) Go to the "Model" tab
2) Enter your information in Column M (orange cells only)
3) Enter your annual wage history in Column B (You can get this from www.ssa.gov)
4) Your estimated monthly benefits will be in the green cells.


FAQ:
Q) Why is this paid?
A) When I released this tool for free, the #1 piece of audience feedback was: "It's free. Therefore you have to be stealing my information!". I give the audience what they want. Congratulations, it's no longer free.


Q) Do I have to give the tool my social security number?
A) No


Q) Do I have to give the tool my name?
A) No