Spreadsheet: 221493d1363589701-use-a-column-as-function-inputs-value-study
Sheet: Sheet1

Year | Real SP Price | Real Div | [NAME] (%) | Exp return | Real T-bill return | Real SP return, with div | T-bill decimal return | SP as decimal return | annual income |  | 1929 stocks | stock excess helper | 1929 bonds | 1929 cash | 1929 total | 1929 bond values | Ending total
1928 | 236.0257439306358 | 10.45756961271676 | 4.430690245293782 |  | 4.28 |  |  |  |  |  |  |  |  |  |  | 10000
1929 | 338.6324526315788 | 11.71455789473684 | 3.459372485921159 |  | 3.16 |  |  |  |  |  | 1000000 | 0 | 150000 | 47794 |  | 20000
1930 | 295.7244789473683 | 13.22382884210526 | 4.471672040534316 |  | 7.25 |  |  |  |  |  |  |  |  | 47794 |  | 30000 |  |  |  |  | 1000000 | 0 | 157536.6611556245 | 57917
1931 | 234.1009698113207 | 14.16179020754717 | 6.049436795994994 |  | 11.21 |  |  |  |  |  |  |  |  | 47794 |  | 40000 |  |  |  |  |  |  |  | 57917
1932 | 135.1965524475524 | 12.92185844055944 | 9.557831325301205 |  | 11.37 |  |  |  |  |  |  |  |  | 47794 |  | 50000 |  |  |  |  |  |  |  | 57917
1933 | 128.0206674418604 | 8.93797325581395 | 6.981664315937941 |  | 6.16 |  |  |  |  |  |  |  |  | 47794 |  | 60000 |  |  |  |  |  |  |  | 57917
1934 | 185.9902772727272 | 7.778416909090908 | 4.182163187855789 |  | -3.18 |  |  |  |  |  |  |  |  | 47794 |  | 70000 |  |  |  |  |  |  |  | 57917
1935 | 158.5972455882353 | 7.707209558823528 | 4.859611231101511 |  | -2.42 |  |  |  |  |  |  |  |  | 47794 |  | 80000 |  |  |  |  |  |  |  | 57917
1936 | 232.2538434782608 | 8.101878260869563 | 3.488372093023257 |  | -0.83 |  |  |  |  |  |  |  |  | 47794 |  | 90000 |  |  |  |  |  |  |  | 57917
1937 | 290.5830574468084 | 12.05944468085106 | 4.150085275724844 |  | -3.4 |  |  |  |  |  |  |  |  | 47794 |  | 100000 |  |  |  |  |  |  |  | 57917
1938 | 185.5230274647887 | 13.01339875753521 | 7.01443854995579 |  | 2.08 |  |  |  |  |  |  |  |  | 47794 |  | 110000 |  |  |  |  |  |  |  | 57917
1939 | 207.9723214285714 | 8.540724454071427 | 4.106664 |  | 1.34 |  |  |  |  |  |  |  |  | 47794 |  | 120000 |  |  |  |  |  |  |  | 57917
1940 | 206.1170287769784 | 10.44549153647482 | 5.067747967479674 |  | -0.67 |  |  |  |  |  |  |  |  | 47794 |  | 130000 |  |  |  |  |  |  |  | 57917
1941 | 174.2837553191489 | 11.12331789765957 | 6.382303317535544 |  | -5.02 |  |  |  |  |  |  |  |  | 47794 |  | 140000 |  |  |  |  |  |  |  | 57917
1942 | 132.4876414012739 | 10.43481862146497 | 7.876069428891378 |  | -10.56 |  |  |  |  |  |  |  |  | 47794 |  | 150000 |  |  |  |  |  |  |  | 57917
1943 | 139.0682609467455 | 8.131840828402364 | 5.847373637264617 |  | -5.62 |  |  |  |  |  |  |  |  | 47794 |  | 160000 |  |  |  |  |  |  |  | 57917
1944 | 158.6326810344827 | 8.210519675689655 | 5.175805907172997 |  | -1.22 |  |  |  |  |  |  |  |  | 47794 |  | 170000 |  |  |  |  |  |  |  | 57917
1945 | 176.5287758426966 | 8.41859058185393 | 4.768962194217939 |  | -1.92 |  |  |  |  |  |  |  |  | 47794 |  | 180000 |  |  |  |  |  |  |  | 57917
1946 | 230.6253065934065 | 8.532202068296701 | 3.699594894561598 |  | -8.12 |  |  |  |  |  |  |  |  | 47794 |  | 190000 |  |  |  |  |  |  |  | 57917
1947 | 164.783725116279 | 7.728183365441859 | 4.689894806048652 |  | -13.83 |  |  |  |  |  |  |  |  | 47794 |  | 200000 |  |  |  |  |  |  |  | 57917
1948 | 145.7526189873417 | 8.288468875822783 | 5.686668914362778 |  | -6.68 |  |  |  |  |  |  |  |  | 47794 |  | 210000 |  |  |  |  |  |  |  | 57917
1949 | 149.07456 | 9.187758235124997 | 6.163196614583333 |  | 2.1 |  |  |  |  |  |  |  |  | 47794 |  | 220000 |  |  |  |  |  |  |  | 57917
1950 | 167.3124051063829 | 11.39865319148936 | 6.812796208530806 |  | 0.07 |  |  |  |  |  |  |  |  | 47794 |  | 230000 |  |  |  |  |  |  |  | 57917
1951 | 194.5048854330708 | 13.63340773346456 | 7.009288071664309 |  | -6.42 |  |  |  |  |  |  |  |  | 47794 |  | 240000 |  |  |  |  |  |  |  | 57917
1952 | 212.6246230188679 | 12.42285070075471 | 5.8426209177346 |  | -0.63 |  |  |  |  |  |  |  |  | 47794 |  | 250000 |  |  |  |  |  |  |  | 57917
1953 | 229.2511736842104 | 12.34698834586466 | 5.385790679908327 |  | 1.09 |  |  |  |  |  |  |  |  | 47794 |  | 260000 |  |  |  |  |  |  |  | 57917
1954 | 220.4599382899628 | 12.61340841747212 | 5.721406127258444 |  | 0.66 |  |  |  |  |  |  |  |  | 47794 |  | 270000 |  |  |  |  |  |  |  | 57917
1955 | 310.5719999999999 | 13.49304481011236 | 4.344578651685393 |  | 1.96 |  |  |  |  |  |  |  |  | 47794 |  | 280000 |  |  |  |  |  |  |  | 57917
1956 | 383.7244533582088 | 14.51460559701492 | 3.782559456398641 |  | 1.06 |  |  |  |  |  |  |  |  | 47794 |  | 290000 |  |  |  |  |  |  |  | 57917
1957 | 383.4045097826086 | 14.65655095760869 | 3.822738278670482 |  | -0.07 |  |  |  |  |  |  |  |  | 47794 |  | 300000 |  |  |  |  |  |  |  | 57917
1958 | 334.8965202797202 | 14.52410047447552 | 4.336892023346304 |  | -0.92 |  |  |  |  |  |  |  |  | 47794 |  | 310000 |  |  |  |  |  |  |  | 57917
1959 | 446.7417579310343 | 14.10963401482758 | 3.15834232290543 |  | 2.18 |  |  |  |  |  |  |  |  | 47794 |  | 320000 |  |  |  |  |  |  |  | 57917
1960 | 461.3266167235494 | 14.83964424675768 | 3.216732724452869 |  | 1.55 |  |  |  |  |  |  |  |  | 47794 |  | 330000 |  |  |  |  |  |  |  | 57917
1961 | 466.7959691275166 | 15.21596967885906 | 3.259661754855995 |  | 1.17 |  |  |  |  |  |  |  |  | 47794 |  | 340000 |  |  |  |  |  |  |  | 57917
1962 | 536.2802009999998 | 15.735673881 | 2.93422614738671 |  | 1.58 |  |  |  |  |  |  |  |  | 47794 |  | 350000 |  |  |  |  |  |  |  | 57917
1963 | 498.4987085526315 | 16.37146073782894 | 3.284153089455887 |  | 1.91 |  |  |  |  |  |  |  |  | 47794 |  | 360000 |  |  |  |  |  |  |  | 57917
1964 | 576.2919757281553 | 17.31265522427184 | 3.004146500981033 |  | 2.21 |  |  |  |  |  |  |  |  |  |  | 370000 |  |  |  |  |  |  |  | 57917
1965 | 642.9437653846153 | 18.7886354625 | 2.922282861124013 |  | 2.3 |  |  |  |  |  |  |  |  |  |  | 380000
1966 | 683.55139245283 | 20.06998301886792 | 2.936133733390485 |  | 1.84 |  |  |  |  |  |  |  |  |  |  | 390000 |  |  |  |  |  |  |  |  |  | 1000000 | 0 | 54354.15765298383 | 42561
1967 | 597.8982993920971 | 20.39013738601824 | 3.410301953818828 |  | 1.53 |  |  |  |  |  |  |  |  |  |  | 400000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1968 | 649.1956645161289 | 20.01413401759531 | 3.082912457912458 |  | 0.96 |  |  |  |  |  |  |  |  |  |  | 410000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1969 | 667.380842696629 | 20.15228426966291 | 3.019607843137255 |  | 1.06 |  |  |  |  |  |  |  |  |  |  | 420000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1970 | 556.5031214285714 | 19.49289136428571 | 3.502746096777765 |  | 0.89 |  |  |  |  |  |  |  |  |  |  | 430000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1971 | 547.1490505025124 | 18.31828567839196 | 3.347951652583165 |  | 0.24 |  |  |  |  |  |  |  |  |  |  | 440000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1972 | 585.4395547445254 | 17.39883284671532 | 2.971926427879961 |  | 0.65 |  |  |  |  |  |  |  |  |  |  | 450000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1973 | 647.3895211267604 | 17.26009357816901 | 2.666106418918919 |  | 0.53 |  |  |  |  |  |  |  |  |  |  | 460000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1974 | 480.4035663090128 | 16.99481974248927 | 3.537613151597129 |  | -3.32 |  |  |  |  |  |  |  |  |  |  | 470000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1975 | 324.4016936660267 | 16.19920601861804 | 4.993563947078282 |  | -3.51 |  |  |  |  |  |  |  |  |  |  | 480000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1976 | 405.7824269784172 | 15.43083405701439 | 3.802735907495354 |  | -0.73 |  |  |  |  |  |  |  |  |  |  | 490000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1977 | 413.2996615384614 | 16.31167942615384 | 3.946695568400771 |  | -1.37 |  |  |  |  |  |  |  |  |  |  | 500000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1978 | 336.3494759999999 | 17.56593989712 | 5.222526315789474 |  | -0.67 |  |  |  |  |  |  |  |  |  |  | 510000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1979 | 340.049056954612 | 17.43840180922401 | 5.128201785177014 |  | -1.36 |  |  |  |  |  |  |  |  |  |  | 520000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1980 | 332.0286131105398 | 17.06549228791773 | 5.139765554553652 |  | -2.28 |  |  |  |  |  |  |  |  |  |  | 530000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1981 | 356.0868620689654 | 16.59953793103448 | 4.661654135338346 |  | 4 |  |  |  |  |  |  |  |  |  |  | 540000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1982 | 289.7409512195121 | 16.45076500530222 | 5.677749360613811 |  | 4.91 |  |  |  |  |  |  |  |  |  |  | 550000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1983 | 343.6774509202453 | 16.39393838006135 | 4.77015246015246 |  | 5.25 |  |  |  |  |  |  |  |  |  |  | 560000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1984 | 380.3668851815505 | 16.27531383709519 | 4.278846153846153 |  | 5.31 |  |  |  |  |  |  |  |  |  |  | 570000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1985 | 378.8684018957345 | 16.72083586322275 | 4.413362470862471 |  | 3.99 |  |  |  |  |  |  |  |  |  |  | 580000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1986 | 442.4800894160583 | 16.87460091240876 | 3.813640730067243 |  | 4.14 |  |  |  |  |  |  |  |  |  |  | 590000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1987 | 554.0442491007193 | 17.38588758992805 | 3.137996219281663 |  | 2.02 |  |  |  |  |  |  |  |  |  |  | 600000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1988 | 504.3104105445116 | 17.83038276949005 | 3.535596806387225 |  | 2.35 |  |  |  |  |  |  |  |  |  |  | 610000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1989 | 548.9507563996694 | 18.8753851657308 | 3.43844779257183 |  | 3.31 |  |  |  |  |  |  |  |  |  |  | 620000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1990 | 621.5767043171113 | 20.36757503924646 | 3.27675971409242 |  | 2.35 |  |  |  |  |  |  |  |  |  |  | 630000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1991 | 563.2693923476968 | 20.95097714933135 | 3.719530553934068 |  | 1.41 |  |  |  |  |  |  |  |  |  |  | 640000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1992 | 701.7892709630701 | 20.64482954380883 | 2.941741972697559 |  | 0.41 |  |  |  |  |  |  |  |  |  |  | 650000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1993 | 710.9234829593266 | 20.27642044670407 | 2.852124164235003 |  | -0.02 |  |  |  |  |  |  |  |  |  |  | 660000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1994 | 753.5778913132694 | 20.11171440287277 | 2.668830207826804 |  | 1.39 |  |  |  |  |  |  |  |  |  |  | 670000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1995 | 721.0260628742512 | 20.42584311377245 | 2.832885545405696 |  | 2.72 |  |  |  |  |  |  |  |  |  |  | 680000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1996 | 926.918628108808 | 20.95953675971502 | 2.261205689918948 |  | 2.12 |  |  |  |  |  |  |  |  |  |  | 690000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1997 | 1121.777865367693 | 21.89225151288498 | 1.951567434940357 |  | 2.75 |  |  |  |  |  |  |  |  |  |  | 700000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1998 | 1388.579711881188 | 22.41365068069307 | 1.614142169074904 |  | 3.13 |  |  |  |  |  |  |  |  |  |  | 710000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
1999 | 1770.387993487522 | 23.08496986745934 | 1.30394975295691 |  | 2.31 |  |  |  |  |  |  |  |  |  |  | 720000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
2000 | 1967.18751842417 | 22.86972265148103 | 1.162559361387215 |  | 2.36 |  |  |  |  |  |  |  |  |  |  | 730000 |  |  |  |  |  |  |  |  |  |  |  |  | 42561
2001 | 1776.738779383209 | 21.51034797258709 | 1.210664630174525 |  | 0.87 |  |  |  |  |  |  |  |  |  |  | 740000
2002 | 1499.649774647092 | 20.70187724449463 | 1.380447461432543 |  | 0.06 |  |  |  |  |  |  |  |  |  |  | 750000
2003 | 1148.415604623005 | 20.66491733626857 | 1.79942846936953 |  | -1.27 |  |  |  |  |  |  |  |  |  |  | 760000
2004 | 1424.38850475162 | 22.13580129589633 | 1.554056440504362 |  | -1.47 |  |  |  |  |  |  |  |  |  |  | 770000
2005 | 1443.023858888306 | 24.06240849501835 | 1.66749900542572 |  | -0.39 |  |  |  |  |  |  |  |  |  |  | 780000
2006 | 1502.033788048411 | 26.32344372163388 | 1.752520078515402 |  | 1.48 |  |  |  |  |  |  |  |  |  |  | 790000
2007 | 1638.843592601375 | 28.8606598292625 | 1.761038085608359 |  | 1.74 |  |  |  |  |  |  |  |  |  |  | 800000
2008 | 1521.476160886867 | 30.81001364411597 | 2.025007978183295 |  | -2.21 |  |  |  |  |  |  |  |  |  |  | 810000
2009 | 954.8916318324547 | 30.90010698910217 | 3.235980498625199 |  | 0.54 |  |  |  |  |  |  |  |  |  |  | 820000
2010 | 1207.799110329646 | 23.90702238712981 | 1.979387315544955 |  | -1.47 |  |  |  |  |  |  |  |  |  |  | 830000
2011 | 1356.622123847191 | 24.28470159792573 | 1.790085917886826 |  | -3.17 |  |  |  |  |  |  |  |  |  |  | 840000
2012 | 1336.52 | 27.48 | 2.06 |  |  |  |  |  |  |  |  |  |  |  |  | 850000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 860000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 870000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 880000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 890000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 900000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 910000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 920000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 930000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 940000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 950000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 960000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 980000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 990000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000