9. A bond has just been issued. The bond has an annual coupon rate of 7% and coupons are paid semi-annually. The bond has a face value of $1,000 and will mature in 14 years. The bond's annual yield to maturity is 8%. a. Use Excel's Data Table feature to construct a TwoWay Data Table to demonstrate the impact of the coupon rate and the time to maturity on the bond's duration using: i. Coupon Rates of 0%,2%,4%,6%, and 8%. ii. Maturities of 3 years, 6 years, 9 years, 12 years, and 15 years. b. What four (4) duration principles or relationships are demonstrated in this table