ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAU
1
Age:657080100Av ROIRetirement ProjectionsRecalculate: Ctrl-RS&P 500S&P 500S&P 500S&P 500
2
Bal:4165437961,2359.6(all $ amounts in thousands and don't include inflation)S&P 500S&P 500S&P 500S&P 500Russll 2000Russll 2000Russll 2000Russll 2000
3
Av ROI:14.816.412.74.8Russll 2000Russll 2000Russll 2000Russll 2000Emrg MktsEmrg MktsEAFEEAFE
4
Emrg MktsEmrg MktsEmrg MktsEmrg MktsBRKBRKBRKBRKBRKBRK
5
9.6Scenario average ROIYearS&P 500S&P 500Bond IdxBond IdxBRKBRKBond IdxBond IdxBond IdxBond IdxS&P 500S&P 500
6
PortolioIncomeExpensesStock SalesROIw/o inflat(1:1:1:1)w/o inflat(1:1:1:1)w/o inflat(1:1:1:1:1)w/o inflat(1:1:1:1:1)w/o inflat(3:1)w/o inflat
7
ROIYearAgeValueGrowthTotalSoc Sec 1Pen- sion 1Soc Sec 2SS Sp Ben 2Pen- sion 2OtherSpecialTotalSOLInc TaxMtgeSpecHlthLTCVacCarAmt123456789101112131415161718
8
-12.1201863500-610000024100212024196730.926.9
9
25.72019644161076006001135841520754107196811.08.0
10
25.62020654161062000200097581152615771969-8.4-11.4
11
20.02021664458920002000125584152653510519703.90.9
12
20.02022674298620002000875801536567197114.611.6
13
18.02023684478020002000885801537568197218.915.9
14
25.62024694591185525820208958115375341973-14.8-17.8
15
20.02025705431096330102030100582153715371974-26.4-26.4
16
-1.7202671615-106330102030126582153853563197537.233.2
17
-0.9202772541-56330102030925821548529197623.620.6
18
-0.9202873507-563301020309258215485291977-7.4-10.4
19
12.120297447357633010203093582154953019786.43.4
20
25.7203075500129633010203010358215491540197918.215.2
21
13.0203176589776330102030128582154953565198032.328.3
22
18.0203277601108633010203095582155105321981-5.0-8.0
23
13.02033786778863301020309558215510532198221.418.4
24
13.02034797339563301020309558215510532198322.419.4
25
25.720358079620563301020308558215552219846.13.1
26
7.920368197977633010203012058215553557198531.627.6
27
7.12037821,00071643010204086582156523198618.615.6
28
13.02038831,04813664301020408658215652319875.12.1
29
-22.12039841,162-257643010204086582156523198816.613.6
30
1.920408588317643010204086582156522198931.727.7
31
-37.0204186877-3256430102040865821565221990-3.1-6.1
32
13.020428753069643010204087582157523199130.526.5
33
12.82043885767464301020401225821575355819927.64.6
34
12.12044895917264301020408258215718199310.17.128.425.429.526.525.622.619.016.013.210.2
35
7.9204590644516430102040825821571819941.3-1.7-2.7-5.71.5-1.50.6-2.45.32.310.87.8
36
20.020469167713564301020406758273199537.633.619.815.826.022.024.520.530.126.141.737.7
37
-14.9204792809-12164301020406858284199623.020.012.39.319.316.316.213.219.316.329.626.6
38
33.620489368423064301020406858284199733.429.413.49.419.615.617.613.622.918.933.929.9
39
33.620499491030664301020406858284199828.625.62.3-0.712.29.211.58.523.620.643.440.4
40
-14.92050951,212-18164301020406858284199921.018.027.024.027.324.321.718.717.414.45.62.6
41
13.02051961,027134643010204068582842000-9.1-12.1-7.8-10.8-9.1-12.1-4.9-7.9-5.0-8.02.6-0.4
42
7.12052971,15682643010204069582952001-11.9-14.9-0.8-3.8-4.5-7.5-1.9-4.9-9.3-12.3-7.6-10.6
43
-0.92053981,233-11643010204069582952002-22.1-22.1-9.6-9.6-9.6-9.6-5.7-5.7-12.1-12.12.02.0
44
1.92054991,2172364301020406958295200328.725.734.131.138.335.331.528.533.930.922.919.9
45
20551001,235064301020406958295200410.97.914.911.916.413.414.011.015.012.010.67.6
46
20054.91.911.68.612.69.610.67.67.44.46.03.0
47
200615.812.817.814.821.318.317.914.919.716.717.714.7
48
20075.52.512.79.713.710.712.39.36.53.59.66.6
49
2008-37.0-37.0-29.7-29.7-33.4-33.4-25.7-25.7-30.9-30.9-16.5-16.5
50
200926.523.533.130.136.633.630.527.524.821.821.518.5
51
201015.112.116.913.918.515.516.113.115.712.713.510.5
52
AgeAv ROI20112.1-0.9-3.1-6.1-3.9-6.9-1.6-4.6-2.4-5.44.01.0
53
Scen.657080100100201216.013.013.810.816.313.313.910.916.013.014.811.8
54
201332.428.4
55
1666-55-426-862-1.5201413.710.7
56
21,199622149-1520.3
57
31,096467454-670.5Ave:11.48.410.27.412.49.611.28.410.88.014.011.2
58
4913271-58-3281.7# Pos3573%1470%1575%1575%1575%1680%
59
5566234-276-1,1671.9# Neg1327%630%525%525%525%420%
60
61,196727640-542.0
61
759546-362-8792.0
62
8742399191-1612.3
63
989356577-2992.3
64
101,3311,3251,1667173.0
65
11925208-152-5523.1
66
121,0291,9068524223.3
67
131,239251-184-5803.4
68
141,035820199-2193.4
69
159891,5362,8588923.7
70
161,0277983331603.8
71
171,01879-421-1,2533.9
72
181,058840548274.0
73
191,02959494-7384.1
74
209981,3104893954.1
75
21714735211-6284.3
76
221,425407-97-1,2944.3
77
237175035121124.5
78
241,2941,0908144734.6
79
259841,7217849914.8
80
261,4991,1389901,3674.8
81
2737242-740-1,5934.8
82
281,1656541,1927625.2
83
291,0206543942105.2
84
30675512236-1755.4
85
311,0541,1221,5111,7875.4
86
326271,08845-7915.4
87
331,5522,6953,4552,4625.4
88
348437265347785.5
89
351,076442383366.1
90
367788452421496.1
91
371,1405417111,1036.1
92
387479828249896.1
93
391,1147595107556.3
94
40929590200-1,0946.4
95
419741,3164821,2786.5
96
421,2089811,5252,7566.5
97
431,1621,6745131,8376.5
98
447607251,1631,7386.6
99
451,3381,0326098886.7
100
46529189-26-9266.7