Question: A coupon bond has a life of 5 years, makes semiannual coupon payments at the rate of 6 percent per year, has a principal of $100, and a market price of $95.
a. Using Excel, compute this bond's yield to maturity.
b. Compute the duration of the bond.