using this data,create a long formula in excel with recurring investsments of $1000 each year for 20 years ,which gives you the value of the investment at the end of year 20 which is 1947.The answer is $42055.32

\begin{tabular}{|c|c|} \hline Year & S\&P 500 \\ \hline 1928 & 43.81% \\ \hline 1929 & 8.30% \\ \hline 1930 & 25.12% \\ \hline 1931 & 43.84% \\ \hline 1932 & 8.64% \\ \hline 1933 & 49.98% \\ \hline 1934 & 1.19% \\ \hline 1935 & 46.74% \\ \hline 1936 & 31.94% \\ \hline 1937 & 35.34% \\ \hline 1938 & 29.28% \\ \hline 1939 & 1.10% \\ \hline 1940 & 10.67% \\ \hline 1941 & 12.77% \\ \hline 1942 & 19.17% \\ \hline 1943 & 25.06% \\ \hline 1944 & 19.03% \\ \hline 1945 & 35.82% \\ \hline 1946 & 8.43% \\ \hline 1947 & 5.20% \\ \hline \end{tabular}