Please write a long formula in Excel that results in the given solution for the first period.

See the tab for historic returns and consider this strategy: during your 20-year career, you can invest $1,000 at the beginning of each year into one of these funds. Once you pick your fund, you have to stick with it for the entire 20 years. One fund has returns in line with the 3-month t-bill, one has returns in line with 10-year t-bonds, one tracks Baa corporate bond returns, one tracks real estate, and one is an S\&P500 tracking fund. Which fund would you pick if you started working in 1928 ? How would the optimal decision vary depending on what year you had started working? What does this say about the risk of stocks versus bonds in the long run? The chart should update to help your analysis. Note: Help yourself out by using excel references for this part as much as possible. If constructed correctly, you will only need one (long) formula for the ending value, and you can drag the formula to calculate all the other portfolio values. \begin{tabular}{|r|r|r|r|r|r|} \hline Year & S\&P 500 & 3-month Tbill & 10-year Tbond & Baa Bond & Real Estate \\ \hline 1928 & 43.81% & 3.08% & 0.84% & 3.22% & 1.49% \\ \hline 1929 & 8.30% & 3.16% & 4.20% & 3.02% & 2.06% \\ \hline 1930 & 25.12% & 4.55% & 4.54% & 0.54% & 4.30% \\ \hline 1931 & 43.84% & 2.31% & 2.56% & 15.68% & 8.15% \\ \hline 1932 & 8.64% & 1.07% & 8.79% & 23.59% & 10.47% \\ \hline 1933 & 49.98% & 0.96% & 1.86% & 12.97% & 3.81% \\ \hline 1934 & 1.19% & 0.28% & 7.96% & 18.82% & 2.91% \\ \hline 1935 & 46.74% & 0.17% & 4.47% & 13.31% & 9.77% \\ \hline 1936 & 31.94% & 0.17% & 5.02% & 11.38% & 3.22% \\ \hline 1937 & 35.34% & 0.28% & 1.38% & 4.42% & 2.56% \\ \hline 1938 & 29.28% & 0.07% & 4.21% & 9.24% & 0.87% \\ \hline 1939 & 1.10% & 0.05% & 4.41% & 7.98% & 1.30% \\ \hline 1940 & 10.67% & 0.04% & 5.40% & 8.65% & 3.31% \\ \hline 1941 & 12.77% & 0.13% & 2.02% & 5.01% & 8.38% \\ \hline 1942 & 19.17% & 0.34% & 2.29% & 5.18% & 3.33% \\ \hline 1943 & 25.06% & 0.38% & 2.49% & 8.04% & 11.45% \\ \hline 1944 & 19.03% & 0.38% & 2.58% & 6.57% & 16.58% \\ \hline 1945 & 35.82% & 0.38% & 3.80% & 6.80% & 11.78% \\ \hline 1946 & 8.43% & 0.38% & 3.13% & 2.51% & 24.10% \\ \hline 1947 & 5.20% & 0.60% & 0.92% & 0.26% & 21.26% \\ \hline 1948 & 5.70% & 1.05% & 1.95% & 3.44% & 2.06% \\ \hline 1949 & 18.30% & 1.12% & 4.66% & 5.38% & 0.09% \\ \hline 1950 & 30.81% & 1.20% & 0.43% & 4.24% & 3.64% \\ \hline \end{tabular} Here is the solution for the first period. It's up to you to build the formula and solve for the remaining periods. \begin{tabular}{|c|c|c|c|c|c|} \hline Work Period & S&P500 & 3-month Tbill & 10-year Tbond & Baa Bond & Real Estate \\ \hline 19281947 & $42,055.32 & $21,025.08 & 27,666.92 & $40,449.08 & $40,667.75 \\ \hline 19291948 & & & & & \\ \hline 19301949 & & & & & \\ \hline 19311950 & & & & & \\ \hline 19321951 & & & & & \\ \hline \end{tabular}