$2.$ What is the value of a $30-$year semiannual coupon bond given that the coupon rate $=$

$11\%,$ the face value $=$ $$1000,$ the required return $=15\%,$ and there are $15$ years

remaining until maturity? $($Do not use the dollar sign in your answer$).$

What is the duration of the bond in Problem $2,$ assuming a settlement date of

$3/1/2018$ and a maturity date of $6/1/2033?$ ANSWER WITH EXCEL