A bond has just been issued. The bond has an annual coupon rate of 4% and coupons are paid annually. The bond has a face value of $1,000 and will mature in 8 years. The bonds yield to maturity is 8%.

a.Use Excels 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 bonds duration using:

i. Coupon Rates of 0%, 4%, 8%, and 12%.

ii. Maturities of 4 years, 8 years, and 12 years.

b. What four (4) duration principles or relationships are demonstrated in this table?