Find the yield to maturity on a semiannual coupon bond given that the bond price is $$1128,$ the coupon rate is $8\%,$ the face value is $$1000,$ and which matures in $13$ years. $($Do not use $\%$ sign with your answer$).$   

What is the duration of the bond in Problem $1,$ assuming a settlement date of$\mathrm{ 3}/1/2018$ and a maturity date of $4/15/2031?$ ANSWER WITH EXCEL