Public Social Security Calculation Early Retirement
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXY
1
Instructions
2
1. Enter number of years more that you will be working in B9. Work in year 2017 also counts as 1 year.
3
2. (Optional) Income in extra working years may be entered in B10. If blank, income in last year B14 is used.
4
3. Enter income earned per year in B14 to B74. This should match what is on your SS statement or website.
5
4. This calculation should be reasonably accurate for those with FRA of 67.
6
5. The results are given in F10 to F12. These are given in 2016 Dollars.
7
6. Do not change anything else. All calculations are done in Sheet2 (Unhide to See).
8
9
Years More to Work1MonthlyYearly
10
Income Years MoreSS at Age 67$1,242.18$14,906.11
11
SS at Age 62$919.21$11,030.52
12
SS at Age 70$1,540.30$18,483.58
13
YearIncome
14
2016$100,000.00
15
2015$100,000.00AIME$2,277.74
16
2014$100,000.00
17
2013$100,000.00
18
2012$100,000.00
19
2011$100,000.00
20
2010$35,000.00
21
2009$30,000.00
22
2008$30,000.00
23
2007$30,000.00
24
2006$15,000.00
25
2005$15,000.00
26
2004$15,000.00
27
2003$15,000.00
28
2002$0.00
29
2001$0.00
30
2000$0.00
31
1999$0.00
32
1998$0.00
33
1997$0.00
34
1996$0.00
35
1995$0.00
36
1994$0.00
37
1993$0.00
38
1992$0.00
39
1991$0.00
40
1990$0.00
41
1989$0.00
42
1988$0.00
43
1987$0.00
44
1986$0.00
45
1985$0.00
46
1984$0.00
47
1983$0.00
48
1982$0.00
49
1981$0.00
50
1980$0.00
51
1979$0.00
52
1978$0.00
53
1977$0.00
54
1976$0.00
55
1975$0.00
56
1974$0.00
57
1973$0.00
58
1972$0.00
59
1971$0.00
60
1970$0.00
61
1969$0.00
62
1968$0.00
63
1967$0.00
64
1966$0.00
65
1965$0.00
66
1964$0.00
67
1963$0.00
68
1962$0.00
69
1961$0.00
70
1960$0.00
71
1959$0.00
72
1958$0.00
73
1957$0.00
74
1956$0.00
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu