ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1
Assumptions
I am assuming that someone will be able to invest the money from social security, i.e. has other resources to live on from 62 to 70
2
Social Security payable at 66 per website
2000
I am assuming that this is an "upper middle class" person needing at least $100,000/year in income to live the lifestyle they want in retirement
3
payable at 62 per website15000.56%0.42%75%
2015 tax rates 10% until 18,450, 15% until $74,900, 25% until $151,200, 28% until 230,450
4
payable at 70 per website26400.67%132%
5
Assumed rate of return after taxes0.06
6
Inflation3%
7
Tax Rate pre 7025.00%85% taxable
8
Tax Rate post 7025.00%85% taxable
9
Age 62 income needs 100,000
10
Assets 2,000,000
11
SS payable at 66 with COLA 2,251
12
SS payable at 70 with COLA 3,344
13
14
Age at death??
15
16
AgeSSBTaxesInvestment
BOY balance
SS depW/DEarningsEOY balAgeSSBTaxes
Investment
BOY balance
SS depW/DEarningsEOY balAgeSSBTaxes
Investment
BOY balance
ContribW/DEarningsEOY bal
17
62 18,000 (3,825) 14,175 2,000,000 14,175 (100,000) 117,425 2,031,600 62 - - - 2,000,000 - (100,000) 117,000 2,017,000 62 - - 2,000,000 - (100,000) 117,000 2,017,000
18
63 18,540 (3,940) 14,600 2,031,600 14,600 (103,000) 119,244 2,062,445 63 - - - 2,017,000 - (103,000) 117,930 2,031,930 63 - - - 2,017,000 - (103,000) 117,930 2,031,930
19
64 19,096 (4,058) 15,038 2,062,445 15,038 (106,090) 121,015 2,092,408 64 - - - 2,031,930 - (106,090) 118,733 2,044,573 64 - - - 2,031,930 - (106,090) 118,733 2,044,573
20
65 19,669 (4,180) 15,489 2,092,408 15,489 (109,273) 122,731 2,121,356 65 - - - 2,044,573 - (109,273) 119,396 2,054,697 65 - - - 2,044,573 - (109,273) 119,396 2,054,697
21
66 20,259 (4,305) 15,954 2,121,356 15,954 (112,551) 124,383 2,149,142 66 27,012 (5,740) 21,272 2,054,697 21,272 (112,551) 120,543 2,083,961 66 - - - 2,054,697 - (112,551) 119,905 2,062,051
22
67 20,867 (4,434) 16,433 2,149,142 16,433 (115,927) 125,964 2,175,611 67 27,823 (5,912) 21,910 2,083,961 21,910 (115,927) 122,217 2,112,161 67 - - - 2,062,051 - (115,927) 120,245 2,066,369
23
68 21,493 (4,567) 16,926 2,175,611 16,926 (119,405) 127,462 2,200,594 68 28,657 (6,090) 22,568 2,112,161 22,568 (119,405) 123,825 2,139,148 68 - - - 2,066,369 - (119,405) 120,400 2,067,364
24
69 22,138 (4,704) 17,433 2,200,594 17,433 (122,987) 128,869 2,223,909 69 29,517 (6,272) 23,245 2,139,148 23,245 (122,987) 125,357 2,164,762 69 - - - 2,067,364 - (122,987) 120,352 2,064,728 62 v 7062 v 6666 v 70
25
70 22,802 (4,845) 17,956 2,223,909 17,956 (126,677) 130,173 2,245,361 70 30,402 (6,461) 23,942 2,164,762 23,942 (126,677) 126,804 2,188,831 70 40,131 (8,528) 31,603 2,064,728 31,603 (126,677) 121,031 2,090,686 154,675 56,531 98,144
26
71 23,486 (4,991) 18,495 2,245,361 18,495 (130,477) 131,362 2,264,742 71 31,315 (6,654) 24,660 2,188,831 24,660 (130,477) 128,155 2,211,169 71 41,335 (8,784) 32,551 2,090,686 32,551 (130,477) 122,503 2,115,264 149,478 53,573 95,905
27
72 24,190 (5,140) 19,050 2,264,742 19,050 (134,392) 132,424 2,281,824 72 32,254 (6,854) 25,400 2,211,169 25,400 (134,392) 129,400 2,231,578 72 42,575 (9,047) 33,528 2,115,264 33,528 (134,392) 123,890 2,138,290 143,534 50,246 93,288
28
73 24,916 (5,295) 19,622 2,281,824 19,622 (138,423) 133,345 2,296,368 73 33,222 (7,060) 26,162 2,231,578 26,162 (138,423) 130,527 2,249,843 73 43,853 (9,319) 34,534 2,138,290 34,534 (138,423) 125,181 2,159,581 136,786 46,525 90,262
29
74 25,664 (5,454) 20,210 2,296,368 20,210 (142,576) 134,111 2,308,113 74 34,218 (7,271) 26,947 2,249,843 26,947 (142,576) 131,522 2,265,736 74 45,168 (9,598) 35,570 2,159,581 35,570 (142,576) 126,365 2,178,940 129,173 42,377 86,796
30
75 26,434 (5,617) 20,816 2,308,113 20,816 (146,853) 134,706 2,316,782 75 35,245 (7,490) 27,755 2,265,736 27,755 (146,853) 132,371 2,279,009 75 46,523 (9,886) 36,637 2,178,940 36,637 (146,853) 127,430 2,196,153 120,628 37,773 82,855
31
76 27,227 (5,786) 21,441 2,316,782 21,441 (151,259) 135,112 2,322,076 76 36,302 (7,714) 28,588 2,279,009 28,588 (151,259) 133,060 2,289,398 76 47,919 (10,183) 37,736 2,196,153 37,736 (151,259) 128,364 2,210,994 111,082 32,678 78,404
32
77 28,043 (5,959) 22,084 2,322,076 22,084 (155,797) 135,313 2,323,677 77 37,391 (7,946) 29,446 2,289,398 29,446 (155,797) 133,573 2,296,620 77 49,356 (10,488) 38,868 2,210,994 38,868 (155,797) 129,152 2,223,217 100,459 27,056 73,403
33
78 28,885 (6,138) 22,747 2,323,677 22,747 (160,471) 135,289 2,321,241 78 38,513 (8,184) 30,329 2,296,620 30,329 (160,471) 133,893 2,300,372 78 50,837 (10,803) 40,034 2,223,217 40,034 (160,471) 129,780 2,232,561 88,681 20,870 67,811
34
79 29,751 (6,322) 23,429 2,321,241 23,429 (165,285) 135,019 2,314,405 79 39,668 (8,430) 31,239 2,300,372 31,239 (165,285) 134,001 2,300,327 79 52,362 (11,127) 41,235 2,232,561 41,235 (165,285) 130,232 2,238,743 75,661 14,078 61,583
35
80 30,644 (6,512) 24,132 2,314,405 24,132 (170,243) 134,481 2,302,774 80 40,858 (8,682) 32,176 2,300,327 32,176 (170,243) 133,878 2,296,137 80 53,933 (11,461) 42,472 2,238,743 42,472 (170,243) 130,491 2,241,464 61,311 6,637 54,673
36
81 31,563 (6,707) 24,856 2,302,774 24,856 (175,351) 133,652 2,285,931 81 42,084 (8,943) 33,141 2,296,137 33,141 (175,351) 133,502 2,287,429 81 55,551 (11,805) 43,746 2,241,464 43,746 (175,351) 130,540 2,240,399 45,532 (1,498) 47,030
37
82 32,510 (6,908) 25,602 2,285,931 25,602 (180,611) 132,506 2,263,427 82 43,347 (9,211) 34,136 2,287,429 34,136 (180,611) 132,851 2,273,805 82 57,218 (12,159) 45,059 2,240,399 45,059 (180,611) 130,357 2,235,204 28,223 (10,378) 38,601
38
83 33,485 (7,116) 26,370 2,263,427 26,370 (186,029) 131,016 2,234,783 83 44,647 (9,488) 35,160 2,273,805 35,160 (186,029) 131,902 2,254,838 83 58,934 (12,524) 46,411 2,235,204 46,411 (186,029) 129,924 2,225,509 9,274 (20,054) 29,328
39
84 34,490 (7,329) 27,161 2,234,783 27,161 (191,610) 129,154 2,199,487 84 45,986 (9,772) 36,214 2,254,838 36,214 (191,610) 130,628 2,230,070 84 60,702 (12,899) 47,803 2,225,509 47,803 (191,610) 129,216 2,210,918 (11,431) (30,583) 19,152
40
85 35,525 (7,549) 27,976 2,199,487 27,976 (197,359) 126,888 2,156,992 85 47,366 (10,065) 37,301 2,230,070 37,301 (197,359) 129,002 2,199,015 85 62,523 (13,286) 49,237 2,210,918 49,237 (197,359) 128,211 2,191,008 (34,016) (42,023) 8,006
41
86 36,590 (7,775) 28,815 2,156,992 28,815 (203,279) 124,186 2,106,713 86 48,787 (10,367) 38,420 2,199,015 38,420 (203,279) 126,995 2,161,150 86 64,399 (13,685) 50,714 2,191,008 50,714 (203,279) 126,884 2,165,326 (58,613) (54,437) (4,176)
42
87 37,688 (8,009) 29,679 2,106,713 29,679 (209,378) 121,012 2,048,026 87 50,251 (10,678) 39,572 2,161,150 39,572 (209,378) 124,575 2,115,919 87 66,331 (14,095) 52,236 2,165,326 52,236 (209,378) 125,205 2,133,389 (85,363) (67,893) (17,470)
43
88 38,819 (8,249) 30,570 2,048,026 30,570 (215,659) 117,329 1,980,266 88 51,758 (10,999) 40,760 2,115,919 40,760 (215,659) 121,708 2,062,728 88 68,321 (14,518) 53,803 2,133,389 53,803 (215,659) 123,148 2,094,681 (114,415) (82,462) (31,952)
44
89 39,983 (8,496) 31,487 1,980,266 31,487 (222,129) 113,097 1,902,720 89 53,311 (11,329) 41,982 2,062,728 41,982 (222,129) 118,359 2,000,941 89 70,370 (14,954) 55,417 2,094,681 55,417 (222,129) 120,679 2,048,648 (145,928) (98,221) (47,707)
45
90 41,183 (8,751) 32,431 1,902,720 32,431 (228,793) 108,272 1,814,631 90 54,910 (11,668) 43,242 2,000,941 43,242 (228,793) 114,490 1,929,880 90 72,482 (15,402) 57,079 2,048,648 57,079 (228,793) 117,767 1,994,702 (180,070) (115,249) (64,822)
46
91 42,418 (9,014) 33,404 1,814,631 33,404 (235,657) 102,810 1,715,189 91 56,558 (12,018) 44,539 1,929,880 44,539 (235,657) 110,059 1,848,822 91 74,656 (15,864) 58,792 1,994,702 58,792 (235,657) 114,376 1,932,213 (217,024) (133,632) (83,391)
47
92 43,691 (9,284) 34,406 1,715,189 34,406 (242,726) 96,662 1,603,531 92 58,254 (12,379) 45,875 1,848,822 45,875 (242,726) 105,024 1,756,994 92 76,896 (16,340) 60,555 1,932,213 60,555 (242,726) 110,468 1,860,510 (256,978) (153,463) (103,515)
48
93 45,001 (9,563) 35,439 1,603,531 35,439 (250,008) 89,775 1,478,737 93 60,002 (12,750) 47,252 1,756,994 47,252 (250,008) 99,337 1,653,575 93 79,203 (16,831) 62,372 1,860,510 62,372 (250,008) 106,002 1,778,875 (300,138) (174,838) (125,300)
49
94 46,351 (9,850) 36,502 1,478,737 36,502 (257,508) 82,094 1,339,824 94 61,802 (13,133) 48,669 1,653,575 48,669 (257,508) 92,949 1,537,685 94 81,579 (17,335) 64,243 1,778,875 64,243 (257,508) 100,935 1,686,545 (346,720) (197,861) (148,860)
50
95 47,742 (10,145) 37,597 1,339,824 37,597 (265,234) 73,560 1,185,748 95 63,656 (13,527) 50,129 1,537,685 50,129 (265,234) 85,808 1,408,389 95 84,026 (17,856) 66,170 1,686,545 66,170 (265,234) 95,221 1,582,702 (396,954) (222,641) (174,314)
51
52
 (396,954)
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
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