A 3 year bond with semiannual coupons of 11% has a yield of 15.62%. You are to use Excel's "SumProduct" function to compute the duration of this bond. Given two ranges of values, "SumProduct" computes their dot product. Create a table as shown, with entries appropriate to your bond, replacing the question marks with appropriate formulas.

A B C D E 2 Face Coupon Yield 4 100 6 Time Cash Flow Present Value 7 Coupon 1 0.5 8 Coupon 2 1 9 Coupon 3 1.5 10 Coupon 4 2 11 Coupon 5 2.5 12 Coupon 6 3 13 Redemption 3 100 14