1. 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%.
   1. 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:
      1. Coupon Rates of 0%, 4%, 8%, and 12%.
      2. Maturities of 4 years, 8 years, and 12 years.
   2. What four (4) duration principles or relationships are demonstrated in this table? PLEASE USE EXCEL AND SHOW FORMULAS