SHOW EXCEL CALCULATIONS

1. CALCULATE TOTAL RETURN IF YOU INVEST 10,000

\begin{tabular}{|c|c|c|c|c|c|c|} \hline A & B & C & D & E & F & G \\ \hline SETTLEMENT DATE & MARKET PRICE & Years to Maturity & YTM & & & \\ \hline 10/11/2023 & 82.84 & 5.89 & 2.69% & & & \\ \hline 9/28/2023 & 82.29 & 5.92 & 2.74% & & & \\ \hline 6/28/2023 & 85.16 & 6.18 & 2.38% & & & \\ \hline 3/28/2023 & 86.00 & 6.43 & 2.25% & & & \\ \hline 12/28/2022 & 83.84 & 6.67 & 2.41% & & & \\ \hline 9/28/2022 & 81.42 & 6.92 & 2.58% & & & \\ \hline Face value & 1000 & & & & & \\ \hline coupon rate & 0.02 & & & I & & \\ \hline payments & 2 & & & & & \\ \hline maturity date & 9/1/2029 & & & & & \\ \hline Coupon & 2 & 2 & 2 & 2 & 2 & 2 \\ \hline redemption amount & 100 & 100 & 100 & 100 & 100 & 100 \\ \hline price & 82.84 & 82.29 & 85.16 & 86 & 83.84 & 81.42 \\ \hline years to maturity & 5.89 & 5.92 & 6.18 & 6.43 & 6.67 & 6.92 \\ \hline YTM & 2.69% & 2.74% & 2.38% & 2.25% & 2.41% & 2.58% \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline A & B & C & D & E & F & G \\ \hline SETTLEMENT DATE & MARKET PRICE & Years to Maturity & YTM & & & \\ \hline 10/11/2023 & 82.84 & 5.89 & 2.69% & & & \\ \hline 9/28/2023 & 82.29 & 5.92 & 2.74% & & & \\ \hline 6/28/2023 & 85.16 & 6.18 & 2.38% & & & \\ \hline 3/28/2023 & 86.00 & 6.43 & 2.25% & & & \\ \hline 12/28/2022 & 83.84 & 6.67 & 2.41% & & & \\ \hline 9/28/2022 & 81.42 & 6.92 & 2.58% & & & \\ \hline Face value & 1000 & & & & & \\ \hline coupon rate & 0.02 & & & I & & \\ \hline payments & 2 & & & & & \\ \hline maturity date & 9/1/2029 & & & & & \\ \hline Coupon & 2 & 2 & 2 & 2 & 2 & 2 \\ \hline redemption amount & 100 & 100 & 100 & 100 & 100 & 100 \\ \hline price & 82.84 & 82.29 & 85.16 & 86 & 83.84 & 81.42 \\ \hline years to maturity & 5.89 & 5.92 & 6.18 & 6.43 & 6.67 & 6.92 \\ \hline YTM & 2.69% & 2.74% & 2.38% & 2.25% & 2.41% & 2.58% \\ \hline \end{tabular}