Spreadsheet: 678134d1589728118-help-with-calculating-portfolio-returns-over-rolling-30-yr-periods-glide-path
Sheet: Sheet1

 |  | Inflation Rate | S&P 500 return | bond return | % in stock | portfolio return | annual real savings | account value
1 | 1928 | -0.0115 | 0.4549 | 0.0201 | 0.9 |  | 1000
2 | 1929 | 0 | -0.083 | 0.042 | 0.9
3 | 1930 | -0.0267 | -0.2307 | 0.0741 | 0.9
4 | 1931 | -0.0893 | -0.3833 | 0.07 | 0.9
5 | 1932 | -0.103 | 0.0185 | 0.2128 | 0.9
6 | 1933 | -0.0519 | 0.582 | 0.0743 | 0.9
7 | 1934 | 0.0348 | -0.0451 | 0.0433 | 0.9
8 | 1935 | 0.0255 | 0.4309 | 0.0187 | 0.9
9 | 1936 | 0.0103 | 0.306 | 0.0394 | 0.9
10 | 1937 | 0.0373 | -0.3766 | -0.0226 | 0.9
11 | 1938 | -0.0203 | 0.3196 | 0.0637 | 0.9
12 | 1939 | -0.013 | 0.0021 | 0.0579 | 0.9
13 | 1940 | 0.0072 | -0.1131 | 0.0465 | 0.9
14 | 1941 | 0.0512 | -0.1702 | -0.0679 | 0.9
15 | 1942 | 0.1092 | 0.0744 | -0.0778 | 0.9
16 | 1943 | 0.0597 | 0.1802 | -0.0328
17 | 1944 | 0.0164 | 0.1711 | 0.0093
18 | 1945 | 0.0227 | 0.328 | 0.015
19 | 1946 | 0.0848 | -0.1558 | -0.0493
20 | 1947 | 0.1439 | -0.0803 | -0.1178
21 | 1948 | 0.0769 | -0.0184 | -0.0533
22 | 1949 | -0.0097 | 0.1946 | 0.0569
23 | 1950 | 0.0109 | 0.294 | -0.0065
24 | 1951 | 0.0786 | 0.1467 | -0.0756
25 | 1952 | 0.0228 | 0.1552 | -0.0001
26 | 1953 | 0.0082 | -0.0201 | 0.033
27 | 1954 | 0.0031 | 0.5209 | 0.0297
28 | 1955 | -0.0028 | 0.3297 | -0.0106
29 | 1956 | 0.0153 | 0.0583 | -0.0372
30 | 1957 | 0.0334 | -0.1335 | 0.0334
31 | 1958 | 0.0273 | 0.399 | -0.047
32 | 1959 | 0.0101 | 0.1094 | -0.0362
33 | 1960 | 0.0146 | -0.0111 | 0.1004
34 | 1961 | 0.0107 | 0.253 | 0.0098
35 | 1962 | 0.012 | -0.0989 | 0.0444
36 | 1963 | 0.0124 | 0.2111 | 0.0044
37 | 1964 | 0.0128 | 0.1495 | 0.0242
38 | 1965 | 0.0159 | 0.1065 | -0.0085
39 | 1966 | 0.0302 | -0.1261 | -0.001
40 | 1967 | 0.0277 | 0.2046 | -0.0424
41 | 1968 | 0.0427 | 0.0628 | -0.0096
42 | 1969 | 0.0546 | -0.1299 | -0.0993
43 | 1970 | 0.0584 | -0.0215 | 0.1031
44 | 1971 | 0.0429 | 0.0952 | 0.0527
45 | 1972 | 0.0327 | 0.1499 | -0.0044
46 | 1973 | 0.0618 | -0.1929 | -0.0237
47 | 1974 | 0.1105 | -0.3328 | -0.0816
48 | 1975 | 0.0914 | 0.2552 | -0.0507
49 | 1976 | 0.0574 | 0.171 | 0.0968
50 | 1977 | 0.065 | -0.1266 | -0.0489
51 | 1978 | 0.0763 | -0.0104 | -0.0781
52 | 1979 | 0.1125 | 0.0653 | -0.0951
53 | 1980 | 0.1355 | 0.1602 | -0.1457
54 | 1981 | 0.1033 | -0.1363 | -0.0194
55 | 1982 | 0.0613 | 0.1346 | 0.2514
56 | 1983 | 0.0321 | 0.1853 | -0.0001
 | 1984 | 0.043 | 0.0177 | 0.0904
 | 1985 | 0.0355 | 0.2674 | 0.2141
 | 1986 | 0.019 | 0.1629 | 0.2197
 | 1987 | 0.0366 | 0.0207 | -0.0832
 | 1988 | 0.0408 | 0.1197 | 0.0398
 | 1989 | 0.0483 | 0.2542 | 0.1227
 | 1990 | 0.054 | -0.0803 | 0.0079
 | 1991 | 0.0423 | 0.2494 | 0.1033
 | 1992 | 0.0303 | 0.0433 | 0.0615
 | 1993 | 0.0295 | 0.0681 | 0.1094
 | 1994 | 0.0261 | -0.0125 | -0.1037
 | 1995 | 0.0281 | 0.3345 | 0.2011
 | 1996 | 0.0293 | 0.1919 | -0.0146
 | 1997 | 0.0234 | 0.3006 | 0.0743
 | 1998 | 0.0155 | 0.2638 | 0.1316
 | 1999 | 0.0219 | 0.183 | -0.1022
 | 2000 | 0.0338 | -0.12 | 0.1284
 | 2001 | 0.0283 | -0.1427 | 0.0267
 | 2002 | 0.0159 | -0.2318 | 0.1332
 | 2003 | 0.0227 | 0.2551 | -0.0185
 | 2004 | 0.0268 | 0.0786 | 0.0177
 | 2005 | 0.0339 | 0.0139 | -0.0051
 | 2006 | 0.0323 | 0.12 | -0.0123
 | 2007 | 0.0285 | 0.0256 | 0.0715
 | 2008 | 0.0384 | -0.389 | 0.1566
 | 2009 | -0.0036 | 0.2638 | -0.108
 | 2010 | 0.0164 | 0.1297 | 0.0671
 | 2011 | 0.0316 | -0.0103 | 0.1248
 | 2012 | 0.0207 | 0.1354 | 0.0088
 | 2013 | 0.0146 | 0.3024 | -0.1042
 | 2014 | 0.0162 | 0.1171 | 0.0898
 | 2015 | 0.0012 | 0.0126 | 0.0116
 | 2016 | 0.0126 | 0.1038 | -0.0056
 | 2017 | 0.0213 | 0.1907 | 0.0066
 | 2018 | 0.0244 | -0.0651 | -0.024
 | 2019 | 0.0229 | 0.2829 | 0.0718
 | [1]
 | [NAME]:
 | ST: Short term (Treasury bill)
 | LT: Long term (Treasury bond)
 | [2]
 | [NAME]:
 | The risk premium will be computed from this year to the current year.