Please help with parts 1-7.

1. In cells F11-F20, calculate the payment for each period, and in F21, calculate the total payments. 2. In cells G11-G20, calculate the present value of the payment for each period, and in G21, calculate the total present value of payments (which is the current price). 3. In cells H11H20, 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%. 4. In cells K11K20, multiply the weights from step 3 by the year, and in K21, calculate the duration of the bond. 5. In cell K22, calculate the modified duration of the bond. 6. In cells M11-M20, calculate the year plus the year squared for each time period