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 Two$-$Way 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?