Assume today is the purchase date listed below, and you purchase the bond described below. The dates of the bond's remaining payments are in colun

the default day count

In cells F$15-$F$27,$ calculate the amount of the each of the bond's remaining payments.

In cells G$15-$G$27,$ calculate the present value of each payment by discounting each payment at the YTM for tyears. Sum these values in cell G$28.$

In cells H$15-$H$27,$ calculate the payment weights $($i$.$e$.,$ the percentage of the overall bond price that each bond payment contributes$).$ Sum these

values in cell $H28$ and confirm that your weights sum to $100\%.$

In cells I$15-127,$ multiply the time until each payment $($t$)$ by the weights from the previous step. In cell $128,$ sum these values to find the bond's

weighted average time to payment.

In cells J$15-$J$27,$ multiply the PV of each payment by $($t$^2+t).$ In cell J$28,$ sum these values.

In cells B$24-$B$25,$ report the bond's price and duration by referencing the appropriate cells from your completed cash flow table.

In cell B$26,$ calculate the bond's modified duration.

In cell B$27,$ calculate the bond's convexity. You can find the formula for convexity in footnote $2$ on page $345$ of the textbook.

To receive full credit, do not hard code any values anywhere in your sheet. Always use cell references when possible.