Using the Excel template, set the term structure to be flat at 5%. On the "First scenario" tab, set the coupon to be 4% Calculate and fill in the values for cells \$B19:\$D19. The 0.1% up and down moves are shifts of the whole term structure. What's the duration for this bond in this market environment? \begin{tabular}{|l|l|l|l|l|l|l|} \hline 40 & & & & \multicolumn{2}{c|}{ Differences } \\ \hline 41 & \multicolumn{1}{|c|}{Y} & \multicolumn{1}{c|}{P/P} & \multicolumn{1}{c|}{D} & D+C & \multicolumn{1}{c|}{D} & \multicolumn{1}{c|}{D+C} \\ \hline 42 & 3.50% & 10.35% & 9.85% & 10.51% & 0.50% & 0.16% \\ \hline 43 & 2.92% & 8.52% & 8.21% & 8.66% & 0.32% & 0.14% \\ \hline 44 & 2.33% & 6.74% & 6.56% & 6.86% & 0.18% & 0.12% \\ \hline 45 & 1.75% & 5.00% & 4.92% & 5.09% & 0.07% & 0.09% \\ \hline 46 & 1.17% & 3.29% & 3.28% & 3.36% & 0.01% & 0.06% \\ \hline 47 & 0.58% & 1.63% & 1.64% & 1.66% & 0.01% & 0.03% \\ \hline 48 & 0.00% & 0.00% & 0.00% & 0.00% & 0.00% & 0.00% \\ \hline 49 & 0.58% & 1.59% & 1.64% & 1.62% & 0.05% & 0.03% \\ \hline 50 & 1.17% & 3.15% & 3.28% & 3.21% & 0.13% & 0.06% \\ \hline 51 & 1.75% & 4.68% & 4.92% & 4.76% & 0.25% & 0.08% \\ \hline 52 & 2.33% & 6.17% & 6.56% & 6.27% & 0.40% & 0.10% \\ \hline 53 & 2.92% & 7.63% & 8.21% & 7.75% & 0.58% & 0.12% \\ \hline 54 & 3.50% & 9.05% & 9.85% & 9.19% & 0.79% & 0.13% \\ \hline 55 & & & & & & \\ \hline 56 & & & & & & \\ \hline \end{tabular} 1 Term Structure Same setup as \#21. What is the convexity? Using the Excel template, set the term structure to be flat at 5%. On the "First scenario" tab, set the coupon to be 4% Calculate and fill in the values for cells \$B19:\$D19. The 0.1% up and down moves are shifts of the whole term structure. What's the duration for this bond in this market environment? \begin{tabular}{|l|l|l|l|l|l|l|} \hline 40 & & & & \multicolumn{2}{c|}{ Differences } \\ \hline 41 & \multicolumn{1}{|c|}{Y} & \multicolumn{1}{c|}{P/P} & \multicolumn{1}{c|}{D} & D+C & \multicolumn{1}{c|}{D} & \multicolumn{1}{c|}{D+C} \\ \hline 42 & 3.50% & 10.35% & 9.85% & 10.51% & 0.50% & 0.16% \\ \hline 43 & 2.92% & 8.52% & 8.21% & 8.66% & 0.32% & 0.14% \\ \hline 44 & 2.33% & 6.74% & 6.56% & 6.86% & 0.18% & 0.12% \\ \hline 45 & 1.75% & 5.00% & 4.92% & 5.09% & 0.07% & 0.09% \\ \hline 46 & 1.17% & 3.29% & 3.28% & 3.36% & 0.01% & 0.06% \\ \hline 47 & 0.58% & 1.63% & 1.64% & 1.66% & 0.01% & 0.03% \\ \hline 48 & 0.00% & 0.00% & 0.00% & 0.00% & 0.00% & 0.00% \\ \hline 49 & 0.58% & 1.59% & 1.64% & 1.62% & 0.05% & 0.03% \\ \hline 50 & 1.17% & 3.15% & 3.28% & 3.21% & 0.13% & 0.06% \\ \hline 51 & 1.75% & 4.68% & 4.92% & 4.76% & 0.25% & 0.08% \\ \hline 52 & 2.33% & 6.17% & 6.56% & 6.27% & 0.40% & 0.10% \\ \hline 53 & 2.92% & 7.63% & 8.21% & 7.75% & 0.58% & 0.12% \\ \hline 54 & 3.50% & 9.05% & 9.85% & 9.19% & 0.79% & 0.13% \\ \hline 55 & & & & & & \\ \hline 56 & & & & & & \\ \hline \end{tabular} 1 Term Structure Same setup as \#21. What is the convexity