In cells F$11-$F$20,$ calculate the payment for each period, and in F$21,$ calculate the total payments.

In cells G$11-$G$20,$ calculate the present value of the payment for each period, and in G$21,$ calculate the total present value of payments $($which is the current price$).$

In cells $H11-H20,$ calculate the $\%($or weight$)$ of the total bond price for each of the cash flow present values, and in $H21,$ check that the total weights equals $100\%.$

In cells K$11-$K$20,$ multiply the weights from step $3$ by the year, and in $K21,$ calculate the duration of the bond.

In cell K$22,$ calculate the modified duration of the bond.

In cells M$11-$M$20,$ calculate the year plus the year squared for each time period.