Excel Online Structured Activity: Expectations Theory spreadsheet and perform the required analysis to answer the question below. Open spreadsheet intermediate calculations. Round your answer to two decimal places. % \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline 1 & Expectations Theory & & & & & \\ \hline 2 & & & & & & \\ \hline 3 & 4-yr. Treasury security yield & 6.65% & & & & \\ \hline 4 & 6-yr. Treasury security yield & 7.35% & & & & \\ \hline 5 & & & & & & \\ \hline 6 & Algebraic solution: & & & Formulas & & \\ \hline 7 & Total return earned on 6-year securities & & & \#N/A & & \\ \hline 8 & Total return earned on 4-year securities & & & \#N/A & & \\ \hline 9 & Yield on 2-yr. securities, 4 years from now & & & #N/A & & \\ \hline 10 & & & & & & \\ \hline 11 & Geometric solution: & & & & & \\ \hline 12 & 1+ Total return earned on 6-year securities & & & #N/A & & \\ \hline 13 & 1+ Total return earned on 4-year securities & & & #N/A & & \\ \hline 14 & Yield on 2-yr. securities, 4 years from now & & & #N/A & & \\ \hline 15 & & & & & & \\ \hline \end{tabular}